aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
diff options
context:
space:
mode:
authoronefang2019-05-19 21:24:15 +1000
committeronefang2019-05-19 21:24:15 +1000
commit5e4d6cab00cb29cd088ab7b62ab13aff103b64cb (patch)
treea9fbc62df9eb2d1d9ba2698d8552eae71eca20d8 /OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations
parentAdd a build script. (diff)
downloadopensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.zip
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.gz
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.bz2
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.xz
Dump OpenSim 0.9.0.1 into it's own branch.
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations19
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 @@
1:VERSION 1
2
3BEGIN TRANSACTION;
4
5CREATE TABLE IF NOT EXISTS "public"."agentprefs" (
6 "PrincipalID" uuid NOT NULL,
7 "AccessPrefs" char(2) NOT NULL DEFAULT 'M'::bpchar COLLATE "default",
8 "HoverHeight" float8 NOT NULL DEFAULT 0,
9 "Language" char(5) NOT NULL DEFAULT 'en-us'::bpchar COLLATE "default",
10 "LanguageIsPublic" bool NOT NULL DEFAULT true,
11 "PermEveryone" int4 NOT NULL DEFAULT 0,
12 "PermGroup" int4 NOT NULL DEFAULT 0,
13 "PermNextOwner" int4 NOT NULL DEFAULT 532480
14)
15WITH (OIDS=FALSE);
16
17ALTER TABLE "public"."agentprefs" ADD PRIMARY KEY ("PrincipalID") NOT DEFERRABLE INITIALLY IMMEDIATE;
18
19COMMIT;