diff options
Diffstat (limited to 'share/sql')
| -rw-r--r-- | share/sql/mysql-inventoryfolders.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql index 8704702..ebda3bb 100644 --- a/share/sql/mysql-inventoryfolders.sql +++ b/share/sql/mysql-inventoryfolders.sql | |||
| @@ -3,6 +3,8 @@ CREATE TABLE `inventoryfolders` ( | |||
| 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 | `category` TINYINT NOT NULL, | ||
| 7 | `folderType` TINYINT NOT NULL, | ||
| 6 | PRIMARY KEY (`folderID`), | 8 | PRIMARY KEY (`folderID`), |
| 7 | KEY `owner` (`agentID`), | 9 | KEY `owner` (`agentID`), |
| 8 | KEY `parent` (`parentFolderID`) | 10 | KEY `parent` (`parentFolderID`) |