1
0

CreateFoldersTable.sql 423 B

1234567891011
  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. `type` smallint NOT NULL default 0,
  7. `version` int NOT NULL default 0,
  8. PRIMARY KEY (`folderID`),
  9. KEY `owner` (`agentID`),
  10. KEY `parent` (`parentFolderID`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';