From 9abe102fc296dafe80d69a9f579f84826d472070 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Mon, 6 Aug 2007 19:06:18 +0000
Subject: first bits of updating sqlite to definition based on new objects

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

(limited to 'share')

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,
-- 
cgit v1.1