1 files changed, 144 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql b/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql
new file mode 100644
index 0000000..39e8180
--- /dev/null
+++ b/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql
@@ -0,0 +1,144 @@
+BEGIN TRANSACTION;
+CREATE TABLE prims(
+       UUID varchar(255) primary key,
+       RegionUUID varchar(255),
+       ParentID integer,
+       CreationDate integer,
+       Name varchar(255),
+       SceneGroupID varchar(255),
+       Text varchar(255),
+       Description varchar(255),
+       SitName varchar(255),
+       TouchName varchar(255),
+       CreatorID varchar(255),
+       OwnerID varchar(255),
+       GroupID varchar(255),
+       LastOwnerID varchar(255),
+       OwnerMask integer,
+       NextOwnerMask integer,
+       GroupMask integer,
+       EveryoneMask integer,
+       BaseMask integer,
+       PositionX float,
+       PositionY float,
+       PositionZ float,
+       GroupPositionX float,
+       GroupPositionY float,
+       GroupPositionZ float,
+       VelocityX float,
+       VelocityY float,
+       VelocityZ float,
+       AngularVelocityX float,
+       AngularVelocityY float,
+       AngularVelocityZ float,
+       AccelerationX float,
+       AccelerationY float,
+       AccelerationZ float,
+       RotationX float,
+       RotationY float,
+       RotationZ float,
+       RotationW float, 
+       ObjectFlags integer, 
+       SitTargetOffsetX float NOT NULL default 0, 
+       SitTargetOffsetY float NOT NULL default 0, 
+       SitTargetOffsetZ float NOT NULL default 0, 
+       SitTargetOrientW float NOT NULL default 0, 
+       SitTargetOrientX float NOT NULL default 0, 
+       SitTargetOrientY float NOT NULL default 0, 
+       SitTargetOrientZ float NOT NULL default 0);
+CREATE TABLE primshapes(
+       UUID varchar(255) primary key,
+       Shape integer,
+       ScaleX float,
+       ScaleY float,
+       ScaleZ float,
+       PCode integer,
+       PathBegin integer,
+       PathEnd integer,
+       PathScaleX integer,
+       PathScaleY integer,
+       PathShearX integer,
+       PathShearY integer,
+       PathSkew integer,
+       PathCurve integer,
+       PathRadiusOffset integer,
+       PathRevolutions integer,
+       PathTaperX integer,
+       PathTaperY integer,
+       PathTwist integer,
+       PathTwistBegin integer,
+       ProfileBegin integer,
+       ProfileEnd integer,
+       ProfileCurve integer,
+       ProfileHollow integer,
+       Texture blob,
+       ExtraParams blob, 
+       State Integer NOT NULL default 0);
+CREATE TABLE primitems(
+       itemID varchar(255) primary key,
+       primID varchar(255),
+       assetID varchar(255),
+       parentFolderID varchar(255),
+       invType integer,
+       assetType integer,
+       name varchar(255),
+       description varchar(255),
+       creationDate integer,
+       creatorID varchar(255),
+       ownerID varchar(255),
+       lastOwnerID varchar(255),
+       groupID varchar(255),
+       nextPermissions string,
+       currentPermissions string,
+       basePermissions string,
+       everyonePermissions string,
+       groupPermissions string);
+CREATE TABLE terrain(
+       RegionUUID varchar(255),
+       Revision integer,
+       Heightfield blob);
+CREATE TABLE land(
+       UUID varchar(255) primary key,
+       RegionUUID varchar(255),
+       LocalLandID string,
+       Bitmap blob,
+       Name varchar(255),
+       Desc varchar(255),
+       OwnerUUID varchar(255),
+       IsGroupOwned string,
+       Area integer,
+       AuctionID integer,
+       Category integer,
+       ClaimDate integer,
+       ClaimPrice integer,
+       GroupUUID varchar(255),
+       SalePrice integer,
+       LandStatus integer,
+       LandFlags string,
+       LandingType string,
+       MediaAutoScale string,
+       MediaTextureUUID varchar(255),
+       MediaURL varchar(255),
+       MusicURL varchar(255),
+       PassHours float,
+       PassPrice string,
+       SnapshotUUID varchar(255),
+       UserLocationX float,
+       UserLocationY float,
+       UserLocationZ float,
+       UserLookAtX float,
+       UserLookAtY float,
+       UserLookAtZ float, 
+       AuthbuyerID varchar(36) NOT NULL default  '00000000-0000-0000-0000-000000000000');
+CREATE TABLE landaccesslist(
+       LandUUID varchar(255),
+       AccessUUID varchar(255),
+       Flags string);
+COMMIT;

diff --git a/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql b/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql new file mode 100644 index 0000000..39e8180 --- /dev/null +++ b/OpenSim/Data/SQLiteNG/Resources/001_RegionStore.sql
@@ -0,0 +1,144 @@
	1	BEGIN TRANSACTION;
	2
	3	CREATE TABLE prims(
	4	UUID varchar(255) primary key,
	5	RegionUUID varchar(255),
	6	ParentID integer,
	7	CreationDate integer,
	8	Name varchar(255),
	9	SceneGroupID varchar(255),
	10	Text varchar(255),
	11	Description varchar(255),
	12	SitName varchar(255),
	13	TouchName varchar(255),
	14	CreatorID varchar(255),
	15	OwnerID varchar(255),
	16	GroupID varchar(255),
	17	LastOwnerID varchar(255),
	18	OwnerMask integer,
	19	NextOwnerMask integer,
	20	GroupMask integer,
	21	EveryoneMask integer,
	22	BaseMask integer,
	23	PositionX float,
	24	PositionY float,
	25	PositionZ float,
	26	GroupPositionX float,
	27	GroupPositionY float,
	28	GroupPositionZ float,
	29	VelocityX float,
	30	VelocityY float,
	31	VelocityZ float,
	32	AngularVelocityX float,
	33	AngularVelocityY float,
	34	AngularVelocityZ float,
	35	AccelerationX float,
	36	AccelerationY float,
	37	AccelerationZ float,
	38	RotationX float,
	39	RotationY float,
	40	RotationZ float,
	41	RotationW float,
	42	ObjectFlags integer,
	43	SitTargetOffsetX float NOT NULL default 0,
	44	SitTargetOffsetY float NOT NULL default 0,
	45	SitTargetOffsetZ float NOT NULL default 0,
	46	SitTargetOrientW float NOT NULL default 0,
	47	SitTargetOrientX float NOT NULL default 0,
	48	SitTargetOrientY float NOT NULL default 0,
	49	SitTargetOrientZ float NOT NULL default 0);
	50
	51	CREATE TABLE primshapes(
	52	UUID varchar(255) primary key,
	53	Shape integer,
	54	ScaleX float,
	55	ScaleY float,
	56	ScaleZ float,
	57	PCode integer,
	58	PathBegin integer,
	59	PathEnd integer,
	60	PathScaleX integer,
	61	PathScaleY integer,
	62	PathShearX integer,
	63	PathShearY integer,
	64	PathSkew integer,
	65	PathCurve integer,
	66	PathRadiusOffset integer,
	67	PathRevolutions integer,
	68	PathTaperX integer,
	69	PathTaperY integer,
	70	PathTwist integer,
	71	PathTwistBegin integer,
	72	ProfileBegin integer,
	73	ProfileEnd integer,
	74	ProfileCurve integer,
	75	ProfileHollow integer,
	76	Texture blob,
	77	ExtraParams blob,
	78	State Integer NOT NULL default 0);
	79
	80	CREATE TABLE primitems(
	81	itemID varchar(255) primary key,
	82	primID varchar(255),
	83	assetID varchar(255),
	84	parentFolderID varchar(255),
	85	invType integer,
	86	assetType integer,
	87	name varchar(255),
	88	description varchar(255),
	89	creationDate integer,
	90	creatorID varchar(255),
	91	ownerID varchar(255),
	92	lastOwnerID varchar(255),
	93	groupID varchar(255),
	94	nextPermissions string,
	95	currentPermissions string,
	96	basePermissions string,
	97	everyonePermissions string,
	98	groupPermissions string);
	99
	100	CREATE TABLE terrain(
	101	RegionUUID varchar(255),
	102	Revision integer,
	103	Heightfield blob);
	104
	105	CREATE TABLE land(
	106	UUID varchar(255) primary key,
	107	RegionUUID varchar(255),
	108	LocalLandID string,
	109	Bitmap blob,
	110	Name varchar(255),
	111	Desc varchar(255),
	112	OwnerUUID varchar(255),
	113	IsGroupOwned string,
	114	Area integer,
	115	AuctionID integer,
	116	Category integer,
	117	ClaimDate integer,
	118	ClaimPrice integer,
	119	GroupUUID varchar(255),
	120	SalePrice integer,
	121	LandStatus integer,
	122	LandFlags string,
	123	LandingType string,
	124	MediaAutoScale string,
	125	MediaTextureUUID varchar(255),
	126	MediaURL varchar(255),
	127	MusicURL varchar(255),
	128	PassHours float,
	129	PassPrice string,
	130	SnapshotUUID varchar(255),
	131	UserLocationX float,
	132	UserLocationY float,
	133	UserLocationZ float,
	134	UserLookAtX float,
	135	UserLookAtY float,
	136	UserLookAtZ float,
	137	AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000');
	138
	139	CREATE TABLE landaccesslist(
	140	LandUUID varchar(255),
	141	AccessUUID varchar(255),
	142	Flags string);
	143
	144	COMMIT;