diff options
| author | Geir Nøklebye | 2017-05-08 21:11:33 +0200 |
|---|---|---|
| committer | UbitUmarov | 2017-05-08 20:25:03 +0100 |
| commit | d952d62baaee5817d080cffd1fd46767992f0397 (patch) | |
| tree | 19a9f8727bfb0c237eceb81625aae4925ee728ee /OpenSim | |
| parent | some conditional dispose on http requests inputstream (diff) | |
| download | opensim-SC-d952d62baaee5817d080cffd1fd46767992f0397.zip opensim-SC-d952d62baaee5817d080cffd1fd46767992f0397.tar.gz opensim-SC-d952d62baaee5817d080cffd1fd46767992f0397.tar.bz2 opensim-SC-d952d62baaee5817d080cffd1fd46767992f0397.tar.xz | |
PGSQL: Add missing AgentPrefs.migrations
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
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; | ||