remove all the very old create and upgrade sql files, these were

outdated by migrations 6 months ago.

17 files changed, 0 insertions, 288 deletions

diff --git a/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql b/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql
deleted file mode 100644
index 3ef7bc9..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateAgentsTable.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
--- ----------------------------
--- Table structure for agents
--- ----------------------------
-CREATE TABLE `agents` (
-  `UUID` varchar(36) NOT NULL,
-  `sessionID` varchar(36) NOT NULL,
-  `secureSessionID` varchar(36) NOT NULL,
-  `agentIP` varchar(16) NOT NULL,
-  `agentPort` int(11) NOT NULL,
-  `agentOnline` tinyint(4) NOT NULL,
-  `loginTime` int(11) NOT NULL,
-  `logoutTime` int(11) NOT NULL,
-  `currentRegion` varchar(36) NOT NULL,
-  `currentHandle` bigint(20) unsigned NOT NULL,
-  `currentPos` varchar(64) NOT NULL,
-  PRIMARY KEY  (`UUID`),
-  UNIQUE KEY `session` (`sessionID`),
-  UNIQUE KEY `ssession` (`secureSessionID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
--- ----------------------------
--- Records 
--- ----------------------------
diff --git a/OpenSim/Data/MySQL/Resources/CreateAssetsTable.sql b/OpenSim/Data/MySQL/Resources/CreateAssetsTable.sql
deleted file mode 100644
index 2c750fe..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateAssetsTable.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE TABLE `assets` (
-  `id` binary(16) NOT NULL,
-  `name` varchar(64) NOT NULL,
-  `description` varchar(64) NOT NULL,
-  `assetType` tinyint(4) NOT NULL,
-  `invType` tinyint(4) NOT NULL,
-  `local` tinyint(1) NOT NULL,
-  `temporary` tinyint(1) NOT NULL,
-  `data` longblob NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
\ No newline at end of file
diff --git a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql b/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
deleted file mode 100644
index 475c933..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
+++ /dev/null
@@ -1,42 +0,0 @@
---
--- Create schema avatar_appearance
---
-
-DROP TABLE IF EXISTS `avatarappearance`;
-CREATE TABLE `avatarappearance` (
-  Owner char(36) NOT NULL,
-  Serial int(10) unsigned NOT NULL,
-  Visual_Params blob NOT NULL,
-  Texture blob NOT NULL,
-  Avatar_Height float NOT NULL,
-  Body_Item char(36) NOT NULL,
-  Body_Asset char(36) NOT NULL,
-  Skin_Item char(36) NOT NULL,
-  Skin_Asset char(36) NOT NULL,
-  Hair_Item char(36) NOT NULL,
-  Hair_Asset char(36) NOT NULL,
-  Eyes_Item char(36) NOT NULL,
-  Eyes_Asset char(36) NOT NULL,
-  Shirt_Item char(36) NOT NULL,
-  Shirt_Asset char(36) NOT NULL,
-  Pants_Item char(36) NOT NULL,
-  Pants_Asset char(36) NOT NULL,
-  Shoes_Item char(36) NOT NULL,
-  Shoes_Asset char(36) NOT NULL,
-  Socks_Item char(36) NOT NULL,
-  Socks_Asset char(36) NOT NULL,
-  Jacket_Item char(36) NOT NULL,
-  Jacket_Asset char(36) NOT NULL,
-  Gloves_Item char(36) NOT NULL,
-  Gloves_Asset char(36) NOT NULL,
-  Undershirt_Item char(36) NOT NULL,
-  Undershirt_Asset char(36) NOT NULL,
-  Underpants_Item char(36) NOT NULL,
-  Underpants_Asset char(36) NOT NULL,
-  Skirt_Item char(36) NOT NULL,
-  Skirt_Asset char(36) NOT NULL,
-
-
-  PRIMARY KEY  (`Owner`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2';
-
diff --git a/OpenSim/Data/MySQL/Resources/CreateFoldersTable.sql b/OpenSim/Data/MySQL/Resources/CreateFoldersTable.sql
deleted file mode 100644
index b5bddde..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateFoldersTable.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-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';
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';
diff --git a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql
deleted file mode 100644
index 6c7254a..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-CREATE TABLE `land`
-   (
-   `UUID` varchar (255) NOT NULL,
-   `RegionUUID` varchar (255) DEFAULT NULL ,
-   `LocalLandID` int (11) DEFAULT NULL ,
-   `Bitmap` longblob,
-   `Name` varchar (255) DEFAULT NULL ,
-   `Description` varchar (255) DEFAULT NULL ,
-   `OwnerUUID` varchar (255) DEFAULT NULL ,
-   `IsGroupOwned` int (11) DEFAULT NULL ,
-   `Area` int (11) DEFAULT NULL ,
-   `AuctionID` int (11) DEFAULT NULL ,
-   `Category` int (11) DEFAULT NULL ,
-   `ClaimDate` int (11) DEFAULT NULL ,
-   `ClaimPrice` int (11) DEFAULT NULL ,
-   `GroupUUID` varchar (255) DEFAULT NULL ,
-   `SalePrice` int (11) DEFAULT NULL ,
-   `LandStatus` int (11) DEFAULT NULL ,
-   `LandFlags` int (11) DEFAULT NULL ,
-   `LandingType` int (11) DEFAULT NULL ,
-   `MediaAutoScale` int (11) DEFAULT NULL ,
-   `MediaTextureUUID` varchar (255) DEFAULT NULL ,
-   `MediaURL` varchar (255) DEFAULT NULL ,
-   `MusicURL` varchar (255) DEFAULT NULL ,
-   `PassHours` float DEFAULT NULL ,
-   `PassPrice` int (11) DEFAULT NULL ,
-   `SnapshotUUID` varchar (255) DEFAULT NULL ,
-   `UserLocationX` float DEFAULT NULL ,
-   `UserLocationY` float DEFAULT NULL ,
-   `UserLocationZ` float DEFAULT NULL ,
-   `UserLookAtX` float DEFAULT NULL ,
-   `UserLookAtY` float DEFAULT NULL ,
-   `UserLookAtZ` float DEFAULT NULL ,
-   `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-   
-   PRIMARY KEY (`UUID`)
-   )
-   ENGINE=INNODB
-   DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
\ No newline at end of file
diff --git a/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql b/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql
deleted file mode 100644
index 53dcd31..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE `logs` (
-  `logID` int(10) unsigned NOT NULL auto_increment,
-  `target` varchar(36) default NULL,
-  `server` varchar(64) default NULL,
-  `method` varchar(64) default NULL,
-  `arguments` varchar(255) default NULL,
-  `priority` int(11) default NULL,
-  `message` text,
-  PRIMARY KEY  (`logID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8
diff --git a/OpenSim/Data/MySQL/Resources/CreateRegionsTable.sql b/OpenSim/Data/MySQL/Resources/CreateRegionsTable.sql
deleted file mode 100644
index cb0f9bd..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateRegionsTable.sql
+++ /dev/null
@@ -1,32 +0,0 @@
-CREATE TABLE `regions` (
-  `uuid` varchar(36) NOT NULL,
-  `regionHandle` bigint(20) unsigned NOT NULL,
-  `regionName` varchar(32) default NULL,
-  `regionRecvKey` varchar(128) default NULL,
-  `regionSendKey` varchar(128) default NULL,
-  `regionSecret` varchar(128) default NULL,
-  `regionDataURI` varchar(255) default NULL,
-  `serverIP` varchar(64) default NULL,
-  `serverPort` int(10) unsigned default NULL,
-  `serverURI` varchar(255) default NULL,
-  `locX` int(10) unsigned default NULL,
-  `locY` int(10) unsigned default NULL,
-  `locZ` int(10) unsigned default NULL,
-  `eastOverrideHandle` bigint(20) unsigned default NULL,
-  `westOverrideHandle` bigint(20) unsigned default NULL,
-  `southOverrideHandle` bigint(20) unsigned default NULL,
-  `northOverrideHandle` bigint(20) unsigned default NULL,
-  `regionAssetURI` varchar(255) default NULL,
-  `regionAssetRecvKey` varchar(128) default NULL,
-  `regionAssetSendKey` varchar(128) default NULL,
-  `regionUserURI` varchar(255) default NULL,
-  `regionUserRecvKey` varchar(128) default NULL,
-  `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
-  `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
-  `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-  `originUUID` varchar(36),
-  PRIMARY KEY  (`uuid`),
-  KEY `regionName` (`regionName`),
-  KEY `regionHandle` (`regionHandle`),
-  KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
diff --git a/OpenSim/Data/MySQL/Resources/CreateUserFriendsTable.sql b/OpenSim/Data/MySQL/Resources/CreateUserFriendsTable.sql
deleted file mode 100644
index 8480d48..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateUserFriendsTable.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
--- ----------------------------
--- Table structure for users
--- ----------------------------
-CREATE TABLE `userfriends` (
-   `ownerID` VARCHAR(37) NOT NULL,
-   `friendID` VARCHAR(37) NOT NULL,
-   `friendPerms` INT NOT NULL,
-   `datetimestamp` INT NOT NULL,
-         UNIQUE KEY  (`ownerID`, `friendID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1';
\ No newline at end of file
diff --git a/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql b/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql
deleted file mode 100644
index d9e8ae2..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateUsersTable.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
--- ----------------------------
--- Table structure for users
--- ----------------------------
-CREATE TABLE `users` (
-  `UUID` varchar(36) NOT NULL default '',
-  `username` varchar(32) NOT NULL,
-  `lastname` varchar(32) NOT NULL,
-  `passwordHash` varchar(32) NOT NULL,
-  `passwordSalt` varchar(32) NOT NULL,
-  `homeRegion` bigint(20) unsigned default NULL,
-  `homeLocationX` float default NULL,
-  `homeLocationY` float default NULL,
-  `homeLocationZ` float default NULL,
-  `homeLookAtX` float default NULL,
-  `homeLookAtY` float default NULL,
-  `homeLookAtZ` float default NULL,
-  `created` int(11) NOT NULL,
-  `lastLogin` int(11) NOT NULL,
-  `userInventoryURI` varchar(255) default NULL,
-  `userAssetURI` varchar(255) default NULL,
-  `profileCanDoMask` int(10) unsigned default NULL,
-  `profileWantDoMask` int(10) unsigned default NULL,
-  `profileAboutText` text,
-  `profileFirstText` text,
-  `profileImage` varchar(36) default NULL,
-  `profileFirstImage` varchar(36) default NULL,
-  `webLoginKey` varchar(36) default NULL,
-  PRIMARY KEY  (`UUID`),
-  UNIQUE KEY `usernames` (`username`,`lastname`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
-
--- ----------------------------
--- Records 
--- ----------------------------
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeFoldersTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeFoldersTableToVersion2.sql
deleted file mode 100644
index b5a7964..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeFoldersTableToVersion2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `inventoryfolders` 
-        ADD COLUMN `type` smallint NOT NULL default 0,
-        ADD COLUMN `version` int NOT NULL default 0,
-COMMENT='Rev. 2';
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql
deleted file mode 100644
index d1ef504..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion2.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-ALTER TABLE `inventoryitems` 
-        CHANGE COLUMN `type` `assetType` int(11) default NULL,
-        ADD COLUMN `invType` int(11) default NULL,
-        ADD COLUMN `creatorID` varchar(36) default NULL,
-        ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
-        ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
-COMMENT='Rev. 2';
-
-UPDATE `inventoryitems` SET invType=assetType;
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
deleted file mode 100644
index b4108ab..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-ALTER TABLE `inventoryitems` 
-        ADD COLUMN `salePrice` int(11) NOT NULL default 0,
-        ADD COLUMN `saleType` tinyint(4) NOT NULL default 0,
-        ADD COLUMN `creationDate` int(11) NOT NULL default 0,
-        ADD COLUMN `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
-        ADD COLUMN `groupOwned` tinyint(4) NOT NULL default 0,
-        ADD COLUMN `flags` int(11) unsigned NOT NULL default 0,
-COMMENT='Rev. 3';
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql
deleted file mode 100644
index c5c55f1..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `land` 
-        ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-COMMENT='Rev. 2';
\ No newline at end of file
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion2.sql
deleted file mode 100644
index 034b755..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `regions` 
-        ADD COLUMN `originUUID` varchar(36),
-COMMENT='Rev. 2';
-UPDATE `regions` SET originUUID=uuid;
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion3.sql b/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion3.sql
deleted file mode 100644
index b48afec..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeRegionsTableToVersion3.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-DROP PROCEDURE IF EXISTS upgraderegions3;
-
-create procedure upgraderegions3()
-BEGIN
-DECLARE db_name varchar(64);
-select database() into db_name;
-IF ((select count(*) from information_schema.columns where table_name='regions' and column_name='owner_uuid' and table_schema=db_name) > 0)
-THEN
-    ALTER TABLE `regions`, COMMENT='Rev. 3';
-ELSE
-    ALTER TABLE `regions`
-        ADD COLUMN `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null after serverRemotingPort, COMMENT='Rev. 3';
-END IF;
-END; 
-
-call upgraderegions3();
-
-
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeUsersTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeUsersTableToVersion2.sql
deleted file mode 100644
index dd21a66..0000000
--- a/OpenSim/Data/MySQL/Resources/UpgradeUsersTableToVersion2.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `users` 
-        ADD COLUMN `webLoginKey` varchar(36) default '00000000-0000-0000-0000-000000000000' NOT NULL,
-COMMENT='Rev. 2';
\ No newline at end of file