aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql5
1 files changed, 2 insertions, 3 deletions
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 @@
8-- string => varchar(256) until such time as we know we need bigger 8-- string => varchar(256) until such time as we know we need bigger
9 9
10create table prims ( 10create table prims (
11 id integer primary key autoincrement, -- this.LocalID 11 UUID char(36) primary key, -- this.UUID
12 ParentID integer default 0, -- this.ParentID 12 ParentID integer default 0, -- this.ParentID
13 UUID char(36), -- this.UUID
14 CreationDate integer, -- this.CreationDate 13 CreationDate integer, -- this.CreationDate
15 Name varchar(256), 14 Name varchar(256),
16 -- various text fields 15 -- various text fields
17 Text varchar(256), 16 Text varchar(256),
18 Description varchar(256), 17 Description varchar(256),
19 SitName varchar(256), 18 SitName varchar(256),
20 TouchName 19 TouchName varchar(256),
21 -- permissions 20 -- permissions
22 CreatorID char(36), 21 CreatorID char(36),
23 OwnerID char(36), 22 OwnerID char(36),