aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql')
-rw-r--r--share/sql/sqlite3-prims.sql15
1 files changed, 11 insertions, 4 deletions
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 @@
1-- 1--
2-- Database schema for local prim storage 2-- Database schema for local prim storage
3-- 3--
4--
5-- Some type mappings
6-- LLUID => char(36) (in ascii hex format)
7-- uint => integer
4 8
5create table prims ( 9create table prims (
6 id integer primary key autoincrement, 10 id integer primary key autoincrement, -- this.LocalID
7 ParentID integer default 0, 11 ParentID integer default 0, -- this.ParentID
8 FullID char(36), 12 UUID char(36), -- this.UUID
9 CreationDate integer, 13 CreationDate integer, -- this.CreationDate
14 Name varchar(256),
10 -- permissions 15 -- permissions
16 CreatorID char(36),
11 OwnerID char(36), 17 OwnerID char(36),
18 GroupID char(36),
12 LastOwnerID char(36), 19 LastOwnerID char(36),
13 OwnerMask integer, 20 OwnerMask integer,
14 NextOwnerMask integer, 21 NextOwnerMask integer,