blob: 6154719c6adbfc0739bb233af393d840b6e6d200 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
:VERSION 2
BEGIN TRANSACTION;
DROP TABLE IF EXISTS "AgentPrefs";
CREATE TABLE "AgentPrefs" (
"PrincipalID" uuid NOT NULL,
"AccessPrefs" CHAR(2) NOT NULL DEFAULT 'M',
"HoverHeight" DOUBLE PRECISION NOT NULL DEFAULT 0,
"Language" CHAR(5) NOT NULL DEFAULT 'en-us',
"LanguageIsPublic" BOOLEAN NOT NULL DEFAULT true,
"PermEveryone" INT4 NOT NULL DEFAULT 0,
"PermGroup" INT4 NOT NULL DEFAULT 0,
"PermNextOwner" INT4 NOT NULL DEFAULT 532480
);
ALTER TABLE "AgentPrefs" ADD PRIMARY KEY("PrincipalID");
COMMIT;
|