aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql27
1 files changed, 19 insertions, 8 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
index 5ca29f7..f86b22f 100644
--- a/share/sql/sqlite3-prims.sql
+++ b/share/sql/sqlite3-prims.sql
@@ -3,21 +3,19 @@
3-- 3--
4 4
5create table prims ( 5create table prims (
6 LocalID integer primary key not null, 6 id integer primary key autoincrement,
7 ParentID integer default 0, 7 ParentID integer default 0,
8 FullID char(36), 8 FullID char(36),
9 CreationDate integer, 9 CreationDate integer,
10 -- permissions 10 -- permissions
11 OwnerID char(36), 11 OwnerID char(36),
12 LastOwnerID char(36),
12 OwnerMask integer, 13 OwnerMask integer,
13 NextOwnerMask integer, 14 NextOwnerMask integer,
14 GroupMask integer, 15 GroupMask integer,
15 EveryoneMask integer, 16 EveryoneMask integer,
16 BaseMask integer, 17 BaseMask integer,
17 -- vectors (converted from LLVector3) 18 -- vectors (converted from LLVector3)
18 ScaleX integer,
19 ScaleY integer,
20 ScaleZ integer,
21 PositionX integer, 19 PositionX integer,
22 PositionY integer, 20 PositionY integer,
23 PositionZ integer, 21 PositionZ integer,
@@ -25,7 +23,22 @@ create table prims (
25 RotationX integer, 23 RotationX integer,
26 RotationY integer, 24 RotationY integer,
27 RotationZ integer, 25 RotationZ integer,
28 RotationW integer, 26 RotationW integer
27);
28
29create index prims_parent on prims(ParentID);
30create index prims_ownerid on prims(OwnerID);
31create index prims_lastownerid on prims(LastOwnerID);
32
33create table primshapes (
34 id integer primary key autoincrement,
35 prim_id integer not null,
36 -- Shape is an enum
37 Shape integer,
38 -- vectors (converted from LLVector3)
39 ScaleX integer,
40 ScaleY integer,
41 ScaleZ integer,
29 -- paths 42 -- paths
30 PCode integer, 43 PCode integer,
31 PathBegin integer, 44 PathBegin integer,
@@ -51,6 +64,4 @@ create table prims (
51 Texture blob 64 Texture blob
52); 65);
53 66
54create index prims_parent on prims(ParentID); 67create index primshapes_parentid on primshapes(prim_id);
55create index prims_ownerid on prims(OwnerID);
56create index prims_fullid on prims(FullID); \ No newline at end of file