add mysql migrations for nhibernate driver

author: Sean Dague 2008-06-18 21:08:16 +0000
committer: Sean Dague 2008-06-18 21:08:16 +0000
commit: b58dc7fb3320b8da2771d69921b7b8bb96e32806 (patch)
tree: 7c4f85e819479ebce8718f5e16cb924109b213a0
parent: Mantis#1567. Thank you kindly, Dmiles for a patch that addresses: (diff)
download: opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.zip
opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.gz
opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.bz2
opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.xz
3 files changed, 136 insertions, 10 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
index 6e0b61a..3484b64 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -1,14 +1,15 @@
 START TRANSACTION;
-create table Assets(
+CREATE TABLE `Assets` (
-       ID varchar(36) not null primary key,
+  `ID` char(36) NOT NULL,
-       Type int default 0,
+  `Type` smallint(6) default NULL,
-       InvType int default 0,
+  `InvType` smallint(6) default NULL,
-       Name varchar(64),
+  `Name` varchar(64) default NULL,
-       Description varchar(64),
+  `Description` varchar(64) default NULL,
-       Local boolean,
+  `Local` tinyint(1) default NULL,
-       Temporary boolean,
+  `Temporary` tinyint(1) default NULL,
-       Data blob
+  `Data` longblob,
-);
+  PRIMARY KEY  (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 COMMIT;
 \ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
new file mode 100644
index 0000000..80afaa0
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
@@ -0,0 +1,41 @@
+START TRANSACTION;
+CREATE TABLE `InventoryFolders` (
+  `ID` char(36) NOT NULL,
+  `Type` int(11) default NULL,
+  `Version` int(11) default NULL,
+  `ParentID` char(36) default NULL,
+  `Owner` char(36) default NULL,
+  `Name` varchar(64) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `folder_owner_id` (`Owner`),
+  KEY `folder_parent_id` (`ParentID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+CREATE TABLE `InventoryItems` (
+  `ID` char(36) NOT NULL,
+  `InvType` smallint(6) default NULL,
+  `AssetType` smallint(6) default NULL,
+  `AssetID` char(36) default NULL,
+  `Folder` char(36) default NULL,
+  `Owner` char(36) default NULL,
+  `Creator` char(36) default NULL,
+  `Name` varchar(64) default NULL,
+  `Description` varchar(64) default NULL,
+  `NextPermissions` int(11) default NULL,
+  `CurrentPermissions` int(11) default NULL,
+  `BasePermissions` int(11) default NULL,
+  `EveryOnePermissions` int(11) default NULL,
+  `GroupID` char(36) default NULL,
+  `GroupOwned` tinyint(1) default NULL,
+  `SalePrice` int(11) default NULL,
+  `SaleType` smallint(6) default NULL,
+  `Flags` int(11) default NULL,
+  `CreationDate` int(11) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `item_group_id` (`GroupID`),
+  KEY `item_owner_id` (`Owner`),
+  KEY `item_folder_id` (`Folder`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+COMMIT;
+\ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
new file mode 100644
index 0000000..5db5d29
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
@@ -0,0 +1,84 @@
+START TRANSACTION;
+CREATE TABLE `UserAgents` (
+  `ProfileID` varchar(255) NOT NULL,
+  `AgentIP` varchar(24) default NULL,
+  `AgentPort` int(11) default NULL,
+  `AgentOnline` tinyint(1) default NULL,
+  `SessionID` varchar(255) default NULL,
+  `SecureSessionID` varchar(255) default NULL,
+  `InitialRegion` varchar(255) default NULL,
+  `Region` varchar(255) default NULL,
+  `LoginTime` int(11) default NULL,
+  `LogoutTime` int(11) default NULL,
+  `Handle` bigint(20) default NULL,
+  `PositionX` float default NULL,
+  `PositionY` float default NULL,
+  `PositionZ` float default NULL,
+  PRIMARY KEY  (`ProfileID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+CREATE TABLE `UserProfiles` (
+  `ID` varchar(255) NOT NULL,
+  `FirstName` varchar(32) default NULL,
+  `SurName` varchar(32) default NULL,
+  `PasswordHash` varchar(32) default NULL,
+  `PasswordSalt` varchar(32) default NULL,
+  `WebLoginKey` varchar(255) default NULL,
+  `HomeRegionX` int(11) default NULL,
+  `HomeRegionY` int(11) default NULL,
+  `HomeLocationX` float default NULL,
+  `HomeLocationY` float default NULL,
+  `HomeLocationZ` float default NULL,
+  `HomeLookAtX` float default NULL,
+  `HomeLookAtY` float default NULL,
+  `HomeLookAtZ` float default NULL,
+  `Created` int(11) default NULL,
+  `LastLogin` int(11) default NULL,
+  `RootInventoryFolderID` varchar(255) default NULL,
+  `UserInventoryURI` varchar(255) default NULL,
+  `UserAssetURI` varchar(255) default NULL,
+  `Image` varchar(255) default NULL,
+  `FirstLifeImage` varchar(255) default NULL,
+  `AboutText` varchar(255) default NULL,
+  `FirstLifeAboutText` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `user_surname` (`SurName`),
+  KEY `user_firstname` (`FirstName`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+CREATE TABLE `UserAppearances` (
+  `Owner` varchar(255) NOT NULL,
+  `BodyItem` varchar(255) default NULL,
+  `BodyAsset` varchar(255) default NULL,
+  `SkinItem` varchar(255) default NULL,
+  `SkinAsset` varchar(255) default NULL,
+  `HairItem` varchar(255) default NULL,
+  `HairAsset` varchar(255) default NULL,
+  `EyesItem` varchar(255) default NULL,
+  `EyesAsset` varchar(255) default NULL,
+  `ShirtItem` varchar(255) default NULL,
+  `ShirtAsset` varchar(255) default NULL,
+  `PantsItem` varchar(255) default NULL,
+  `PantsAsset` varchar(255) default NULL,
+  `ShoesItem` varchar(255) default NULL,
+  `ShoesAsset` varchar(255) default NULL,
+  `SocksItem` varchar(255) default NULL,
+  `SocksAsset` varchar(255) default NULL,
+  `JacketItem` varchar(255) default NULL,
+  `JacketAsset` varchar(255) default NULL,
+  `GlovesItem` varchar(255) default NULL,
+  `GlovesAsset` varchar(255) default NULL,
+  `UnderShirtItem` varchar(255) default NULL,
+  `UnderShirtAsset` varchar(255) default NULL,
+  `UnderPantsItem` varchar(255) default NULL,
+  `UnderPantsAsset` varchar(255) default NULL,
+  `SkirtItem` varchar(255) default NULL,
+  `SkirtAsset` varchar(255) default NULL,
+  `Texture` longblob,
+  `VisualParams` longblob,
+  `Serial` int(11) default NULL,
+  PRIMARY KEY  (`Owner`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+COMMIT;
+\ No newline at end of file
author	Sean Dague	2008-06-18 21:08:16 +0000
committer	Sean Dague	2008-06-18 21:08:16 +0000
commit	b58dc7fb3320b8da2771d69921b7b8bb96e32806 (patch)
tree	7c4f85e819479ebce8718f5e16cb924109b213a0
parent	Mantis#1567. Thank you kindly, Dmiles for a patch that addresses: (diff)
download	opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.zip opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.gz opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.bz2 opensim-SC-b58dc7fb3320b8da2771d69921b7b8bb96e32806.tar.xz

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql index 6e0b61a..3484b64 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
@@ -1,14 +1,15 @@
1	START TRANSACTION;	1	START TRANSACTION;
2		2
3	create table Assets(	3	CREATE TABLE `Assets` (
4	ID varchar(36) not null primary key,	4	`ID` char(36) NOT NULL,
5	Type int default 0,	5	`Type` smallint(6) default NULL,
6	InvType int default 0,	6	`InvType` smallint(6) default NULL,
7	Name varchar(64),	7	`Name` varchar(64) default NULL,
8	Description varchar(64),	8	`Description` varchar(64) default NULL,
9	Local boolean,	9	`Local` tinyint(1) default NULL,
10	Temporary boolean,	10	`Temporary` tinyint(1) default NULL,
11	Data blob	11	`Data` longblob,
12	);	12	PRIMARY KEY (`ID`)
		13	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13		14
14	COMMIT; \ No newline at end of file	15	COMMIT; \ No newline at end of file


diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql new file mode 100644 index 0000000..80afaa0 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
@@ -0,0 +1,41 @@
		1	START TRANSACTION;
		2
		3	CREATE TABLE `InventoryFolders` (
		4	`ID` char(36) NOT NULL,
		5	`Type` int(11) default NULL,
		6	`Version` int(11) default NULL,
		7	`ParentID` char(36) default NULL,
		8	`Owner` char(36) default NULL,
		9	`Name` varchar(64) default NULL,
		10	PRIMARY KEY (`ID`),
		11	KEY `folder_owner_id` (`Owner`),
		12	KEY `folder_parent_id` (`ParentID`)
		13	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		14
		15	CREATE TABLE `InventoryItems` (
		16	`ID` char(36) NOT NULL,
		17	`InvType` smallint(6) default NULL,
		18	`AssetType` smallint(6) default NULL,
		19	`AssetID` char(36) default NULL,
		20	`Folder` char(36) default NULL,
		21	`Owner` char(36) default NULL,
		22	`Creator` char(36) default NULL,
		23	`Name` varchar(64) default NULL,
		24	`Description` varchar(64) default NULL,
		25	`NextPermissions` int(11) default NULL,
		26	`CurrentPermissions` int(11) default NULL,
		27	`BasePermissions` int(11) default NULL,
		28	`EveryOnePermissions` int(11) default NULL,
		29	`GroupID` char(36) default NULL,
		30	`GroupOwned` tinyint(1) default NULL,
		31	`SalePrice` int(11) default NULL,
		32	`SaleType` smallint(6) default NULL,
		33	`Flags` int(11) default NULL,
		34	`CreationDate` int(11) default NULL,
		35	PRIMARY KEY (`ID`),
		36	KEY `item_group_id` (`GroupID`),
		37	KEY `item_owner_id` (`Owner`),
		38	KEY `item_folder_id` (`Folder`)
		39	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		40
		41	COMMIT; \ No newline at end of file


diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql new file mode 100644 index 0000000..5db5d29 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
@@ -0,0 +1,84 @@
		1	START TRANSACTION;
		2
		3	CREATE TABLE `UserAgents` (
		4	`ProfileID` varchar(255) NOT NULL,
		5	`AgentIP` varchar(24) default NULL,
		6	`AgentPort` int(11) default NULL,
		7	`AgentOnline` tinyint(1) default NULL,
		8	`SessionID` varchar(255) default NULL,
		9	`SecureSessionID` varchar(255) default NULL,
		10	`InitialRegion` varchar(255) default NULL,
		11	`Region` varchar(255) default NULL,
		12	`LoginTime` int(11) default NULL,
		13	`LogoutTime` int(11) default NULL,
		14	`Handle` bigint(20) default NULL,
		15	`PositionX` float default NULL,
		16	`PositionY` float default NULL,
		17	`PositionZ` float default NULL,
		18	PRIMARY KEY (`ProfileID`)
		19	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		20
		21	CREATE TABLE `UserProfiles` (
		22	`ID` varchar(255) NOT NULL,
		23	`FirstName` varchar(32) default NULL,
		24	`SurName` varchar(32) default NULL,
		25	`PasswordHash` varchar(32) default NULL,
		26	`PasswordSalt` varchar(32) default NULL,
		27	`WebLoginKey` varchar(255) default NULL,
		28	`HomeRegionX` int(11) default NULL,
		29	`HomeRegionY` int(11) default NULL,
		30	`HomeLocationX` float default NULL,
		31	`HomeLocationY` float default NULL,
		32	`HomeLocationZ` float default NULL,
		33	`HomeLookAtX` float default NULL,
		34	`HomeLookAtY` float default NULL,
		35	`HomeLookAtZ` float default NULL,
		36	`Created` int(11) default NULL,
		37	`LastLogin` int(11) default NULL,
		38	`RootInventoryFolderID` varchar(255) default NULL,
		39	`UserInventoryURI` varchar(255) default NULL,
		40	`UserAssetURI` varchar(255) default NULL,
		41	`Image` varchar(255) default NULL,
		42	`FirstLifeImage` varchar(255) default NULL,
		43	`AboutText` varchar(255) default NULL,
		44	`FirstLifeAboutText` varchar(255) default NULL,
		45	PRIMARY KEY (`ID`),
		46	KEY `user_surname` (`SurName`),
		47	KEY `user_firstname` (`FirstName`)
		48	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		49
		50	CREATE TABLE `UserAppearances` (
		51	`Owner` varchar(255) NOT NULL,
		52	`BodyItem` varchar(255) default NULL,
		53	`BodyAsset` varchar(255) default NULL,
		54	`SkinItem` varchar(255) default NULL,
		55	`SkinAsset` varchar(255) default NULL,
		56	`HairItem` varchar(255) default NULL,
		57	`HairAsset` varchar(255) default NULL,
		58	`EyesItem` varchar(255) default NULL,
		59	`EyesAsset` varchar(255) default NULL,
		60	`ShirtItem` varchar(255) default NULL,
		61	`ShirtAsset` varchar(255) default NULL,
		62	`PantsItem` varchar(255) default NULL,
		63	`PantsAsset` varchar(255) default NULL,
		64	`ShoesItem` varchar(255) default NULL,
		65	`ShoesAsset` varchar(255) default NULL,
		66	`SocksItem` varchar(255) default NULL,
		67	`SocksAsset` varchar(255) default NULL,
		68	`JacketItem` varchar(255) default NULL,
		69	`JacketAsset` varchar(255) default NULL,
		70	`GlovesItem` varchar(255) default NULL,
		71	`GlovesAsset` varchar(255) default NULL,
		72	`UnderShirtItem` varchar(255) default NULL,
		73	`UnderShirtAsset` varchar(255) default NULL,
		74	`UnderPantsItem` varchar(255) default NULL,
		75	`UnderPantsAsset` varchar(255) default NULL,
		76	`SkirtItem` varchar(255) default NULL,
		77	`SkirtAsset` varchar(255) default NULL,
		78	`Texture` longblob,
		79	`VisualParams` longblob,
		80	`Serial` int(11) default NULL,
		81	PRIMARY KEY (`Owner`)
		82	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		83
		84	COMMIT; \ No newline at end of file