From 7635138c59afdf86a32de83799b9baad831f9e04 Mon Sep 17 00:00:00 2001 From: Cinder Date: Sat, 13 Jun 2015 15:47:18 -0600 Subject: SQLite and PGSQL adapters for AgentPreferences Signed-off-by: Diva Canto --- OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations (limited to 'OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations') 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 @@ +:VERSION 1 + +BEGIN; + +CREATE TABLE `AgentPrefs` ( + `PrincipalID` CHAR(36) NOT NULL, + `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M', + `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0, + `Language` CHAR(5) NOT NULL DEFAULT 'en-us', + `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1, + `PermEveryone` INT(6) NOT NULL DEFAULT 0, + `PermGroup` INT(6) NOT NULL DEFAULT 0, + `PermNextOwner` INT(6) NOT NULL DEFAULT 532480, + UNIQUE KEY `PrincipalID` (`PrincipalID`), + PRIMARY KEY(`PrincipalID`)); + +COMMIT; \ No newline at end of file -- cgit v1.1