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