1 files changed, 122 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
new file mode 100644
index 0000000..15f3d9f
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
@@ -0,0 +1,122 @@
+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,
+        State integer,
+        Texture blob,
+        ExtraParams blob);
+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(36),
+        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);
+CREATE TABLE landaccesslist(
+        LandUUID varchar(255),
+        AccessUUID varchar(255),
+        Flags string);
+COMMIT;

diff --git a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql new file mode 100644 index 0000000..15f3d9f --- /dev/null +++ b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
@@ -0,0 +1,122 @@
	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(UUID varchar(255) primary key,
	52	Shape integer,
	53	ScaleX float,
	54	ScaleY float,
	55	ScaleZ float,
	56	PCode integer,
	57	PathBegin integer,
	58	PathEnd integer,
	59	PathScaleX integer,
	60	PathScaleY integer,
	61	PathShearX integer,
	62	PathShearY integer,
	63	PathSkew integer,
	64	PathCurve integer,
	65	PathRadiusOffset integer,
	66	PathRevolutions integer,
	67	PathTaperX integer,
	68	PathTaperY integer,
	69	PathTwist integer,
	70	PathTwistBegin integer,
	71	ProfileBegin integer,
	72	ProfileEnd integer,
	73	ProfileCurve integer,
	74	ProfileHollow integer,
	75	State integer,
	76	Texture blob,
	77	ExtraParams blob);
	78
	79	CREATE TABLE terrain(
	80	RegionUUID varchar(255),
	81	Revision integer,
	82	Heightfield blob);
	83
	84	CREATE TABLE land(
	85	UUID varchar(255) primary key,
	86	RegionUUID varchar(255),
	87	LocalLandID string,
	88	Bitmap blob,
	89	Name varchar(255),
	90	Desc varchar(255),
	91	OwnerUUID varchar(36),
	92	IsGroupOwned string,
	93	Area integer,
	94	AuctionID integer,
	95	Category integer,
	96	ClaimDate integer,
	97	ClaimPrice integer,
	98	GroupUUID varchar(255),
	99	SalePrice integer,
	100	LandStatus integer,
	101	LandFlags string,
	102	LandingType string,
	103	MediaAutoScale string,
	104	MediaTextureUUID varchar(255),
	105	MediaURL varchar(255),
	106	MusicURL varchar(255),
	107	PassHours float,
	108	PassPrice string,
	109	SnapshotUUID varchar(255),
	110	UserLocationX float,
	111	UserLocationY float,
	112	UserLocationZ float,
	113	UserLookAtX float,
	114	UserLookAtY float,
	115	UserLookAtZ float);
	116
	117	CREATE TABLE landaccesslist(
	118	LandUUID varchar(255),
	119	AccessUUID varchar(255),
	120	Flags string);
	121
	122	COMMIT;