aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.SQLite/Resources
diff options
context:
space:
mode:
authorSean Dague2008-01-10 19:38:37 +0000
committerSean Dague2008-01-10 19:38:37 +0000
commit13736995d2a169f35ef9678f53275eb4b5c8ece0 (patch)
treeca3a392376f4df462678fe67928bb1204e78a8e7 /OpenSim/Framework/Data.SQLite/Resources
parentAdded const definintions for sculpted prims. (diff)
downloadopensim-SC_OLD-13736995d2a169f35ef9678f53275eb4b5c8ece0.zip
opensim-SC_OLD-13736995d2a169f35ef9678f53275eb4b5c8ece0.tar.gz
opensim-SC_OLD-13736995d2a169f35ef9678f53275eb4b5c8ece0.tar.bz2
opensim-SC_OLD-13736995d2a169f35ef9678f53275eb4b5c8ece0.tar.xz
add sqlite database definitions as Resources for SQLite.dll
Diffstat (limited to 'OpenSim/Framework/Data.SQLite/Resources')
-rw-r--r--OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql13
-rw-r--r--OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql26
-rw-r--r--OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql121
-rw-r--r--OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql37
4 files changed, 197 insertions, 0 deletions
diff --git a/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql
new file mode 100644
index 0000000..1dc05d8
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql
@@ -0,0 +1,13 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE assets(
4 UUID varchar(255) primary key,
5 Name varchar(255),
6 Description varchar(255),
7 Type integer,
8 InvType integer,
9 Local integer,
10 Temporary integer,
11 Data blob);
12
13COMMIT;
diff --git a/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql
new file mode 100644
index 0000000..e4951b0
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql
@@ -0,0 +1,26 @@
1BEGIN TRANSACTION;
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(
19 UUID varchar(255) primary key,
20 name varchar(255),
21 agentID varchar(255),
22 parentID varchar(255),
23 type integer,
24 version integer);
25
26COMMIT;
diff --git a/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql
new file mode 100644
index 0000000..1db8ba8
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql
@@ -0,0 +1,121 @@
1BEGIN TRANSACTION;
2
3CREATE 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
51CREATE 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 Texture blob,
76 ExtraParams blob);
77
78CREATE TABLE terrain(
79 RegionUUID varchar(255),
80 Revision integer,
81 Heightfield blob);
82
83CREATE TABLE land(
84 UUID varchar(255) primary key,
85 RegionUUID varchar(255),
86 LocalLandID string,
87 Bitmap blob,
88 Name varchar(255),
89 Desc varchar(255),
90 OwnerUUID varchar(255),
91 IsGroupOwned string,
92 Area integer,
93 AuctionID integer,
94 Category integer,
95 ClaimDate integer,
96 ClaimPrice integer,
97 GroupUUID varchar(255),
98 SalePrice integer,
99 LandStatus integer,
100 LandFlags string,
101 LandingType string,
102 MediaAutoScale string,
103 MediaTextureUUID varchar(255),
104 MediaURL varchar(255),
105 MusicURL varchar(255),
106 PassHours float,
107 PassPrice string,
108 SnapshotUUID varchar(255),
109 UserLocationX float,
110 UserLocationY float,
111 UserLocationZ float,
112 UserLookAtX float,
113 UserLookAtY float,
114 UserLookAtZ float);
115
116CREATE TABLE landaccesslist(
117 LandUUID varchar(255),
118 AccessUUID varchar(255),
119 Flags string);
120
121COMMIT;
diff --git a/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql
new file mode 100644
index 0000000..070e340
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql
@@ -0,0 +1,37 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE users(
4 UUID varchar(255) primary key,
5 username varchar(255),
6 surname varchar(255),
7 passwordHash varchar(255),
8 passwordSalt varchar(255),
9 homeRegionX integer,
10 homeRegionY integer,
11 homeLocationX float,
12 homeLocationY float,
13 homeLocationZ float,
14 homeLookAtX float,
15 homeLookAtY float,
16 homeLookAtZ float,
17 created integer,
18 lastLogin integer,
19 rootInventoryFolderID varchar(255),
20 userInventoryURI varchar(255),
21 userAssetURI varchar(255),
22 profileCanDoMask integer,
23 profileWantDoMask integer,
24 profileAboutText varchar(255),
25 profileFirstText varchar(255),
26 profileImage varchar(255),
27 profileFirstImage varchar(255),
28 webLoginKey text default '00000000-0000-0000-0000-000000000000');
29
30CREATE TABLE userfriends(
31 ownerID varchar(255),
32 friendID varchar(255),
33 friendPerms integer,
34 ownerPerms integer,
35 datetimestamp integer);
36
37COMMIT;