diff options
| author | TomTheDragon | 2017-11-11 19:44:17 -0500 |
|---|---|---|
| committer | UbitUmarov | 2017-11-12 09:07:09 +0000 |
| commit | 6a75b7c65e0b7f756e180bb2c46f44b467be2a63 (patch) | |
| tree | b81a837ec5d944738998abfeb2626e69f0011d65 /OpenSim/Data | |
| parent | add a warning in opensim.ini.example mute lists, about the fact viewers cache... (diff) | |
| download | opensim-SC_OLD-6a75b7c65e0b7f756e180bb2c46f44b467be2a63.zip opensim-SC_OLD-6a75b7c65e0b7f756e180bb2c46f44b467be2a63.tar.gz opensim-SC_OLD-6a75b7c65e0b7f756e180bb2c46f44b467be2a63.tar.bz2 opensim-SC_OLD-6a75b7c65e0b7f756e180bb2c46f44b467be2a63.tar.xz | |
PGSQL EstateStore create estate_settings_id SEQUENCE
Missing creation for estate_settings_id sequence causes first run
to fail unless manually added.
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
Diffstat (limited to 'OpenSim/Data')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/EstateStore.migrations | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/EstateStore.migrations b/OpenSim/Data/PGSQL/Resources/EstateStore.migrations index 63b70bd..4dbc59f 100644 --- a/OpenSim/Data/PGSQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/EstateStore.migrations | |||
| @@ -3,6 +3,16 @@ | |||
| 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 | -- ---------------------------- | ||
| 6 | -- Table structure for estate_groups | 16 | -- Table structure for estate_groups |
| 7 | -- ---------------------------- | 17 | -- ---------------------------- |
| 8 | CREATE TABLE IF NOT EXISTS "public"."estate_groups" ( | 18 | CREATE TABLE IF NOT EXISTS "public"."estate_groups" ( |