3 files changed, 219 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
new file mode 100644
index 0000000..1cb18e3
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
@@ -0,0 +1,38 @@
+BEGIN TRANSACTION;
+create table Regions (
+  Uuid NVARCHAR(255) not null,
+   RegionHandle BIGINT null,
+   RegionName NVARCHAR(32) null,
+   RegionRecvKey NVARCHAR(128) null,
+   RegionSendKey NVARCHAR(128) null,
+   RegionSecret NVARCHAR(128) null,
+   RegionDataURI NVARCHAR(255) null,
+   ServerIP NVARCHAR(64) null,
+   ServerPort INT null,
+   ServerURI NVARCHAR(255) null,
+   RegionLocX INT null,
+   RegionLocY INT null,
+   RegionLocZ INT null,
+   EastOverrideHandle BIGINT null,
+   WestOverrideHandle BIGINT null,
+   SouthOverrideHandle BIGINT null,
+   NorthOverrideHandle BIGINT null,
+   RegionAssetURI NVARCHAR(255) null,
+   RegionAssetRecvKey NVARCHAR(128) null,
+   RegionAssetSendKey NVARCHAR(128) null,
+   RegionUserURI NVARCHAR(255) null,
+   RegionUserRecvKey NVARCHAR(128) null,
+   RegionUserSendKey NVARCHAR(128) null,
+   ServerHttpPort INT null,
+   ServerRemotingPort INT null,
+   RegionMapTextureID NVARCHAR(255) null,
+   Owner_uuid NVARCHAR(255) null,
+   OriginUUID NVARCHAR(255) null,
+   primary key (Uuid)
+);
+create index region_handle on Regions (RegionHandle);
+create index region_name on Regions (RegionName);
+COMMIT;
+\ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
new file mode 100644
index 0000000..d557b9a
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
@@ -0,0 +1,102 @@
+BEGIN TRANSACTION;
+create table Prims (
+  UUID TEXT not null,
+   ParentID INTEGER,
+   ParentUUID TEXT,
+   RegionID TEXT,
+   CreationDate INTEGER,
+   Name TEXT,
+   Text TEXT,
+   Description TEXT,
+   SitName TEXT,
+   TouchName TEXT,
+   ObjectFlags INTEGER,
+   CreatorID TEXT,
+   OwnerID TEXT,
+   GroupID TEXT,
+   LastOwnerID TEXT,
+   OwnerMask INTEGER,
+   NextOwnerMask INTEGER,
+   GroupMask INTEGER,
+   EveryoneMask INTEGER,
+   BaseMask INTEGER,
+   PositionX NUMERIC,
+   PositionY NUMERIC,
+   PositionZ NUMERIC,
+   GroupPositionX NUMERIC,
+   GroupPositionY NUMERIC,
+   GroupPositionZ NUMERIC,
+   VelocityX NUMERIC,
+   VelocityY NUMERIC,
+   VelocityZ NUMERIC,
+   AngularVelocityX NUMERIC,
+   AngularVelocityY NUMERIC,
+   AngularVelocityZ NUMERIC,
+   AccelerationX NUMERIC,
+   AccelerationY NUMERIC,
+   AccelerationZ NUMERIC,
+   SitTargetOffsetX NUMERIC,
+   SitTargetOffsetY NUMERIC,
+   SitTargetOffsetZ NUMERIC,
+   RotationX NUMERIC,
+   RotationY NUMERIC,
+   RotationZ NUMERIC,
+   RotationW NUMERIC,
+   SitTargetOrientX NUMERIC,
+   SitTargetOrientY NUMERIC,
+   SitTargetOrientZ NUMERIC,
+   SitTargetOrientW NUMERIC,
+   ScaleX NUMERIC,
+   ScaleY NUMERIC,
+   ScaleZ NUMERIC,
+   PCode INTEGER,
+   PathBegin INTEGER,
+   PathEnd INTEGER,
+   PathScaleX INTEGER,
+   PathScaleY INTEGER,
+   PathShearX INTEGER,
+   PathShearY INTEGER,
+   PathSkew INTEGER,
+   PathCurve INTEGER,
+   PathRadiusOffset INTEGER,
+   PathRevolutions INTEGER,
+   PathTaperX INTEGER,
+   PathTwist INTEGER,
+   ProfileBegin INTEGER,
+   ProfileEnd INTEGER,
+   ProfileCurve INTEGER,
+   ProfileHollow INTEGER,
+   Texture BLOB,
+   ExtraParams BLOB,
+   State INTEGER,
+   primary key (UUID)
+);
+create table Terrain (
+  RegionID TEXT not null,
+   MapData BLOB,
+   primary key (RegionID)
+);
+create table PrimItems (
+  ItemID TEXT not null,
+   PrimID TEXT,
+   AssetID TEXT,
+   ParentFolderID TEXT,
+   CreatorID TEXT,
+   OwnerID TEXT,
+   GroupID TEXT,
+   LastOwnerID TEXT,
+   CurrentPermissions INTEGER,
+   BasePermissions INTEGER,
+   EveryonePermissions INTEGER,
+   GroupPermissions INTEGER,
+   NextPermissions INTEGER,
+   Name TEXT,
+   Description TEXT,
+   CreationDate INTEGER,
+   Flags INTEGER,
+   InvType INTEGER,
+   primary key (ItemID)
+);
+COMMIT;
+\ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
new file mode 100644
index 0000000..8d1ba5c
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
@@ -0,0 +1,79 @@
+BEGIN TRANSACTION;
+create table UserAgents (
+  ProfileID TEXT not null,
+   AgentIP TEXT,
+   AgentPort INTEGER,
+   AgentOnline INTEGER,
+   SessionID TEXT,
+   SecureSessionID TEXT,
+   InitialRegion TEXT,
+   Region TEXT,
+   LoginTime INTEGER,
+   LogoutTime INTEGER,
+   Handle INTEGER,
+   primary key (ProfileID)
+);
+create table UserProfiles (
+  ID TEXT not null,
+   FirstName TEXT,
+   SurName TEXT,
+   PasswordHash TEXT,
+   PasswordSalt TEXT,
+   WebLoginKey TEXT,
+   HomeRegionX INTEGER,
+   HomeRegionY INTEGER,
+   HomeLocationX NUMERIC,
+   HomeLocationY NUMERIC,
+   HomeLocationZ NUMERIC,
+   HomeLookAtX NUMERIC,
+   HomeLookAtY NUMERIC,
+   HomeLookAtZ NUMERIC,
+   Created INTEGER,
+   LastLogin INTEGER,
+   RootInventoryFolderID TEXT,
+   UserInventoryURI TEXT,
+   UserAssetURI TEXT,
+   Image TEXT,
+   FirstLifeImage TEXT,
+   AboutText TEXT,
+   FirstLifeAboutText TEXT,
+   primary key (ID)
+);
+create table UserAppearances (
+  Owner TEXT not null,
+   BodyItem TEXT,
+   BodyAsset TEXT,
+   SkinItem TEXT,
+   SkinAsset TEXT,
+   HairItem TEXT,
+   HairAsset TEXT,
+   EyesItem TEXT,
+   EyesAsset TEXT,
+   ShirtItem TEXT,
+   ShirtAsset TEXT,
+   PantsItem TEXT,
+   PantsAsset TEXT,
+   ShoesItem TEXT,
+   ShoesAsset TEXT,
+   SocksItem TEXT,
+   SocksAsset TEXT,
+   JacketItem TEXT,
+   JacketAsset TEXT,
+   GlovesItem TEXT,
+   GlovesAsset TEXT,
+   UnderShirtItem TEXT,
+   UnderShirtAsset TEXT,
+   UnderPantsItem TEXT,
+   UnderPantsAsset TEXT,
+   SkirtItem TEXT,
+   SkirtAsset TEXT,
+   Texture BLOB,
+   VisualParams BLOB,
+   Serial INTEGER,
+   primary key (Owner)
+);
+create index user_firstname on UserProfiles (FirstName);
+create index user_surname on UserProfiles (SurName);
+COMMIT;
+\ No newline at end of file

diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql new file mode 100644 index 0000000..1cb18e3 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
@@ -0,0 +1,38 @@
	1	BEGIN TRANSACTION;
	2
	3	create table Regions (
	4	Uuid NVARCHAR(255) not null,
	5	RegionHandle BIGINT null,
	6	RegionName NVARCHAR(32) null,
	7	RegionRecvKey NVARCHAR(128) null,
	8	RegionSendKey NVARCHAR(128) null,
	9	RegionSecret NVARCHAR(128) null,
	10	RegionDataURI NVARCHAR(255) null,
	11	ServerIP NVARCHAR(64) null,
	12	ServerPort INT null,
	13	ServerURI NVARCHAR(255) null,
	14	RegionLocX INT null,
	15	RegionLocY INT null,
	16	RegionLocZ INT null,
	17	EastOverrideHandle BIGINT null,
	18	WestOverrideHandle BIGINT null,
	19	SouthOverrideHandle BIGINT null,
	20	NorthOverrideHandle BIGINT null,
	21	RegionAssetURI NVARCHAR(255) null,
	22	RegionAssetRecvKey NVARCHAR(128) null,
	23	RegionAssetSendKey NVARCHAR(128) null,
	24	RegionUserURI NVARCHAR(255) null,
	25	RegionUserRecvKey NVARCHAR(128) null,
	26	RegionUserSendKey NVARCHAR(128) null,
	27	ServerHttpPort INT null,
	28	ServerRemotingPort INT null,
	29	RegionMapTextureID NVARCHAR(255) null,
	30	Owner_uuid NVARCHAR(255) null,
	31	OriginUUID NVARCHAR(255) null,
	32	primary key (Uuid)
	33	);
	34
	35	create index region_handle on Regions (RegionHandle);
	36	create index region_name on Regions (RegionName);
	37
	38	COMMIT; \ No newline at end of file


diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql new file mode 100644 index 0000000..d557b9a --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
@@ -0,0 +1,102 @@
	1	BEGIN TRANSACTION;
	2
	3	create table Prims (
	4	UUID TEXT not null,
	5	ParentID INTEGER,
	6	ParentUUID TEXT,
	7	RegionID TEXT,
	8	CreationDate INTEGER,
	9	Name TEXT,
	10	Text TEXT,
	11	Description TEXT,
	12	SitName TEXT,
	13	TouchName TEXT,
	14	ObjectFlags INTEGER,
	15	CreatorID TEXT,
	16	OwnerID TEXT,
	17	GroupID TEXT,
	18	LastOwnerID TEXT,
	19	OwnerMask INTEGER,
	20	NextOwnerMask INTEGER,
	21	GroupMask INTEGER,
	22	EveryoneMask INTEGER,
	23	BaseMask INTEGER,
	24	PositionX NUMERIC,
	25	PositionY NUMERIC,
	26	PositionZ NUMERIC,
	27	GroupPositionX NUMERIC,
	28	GroupPositionY NUMERIC,
	29	GroupPositionZ NUMERIC,
	30	VelocityX NUMERIC,
	31	VelocityY NUMERIC,
	32	VelocityZ NUMERIC,
	33	AngularVelocityX NUMERIC,
	34	AngularVelocityY NUMERIC,
	35	AngularVelocityZ NUMERIC,
	36	AccelerationX NUMERIC,
	37	AccelerationY NUMERIC,
	38	AccelerationZ NUMERIC,
	39	SitTargetOffsetX NUMERIC,
	40	SitTargetOffsetY NUMERIC,
	41	SitTargetOffsetZ NUMERIC,
	42	RotationX NUMERIC,
	43	RotationY NUMERIC,
	44	RotationZ NUMERIC,
	45	RotationW NUMERIC,
	46	SitTargetOrientX NUMERIC,
	47	SitTargetOrientY NUMERIC,
	48	SitTargetOrientZ NUMERIC,
	49	SitTargetOrientW NUMERIC,
	50	ScaleX NUMERIC,
	51	ScaleY NUMERIC,
	52	ScaleZ NUMERIC,
	53	PCode INTEGER,
	54	PathBegin INTEGER,
	55	PathEnd INTEGER,
	56	PathScaleX INTEGER,
	57	PathScaleY INTEGER,
	58	PathShearX INTEGER,
	59	PathShearY INTEGER,
	60	PathSkew INTEGER,
	61	PathCurve INTEGER,
	62	PathRadiusOffset INTEGER,
	63	PathRevolutions INTEGER,
	64	PathTaperX INTEGER,
	65	PathTwist INTEGER,
	66	ProfileBegin INTEGER,
	67	ProfileEnd INTEGER,
	68	ProfileCurve INTEGER,
	69	ProfileHollow INTEGER,
	70	Texture BLOB,
	71	ExtraParams BLOB,
	72	State INTEGER,
	73	primary key (UUID)
	74	);
	75	create table Terrain (
	76	RegionID TEXT not null,
	77	MapData BLOB,
	78	primary key (RegionID)
	79	);
	80	create table PrimItems (
	81	ItemID TEXT not null,
	82	PrimID TEXT,
	83	AssetID TEXT,
	84	ParentFolderID TEXT,
	85	CreatorID TEXT,
	86	OwnerID TEXT,
	87	GroupID TEXT,
	88	LastOwnerID TEXT,
	89	CurrentPermissions INTEGER,
	90	BasePermissions INTEGER,
	91	EveryonePermissions INTEGER,
	92	GroupPermissions INTEGER,
	93	NextPermissions INTEGER,
	94	Name TEXT,
	95	Description TEXT,
	96	CreationDate INTEGER,
	97	Flags INTEGER,
	98	InvType INTEGER,
	99	primary key (ItemID)
	100	);
	101
	102	COMMIT; \ No newline at end of file


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