From 4805460e89b448c849a7b5bf2808d9990e5e1125 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 8 Aug 2007 15:50:48 +0000
Subject: updated to latest version

---
 share/sql/sqlite3-prims.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

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

diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql
index 7cb0a02..ef6ef5a 100644
--- a/share/sql/sqlite3-prims.sql
+++ b/share/sql/sqlite3-prims.sql
@@ -8,16 +8,15 @@
 -- string => varchar(256) until such time as we know we need bigger
 
 create table prims (
-        id integer primary key autoincrement, -- this.LocalID
+        UUID char(36) primary key, -- this.UUID
         ParentID integer default 0, -- this.ParentID
-        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 
+        TouchName varchar(256),
         -- permissions
         CreatorID char(36),
         OwnerID char(36),
-- 
cgit v1.1

