From 3a85c39b71681d5357ce9f06e923f8d6a41b8595 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Mon, 6 Aug 2007 19:51:12 +0000
Subject: added rest of the fields the prims have

---
 share/sql/sqlite3-prims.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'share/sql/sqlite3-prims.sql')

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 @@
 -- Some type mappings
 -- LLUID => char(36) (in ascii hex format)
 -- uint => integer
+-- string => varchar(256) until such time as we know we need bigger
 
 create table prims (
         id integer primary key autoincrement, -- this.LocalID
@@ -12,6 +13,11 @@ create table prims (
         UUID char(36), -- this.UUID
         CreationDate integer, -- this.CreationDate
         Name varchar(256),
+        -- various text fields
+        Text varchar(256),
+        Description varchar(256),
+        SitName varchar(256),
+        TouchName 
         -- permissions
         CreatorID char(36),
         OwnerID char(36),
@@ -26,6 +32,15 @@ create table prims (
         PositionX float,
         PositionY float,
         PositionZ float,
+        VelocityX float,
+        VelocityY float,
+        VelocityZ float,
+        AngularVelocityX float,
+        AngularVelocityY float,
+        AngularVelocityZ float,
+        AccelerationX float,
+        AccelerationY float,
+        AccelerationZ float,
         -- quaternions (converted from LLQuaternion)
         RotationX float,
         RotationY float,
-- 
cgit v1.1

