aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorSean Dague2008-06-11 20:04:01 +0000
committerSean Dague2008-06-11 20:04:01 +0000
commit68b98aecab0906f6c55f8c567552fb39a3bda1a2 (patch)
treebb318506c8d2c958437bda62172885c9d98010f5
parentFor people receiving: Exception: System.ArgumentException: Value of -21474836... (diff)
downloadopensim-SC_OLD-68b98aecab0906f6c55f8c567552fb39a3bda1a2.zip
opensim-SC_OLD-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.gz
opensim-SC_OLD-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.bz2
opensim-SC_OLD-68b98aecab0906f6c55f8c567552fb39a3bda1a2.tar.xz
updated resources for current sqlite schema for migrations
-rw-r--r--OpenSim/Data/SQLite/Resources/001_AssetStore.sql17
-rw-r--r--OpenSim/Data/SQLite/Resources/001_InventoryStore.sql48
-rw-r--r--OpenSim/Data/SQLite/Resources/001_RegionStore.sql242
-rw-r--r--OpenSim/Data/SQLite/Resources/001_UserStore.sql64
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2
3CREATE TABLE assets( 2CREATE 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
13COMMIT; 12COMMIT;
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3CREATE 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
18CREATE TABLE inventoryfolders( 3CREATE 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
11CREATE 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
26COMMIT; 32COMMIT;
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3CREATE TABLE prims( 3CREATE 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
51CREATE TABLE primshapes(UUID varchar(255) primary key, 51CREATE 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
80CREATE 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
79CREATE TABLE terrain( 100CREATE TABLE terrain(
80 RegionUUID varchar(255), 101 RegionUUID varchar(255),
81 Revision integer, 102 Revision integer,
82 Heightfield blob); 103 Heightfield blob);
83 104
84CREATE TABLE land( 105CREATE 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
117CREATE TABLE landaccesslist( 139CREATE 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
122COMMIT; 144COMMIT;
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3-- users table
3CREATE TABLE users( 4CREATE 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
30CREATE TABLE userfriends( 31CREATE 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
37COMMIT; 38COMMIT;
39