first bits of updating sqlite to definition based on new objects

1 files changed, 11 insertions, 4 deletions

diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
index 7e6d79d..b939f66 100644
--- a/share/sql/sqlite3-prims.sql
+++ b/share/sql/sqlite3-prims.sql
@@ -1,14 +1,21 @@
 --
 -- Database schema for local prim storage
 --
+-- 
+-- Some type mappings
+-- LLUID => char(36) (in ascii hex format)
+-- uint => integer
 
 create table prims (
-        id integer primary key autoincrement,
-        ParentID integer default 0,
-        FullID char(36),
-        CreationDate integer, 
+        id integer primary key autoincrement, -- this.LocalID
+        ParentID integer default 0, -- this.ParentID
+        UUID char(36), -- this.UUID
+        CreationDate integer, -- this.CreationDate
+        Name varchar(256),
         -- permissions
+        CreatorID char(36),
         OwnerID char(36),
+        GroupID char(36),
         LastOwnerID char(36),
         OwnerMask integer,
         NextOwnerMask integer,