diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql new file mode 100644 index 0000000..80afaa0 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql | |||
@@ -0,0 +1,41 @@ | |||
1 | START TRANSACTION; | ||
2 | |||
3 | CREATE TABLE `InventoryFolders` ( | ||
4 | `ID` char(36) NOT NULL, | ||
5 | `Type` int(11) default NULL, | ||
6 | `Version` int(11) default NULL, | ||
7 | `ParentID` char(36) default NULL, | ||
8 | `Owner` char(36) default NULL, | ||
9 | `Name` varchar(64) default NULL, | ||
10 | PRIMARY KEY (`ID`), | ||
11 | KEY `folder_owner_id` (`Owner`), | ||
12 | KEY `folder_parent_id` (`ParentID`) | ||
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
14 | |||
15 | CREATE TABLE `InventoryItems` ( | ||
16 | `ID` char(36) NOT NULL, | ||
17 | `InvType` smallint(6) default NULL, | ||
18 | `AssetType` smallint(6) default NULL, | ||
19 | `AssetID` char(36) default NULL, | ||
20 | `Folder` char(36) default NULL, | ||
21 | `Owner` char(36) default NULL, | ||
22 | `Creator` char(36) default NULL, | ||
23 | `Name` varchar(64) default NULL, | ||
24 | `Description` varchar(64) default NULL, | ||
25 | `NextPermissions` int(11) default NULL, | ||
26 | `CurrentPermissions` int(11) default NULL, | ||
27 | `BasePermissions` int(11) default NULL, | ||
28 | `EveryOnePermissions` int(11) default NULL, | ||
29 | `GroupID` char(36) default NULL, | ||
30 | `GroupOwned` tinyint(1) default NULL, | ||
31 | `SalePrice` int(11) default NULL, | ||
32 | `SaleType` smallint(6) default NULL, | ||
33 | `Flags` int(11) default NULL, | ||
34 | `CreationDate` int(11) default NULL, | ||
35 | PRIMARY KEY (`ID`), | ||
36 | KEY `item_group_id` (`GroupID`), | ||
37 | KEY `item_owner_id` (`Owner`), | ||
38 | KEY `item_folder_id` (`Folder`) | ||
39 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
40 | |||
41 | COMMIT; \ No newline at end of file | ||