diff options
| author | Diva Canto | 2015-06-14 14:49:20 -0700 |
|---|---|---|
| committer | Diva Canto | 2015-06-14 14:49:20 -0700 |
| commit | 4a516fa1569e814aee672e38996e31bc749d43b5 (patch) | |
| tree | b36dbc7197b38d874412921f7f934ffdfe8d8ec2 /OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | |
| parent | Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead of varcha... (diff) | |
| download | opensim-SC_OLD-4a516fa1569e814aee672e38996e31bc749d43b5.zip opensim-SC_OLD-4a516fa1569e814aee672e38996e31bc749d43b5.tar.gz opensim-SC_OLD-4a516fa1569e814aee672e38996e31bc749d43b5.tar.bz2 opensim-SC_OLD-4a516fa1569e814aee672e38996e31bc749d43b5.tar.xz | |
Removed the pgsql table for AgentPrefs, because it is not working. For now the Agent Preferences feature will not work with PGSQL installations -- someone who uses PGSQL needs to send a table that works.
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations deleted file mode 100644 index 6154719..0000000 --- a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations +++ /dev/null | |||
| @@ -1,18 +0,0 @@ | |||
| 1 | :VERSION 2 | ||
| 2 | |||
| 3 | BEGIN TRANSACTION; | ||
| 4 | |||
| 5 | DROP TABLE IF EXISTS "AgentPrefs"; | ||
| 6 | CREATE TABLE "AgentPrefs" ( | ||
| 7 | "PrincipalID" uuid NOT NULL, | ||
| 8 | "AccessPrefs" CHAR(2) NOT NULL DEFAULT 'M', | ||
| 9 | "HoverHeight" DOUBLE PRECISION NOT NULL DEFAULT 0, | ||
| 10 | "Language" CHAR(5) NOT NULL DEFAULT 'en-us', | ||
| 11 | "LanguageIsPublic" BOOLEAN NOT NULL DEFAULT true, | ||
| 12 | "PermEveryone" INT4 NOT NULL DEFAULT 0, | ||
| 13 | "PermGroup" INT4 NOT NULL DEFAULT 0, | ||
| 14 | "PermNextOwner" INT4 NOT NULL DEFAULT 532480 | ||
| 15 | ); | ||
| 16 | ALTER TABLE "AgentPrefs" ADD PRIMARY KEY("PrincipalID"); | ||
| 17 | |||
| 18 | COMMIT; \ No newline at end of file | ||