aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim
diff options
context:
space:
mode:
authorSean Dague2007-08-09 00:42:32 +0000
committerSean Dague2007-08-09 00:42:32 +0000
commit8425693076119278413e1ba8036f2f19820d106f (patch)
tree183ecfa8423a7dd5a29420b246519369ea9cf3b9 /OpenSim
parent* Checked in new tweaked Prebuild.exe (diff)
downloadopensim-SC_OLD-8425693076119278413e1ba8036f2f19820d106f.zip
opensim-SC_OLD-8425693076119278413e1ba8036f2f19820d106f.tar.gz
opensim-SC_OLD-8425693076119278413e1ba8036f2f19820d106f.tar.bz2
opensim-SC_OLD-8425693076119278413e1ba8036f2f19820d106f.tar.xz
Commit in the changes for all the parameter bindings for prims
Diffstat (limited to '')
-rw-r--r--OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs40
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