aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql91
1 files changed, 0 insertions, 91 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
deleted file mode 100644
index 5680c15..0000000
--- a/share/sql/sqlite3-prims.sql
+++ /dev/null
@@ -1,91 +0,0 @@
1--
2-- Database schema for local prim storage
3--
4--
5-- Some type mappings
6-- LLUID => char(36) (in ascii hex format)
7-- uint => integer
8-- string => varchar(256) until such time as we know we need bigger
9
10create table prims (
11 UUID char(36) primary key, -- this.UUID
12 ParentID integer default 0, -- this.ParentID
13 CreationDate integer, -- this.CreationDate
14 Name varchar(256),
15 SceneGroupID char(36),
16 -- various text fields
17 Text varchar(256),
18 Description varchar(256),
19 SitName varchar(256),
20 TouchName varchar(256),
21 -- permissions
22 CreatorID char(36),
23 OwnerID char(36),
24 GroupID char(36),
25 LastOwnerID char(36),
26 OwnerMask integer,
27 NextOwnerMask integer,
28 GroupMask integer,
29 EveryoneMask integer,
30 BaseMask integer,
31 -- vectors (converted from LLVector3)
32 PositionX float,
33 PositionY float,
34 PositionZ float,
35 GroupPositionX float,
36 GroupPositionY float,
37 GroupPositionZ float,
38 VelocityX float,
39 VelocityY float,
40 VelocityZ float,
41 AngularVelocityX float,
42 AngularVelocityY float,
43 AngularVelocityZ float,
44 AccelerationX float,
45 AccelerationY float,
46 AccelerationZ float,
47 -- quaternions (converted from LLQuaternion)
48 RotationX float,
49 RotationY float,
50 RotationZ float,
51 RotationW float
52);
53
54create index prims_parent on prims(ParentID);
55create index prims_ownerid on prims(OwnerID);
56create index prims_lastownerid on prims(LastOwnerID);
57
58create table primshapes (
59 -- The same UUID as prim, just to keep them easily linked
60 UUID varchar(36) primary key not null,
61 -- Shape is an enum
62 Shape integer,
63 -- vectors (converted from LLVector3)
64 ScaleX float,
65 ScaleY float,
66 ScaleZ float,
67 -- paths
68 PCode integer,
69 PathBegin integer,
70 PathEnd integer,
71 PathScaleX integer,
72 PathScaleY integer,
73 PathShearX integer,
74 PathShearY integer,
75 PathSkew integer,
76 PathCurve integer,
77 PathRadiusOffset integer,
78 PathRevolutions integer,
79 PathTaperX integer,
80 PathTaperY integer,
81 PathTwist integer,
82 PathTwistBegin integer,
83 -- profile
84 ProfileBegin integer,
85 ProfileEnd integer,
86 ProfileCurve integer,
87 ProfileHollow integer,
88 -- text
89 Texture blob
90);
91