diff options
author | Sean Dague | 2007-08-06 19:06:18 +0000 |
---|---|---|
committer | Sean Dague | 2007-08-06 19:06:18 +0000 |
commit | 9abe102fc296dafe80d69a9f579f84826d472070 (patch) | |
tree | 30d92a346967127de92d3c33f024d8aff6fe9552 /share/sql/sqlite3-prims.sql | |
parent | OpenSim/Region/Terrain.BasicTerrain/TerrainEngine.cs (diff) | |
download | opensim-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.sql | 15 |
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 | ||
5 | create table prims ( | 9 | create 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, |