diff options
author | UbitUmarov | 2017-11-12 09:16:32 +0000 |
---|---|---|
committer | UbitUmarov | 2017-11-12 09:16:32 +0000 |
commit | f2b54c8cf93e20abad33043c3f1d7fc1407f3097 (patch) | |
tree | 40410856a0cc289ca33bcb4e08ad3c5c8d8f5f38 /OpenSim/Data/PGSQL/Resources/EstateStore.migrations | |
parent | PGSQL EstateStore create estate_settings_id SEQUENCE (diff) | |
download | opensim-SC_OLD-f2b54c8cf93e20abad33043c3f1d7fc1407f3097.zip opensim-SC_OLD-f2b54c8cf93e20abad33043c3f1d7fc1407f3097.tar.gz opensim-SC_OLD-f2b54c8cf93e20abad33043c3f1d7fc1407f3097.tar.bz2 opensim-SC_OLD-f2b54c8cf93e20abad33043c3f1d7fc1407f3097.tar.xz |
mantis 8200: move changes in PGSQL from last commit to a new transaction (13)
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/EstateStore.migrations | 25 |
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 @@ | |||
3 | BEGIN TRANSACTION; | 3 | BEGIN TRANSACTION; |
4 | 4 | ||
5 | -- ---------------------------- | 5 | -- ---------------------------- |
6 | -- SEQUENCE estate_settings_id | ||
7 | -- ---------------------------- | ||
8 | CREATE SEQUENCE IF NOT EXISTS "public"."estate_settings_id" | ||
9 | INCREMENT 100 | ||
10 | MINVALUE 1 | ||
11 | MAXVALUE 9223372036854775807 | ||
12 | START 100 | ||
13 | CACHE 1; | ||
14 | |||
15 | -- ---------------------------- | ||
16 | -- Table structure for estate_groups | 6 | -- Table structure for estate_groups |
17 | -- ---------------------------- | 7 | -- ---------------------------- |
18 | CREATE TABLE IF NOT EXISTS "public"."estate_groups" ( | 8 | CREATE TABLE IF NOT EXISTS "public"."estate_groups" ( |
@@ -120,3 +110,18 @@ CREATE INDEX IF NOT EXISTS "ix_estateban" ON "public"."estateban" USING btree(" | |||
120 | 110 | ||
121 | COMMIT; | 111 | COMMIT; |
122 | 112 | ||
113 | :VERSION 13 | ||
114 | |||
115 | BEGIN TRASACTION; | ||
116 | |||
117 | -- ---------------------------- | ||
118 | -- SEQUENCE estate_settings_id | ||
119 | -- ---------------------------- | ||
120 | CREATE SEQUENCE IF NOT EXISTS "public"."estate_settings_id" | ||
121 | INCREMENT 100 | ||
122 | MINVALUE 1 | ||
123 | MAXVALUE 9223372036854775807 | ||
124 | START 100 | ||
125 | CACHE 1; | ||
126 | |||
127 | COMMIT; | ||