updated resources for current sqlite schema for migrations

author: Sean Dague 2008-06-11 20:04:01 +0000
committer: Sean Dague 2008-06-11 20:04:01 +0000
commit: 68b98aecab0906f6c55f8c567552fb39a3bda1a2 (patch)
tree: bb318506c8d2c958437bda62172885c9d98010f5 /OpenSim/Data/SQLite/Resources
parent: For people receiving: Exception: System.ArgumentException: Value of -21474836... (diff)
download: opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.zip
opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.gz
opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.bz2
opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.xz
4 files changed, 200 insertions, 171 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_AssetStore.sql b/OpenSim/Data/SQLite/Resources/001_AssetStore.sql
index 1dc05d8..2e026ca 100644
--- a/OpenSim/Data/SQLite/Resources/001_AssetStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_AssetStore.sql
@@ -1,13 +1,12 @@
 BEGIN TRANSACTION;
 CREATE TABLE assets(
-        UUID varchar(255) primary key,
+       UUID varchar(255) primary key,
-        Name varchar(255),
+       Name varchar(255),
-        Description varchar(255),
+       Description varchar(255),
-        Type integer,
+       Type integer,
-        InvType integer,
+       InvType integer,
-        Local integer,
+       Local integer,
-        Temporary integer,
+       Temporary integer,
-        Data blob);
+       Data blob);
 COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
index e4951b0..554d5c2 100644
--- a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
@@ -1,26 +1,32 @@
 BEGIN TRANSACTION;
-CREATE TABLE inventoryitems(
-        UUID varchar(255) primary key,
-        assetID varchar(255),
-        assetType integer,
-        invType integer,
-        parentFolderID varchar(255),
-        avatarID varchar(255),
-        creatorsID varchar(255),
-        inventoryName varchar(255),
-        inventoryDescription varchar(255),
-        inventoryNextPermissions integer,
-        inventoryCurrentPermissions integer,
-        inventoryBasePermissions integer,
-        inventoryEveryOnePermissions integer);
 CREATE TABLE inventoryfolders(
-        UUID varchar(255) primary key,
+       UUID varchar(255) primary key,
-        name varchar(255),
+       name varchar(255),
-        agentID varchar(255),
+       agentID varchar(255),
-        parentID varchar(255),
+       parentID varchar(255),
-        type integer,
+       type integer,
-        version integer);
+       version integer);
+CREATE TABLE inventoryitems(
+       UUID varchar(255) primary key,
+       assetID varchar(255),
+       assetType integer,
+       invType integer,
+       parentFolderID varchar(255),
+       avatarID varchar(255),
+       creatorsID varchar(255),
+       inventoryName varchar(255),
+       inventoryDescription varchar(255),
+       inventoryNextPermissions integer,
+       inventoryCurrentPermissions integer,
+       inventoryBasePermissions integer,
+       inventoryEveryOnePermissions integer, 
+       salePrice integer default 99, 
+       saleType integer default 0, 
+       creationDate integer default 2000, 
+       groupID varchar(255) default '00000000-0000-0000-0000-000000000000', 
+       groupOwned integer default 0, 
+       flags integer default 0);
 COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
index 15f3d9f..39e8180 100644
--- a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
@@ -1,122 +1,144 @@
 BEGIN TRANSACTION;
 CREATE TABLE prims(
-        UUID varchar(255) primary key,
+       UUID varchar(255) primary key,
-        RegionUUID varchar(255),
+       RegionUUID varchar(255),
-        ParentID integer,
+       ParentID integer,
-        CreationDate integer,
+       CreationDate integer,
-        Name varchar(255),
+       Name varchar(255),
-        SceneGroupID varchar(255),
+       SceneGroupID varchar(255),
-        Text varchar(255),
+       Text varchar(255),
-        Description varchar(255),
+       Description varchar(255),
-        SitName varchar(255),
+       SitName varchar(255),
-        TouchName varchar(255),
+       TouchName varchar(255),
-        CreatorID varchar(255),
+       CreatorID varchar(255),
-        OwnerID varchar(255),
+       OwnerID varchar(255),
-        GroupID varchar(255),
+       GroupID varchar(255),
-        LastOwnerID varchar(255),
+       LastOwnerID varchar(255),
-        OwnerMask integer,
+       OwnerMask integer,
-        NextOwnerMask integer,
+       NextOwnerMask integer,
-        GroupMask integer,
+       GroupMask integer,
-        EveryoneMask integer,
+       EveryoneMask integer,
-        BaseMask integer,
+       BaseMask integer,
-        PositionX float,
+       PositionX float,
-        PositionY float,
+       PositionY float,
-        PositionZ float,
+       PositionZ float,
-        GroupPositionX float,
+       GroupPositionX float,
-        GroupPositionY float,
+       GroupPositionY float,
-        GroupPositionZ float,
+       GroupPositionZ float,
-        VelocityX float,
+       VelocityX float,
-        VelocityY float,
+       VelocityY float,
-        VelocityZ float,
+       VelocityZ float,
-        AngularVelocityX float,
+       AngularVelocityX float,
-        AngularVelocityY float,
+       AngularVelocityY float,
-        AngularVelocityZ float,
+       AngularVelocityZ float,
-        AccelerationX float,
+       AccelerationX float,
-        AccelerationY float,
+       AccelerationY float,
-        AccelerationZ float,
+       AccelerationZ float,
-        RotationX float,
+       RotationX float,
-        RotationY float,
+       RotationY float,
-        RotationZ float,
+       RotationZ float,
-        RotationW float, 
+       RotationW float, 
-        ObjectFlags integer, 
+       ObjectFlags integer, 
-        SitTargetOffsetX float NOT NULL default 0, 
+       SitTargetOffsetX float NOT NULL default 0, 
-        SitTargetOffsetY float NOT NULL default 0, 
+       SitTargetOffsetY float NOT NULL default 0, 
-        SitTargetOffsetZ float NOT NULL default 0, 
+       SitTargetOffsetZ float NOT NULL default 0, 
-        SitTargetOrientW float NOT NULL default 0, 
+       SitTargetOrientW float NOT NULL default 0, 
-        SitTargetOrientX float NOT NULL default 0, 
+       SitTargetOrientX float NOT NULL default 0, 
-        SitTargetOrientY float NOT NULL default 0, 
+       SitTargetOrientY float NOT NULL default 0, 
-        SitTargetOrientZ float NOT NULL default 0);
+       SitTargetOrientZ float NOT NULL default 0);
-CREATE TABLE primshapes(UUID varchar(255) primary key,
+CREATE TABLE primshapes(
-        Shape integer,
+       UUID varchar(255) primary key,
-        ScaleX float,
+       Shape integer,
-        ScaleY float,
+       ScaleX float,
-        ScaleZ float,
+       ScaleY float,
-        PCode integer,
+       ScaleZ float,
-        PathBegin integer,
+       PCode integer,
-        PathEnd integer,
+       PathBegin integer,
-        PathScaleX integer,
+       PathEnd integer,
-        PathScaleY integer,
+       PathScaleX integer,
-        PathShearX integer,
+       PathScaleY integer,
-        PathShearY integer,
+       PathShearX integer,
-        PathSkew integer,
+       PathShearY integer,
-        PathCurve integer,
+       PathSkew integer,
-        PathRadiusOffset integer,
+       PathCurve integer,
-        PathRevolutions integer,
+       PathRadiusOffset integer,
-        PathTaperX integer,
+       PathRevolutions integer,
-        PathTaperY integer,
+       PathTaperX integer,
-        PathTwist integer,
+       PathTaperY integer,
-        PathTwistBegin integer,
+       PathTwist integer,
-        ProfileBegin integer,
+       PathTwistBegin integer,
-        ProfileEnd integer,
+       ProfileBegin integer,
-        ProfileCurve integer,
+       ProfileEnd integer,
-        ProfileHollow integer,
+       ProfileCurve integer,
-        State integer,
+       ProfileHollow integer,
-        Texture blob,
+       Texture blob,
-        ExtraParams 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),
+       RegionUUID varchar(255),
-        Revision integer,
+       Revision integer,
-        Heightfield blob);
+       Heightfield blob);
 CREATE TABLE land(
-        UUID varchar(255) primary key,
+       UUID varchar(255) primary key,
-        RegionUUID varchar(255),
+       RegionUUID varchar(255),
-        LocalLandID string,
+       LocalLandID string,
-        Bitmap blob,
+       Bitmap blob,
-        Name varchar(255),
+       Name varchar(255),
-        Desc varchar(255),
+       Desc varchar(255),
-        OwnerUUID varchar(36),
+       OwnerUUID varchar(255),
-        IsGroupOwned string,
+       IsGroupOwned string,
-        Area integer,
+       Area integer,
-        AuctionID integer,
+       AuctionID integer,
-        Category integer,
+       Category integer,
-        ClaimDate integer,
+       ClaimDate integer,
-        ClaimPrice integer,
+       ClaimPrice integer,
-        GroupUUID varchar(255),
+       GroupUUID varchar(255),
-        SalePrice integer,
+       SalePrice integer,
-        LandStatus integer,
+       LandStatus integer,
-        LandFlags string,
+       LandFlags string,
-        LandingType string,
+       LandingType string,
-        MediaAutoScale string,
+       MediaAutoScale string,
-        MediaTextureUUID varchar(255),
+       MediaTextureUUID varchar(255),
-        MediaURL varchar(255),
+       MediaURL varchar(255),
-        MusicURL varchar(255),
+       MusicURL varchar(255),
-        PassHours float,
+       PassHours float,
-        PassPrice string,
+       PassPrice string,
-        SnapshotUUID varchar(255),
+       SnapshotUUID varchar(255),
-        UserLocationX float,
+       UserLocationX float,
-        UserLocationY float,
+       UserLocationY float,
-        UserLocationZ float,    
+       UserLocationZ float,
-        UserLookAtX float,
+       UserLookAtX float,
-        UserLookAtY float,
+       UserLookAtY float,
-        UserLookAtZ float);
+       UserLookAtZ float, 
+       AuthbuyerID varchar(36) NOT NULL default  '00000000-0000-0000-0000-000000000000');
 CREATE TABLE landaccesslist(
-        LandUUID varchar(255),
+       LandUUID varchar(255),
-        AccessUUID varchar(255),
+       AccessUUID varchar(255),
-        Flags string);
+       Flags string);
 COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/001_UserStore.sql b/OpenSim/Data/SQLite/Resources/001_UserStore.sql
index 070e340..b584594 100644
--- a/OpenSim/Data/SQLite/Resources/001_UserStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_UserStore.sql
@@ -1,37 +1,39 @@
 BEGIN TRANSACTION;
+-- users table
 CREATE TABLE users(
-        UUID varchar(255) primary key,
+       UUID varchar(255) primary key,
-        username varchar(255),
+       username varchar(255),
-        surname varchar(255),
+       surname varchar(255),
-        passwordHash varchar(255),
+       passwordHash varchar(255),
-        passwordSalt varchar(255),
+       passwordSalt varchar(255),
-        homeRegionX integer,
+       homeRegionX integer,
-        homeRegionY integer,
+       homeRegionY integer,
-        homeLocationX float,    
+       homeLocationX float,
-        homeLocationY float,
+       homeLocationY float,
-        homeLocationZ float,
+       homeLocationZ float,
-        homeLookAtX float,
+       homeLookAtX float,
-        homeLookAtY float,
+       homeLookAtY float,
-        homeLookAtZ float,
+       homeLookAtZ float,
-        created integer,
+       created integer,
-        lastLogin integer,
+       lastLogin integer,
-        rootInventoryFolderID varchar(255),
+       rootInventoryFolderID varchar(255),
-        userInventoryURI varchar(255),
+       userInventoryURI varchar(255),
-        userAssetURI varchar(255),
+       userAssetURI varchar(255),
-        profileCanDoMask integer,
+       profileCanDoMask integer,
-        profileWantDoMask integer,
+       profileWantDoMask integer,
-        profileAboutText varchar(255),
+       profileAboutText varchar(255),
-        profileFirstText varchar(255),
+       profileFirstText varchar(255),
-        profileImage varchar(255),
+       profileImage varchar(255),
-        profileFirstImage varchar(255), 
+       profileFirstImage varchar(255), 
-        webLoginKey text default '00000000-0000-0000-0000-000000000000');
+       webLoginKey text default '00000000-0000-0000-0000-000000000000');
+-- friends table
 CREATE TABLE userfriends(
-        ownerID varchar(255),
+       ownerID varchar(255),
-        friendID varchar(255),
+       friendID varchar(255),
-        friendPerms integer,
+       friendPerms integer,
-        ownerPerms integer,
+       ownerPerms integer,
-        datetimestamp integer);
+       datetimestamp integer);
 COMMIT;
author	Sean Dague	2008-06-11 20:04:01 +0000
committer	Sean Dague	2008-06-11 20:04:01 +0000
commit	68b98aecab0906f6c55f8c567552fb39a3bda1a2 (patch)
tree	bb318506c8d2c958437bda62172885c9d98010f5 /OpenSim/Data/SQLite/Resources
parent	For people receiving: Exception: System.ArgumentException: Value of -21474836... (diff)
download	opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.zip opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.gz opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.bz2 opensim-SC-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.xz

diff --git a/OpenSim/Data/SQLite/Resources/001_AssetStore.sql b/OpenSim/Data/SQLite/Resources/001_AssetStore.sql index 1dc05d8..2e026ca 100644 --- a/OpenSim/Data/SQLite/Resources/001_AssetStore.sql +++ b/OpenSim/Data/SQLite/Resources/001_AssetStore.sql
@@ -1,13 +1,12 @@
1	BEGIN TRANSACTION;	1	BEGIN TRANSACTION;
2
3	CREATE TABLE assets(	2	CREATE TABLE assets(
4	UUID varchar(255) primary key,	3	UUID varchar(255) primary key,
5	Name varchar(255),	4	Name varchar(255),
6	Description varchar(255),	5	Description varchar(255),
7	Type integer,	6	Type integer,
8	InvType integer,	7	InvType integer,
9	Local integer,	8	Local integer,
10	Temporary integer,	9	Temporary integer,
11	Data blob);	10	Data blob);
12		11
13	COMMIT;	12	COMMIT;


diff --git a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql index e4951b0..554d5c2 100644 --- a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql +++ b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
@@ -1,26 +1,32 @@
1	BEGIN TRANSACTION;	1	BEGIN TRANSACTION;
2		2
3	CREATE TABLE inventoryitems(
4	UUID varchar(255) primary key,
5	assetID varchar(255),
6	assetType integer,
7	invType integer,
8	parentFolderID varchar(255),
9	avatarID varchar(255),
10	creatorsID varchar(255),
11	inventoryName varchar(255),
12	inventoryDescription varchar(255),
13	inventoryNextPermissions integer,
14	inventoryCurrentPermissions integer,
15	inventoryBasePermissions integer,
16	inventoryEveryOnePermissions integer);
17
18	CREATE TABLE inventoryfolders(	3	CREATE TABLE inventoryfolders(
19	UUID varchar(255) primary key,	4	UUID varchar(255) primary key,
20	name varchar(255),	5	name varchar(255),
21	agentID varchar(255),	6	agentID varchar(255),
22	parentID varchar(255),	7	parentID varchar(255),
23	type integer,	8	type integer,
24	version integer);	9	version integer);
		10
		11	CREATE TABLE inventoryitems(
		12	UUID varchar(255) primary key,
		13	assetID varchar(255),
		14	assetType integer,
		15	invType integer,
		16	parentFolderID varchar(255),
		17	avatarID varchar(255),
		18	creatorsID varchar(255),
		19	inventoryName varchar(255),
		20	inventoryDescription varchar(255),
		21	inventoryNextPermissions integer,
		22	inventoryCurrentPermissions integer,
		23	inventoryBasePermissions integer,
		24	inventoryEveryOnePermissions integer,
		25	salePrice integer default 99,
		26	saleType integer default 0,
		27	creationDate integer default 2000,
		28	groupID varchar(255) default '00000000-0000-0000-0000-000000000000',
		29	groupOwned integer default 0,
		30	flags integer default 0);
25		31
26	COMMIT;	32	COMMIT;


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


diff --git a/OpenSim/Data/SQLite/Resources/001_UserStore.sql b/OpenSim/Data/SQLite/Resources/001_UserStore.sql index 070e340..b584594 100644 --- a/OpenSim/Data/SQLite/Resources/001_UserStore.sql +++ b/OpenSim/Data/SQLite/Resources/001_UserStore.sql
@@ -1,37 +1,39 @@
1	BEGIN TRANSACTION;	1	BEGIN TRANSACTION;
2		2
		3	-- users table
3	CREATE TABLE users(	4	CREATE TABLE users(
4	UUID varchar(255) primary key,	5	UUID varchar(255) primary key,
5	username varchar(255),	6	username varchar(255),
6	surname varchar(255),	7	surname varchar(255),
7	passwordHash varchar(255),	8	passwordHash varchar(255),
8	passwordSalt varchar(255),	9	passwordSalt varchar(255),
9	homeRegionX integer,	10	homeRegionX integer,
10	homeRegionY integer,	11	homeRegionY integer,
11	homeLocationX float,	12	homeLocationX float,
12	homeLocationY float,	13	homeLocationY float,
13	homeLocationZ float,	14	homeLocationZ float,
14	homeLookAtX float,	15	homeLookAtX float,
15	homeLookAtY float,	16	homeLookAtY float,
16	homeLookAtZ float,	17	homeLookAtZ float,
17	created integer,	18	created integer,
18	lastLogin integer,	19	lastLogin integer,
19	rootInventoryFolderID varchar(255),	20	rootInventoryFolderID varchar(255),
20	userInventoryURI varchar(255),	21	userInventoryURI varchar(255),
21	userAssetURI varchar(255),	22	userAssetURI varchar(255),
22	profileCanDoMask integer,	23	profileCanDoMask integer,
23	profileWantDoMask integer,	24	profileWantDoMask integer,
24	profileAboutText varchar(255),	25	profileAboutText varchar(255),
25	profileFirstText varchar(255),	26	profileFirstText varchar(255),
26	profileImage varchar(255),	27	profileImage varchar(255),
27	profileFirstImage varchar(255),	28	profileFirstImage varchar(255),
28	webLoginKey text default '00000000-0000-0000-0000-000000000000');	29	webLoginKey text default '00000000-0000-0000-0000-000000000000');
29		30	-- friends table
30	CREATE TABLE userfriends(	31	CREATE TABLE userfriends(
31	ownerID varchar(255),	32	ownerID varchar(255),
32	friendID varchar(255),	33	friendID varchar(255),
33	friendPerms integer,	34	friendPerms integer,
34	ownerPerms integer,	35	ownerPerms integer,
35	datetimestamp integer);	36	datetimestamp integer);
36		37
37	COMMIT;	38	COMMIT;
		39