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, |
||
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 | PRIMARY KEY (`classifieduuid`) |
||
22 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
||
23 | |||
24 | |||
25 | CREATE TABLE IF NOT EXISTS `usernotes` ( |
||
26 | `useruuid` varchar(36) NOT NULL, |
||
27 | `targetuuid` varchar(36) NOT NULL, |
||
28 | `notes` text NOT NULL, |
||
29 | UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`) |
||
30 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
31 | |||
32 | |||
33 | CREATE TABLE IF NOT EXISTS `userpicks` ( |
||
34 | `pickuuid` varchar(36) NOT NULL, |
||
35 | `creatoruuid` varchar(36) NOT NULL, |
||
36 | `toppick` enum('true','false') 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` int(2) NOT NULL, |
||
46 | `enabled` enum('true','false') NOT NULL, |
||
47 | PRIMARY KEY (`pickuuid`) |
||
48 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
49 | |||
50 | |||
51 | CREATE TABLE IF NOT EXISTS `userprofile` ( |
||
52 | `useruuid` varchar(36) NOT NULL, |
||
53 | `profilePartner` varchar(36) NOT NULL, |
||
54 | `profileAllowPublish` binary(1) NOT NULL, |
||
55 | `profileMaturePublish` binary(1) NOT NULL, |
||
56 | `profileURL` varchar(255) NOT NULL, |
||
57 | `profileWantToMask` int(3) NOT NULL, |
||
58 | `profileWantToText` text NOT NULL, |
||
59 | `profileSkillsMask` int(3) 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 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
68 | |||
69 | commit; |
||
70 | |||
71 | :VERSION 2 # ------------------------------- |
||
72 | |||
73 | begin; |
||
74 | CREATE TABLE IF NOT EXISTS `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 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
81 | |||
82 | commit; |
||
83 | |||
84 | :VERSION 3 # ------------------------------- |
||
85 | begin; |
||
86 | CREATE TABLE IF NOT EXISTS `usersettings` ( |
||
87 | `useruuid` varchar(36) NOT NULL, |
||
88 | `imviaemail` enum('true','false') NOT NULL, |
||
89 | `visible` enum('true','false') NOT NULL, |
||
90 | `email` varchar(254) NOT NULL, |
||
91 | PRIMARY KEY (`useruuid`) |
||
92 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
||
93 | commit; |