diff options
Diffstat (limited to 'OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs')
-rw-r--r-- | OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs | 40 |
1 files changed, 38 insertions, 2 deletions
diff --git a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs index fc017d9..e408481 100644 --- a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs +++ b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs | |||
@@ -70,14 +70,50 @@ namespace OpenSim.DataStore.MonoSqliteStorage | |||
70 | 70 | ||
71 | private void setupPrimCommands(SqliteDataAdapter da, SqliteConnection conn) | 71 | private void setupPrimCommands(SqliteDataAdapter da, SqliteConnection conn) |
72 | { | 72 | { |
73 | /* | ||
74 | * Create all the bound parameters. Try to keep these in the same order | ||
75 | * as the sql file, with comments in the same places, or your head will probably | ||
76 | * explode trying to do corolations | ||
77 | */ | ||
73 | SqliteParameter UUID = createSqliteParameter("UUID", DbType.String); | 78 | SqliteParameter UUID = createSqliteParameter("UUID", DbType.String); |
74 | SqliteParameter Name = createSqliteParameter("Name", DbType.String); | 79 | SqliteParameter ParentID = createSqliteParameter("ParentID", DbType.Int32); |
75 | SqliteParameter CreationDate = createSqliteParameter("CreationDate", DbType.Int32); | 80 | SqliteParameter CreationDate = createSqliteParameter("CreationDate", DbType.Int32); |
81 | SqliteParameter Name = createSqliteParameter("Name", DbType.String); | ||
82 | // various text fields | ||
83 | SqliteParameter Text = createSqliteParameter("Text", DbType.String); | ||
84 | SqliteParameter Description = createSqliteParameter("Description", DbType.String); | ||
85 | SqliteParameter SitName = createSqliteParameter("SitName", DbType.String); | ||
86 | SqliteParameter TouchName = createSqliteParameter("TouchName", DbType.String); | ||
87 | // permissions | ||
88 | SqliteParameter CreatorID = createSqliteParameter("CreatorID", DbType.String); | ||
89 | SqliteParameter OwnerID = createSqliteParameter("OwnerID", DbType.String); | ||
90 | SqliteParameter GroupID = createSqliteParameter("GroupID", DbType.String); | ||
91 | SqliteParameter LastOwnerID = createSqliteParameter("LastOwnerID", DbType.String); | ||
92 | SqliteParameter OwnerMask = createSqliteParameter("OwnerMask", DbType.Int32); | ||
93 | SqliteParameter NextOwnerMask = createSqliteParameter("NextOwnerMask", DbType.Int32); | ||
94 | SqliteParameter GroupMask = createSqliteParameter("GroupMask", DbType.Int32); | ||
95 | SqliteParameter EveryoneMask = createSqliteParameter("EveryoneMask", DbType.Int32); | ||
96 | SqliteParameter BaseMask = createSqliteParameter("BaseMask", DbType.Int32); | ||
97 | // vectors | ||
76 | SqliteParameter PositionX = createSqliteParameter("PositionX", DbType.Double); | 98 | SqliteParameter PositionX = createSqliteParameter("PositionX", DbType.Double); |
77 | SqliteParameter PositionY = createSqliteParameter("PositionY", DbType.Double); | 99 | SqliteParameter PositionY = createSqliteParameter("PositionY", DbType.Double); |
78 | SqliteParameter PositionZ = createSqliteParameter("PositionZ", DbType.Double); | 100 | SqliteParameter PositionZ = createSqliteParameter("PositionZ", DbType.Double); |
101 | SqliteParameter VelocityX = createSqliteParameter("VelocityX", DbType.Double); | ||
102 | SqliteParameter VelocityY = createSqliteParameter("VelocityY", DbType.Double); | ||
103 | SqliteParameter VelocityZ = createSqliteParameter("VelocityZ", DbType.Double); | ||
104 | SqliteParameter AngularVelocityX = createSqliteParameter("AngularVelocityX", DbType.Double); | ||
105 | SqliteParameter AngularVelocityY = createSqliteParameter("AngularVelocityY", DbType.Double); | ||
106 | SqliteParameter AngularVelocityZ = createSqliteParameter("AngularVelocityZ", DbType.Double); | ||
107 | SqliteParameter AccelerationX = createSqliteParameter("AccelerationX", DbType.Double); | ||
108 | SqliteParameter AccelerationY = createSqliteParameter("AccelerationY", DbType.Double); | ||
109 | SqliteParameter AccelerationZ = createSqliteParameter("AccelerationZ", DbType.Double); | ||
110 | // quaternions | ||
111 | SqliteParameter RotationX = createSqliteParameter("RotationX", DbType.Double); | ||
112 | SqliteParameter RotationY = createSqliteParameter("RotationY", DbType.Double); | ||
113 | SqliteParameter RotationZ = createSqliteParameter("RotationZ", DbType.Double); | ||
114 | SqliteParameter RotationW = createSqliteParameter("RotationW", DbType.Double); | ||
79 | 115 | ||
80 | 116 | ||
81 | SqliteCommand delete = new SqliteCommand("delete from prims where UUID = :UUID"); | 117 | SqliteCommand delete = new SqliteCommand("delete from prims where UUID = :UUID"); |
82 | delete.Connection = conn; | 118 | delete.Connection = conn; |
83 | 119 | ||