1
0

mysql-inventoryfolders.sql 332 B

123456789
  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;