aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/001_UserStore.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/001_UserStore.sql13
1 files changed, 7 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_UserStore.sql b/OpenSim/Data/MySQL/Resources/001_UserStore.sql
index 7ab628f..29ebc7d 100644
--- a/OpenSim/Data/MySQL/Resources/001_UserStore.sql
+++ b/OpenSim/Data/MySQL/Resources/001_UserStore.sql
@@ -1,3 +1,5 @@
1BEGIN;
2
1SET FOREIGN_KEY_CHECKS=0; 3SET FOREIGN_KEY_CHECKS=0;
2-- ---------------------------- 4-- ----------------------------
3-- Table structure for agents 5-- Table structure for agents
@@ -17,7 +19,7 @@ CREATE TABLE `agents` (
17 PRIMARY KEY (`UUID`), 19 PRIMARY KEY (`UUID`),
18 UNIQUE KEY `session` (`sessionID`), 20 UNIQUE KEY `session` (`sessionID`),
19 UNIQUE KEY `ssession` (`secureSessionID`) 21 UNIQUE KEY `ssession` (`secureSessionID`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21 23
22-- Create schema avatar_appearance 24-- Create schema avatar_appearance
23-- 25--
@@ -54,10 +56,8 @@ CREATE TABLE `avatarappearance` (
54 Underpants_Asset char(36) NOT NULL, 56 Underpants_Asset char(36) NOT NULL,
55 Skirt_Item char(36) NOT NULL, 57 Skirt_Item char(36) NOT NULL,
56 Skirt_Asset char(36) NOT NULL, 58 Skirt_Asset char(36) NOT NULL,
57
58
59 PRIMARY KEY (`Owner`) 59 PRIMARY KEY (`Owner`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2'; 60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61 61
62SET FOREIGN_KEY_CHECKS=0; 62SET FOREIGN_KEY_CHECKS=0;
63-- ---------------------------- 63-- ----------------------------
@@ -69,7 +69,7 @@ CREATE TABLE `userfriends` (
69 `friendPerms` INT NOT NULL, 69 `friendPerms` INT NOT NULL,
70 `datetimestamp` INT NOT NULL, 70 `datetimestamp` INT NOT NULL,
71 UNIQUE KEY (`ownerID`, `friendID`) 71 UNIQUE KEY (`ownerID`, `friendID`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1';SET FOREIGN_KEY_CHECKS=0; 72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73-- ---------------------------- 73-- ----------------------------
74-- Table structure for users 74-- Table structure for users
75-- ---------------------------- 75-- ----------------------------
@@ -99,8 +99,9 @@ CREATE TABLE `users` (
99 `webLoginKey` varchar(36) default NULL, 99 `webLoginKey` varchar(36) default NULL,
100 PRIMARY KEY (`UUID`), 100 PRIMARY KEY (`UUID`),
101 UNIQUE KEY `usernames` (`username`,`lastname`) 101 UNIQUE KEY `usernames` (`username`,`lastname`)
102) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; 102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103 103
104-- ---------------------------- 104-- ----------------------------
105-- Records 105-- Records
106-- ---------------------------- 106-- ----------------------------
107COMMIT; \ No newline at end of file