diff options
author | Sean Dague | 2009-02-17 19:06:23 +0000 |
---|---|---|
committer | Sean Dague | 2009-02-17 19:06:23 +0000 |
commit | c417a5b619eb85706a1782c5b0943cb8b28bd7a1 (patch) | |
tree | f14981b650694cfc4271f84368a27f63979ff35e /OpenSim/Data/MySQL | |
parent | * Allow inventory archives to be saved from the 'root' inventory directory (diff) | |
download | opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.zip opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.gz opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.bz2 opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.xz |
remove all the very old create and upgrade sql files, these were
outdated by migrations 6 months ago.
Diffstat (limited to '')
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 @@ | |||
1 | SET FOREIGN_KEY_CHECKS=0; | ||
2 | -- ---------------------------- | ||
3 | -- Table structure for agents | ||
4 | -- ---------------------------- | ||
5 | CREATE TABLE `agents` ( | ||
6 | `UUID` varchar(36) NOT NULL, | ||
7 | `sessionID` varchar(36) NOT NULL, | ||
8 | `secureSessionID` varchar(36) NOT NULL, | ||
9 | `agentIP` varchar(16) NOT NULL, | ||
10 | `agentPort` int(11) NOT NULL, | ||
11 | `agentOnline` tinyint(4) NOT NULL, | ||
12 | `loginTime` int(11) NOT NULL, | ||
13 | `logoutTime` int(11) NOT NULL, | ||
14 | `currentRegion` varchar(36) NOT NULL, | ||
15 | `currentHandle` bigint(20) unsigned NOT NULL, | ||
16 | `currentPos` varchar(64) NOT NULL, | ||
17 | PRIMARY KEY (`UUID`), | ||
18 | UNIQUE KEY `session` (`sessionID`), | ||
19 | UNIQUE KEY `ssession` (`secureSessionID`) | ||
20 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
21 | |||
22 | -- ---------------------------- | ||
23 | -- Records | ||
24 | -- ---------------------------- | ||
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 @@ | |||
1 | CREATE TABLE `assets` ( | ||
2 | `id` binary(16) NOT NULL, | ||
3 | `name` varchar(64) NOT NULL, | ||
4 | `description` varchar(64) NOT NULL, | ||
5 | `assetType` tinyint(4) NOT NULL, | ||
6 | `invType` tinyint(4) NOT NULL, | ||
7 | `local` tinyint(1) NOT NULL, | ||
8 | `temporary` tinyint(1) NOT NULL, | ||
9 | `data` longblob NOT NULL, | ||
10 | PRIMARY KEY (`id`) | ||
11 | ) 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 @@ | |||
1 | -- | ||
2 | -- Create schema avatar_appearance | ||
3 | -- | ||
4 | |||
5 | DROP TABLE IF EXISTS `avatarappearance`; | ||
6 | CREATE TABLE `avatarappearance` ( | ||
7 | Owner char(36) NOT NULL, | ||
8 | Serial int(10) unsigned NOT NULL, | ||
9 | Visual_Params blob NOT NULL, | ||
10 | Texture blob NOT NULL, | ||
11 | Avatar_Height float NOT NULL, | ||
12 | Body_Item char(36) NOT NULL, | ||
13 | Body_Asset char(36) NOT NULL, | ||
14 | Skin_Item char(36) NOT NULL, | ||
15 | Skin_Asset char(36) NOT NULL, | ||
16 | Hair_Item char(36) NOT NULL, | ||
17 | Hair_Asset char(36) NOT NULL, | ||
18 | Eyes_Item char(36) NOT NULL, | ||
19 | Eyes_Asset char(36) NOT NULL, | ||
20 | Shirt_Item char(36) NOT NULL, | ||
21 | Shirt_Asset char(36) NOT NULL, | ||
22 | Pants_Item char(36) NOT NULL, | ||
23 | Pants_Asset char(36) NOT NULL, | ||
24 | Shoes_Item char(36) NOT NULL, | ||
25 | Shoes_Asset char(36) NOT NULL, | ||
26 | Socks_Item char(36) NOT NULL, | ||
27 | Socks_Asset char(36) NOT NULL, | ||
28 | Jacket_Item char(36) NOT NULL, | ||
29 | Jacket_Asset char(36) NOT NULL, | ||
30 | Gloves_Item char(36) NOT NULL, | ||
31 | Gloves_Asset char(36) NOT NULL, | ||
32 | Undershirt_Item char(36) NOT NULL, | ||
33 | Undershirt_Asset char(36) NOT NULL, | ||
34 | Underpants_Item char(36) NOT NULL, | ||
35 | Underpants_Asset char(36) NOT NULL, | ||
36 | Skirt_Item char(36) NOT NULL, | ||
37 | Skirt_Asset char(36) NOT NULL, | ||
38 | |||
39 | |||
40 | PRIMARY KEY (`Owner`) | ||
41 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2'; | ||
42 | |||
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 @@ | |||
1 | CREATE TABLE `inventoryfolders` ( | ||
2 | `folderID` varchar(36) NOT NULL default '', | ||
3 | `agentID` varchar(36) default NULL, | ||
4 | `parentFolderID` varchar(36) default NULL, | ||
5 | `folderName` varchar(64) default NULL, | ||
6 | `type` smallint NOT NULL default 0, | ||
7 | `version` int NOT NULL default 0, | ||
8 | PRIMARY KEY (`folderID`), | ||
9 | KEY `owner` (`agentID`), | ||
10 | KEY `parent` (`parentFolderID`) | ||
11 | ) 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 @@ | |||
1 | CREATE TABLE `inventoryitems` ( | ||
2 | `inventoryID` varchar(36) NOT NULL default '', | ||
3 | `assetID` varchar(36) default NULL, | ||
4 | `assetType` int(11) default NULL, | ||
5 | `parentFolderID` varchar(36) default NULL, | ||
6 | `avatarID` varchar(36) default NULL, | ||
7 | `inventoryName` varchar(64) default NULL, | ||
8 | `inventoryDescription` varchar(128) default NULL, | ||
9 | `inventoryNextPermissions` int(10) unsigned default NULL, | ||
10 | `inventoryCurrentPermissions` int(10) unsigned default NULL, | ||
11 | `invType` int(11) default NULL, | ||
12 | `creatorID` varchar(36) default NULL, | ||
13 | `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | ||
14 | `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | ||
15 | `salePrice` int(11) NOT NULL default 0, | ||
16 | `saleType` tinyint(4) NOT NULL default 0, | ||
17 | `creationDate` int(11) NOT NULL default 0, | ||
18 | `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
19 | `groupOwned` tinyint(4) NOT NULL default 0, | ||
20 | `flags` int(11) unsigned NOT NULL default 0, | ||
21 | PRIMARY KEY (`inventoryID`), | ||
22 | KEY `owner` (`avatarID`), | ||
23 | KEY `folder` (`parentFolderID`) | ||
24 | ) 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 @@ | |||
1 | CREATE TABLE `land` | ||
2 | ( | ||
3 | `UUID` varchar (255) NOT NULL, | ||
4 | `RegionUUID` varchar (255) DEFAULT NULL , | ||
5 | `LocalLandID` int (11) DEFAULT NULL , | ||
6 | `Bitmap` longblob, | ||
7 | `Name` varchar (255) DEFAULT NULL , | ||
8 | `Description` varchar (255) DEFAULT NULL , | ||
9 | `OwnerUUID` varchar (255) DEFAULT NULL , | ||
10 | `IsGroupOwned` int (11) DEFAULT NULL , | ||
11 | `Area` int (11) DEFAULT NULL , | ||
12 | `AuctionID` int (11) DEFAULT NULL , | ||
13 | `Category` int (11) DEFAULT NULL , | ||
14 | `ClaimDate` int (11) DEFAULT NULL , | ||
15 | `ClaimPrice` int (11) DEFAULT NULL , | ||
16 | `GroupUUID` varchar (255) DEFAULT NULL , | ||
17 | `SalePrice` int (11) DEFAULT NULL , | ||
18 | `LandStatus` int (11) DEFAULT NULL , | ||
19 | `LandFlags` int (11) DEFAULT NULL , | ||
20 | `LandingType` int (11) DEFAULT NULL , | ||
21 | `MediaAutoScale` int (11) DEFAULT NULL , | ||
22 | `MediaTextureUUID` varchar (255) DEFAULT NULL , | ||
23 | `MediaURL` varchar (255) DEFAULT NULL , | ||
24 | `MusicURL` varchar (255) DEFAULT NULL , | ||
25 | `PassHours` float DEFAULT NULL , | ||
26 | `PassPrice` int (11) DEFAULT NULL , | ||
27 | `SnapshotUUID` varchar (255) DEFAULT NULL , | ||
28 | `UserLocationX` float DEFAULT NULL , | ||
29 | `UserLocationY` float DEFAULT NULL , | ||
30 | `UserLocationZ` float DEFAULT NULL , | ||
31 | `UserLookAtX` float DEFAULT NULL , | ||
32 | `UserLookAtY` float DEFAULT NULL , | ||
33 | `UserLookAtZ` float DEFAULT NULL , | ||
34 | `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | ||
35 | |||
36 | PRIMARY KEY (`UUID`) | ||
37 | ) | ||
38 | ENGINE=INNODB | ||
39 | 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 @@ | |||
1 | CREATE TABLE `logs` ( | ||
2 | `logID` int(10) unsigned NOT NULL auto_increment, | ||
3 | `target` varchar(36) default NULL, | ||
4 | `server` varchar(64) default NULL, | ||
5 | `method` varchar(64) default NULL, | ||
6 | `arguments` varchar(255) default NULL, | ||
7 | `priority` int(11) default NULL, | ||
8 | `message` text, | ||
9 | PRIMARY KEY (`logID`) | ||
10 | ) 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 @@ | |||
1 | CREATE TABLE `regions` ( | ||
2 | `uuid` varchar(36) NOT NULL, | ||
3 | `regionHandle` bigint(20) unsigned NOT NULL, | ||
4 | `regionName` varchar(32) default NULL, | ||
5 | `regionRecvKey` varchar(128) default NULL, | ||
6 | `regionSendKey` varchar(128) default NULL, | ||
7 | `regionSecret` varchar(128) default NULL, | ||
8 | `regionDataURI` varchar(255) default NULL, | ||
9 | `serverIP` varchar(64) default NULL, | ||
10 | `serverPort` int(10) unsigned default NULL, | ||
11 | `serverURI` varchar(255) default NULL, | ||
12 | `locX` int(10) unsigned default NULL, | ||
13 | `locY` int(10) unsigned default NULL, | ||
14 | `locZ` int(10) unsigned default NULL, | ||
15 | `eastOverrideHandle` bigint(20) unsigned default NULL, | ||
16 | `westOverrideHandle` bigint(20) unsigned default NULL, | ||
17 | `southOverrideHandle` bigint(20) unsigned default NULL, | ||
18 | `northOverrideHandle` bigint(20) unsigned default NULL, | ||
19 | `regionAssetURI` varchar(255) default NULL, | ||
20 | `regionAssetRecvKey` varchar(128) default NULL, | ||
21 | `regionAssetSendKey` varchar(128) default NULL, | ||
22 | `regionUserURI` varchar(255) default NULL, | ||
23 | `regionUserRecvKey` varchar(128) default NULL, | ||
24 | `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL, | ||
25 | `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL, | ||
26 | `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | ||
27 | `originUUID` varchar(36), | ||
28 | PRIMARY KEY (`uuid`), | ||
29 | KEY `regionName` (`regionName`), | ||
30 | KEY `regionHandle` (`regionHandle`), | ||
31 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) | ||
32 | ) 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 @@ | |||
1 | SET FOREIGN_KEY_CHECKS=0; | ||
2 | -- ---------------------------- | ||
3 | -- Table structure for users | ||
4 | -- ---------------------------- | ||
5 | CREATE TABLE `userfriends` ( | ||
6 | `ownerID` VARCHAR(37) NOT NULL, | ||
7 | `friendID` VARCHAR(37) NOT NULL, | ||
8 | `friendPerms` INT NOT NULL, | ||
9 | `datetimestamp` INT NOT NULL, | ||
10 | UNIQUE KEY (`ownerID`, `friendID`) | ||
11 | ) 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 @@ | |||
1 | SET FOREIGN_KEY_CHECKS=0; | ||
2 | -- ---------------------------- | ||
3 | -- Table structure for users | ||
4 | -- ---------------------------- | ||
5 | CREATE TABLE `users` ( | ||
6 | `UUID` varchar(36) NOT NULL default '', | ||
7 | `username` varchar(32) NOT NULL, | ||
8 | `lastname` varchar(32) NOT NULL, | ||
9 | `passwordHash` varchar(32) NOT NULL, | ||
10 | `passwordSalt` varchar(32) NOT NULL, | ||
11 | `homeRegion` bigint(20) unsigned default NULL, | ||
12 | `homeLocationX` float default NULL, | ||
13 | `homeLocationY` float default NULL, | ||
14 | `homeLocationZ` float default NULL, | ||
15 | `homeLookAtX` float default NULL, | ||
16 | `homeLookAtY` float default NULL, | ||
17 | `homeLookAtZ` float default NULL, | ||
18 | `created` int(11) NOT NULL, | ||
19 | `lastLogin` int(11) NOT NULL, | ||
20 | `userInventoryURI` varchar(255) default NULL, | ||
21 | `userAssetURI` varchar(255) default NULL, | ||
22 | `profileCanDoMask` int(10) unsigned default NULL, | ||
23 | `profileWantDoMask` int(10) unsigned default NULL, | ||
24 | `profileAboutText` text, | ||
25 | `profileFirstText` text, | ||
26 | `profileImage` varchar(36) default NULL, | ||
27 | `profileFirstImage` varchar(36) default NULL, | ||
28 | `webLoginKey` varchar(36) default NULL, | ||
29 | PRIMARY KEY (`UUID`), | ||
30 | UNIQUE KEY `usernames` (`username`,`lastname`) | ||
31 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; | ||
32 | |||
33 | -- ---------------------------- | ||
34 | -- Records | ||
35 | -- ---------------------------- | ||
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 @@ | |||
1 | ALTER TABLE `inventoryfolders` | ||
2 | ADD COLUMN `type` smallint NOT NULL default 0, | ||
3 | ADD COLUMN `version` int NOT NULL default 0, | ||
4 | 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 @@ | |||
1 | ALTER TABLE `inventoryitems` | ||
2 | CHANGE COLUMN `type` `assetType` int(11) default NULL, | ||
3 | ADD COLUMN `invType` int(11) default NULL, | ||
4 | ADD COLUMN `creatorID` varchar(36) default NULL, | ||
5 | ADD COLUMN `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | ||
6 | ADD COLUMN `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | ||
7 | COMMENT='Rev. 2'; | ||
8 | |||
9 | 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 @@ | |||
1 | ALTER TABLE `inventoryitems` | ||
2 | ADD COLUMN `salePrice` int(11) NOT NULL default 0, | ||
3 | ADD COLUMN `saleType` tinyint(4) NOT NULL default 0, | ||
4 | ADD COLUMN `creationDate` int(11) NOT NULL default 0, | ||
5 | ADD COLUMN `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
6 | ADD COLUMN `groupOwned` tinyint(4) NOT NULL default 0, | ||
7 | ADD COLUMN `flags` int(11) unsigned NOT NULL default 0, | ||
8 | 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 @@ | |||
1 | ALTER TABLE `land` | ||
2 | ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | ||
3 | 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 @@ | |||
1 | ALTER TABLE `regions` | ||
2 | ADD COLUMN `originUUID` varchar(36), | ||
3 | COMMENT='Rev. 2'; | ||
4 | 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 @@ | |||
1 | DROP PROCEDURE IF EXISTS upgraderegions3; | ||
2 | |||
3 | create procedure upgraderegions3() | ||
4 | BEGIN | ||
5 | DECLARE db_name varchar(64); | ||
6 | select database() into db_name; | ||
7 | IF ((select count(*) from information_schema.columns where table_name='regions' and column_name='owner_uuid' and table_schema=db_name) > 0) | ||
8 | THEN | ||
9 | ALTER TABLE `regions`, COMMENT='Rev. 3'; | ||
10 | ELSE | ||
11 | ALTER TABLE `regions` | ||
12 | ADD COLUMN `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null after serverRemotingPort, COMMENT='Rev. 3'; | ||
13 | END IF; | ||
14 | END; | ||
15 | |||
16 | call upgraderegions3(); | ||
17 | |||
18 | |||
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 @@ | |||
1 | ALTER TABLE `users` | ||
2 | ADD COLUMN `webLoginKey` varchar(36) default '00000000-0000-0000-0000-000000000000' NOT NULL, | ||
3 | COMMENT='Rev. 2'; \ No newline at end of file | ||