[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.11,1.12

[Marco M. <mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24131/b2_DataAccess

Modified Files:
	DataBaseVersionManager.cs 
Log Message:
Added code to add new columns in validateTickers table

Index: DataBaseVersionManager.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** DataBaseVersionManager.cs	21 Apr 2004 12:00:55 -0000	1.11
--- DataBaseVersionManager.cs	26 Apr 2004 14:28:29 -0000	1.12
***************
*** 92,96 ****
  	private void createDatabase()
  	{
! 		//TODO code to create an empty DB if user doesn't select the QuantProject.mdb;
  	}
  	private void createTables()
--- 92,96 ----
  	private void createDatabase()
  	{
! 		//TODO: code to create an empty DB if user doesn't select the QuantProject.mdb;
  	}
  	private void createTables()
***************
*** 169,174 ****
  	private void alterTablesAddColumns()
  	{
! 		this.executeCommand("ALTER TABLE tickers " + 
  			"ADD COLUMN tiCompanyName TEXT(100)");
  	}
  	private void alterTablesAddIndexes()
--- 169,180 ----
  	private void alterTablesAddColumns()
  	{
! 		// add code here for adding new columns to existing tables;
! 
!     this.executeCommand("ALTER TABLE tickers " + 
  			"ADD COLUMN tiCompanyName TEXT(100)");
+     this.executeCommand("ALTER TABLE validatedTickers " +
+       "ADD COLUMN vtHashValue TEXT(50)");
+     this.executeCommand("ALTER TABLE validatedTickers " +
+       "ADD COLUMN vtEditDate DATETIME");
  	}
  	private void alterTablesAddIndexes()