aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
diff options
context:
space:
mode:
authorSean Dague2008-06-11 20:04:01 +0000
committerSean Dague2008-06-11 20:04:01 +0000
commit68b98aecab0906f6c55f8c567552fb39a3bda1a2 (patch)
treebb318506c8d2c958437bda62172885c9d98010f5 /OpenSim/Data/SQLite/Resources/001_RegionStore.sql
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
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_RegionStore.sql242
1 files changed, 132 insertions, 110 deletions
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;
generated by cgit v1.1 at 2024-07-08 01:21:06 +0000