PGSQL: Add missing AgentPrefs.migrations

Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>

1 files changed, 19 insertions, 0 deletions

diff --git a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
new file mode 100644
index 0000000..ca3cca2
--- /dev/null
+++ b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
@@ -0,0 +1,19 @@
+:VERSION 1
+
+BEGIN TRANSACTION;
+
+CREATE TABLE IF NOT EXISTS "public"."agentprefs" (
+        "PrincipalID" uuid NOT NULL,
+        "AccessPrefs" char(2) NOT NULL DEFAULT 'M'::bpchar COLLATE "default",
+        "HoverHeight" float8 NOT NULL DEFAULT 0,
+        "Language" char(5) NOT NULL DEFAULT 'en-us'::bpchar COLLATE "default",
+        "LanguageIsPublic" bool NOT NULL DEFAULT true,
+        "PermEveryone" int4 NOT NULL DEFAULT 0,
+        "PermGroup" int4 NOT NULL DEFAULT 0,
+        "PermNextOwner" int4 NOT NULL DEFAULT 532480
+)
+WITH (OIDS=FALSE);
+
+ALTER TABLE "public"."agentprefs" ADD PRIMARY KEY ("PrincipalID") NOT DEFERRABLE INITIALLY IMMEDIATE;
+
+COMMIT;