aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql56
1 files changed, 56 insertions, 0 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
new file mode 100644
index 0000000..5ca29f7
--- /dev/null
+++ b/share/sql/sqlite3-prims.sql
@@ -0,0 +1,56 @@
1--
2-- Database schema for local prim storage
3--
4
5create table prims (
6 LocalID integer primary key not null,
7 ParentID integer default 0,
8 FullID char(36),
9 CreationDate integer,
10 -- permissions
11 OwnerID char(36),
12 OwnerMask integer,
13 NextOwnerMask integer,
14 GroupMask integer,
15 EveryoneMask integer,
16 BaseMask integer,
17 -- vectors (converted from LLVector3)
18 ScaleX integer,
19 ScaleY integer,
20 ScaleZ integer,
21 PositionX integer,
22 PositionY integer,
23 PositionZ integer,
24 -- quaternions (converted from LLQuaternion)
25 RotationX integer,
26 RotationY integer,
27 RotationZ integer,
28 RotationW integer,
29 -- paths
30 PCode integer,
31 PathBegin integer,
32 PathEnd integer,
33 PathScaleX integer,
34 PathScaleY integer,
35 PathShearX integer,
36 PathShearY integer,
37 PathSkew integer,
38 PathCurve integer,
39 PathRadiusOffset integer,
40 PathRevolutions integer,
41 PathTaperX integer,
42 PathTaperY integer,
43 PathTwist integer,
44 PathTwistBegin integer,
45 -- profile
46 ProfileBegin integer,
47 ProfileEnd integer,
48 ProfileCurve integer,
49 ProfileHollow integer,
50 -- text
51 Texture blob
52);
53
54create index prims_parent on prims(ParentID);
55create index prims_ownerid on prims(OwnerID);
56create index prims_fullid on prims(FullID); \ No newline at end of file