From f13611bbc91127ae573155b7dd490284614a0e2c Mon Sep 17 00:00:00 2001 From: MW Date: Mon, 8 Oct 2007 16:42:05 +0000 Subject: The files that I missed from Tleiades patch. --- OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql (limited to 'OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql') diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql new file mode 100644 index 0000000..2bb5553 --- /dev/null +++ b/OpenSim/Framework/Data.MySQL/Resources/CreateFoldersTable.sql @@ -0,0 +1,11 @@ +CREATE TABLE `inventoryfolders` ( + `folderID` varchar(36) NOT NULL default '', + `agentID` varchar(36) default NULL, + `parentFolderID` varchar(36) default NULL, + `folderName` varchar(64) default NULL, + `type` smallint NOT NULL default 0, + `version` int NOT NULL default 0, + PRIMARY KEY (`folderID`), + KEY `owner` (`agentID`), + KEY `parent` (`parentFolderID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; -- cgit v1.1