1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
START TRANSACTION;
CREATE TABLE `InventoryFolders` (
`ID` char(36) NOT NULL,
`Type` int(11) default NULL,
`Version` int(11) default NULL,
`ParentID` char(36) default NULL,
`Owner` char(36) default NULL,
`Name` varchar(64) default NULL,
PRIMARY KEY (`ID`),
KEY `folder_owner_id` (`Owner`),
KEY `folder_parent_id` (`ParentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `InventoryItems` (
`ID` char(36) NOT NULL,
`InvType` smallint(6) default NULL,
`AssetType` smallint(6) default NULL,
`AssetID` char(36) default NULL,
`Folder` char(36) default NULL,
`Owner` char(36) default NULL,
`Creator` char(36) default NULL,
`Name` varchar(64) default NULL,
`Description` varchar(64) default NULL,
`NextPermissions` int(11) default NULL,
`CurrentPermissions` int(11) default NULL,
`BasePermissions` int(11) default NULL,
`EveryOnePermissions` int(11) default NULL,
`GroupID` char(36) default NULL,
`GroupOwned` tinyint(1) default NULL,
`SalePrice` int(11) default NULL,
`SaleType` smallint(6) default NULL,
`Flags` int(11) default NULL,
`CreationDate` int(11) default NULL,
PRIMARY KEY (`ID`),
KEY `item_group_id` (`GroupID`),
KEY `item_owner_id` (`Owner`),
KEY `item_folder_id` (`Folder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;
|
