diff options
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/AgentPrefs.migrations | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations index 3307f2d..7e0525d 100644 --- a/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations +++ b/OpenSim/Data/SQLite/Resources/AgentPrefs.migrations | |||
@@ -15,3 +15,22 @@ CREATE TABLE `AgentPrefs` ( | |||
15 | PRIMARY KEY(`PrincipalID`)); | 15 | PRIMARY KEY(`PrincipalID`)); |
16 | 16 | ||
17 | COMMIT; | 17 | COMMIT; |
18 | |||
19 | :VERSION 2 | ||
20 | |||
21 | BEGIN; | ||
22 | |||
23 | CREATE TABLE AgentPrefs( | ||
24 | PrincipalID CHAR(36) NOT NULL, | ||
25 | AccessPrefs CHAR(2) NOT NULL DEFAULT 'M', | ||
26 | HoverHeight DOUBLE(30, 27) NOT NULL DEFAULT 0, | ||
27 | Language CHAR(5) NOT NULL DEFAULT 'en-us', | ||
28 | LanguageIsPublic BOOLEAN NOT NULL DEFAULT 1, | ||
29 | PermEveryone INT(6) NOT NULL DEFAULT 0, | ||
30 | PermGroup INT(6) NOT NULL DEFAULT 0, | ||
31 | PermNextOwner INT(6) NOT NULL DEFAULT 532480, | ||
32 | UNIQUE(PrincipalID), | ||
33 | PRIMARY KEY(PrincipalID) | ||
34 | ); | ||
35 | |||
36 | COMMIT; | ||