aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-12-04 20:48:08 +0000
committerJustin Clarke Casey2008-12-04 20:48:08 +0000
commitbdee86563cfce5211f182b78e64503a05fc7ffa1 (patch)
tree9b1e7e941e787d36f2248ff4b57f101a779351a6 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
parent* Apply http://opensimulator.org/mantis/view.php?id=2750 with a small tweak. (diff)
downloadopensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.zip
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.gz
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.bz2
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.xz
* Check in another patch from http://opensimulator.org/mantis/view.php?id=2710
* This allows removal of the old NHiberate.Mapping.Attributes.dll * Also add in the files I forgot about last time. Doh!
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql102
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 @@
1BEGIN TRANSACTION;
2
3create 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);
75create table Terrain (
76 RegionID TEXT not null,
77 MapData BLOB,
78 primary key (RegionID)
79);
80create 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
102COMMIT; \ No newline at end of file