From dd5120af43687c71e44d1b5758a71066758cb4fc Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Fri, 13 Jul 2007 19:07:18 +0000
Subject: first draft sql definition for prims based on PrimData

---
 share/sql/sqlite3-prims.sql | 56 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 56 insertions(+)
 create mode 100644 share/sql/sqlite3-prims.sql

(limited to 'share')

diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
new file mode 100644
index 0000000..5ca29f7
--- /dev/null
+++ b/share/sql/sqlite3-prims.sql
@@ -0,0 +1,56 @@
+--
+-- Database schema for local prim storage
+--
+
+create table prims (
+        LocalID integer primary key not null,
+        ParentID integer default 0,
+        FullID char(36),
+        CreationDate integer, 
+        -- permissions
+        OwnerID 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,
+        -- quaternions (converted from LLQuaternion)
+        RotationX integer,
+        RotationY integer,
+        RotationZ integer,
+        RotationW integer,
+        -- paths
+        PCode integer,
+        PathBegin integer,
+        PathEnd integer,
+        PathScaleX integer,
+        PathScaleY integer,
+        PathShearX integer,
+        PathShearY integer,
+        PathSkew integer,
+        PathCurve integer,
+        PathRadiusOffset integer,
+        PathRevolutions integer,
+        PathTaperX integer,
+        PathTaperY integer,
+        PathTwist integer,
+        PathTwistBegin integer,
+        -- profile
+        ProfileBegin integer,
+        ProfileEnd integer,
+        ProfileCurve integer,
+        ProfileHollow integer,
+        -- text
+        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
-- 
cgit v1.1