OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations


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;