aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
index b939f66..7cb0a02 100644
--- a/share/sql/sqlite3-prims.sql
+++ b/share/sql/sqlite3-prims.sql
@@ -5,6 +5,7 @@
5-- Some type mappings 5-- Some type mappings
6-- LLUID => char(36) (in ascii hex format) 6-- LLUID => char(36) (in ascii hex format)
7-- uint => integer 7-- uint => integer
8-- string => varchar(256) until such time as we know we need bigger
8 9
9create table prims ( 10create table prims (
10 id integer primary key autoincrement, -- this.LocalID 11 id integer primary key autoincrement, -- this.LocalID
@@ -12,6 +13,11 @@ create table prims (
12 UUID char(36), -- this.UUID 13 UUID char(36), -- this.UUID
13 CreationDate integer, -- this.CreationDate 14 CreationDate integer, -- this.CreationDate
14 Name varchar(256), 15 Name varchar(256),
16 -- various text fields
17 Text varchar(256),
18 Description varchar(256),
19 SitName varchar(256),
20 TouchName
15 -- permissions 21 -- permissions
16 CreatorID char(36), 22 CreatorID char(36),
17 OwnerID char(36), 23 OwnerID char(36),
@@ -26,6 +32,15 @@ create table prims (
26 PositionX float, 32 PositionX float,
27 PositionY float, 33 PositionY float,
28 PositionZ float, 34 PositionZ float,
35 VelocityX float,
36 VelocityY float,
37 VelocityZ float,
38 AngularVelocityX float,
39 AngularVelocityY float,
40 AngularVelocityZ float,
41 AccelerationX float,
42 AccelerationY float,
43 AccelerationZ float,
29 -- quaternions (converted from LLQuaternion) 44 -- quaternions (converted from LLQuaternion)
30 RotationX float, 45 RotationX float,
31 RotationY float, 46 RotationY float,