diff options
author | Diva Canto | 2016-02-20 19:08:02 -0800 |
---|---|---|
committer | Diva Canto | 2016-02-20 19:27:12 -0800 |
commit | 134e94a7e91adb7b4eb153c2df9b70096c4edfb4 (patch) | |
tree | 8cbff3cb2cd6114f505e34e289afed1f76ad3116 /OpenSim/Data | |
parent | Merge branch 'master' of opensimulator.org:/var/git/opensim (diff) | |
download | opensim-SC_OLD-134e94a7e91adb7b4eb153c2df9b70096c4edfb4.zip opensim-SC_OLD-134e94a7e91adb7b4eb153c2df9b70096c4edfb4.tar.gz opensim-SC_OLD-134e94a7e91adb7b4eb153c2df9b70096c4edfb4.tar.bz2 opensim-SC_OLD-134e94a7e91adb7b4eb153c2df9b70096c4edfb4.tar.xz |
Flatten migrations for MySQL.
Conflicts:
OpenSim/Data/MySQL/Resources/RegionStore.migrations
OpenSim/Data/MySQL/Resources/UserAccount.migrations
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/AssetStore.migrations | 76 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/AuthStore.migrations | 37 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Avatar.migrations | 23 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 80 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/FriendsStore.migrations | 36 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/GridStore.migrations | 139 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/IM_Store.migrations | 46 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/InventoryStore.migrations | 137 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 37 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 1087 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserAccount.migrations | 64 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserProfiles.migrations | 16 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserStore.migrations | 168 |
13 files changed, 432 insertions, 1514 deletions
diff --git a/OpenSim/Data/MySQL/Resources/AssetStore.migrations b/OpenSim/Data/MySQL/Resources/AssetStore.migrations index 661d825..820799d 100644 --- a/OpenSim/Data/MySQL/Resources/AssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/AssetStore.migrations | |||
@@ -1,81 +1,21 @@ | |||
1 | # ----------------- | 1 | # ----------------- |
2 | :VERSION 1 | 2 | :VERSION 10 |
3 | 3 | ||
4 | BEGIN; | 4 | BEGIN; |
5 | 5 | ||
6 | CREATE TABLE `assets` ( | 6 | CREATE TABLE IF NOT EXISTS `assets` ( |
7 | `id` binary(16) NOT NULL, | ||
8 | `name` varchar(64) NOT NULL, | 7 | `name` varchar(64) NOT NULL, |
9 | `description` varchar(64) NOT NULL, | 8 | `description` varchar(64) NOT NULL, |
10 | `assetType` tinyint(4) NOT NULL, | 9 | `assetType` tinyint(4) NOT NULL, |
11 | `invType` tinyint(4) NOT NULL, | ||
12 | `local` tinyint(1) NOT NULL, | 10 | `local` tinyint(1) NOT NULL, |
13 | `temporary` tinyint(1) NOT NULL, | 11 | `temporary` tinyint(1) NOT NULL, |
14 | `data` longblob NOT NULL, | 12 | `data` longblob NOT NULL, |
13 | `id` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
14 | `create_time` int(11) DEFAULT '0', | ||
15 | `access_time` int(11) DEFAULT '0', | ||
16 | `asset_flags` int(11) NOT NULL DEFAULT '0', | ||
17 | `CreatorID` varchar(128) NOT NULL DEFAULT '', | ||
15 | PRIMARY KEY (`id`) | 18 | PRIMARY KEY (`id`) |
16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
17 | 20 | ||
18 | COMMIT; | 21 | COMMIT; |
19 | |||
20 | # ----------------- | ||
21 | :VERSION 2 | ||
22 | |||
23 | BEGIN; | ||
24 | |||
25 | ALTER TABLE assets change id oldid binary(16); | ||
26 | ALTER TABLE assets add id varchar(36) not null default ''; | ||
27 | UPDATE assets set id = concat(substr(hex(oldid),1,8),"-",substr(hex(oldid),9,4),"-",substr(hex(oldid),13,4),"-",substr(hex(oldid),17,4),"-",substr(hex(oldid),21,12)); | ||
28 | ALTER TABLE assets drop oldid; | ||
29 | ALTER TABLE assets add constraint primary key(id); | ||
30 | |||
31 | COMMIT; | ||
32 | |||
33 | # ----------------- | ||
34 | :VERSION 3 | ||
35 | |||
36 | BEGIN; | ||
37 | |||
38 | ALTER TABLE assets change id oldid varchar(36); | ||
39 | ALTER TABLE assets add id char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
40 | UPDATE assets set id = oldid; | ||
41 | ALTER TABLE assets drop oldid; | ||
42 | ALTER TABLE assets add constraint primary key(id); | ||
43 | |||
44 | COMMIT; | ||
45 | |||
46 | # ----------------- | ||
47 | :VERSION 4 | ||
48 | |||
49 | BEGIN; | ||
50 | |||
51 | ALTER TABLE assets drop InvType; | ||
52 | |||
53 | COMMIT; | ||
54 | |||
55 | # ----------------- | ||
56 | :VERSION 5 | ||
57 | |||
58 | BEGIN; | ||
59 | |||
60 | ALTER TABLE assets add create_time integer default 0; | ||
61 | ALTER TABLE assets add access_time integer default 0; | ||
62 | |||
63 | COMMIT; | ||
64 | |||
65 | # ----------------- | ||
66 | :VERSION 6 | ||
67 | |||
68 | DELETE FROM assets WHERE id = 'dc4b9f0b-d008-45c6-96a4-01dd947ac621' | ||
69 | |||
70 | :VERSION 7 | ||
71 | |||
72 | ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0; | ||
73 | |||
74 | :VERSION 8 | ||
75 | |||
76 | ALTER TABLE assets ADD COLUMN CreatorID varchar(128) NOT NULL DEFAULT ''; | ||
77 | |||
78 | :VERSION 9 | ||
79 | |||
80 | BEGIN; | ||
81 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/AuthStore.migrations b/OpenSim/Data/MySQL/Resources/AuthStore.migrations index 023c786..f00979f 100644 --- a/OpenSim/Data/MySQL/Resources/AuthStore.migrations +++ b/OpenSim/Data/MySQL/Resources/AuthStore.migrations | |||
@@ -1,16 +1,17 @@ | |||
1 | :VERSION 1 # ------------------------------- | 1 | :VERSION 4 # ------------------------------- |
2 | 2 | ||
3 | begin; | 3 | begin; |
4 | 4 | ||
5 | CREATE TABLE `auth` ( | 5 | CREATE TABLE IF NOT EXISTS `auth` ( |
6 | `UUID` char(36) NOT NULL, | 6 | `UUID` char(36) NOT NULL, |
7 | `passwordHash` char(32) NOT NULL default '', | 7 | `passwordHash` char(32) NOT NULL DEFAULT '', |
8 | `passwordSalt` char(32) NOT NULL default '', | 8 | `passwordSalt` char(32) NOT NULL DEFAULT '', |
9 | `webLoginKey` varchar(255) NOT NULL default '', | 9 | `webLoginKey` varchar(255) NOT NULL DEFAULT '', |
10 | PRIMARY KEY (`UUID`) | 10 | `accountType` varchar(32) NOT NULL DEFAULT 'UserAccount', |
11 | ) ENGINE=InnoDB; | 11 | PRIMARY KEY (`UUID`) |
12 | 12 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
13 | CREATE TABLE `tokens` ( | 13 | |
14 | CREATE TABLE IF NOT EXISTS `tokens` ( | ||
14 | `UUID` char(36) NOT NULL, | 15 | `UUID` char(36) NOT NULL, |
15 | `token` varchar(255) NOT NULL, | 16 | `token` varchar(255) NOT NULL, |
16 | `validity` datetime NOT NULL, | 17 | `validity` datetime NOT NULL, |
@@ -18,22 +19,6 @@ CREATE TABLE `tokens` ( | |||
18 | KEY `UUID` (`UUID`), | 19 | KEY `UUID` (`UUID`), |
19 | KEY `token` (`token`), | 20 | KEY `token` (`token`), |
20 | KEY `validity` (`validity`) | 21 | KEY `validity` (`validity`) |
21 | ) ENGINE=InnoDB; | 22 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
22 | |||
23 | commit; | ||
24 | |||
25 | :VERSION 2 # ------------------------------- | ||
26 | |||
27 | BEGIN; | ||
28 | |||
29 | INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users; | ||
30 | |||
31 | COMMIT; | ||
32 | |||
33 | :VERSION 3 # ------------------------------- | ||
34 | |||
35 | BEGIN; | ||
36 | |||
37 | ALTER TABLE `auth` ADD COLUMN `accountType` VARCHAR(32) NOT NULL DEFAULT 'UserAccount'; | ||
38 | 23 | ||
39 | COMMIT; | 24 | COMMIT; |
diff --git a/OpenSim/Data/MySQL/Resources/Avatar.migrations b/OpenSim/Data/MySQL/Resources/Avatar.migrations index f7cf176..07e6c68 100644 --- a/OpenSim/Data/MySQL/Resources/Avatar.migrations +++ b/OpenSim/Data/MySQL/Resources/Avatar.migrations | |||
@@ -1,20 +1,13 @@ | |||
1 | :VERSION 1 | 1 | :VERSION 3 |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE Avatars ( | 5 | CREATE TABLE IF NOT EXISTS `avatars` ( |
6 | PrincipalID CHAR(36) NOT NULL, | 6 | `PrincipalID` char(36) NOT NULL, |
7 | Name VARCHAR(32) NOT NULL, | 7 | `Name` varchar(32) NOT NULL, |
8 | Value VARCHAR(255) NOT NULL DEFAULT '', | 8 | `Value` text, |
9 | PRIMARY KEY(PrincipalID, Name), | 9 | PRIMARY KEY (`PrincipalID`,`Name`), |
10 | KEY(PrincipalID)); | 10 | KEY `PrincipalID` (`PrincipalID`) |
11 | 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
12 | COMMIT; | ||
13 | |||
14 | :VERSION 2 | ||
15 | |||
16 | BEGIN; | ||
17 | |||
18 | alter table Avatars change column Value Value text; | ||
19 | 12 | ||
20 | COMMIT; | 13 | COMMIT; |
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 2d1c2b5..615af95 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -1,41 +1,29 @@ | |||
1 | :VERSION 13 | 1 | :VERSION 34 |
2 | |||
3 | # The estate migrations used to be in Region store | ||
4 | # here they will do nothing (bad) if the tables are already there, | ||
5 | # just update the store version. | ||
6 | 2 | ||
7 | BEGIN; | 3 | BEGIN; |
8 | 4 | ||
9 | CREATE TABLE IF NOT EXISTS `estate_managers` ( | ||
10 | `EstateID` int(10) unsigned NOT NULL, | ||
11 | `uuid` char(36) NOT NULL, | ||
12 | KEY `EstateID` (`EstateID`) | ||
13 | ) ENGINE=InnoDB; | ||
14 | |||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | 5 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
16 | `EstateID` int(10) unsigned NOT NULL, | 6 | `EstateID` int(10) unsigned NOT NULL, |
17 | `uuid` char(36) NOT NULL, | 7 | `uuid` char(36) NOT NULL, |
18 | KEY `EstateID` (`EstateID`) | 8 | KEY `EstateID` (`EstateID`) |
19 | ) ENGINE=InnoDB; | 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
20 | 10 | ||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 11 | CREATE TABLE IF NOT EXISTS `estate_managers` ( |
22 | `EstateID` int(10) unsigned NOT NULL, | 12 | `EstateID` int(10) unsigned NOT NULL, |
23 | `uuid` char(36) NOT NULL, | 13 | `uuid` char(36) NOT NULL, |
24 | KEY `EstateID` (`EstateID`) | 14 | KEY `EstateID` (`EstateID`) |
25 | ) ENGINE=InnoDB; | 15 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
26 | 16 | ||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( | 17 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
28 | `EstateID` int(10) unsigned NOT NULL, | 18 | `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
29 | `bannedUUID` varchar(36) NOT NULL, | 19 | `EstateID` int(11) NOT NULL, |
30 | `bannedIp` varchar(16) NOT NULL, | 20 | PRIMARY KEY (`RegionID`), |
31 | `bannedIpHostMask` varchar(16) NOT NULL, | 21 | KEY `EstateID` (`EstateID`) |
32 | `bannedNameMask` varchar(64) default NULL, | 22 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
33 | KEY `estateban_EstateID` (`EstateID`) | ||
34 | ) ENGINE=InnoDB; | ||
35 | 23 | ||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 24 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, | 25 | `EstateID` int(10) unsigned NOT NULL AUTO_INCREMENT, |
38 | `EstateName` varchar(64) default NULL, | 26 | `EstateName` varchar(64) DEFAULT NULL, |
39 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, | 27 | `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, |
40 | `DenyAnonymous` tinyint(4) NOT NULL, | 28 | `DenyAnonymous` tinyint(4) NOT NULL, |
41 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, | 29 | `ResetHomeOnTeleport` tinyint(4) NOT NULL, |
@@ -55,33 +43,29 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
55 | `EstateSkipScripts` tinyint(4) NOT NULL, | 43 | `EstateSkipScripts` tinyint(4) NOT NULL, |
56 | `BillableFactor` float NOT NULL, | 44 | `BillableFactor` float NOT NULL, |
57 | `PublicAccess` tinyint(4) NOT NULL, | 45 | `PublicAccess` tinyint(4) NOT NULL, |
58 | `AbuseEmail` varchar(255) not null, | 46 | `AbuseEmail` varchar(255) NOT NULL, |
59 | `EstateOwner` varchar(36) not null, | 47 | `EstateOwner` varchar(36) NOT NULL, |
60 | `DenyMinors` tinyint not null, | 48 | `DenyMinors` tinyint(4) NOT NULL, |
61 | 49 | `AllowLandmark` tinyint(4) NOT NULL DEFAULT '1', | |
62 | PRIMARY KEY (`EstateID`) | 50 | `AllowParcelChanges` tinyint(4) NOT NULL DEFAULT '1', |
63 | ) ENGINE=InnoDB AUTO_INCREMENT=100; | 51 | `AllowSetHome` tinyint(4) NOT NULL DEFAULT '1', |
52 | PRIMARY KEY (`EstateID`) | ||
53 | ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; | ||
64 | 54 | ||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 55 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 56 | `EstateID` int(10) unsigned NOT NULL, |
67 | `EstateID` int(11) NOT NULL, | 57 | `uuid` char(36) NOT NULL, |
68 | PRIMARY KEY (`RegionID`), | ||
69 | KEY `EstateID` (`EstateID`) | 58 | KEY `EstateID` (`EstateID`) |
70 | ) ENGINE=InnoDB; | 59 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
71 | 60 | ||
72 | COMMIT; | 61 | CREATE TABLE IF NOT EXISTS `estateban` ( |
73 | 62 | `EstateID` int(10) unsigned NOT NULL, | |
74 | :VERSION 32 #--------------------- (moved from RegionStore migr, just in case) | 63 | `bannedUUID` varchar(36) NOT NULL, |
75 | 64 | `bannedIp` varchar(16) NOT NULL, | |
76 | BEGIN; | 65 | `bannedIpHostMask` varchar(16) NOT NULL, |
77 | ALTER TABLE estate_settings AUTO_INCREMENT = 100; | 66 | `bannedNameMask` varchar(64) DEFAULT NULL, |
78 | COMMIT; | 67 | KEY `estateban_EstateID` (`EstateID`) |
79 | 68 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
80 | :VERSION 33 #--------------------- | ||
81 | 69 | ||
82 | BEGIN; | ||
83 | ALTER TABLE estate_settings ADD COLUMN `AllowLandmark` tinyint(4) NOT NULL default '1'; | ||
84 | ALTER TABLE estate_settings ADD COLUMN `AllowParcelChanges` tinyint(4) NOT NULL default '1'; | ||
85 | ALTER TABLE estate_settings ADD COLUMN `AllowSetHome` tinyint(4) NOT NULL default '1'; | ||
86 | COMMIT; | 70 | COMMIT; |
87 | 71 | ||
diff --git a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations index 5faf956..8e304de 100644 --- a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations +++ b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations | |||
@@ -1,32 +1,14 @@ | |||
1 | :VERSION 1 # ------------------------- | 1 | :VERSION 4 # ------------------------- |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `Friends` ( | 5 | CREATE TABLE IF NOT EXISTS `friends` ( |
6 | `PrincipalID` CHAR(36) NOT NULL, | 6 | `PrincipalID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
7 | `Friend` VARCHAR(255) NOT NULL, | 7 | `Friend` varchar(255) NOT NULL, |
8 | `Flags` VARCHAR(16) NOT NULL DEFAULT 0, | 8 | `Flags` varchar(16) NOT NULL DEFAULT '0', |
9 | `Offered` VARCHAR(32) NOT NULL DEFAULT 0, | 9 | `Offered` varchar(32) NOT NULL DEFAULT '0', |
10 | PRIMARY KEY(`PrincipalID`, `Friend`), | 10 | PRIMARY KEY (`PrincipalID`(36),`Friend`(36)), |
11 | KEY(`PrincipalID`) | 11 | KEY `PrincipalID` (`PrincipalID`) |
12 | ) ENGINE=InnoDB; | 12 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
13 | |||
14 | COMMIT; | ||
15 | |||
16 | :VERSION 2 # ------------------------- | ||
17 | |||
18 | BEGIN; | ||
19 | |||
20 | INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`; | ||
21 | |||
22 | COMMIT; | ||
23 | |||
24 | :VERSION 3 # ------------------------- | ||
25 | |||
26 | BEGIN; | ||
27 | |||
28 | ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
29 | ALTER TABLE `Friends` DROP PRIMARY KEY; | ||
30 | ALTER TABLE `Friends` ADD PRIMARY KEY(PrincipalID(36), Friend(36)); | ||
31 | 13 | ||
32 | COMMIT; | 14 | COMMIT; |
diff --git a/OpenSim/Data/MySQL/Resources/GridStore.migrations b/OpenSim/Data/MySQL/Resources/GridStore.migrations index b8d287a..e4c8fc3 100644 --- a/OpenSim/Data/MySQL/Resources/GridStore.migrations +++ b/OpenSim/Data/MySQL/Resources/GridStore.migrations | |||
@@ -1,109 +1,52 @@ | |||
1 | :VERSION 1 | 1 | :VERSION 10 |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `regions` ( | 5 | CREATE TABLE IF NOT EXISTS `regions` ( |
6 | `uuid` varchar(36) NOT NULL, | 6 | `uuid` varchar(36) NOT NULL, |
7 | `regionHandle` bigint(20) unsigned NOT NULL, | 7 | `regionHandle` bigint(20) unsigned NOT NULL, |
8 | `regionName` varchar(32) default NULL, | 8 | `regionName` varchar(128) DEFAULT NULL, |
9 | `regionRecvKey` varchar(128) default NULL, | 9 | `regionRecvKey` varchar(128) DEFAULT NULL, |
10 | `regionSendKey` varchar(128) default NULL, | 10 | `regionSendKey` varchar(128) DEFAULT NULL, |
11 | `regionSecret` varchar(128) default NULL, | 11 | `regionSecret` varchar(128) DEFAULT NULL, |
12 | `regionDataURI` varchar(255) default NULL, | 12 | `regionDataURI` varchar(255) DEFAULT NULL, |
13 | `serverIP` varchar(64) default NULL, | 13 | `serverIP` varchar(64) DEFAULT NULL, |
14 | `serverPort` int(10) unsigned default NULL, | 14 | `serverPort` int(10) unsigned DEFAULT NULL, |
15 | `serverURI` varchar(255) default NULL, | 15 | `serverURI` varchar(255) DEFAULT NULL, |
16 | `locX` int(10) unsigned default NULL, | 16 | `locX` int(10) unsigned DEFAULT NULL, |
17 | `locY` int(10) unsigned default NULL, | 17 | `locY` int(10) unsigned DEFAULT NULL, |
18 | `locZ` int(10) unsigned default NULL, | 18 | `locZ` int(10) unsigned DEFAULT NULL, |
19 | `eastOverrideHandle` bigint(20) unsigned default NULL, | 19 | `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL, |
20 | `westOverrideHandle` bigint(20) unsigned default NULL, | 20 | `westOverrideHandle` bigint(20) unsigned DEFAULT NULL, |
21 | `southOverrideHandle` bigint(20) unsigned default NULL, | 21 | `southOverrideHandle` bigint(20) unsigned DEFAULT NULL, |
22 | `northOverrideHandle` bigint(20) unsigned default NULL, | 22 | `northOverrideHandle` bigint(20) unsigned DEFAULT NULL, |
23 | `regionAssetURI` varchar(255) default NULL, | 23 | `regionAssetURI` varchar(255) DEFAULT NULL, |
24 | `regionAssetRecvKey` varchar(128) default NULL, | 24 | `regionAssetRecvKey` varchar(128) DEFAULT NULL, |
25 | `regionAssetSendKey` varchar(128) default NULL, | 25 | `regionAssetSendKey` varchar(128) DEFAULT NULL, |
26 | `regionUserURI` varchar(255) default NULL, | 26 | `regionUserURI` varchar(255) DEFAULT NULL, |
27 | `regionUserRecvKey` varchar(128) default NULL, | 27 | `regionUserRecvKey` varchar(128) DEFAULT NULL, |
28 | `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL, | 28 | `regionUserSendKey` varchar(128) DEFAULT NULL, |
29 | `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL, | 29 | `regionMapTexture` varchar(36) DEFAULT NULL, |
30 | `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | 30 | `serverHttpPort` int(10) DEFAULT NULL, |
31 | `originUUID` varchar(36), | 31 | `serverRemotingPort` int(10) DEFAULT NULL, |
32 | PRIMARY KEY (`uuid`), | 32 | `owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
33 | `originUUID` varchar(36) DEFAULT NULL, | ||
34 | `access` int(10) unsigned DEFAULT '1', | ||
35 | `ScopeID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
36 | `sizeX` int(11) NOT NULL DEFAULT '0', | ||
37 | `sizeY` int(11) NOT NULL DEFAULT '0', | ||
38 | `flags` int(11) NOT NULL DEFAULT '0', | ||
39 | `last_seen` int(11) NOT NULL DEFAULT '0', | ||
40 | `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
41 | `Token` varchar(255) NOT NULL, | ||
42 | `parcelMapTexture` varchar(36) DEFAULT NULL, | ||
43 | PRIMARY KEY (`uuid`), | ||
33 | KEY `regionName` (`regionName`), | 44 | KEY `regionName` (`regionName`), |
34 | KEY `regionHandle` (`regionHandle`), | 45 | KEY `regionHandle` (`regionHandle`), |
35 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) | 46 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`), |
47 | KEY `ScopeID` (`ScopeID`), | ||
48 | KEY `flags` (`flags`) | ||
36 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
37 | 50 | ||
38 | COMMIT; | 51 | COMMIT; |
39 | 52 | ||
40 | :VERSION 2 | ||
41 | |||
42 | BEGIN; | ||
43 | |||
44 | ALTER TABLE regions add column access integer unsigned default 1; | ||
45 | |||
46 | COMMIT; | ||
47 | |||
48 | :VERSION 3 | ||
49 | |||
50 | BEGIN; | ||
51 | |||
52 | ALTER TABLE regions add column ScopeID char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
53 | |||
54 | create index ScopeID on regions(ScopeID); | ||
55 | |||
56 | COMMIT; | ||
57 | |||
58 | :VERSION 4 | ||
59 | |||
60 | BEGIN; | ||
61 | |||
62 | ALTER TABLE regions add column sizeX integer not null default 0; | ||
63 | ALTER TABLE regions add column sizeY integer not null default 0; | ||
64 | |||
65 | COMMIT; | ||
66 | |||
67 | :VERSION 5 | ||
68 | |||
69 | BEGIN; | ||
70 | |||
71 | ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0; | ||
72 | CREATE INDEX flags ON regions(flags); | ||
73 | |||
74 | COMMIT; | ||
75 | |||
76 | :VERSION 6 | ||
77 | |||
78 | BEGIN; | ||
79 | |||
80 | ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0; | ||
81 | |||
82 | COMMIT; | ||
83 | |||
84 | :VERSION 7 | ||
85 | |||
86 | BEGIN; | ||
87 | |||
88 | ALTER TABLE `regions` ADD COLUMN `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
89 | ALTER TABLE `regions` ADD COLUMN `Token` varchar(255) NOT NULL; | ||
90 | |||
91 | COMMIT; | ||
92 | |||
93 | |||
94 | :VERSION 8 # ------------ | ||
95 | |||
96 | BEGIN; | ||
97 | |||
98 | alter table regions modify column regionName varchar(128) default NULL; | ||
99 | |||
100 | COMMIT; | ||
101 | |||
102 | :VERSION 9 # ------------ | ||
103 | |||
104 | BEGIN; | ||
105 | |||
106 | alter table regions add column `parcelMapTexture` varchar(36) default NULL; | ||
107 | |||
108 | COMMIT; | ||
109 | |||
diff --git a/OpenSim/Data/MySQL/Resources/IM_Store.migrations b/OpenSim/Data/MySQL/Resources/IM_Store.migrations index 79ead98..e271fcc 100644 --- a/OpenSim/Data/MySQL/Resources/IM_Store.migrations +++ b/OpenSim/Data/MySQL/Resources/IM_Store.migrations | |||
@@ -1,42 +1,16 @@ | |||
1 | :VERSION 1 # -------------------------- | 1 | :VERSION 5 # -------------------------- |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `im_offline` ( | 5 | CREATE TABLE IF NOT EXISTS `im_offline` ( |
6 | `ID` MEDIUMINT NOT NULL AUTO_INCREMENT, | 6 | `ID` mediumint(9) NOT NULL AUTO_INCREMENT, |
7 | `PrincipalID` char(36) NOT NULL default '', | 7 | `PrincipalID` char(36) NOT NULL DEFAULT '', |
8 | `FromID` char(36) NOT NULL DEFAULT '', | ||
8 | `Message` text NOT NULL, | 9 | `Message` text NOT NULL, |
9 | `TMStamp` timestamp NOT NULL, | 10 | `TMStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
10 | PRIMARY KEY (`ID`), | 11 | PRIMARY KEY (`ID`), |
11 | KEY `PrincipalID` (`PrincipalID`) | 12 | KEY `PrincipalID` (`PrincipalID`), |
12 | ) ENGINE=MyISAM; | 13 | KEY `FromID` (`FromID`) |
13 | 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
14 | COMMIT; | ||
15 | |||
16 | :VERSION 2 # -------------------------- | ||
17 | |||
18 | BEGIN; | ||
19 | |||
20 | INSERT INTO `im_offline` SELECT * from `diva_im_offline`; | ||
21 | DROP TABLE `diva_im_offline`; | ||
22 | DELETE FROM `migrations` WHERE name='diva_im_Store'; | ||
23 | |||
24 | COMMIT; | ||
25 | |||
26 | :VERSION 3 # -------------------------- | ||
27 | |||
28 | BEGIN; | ||
29 | |||
30 | ALTER TABLE `im_offline` | ||
31 | ADD `FromID` char(36) NOT NULL default '' AFTER `PrincipalID`, | ||
32 | ADD KEY `FromID` (`FromID`); | ||
33 | |||
34 | COMMIT; | ||
35 | |||
36 | :VERSION 4 # -------------------------- | ||
37 | |||
38 | BEGIN; | ||
39 | |||
40 | ALTER TABLE im_offline CONVERT TO CHARACTER SET utf8; | ||
41 | 15 | ||
42 | COMMIT; | 16 | COMMIT; |
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 993a5a0..2d4384c 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |||
@@ -1,109 +1,42 @@ | |||
1 | :VERSION 1 # ------------ | 1 | :VERSION 7 # ------------ |
2 | BEGIN; | 2 | BEGIN; |
3 | 3 | ||
4 | CREATE TABLE `inventoryfolders` ( | 4 | CREATE TABLE IF NOT EXISTS `inventoryitems` ( |
5 | `folderID` varchar(36) NOT NULL default '', | 5 | `assetID` varchar(36) DEFAULT NULL, |
6 | `agentID` varchar(36) default NULL, | 6 | `assetType` int(11) DEFAULT NULL, |
7 | `parentFolderID` varchar(36) default NULL, | 7 | `inventoryName` varchar(64) DEFAULT NULL, |
8 | `folderName` varchar(64) default NULL, | 8 | `inventoryDescription` varchar(128) DEFAULT NULL, |
9 | `type` smallint NOT NULL default 0, | 9 | `inventoryNextPermissions` int(10) unsigned DEFAULT NULL, |
10 | `version` int NOT NULL default 0, | 10 | `inventoryCurrentPermissions` int(10) unsigned DEFAULT NULL, |
11 | PRIMARY KEY (`folderID`), | 11 | `invType` int(11) DEFAULT NULL, |
12 | KEY `owner` (`agentID`), | 12 | `creatorID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
13 | KEY `parent` (`parentFolderID`) | 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 | `inventoryID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
22 | `avatarID` char(36) DEFAULT NULL, | ||
23 | `parentFolderID` char(36) DEFAULT NULL, | ||
24 | `inventoryGroupPermissions` int(10) unsigned NOT NULL DEFAULT '0', | ||
25 | PRIMARY KEY (`inventoryID`), | ||
26 | KEY `inventoryitems_avatarid` (`avatarID`), | ||
27 | KEY `inventoryitems_parentFolderid` (`parentFolderID`) | ||
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 28 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
15 | 29 | ||
16 | CREATE TABLE `inventoryitems` ( | 30 | CREATE TABLE IF NOT EXISTS `inventoryfolders` ( |
17 | `inventoryID` varchar(36) NOT NULL default '', | 31 | `folderName` varchar(64) DEFAULT NULL, |
18 | `assetID` varchar(36) default NULL, | 32 | `type` smallint(6) NOT NULL DEFAULT '0', |
19 | `assetType` int(11) default NULL, | 33 | `version` int(11) NOT NULL DEFAULT '0', |
20 | `parentFolderID` varchar(36) default NULL, | 34 | `folderID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
21 | `avatarID` varchar(36) default NULL, | 35 | `agentID` char(36) DEFAULT NULL, |
22 | `inventoryName` varchar(64) default NULL, | 36 | `parentFolderID` char(36) DEFAULT NULL, |
23 | `inventoryDescription` varchar(128) default NULL, | 37 | PRIMARY KEY (`folderID`), |
24 | `inventoryNextPermissions` int(10) unsigned default NULL, | 38 | KEY `inventoryfolders_agentid` (`agentID`), |
25 | `inventoryCurrentPermissions` int(10) unsigned default NULL, | 39 | KEY `inventoryfolders_parentFolderid` (`parentFolderID`) |
26 | `invType` int(11) default NULL, | ||
27 | `creatorID` varchar(36) default NULL, | ||
28 | `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, | ||
29 | `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, | ||
30 | `salePrice` int(11) NOT NULL default 0, | ||
31 | `saleType` tinyint(4) NOT NULL default 0, | ||
32 | `creationDate` int(11) NOT NULL default 0, | ||
33 | `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | ||
34 | `groupOwned` tinyint(4) NOT NULL default 0, | ||
35 | `flags` int(11) unsigned NOT NULL default 0, | ||
36 | PRIMARY KEY (`inventoryID`), | ||
37 | KEY `owner` (`avatarID`), | ||
38 | KEY `folder` (`parentFolderID`) | ||
39 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
40 | 41 | ||
41 | COMMIT; | 42 | COMMIT; |
42 | |||
43 | :VERSION 2 # ------------ | ||
44 | |||
45 | BEGIN; | ||
46 | |||
47 | ALTER TABLE inventoryfolders change folderID folderIDold varchar(36); | ||
48 | ALTER TABLE inventoryfolders change agentID agentIDold varchar(36); | ||
49 | ALTER TABLE inventoryfolders change parentFolderID parentFolderIDold varchar(36); | ||
50 | ALTER TABLE inventoryfolders add folderID char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
51 | ALTER TABLE inventoryfolders add agentID char(36) default NULL; | ||
52 | ALTER TABLE inventoryfolders add parentFolderID char(36) default NULL; | ||
53 | UPDATE inventoryfolders set folderID = folderIDold, agentID = agentIDold, parentFolderID = parentFolderIDold; | ||
54 | ALTER TABLE inventoryfolders drop folderIDold; | ||
55 | ALTER TABLE inventoryfolders drop agentIDold; | ||
56 | ALTER TABLE inventoryfolders drop parentFolderIDold; | ||
57 | ALTER TABLE inventoryfolders add constraint primary key(folderID); | ||
58 | ALTER TABLE inventoryfolders add index inventoryfolders_agentid(agentID); | ||
59 | ALTER TABLE inventoryfolders add index inventoryfolders_parentFolderid(parentFolderID); | ||
60 | |||
61 | ALTER TABLE inventoryitems change inventoryID inventoryIDold varchar(36); | ||
62 | ALTER TABLE inventoryitems change avatarID avatarIDold varchar(36); | ||
63 | ALTER TABLE inventoryitems change parentFolderID parentFolderIDold varchar(36); | ||
64 | ALTER TABLE inventoryitems add inventoryID char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
65 | ALTER TABLE inventoryitems add avatarID char(36) default NULL; | ||
66 | ALTER TABLE inventoryitems add parentFolderID char(36) default NULL; | ||
67 | UPDATE inventoryitems set inventoryID = inventoryIDold, avatarID = avatarIDold, parentFolderID = parentFolderIDold; | ||
68 | ALTER TABLE inventoryitems drop inventoryIDold; | ||
69 | ALTER TABLE inventoryitems drop avatarIDold; | ||
70 | ALTER TABLE inventoryitems drop parentFolderIDold; | ||
71 | ALTER TABLE inventoryitems add constraint primary key(inventoryID); | ||
72 | ALTER TABLE inventoryitems add index inventoryitems_avatarid(avatarID); | ||
73 | ALTER TABLE inventoryitems add index inventoryitems_parentFolderid(parentFolderID); | ||
74 | |||
75 | COMMIT; | ||
76 | |||
77 | :VERSION 3 # ------------ | ||
78 | |||
79 | BEGIN; | ||
80 | |||
81 | alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; | ||
82 | |||
83 | COMMIT; | ||
84 | |||
85 | :VERSION 4 # ------------ | ||
86 | |||
87 | BEGIN; | ||
88 | |||
89 | update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID is NULL; | ||
90 | update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID = ''; | ||
91 | alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000'; | ||
92 | |||
93 | COMMIT; | ||
94 | |||
95 | :VERSION 5 # ------------ | ||
96 | |||
97 | BEGIN; | ||
98 | |||
99 | alter table inventoryitems modify column creatorID varchar(128) not NULL default '00000000-0000-0000-0000-000000000000'; | ||
100 | |||
101 | COMMIT; | ||
102 | |||
103 | :VERSION 6 # ------------ | ||
104 | |||
105 | BEGIN; | ||
106 | |||
107 | alter table inventoryitems modify column creatorID varchar(255) not NULL default '00000000-0000-0000-0000-000000000000'; | ||
108 | |||
109 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/Presence.migrations b/OpenSim/Data/MySQL/Resources/Presence.migrations index c4e40fa..69e33e0 100644 --- a/OpenSim/Data/MySQL/Resources/Presence.migrations +++ b/OpenSim/Data/MySQL/Resources/Presence.migrations | |||
@@ -1,31 +1,16 @@ | |||
1 | :VERSION 1 # -------------------------- | 1 | :VERSION 4 # -------------------------- |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `Presence` ( | 5 | CREATE TABLE IF NOT EXISTS `presence` ( |
6 | `UserID` VARCHAR(255) NOT NULL, | 6 | `UserID` varchar(255) NOT NULL, |
7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 7 | `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 8 | `SessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' | 9 | `SecureSessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
10 | ) ENGINE=InnoDB; | 10 | `LastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
11 | 11 | UNIQUE KEY `SessionID` (`SessionID`), | |
12 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | 12 | KEY `UserID` (`UserID`), |
13 | CREATE INDEX UserID ON Presence(UserID); | 13 | KEY `RegionID` (`RegionID`) |
14 | 14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
15 | COMMIT; | ||
16 | |||
17 | :VERSION 2 # -------------------------- | ||
18 | |||
19 | BEGIN; | ||
20 | |||
21 | ALTER TABLE `Presence` ADD COLUMN LastSeen timestamp; | ||
22 | |||
23 | COMMIT; | ||
24 | |||
25 | :VERSION 3 # -------------------------- | ||
26 | |||
27 | BEGIN; | ||
28 | |||
29 | CREATE INDEX RegionID ON Presence(RegionID); | ||
30 | 15 | ||
31 | COMMIT; | 16 | COMMIT; |
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index a3d4b5d..c32f645 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -1,354 +1,226 @@ | |||
1 | 1 | ||
2 | :VERSION 1 #--------------------- | 2 | :VERSION 51 #--------------------- |
3 | 3 | ||
4 | BEGIN; | 4 | BEGIN; |
5 | 5 | ||
6 | CREATE TABLE `prims` ( | 6 | CREATE TABLE IF NOT EXISTS `prims` ( |
7 | `UUID` varchar(255) NOT NULL, | 7 | `CreationDate` int(11) DEFAULT NULL, |
8 | `RegionUUID` varchar(255) default NULL, | 8 | `Name` varchar(255) DEFAULT NULL, |
9 | `ParentID` int(11) default NULL, | 9 | `Text` varchar(255) DEFAULT NULL, |
10 | `CreationDate` int(11) default NULL, | 10 | `Description` varchar(255) DEFAULT NULL, |
11 | `Name` varchar(255) default NULL, | 11 | `SitName` varchar(255) DEFAULT NULL, |
12 | `SceneGroupID` varchar(255) default NULL, | 12 | `TouchName` varchar(255) DEFAULT NULL, |
13 | `Text` varchar(255) default NULL, | 13 | `ObjectFlags` int(11) DEFAULT NULL, |
14 | `Description` varchar(255) default NULL, | 14 | `OwnerMask` int(11) DEFAULT NULL, |
15 | `SitName` varchar(255) default NULL, | 15 | `NextOwnerMask` int(11) DEFAULT NULL, |
16 | `TouchName` varchar(255) default NULL, | 16 | `GroupMask` int(11) DEFAULT NULL, |
17 | `ObjectFlags` int(11) default NULL, | 17 | `EveryoneMask` int(11) DEFAULT NULL, |
18 | `CreatorID` varchar(255) default NULL, | 18 | `BaseMask` int(11) DEFAULT NULL, |
19 | `OwnerID` varchar(255) default NULL, | 19 | `PositionX` double DEFAULT NULL, |
20 | `GroupID` varchar(255) default NULL, | 20 | `PositionY` double DEFAULT NULL, |
21 | `LastOwnerID` varchar(255) default NULL, | 21 | `PositionZ` double DEFAULT NULL, |
22 | `OwnerMask` int(11) default NULL, | 22 | `GroupPositionX` double DEFAULT NULL, |
23 | `NextOwnerMask` int(11) default NULL, | 23 | `GroupPositionY` double DEFAULT NULL, |
24 | `GroupMask` int(11) default NULL, | 24 | `GroupPositionZ` double DEFAULT NULL, |
25 | `EveryoneMask` int(11) default NULL, | 25 | `VelocityX` double DEFAULT NULL, |
26 | `BaseMask` int(11) default NULL, | 26 | `VelocityY` double DEFAULT NULL, |
27 | `PositionX` float default NULL, | 27 | `VelocityZ` double DEFAULT NULL, |
28 | `PositionY` float default NULL, | 28 | `AngularVelocityX` double DEFAULT NULL, |
29 | `PositionZ` float default NULL, | 29 | `AngularVelocityY` double DEFAULT NULL, |
30 | `GroupPositionX` float default NULL, | 30 | `AngularVelocityZ` double DEFAULT NULL, |
31 | `GroupPositionY` float default NULL, | 31 | `AccelerationX` double DEFAULT NULL, |
32 | `GroupPositionZ` float default NULL, | 32 | `AccelerationY` double DEFAULT NULL, |
33 | `VelocityX` float default NULL, | 33 | `AccelerationZ` double DEFAULT NULL, |
34 | `VelocityY` float default NULL, | 34 | `RotationX` double DEFAULT NULL, |
35 | `VelocityZ` float default NULL, | 35 | `RotationY` double DEFAULT NULL, |
36 | `AngularVelocityX` float default NULL, | 36 | `RotationZ` double DEFAULT NULL, |
37 | `AngularVelocityY` float default NULL, | 37 | `RotationW` double DEFAULT NULL, |
38 | `AngularVelocityZ` float default NULL, | 38 | `SitTargetOffsetX` double DEFAULT NULL, |
39 | `AccelerationX` float default NULL, | 39 | `SitTargetOffsetY` double DEFAULT NULL, |
40 | `AccelerationY` float default NULL, | 40 | `SitTargetOffsetZ` double DEFAULT NULL, |
41 | `AccelerationZ` float default NULL, | 41 | `SitTargetOrientW` double DEFAULT NULL, |
42 | `RotationX` float default NULL, | 42 | `SitTargetOrientX` double DEFAULT NULL, |
43 | `RotationY` float default NULL, | 43 | `SitTargetOrientY` double DEFAULT NULL, |
44 | `RotationZ` float default NULL, | 44 | `SitTargetOrientZ` double DEFAULT NULL, |
45 | `RotationW` float default NULL, | 45 | `UUID` char(36) NOT NULL DEFAULT '', |
46 | `SitTargetOffsetX` float default NULL, | 46 | `RegionUUID` char(36) DEFAULT NULL, |
47 | `SitTargetOffsetY` float default NULL, | 47 | `CreatorID` varchar(255) NOT NULL DEFAULT '', |
48 | `SitTargetOffsetZ` float default NULL, | 48 | `OwnerID` char(36) DEFAULT NULL, |
49 | `SitTargetOrientW` float default NULL, | 49 | `GroupID` char(36) DEFAULT NULL, |
50 | `SitTargetOrientX` float default NULL, | 50 | `LastOwnerID` char(36) DEFAULT NULL, |
51 | `SitTargetOrientY` float default NULL, | 51 | `SceneGroupID` char(36) DEFAULT NULL, |
52 | `SitTargetOrientZ` float default NULL, | 52 | `PayPrice` int(11) NOT NULL DEFAULT '0', |
53 | PRIMARY KEY (`UUID`) | 53 | `PayButton1` int(11) NOT NULL DEFAULT '0', |
54 | `PayButton2` int(11) NOT NULL DEFAULT '0', | ||
55 | `PayButton3` int(11) NOT NULL DEFAULT '0', | ||
56 | `PayButton4` int(11) NOT NULL DEFAULT '0', | ||
57 | `LoopedSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
58 | `LoopedSoundGain` double NOT NULL DEFAULT '0', | ||
59 | `TextureAnimation` blob, | ||
60 | `OmegaX` double NOT NULL DEFAULT '0', | ||
61 | `OmegaY` double NOT NULL DEFAULT '0', | ||
62 | `OmegaZ` double NOT NULL DEFAULT '0', | ||
63 | `CameraEyeOffsetX` double NOT NULL DEFAULT '0', | ||
64 | `CameraEyeOffsetY` double NOT NULL DEFAULT '0', | ||
65 | `CameraEyeOffsetZ` double NOT NULL DEFAULT '0', | ||
66 | `CameraAtOffsetX` double NOT NULL DEFAULT '0', | ||
67 | `CameraAtOffsetY` double NOT NULL DEFAULT '0', | ||
68 | `CameraAtOffsetZ` double NOT NULL DEFAULT '0', | ||
69 | `ForceMouselook` tinyint(4) NOT NULL DEFAULT '0', | ||
70 | `ScriptAccessPin` int(11) NOT NULL DEFAULT '0', | ||
71 | `AllowedDrop` tinyint(4) NOT NULL DEFAULT '0', | ||
72 | `DieAtEdge` tinyint(4) NOT NULL DEFAULT '0', | ||
73 | `SalePrice` int(11) NOT NULL DEFAULT '10', | ||
74 | `SaleType` tinyint(4) NOT NULL DEFAULT '0', | ||
75 | `ColorR` int(11) NOT NULL DEFAULT '0', | ||
76 | `ColorG` int(11) NOT NULL DEFAULT '0', | ||
77 | `ColorB` int(11) NOT NULL DEFAULT '0', | ||
78 | `ColorA` int(11) NOT NULL DEFAULT '0', | ||
79 | `ParticleSystem` blob, | ||
80 | `ClickAction` tinyint(4) NOT NULL DEFAULT '0', | ||
81 | `Material` tinyint(4) NOT NULL DEFAULT '3', | ||
82 | `CollisionSound` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | ||
83 | `CollisionSoundVolume` double NOT NULL DEFAULT '0', | ||
84 | `LinkNumber` int(11) NOT NULL DEFAULT '0', | ||
85 | `PassTouches` tinyint(4) NOT NULL DEFAULT '0', | ||
86 | `MediaURL` varchar(255) DEFAULT NULL, | ||
87 | `DynAttrs` text, | ||
88 | `PhysicsShapeType` tinyint(4) NOT NULL DEFAULT '0', | ||
89 | `Density` double NOT NULL DEFAULT '1000', | ||
90 | `GravityModifier` double NOT NULL DEFAULT '1', | ||
91 | `Friction` double NOT NULL DEFAULT '0.6', | ||
92 | `Restitution` double NOT NULL DEFAULT '0.5', | ||
93 | `KeyframeMotion` blob, | ||
94 | `AttachedPosX` double DEFAULT '0', | ||
95 | `AttachedPosY` double DEFAULT '0', | ||
96 | `AttachedPosZ` double DEFAULT '0', | ||
97 | PRIMARY KEY (`UUID`), | ||
98 | KEY `prims_regionuuid` (`RegionUUID`), | ||
99 | KEY `prims_scenegroupid` (`SceneGroupID`) | ||
54 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 100 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
55 | 101 | ||
56 | CREATE TABLE `primshapes` ( | 102 | CREATE TABLE IF NOT EXISTS `primshapes` ( |
57 | `UUID` varchar(255) NOT NULL, | 103 | `Shape` int(11) DEFAULT NULL, |
58 | `Shape` int(11) default NULL, | 104 | `ScaleX` double NOT NULL DEFAULT '0', |
59 | `ScaleX` float default NULL, | 105 | `ScaleY` double NOT NULL DEFAULT '0', |
60 | `ScaleY` float default NULL, | 106 | `ScaleZ` double NOT NULL DEFAULT '0', |
61 | `ScaleZ` float default NULL, | 107 | `PCode` int(11) DEFAULT NULL, |
62 | `PCode` int(11) default NULL, | 108 | `PathBegin` int(11) DEFAULT NULL, |
63 | `PathBegin` int(11) default NULL, | 109 | `PathEnd` int(11) DEFAULT NULL, |
64 | `PathEnd` int(11) default NULL, | 110 | `PathScaleX` int(11) DEFAULT NULL, |
65 | `PathScaleX` int(11) default NULL, | 111 | `PathScaleY` int(11) DEFAULT NULL, |
66 | `PathScaleY` int(11) default NULL, | 112 | `PathShearX` int(11) DEFAULT NULL, |
67 | `PathShearX` int(11) default NULL, | 113 | `PathShearY` int(11) DEFAULT NULL, |
68 | `PathShearY` int(11) default NULL, | 114 | `PathSkew` int(11) DEFAULT NULL, |
69 | `PathSkew` int(11) default NULL, | 115 | `PathCurve` int(11) DEFAULT NULL, |
70 | `PathCurve` int(11) default NULL, | 116 | `PathRadiusOffset` int(11) DEFAULT NULL, |
71 | `PathRadiusOffset` int(11) default NULL, | 117 | `PathRevolutions` int(11) DEFAULT NULL, |
72 | `PathRevolutions` int(11) default NULL, | 118 | `PathTaperX` int(11) DEFAULT NULL, |
73 | `PathTaperX` int(11) default NULL, | 119 | `PathTaperY` int(11) DEFAULT NULL, |
74 | `PathTaperY` int(11) default NULL, | 120 | `PathTwist` int(11) DEFAULT NULL, |
75 | `PathTwist` int(11) default NULL, | 121 | `PathTwistBegin` int(11) DEFAULT NULL, |
76 | `PathTwistBegin` int(11) default NULL, | 122 | `ProfileBegin` int(11) DEFAULT NULL, |
77 | `ProfileBegin` int(11) default NULL, | 123 | `ProfileEnd` int(11) DEFAULT NULL, |
78 | `ProfileEnd` int(11) default NULL, | 124 | `ProfileCurve` int(11) DEFAULT NULL, |
79 | `ProfileCurve` int(11) default NULL, | 125 | `ProfileHollow` int(11) DEFAULT NULL, |
80 | `ProfileHollow` int(11) default NULL, | 126 | `State` int(11) DEFAULT NULL, |
81 | `State` int(11) default NULL, | ||
82 | `Texture` longblob, | 127 | `Texture` longblob, |
83 | `ExtraParams` longblob, | 128 | `ExtraParams` longblob, |
84 | PRIMARY KEY (`UUID`) | 129 | `UUID` char(36) NOT NULL DEFAULT '', |
130 | `Media` text, | ||
131 | `LastAttachPoint` int(4) NOT NULL DEFAULT '0', | ||
132 | PRIMARY KEY (`UUID`) | ||
85 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 133 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
86 | 134 | ||
87 | CREATE TABLE `primitems` ( | 135 | CREATE TABLE IF NOT EXISTS `primitems` ( |
88 | `itemID` varchar(255) NOT NULL, | 136 | `invType` int(11) DEFAULT NULL, |
89 | `primID` varchar(255) default NULL, | 137 | `assetType` int(11) DEFAULT NULL, |
90 | `assetID` varchar(255) default NULL, | 138 | `name` varchar(255) DEFAULT NULL, |
91 | `parentFolderID` varchar(255) default NULL, | 139 | `description` varchar(255) DEFAULT NULL, |
92 | `invType` int(11) default NULL, | 140 | `creationDate` bigint(20) DEFAULT NULL, |
93 | `assetType` int(11) default NULL, | 141 | `nextPermissions` int(11) DEFAULT NULL, |
94 | `name` varchar(255) default NULL, | 142 | `currentPermissions` int(11) DEFAULT NULL, |
95 | `description` varchar(255) default NULL, | 143 | `basePermissions` int(11) DEFAULT NULL, |
96 | `creationDate` bigint(20) default NULL, | 144 | `everyonePermissions` int(11) DEFAULT NULL, |
97 | `creatorID` varchar(255) default NULL, | 145 | `groupPermissions` int(11) DEFAULT NULL, |
98 | `ownerID` varchar(255) default NULL, | 146 | `flags` int(11) NOT NULL DEFAULT '0', |
99 | `lastOwnerID` varchar(255) default NULL, | 147 | `itemID` char(36) NOT NULL DEFAULT '', |
100 | `groupID` varchar(255) default NULL, | 148 | `primID` char(36) DEFAULT NULL, |
101 | `nextPermissions` int(11) default NULL, | 149 | `assetID` char(36) DEFAULT NULL, |
102 | `currentPermissions` int(11) default NULL, | 150 | `parentFolderID` char(36) DEFAULT NULL, |
103 | `basePermissions` int(11) default NULL, | 151 | `CreatorID` varchar(255) NOT NULL DEFAULT '', |
104 | `everyonePermissions` int(11) default NULL, | 152 | `ownerID` char(36) DEFAULT NULL, |
105 | `groupPermissions` int(11) default NULL, | 153 | `groupID` char(36) DEFAULT NULL, |
106 | PRIMARY KEY (`itemID`) | 154 | `lastOwnerID` char(36) DEFAULT NULL, |
155 | PRIMARY KEY (`itemID`), | ||
156 | KEY `primitems_primid` (`primID`) | ||
107 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 157 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
108 | 158 | ||
109 | CREATE TABLE `terrain` ( | 159 | CREATE TABLE IF NOT EXISTS `terrain` ( |
110 | `RegionUUID` varchar(255) default NULL, | 160 | `RegionUUID` varchar(255) DEFAULT NULL, |
111 | `Revision` int(11) default NULL, | 161 | `Revision` int(11) DEFAULT NULL, |
112 | `Heightfield` longblob | 162 | `Heightfield` longblob |
113 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 163 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
114 | 164 | ||
115 | CREATE TABLE `land` ( | 165 | CREATE TABLE IF NOT EXISTS `land` ( |
116 | `UUID` varchar(255) NOT NULL, | 166 | `UUID` varchar(255) NOT NULL, |
117 | `RegionUUID` varchar(255) default NULL, | 167 | `RegionUUID` varchar(255) DEFAULT NULL, |
118 | `LocalLandID` int(11) default NULL, | 168 | `LocalLandID` int(11) DEFAULT NULL, |
119 | `Bitmap` longblob, | 169 | `Bitmap` longblob, |
120 | `Name` varchar(255) default NULL, | 170 | `Name` varchar(255) DEFAULT NULL, |
121 | `Description` varchar(255) default NULL, | 171 | `Description` varchar(255) DEFAULT NULL, |
122 | `OwnerUUID` varchar(255) default NULL, | 172 | `OwnerUUID` varchar(255) DEFAULT NULL, |
123 | `IsGroupOwned` int(11) default NULL, | 173 | `IsGroupOwned` int(11) DEFAULT NULL, |
124 | `Area` int(11) default NULL, | 174 | `Area` int(11) DEFAULT NULL, |
125 | `AuctionID` int(11) default NULL, | 175 | `AuctionID` int(11) DEFAULT NULL, |
126 | `Category` int(11) default NULL, | 176 | `Category` int(11) DEFAULT NULL, |
127 | `ClaimDate` int(11) default NULL, | 177 | `ClaimDate` int(11) DEFAULT NULL, |
128 | `ClaimPrice` int(11) default NULL, | 178 | `ClaimPrice` int(11) DEFAULT NULL, |
129 | `GroupUUID` varchar(255) default NULL, | 179 | `GroupUUID` varchar(255) DEFAULT NULL, |
130 | `SalePrice` int(11) default NULL, | 180 | `SalePrice` int(11) DEFAULT NULL, |
131 | `LandStatus` int(11) default NULL, | 181 | `LandStatus` int(11) DEFAULT NULL, |
132 | `LandFlags` int(11) default NULL, | 182 | `LandFlags` int(10) unsigned DEFAULT NULL, |
133 | `LandingType` int(11) default NULL, | 183 | `LandingType` int(11) DEFAULT NULL, |
134 | `MediaAutoScale` int(11) default NULL, | 184 | `MediaAutoScale` int(11) DEFAULT NULL, |
135 | `MediaTextureUUID` varchar(255) default NULL, | 185 | `MediaTextureUUID` varchar(255) DEFAULT NULL, |
136 | `MediaURL` varchar(255) default NULL, | 186 | `MediaURL` varchar(255) DEFAULT NULL, |
137 | `MusicURL` varchar(255) default NULL, | 187 | `MusicURL` varchar(255) DEFAULT NULL, |
138 | `PassHours` float default NULL, | 188 | `PassHours` float DEFAULT NULL, |
139 | `PassPrice` int(11) default NULL, | 189 | `PassPrice` int(11) DEFAULT NULL, |
140 | `SnapshotUUID` varchar(255) default NULL, | 190 | `SnapshotUUID` varchar(255) DEFAULT NULL, |
141 | `UserLocationX` float default NULL, | 191 | `UserLocationX` float DEFAULT NULL, |
142 | `UserLocationY` float default NULL, | 192 | `UserLocationY` float DEFAULT NULL, |
143 | `UserLocationZ` float default NULL, | 193 | `UserLocationZ` float DEFAULT NULL, |
144 | `UserLookAtX` float default NULL, | 194 | `UserLookAtX` float DEFAULT NULL, |
145 | `UserLookAtY` float default NULL, | 195 | `UserLookAtY` float DEFAULT NULL, |
146 | `UserLookAtZ` float default NULL, | 196 | `UserLookAtZ` float DEFAULT NULL, |
147 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 197 | `AuthbuyerID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
148 | PRIMARY KEY (`UUID`) | 198 | `OtherCleanTime` int(11) NOT NULL DEFAULT '0', |
149 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 199 | `Dwell` int(11) NOT NULL DEFAULT '0', |
150 | 200 | `MediaType` varchar(32) NOT NULL DEFAULT 'none/none', | |
151 | CREATE TABLE `landaccesslist` ( | 201 | `MediaDescription` varchar(255) NOT NULL DEFAULT '', |
152 | `LandUUID` varchar(255) default NULL, | 202 | `MediaSize` varchar(16) NOT NULL DEFAULT '0,0', |
153 | `AccessUUID` varchar(255) default NULL, | 203 | `MediaLoop` tinyint(1) NOT NULL DEFAULT '0', |
154 | `Flags` int(11) default NULL | 204 | `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0', |
205 | `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0', | ||
206 | PRIMARY KEY (`UUID`) | ||
207 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
208 | |||
209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( | ||
210 | `LandUUID` varchar(255) DEFAULT NULL, | ||
211 | `AccessUUID` varchar(255) DEFAULT NULL, | ||
212 | `Flags` int(11) DEFAULT NULL, | ||
213 | `Expires` int(11) NOT NULL DEFAULT '0' | ||
155 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 214 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
156 | 215 | ||
157 | COMMIT; | 216 | CREATE TABLE IF NOT EXISTS `regionban` ( |
158 | 217 | `regionUUID` varchar(36) NOT NULL, | |
159 | :VERSION 2 #--------------------- | 218 | `bannedUUID` varchar(36) NOT NULL, |
160 | 219 | `bannedIp` varchar(16) NOT NULL, | |
161 | BEGIN; | 220 | `bannedIpHostMask` varchar(16) NOT NULL |
162 | 221 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
163 | CREATE index prims_regionuuid on prims(RegionUUID); | ||
164 | CREATE index primitems_primid on primitems(primID); | ||
165 | |||
166 | COMMIT; | ||
167 | |||
168 | :VERSION 3 #--------------------- | ||
169 | |||
170 | BEGIN; | ||
171 | CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
172 | COMMIT; | ||
173 | |||
174 | :VERSION 4 #--------------------- | ||
175 | |||
176 | BEGIN; | ||
177 | |||
178 | ALTER TABLE primitems add flags integer not null default 0; | ||
179 | |||
180 | COMMIT; | ||
181 | |||
182 | :VERSION 5 #--------------------- | ||
183 | BEGIN; | ||
184 | |||
185 | create table regionsettings ( | ||
186 | regionUUID char(36) not null, | ||
187 | block_terraform integer not null, | ||
188 | block_fly integer not null, | ||
189 | allow_damage integer not null, | ||
190 | restrict_pushing integer not null, | ||
191 | allow_land_resell integer not null, | ||
192 | allow_land_join_divide integer not null, | ||
193 | block_show_in_search integer not null, | ||
194 | agent_limit integer not null, | ||
195 | object_bonus float not null, | ||
196 | maturity integer not null, | ||
197 | disable_scripts integer not null, | ||
198 | disable_collisions integer not null, | ||
199 | disable_physics integer not null, | ||
200 | terrain_texture_1 char(36) not null, | ||
201 | terrain_texture_2 char(36) not null, | ||
202 | terrain_texture_3 char(36) not null, | ||
203 | terrain_texture_4 char(36) not null, | ||
204 | elevation_1_nw float not null, | ||
205 | elevation_2_nw float not null, | ||
206 | elevation_1_ne float not null, | ||
207 | elevation_2_ne float not null, | ||
208 | elevation_1_se float not null, | ||
209 | elevation_2_se float not null, | ||
210 | elevation_1_sw float not null, | ||
211 | elevation_2_sw float not null, | ||
212 | water_height float not null, | ||
213 | terrain_raise_limit float not null, | ||
214 | terrain_lower_limit float not null, | ||
215 | use_estate_sun integer not null, | ||
216 | fixed_sun integer not null, | ||
217 | sun_position float not null, | ||
218 | covenant char(36), | ||
219 | primary key(regionUUID) | ||
220 | ); | ||
221 | |||
222 | COMMIT; | ||
223 | |||
224 | |||
225 | :VERSION 6 #--------------------- | ||
226 | |||
227 | BEGIN; | ||
228 | |||
229 | alter table landaccesslist ENGINE = InnoDB; | ||
230 | alter table migrations ENGINE = InnoDB; | ||
231 | alter table primitems ENGINE = InnoDB; | ||
232 | alter table prims ENGINE = InnoDB; | ||
233 | alter table primshapes ENGINE = InnoDB; | ||
234 | alter table regionsettings ENGINE = InnoDB; | ||
235 | alter table terrain ENGINE = InnoDB; | ||
236 | |||
237 | COMMIT; | ||
238 | |||
239 | :VERSION 7 #--------------------- | ||
240 | |||
241 | BEGIN; | ||
242 | |||
243 | ALTER TABLE prims change UUID UUIDold varchar(255); | ||
244 | ALTER TABLE prims change RegionUUID RegionUUIDold varchar(255); | ||
245 | ALTER TABLE prims change CreatorID CreatorIDold varchar(255); | ||
246 | ALTER TABLE prims change OwnerID OwnerIDold varchar(255); | ||
247 | ALTER TABLE prims change GroupID GroupIDold varchar(255); | ||
248 | ALTER TABLE prims change LastOwnerID LastOwnerIDold varchar(255); | ||
249 | ALTER TABLE prims add UUID char(36); | ||
250 | ALTER TABLE prims add RegionUUID char(36); | ||
251 | ALTER TABLE prims add CreatorID char(36); | ||
252 | ALTER TABLE prims add OwnerID char(36); | ||
253 | ALTER TABLE prims add GroupID char(36); | ||
254 | ALTER TABLE prims add LastOwnerID char(36); | ||
255 | UPDATE prims set UUID = UUIDold, RegionUUID = RegionUUIDold, CreatorID = CreatorIDold, OwnerID = OwnerIDold, GroupID = GroupIDold, LastOwnerID = LastOwnerIDold; | ||
256 | ALTER TABLE prims drop UUIDold; | ||
257 | ALTER TABLE prims drop RegionUUIDold; | ||
258 | ALTER TABLE prims drop CreatorIDold; | ||
259 | ALTER TABLE prims drop OwnerIDold; | ||
260 | ALTER TABLE prims drop GroupIDold; | ||
261 | ALTER TABLE prims drop LastOwnerIDold; | ||
262 | ALTER TABLE prims add constraint primary key(UUID); | ||
263 | ALTER TABLE prims add index prims_regionuuid(RegionUUID); | ||
264 | |||
265 | COMMIT; | ||
266 | |||
267 | :VERSION 8 #--------------------- | ||
268 | |||
269 | BEGIN; | ||
270 | |||
271 | ALTER TABLE primshapes change UUID UUIDold varchar(255); | ||
272 | ALTER TABLE primshapes add UUID char(36); | ||
273 | UPDATE primshapes set UUID = UUIDold; | ||
274 | ALTER TABLE primshapes drop UUIDold; | ||
275 | ALTER TABLE primshapes add constraint primary key(UUID); | ||
276 | |||
277 | COMMIT; | ||
278 | |||
279 | :VERSION 9 #--------------------- | ||
280 | |||
281 | BEGIN; | ||
282 | |||
283 | ALTER TABLE primitems change itemID itemIDold varchar(255); | ||
284 | ALTER TABLE primitems change primID primIDold varchar(255); | ||
285 | ALTER TABLE primitems change assetID assetIDold varchar(255); | ||
286 | ALTER TABLE primitems change parentFolderID parentFolderIDold varchar(255); | ||
287 | ALTER TABLE primitems change creatorID creatorIDold varchar(255); | ||
288 | ALTER TABLE primitems change ownerID ownerIDold varchar(255); | ||
289 | ALTER TABLE primitems change groupID groupIDold varchar(255); | ||
290 | ALTER TABLE primitems change lastOwnerID lastOwnerIDold varchar(255); | ||
291 | ALTER TABLE primitems add itemID char(36); | ||
292 | ALTER TABLE primitems add primID char(36); | ||
293 | ALTER TABLE primitems add assetID char(36); | ||
294 | ALTER TABLE primitems add parentFolderID char(36); | ||
295 | ALTER TABLE primitems add creatorID char(36); | ||
296 | ALTER TABLE primitems add ownerID char(36); | ||
297 | ALTER TABLE primitems add groupID char(36); | ||
298 | ALTER TABLE primitems add lastOwnerID char(36); | ||
299 | UPDATE primitems set itemID = itemIDold, primID = primIDold, assetID = assetIDold, parentFolderID = parentFolderIDold, creatorID = creatorIDold, ownerID = ownerIDold, groupID = groupIDold, lastOwnerID = lastOwnerIDold; | ||
300 | ALTER TABLE primitems drop itemIDold; | ||
301 | ALTER TABLE primitems drop primIDold; | ||
302 | ALTER TABLE primitems drop assetIDold; | ||
303 | ALTER TABLE primitems drop parentFolderIDold; | ||
304 | ALTER TABLE primitems drop creatorIDold; | ||
305 | ALTER TABLE primitems drop ownerIDold; | ||
306 | ALTER TABLE primitems drop groupIDold; | ||
307 | ALTER TABLE primitems drop lastOwnerIDold; | ||
308 | ALTER TABLE primitems add constraint primary key(itemID); | ||
309 | ALTER TABLE primitems add index primitems_primid(primID); | ||
310 | |||
311 | COMMIT; | ||
312 | |||
313 | :VERSION 10 #--------------------- | ||
314 | |||
315 | # 1 "010_RegionStore.sql" | ||
316 | # 1 "<built-in>" | ||
317 | # 1 "<command line>" | ||
318 | # 1 "010_RegionStore.sql" | ||
319 | BEGIN; | ||
320 | |||
321 | DELETE FROM regionsettings; | ||
322 | |||
323 | COMMIT; | ||
324 | |||
325 | |||
326 | :VERSION 11 #--------------------- | ||
327 | |||
328 | BEGIN; | ||
329 | |||
330 | ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255); | ||
331 | ALTER TABLE prims add SceneGroupID char(36); | ||
332 | UPDATE prims set SceneGroupID = SceneGroupIDold; | ||
333 | ALTER TABLE prims drop SceneGroupIDold; | ||
334 | ALTER TABLE prims add index prims_scenegroupid(SceneGroupID); | ||
335 | |||
336 | COMMIT; | ||
337 | |||
338 | :VERSION 12 #--------------------- | ||
339 | |||
340 | BEGIN; | ||
341 | |||
342 | ALTER TABLE prims add index prims_parentid(ParentID); | ||
343 | 222 | ||
344 | COMMIT; | 223 | CREATE TABLE IF NOT EXISTS `regionsettings` ( |
345 | |||
346 | :VERSION 13 #--------------------- | ||
347 | begin; | ||
348 | |||
349 | drop table regionsettings; | ||
350 | |||
351 | CREATE TABLE `regionsettings` ( | ||
352 | `regionUUID` char(36) NOT NULL, | 224 | `regionUUID` char(36) NOT NULL, |
353 | `block_terraform` int(11) NOT NULL, | 225 | `block_terraform` int(11) NOT NULL, |
354 | `block_fly` int(11) NOT NULL, | 226 | `block_fly` int(11) NOT NULL, |
@@ -358,7 +230,7 @@ CREATE TABLE `regionsettings` ( | |||
358 | `allow_land_join_divide` int(11) NOT NULL, | 230 | `allow_land_join_divide` int(11) NOT NULL, |
359 | `block_show_in_search` int(11) NOT NULL, | 231 | `block_show_in_search` int(11) NOT NULL, |
360 | `agent_limit` int(11) NOT NULL, | 232 | `agent_limit` int(11) NOT NULL, |
361 | `object_bonus` float NOT NULL, | 233 | `object_bonus` double NOT NULL, |
362 | `maturity` int(11) NOT NULL, | 234 | `maturity` int(11) NOT NULL, |
363 | `disable_scripts` int(11) NOT NULL, | 235 | `disable_scripts` int(11) NOT NULL, |
364 | `disable_collisions` int(11) NOT NULL, | 236 | `disable_collisions` int(11) NOT NULL, |
@@ -367,360 +239,35 @@ CREATE TABLE `regionsettings` ( | |||
367 | `terrain_texture_2` char(36) NOT NULL, | 239 | `terrain_texture_2` char(36) NOT NULL, |
368 | `terrain_texture_3` char(36) NOT NULL, | 240 | `terrain_texture_3` char(36) NOT NULL, |
369 | `terrain_texture_4` char(36) NOT NULL, | 241 | `terrain_texture_4` char(36) NOT NULL, |
370 | `elevation_1_nw` float NOT NULL, | 242 | `elevation_1_nw` double NOT NULL, |
371 | `elevation_2_nw` float NOT NULL, | 243 | `elevation_2_nw` double NOT NULL, |
372 | `elevation_1_ne` float NOT NULL, | 244 | `elevation_1_ne` double NOT NULL, |
373 | `elevation_2_ne` float NOT NULL, | 245 | `elevation_2_ne` double NOT NULL, |
374 | `elevation_1_se` float NOT NULL, | 246 | `elevation_1_se` double NOT NULL, |
375 | `elevation_2_se` float NOT NULL, | 247 | `elevation_2_se` double NOT NULL, |
376 | `elevation_1_sw` float NOT NULL, | 248 | `elevation_1_sw` double NOT NULL, |
377 | `elevation_2_sw` float NOT NULL, | 249 | `elevation_2_sw` double NOT NULL, |
378 | `water_height` float NOT NULL, | 250 | `water_height` double NOT NULL, |
379 | `terrain_raise_limit` float NOT NULL, | 251 | `terrain_raise_limit` double NOT NULL, |
380 | `terrain_lower_limit` float NOT NULL, | 252 | `terrain_lower_limit` double NOT NULL, |
381 | `use_estate_sun` int(11) NOT NULL, | 253 | `use_estate_sun` int(11) NOT NULL, |
382 | `fixed_sun` int(11) NOT NULL, | 254 | `fixed_sun` int(11) NOT NULL, |
383 | `sun_position` float NOT NULL, | 255 | `sun_position` double NOT NULL, |
384 | `covenant` char(36) default NULL, | 256 | `covenant` char(36) DEFAULT NULL, |
385 | `Sandbox` tinyint(4) NOT NULL, | 257 | `Sandbox` tinyint(4) NOT NULL, |
386 | PRIMARY KEY (`regionUUID`) | 258 | `sunvectorx` double NOT NULL DEFAULT '0', |
387 | ) ENGINE=InnoDB; | 259 | `sunvectory` double NOT NULL DEFAULT '0', |
388 | 260 | `sunvectorz` double NOT NULL DEFAULT '0', | |
389 | commit; | 261 | `loaded_creation_id` varchar(64) DEFAULT NULL, |
390 | 262 | `loaded_creation_datetime` int(10) unsigned NOT NULL DEFAULT '0', | |
391 | :VERSION 16 #--------------------- | 263 | `map_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
392 | 264 | `TelehubObject` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | |
393 | BEGIN; | 265 | `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
394 | 266 | `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0', | |
395 | ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; | 267 | PRIMARY KEY (`regionUUID`) |
396 | ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; | 268 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
397 | ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0; | 269 | |
398 | ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0; | 270 | CREATE TABLE IF NOT EXISTS `regionwindlight` ( |
399 | ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0; | ||
400 | ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
401 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0; | ||
402 | ALTER TABLE prims ADD COLUMN TextureAnimation blob; | ||
403 | ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0; | ||
404 | ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0; | ||
405 | ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0; | ||
406 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0; | ||
407 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0; | ||
408 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0; | ||
409 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0; | ||
410 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0; | ||
411 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0; | ||
412 | ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0; | ||
413 | ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0; | ||
414 | ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0; | ||
415 | ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0; | ||
416 | ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10; | ||
417 | ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0; | ||
418 | |||
419 | COMMIT; | ||
420 | |||
421 | |||
422 | :VERSION 17 #--------------------- | ||
423 | |||
424 | BEGIN; | ||
425 | |||
426 | ALTER TABLE prims ADD COLUMN ColorR integer not null default 0; | ||
427 | ALTER TABLE prims ADD COLUMN ColorG integer not null default 0; | ||
428 | ALTER TABLE prims ADD COLUMN ColorB integer not null default 0; | ||
429 | ALTER TABLE prims ADD COLUMN ColorA integer not null default 0; | ||
430 | ALTER TABLE prims ADD COLUMN ParticleSystem blob; | ||
431 | |||
432 | COMMIT; | ||
433 | |||
434 | |||
435 | :VERSION 18 #--------------------- | ||
436 | |||
437 | begin; | ||
438 | |||
439 | ALTER TABLE prims ADD COLUMN ClickAction tinyint NOT NULL default 0; | ||
440 | |||
441 | commit; | ||
442 | |||
443 | :VERSION 19 #--------------------- | ||
444 | |||
445 | begin; | ||
446 | |||
447 | ALTER TABLE prims ADD COLUMN Material tinyint NOT NULL default 3; | ||
448 | |||
449 | commit; | ||
450 | |||
451 | |||
452 | :VERSION 20 #--------------------- | ||
453 | |||
454 | begin; | ||
455 | |||
456 | ALTER TABLE land ADD COLUMN OtherCleanTime integer NOT NULL default 0; | ||
457 | ALTER TABLE land ADD COLUMN Dwell integer NOT NULL default 0; | ||
458 | |||
459 | commit; | ||
460 | |||
461 | :VERSION 21 #--------------------- | ||
462 | |||
463 | begin; | ||
464 | |||
465 | ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0; | ||
466 | ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0; | ||
467 | ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0; | ||
468 | |||
469 | commit; | ||
470 | |||
471 | |||
472 | :VERSION 22 #--------------------- | ||
473 | |||
474 | BEGIN; | ||
475 | |||
476 | ALTER TABLE prims ADD COLUMN CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
477 | ALTER TABLE prims ADD COLUMN CollisionSoundVolume float not null default 0.0; | ||
478 | |||
479 | COMMIT; | ||
480 | |||
481 | :VERSION 23 #--------------------- | ||
482 | |||
483 | BEGIN; | ||
484 | |||
485 | ALTER TABLE prims ADD COLUMN LinkNumber integer not null default 0; | ||
486 | |||
487 | COMMIT; | ||
488 | |||
489 | :VERSION 24 #--------------------- | ||
490 | |||
491 | BEGIN; | ||
492 | |||
493 | alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL; | ||
494 | alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL; | ||
495 | alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL; | ||
496 | alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL; | ||
497 | alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL; | ||
498 | alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL; | ||
499 | alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL; | ||
500 | alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL; | ||
501 | alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL; | ||
502 | alter table regionsettings change column `water_height` `water_height` double NOT NULL; | ||
503 | alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL; | ||
504 | alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL; | ||
505 | alter table regionsettings change column `sun_position` `sun_position` double NOT NULL; | ||
506 | |||
507 | COMMIT; | ||
508 | |||
509 | |||
510 | :VERSION 25 #--------------------- | ||
511 | |||
512 | BEGIN; | ||
513 | |||
514 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
515 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
516 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
517 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
518 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
519 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
520 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
521 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
522 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
523 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
524 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
525 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
526 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
527 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
528 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
529 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
530 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
531 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
532 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
533 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
534 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
535 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
536 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
537 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
538 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
539 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
540 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
541 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
542 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
543 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
544 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
545 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
546 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
547 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
548 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
549 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
550 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
551 | |||
552 | alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0'; | ||
553 | alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0'; | ||
554 | alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0'; | ||
555 | |||
556 | COMMIT; | ||
557 | |||
558 | :VERSION 26 #--------------------- | ||
559 | |||
560 | begin; | ||
561 | |||
562 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
563 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
564 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
565 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
566 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
567 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
568 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
569 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
570 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
571 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
572 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
573 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
574 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
575 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
576 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
577 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
578 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
579 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
580 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
581 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
582 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
583 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
584 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
585 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
586 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
587 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
588 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; | ||
589 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; | ||
590 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; | ||
591 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; | ||
592 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; | ||
593 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; | ||
594 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; | ||
595 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; | ||
596 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; | ||
597 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; | ||
598 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; | ||
599 | |||
600 | commit; | ||
601 | |||
602 | :VERSION 27 #--------------------- | ||
603 | |||
604 | BEGIN; | ||
605 | |||
606 | ALTER TABLE prims DROP COLUMN ParentID; | ||
607 | |||
608 | COMMIT; | ||
609 | |||
610 | :VERSION 28 #--------------------- | ||
611 | |||
612 | BEGIN; | ||
613 | |||
614 | update terrain | ||
615 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
616 | where RegionUUID not like '%-%'; | ||
617 | |||
618 | |||
619 | update landaccesslist | ||
620 | set LandUUID = concat(substr(LandUUID, 1, 8), "-", substr(LandUUID, 9, 4), "-", substr(LandUUID, 13, 4), "-", substr(LandUUID, 17, 4), "-", substr(LandUUID, 21, 12)) | ||
621 | where LandUUID not like '%-%'; | ||
622 | |||
623 | update landaccesslist | ||
624 | set AccessUUID = concat(substr(AccessUUID, 1, 8), "-", substr(AccessUUID, 9, 4), "-", substr(AccessUUID, 13, 4), "-", substr(AccessUUID, 17, 4), "-", substr(AccessUUID, 21, 12)) | ||
625 | where AccessUUID not like '%-%'; | ||
626 | |||
627 | |||
628 | update prims | ||
629 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
630 | where UUID not like '%-%'; | ||
631 | |||
632 | update prims | ||
633 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
634 | where RegionUUID not like '%-%'; | ||
635 | |||
636 | update prims | ||
637 | set SceneGroupID = concat(substr(SceneGroupID, 1, 8), "-", substr(SceneGroupID, 9, 4), "-", substr(SceneGroupID, 13, 4), "-", substr(SceneGroupID, 17, 4), "-", substr(SceneGroupID, 21, 12)) | ||
638 | where SceneGroupID not like '%-%'; | ||
639 | |||
640 | update prims | ||
641 | set CreatorID = concat(substr(CreatorID, 1, 8), "-", substr(CreatorID, 9, 4), "-", substr(CreatorID, 13, 4), "-", substr(CreatorID, 17, 4), "-", substr(CreatorID, 21, 12)) | ||
642 | where CreatorID not like '%-%'; | ||
643 | |||
644 | update prims | ||
645 | set OwnerID = concat(substr(OwnerID, 1, 8), "-", substr(OwnerID, 9, 4), "-", substr(OwnerID, 13, 4), "-", substr(OwnerID, 17, 4), "-", substr(OwnerID, 21, 12)) | ||
646 | where OwnerID not like '%-%'; | ||
647 | |||
648 | update prims | ||
649 | set GroupID = concat(substr(GroupID, 1, 8), "-", substr(GroupID, 9, 4), "-", substr(GroupID, 13, 4), "-", substr(GroupID, 17, 4), "-", substr(GroupID, 21, 12)) | ||
650 | where GroupID not like '%-%'; | ||
651 | |||
652 | update prims | ||
653 | set LastOwnerID = concat(substr(LastOwnerID, 1, 8), "-", substr(LastOwnerID, 9, 4), "-", substr(LastOwnerID, 13, 4), "-", substr(LastOwnerID, 17, 4), "-", substr(LastOwnerID, 21, 12)) | ||
654 | where LastOwnerID not like '%-%'; | ||
655 | |||
656 | |||
657 | update primshapes | ||
658 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
659 | where UUID not like '%-%'; | ||
660 | |||
661 | |||
662 | update land | ||
663 | set UUID = concat(substr(UUID, 1, 8), "-", substr(UUID, 9, 4), "-", substr(UUID, 13, 4), "-", substr(UUID, 17, 4), "-", substr(UUID, 21, 12)) | ||
664 | where UUID not like '%-%'; | ||
665 | |||
666 | update land | ||
667 | set RegionUUID = concat(substr(RegionUUID, 1, 8), "-", substr(RegionUUID, 9, 4), "-", substr(RegionUUID, 13, 4), "-", substr(RegionUUID, 17, 4), "-", substr(RegionUUID, 21, 12)) | ||
668 | where RegionUUID not like '%-%'; | ||
669 | |||
670 | update land | ||
671 | set OwnerUUID = concat(substr(OwnerUUID, 1, 8), "-", substr(OwnerUUID, 9, 4), "-", substr(OwnerUUID, 13, 4), "-", substr(OwnerUUID, 17, 4), "-", substr(OwnerUUID, 21, 12)) | ||
672 | where OwnerUUID not like '%-%'; | ||
673 | |||
674 | update land | ||
675 | set GroupUUID = concat(substr(GroupUUID, 1, 8), "-", substr(GroupUUID, 9, 4), "-", substr(GroupUUID, 13, 4), "-", substr(GroupUUID, 17, 4), "-", substr(GroupUUID, 21, 12)) | ||
676 | where GroupUUID not like '%-%'; | ||
677 | |||
678 | update land | ||
679 | set MediaTextureUUID = concat(substr(MediaTextureUUID, 1, 8), "-", substr(MediaTextureUUID, 9, 4), "-", substr(MediaTextureUUID, 13, 4), "-", substr(MediaTextureUUID, 17, 4), "-", substr(MediaTextureUUID, 21, 12)) | ||
680 | where MediaTextureUUID not like '%-%'; | ||
681 | |||
682 | update land | ||
683 | set SnapshotUUID = concat(substr(SnapshotUUID, 1, 8), "-", substr(SnapshotUUID, 9, 4), "-", substr(SnapshotUUID, 13, 4), "-", substr(SnapshotUUID, 17, 4), "-", substr(SnapshotUUID, 21, 12)) | ||
684 | where SnapshotUUID not like '%-%'; | ||
685 | |||
686 | update land | ||
687 | set AuthbuyerID = concat(substr(AuthbuyerID, 1, 8), "-", substr(AuthbuyerID, 9, 4), "-", substr(AuthbuyerID, 13, 4), "-", substr(AuthbuyerID, 17, 4), "-", substr(AuthbuyerID, 21, 12)) | ||
688 | where AuthbuyerID not like '%-%'; | ||
689 | |||
690 | COMMIT; | ||
691 | |||
692 | :VERSION 29 #--------------------- | ||
693 | |||
694 | BEGIN; | ||
695 | |||
696 | ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0; | ||
697 | |||
698 | COMMIT; | ||
699 | |||
700 | :VERSION 30 #--------------------- | ||
701 | |||
702 | BEGIN; | ||
703 | |||
704 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_date varchar(20) default NULL; | ||
705 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_time varchar(20) default NULL; | ||
706 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_id varchar(64) default NULL; | ||
707 | |||
708 | COMMIT; | ||
709 | |||
710 | :VERSION 31 #--------------------- | ||
711 | |||
712 | BEGIN; | ||
713 | |||
714 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; | ||
715 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; | ||
716 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; | ||
717 | |||
718 | COMMIT; | ||
719 | |||
720 | :VERSION 32 #--------------------- | ||
721 | |||
722 | BEGIN; | ||
723 | CREATE TABLE `regionwindlight` ( | ||
724 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', | 271 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', |
725 | `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000', | 272 | `water_color_r` float(9,6) unsigned NOT NULL DEFAULT '4.000000', |
726 | `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', | 273 | `water_color_g` float(9,6) unsigned NOT NULL DEFAULT '38.000000', |
@@ -779,176 +326,38 @@ CREATE TABLE `regionwindlight` ( | |||
779 | `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', | 326 | `cloud_detail_x` float(3,2) unsigned NOT NULL DEFAULT '1.00', |
780 | `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', | 327 | `cloud_detail_y` float(3,2) unsigned NOT NULL DEFAULT '0.53', |
781 | `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12', | 328 | `cloud_detail_density` float(3,2) unsigned NOT NULL DEFAULT '0.12', |
782 | `cloud_scroll_x` float(3,2) unsigned NOT NULL DEFAULT '0.20', | 329 | `cloud_scroll_x` float(4,2) NOT NULL DEFAULT '0.20', |
783 | `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', | 330 | `cloud_scroll_x_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
784 | `cloud_scroll_y` float(3,2) unsigned NOT NULL DEFAULT '0.01', | 331 | `cloud_scroll_y` float(4,2) NOT NULL DEFAULT '0.01', |
785 | `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', | 332 | `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', |
786 | `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', | 333 | `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', |
787 | PRIMARY KEY (`region_id`) | 334 | PRIMARY KEY (`region_id`) |
788 | ); | 335 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
789 | |||
790 | |||
791 | :VERSION 33 #--------------------- | ||
792 | |||
793 | BEGIN; | ||
794 | ALTER TABLE regionsettings ADD map_tile_ID CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
795 | COMMIT; | ||
796 | |||
797 | :VERSION 34 #--------------------- | ||
798 | |||
799 | BEGIN; | ||
800 | ALTER TABLE `regionwindlight` CHANGE COLUMN `cloud_scroll_x` `cloud_scroll_x` FLOAT(4,2) NOT NULL DEFAULT '0.20' AFTER `cloud_detail_density`, CHANGE COLUMN `cloud_scroll_y` `cloud_scroll_y` FLOAT(4,2) NOT NULL DEFAULT '0.01' AFTER `cloud_scroll_x_lock`; | ||
801 | COMMIT; | ||
802 | |||
803 | :VERSION 35 #--------------------- | ||
804 | |||
805 | BEGIN; | ||
806 | ALTER TABLE prims ADD COLUMN MediaURL varchar(255); | ||
807 | ALTER TABLE primshapes ADD COLUMN Media TEXT; | ||
808 | COMMIT; | ||
809 | |||
810 | :VERSION 36 #--------------------- | ||
811 | |||
812 | BEGIN; | ||
813 | ALTER TABLE `land` ADD COLUMN `MediaType` VARCHAR(32) NOT NULL DEFAULT 'none/none' ; | ||
814 | ALTER TABLE `land` ADD COLUMN `MediaDescription` VARCHAR(255) NOT NULL DEFAULT ''; | ||
815 | ALTER TABLE `land` ADD COLUMN `MediaSize` VARCHAR(16) NOT NULL DEFAULT '0,0'; | ||
816 | ALTER TABLE `land` ADD COLUMN `MediaLoop` BOOLEAN NOT NULL DEFAULT FALSE; | ||
817 | ALTER TABLE `land` ADD COLUMN `ObscureMusic` BOOLEAN NOT NULL DEFAULT FALSE; | ||
818 | ALTER TABLE `land` ADD COLUMN `ObscureMedia` BOOLEAN NOT NULL DEFAULT FALSE; | ||
819 | COMMIT; | ||
820 | |||
821 | :VERSION 37 #--------------------- | ||
822 | |||
823 | BEGIN; | ||
824 | |||
825 | ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
826 | ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; | ||
827 | |||
828 | COMMIT; | ||
829 | |||
830 | :VERSION 38 #--------------------- | ||
831 | |||
832 | BEGIN; | ||
833 | |||
834 | alter table land ENGINE = MyISAM; | ||
835 | alter table landaccesslist ENGINE = MyISAM; | ||
836 | alter table migrations ENGINE = MyISAM; | ||
837 | alter table primitems ENGINE = MyISAM; | ||
838 | alter table prims ENGINE = MyISAM; | ||
839 | alter table primshapes ENGINE = MyISAM; | ||
840 | alter table regionban ENGINE = MyISAM; | ||
841 | alter table regionsettings ENGINE = MyISAM; | ||
842 | alter table terrain ENGINE = MyISAM; | ||
843 | |||
844 | COMMIT; | ||
845 | |||
846 | :VERSION 39 #--------------- Telehub support | ||
847 | 336 | ||
848 | BEGIN; | ||
849 | CREATE TABLE IF NOT EXISTS `spawn_points` ( | 337 | CREATE TABLE IF NOT EXISTS `spawn_points` ( |
850 | `RegionID` varchar(36) COLLATE utf8_unicode_ci NOT NULL, | 338 | `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
851 | `Yaw` float NOT NULL, | 339 | `Yaw` float NOT NULL, |
852 | `Pitch` float NOT NULL, | 340 | `Pitch` float NOT NULL, |
853 | `Distance` float NOT NULL, | 341 | `Distance` float NOT NULL, |
854 | KEY `RegionID` (`RegionID`) | 342 | KEY `RegionID` (`RegionID`) |
855 | ) ENGINE=Innodb; | 343 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
856 | |||
857 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; | ||
858 | COMMIT; | ||
859 | |||
860 | :VERSION 40 #---------------- Parcels for sale | ||
861 | |||
862 | BEGIN; | ||
863 | ALTER TABLE `regionsettings` ADD COLUMN `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
864 | COMMIT; | ||
865 | |||
866 | :VERSION 41 #---------------- Timed bans/access | ||
867 | |||
868 | BEGIN; | ||
869 | ALTER TABLE `landaccesslist` ADD COLUMN `Expires` INTEGER NOT NULL DEFAULT 0; | ||
870 | COMMIT; | ||
871 | |||
872 | :VERSION 42 #--------------------- Region Covenant changed time | ||
873 | |||
874 | BEGIN; | ||
875 | ALTER TABLE regionsettings ADD COLUMN covenant_datetime int unsigned NOT NULL DEFAULT '0'; | ||
876 | COMMIT; | ||
877 | |||
878 | :VERSION 43 #--------------------- | ||
879 | |||
880 | BEGIN; | ||
881 | |||
882 | ALTER TABLE `regionsettings` MODIFY COLUMN `TelehubObject` VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
883 | |||
884 | COMMIT; | ||
885 | |||
886 | :VERSION 44 #--------------------- Environment Settings | ||
887 | |||
888 | BEGIN; | ||
889 | 344 | ||
890 | CREATE TABLE `regionenvironment` ( | 345 | CREATE TABLE IF NOT EXISTS `regionenvironment` ( |
891 | `region_id` varchar(36) NOT NULL, | 346 | `region_id` varchar(36) NOT NULL, |
892 | `llsd_settings` TEXT NOT NULL, | 347 | `llsd_settings` text NOT NULL, |
893 | PRIMARY KEY (`region_id`) | 348 | PRIMARY KEY (`region_id`) |
894 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 349 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
895 | 350 | ||
896 | COMMIT; | 351 | CREATE TABLE IF NOT EXISTS `regionextra` ( |
897 | 352 | `RegionID` char(36) NOT NULL, | |
898 | :VERSION 45 | 353 | `Name` varchar(32) NOT NULL, |
899 | 354 | `value` text, | |
900 | BEGIN; | 355 | PRIMARY KEY (`RegionID`,`Name`) |
901 | 356 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
902 | CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`)); | ||
903 | |||
904 | COMMIT; | ||
905 | |||
906 | :VERSION 46 #---------------- Dynamic attributes | ||
907 | |||
908 | BEGIN; | ||
909 | |||
910 | ALTER TABLE prims ADD COLUMN DynAttrs TEXT; | ||
911 | |||
912 | COMMIT; | ||
913 | |||
914 | :VERSION 47 #---------------- Extra physics params | ||
915 | |||
916 | BEGIN; | ||
917 | |||
918 | ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0'; | ||
919 | ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000'; | ||
920 | ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1'; | ||
921 | ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6'; | ||
922 | ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5'; | ||
923 | |||
924 | COMMIT; | ||
925 | |||
926 | :VERSION 48 #---------------- Keyframes | ||
927 | |||
928 | BEGIN; | ||
929 | |||
930 | ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob; | ||
931 | |||
932 | COMMIT; | ||
933 | |||
934 | :VERSION 49 #--------------------- Save attachment info | ||
935 | |||
936 | BEGIN; | ||
937 | ALTER TABLE prims ADD COLUMN AttachedPosX double default 0; | ||
938 | ALTER TABLE prims ADD COLUMN AttachedPosY double default 0; | ||
939 | ALTER TABLE prims ADD COLUMN AttachedPosZ double default 0; | ||
940 | ALTER TABLE primshapes ADD COLUMN LastAttachPoint int(4) not null default '0'; | ||
941 | COMMIT; | ||
942 | |||
943 | :VERSION 50 #---- Change LandFlags to unsigned | ||
944 | |||
945 | BEGIN; | ||
946 | |||
947 | ALTER TABLE land CHANGE COLUMN LandFlags LandFlags int unsigned default null; | ||
948 | 357 | ||
949 | COMMIT; | 358 | COMMIT; |
950 | 359 | ||
951 | :VERSION 51 #---- avination fields | 360 | :VERSION 52 #---- avination fields |
952 | 361 | ||
953 | BEGIN; | 362 | BEGIN; |
954 | 363 | ||
@@ -962,7 +371,7 @@ ALTER TABLE `land` ADD COLUMN `GroupAVSounds` tinyint(4) NOT NULL default '1'; | |||
962 | 371 | ||
963 | COMMIT; | 372 | COMMIT; |
964 | 373 | ||
965 | :VERSION 52 #---- STATUS ROTATION axis locks | 374 | :VERSION 53 #---- STATUS ROTATION axis locks |
966 | 375 | ||
967 | BEGIN; | 376 | BEGIN; |
968 | 377 | ||
diff --git a/OpenSim/Data/MySQL/Resources/UserAccount.migrations b/OpenSim/Data/MySQL/Resources/UserAccount.migrations index 71f1cc4..b634343 100644 --- a/OpenSim/Data/MySQL/Resources/UserAccount.migrations +++ b/OpenSim/Data/MySQL/Resources/UserAccount.migrations | |||
@@ -1,54 +1,24 @@ | |||
1 | :VERSION 1 # ------------------------- | 1 | :VERSION 5 # ------------------------- |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `UserAccounts` ( | 5 | CREATE TABLE IF NOT EXISTS `useraccounts` ( |
6 | `PrincipalID` CHAR(36) NOT NULL, | 6 | `PrincipalID` char(36) NOT NULL, |
7 | `ScopeID` CHAR(36) NOT NULL, | 7 | `ScopeID` char(36) NOT NULL, |
8 | `FirstName` VARCHAR(64) NOT NULL, | 8 | `FirstName` varchar(64) NOT NULL, |
9 | `LastName` VARCHAR(64) NOT NULL, | 9 | `LastName` varchar(64) NOT NULL, |
10 | `Email` VARCHAR(64), | 10 | `Email` varchar(64) DEFAULT NULL, |
11 | `ServiceURLs` TEXT, | 11 | `ServiceURLs` text, |
12 | `Created` INT(11) | 12 | `Created` int(11) DEFAULT NULL, |
13 | `UserLevel` int(11) NOT NULL DEFAULT '0', | ||
14 | `UserFlags` int(11) NOT NULL DEFAULT '0', | ||
15 | `UserTitle` varchar(64) NOT NULL DEFAULT '', | ||
16 | UNIQUE KEY `PrincipalID` (`PrincipalID`), | ||
17 | KEY `Email` (`Email`), | ||
18 | KEY `FirstName` (`FirstName`), | ||
19 | KEY `LastName` (`LastName`), | ||
20 | KEY `Name` (`FirstName`,`LastName`) | ||
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 21 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
14 | 22 | ||
15 | COMMIT; | 23 | COMMIT; |
16 | 24 | ||
17 | :VERSION 2 # ------------------------- | ||
18 | |||
19 | BEGIN; | ||
20 | |||
21 | INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, lastname AS LastName, email as Email, CONCAT('AssetServerURI=', userAssetURI, ' InventoryServerURI=', userInventoryURI, ' GatewayURI= HomeURI=') AS ServiceURLs, created as Created FROM users; | ||
22 | |||
23 | COMMIT; | ||
24 | |||
25 | :VERSION 3 # ------------------------- | ||
26 | |||
27 | BEGIN; | ||
28 | |||
29 | CREATE UNIQUE INDEX PrincipalID ON UserAccounts(PrincipalID); | ||
30 | CREATE INDEX Email ON UserAccounts(Email); | ||
31 | CREATE INDEX FirstName ON UserAccounts(FirstName); | ||
32 | CREATE INDEX LastName ON UserAccounts(LastName); | ||
33 | CREATE INDEX Name ON UserAccounts(FirstName,LastName); | ||
34 | |||
35 | COMMIT; | ||
36 | |||
37 | :VERSION 4 # ------------------------- | ||
38 | |||
39 | BEGIN; | ||
40 | |||
41 | ALTER TABLE UserAccounts ADD COLUMN UserLevel integer NOT NULL DEFAULT 0; | ||
42 | ALTER TABLE UserAccounts ADD COLUMN UserFlags integer NOT NULL DEFAULT 0; | ||
43 | ALTER TABLE UserAccounts ADD COLUMN UserTitle varchar(64) NOT NULL DEFAULT ''; | ||
44 | |||
45 | COMMIT; | ||
46 | |||
47 | :VERSION 5 # ------------------------- | ||
48 | |||
49 | BEGIN; | ||
50 | |||
51 | ALTER TABLE `UserAccounts` ADD `active` INT NOT NULL DEFAULT '1'; | ||
52 | |||
53 | COMMIT; | ||
54 | |||
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations index 87e99fa..008e455 100644 --- a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | :VERSION 1 # ------------------------------- | 1 | :VERSION 5 # ------------------------------- |
2 | 2 | ||
3 | begin; | 3 | begin; |
4 | 4 | ||
@@ -44,6 +44,7 @@ CREATE TABLE IF NOT EXISTS `userpicks` ( | |||
44 | `posglobal` varchar(255) NOT NULL, | 44 | `posglobal` varchar(255) NOT NULL, |
45 | `sortorder` int(2) NOT NULL, | 45 | `sortorder` int(2) NOT NULL, |
46 | `enabled` enum('true','false') NOT NULL, | 46 | `enabled` enum('true','false') NOT NULL, |
47 | `gatekeeper` varchar(255), | ||
47 | PRIMARY KEY (`pickuuid`) | 48 | PRIMARY KEY (`pickuuid`) |
48 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 49 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
49 | 50 | ||
@@ -66,11 +67,6 @@ CREATE TABLE IF NOT EXISTS `userprofile` ( | |||
66 | PRIMARY KEY (`useruuid`) | 67 | PRIMARY KEY (`useruuid`) |
67 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 68 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
68 | 69 | ||
69 | commit; | ||
70 | |||
71 | :VERSION 2 # ------------------------------- | ||
72 | |||
73 | begin; | ||
74 | CREATE TABLE IF NOT EXISTS `userdata` ( | 70 | CREATE TABLE IF NOT EXISTS `userdata` ( |
75 | `UserId` char(36) NOT NULL, | 71 | `UserId` char(36) NOT NULL, |
76 | `TagId` varchar(64) NOT NULL, | 72 | `TagId` varchar(64) NOT NULL, |
@@ -79,10 +75,6 @@ CREATE TABLE IF NOT EXISTS `userdata` ( | |||
79 | PRIMARY KEY (`UserId`,`TagId`) | 75 | PRIMARY KEY (`UserId`,`TagId`) |
80 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 76 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
81 | 77 | ||
82 | commit; | ||
83 | |||
84 | :VERSION 3 # ------------------------------- | ||
85 | begin; | ||
86 | CREATE TABLE IF NOT EXISTS `usersettings` ( | 78 | CREATE TABLE IF NOT EXISTS `usersettings` ( |
87 | `useruuid` varchar(36) NOT NULL, | 79 | `useruuid` varchar(36) NOT NULL, |
88 | `imviaemail` enum('true','false') NOT NULL, | 80 | `imviaemail` enum('true','false') NOT NULL, |
@@ -90,9 +82,5 @@ CREATE TABLE IF NOT EXISTS `usersettings` ( | |||
90 | `email` varchar(254) NOT NULL, | 82 | `email` varchar(254) NOT NULL, |
91 | PRIMARY KEY (`useruuid`) | 83 | PRIMARY KEY (`useruuid`) |
92 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 84 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
93 | commit; | ||
94 | 85 | ||
95 | :VERSION 4 # ------------------------------- | ||
96 | begin; | ||
97 | ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255); | ||
98 | commit; | 86 | commit; |
diff --git a/OpenSim/Data/MySQL/Resources/UserStore.migrations b/OpenSim/Data/MySQL/Resources/UserStore.migrations deleted file mode 100644 index f054611..0000000 --- a/OpenSim/Data/MySQL/Resources/UserStore.migrations +++ /dev/null | |||
@@ -1,168 +0,0 @@ | |||
1 | :VERSION 1 # ----------------------------- | ||
2 | |||
3 | BEGIN; | ||
4 | |||
5 | SET FOREIGN_KEY_CHECKS=0; | ||
6 | -- ---------------------------- | ||
7 | -- Table structure for agents | ||
8 | -- ---------------------------- | ||
9 | CREATE TABLE `agents` ( | ||
10 | `UUID` varchar(36) NOT NULL, | ||
11 | `sessionID` varchar(36) NOT NULL, | ||
12 | `secureSessionID` varchar(36) NOT NULL, | ||
13 | `agentIP` varchar(16) NOT NULL, | ||
14 | `agentPort` int(11) NOT NULL, | ||
15 | `agentOnline` tinyint(4) NOT NULL, | ||
16 | `loginTime` int(11) NOT NULL, | ||
17 | `logoutTime` int(11) NOT NULL, | ||
18 | `currentRegion` varchar(36) NOT NULL, | ||
19 | `currentHandle` bigint(20) unsigned NOT NULL, | ||
20 | `currentPos` varchar(64) NOT NULL, | ||
21 | PRIMARY KEY (`UUID`), | ||
22 | UNIQUE KEY `session` (`sessionID`), | ||
23 | UNIQUE KEY `ssession` (`secureSessionID`) | ||
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
25 | |||
26 | -- Create schema avatar_appearance | ||
27 | -- | ||
28 | |||
29 | CREATE TABLE `avatarappearance` ( | ||
30 | Owner char(36) NOT NULL, | ||
31 | Serial int(10) unsigned NOT NULL, | ||
32 | Visual_Params blob NOT NULL, | ||
33 | Texture blob NOT NULL, | ||
34 | Avatar_Height float NOT NULL, | ||
35 | Body_Item char(36) NOT NULL, | ||
36 | Body_Asset char(36) NOT NULL, | ||
37 | Skin_Item char(36) NOT NULL, | ||
38 | Skin_Asset char(36) NOT NULL, | ||
39 | Hair_Item char(36) NOT NULL, | ||
40 | Hair_Asset char(36) NOT NULL, | ||
41 | Eyes_Item char(36) NOT NULL, | ||
42 | Eyes_Asset char(36) NOT NULL, | ||
43 | Shirt_Item char(36) NOT NULL, | ||
44 | Shirt_Asset char(36) NOT NULL, | ||
45 | Pants_Item char(36) NOT NULL, | ||
46 | Pants_Asset char(36) NOT NULL, | ||
47 | Shoes_Item char(36) NOT NULL, | ||
48 | Shoes_Asset char(36) NOT NULL, | ||
49 | Socks_Item char(36) NOT NULL, | ||
50 | Socks_Asset char(36) NOT NULL, | ||
51 | Jacket_Item char(36) NOT NULL, | ||
52 | Jacket_Asset char(36) NOT NULL, | ||
53 | Gloves_Item char(36) NOT NULL, | ||
54 | Gloves_Asset char(36) NOT NULL, | ||
55 | Undershirt_Item char(36) NOT NULL, | ||
56 | Undershirt_Asset char(36) NOT NULL, | ||
57 | Underpants_Item char(36) NOT NULL, | ||
58 | Underpants_Asset char(36) NOT NULL, | ||
59 | Skirt_Item char(36) NOT NULL, | ||
60 | Skirt_Asset char(36) NOT NULL, | ||
61 | PRIMARY KEY (`Owner`) | ||
62 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
63 | |||
64 | SET FOREIGN_KEY_CHECKS=0; | ||
65 | -- ---------------------------- | ||
66 | -- Table structure for users | ||
67 | -- ---------------------------- | ||
68 | CREATE TABLE `userfriends` ( | ||
69 | `ownerID` VARCHAR(37) NOT NULL, | ||
70 | `friendID` VARCHAR(37) NOT NULL, | ||
71 | `friendPerms` INT NOT NULL, | ||
72 | `datetimestamp` INT NOT NULL, | ||
73 | UNIQUE KEY (`ownerID`, `friendID`) | ||
74 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
75 | -- ---------------------------- | ||
76 | -- Table structure for users | ||
77 | -- ---------------------------- | ||
78 | CREATE TABLE `users` ( | ||
79 | `UUID` varchar(36) NOT NULL default '', | ||
80 | `username` varchar(32) NOT NULL, | ||
81 | `lastname` varchar(32) NOT NULL, | ||
82 | `passwordHash` varchar(32) NOT NULL, | ||
83 | `passwordSalt` varchar(32) NOT NULL, | ||
84 | `homeRegion` bigint(20) unsigned default NULL, | ||
85 | `homeLocationX` float default NULL, | ||
86 | `homeLocationY` float default NULL, | ||
87 | `homeLocationZ` float default NULL, | ||
88 | `homeLookAtX` float default NULL, | ||
89 | `homeLookAtY` float default NULL, | ||
90 | `homeLookAtZ` float default NULL, | ||
91 | `created` int(11) NOT NULL, | ||
92 | `lastLogin` int(11) NOT NULL, | ||
93 | `userInventoryURI` varchar(255) default NULL, | ||
94 | `userAssetURI` varchar(255) default NULL, | ||
95 | `profileCanDoMask` int(10) unsigned default NULL, | ||
96 | `profileWantDoMask` int(10) unsigned default NULL, | ||
97 | `profileAboutText` text, | ||
98 | `profileFirstText` text, | ||
99 | `profileImage` varchar(36) default NULL, | ||
100 | `profileFirstImage` varchar(36) default NULL, | ||
101 | `webLoginKey` varchar(36) default NULL, | ||
102 | PRIMARY KEY (`UUID`), | ||
103 | UNIQUE KEY `usernames` (`username`,`lastname`) | ||
104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
105 | |||
106 | -- ---------------------------- | ||
107 | -- Records | ||
108 | -- ---------------------------- | ||
109 | COMMIT; | ||
110 | |||
111 | :VERSION 2 # ----------------------------- | ||
112 | |||
113 | BEGIN; | ||
114 | |||
115 | ALTER TABLE users add homeRegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; | ||
116 | |||
117 | COMMIT; | ||
118 | |||
119 | :VERSION 3 # ----------------------------- | ||
120 | |||
121 | BEGIN; | ||
122 | |||
123 | ALTER TABLE users add userFlags integer NOT NULL default 0; | ||
124 | ALTER TABLE users add godLevel integer NOT NULL default 0; | ||
125 | |||
126 | COMMIT; | ||
127 | |||
128 | :VERSION 4 # ----------------------------- | ||
129 | |||
130 | BEGIN; | ||
131 | |||
132 | ALTER TABLE users add customType varchar(32) not null default ''; | ||
133 | ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
134 | |||
135 | COMMIT; | ||
136 | |||
137 | :VERSION 5 # ----------------------------- | ||
138 | |||
139 | BEGIN; | ||
140 | |||
141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=InnoDB; | ||
142 | |||
143 | COMMIT; | ||
144 | |||
145 | :VERSION 6 # ----------------------------- | ||
146 | |||
147 | BEGIN; | ||
148 | |||
149 | ALTER TABLE agents add currentLookAt varchar(36) not null default ''; | ||
150 | |||
151 | COMMIT; | ||
152 | |||
153 | :VERSION 7 # ----------------------------- | ||
154 | |||
155 | BEGIN; | ||
156 | |||
157 | ALTER TABLE users add email varchar(250); | ||
158 | |||
159 | COMMIT; | ||
160 | |||
161 | :VERSION 8 # ----------------------------- | ||
162 | |||
163 | BEGIN; | ||
164 | |||
165 | ALTER TABLE users add scopeID char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
166 | |||
167 | COMMIT; | ||
168 | |||