Computer Chess Club Archives

Search

Messages

Subject: Another shot at a computer chess engine model (with time control stuff)

Author: Dann Corbit

Date: 21:41:55 03/15/05

CREATE TABLE BlitzTimeControl ( BlitzTimeControlID int IDENTITY, MinutesBase int
NULL, SecondsBase int NULL, SecondsBonus int NULL, MillisecondsBonus int NULL )
;
CREATE TABLE BooleanParameters ( BooleanParameterID int IDENTITY,
ProgramVersionID int NOT NULL, ProgramID int NOT NULL, Name varchar(255) NULL,
Description varchar(255) NULL, DefaultValue bit, CurrentValue bit, PreviousValue
bit ) ;
CREATE TABLE CountryCodes ( CountryID int NOT NULL, abbreviation char(2) NOT
NULL, countryname varchar(255) NULL ) ;
CREATE TABLE EndGameDataBase ( EgdbTypeID int IDENTITY, ProgramID int NULL,
EgdbPath varchar(255) NULL, ProgramVersionID int NULL, IsBitbase bit, IsDTM bit,
IsDTC bit, IsDTZ bit, IsDTR bit, EgdbDllPath varchar(255) NULL, EgdbDescription
varchar(255) NULL, EgdbInterfaceDescription text NULL ) ;
CREATE TABLE FixedDepthTimeControl ( FixedDepthTimeControlID int IDENTITY, Plies
int NULL ) ;
CREATE TABLE GameTimeList ( GameTimeID int IDENTITY, GameIncrementOrder int
NULL, GameIncrementType char NULL, GameIncrement int NULL ) ;
CREATE TABLE NodeCountTimeControl ( NodeCountID int IDENTITY, Nodes float NULL )
;
CREATE TABLE NumericParameters ( NumericParameterID int IDENTITY,
ProgramVersionID int NOT NULL, ProgramID int NOT NULL, Name varchar(255) NULL,
Description varchar(255) NULL, MinimumValue float NULL, MaximumValue float NULL,
DefaultValue float NULL, CurrentValue float NULL, PreviousValue float NULL ) ;
CREATE TABLE OpeningBook ( OpeningBookID int IDENTITY, FormatID int NULL,
ProgramID int NULL, ProgramVersionID int NULL, BookName varchar(255) NULL,
BookPath varchar(255) NULL ) ;
CREATE TABLE OpeningBookFormats ( FormatID int IDENTITY, Name varchar(255) NULL,
TechnicalDescription text NULL ) ;
CREATE TABLE Program ( ProgramID int IDENTITY, ProgramName varchar(255) NULL ) ;
CREATE TABLE ProgrammerInfo ( ProgrammerID int IDENTITY, Picture image NULL,
Greeting image NULL, Biography text NULL ) ;
CREATE TABLE Programmers ( ProgrammerID int IDENTITY, Firstname varchar(255)
NULL, ProgramID int NOT NULL, CountryID int NULL, middlename varchar(255) NULL,
lastname varchar(255) NULL, title varchar(255) NULL, notes text NULL ) ;
CREATE TABLE ProgramVersion ( ProgramID int NOT NULL, ProgramVersionID int
IDENTITY, ProgramVersionOrDate varchar(255) NULL, PhysicalLocation varchar(255)
NULL, PhysicalName varchar(255) NULL, LogicalName varchar(255) NULL, EgdbID int
NOT NULL ) ;
CREATE TABLE SecondsPerMoveTimeControl ( SecondsPerMoveID int IDENTITY, Seconds
int NULL ) ;
CREATE TABLE StringParameters ( StringParameterID int IDENTITY, ProgramVersionID
int NOT NULL, ProgramID int NOT NULL, Name varchar(255) NULL, Description
varchar(255) NULL, CurrentValue varchar(255) NULL ) ;
CREATE TABLE TournamentTimeControl ( TournamentTimeControlID int IDENTITY, Moves
int NULL, Minutes int NULL ) ;

ALTER TABLE BlitzTimeControl ADD PRIMARY KEY (BlitzTimeControlID) ;
ALTER TABLE BooleanParameters ADD FOREIGN KEY (ProgramVersionID, ProgramID)
REFERENCES ProgramVersion ;
ALTER TABLE BooleanParameters ADD PRIMARY KEY NONCLUSTERED (BooleanParameterID,
ProgramVersionID, ProgramID) ;
ALTER TABLE CountryCodes ADD PRIMARY KEY (CountryID) ;
ALTER TABLE EndGameDataBase ADD FOREIGN KEY (ProgramVersionID, ProgramID)
REFERENCES ProgramVersion ;
ALTER TABLE EndGameDataBase ADD PRIMARY KEY NONCLUSTERED (EgdbTypeID) ;
ALTER TABLE FixedDepthTimeControl ADD PRIMARY KEY (FixedDepthTimeControlID) ;
ALTER TABLE GameTimeList ADD PRIMARY KEY (GameTimeID) ;
ALTER TABLE NodeCountTimeControl ADD PRIMARY KEY (NodeCountID) ;
ALTER TABLE NumericParameters ADD FOREIGN KEY (ProgramVersionID, ProgramID)
REFERENCES ProgramVersion ;
ALTER TABLE NumericParameters ADD PRIMARY KEY NONCLUSTERED (NumericParameterID,
ProgramVersionID, ProgramID) ;
ALTER TABLE OpeningBook ADD FOREIGN KEY (FormatID) REFERENCES OpeningBookFormats
;
ALTER TABLE OpeningBook ADD FOREIGN KEY (ProgramVersionID, ProgramID) REFERENCES
ProgramVersion ;
ALTER TABLE OpeningBook ADD PRIMARY KEY NONCLUSTERED (OpeningBookID) ;
ALTER TABLE OpeningBookFormats ADD PRIMARY KEY (FormatID) ;
ALTER TABLE Program ADD PRIMARY KEY NONCLUSTERED (ProgramID) ;
ALTER TABLE ProgrammerInfo ADD PRIMARY KEY NONCLUSTERED (ProgrammerID) ;
ALTER TABLE Programmers ADD FOREIGN KEY (CountryID) REFERENCES CountryCodes ;
ALTER TABLE Programmers ADD FOREIGN KEY (ProgramID) REFERENCES Program ;
ALTER TABLE Programmers ADD FOREIGN KEY (ProgrammerID) REFERENCES ProgrammerInfo
;
ALTER TABLE Programmers ADD PRIMARY KEY (ProgrammerID, ProgramID) ;
ALTER TABLE ProgramVersion ADD FOREIGN KEY (ProgramID) REFERENCES Program ;
ALTER TABLE ProgramVersion ADD PRIMARY KEY NONCLUSTERED (ProgramVersionID,
ProgramID) ;
ALTER TABLE SecondsPerMoveTimeControl ADD PRIMARY KEY (SecondsPerMoveID) ;
ALTER TABLE StringParameters ADD FOREIGN KEY (ProgramVersionID, ProgramID)
REFERENCES ProgramVersion ;
ALTER TABLE StringParameters ADD PRIMARY KEY NONCLUSTERED (StringParameterID,
ProgramVersionID, ProgramID) ;
ALTER TABLE TournamentTimeControl ADD PRIMARY KEY (TournamentTimeControlID) ;

CREATE INDEX BooleanParameters_INDEX_2 ON BooleanParameters ( Name ) ;
CREATE INDEX NumericParameters_INDEX_2 ON NumericParameters ( Name ) ;
CREATE INDEX OpeningBook_INDEX_2 ON OpeningBook ( BookName ) ;
CREATE INDEX OpeningBook_INDEX_3 ON OpeningBook ( FormatID ) ;
CREATE INDEX OpeningBook_INDEX_4 ON OpeningBook ( ProgramID ) ;
CREATE INDEX OpeningBook_INDEX_5 ON OpeningBook ( ProgramVersionID ) ;
CREATE INDEX Programmers_INDEX_3 ON Programmers ( Firstname ) ;
CREATE INDEX Programmers_INDEX_4 ON Programmers ( lastname ) ;
CREATE INDEX ProgramVersion_INDEX_4 ON ProgramVersion ( PhysicalName ) ;
CREATE INDEX ProgramVersion_INDEX_5 ON ProgramVersion ( ProgramID ) ;
CREATE INDEX StringParameters_INDEX_2 ON StringParameters ( Name ) ;
CREATE INDEX XIF10Programmers ON Programmers ( ProgramID ) ;
CREATE INDEX XIF11EndGameDataBase ON EndGameDataBase ( ProgramID,
ProgramVersionID ) ;
CREATE INDEX XIF13Programmers ON Programmers ( ProgrammerID ) ;
CREATE INDEX XIF16Programmers ON Programmers ( CountryID ) ;
CREATE INDEX XIF17OpeningBook ON OpeningBook ( ProgramID, ProgramVersionID ) ;
CREATE INDEX XIF21NumericParameters ON NumericParameters ( ProgramVersionID,
ProgramID ) ;
CREATE INDEX XIF22StringParameters ON StringParameters ( ProgramVersionID,
ProgramID ) ;
CREATE INDEX XIF23BooleanParameters ON BooleanParameters ( ProgramVersionID,
ProgramID ) ;

• What the model looks like Dann Corbit 21:45:22 03/15/05

This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.