1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
:VERSION 1
BEGIN TRANSACTION;
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;
:VERSION 2
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(PrincipalID),
PRIMARY KEY(PrincipalID)
);
COMMIT;
|
