diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql | 102 |
1 files changed, 102 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql new file mode 100644 index 0000000..d557b9a --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql | |||
@@ -0,0 +1,102 @@ | |||
1 | BEGIN TRANSACTION; | ||
2 | |||
3 | create table Prims ( | ||
4 | UUID TEXT not null, | ||
5 | ParentID INTEGER, | ||
6 | ParentUUID TEXT, | ||
7 | RegionID TEXT, | ||
8 | CreationDate INTEGER, | ||
9 | Name TEXT, | ||
10 | Text TEXT, | ||
11 | Description TEXT, | ||
12 | SitName TEXT, | ||
13 | TouchName TEXT, | ||
14 | ObjectFlags INTEGER, | ||
15 | CreatorID TEXT, | ||
16 | OwnerID TEXT, | ||
17 | GroupID TEXT, | ||
18 | LastOwnerID TEXT, | ||
19 | OwnerMask INTEGER, | ||
20 | NextOwnerMask INTEGER, | ||
21 | GroupMask INTEGER, | ||
22 | EveryoneMask INTEGER, | ||
23 | BaseMask INTEGER, | ||
24 | PositionX NUMERIC, | ||
25 | PositionY NUMERIC, | ||
26 | PositionZ NUMERIC, | ||
27 | GroupPositionX NUMERIC, | ||
28 | GroupPositionY NUMERIC, | ||
29 | GroupPositionZ NUMERIC, | ||
30 | VelocityX NUMERIC, | ||
31 | VelocityY NUMERIC, | ||
32 | VelocityZ NUMERIC, | ||
33 | AngularVelocityX NUMERIC, | ||
34 | AngularVelocityY NUMERIC, | ||
35 | AngularVelocityZ NUMERIC, | ||
36 | AccelerationX NUMERIC, | ||
37 | AccelerationY NUMERIC, | ||
38 | AccelerationZ NUMERIC, | ||
39 | SitTargetOffsetX NUMERIC, | ||
40 | SitTargetOffsetY NUMERIC, | ||
41 | SitTargetOffsetZ NUMERIC, | ||
42 | RotationX NUMERIC, | ||
43 | RotationY NUMERIC, | ||
44 | RotationZ NUMERIC, | ||
45 | RotationW NUMERIC, | ||
46 | SitTargetOrientX NUMERIC, | ||
47 | SitTargetOrientY NUMERIC, | ||
48 | SitTargetOrientZ NUMERIC, | ||
49 | SitTargetOrientW NUMERIC, | ||
50 | ScaleX NUMERIC, | ||
51 | ScaleY NUMERIC, | ||
52 | ScaleZ NUMERIC, | ||
53 | PCode INTEGER, | ||
54 | PathBegin INTEGER, | ||
55 | PathEnd INTEGER, | ||
56 | PathScaleX INTEGER, | ||
57 | PathScaleY INTEGER, | ||
58 | PathShearX INTEGER, | ||
59 | PathShearY INTEGER, | ||
60 | PathSkew INTEGER, | ||
61 | PathCurve INTEGER, | ||
62 | PathRadiusOffset INTEGER, | ||
63 | PathRevolutions INTEGER, | ||
64 | PathTaperX INTEGER, | ||
65 | PathTwist INTEGER, | ||
66 | ProfileBegin INTEGER, | ||
67 | ProfileEnd INTEGER, | ||
68 | ProfileCurve INTEGER, | ||
69 | ProfileHollow INTEGER, | ||
70 | Texture BLOB, | ||
71 | ExtraParams BLOB, | ||
72 | State INTEGER, | ||
73 | primary key (UUID) | ||
74 | ); | ||
75 | create table Terrain ( | ||
76 | RegionID TEXT not null, | ||
77 | MapData BLOB, | ||
78 | primary key (RegionID) | ||
79 | ); | ||
80 | create table PrimItems ( | ||
81 | ItemID TEXT not null, | ||
82 | PrimID TEXT, | ||
83 | AssetID TEXT, | ||
84 | ParentFolderID TEXT, | ||
85 | CreatorID TEXT, | ||
86 | OwnerID TEXT, | ||
87 | GroupID TEXT, | ||
88 | LastOwnerID TEXT, | ||
89 | CurrentPermissions INTEGER, | ||
90 | BasePermissions INTEGER, | ||
91 | EveryonePermissions INTEGER, | ||
92 | GroupPermissions INTEGER, | ||
93 | NextPermissions INTEGER, | ||
94 | Name TEXT, | ||
95 | Description TEXT, | ||
96 | CreationDate INTEGER, | ||
97 | Flags INTEGER, | ||
98 | InvType INTEGER, | ||
99 | primary key (ItemID) | ||
100 | ); | ||
101 | |||
102 | COMMIT; \ No newline at end of file | ||