diff options
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql index 2bb5553..b5bddde 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql | |||
| @@ -1,11 +1,11 @@ | |||
| 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 | `type` smallint NOT NULL default 0, | 6 | `type` smallint NOT NULL default 0, |
| 7 | `version` int NOT NULL default 0, | 7 | `version` int NOT NULL default 0, |
| 8 | PRIMARY KEY (`folderID`), | 8 | PRIMARY KEY (`folderID`), |
| 9 | KEY `owner` (`agentID`), | 9 | KEY `owner` (`agentID`), |
| 10 | KEY `parent` (`parentFolderID`) | 10 | KEY `parent` (`parentFolderID`) |
| 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; | 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; |