From c417a5b619eb85706a1782c5b0943cb8b28bd7a1 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Tue, 17 Feb 2009 19:06:23 +0000 Subject: remove all the very old create and upgrade sql files, these were outdated by migrations 6 months ago. --- OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | 24 ----------------------- 1 file changed, 24 deletions(-) delete mode 100644 OpenSim/Data/MySQL/Resources/CreateItemsTable.sql (limited to 'OpenSim/Data/MySQL/Resources/CreateItemsTable.sql') diff --git a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql deleted file mode 100644 index ffdbe17..0000000 --- a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql +++ /dev/null @@ -1,24 +0,0 @@ -CREATE TABLE `inventoryitems` ( - `inventoryID` varchar(36) NOT NULL default '', - `assetID` varchar(36) default NULL, - `assetType` int(11) default NULL, - `parentFolderID` varchar(36) default NULL, - `avatarID` varchar(36) default NULL, - `inventoryName` varchar(64) default NULL, - `inventoryDescription` varchar(128) default NULL, - `inventoryNextPermissions` int(10) unsigned default NULL, - `inventoryCurrentPermissions` int(10) unsigned default NULL, - `invType` int(11) default NULL, - `creatorID` varchar(36) default NULL, - `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, - `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, - `salePrice` int(11) NOT NULL default 0, - `saleType` tinyint(4) NOT NULL default 0, - `creationDate` int(11) NOT NULL default 0, - `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', - `groupOwned` tinyint(4) NOT NULL default 0, - `flags` int(11) unsigned NOT NULL default 0, - PRIMARY KEY (`inventoryID`), - KEY `owner` (`avatarID`), - KEY `folder` (`parentFolderID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 3'; -- cgit v1.1