From 3a9fb6a1f29c6951ac886b47373ee8b74871c46b Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Tue, 17 Jul 2007 14:25:30 +0000
Subject: updated to map to current prim object model

---
 share/sql/sqlite3-prims.sql | 27 +++++++++++++++++++--------
 1 file changed, 19 insertions(+), 8 deletions(-)

(limited to 'share/sql')

diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
index 5ca29f7..f86b22f 100644
--- a/share/sql/sqlite3-prims.sql
+++ b/share/sql/sqlite3-prims.sql
@@ -3,21 +3,19 @@
 --
 
 create table prims (
-        LocalID integer primary key not null,
+        id integer primary key autoincrement,
         ParentID integer default 0,
         FullID char(36),
         CreationDate integer, 
         -- permissions
         OwnerID char(36),
+        LastOwnerID char(36),
         OwnerMask integer,
         NextOwnerMask integer,
         GroupMask integer,
         EveryoneMask integer,
         BaseMask integer,
         -- vectors (converted from LLVector3)
-        ScaleX integer,
-        ScaleY integer,
-        ScaleZ integer,
         PositionX integer,
         PositionY integer,
         PositionZ integer,
@@ -25,7 +23,22 @@ create table prims (
         RotationX integer,
         RotationY integer,
         RotationZ integer,
-        RotationW integer,
+        RotationW integer
+);
+
+create index prims_parent on prims(ParentID);
+create index prims_ownerid on prims(OwnerID);
+create index prims_lastownerid on prims(LastOwnerID);
+
+create table primshapes (
+        id integer primary key autoincrement,
+        prim_id integer not null,
+        -- Shape is an enum 
+        Shape integer, 
+        -- vectors (converted from LLVector3)
+        ScaleX integer,
+        ScaleY integer,
+        ScaleZ integer,
         -- paths
         PCode integer,
         PathBegin integer,
@@ -51,6 +64,4 @@ create table prims (
         Texture blob
 );
 
-create index prims_parent on prims(ParentID);
-create index prims_ownerid on prims(OwnerID);
-create index prims_fullid on prims(FullID);
\ No newline at end of file
+create index primshapes_parentid on primshapes(prim_id);
-- 
cgit v1.1