From 6a75b7c65e0b7f756e180bb2c46f44b467be2a63 Mon Sep 17 00:00:00 2001 From: TomTheDragon Date: Sat, 11 Nov 2017 19:44:17 -0500 Subject: 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 --- OpenSim/Data/PGSQL/Resources/EstateStore.migrations | 10 ++++++++++ 1 file changed, 10 insertions(+) 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 @@ 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" ( -- cgit v1.1