diff options
| author | Diva Canto | 2015-06-14 09:30:55 -0700 |
|---|---|---|
| committer | Diva Canto | 2015-06-14 09:30:55 -0700 |
| commit | be68f4852ce0f754e425f6e158df0f7c7fcb33f5 (patch) | |
| tree | e61294422eab9fe779dd56e6f77417898578a111 /OpenSim/Data/PGSQL | |
| parent | Squooshed a warning that could result in a runtime null pointer exception. It... (diff) | |
| download | opensim-SC-be68f4852ce0f754e425f6e158df0f7c7fcb33f5.zip opensim-SC-be68f4852ce0f754e425f6e158df0f7c7fcb33f5.tar.gz opensim-SC-be68f4852ce0f754e425f6e158df0f7c7fcb33f5.tar.bz2 opensim-SC-be68f4852ce0f754e425f6e158df0f7c7fcb33f5.tar.xz | |
Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead of varchar(36), to be consistent with the otehr pgsql tables. Since the first commit on this was yesterday, there's no migration; instead, the version starts at 2. If anyone created the table yesterday, it will be dropped and recreated.
WARNING: untested. (I don't use pg)
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | 27 |
1 files changed, 14 insertions, 13 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations index 2615ca2..6154719 100644 --- a/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations +++ b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | |||
| @@ -1,17 +1,18 @@ | |||
| 1 | :VERSION 1 | 1 | :VERSION 2 |
| 2 | 2 | ||
| 3 | BEGIN; | 3 | BEGIN TRANSACTION; |
| 4 | 4 | ||
| 5 | CREATE TABLE `AgentPrefs` ( | 5 | DROP TABLE IF EXISTS "AgentPrefs"; |
| 6 | `PrincipalID` CHAR(36) NOT NULL, | 6 | CREATE TABLE "AgentPrefs" ( |
| 7 | `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M', | 7 | "PrincipalID" uuid NOT NULL, |
| 8 | `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0, | 8 | "AccessPrefs" CHAR(2) NOT NULL DEFAULT 'M', |
| 9 | `Language` CHAR(5) NOT NULL DEFAULT 'en-us', | 9 | "HoverHeight" DOUBLE PRECISION NOT NULL DEFAULT 0, |
| 10 | `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1, | 10 | "Language" CHAR(5) NOT NULL DEFAULT 'en-us', |
| 11 | `PermEveryone` INT(6) NOT NULL DEFAULT 0, | 11 | "LanguageIsPublic" BOOLEAN NOT NULL DEFAULT true, |
| 12 | `PermGroup` INT(6) NOT NULL DEFAULT 0, | 12 | "PermEveryone" INT4 NOT NULL DEFAULT 0, |
| 13 | `PermNextOwner` INT(6) NOT NULL DEFAULT 532480, | 13 | "PermGroup" INT4 NOT NULL DEFAULT 0, |
| 14 | UNIQUE KEY `PrincipalID` (`PrincipalID`), | 14 | "PermNextOwner" INT4 NOT NULL DEFAULT 532480 |
| 15 | PRIMARY KEY(`PrincipalID`)); | 15 | ); |
| 16 | ALTER TABLE "AgentPrefs" ADD PRIMARY KEY("PrincipalID"); | ||
| 16 | 17 | ||
| 17 | COMMIT; \ No newline at end of file | 18 | COMMIT; \ No newline at end of file |