[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.6,1.7

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

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

Modified Files:
	DataBaseVersionManager.cs 
Log Message:
Modified tables in QuantProject.mdb

Index: DataBaseVersionManager.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** DataBaseVersionManager.cs	17 Jan 2004 19:10:14 -0000	1.6
--- DataBaseVersionManager.cs	4 Feb 2004 19:39:19 -0000	1.7
***************
*** 159,163 ****
  			this.executeCommand("ALTER TABLE quotes ADD CONSTRAINT PKquTicker_quDate " +
  								"PRIMARY KEY (quTicker, quDate)");
! 
  			this.executeCommand("ALTER TABLE validatedTickers ADD CONSTRAINT myKey PRIMARY KEY ( vtTicker )");
  			this.executeCommand("ALTER TABLE tickers_tickerGroups " + 
--- 159,163 ----
  			this.executeCommand("ALTER TABLE quotes ADD CONSTRAINT PKquTicker_quDate " +
  								"PRIMARY KEY (quTicker, quDate)");
! 			this.executeCommand("ALTER TABLE tickerGroups ADD CONSTRAINT PKtgId PRIMARY KEY (tgId)");
  			this.executeCommand("ALTER TABLE validatedTickers ADD CONSTRAINT myKey PRIMARY KEY ( vtTicker )");
  			this.executeCommand("ALTER TABLE tickers_tickerGroups " + 
***************
*** 170,174 ****
  	private void alterTablesAddColumns()
  	{
! 		//add code here for adding columns to existing tables;
  	}
  	private void alterTablesAddIndexes()
--- 170,175 ----
  	private void alterTablesAddColumns()
  	{
! 		this.executeCommand("ALTER TABLE tickers " + 
! 			"ADD COLUMN tiCompanyName TEXT(100)");
  	}
  	private void alterTablesAddIndexes()