diff options
author | onefang | 2019-05-19 21:24:15 +1000 |
---|---|---|
committer | onefang | 2019-05-19 21:24:15 +1000 |
commit | 5e4d6cab00cb29cd088ab7b62ab13aff103b64cb (patch) | |
tree | a9fbc62df9eb2d1d9ba2698d8552eae71eca20d8 /OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | |
parent | Add a build script. (diff) | |
download | opensim-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.migrations | 19 |
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 | |||
3 | BEGIN TRANSACTION; | ||
4 | |||
5 | CREATE 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 | ) | ||
15 | WITH (OIDS=FALSE); | ||
16 | |||
17 | ALTER TABLE "public"."agentprefs" ADD PRIMARY KEY ("PrincipalID") NOT DEFERRABLE INITIALLY IMMEDIATE; | ||
18 | |||
19 | COMMIT; | ||