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') 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