aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql
diff options
context:
space:
mode:
authorSean Dague2007-08-06 19:06:18 +0000
committerSean Dague2007-08-06 19:06:18 +0000
commit9abe102fc296dafe80d69a9f579f84826d472070 (patch)
tree30d92a346967127de92d3c33f024d8aff6fe9552 /share/sql
parentOpenSim/Region/Terrain.BasicTerrain/TerrainEngine.cs (diff)
downloadopensim-SC_OLD-9abe102fc296dafe80d69a9f579f84826d472070.zip
opensim-SC_OLD-9abe102fc296dafe80d69a9f579f84826d472070.tar.gz
opensim-SC_OLD-9abe102fc296dafe80d69a9f579f84826d472070.tar.bz2
opensim-SC_OLD-9abe102fc296dafe80d69a9f579f84826d472070.tar.xz
first bits of updating sqlite to definition based on new objects
Diffstat (limited to '')
-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,