diff options
author | Sean Dague | 2007-07-13 19:07:18 +0000 |
---|---|---|
committer | Sean Dague | 2007-07-13 19:07:18 +0000 |
commit | dd5120af43687c71e44d1b5758a71066758cb4fc (patch) | |
tree | 14f9a64c5a59e345287dc4ce63fe0cb6bfba360b /share/sql | |
parent | Prim Copying (both CTRL+D and shift-drag) should now work. (diff) | |
download | opensim-SC_OLD-dd5120af43687c71e44d1b5758a71066758cb4fc.zip opensim-SC_OLD-dd5120af43687c71e44d1b5758a71066758cb4fc.tar.gz opensim-SC_OLD-dd5120af43687c71e44d1b5758a71066758cb4fc.tar.bz2 opensim-SC_OLD-dd5120af43687c71e44d1b5758a71066758cb4fc.tar.xz |
first draft sql definition for prims based on PrimData
Diffstat (limited to '')
-rw-r--r-- | share/sql/sqlite3-prims.sql | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql new file mode 100644 index 0000000..5ca29f7 --- /dev/null +++ b/share/sql/sqlite3-prims.sql | |||
@@ -0,0 +1,56 @@ | |||
1 | -- | ||
2 | -- Database schema for local prim storage | ||
3 | -- | ||
4 | |||
5 | create table prims ( | ||
6 | LocalID integer primary key not null, | ||
7 | ParentID integer default 0, | ||
8 | FullID char(36), | ||
9 | CreationDate integer, | ||
10 | -- permissions | ||
11 | OwnerID char(36), | ||
12 | OwnerMask integer, | ||
13 | NextOwnerMask integer, | ||
14 | GroupMask integer, | ||
15 | EveryoneMask integer, | ||
16 | BaseMask integer, | ||
17 | -- vectors (converted from LLVector3) | ||
18 | ScaleX integer, | ||
19 | ScaleY integer, | ||
20 | ScaleZ integer, | ||
21 | PositionX integer, | ||
22 | PositionY integer, | ||
23 | PositionZ integer, | ||
24 | -- quaternions (converted from LLQuaternion) | ||
25 | RotationX integer, | ||
26 | RotationY integer, | ||
27 | RotationZ integer, | ||
28 | RotationW integer, | ||
29 | -- paths | ||
30 | PCode integer, | ||
31 | PathBegin integer, | ||
32 | PathEnd integer, | ||
33 | PathScaleX integer, | ||
34 | PathScaleY integer, | ||
35 | PathShearX integer, | ||
36 | PathShearY integer, | ||
37 | PathSkew integer, | ||
38 | PathCurve integer, | ||
39 | PathRadiusOffset integer, | ||
40 | PathRevolutions integer, | ||
41 | PathTaperX integer, | ||
42 | PathTaperY integer, | ||
43 | PathTwist integer, | ||
44 | PathTwistBegin integer, | ||
45 | -- profile | ||
46 | ProfileBegin integer, | ||
47 | ProfileEnd integer, | ||
48 | ProfileCurve integer, | ||
49 | ProfileHollow integer, | ||
50 | -- text | ||
51 | Texture blob | ||
52 | ); | ||
53 | |||
54 | create index prims_parent on prims(ParentID); | ||
55 | create index prims_ownerid on prims(OwnerID); | ||
56 | create index prims_fullid on prims(FullID); \ No newline at end of file | ||