diff options
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql')
-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'; |