diff options
author | Sean Dague | 2007-08-06 19:51:12 +0000 |
---|---|---|
committer | Sean Dague | 2007-08-06 19:51:12 +0000 |
commit | 3a85c39b71681d5357ce9f06e923f8d6a41b8595 (patch) | |
tree | f37ad1a7090afe3a38a123347b9a759d1092e6df /share/sql/sqlite3-prims.sql | |
parent | OpenSim/Region/Terrain.BasicTerrain/TerrainEngine.cs (diff) | |
download | opensim-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 '')
-rw-r--r-- | share/sql/sqlite3-prims.sql | 15 |
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 | ||
9 | create table prims ( | 10 | create 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, |