clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 1 # ----------------------------- |
2 | |||
3 | BEGIN; |
||
4 | |||
5 | SET FOREIGN_KEY_CHECKS=0; |
||
6 | -- ---------------------------- |
||
7 | -- Table structure for agents |
||
8 | -- ---------------------------- |
||
9 | CREATE TABLE `agents` ( |
||
10 | `UUID` varchar(36) NOT NULL, |
||
11 | `sessionID` varchar(36) NOT NULL, |
||
12 | `secureSessionID` varchar(36) NOT NULL, |
||
13 | `agentIP` varchar(16) NOT NULL, |
||
14 | `agentPort` int(11) NOT NULL, |
||
15 | `agentOnline` tinyint(4) NOT NULL, |
||
16 | `loginTime` int(11) NOT NULL, |
||
17 | `logoutTime` int(11) NOT NULL, |
||
18 | `currentRegion` varchar(36) NOT NULL, |
||
19 | `currentHandle` bigint(20) unsigned NOT NULL, |
||
20 | `currentPos` varchar(64) NOT NULL, |
||
21 | PRIMARY KEY (`UUID`), |
||
22 | UNIQUE KEY `session` (`sessionID`), |
||
23 | UNIQUE KEY `ssession` (`secureSessionID`) |
||
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
25 | |||
26 | -- Create schema avatar_appearance |
||
27 | -- |
||
28 | |||
29 | CREATE TABLE `avatarappearance` ( |
||
30 | Owner char(36) NOT NULL, |
||
31 | Serial int(10) unsigned NOT NULL, |
||
32 | Visual_Params blob NOT NULL, |
||
33 | Texture blob NOT NULL, |
||
34 | Avatar_Height float NOT NULL, |
||
35 | Body_Item char(36) NOT NULL, |
||
36 | Body_Asset char(36) NOT NULL, |
||
37 | Skin_Item char(36) NOT NULL, |
||
38 | Skin_Asset char(36) NOT NULL, |
||
39 | Hair_Item char(36) NOT NULL, |
||
40 | Hair_Asset char(36) NOT NULL, |
||
41 | Eyes_Item char(36) NOT NULL, |
||
42 | Eyes_Asset char(36) NOT NULL, |
||
43 | Shirt_Item char(36) NOT NULL, |
||
44 | Shirt_Asset char(36) NOT NULL, |
||
45 | Pants_Item char(36) NOT NULL, |
||
46 | Pants_Asset char(36) NOT NULL, |
||
47 | Shoes_Item char(36) NOT NULL, |
||
48 | Shoes_Asset char(36) NOT NULL, |
||
49 | Socks_Item char(36) NOT NULL, |
||
50 | Socks_Asset char(36) NOT NULL, |
||
51 | Jacket_Item char(36) NOT NULL, |
||
52 | Jacket_Asset char(36) NOT NULL, |
||
53 | Gloves_Item char(36) NOT NULL, |
||
54 | Gloves_Asset char(36) NOT NULL, |
||
55 | Undershirt_Item char(36) NOT NULL, |
||
56 | Undershirt_Asset char(36) NOT NULL, |
||
57 | Underpants_Item char(36) NOT NULL, |
||
58 | Underpants_Asset char(36) NOT NULL, |
||
59 | Skirt_Item char(36) NOT NULL, |
||
60 | Skirt_Asset char(36) NOT NULL, |
||
61 | PRIMARY KEY (`Owner`) |
||
62 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
63 | |||
64 | SET FOREIGN_KEY_CHECKS=0; |
||
65 | -- ---------------------------- |
||
66 | -- Table structure for users |
||
67 | -- ---------------------------- |
||
68 | CREATE TABLE `userfriends` ( |
||
69 | `ownerID` VARCHAR(37) NOT NULL, |
||
70 | `friendID` VARCHAR(37) NOT NULL, |
||
71 | `friendPerms` INT NOT NULL, |
||
72 | `datetimestamp` INT NOT NULL, |
||
73 | UNIQUE KEY (`ownerID`, `friendID`) |
||
74 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
75 | -- ---------------------------- |
||
76 | -- Table structure for users |
||
77 | -- ---------------------------- |
||
78 | CREATE TABLE `users` ( |
||
79 | `UUID` varchar(36) NOT NULL default '', |
||
80 | `username` varchar(32) NOT NULL, |
||
81 | `lastname` varchar(32) NOT NULL, |
||
82 | `passwordHash` varchar(32) NOT NULL, |
||
83 | `passwordSalt` varchar(32) NOT NULL, |
||
84 | `homeRegion` bigint(20) unsigned default NULL, |
||
85 | `homeLocationX` float default NULL, |
||
86 | `homeLocationY` float default NULL, |
||
87 | `homeLocationZ` float default NULL, |
||
88 | `homeLookAtX` float default NULL, |
||
89 | `homeLookAtY` float default NULL, |
||
90 | `homeLookAtZ` float default NULL, |
||
91 | `created` int(11) NOT NULL, |
||
92 | `lastLogin` int(11) NOT NULL, |
||
93 | `userInventoryURI` varchar(255) default NULL, |
||
94 | `userAssetURI` varchar(255) default NULL, |
||
95 | `profileCanDoMask` int(10) unsigned default NULL, |
||
96 | `profileWantDoMask` int(10) unsigned default NULL, |
||
97 | `profileAboutText` text, |
||
98 | `profileFirstText` text, |
||
99 | `profileImage` varchar(36) default NULL, |
||
100 | `profileFirstImage` varchar(36) default NULL, |
||
101 | `webLoginKey` varchar(36) default NULL, |
||
102 | PRIMARY KEY (`UUID`), |
||
103 | UNIQUE KEY `usernames` (`username`,`lastname`) |
||
104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
105 | |||
106 | -- ---------------------------- |
||
107 | -- Records |
||
108 | -- ---------------------------- |
||
109 | COMMIT; |
||
110 | |||
111 | :VERSION 2 # ----------------------------- |
||
112 | |||
113 | BEGIN; |
||
114 | |||
115 | ALTER TABLE users add homeRegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; |
||
116 | |||
117 | COMMIT; |
||
118 | |||
119 | :VERSION 3 # ----------------------------- |
||
120 | |||
121 | BEGIN; |
||
122 | |||
123 | ALTER TABLE users add userFlags integer NOT NULL default 0; |
||
124 | ALTER TABLE users add godLevel integer NOT NULL default 0; |
||
125 | |||
126 | COMMIT; |
||
127 | |||
128 | :VERSION 4 # ----------------------------- |
||
129 | |||
130 | BEGIN; |
||
131 | |||
132 | ALTER TABLE users add customType varchar(32) not null default ''; |
||
133 | ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
134 | |||
135 | COMMIT; |
||
136 | |||
137 | :VERSION 5 # ----------------------------- |
||
138 | |||
139 | BEGIN; |
||
140 | |||
141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=InnoDB; |
||
142 | |||
143 | COMMIT; |
||
144 | |||
145 | :VERSION 6 # ----------------------------- |
||
146 | |||
147 | BEGIN; |
||
148 | |||
149 | ALTER TABLE agents add currentLookAt varchar(36) not null default ''; |
||
150 | |||
151 | COMMIT; |
||
152 | |||
153 | :VERSION 7 # ----------------------------- |
||
154 | |||
155 | BEGIN; |
||
156 | |||
157 | ALTER TABLE users add email varchar(250); |
||
158 | |||
159 | COMMIT; |
||
160 | |||
161 | :VERSION 8 # ----------------------------- |
||
162 | |||
163 | BEGIN; |
||
164 | |||
165 | ALTER TABLE users add scopeID char(36) not null default '00000000-0000-0000-0000-000000000000'; |
||
166 | |||
167 | COMMIT; |
||
168 |