diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql | 102 |
1 files changed, 62 insertions, 40 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql index 5db5d29..a66f5b8 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql | |||
@@ -1,12 +1,12 @@ | |||
1 | START TRANSACTION; | 1 | START TRANSACTION; |
2 | 2 | ||
3 | CREATE TABLE `UserAgents` ( | 3 | CREATE TABLE `UserAgents` ( |
4 | `ProfileID` varchar(255) NOT NULL, | 4 | `ProfileID` varchar(36) NOT NULL, |
5 | `AgentIP` varchar(24) default NULL, | 5 | `AgentIP` varchar(24) default NULL, |
6 | `AgentPort` int(11) default NULL, | 6 | `AgentPort` int(11) default NULL, |
7 | `AgentOnline` tinyint(1) default NULL, | 7 | `AgentOnline` tinyint(1) default NULL, |
8 | `SessionID` varchar(255) default NULL, | 8 | `SessionID` varchar(36) default NULL, |
9 | `SecureSessionID` varchar(255) default NULL, | 9 | `SecureSessionID` varchar(36) default NULL, |
10 | `InitialRegion` varchar(255) default NULL, | 10 | `InitialRegion` varchar(255) default NULL, |
11 | `Region` varchar(255) default NULL, | 11 | `Region` varchar(255) default NULL, |
12 | `LoginTime` int(11) default NULL, | 12 | `LoginTime` int(11) default NULL, |
@@ -15,16 +15,21 @@ CREATE TABLE `UserAgents` ( | |||
15 | `PositionX` float default NULL, | 15 | `PositionX` float default NULL, |
16 | `PositionY` float default NULL, | 16 | `PositionY` float default NULL, |
17 | `PositionZ` float default NULL, | 17 | `PositionZ` float default NULL, |
18 | `LookAtX` float default NULL, | ||
19 | `LookAtY` float default NULL, | ||
20 | `LookAtZ` float default NULL, | ||
18 | PRIMARY KEY (`ProfileID`) | 21 | PRIMARY KEY (`ProfileID`) |
19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 22 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
20 | 23 | ||
21 | CREATE TABLE `UserProfiles` ( | 24 | CREATE TABLE `UserProfiles` ( |
22 | `ID` varchar(255) NOT NULL, | 25 | `ID` varchar(36) NOT NULL, |
26 | `WebLoginKey` varchar(36) default NULL, | ||
23 | `FirstName` varchar(32) default NULL, | 27 | `FirstName` varchar(32) default NULL, |
24 | `SurName` varchar(32) default NULL, | 28 | `SurName` varchar(32) default NULL, |
29 | `Email` varchar(250) default NULL, | ||
25 | `PasswordHash` varchar(32) default NULL, | 30 | `PasswordHash` varchar(32) default NULL, |
26 | `PasswordSalt` varchar(32) default NULL, | 31 | `PasswordSalt` varchar(32) default NULL, |
27 | `WebLoginKey` varchar(255) default NULL, | 32 | `HomeRegionID` varchar(36) default NULL, |
28 | `HomeRegionX` int(11) default NULL, | 33 | `HomeRegionX` int(11) default NULL, |
29 | `HomeRegionY` int(11) default NULL, | 34 | `HomeRegionY` int(11) default NULL, |
30 | `HomeLocationX` float default NULL, | 35 | `HomeLocationX` float default NULL, |
@@ -35,50 +40,67 @@ CREATE TABLE `UserProfiles` ( | |||
35 | `HomeLookAtZ` float default NULL, | 40 | `HomeLookAtZ` float default NULL, |
36 | `Created` int(11) default NULL, | 41 | `Created` int(11) default NULL, |
37 | `LastLogin` int(11) default NULL, | 42 | `LastLogin` int(11) default NULL, |
38 | `RootInventoryFolderID` varchar(255) default NULL, | ||
39 | `UserInventoryURI` varchar(255) default NULL, | 43 | `UserInventoryURI` varchar(255) default NULL, |
40 | `UserAssetURI` varchar(255) default NULL, | 44 | `UserAssetURI` varchar(255) default NULL, |
41 | `Image` varchar(255) default NULL, | 45 | `Image` varchar(36) default NULL, |
42 | `FirstLifeImage` varchar(255) default NULL, | 46 | `FirstLifeImage` varchar(36) default NULL, |
43 | `AboutText` varchar(255) default NULL, | 47 | `AboutText` text default NULL, |
44 | `FirstLifeAboutText` varchar(255) default NULL, | 48 | `FirstLifeAboutText` text default NULL, |
49 | `CanDoMask` int(11) default NULL, | ||
50 | `WantDoMask` int(11) default NULL, | ||
51 | `UserFlags` int(11) default NULL, | ||
52 | `GodLevel` int(11) default NULL, | ||
53 | `CustomType` varchar(32) default NULL, | ||
54 | `Partner` varchar(36) default NULL, | ||
55 | `RootInventoryFolderID` varchar(36) default NULL, | ||
45 | PRIMARY KEY (`ID`), | 56 | PRIMARY KEY (`ID`), |
46 | KEY `user_surname` (`SurName`), | 57 | INDEX `UserSurnameIndex` (`SurName`), |
47 | KEY `user_firstname` (`FirstName`) | 58 | INDEX `UserFirstNameIndex` (`FirstName`), |
59 | UNIQUE INDEX `UserFullNameIndex` (`SurName`,`FirstName`) | ||
48 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 60 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
49 | 61 | ||
50 | CREATE TABLE `UserAppearances` ( | 62 | CREATE TABLE `UserAppearances` ( |
51 | `Owner` varchar(255) NOT NULL, | 63 | `Owner` varchar(36) NOT NULL, |
52 | `BodyItem` varchar(255) default NULL, | 64 | `BodyItem` varchar(36) default NULL, |
53 | `BodyAsset` varchar(255) default NULL, | 65 | `BodyAsset` varchar(36) default NULL, |
54 | `SkinItem` varchar(255) default NULL, | 66 | `SkinItem` varchar(36) default NULL, |
55 | `SkinAsset` varchar(255) default NULL, | 67 | `SkinAsset` varchar(36) default NULL, |
56 | `HairItem` varchar(255) default NULL, | 68 | `HairItem` varchar(36) default NULL, |
57 | `HairAsset` varchar(255) default NULL, | 69 | `HairAsset` varchar(36) default NULL, |
58 | `EyesItem` varchar(255) default NULL, | 70 | `EyesItem` varchar(36) default NULL, |
59 | `EyesAsset` varchar(255) default NULL, | 71 | `EyesAsset` varchar(36) default NULL, |
60 | `ShirtItem` varchar(255) default NULL, | 72 | `ShirtItem` varchar(36) default NULL, |
61 | `ShirtAsset` varchar(255) default NULL, | 73 | `ShirtAsset` varchar(36) default NULL, |
62 | `PantsItem` varchar(255) default NULL, | 74 | `PantsItem` varchar(36) default NULL, |
63 | `PantsAsset` varchar(255) default NULL, | 75 | `PantsAsset` varchar(36) default NULL, |
64 | `ShoesItem` varchar(255) default NULL, | 76 | `ShoesItem` varchar(36) default NULL, |
65 | `ShoesAsset` varchar(255) default NULL, | 77 | `ShoesAsset` varchar(36) default NULL, |
66 | `SocksItem` varchar(255) default NULL, | 78 | `SocksItem` varchar(36) default NULL, |
67 | `SocksAsset` varchar(255) default NULL, | 79 | `SocksAsset` varchar(36) default NULL, |
68 | `JacketItem` varchar(255) default NULL, | 80 | `JacketItem` varchar(36) default NULL, |
69 | `JacketAsset` varchar(255) default NULL, | 81 | `JacketAsset` varchar(36) default NULL, |
70 | `GlovesItem` varchar(255) default NULL, | 82 | `GlovesItem` varchar(36) default NULL, |
71 | `GlovesAsset` varchar(255) default NULL, | 83 | `GlovesAsset` varchar(36) default NULL, |
72 | `UnderShirtItem` varchar(255) default NULL, | 84 | `UnderShirtItem` varchar(36) default NULL, |
73 | `UnderShirtAsset` varchar(255) default NULL, | 85 | `UnderShirtAsset` varchar(36) default NULL, |
74 | `UnderPantsItem` varchar(255) default NULL, | 86 | `UnderPantsItem` varchar(36) default NULL, |
75 | `UnderPantsAsset` varchar(255) default NULL, | 87 | `UnderPantsAsset` varchar(36) default NULL, |
76 | `SkirtItem` varchar(255) default NULL, | 88 | `SkirtItem` varchar(36) default NULL, |
77 | `SkirtAsset` varchar(255) default NULL, | 89 | `SkirtAsset` varchar(36) default NULL, |
78 | `Texture` longblob, | 90 | `Texture` longblob, |
79 | `VisualParams` longblob, | 91 | `VisualParams` longblob, |
80 | `Serial` int(11) default NULL, | 92 | `Serial` int(11) default NULL, |
93 | `AvatarHeight` float default NULL, | ||
81 | PRIMARY KEY (`Owner`) | 94 | PRIMARY KEY (`Owner`) |
82 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 95 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
83 | 96 | ||
84 | COMMIT; \ No newline at end of file | 97 | CREATE TABLE `UserFriends` ( |
98 | `UserFriendID` VARCHAR(36) NOT NULL, | ||
99 | `OwnerID` VARCHAR(36) NOT NULL, | ||
100 | `FriendID` VARCHAR(36) NOT NULL, | ||
101 | `FriendPermissions` INT(11) NOT NULL, | ||
102 | PRIMARY KEY (`UserFriendID`), | ||
103 | UNIQUE INDEX (`OwnerID`,`FriendID`) | ||
104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
105 | |||
106 | COMMIT; | ||