From f2b54c8cf93e20abad33043c3f1d7fc1407f3097 Mon Sep 17 00:00:00 2001 From: UbitUmarov Date: Sun, 12 Nov 2017 09:16:32 +0000 Subject: mantis 8200: move changes in PGSQL from last commit to a new transaction (13) --- .../Data/PGSQL/Resources/EstateStore.migrations | 25 +++++++++++++--------- 1 file changed, 15 insertions(+), 10 deletions(-) (limited to 'OpenSim') 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; -- cgit v1.1