aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/releng/dist/SQL/mysql-inventoryfolders.txt
blob: c30239ed18b82dab023bad75fdac1e48420649bd (plain)
1
2
3
4
5
6
7
8
9
CREATE TABLE `inventoryfolders` (
  `folderID` varchar(36) NOT NULL default '',
  `agentID` varchar(36) default NULL,
  `parentFolderID` varchar(36) default NULL,
  `folderName` varchar(64) default NULL,
  PRIMARY KEY  (`folderID`),
  KEY `owner` (`agentID`),
  KEY `parent` (`parentFolderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;