diff options
Diffstat (limited to 'share/sql/sqlite3-prims.sql')
-rw-r--r-- | share/sql/sqlite3-prims.sql | 91 |
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 | |||
10 | create 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 | |||
54 | create index prims_parent on prims(ParentID); | ||
55 | create index prims_ownerid on prims(OwnerID); | ||
56 | create index prims_lastownerid on prims(LastOwnerID); | ||
57 | |||
58 | create 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 | |||