diff options
| author | Cinder | 2015-06-13 15:47:18 -0600 |
|---|---|---|
| committer | Diva Canto | 2015-06-13 14:53:17 -0700 |
| commit | 7635138c59afdf86a32de83799b9baad831f9e04 (patch) | |
| tree | 50863a974a2960af1737aaac8ff574d52505a18d /OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | |
| parent | Added example of how to configure the GodNames module (diff) | |
| download | opensim-SC-7635138c59afdf86a32de83799b9baad831f9e04.zip opensim-SC-7635138c59afdf86a32de83799b9baad831f9e04.tar.gz opensim-SC-7635138c59afdf86a32de83799b9baad831f9e04.tar.bz2 opensim-SC-7635138c59afdf86a32de83799b9baad831f9e04.tar.xz | |
SQLite and PGSQL adapters for AgentPreferences
Signed-off-by: Diva Canto <diva@metaverseink.com>
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | 17 |
1 files changed, 17 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..2615ca2 --- /dev/null +++ b/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | |||
| @@ -0,0 +1,17 @@ | |||
| 1 | :VERSION 1 | ||
| 2 | |||
| 3 | BEGIN; | ||
| 4 | |||
| 5 | CREATE TABLE `AgentPrefs` ( | ||
| 6 | `PrincipalID` CHAR(36) NOT NULL, | ||
| 7 | `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M', | ||
| 8 | `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0, | ||
| 9 | `Language` CHAR(5) NOT NULL DEFAULT 'en-us', | ||
| 10 | `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1, | ||
| 11 | `PermEveryone` INT(6) NOT NULL DEFAULT 0, | ||
| 12 | `PermGroup` INT(6) NOT NULL DEFAULT 0, | ||
| 13 | `PermNextOwner` INT(6) NOT NULL DEFAULT 532480, | ||
| 14 | UNIQUE KEY `PrincipalID` (`PrincipalID`), | ||
| 15 | PRIMARY KEY(`PrincipalID`)); | ||
| 16 | |||
| 17 | COMMIT; \ No newline at end of file | ||