diff options
Diffstat (limited to 'share/sql/sqlite3-prims.sql')
-rw-r--r-- | share/sql/sqlite3-prims.sql | 5 |
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 | ||
10 | create table prims ( | 10 | create 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), |