From 3dd3be5a57f4927b987cecb2327dd2d7a70bb6be Mon Sep 17 00:00:00 2001 From: Thierry Parmentelat Date: Wed, 18 Mar 2009 12:22:28 +0000 Subject: [PATCH] new run-levels table was created too late (is referenced in nodes) applying Baris's patch (no svn access yet) -- Thank you Baris --- migrations/v42-to-v43/migrate.sql | 22 ++++++++++++---------- 1 file changed, 12 insertions(+), 10 deletions(-) diff --git a/migrations/v42-to-v43/migrate.sql b/migrations/v42-to-v43/migrate.sql index a7f71fd0..7eeb01e9 100644 --- a/migrations/v42-to-v43/migrate.sql +++ b/migrations/v42-to-v43/migrate.sql @@ -107,6 +107,18 @@ drop function mgn_drop_all_views (); ALTER TABLE peers ADD COLUMN shortname TEXT; ALTER TABLE peers ADD COLUMN hrn_root TEXT; + +---------------------------------------- +-- run levels +---------------------------------------- +CREATE TABLE run_levels ( + run_level text PRIMARY KEY +) WITH OIDS; +INSERT INTO run_levels (run_level) VALUES ('boot'); +INSERT INTO run_levels (run_level) VALUES ('safeboot'); +INSERT INTO run_levels (run_level) VALUES ('failboot'); +INSERT INTO run_levels (run_level) VALUES ('reinstall'); + ---------------------------------------- -- nodes ---------------------------------------- @@ -240,16 +252,6 @@ drop view mgn_nodegroups; drop table mgn_site_nodegroup; drop table nodegroup_node; ----------------------------------------- --- run levels ----------------------------------------- -CREATE TABLE run_levels ( - run_level text PRIMARY KEY -) WITH OIDS; -INSERT INTO run_levels (run_level) VALUES ('boot'); -INSERT INTO run_levels (run_level) VALUES ('safeboot'); -INSERT INTO run_levels (run_level) VALUES ('failboot'); -INSERT INTO run_levels (run_level) VALUES ('reinstall'); ---------------------------------------- -- boot states -- 2.47.0