[Quantproject-developers] QuantProject/b2_DataAccess DataBaseVersionManager.cs,1.13,1.14

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

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

Modified Files:
	DataBaseVersionManager.cs 
Log Message:


Index: DataBaseVersionManager.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** DataBaseVersionManager.cs	7 Jul 2004 20:17:11 -0000	1.13
--- DataBaseVersionManager.cs	1 Dec 2004 22:47:00 -0000	1.14
***************
*** 96,101 ****
  	private void createTables()
      {
! 		this.executeCommand("CREATE TABLE tickers (tiTicker TEXT(8))");
! 		this.executeCommand("CREATE TABLE quotes (quTicker TEXT(8), quDate DATETIME, " +
  							"quOpen REAL, quHigh REAL, quLow REAL, quClose REAL, " +
  							"quVolume INTEGER, quAdjustedClose REAL, quAdjustedCloseToCloseRatio FLOAT)");
--- 96,101 ----
  	private void createTables()
      {
! 		this.executeCommand("CREATE TABLE tickers (tiTicker TEXT(10))");
! 		this.executeCommand("CREATE TABLE quotes (quTicker TEXT(10), quDate DATETIME, " +
  							"quOpen REAL, quHigh REAL, quLow REAL, quClose REAL, " +
  							"quVolume INTEGER, quAdjustedClose REAL, quAdjustedCloseToCloseRatio FLOAT)");
***************
*** 109,117 ****
      // a ticker can belong to one or more groups 
      this.executeCommand("CREATE TABLE tickers_tickerGroups " +
!       "( ttTgId TEXT(8) , ttTiId TEXT(8))");
      // validatedTickers will contain a record for each ticker whose quotes have already
      // been validated. The quotes are meant to be ok from vtStartDate to vtEndDate.
      this.executeCommand( "CREATE TABLE validatedTickers " +
!       "( vtTicker TEXT(8) , vtStartDate DATETIME , vtEndDate DATETIME , " +
  			"vtHashValue TEXT(50) , vtEditDate DATETIME, " +
        "CONSTRAINT myKey PRIMARY KEY ( vtTicker ) )" );
--- 109,117 ----
      // a ticker can belong to one or more groups 
      this.executeCommand("CREATE TABLE tickers_tickerGroups " +
!       "( ttTgId TEXT(8) , ttTiId TEXT(10))");
      // validatedTickers will contain a record for each ticker whose quotes have already
      // been validated. The quotes are meant to be ok from vtStartDate to vtEndDate.
      this.executeCommand( "CREATE TABLE validatedTickers " +
!       "( vtTicker TEXT(10) , vtStartDate DATETIME , vtEndDate DATETIME , " +
  			"vtHashValue TEXT(50) , vtEditDate DATETIME, " +
        "CONSTRAINT myKey PRIMARY KEY ( vtTicker ) )" );
***************
*** 125,129 ****
      // vvEditDate: Last date this record has been added/modified
      this.executeCommand( "CREATE TABLE visuallyValidatedQuotes " +
!       "( vvTicker TEXT(8) , vvDate DATETIME , vvValidationType INT , " +
        "vvHashValue TEXT(50) , vvEditDate DATETIME , " +
        "CONSTRAINT myKey PRIMARY KEY ( vvTicker , vvDate , vvValidationType ) )" );
--- 125,129 ----
      // vvEditDate: Last date this record has been added/modified
      this.executeCommand( "CREATE TABLE visuallyValidatedQuotes " +
!       "( vvTicker TEXT(10) , vvDate DATETIME , vvValidationType INT , " +
        "vvHashValue TEXT(50) , vvEditDate DATETIME , " +
        "CONSTRAINT myKey PRIMARY KEY ( vvTicker , vvDate , vvValidationType ) )" );
***************
*** 134,138 ****
      // qsEditDate: last date this record has been added/modified
      this.executeCommand( "create table quotesFromSecondarySources " +
!       "(qsTicker TEXT(8) , " +
        "qsDate DATETIME , " +
        "qsSource SHORT , " +
--- 134,138 ----
      // qsEditDate: last date this record has been added/modified
      this.executeCommand( "create table quotesFromSecondarySources " +
!       "(qsTicker TEXT(10) , " +
        "qsDate DATETIME , " +
        "qsSource SHORT , " +
***************
*** 149,153 ****
  	// faultyTickers will contain tickers not downloaded from the web
  		this.executeCommand( "CREATE TABLE  faultyTickers " +
!       "(ftTicker TEXT(8) , " +
        "ftDate DATETIME)");
      }
--- 149,153 ----
  	// faultyTickers will contain tickers not downloaded from the web
  		this.executeCommand( "CREATE TABLE  faultyTickers " +
!       "(ftTicker TEXT(10) , " +
        "ftDate DATETIME)");
      }
***************
*** 172,176 ****
  
      this.executeCommand("ALTER TABLE tickers " + 
! 			"ADD COLUMN tiCompanyName TEXT(100)");
      this.executeCommand("ALTER TABLE validatedTickers " +
        "ADD COLUMN vtHashValue TEXT(50)");
--- 172,176 ----
  
      this.executeCommand("ALTER TABLE tickers " + 
! 			"ADD COLUMN tiCompanyName TEXT(100) NOT NULL");
      this.executeCommand("ALTER TABLE validatedTickers " +
        "ADD COLUMN vtHashValue TEXT(50)");