opensim-development – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 # ------------------------------- |
2 | |||
3 | begin; |
||
4 | |||
5 | CREATE TABLE classifieds ( |
||
6 | "classifieduuid" char(36) NOT NULL, |
||
7 | "creatoruuid" char(36) NOT NULL, |
||
8 | "creationdate" integer NOT NULL, |
||
9 | "expirationdate" integer NOT NULL, |
||
10 | "category" varchar(20) NOT NULL, |
||
11 | "name" varchar(255) NOT NULL, |
||
12 | "description" text NOT NULL, |
||
13 | "parceluuid" char(36) NOT NULL, |
||
14 | "parentestate" integer NOT NULL, |
||
15 | "snapshotuuid" char(36) NOT NULL, |
||
16 | "simname" varchar(255) NOT NULL, |
||
17 | "posglobal" varchar(255) NOT NULL, |
||
18 | "parcelname" varchar(255) NOT NULL, |
||
19 | "classifiedflags" integer NOT NULL, |
||
20 | "priceforlisting" integer NOT NULL, |
||
21 | constraint classifiedspk PRIMARY KEY ("classifieduuid") |
||
22 | ); |
||
23 | |||
24 | |||
25 | CREATE TABLE usernotes ( |
||
26 | "useruuid" varchar(36) NOT NULL, |
||
27 | "targetuuid" varchar(36) NOT NULL, |
||
28 | "notes" text NOT NULL, |
||
29 | constraint usernoteuk UNIQUE ("useruuid","targetuuid") |
||
30 | ); |
||
31 | |||
32 | |||
33 | CREATE TABLE userpicks ( |
||
34 | "pickuuid" varchar(36) NOT NULL, |
||
35 | "creatoruuid" varchar(36) NOT NULL, |
||
36 | "toppick" boolean NOT NULL, |
||
37 | "parceluuid" varchar(36) NOT NULL, |
||
38 | "name" varchar(255) NOT NULL, |
||
39 | "description" text NOT NULL, |
||
40 | "snapshotuuid" varchar(36) NOT NULL, |
||
41 | "user" varchar(255) NOT NULL, |
||
42 | "originalname" varchar(255) NOT NULL, |
||
43 | "simname" varchar(255) NOT NULL, |
||
44 | "posglobal" varchar(255) NOT NULL, |
||
45 | "sortorder" integer NOT NULL, |
||
46 | "enabled" boolean NOT NULL, |
||
47 | PRIMARY KEY ("pickuuid") |
||
48 | ); |
||
49 | |||
50 | |||
51 | CREATE TABLE userprofile ( |
||
52 | "useruuid" varchar(36) NOT NULL, |
||
53 | "profilePartner" varchar(36) NOT NULL, |
||
54 | "profileAllowPublish" bytea NOT NULL, |
||
55 | "profileMaturePublish" bytea NOT NULL, |
||
56 | "profileURL" varchar(255) NOT NULL, |
||
57 | "profileWantToMask" integer NOT NULL, |
||
58 | "profileWantToText" text NOT NULL, |
||
59 | "profileSkillsMask" integer NOT NULL, |
||
60 | "profileSkillsText" text NOT NULL, |
||
61 | "profileLanguages" text NOT NULL, |
||
62 | "profileImage" varchar(36) NOT NULL, |
||
63 | "profileAboutText" text NOT NULL, |
||
64 | "profileFirstImage" varchar(36) NOT NULL, |
||
65 | "profileFirstText" text NOT NULL, |
||
66 | PRIMARY KEY ("useruuid") |
||
67 | ); |
||
68 | |||
69 | commit; |
||
70 | |||
71 | :VERSION 2 # ------------------------------- |
||
72 | |||
73 | begin; |
||
74 | CREATE TABLE userdata ( |
||
75 | "UserId" char(36) NOT NULL, |
||
76 | "TagId" varchar(64) NOT NULL, |
||
77 | "DataKey" varchar(255), |
||
78 | "DataVal" varchar(255), |
||
79 | PRIMARY KEY ("UserId","TagId") |
||
80 | ); |
||
81 | |||
82 | commit; |
||
83 | |||
84 | :VERSION 3 # ------------------------------- |
||
85 | begin; |
||
86 | CREATE TABLE usersettings ( |
||
87 | "useruuid" char(36) NOT NULL, |
||
88 | "imviaemail" bytea NOT NULL, |
||
89 | "visible" bytea NOT NULL, |
||
90 | PRIMARY KEY ("useruuid") |
||
91 | ); |
||
92 | commit; |