clockwerk-opensim-stable – Blame information for rev 1

Subversion Repositories:
Rev:
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