diff options
author | Sean Dague | 2007-07-17 14:25:30 +0000 |
---|---|---|
committer | Sean Dague | 2007-07-17 14:25:30 +0000 |
commit | 3a9fb6a1f29c6951ac886b47373ee8b74871c46b (patch) | |
tree | 0e400ccad16fae8e862074bc127681b7924c0a24 /share/sql/sqlite3-prims.sql | |
parent | * debugged quite a lot of db-related strangeness and various refactoring goofs (diff) | |
download | opensim-SC-3a9fb6a1f29c6951ac886b47373ee8b74871c46b.zip opensim-SC-3a9fb6a1f29c6951ac886b47373ee8b74871c46b.tar.gz opensim-SC-3a9fb6a1f29c6951ac886b47373ee8b74871c46b.tar.bz2 opensim-SC-3a9fb6a1f29c6951ac886b47373ee8b74871c46b.tar.xz |
updated to map to current prim object model
Diffstat (limited to 'share/sql/sqlite3-prims.sql')
-rw-r--r-- | share/sql/sqlite3-prims.sql | 27 |
1 files changed, 19 insertions, 8 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql index 5ca29f7..f86b22f 100644 --- a/share/sql/sqlite3-prims.sql +++ b/share/sql/sqlite3-prims.sql | |||
@@ -3,21 +3,19 @@ | |||
3 | -- | 3 | -- |
4 | 4 | ||
5 | create table prims ( | 5 | create table prims ( |
6 | LocalID integer primary key not null, | 6 | id integer primary key autoincrement, |
7 | ParentID integer default 0, | 7 | ParentID integer default 0, |
8 | FullID char(36), | 8 | FullID char(36), |
9 | CreationDate integer, | 9 | CreationDate integer, |
10 | -- permissions | 10 | -- permissions |
11 | OwnerID char(36), | 11 | OwnerID char(36), |
12 | LastOwnerID char(36), | ||
12 | OwnerMask integer, | 13 | OwnerMask integer, |
13 | NextOwnerMask integer, | 14 | NextOwnerMask integer, |
14 | GroupMask integer, | 15 | GroupMask integer, |
15 | EveryoneMask integer, | 16 | EveryoneMask integer, |
16 | BaseMask integer, | 17 | BaseMask integer, |
17 | -- vectors (converted from LLVector3) | 18 | -- vectors (converted from LLVector3) |
18 | ScaleX integer, | ||
19 | ScaleY integer, | ||
20 | ScaleZ integer, | ||
21 | PositionX integer, | 19 | PositionX integer, |
22 | PositionY integer, | 20 | PositionY integer, |
23 | PositionZ integer, | 21 | PositionZ integer, |
@@ -25,7 +23,22 @@ create table prims ( | |||
25 | RotationX integer, | 23 | RotationX integer, |
26 | RotationY integer, | 24 | RotationY integer, |
27 | RotationZ integer, | 25 | RotationZ integer, |
28 | RotationW integer, | 26 | RotationW integer |
27 | ); | ||
28 | |||
29 | create index prims_parent on prims(ParentID); | ||
30 | create index prims_ownerid on prims(OwnerID); | ||
31 | create index prims_lastownerid on prims(LastOwnerID); | ||
32 | |||
33 | create table primshapes ( | ||
34 | id integer primary key autoincrement, | ||
35 | prim_id integer not null, | ||
36 | -- Shape is an enum | ||
37 | Shape integer, | ||
38 | -- vectors (converted from LLVector3) | ||
39 | ScaleX integer, | ||
40 | ScaleY integer, | ||
41 | ScaleZ integer, | ||
29 | -- paths | 42 | -- paths |
30 | PCode integer, | 43 | PCode integer, |
31 | PathBegin integer, | 44 | PathBegin integer, |
@@ -51,6 +64,4 @@ create table prims ( | |||
51 | Texture blob | 64 | Texture blob |
52 | ); | 65 | ); |
53 | 66 | ||
54 | create index prims_parent on prims(ParentID); | 67 | create index primshapes_parentid on primshapes(prim_id); |
55 | create index prims_ownerid on prims(OwnerID); | ||
56 | create index prims_fullid on prims(FullID); \ No newline at end of file | ||