opensim – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 # ------------------------------- |
2 | |||
3 | begin; |
||
4 | |||
5 | CREATE TABLE IF NOT EXISTS classifieds ( |
||
6 | classifieduuid char(36) NOT NULL PRIMARY KEY, |
||
7 | creatoruuid char(36) NOT NULL, |
||
8 | creationdate int(20) NOT NULL, |
||
9 | expirationdate int(20) 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 int(11) 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 int(8) NOT NULL, |
||
20 | priceforlisting int(5) NOT NULL |
||
21 | ); |
||
22 | |||
23 | commit; |
||
24 | |||
25 | begin; |
||
26 | |||
27 | CREATE TABLE IF NOT EXISTS usernotes ( |
||
28 | useruuid varchar(36) NOT NULL, |
||
29 | targetuuid varchar(36) NOT NULL, |
||
30 | notes text NOT NULL, |
||
31 | UNIQUE (useruuid,targetuuid) ON CONFLICT REPLACE |
||
32 | ); |
||
33 | |||
34 | commit; |
||
35 | |||
36 | begin; |
||
37 | |||
38 | CREATE TABLE IF NOT EXISTS userpicks ( |
||
39 | pickuuid varchar(36) NOT NULL PRIMARY KEY, |
||
40 | creatoruuid varchar(36) NOT NULL, |
||
41 | toppick int NOT NULL, |
||
42 | parceluuid varchar(36) NOT NULL, |
||
43 | name varchar(255) NOT NULL, |
||
44 | description text NOT NULL, |
||
45 | snapshotuuid varchar(36) NOT NULL, |
||
46 | user varchar(255) NOT NULL, |
||
47 | originalname varchar(255) NOT NULL, |
||
48 | simname varchar(255) NOT NULL, |
||
49 | posglobal varchar(255) NOT NULL, |
||
50 | sortorder int(2) NOT NULL, |
||
51 | enabled int NOT NULL |
||
52 | ); |
||
53 | |||
54 | commit; |
||
55 | |||
56 | begin; |
||
57 | |||
58 | CREATE TABLE IF NOT EXISTS userprofile ( |
||
59 | useruuid varchar(36) NOT NULL PRIMARY KEY, |
||
60 | profilePartner varchar(36) NOT NULL, |
||
61 | profileAllowPublish binary(1) NOT NULL, |
||
62 | profileMaturePublish binary(1) NOT NULL, |
||
63 | profileURL varchar(255) NOT NULL, |
||
64 | profileWantToMask int(3) NOT NULL, |
||
65 | profileWantToText text NOT NULL, |
||
66 | profileSkillsMask int(3) NOT NULL, |
||
67 | profileSkillsText text NOT NULL, |
||
68 | profileLanguages text NOT NULL, |
||
69 | profileImage varchar(36) NOT NULL, |
||
70 | profileAboutText text NOT NULL, |
||
71 | profileFirstImage varchar(36) NOT NULL, |
||
72 | profileFirstText text NOT NULL |
||
73 | ); |
||
74 | |||
75 | commit; |
||
76 | |||
77 | :VERSION 2 # ------------------------------- |
||
78 | |||
79 | begin; |
||
80 | |||
81 | CREATE TABLE IF NOT EXISTS userdata ( |
||
82 | UserId char(36) NOT NULL, |
||
83 | TagId varchar(64) NOT NULL, |
||
84 | DataKey varchar(255), |
||
85 | DataVal varchar(255), |
||
86 | PRIMARY KEY (UserId,TagId) |
||
87 | ); |
||
88 | |||
89 | commit; |
||
90 | |||
91 | |||
92 | :VERSION 3 # ------------------------------- |
||
93 | |||
94 | begin; |
||
95 | CREATE TABLE IF NOT EXISTS usersettings ( |
||
96 | useruuid char(36) NOT NULL, |
||
97 | imviaemail binary(1) NOT NULL, |
||
98 | visible binary(1) NOT NULL, |
||
99 | email varchar(254) NOT NULL, |
||
100 | PRIMARY KEY (useruuid) |
||
101 | ) |
||
102 | commit; |