aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
authorSean Dague2007-08-06 19:51:12 +0000
committerSean Dague2007-08-06 19:51:12 +0000
commit3a85c39b71681d5357ce9f06e923f8d6a41b8595 (patch)
treef37ad1a7090afe3a38a123347b9a759d1092e6df /share/sql
parentOpenSim/Region/Terrain.BasicTerrain/TerrainEngine.cs (diff)
downloadopensim-SC_OLD-3a85c39b71681d5357ce9f06e923f8d6a41b8595.zip
opensim-SC_OLD-3a85c39b71681d5357ce9f06e923f8d6a41b8595.tar.gz
opensim-SC_OLD-3a85c39b71681d5357ce9f06e923f8d6a41b8595.tar.bz2
opensim-SC_OLD-3a85c39b71681d5357ce9f06e923f8d6a41b8595.tar.xz
added rest of the fields the prims have
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,