mantis 8200: move changes in PGSQL from last commit to a new transaction (13)

1 files changed, 15 insertions, 10 deletions

diff --git a/OpenSim/Data/PGSQL/Resources/EstateStore.migrations b/OpenSim/Data/PGSQL/Resources/EstateStore.migrations
index 4dbc59f..5b450aa 100644
--- a/OpenSim/Data/PGSQL/Resources/EstateStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/EstateStore.migrations
@@ -3,16 +3,6 @@
 BEGIN TRANSACTION;
 
 -- ----------------------------
--- SEQUENCE estate_settings_id
--- ----------------------------
-CREATE SEQUENCE IF NOT EXISTS "public"."estate_settings_id"
-  INCREMENT 100
-  MINVALUE 1
-  MAXVALUE 9223372036854775807
-  START 100
-  CACHE 1;
-
--- ----------------------------
 --  Table structure for estate_groups
 -- ----------------------------
 CREATE TABLE IF NOT EXISTS "public"."estate_groups" (
@@ -120,3 +110,18 @@ CREATE INDEX IF NOT EXISTS  "ix_estateban" ON "public"."estateban" USING btree("
 
 COMMIT;
 
+:VERSION 13
+
+ BEGIN TRASACTION;
+
+-- ----------------------------
+-- SEQUENCE estate_settings_id
+-- ----------------------------
+CREATE SEQUENCE IF NOT EXISTS "public"."estate_settings_id"
+  INCREMENT 100
+  MINVALUE 1
+  MAXVALUE 9223372036854775807
+  START 100
+  CACHE 1;
+
+COMMIT;