diff options
Diffstat (limited to 'share/sql')
-rw-r--r-- | share/sql/mysql-inventoryfolders.sql | 9 | ||||
-rw-r--r-- | share/sql/mysql-inventoryitems.sql | 14 |
2 files changed, 0 insertions, 23 deletions
diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql index 8704702..e69de29 100644 --- a/share/sql/mysql-inventoryfolders.sql +++ b/share/sql/mysql-inventoryfolders.sql | |||
@@ -1,9 +0,0 @@ | |||
1 | CREATE TABLE `inventoryfolders` ( | ||
2 | `folderID` varchar(36) NOT NULL default '', | ||
3 | `agentID` varchar(36) default NULL, | ||
4 | `parentFolderID` varchar(36) default NULL, | ||
5 | `folderName` varchar(64) default NULL, | ||
6 | PRIMARY KEY (`folderID`), | ||
7 | KEY `owner` (`agentID`), | ||
8 | KEY `parent` (`parentFolderID`) | ||
9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
diff --git a/share/sql/mysql-inventoryitems.sql b/share/sql/mysql-inventoryitems.sql index 5e03b8d..e69de29 100644 --- a/share/sql/mysql-inventoryitems.sql +++ b/share/sql/mysql-inventoryitems.sql | |||
@@ -1,14 +0,0 @@ | |||
1 | CREATE TABLE `inventoryitems` ( | ||
2 | `inventoryID` varchar(36) NOT NULL default '', | ||
3 | `assetID` varchar(36) default NULL, | ||
4 | `type` int(11) default NULL, | ||
5 | `parentFolderID` varchar(36) default NULL, | ||
6 | `avatarID` varchar(36) default NULL, | ||
7 | `inventoryName` varchar(64) default NULL, | ||
8 | `inventoryDescription` varchar(64) default NULL, | ||
9 | `inventoryNextPermissions` int(10) unsigned default NULL, | ||
10 | `inventoryCurrentPermissions` int(10) unsigned default NULL, | ||
11 | PRIMARY KEY (`inventoryID`), | ||
12 | KEY `owner` (`avatarID`), | ||
13 | KEY `folder` (`parentFolderID`) | ||
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||