[chronojump] Removed name from encoder sql



commit 68b0bc4d18e41249f0f23aca329bff5975efee60
Author: Xavier de Blas <xaviblas gmail com>
Date:   Tue Apr 10 18:17:48 2012 +0200

    Removed name from encoder sql

 diagrams/sqlite/chronojump_sqlite.dia |  Bin 12855 -> 12849 bytes
 diagrams/sqlite/chronojump_sqlite.png |  Bin 157843 -> 157555 bytes
 src/sqlite/encoder.cs                 |    7 +++----
 3 files changed, 3 insertions(+), 4 deletions(-)
---
diff --git a/diagrams/sqlite/chronojump_sqlite.dia b/diagrams/sqlite/chronojump_sqlite.dia
index 554b1ac..7603870 100644
Binary files a/diagrams/sqlite/chronojump_sqlite.dia and b/diagrams/sqlite/chronojump_sqlite.dia differ
diff --git a/diagrams/sqlite/chronojump_sqlite.png b/diagrams/sqlite/chronojump_sqlite.png
index 475d98f..051de5e 100644
Binary files a/diagrams/sqlite/chronojump_sqlite.png and b/diagrams/sqlite/chronojump_sqlite.png differ
diff --git a/src/sqlite/encoder.cs b/src/sqlite/encoder.cs
index e14bb05..91cce3c 100644
--- a/src/sqlite/encoder.cs
+++ b/src/sqlite/encoder.cs
@@ -43,7 +43,6 @@ class SqliteEncoder : Sqlite
 			"uniqueID INTEGER PRIMARY KEY, " +
 			"personID INT, " +
 			"sessionID INT, " +
-			"name TEXT, " +
 			"url TEXT, " +
 			"type TEXT, " +		//"bar" or "jump"
 			"extraWeight TEXT, " +	//string because can contain "33%" or "50Kg"
@@ -60,7 +59,7 @@ class SqliteEncoder : Sqlite
 	 * Encoder class methods
 	 */
 	
-	public static int Insert(bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string name, string url, string type, string extraWeight, string eccon, int time, int minHeight, float smooth, string description)
+	public static int Insert(bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string url, string type, string extraWeight, string eccon, int time, int minHeight, float smooth, string description)
 	{
 		if(! dbconOpened)
 			dbcon.Open();
@@ -69,9 +68,9 @@ class SqliteEncoder : Sqlite
 			uniqueID = "NULL";
 
 		dbcmd.CommandText = "INSERT INTO " + tableName +  
-				" (uniqueID, personID, sessionID, name, url, type, extraWeight, econ, time, minHeight, smooth, description)" +
+				" (uniqueID, personID, sessionID, url, type, extraWeight, econ, time, minHeight, smooth, description)" +
 				" VALUES (" + uniqueID + ", "
-				+ personID + ", " + sessionID + ", '" + name + "', '" + url + "', '" + type + "', '" 
+				+ personID + ", " + sessionID + ", '" + url + "', '" + type + "', '" 
 				+ extraWeight + "', '" + eccon + "', " + time + ", " + minHeight + ", " 
 				+ Util.ConvertToPoint(smooth) + ", '" + description + "')" ;
 		Log.WriteLine(dbcmd.CommandText.ToString());



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]