diff options
Diffstat (limited to 'share/sql/mysql-inventoryfolders.sql')
-rw-r--r-- | share/sql/mysql-inventoryfolders.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql index c30239e..8704702 100644 --- a/share/sql/mysql-inventoryfolders.sql +++ b/share/sql/mysql-inventoryfolders.sql | |||
@@ -1,9 +1,9 @@ | |||
1 | CREATE TABLE `inventoryfolders` ( | 1 | CREATE TABLE `inventoryfolders` ( |
2 | `folderID` varchar(36) NOT NULL default '', | 2 | `folderID` varchar(36) NOT NULL default '', |
3 | `agentID` varchar(36) default NULL, | 3 | `agentID` varchar(36) default NULL, |
4 | `parentFolderID` varchar(36) default NULL, | 4 | `parentFolderID` varchar(36) default NULL, |
5 | `folderName` varchar(64) default NULL, | 5 | `folderName` varchar(64) default NULL, |
6 | PRIMARY KEY (`folderID`), | 6 | PRIMARY KEY (`folderID`), |
7 | KEY `owner` (`agentID`), | 7 | KEY `owner` (`agentID`), |
8 | KEY `parent` (`parentFolderID`) | 8 | KEY `parent` (`parentFolderID`) |
9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |