From: Thierry Parmentelat <thierry.parmentelat@sophia.inria.fr>
Date: Wed, 18 Mar 2009 12:22:28 +0000 (+0000)
Subject: new run-levels table was created too late (is referenced in nodes)
X-Git-Tag: PLCAPI-4.3-4~6
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=3dd3be5a57f4927b987cecb2327dd2d7a70bb6be

new run-levels table was created too late (is referenced in nodes)
applying Baris's patch (no svn access yet) -- Thank you Baris
---

diff --git a/migrations/v42-to-v43/migrate.sql b/migrations/v42-to-v43/migrate.sql
index a7f71fd..7eeb01e 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