DROP TABLE MiscellaneousSupplementalTag
go
 
 CREATE TABLE MiscellaneousSupplementalTag (
        GameID               int NOT NULL,
        Annotator            varchar(20) NULL,
        Node                 varchar(20) NULL,
        PlyCount             int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX MiscellaneousSupplementalTag.PK__MiscellaneousSup__57DD0BE4
go
 
 
 ALTER TABLE MiscellaneousSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE OpeningSupplementalTag
go
 
 CREATE TABLE OpeningSupplementalTag (
        GameID               int NOT NULL,
        Opening              varchar(255) NULL,
        Variation            varchar(255) NULL,
        SubVariation         varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX OpeningSupplementalTag.PK__OpeningSupplemen__5F7E2DAC
go
 
 
 ALTER TABLE OpeningSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE PlayerSupplementalTag
go
 
 CREATE TABLE PlayerSupplementalTag (
        GameID               int NOT NULL,
        BlackCountry         varchar(3) NULL,
        WhiteCountry         varchar(3) NULL,
        WhiteTitle           varchar(20) NULL,
        BlackTitle           varchar(20) NULL,
        WhiteELO             varchar(20) NULL,
        BlackELO             varchar(20) NULL,
        WhiteNA              varchar(20) NULL,
        BlackNA              varchar(10) NULL,
        WhiteType            varchar(20) NULL,
        BlackType            varchar(20) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX PlayerSupplementalTag.PK__PlayerSupplement__65370702
go
 
 
 ALTER TABLE PlayerSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE TimeControlSupplementalTag
go
 
 CREATE TABLE TimeControlSupplementalTag (
        GameID               int NOT NULL,
        TimeControl          varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX TimeControlSupplementalTag.PK__TimeControlSuppl__6CD828CA
go
 
 
 ALTER TABLE TimeControlSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE Nags
go
 
 CREATE TABLE Nags (
        SanMoveBlack         varchar(8) NULL,
        SanMoveWhite         varchar(8) NULL,
        GameID               int NULL,
        MoveNumberIndication int NULL,
        NAG                  int NOT NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX Nags.PK__Nags__5D95E53A
go
 
 
 ALTER TABLE Nags
        ADD PRIMARY KEY (NAG)
               ON "PRIMARY"
go
 
 
 DROP TABLE Rav
go
 
 CREATE TABLE Rav (
        SanMoveBlack         varchar(8) NOT NULL,
        SanMoveWhite         varchar(8) NOT NULL,
        GameID               int NOT NULL,
        MoveNumberIndication int NOT NULL,
        Rav                  varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX Rav.XPKRav
go
 
 
 ALTER TABLE Rav
        ADD CONSTRAINT XPKRav PRIMARY KEY (SanMoveBlack, SanMoveWhite, 
               GameID, MoveNumberIndication)
go
 
 
 DROP TABLE Movetext
go
 
 CREATE TABLE Movetext (
        GameID               int NOT NULL,
        MoveNumberIndication int NOT NULL,
        SanMoveWhite         varchar(8) NOT NULL,
        SanMoveBlack         varchar(8) NOT NULL,
        FenIDBlack           int NULL,
        SanMoveBlackEpdID    int NOT NULL,
        FenIDWhite           int NULL,
        SanMoveWhiteEpdID    int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX Movetext.PK__Movetext__59C55456
go
 
 DROP INDEX Movetext.XIF39Movetext
go
 
 DROP INDEX Movetext.XIF41Movetext
go
 
 DROP INDEX Movetext.XIF42Movetext
go
 
 CREATE INDEX XIF39Movetext ON Movetext
 (
        SanMoveWhiteEpdID
 )
go
 
 CREATE INDEX XIF41Movetext ON Movetext
 (
        FenIDWhite
 )
go
 
 CREATE INDEX XIF42Movetext ON Movetext
 (
        FenIDBlack
 )
go
 
 
 ALTER TABLE Movetext
        ADD PRIMARY KEY (GameID, MoveNumberIndication, SanMoveWhite, 
               SanMoveBlack)
               ON "PRIMARY"
go
 
 
 DROP TABLE AlternateOpeningClassificationSupplementalTag
go
 
 CREATE TABLE AlternateOpeningClassificationSupplementalTag (
        GameID               int NOT NULL,
        EcoCode              varchar(6) NOT NULL,
        NicCode              varchar(20) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX AlternateOpeningClassificationSupplementalTag.XPKAlternateOpeningClassificationSupplementalTag
go
 
 
 ALTER TABLE AlternateOpeningClassificationSupplementalTag
        ADD CONSTRAINT XPKAlternateOpeningClassificationSupplementalTag PRIMARY KEY (
               GameID, EcoCode)
               ON "PRIMARY"
go
 
 
 DROP TABLE AlternateStartingPositionsSupplementalTag
go
 
 CREATE TABLE AlternateStartingPositionsSupplementalTag (
        GameID               int NOT NULL,
        FenID                int NOT NULL,
        Setup                int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX AlternateStartingPositionsSupplementalTag.PK__AlternateStartin__40058253
go
 
 
 ALTER TABLE AlternateStartingPositionsSupplementalTag
        ADD PRIMARY KEY (GameID, FenID)
               ON "PRIMARY"
go
 
 
 DROP TABLE DateTimeSupplementalTag
go
 
 CREATE TABLE DateTimeSupplementalTag (
        GameID               int NOT NULL,
        Time                 varchar(10) NULL,
        UTCTime              varchar(10) NULL,
        UTCDate              varchar(20) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX DateTimeSupplementalTag.PK__DateTimeSuppleme__4A8310C6
go
 
 
 ALTER TABLE DateTimeSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE EventSupplementalTag
go
 
 CREATE TABLE EventSupplementalTag (
        GameID               int NOT NULL,
        EventDate            varchar(20) NULL,
        EventSponsor         varchar(20) NULL,
        Section              varchar(20) NULL,
        Stage                varchar(20) NULL,
        Board                int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EventSupplementalTag.PK__EventSupplementa__540C7B00
go
 
 
 ALTER TABLE EventSupplementalTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE PgnGameTag
go
 
 CREATE TABLE PgnGameTag (
        GameID               int IDENTITY,
        WhitePlayerID        int NOT NULL,
        BlackPlayerID        int NOT NULL,
        Event                varchar(80) NOT NULL,
        Site                 varchar(80) NOT NULL,
        GameDate             varchar(10) NOT NULL,
        Round                varchar(8) NOT NULL,
        Result               varchar(7) NOT NULL,
        PlyCount             int NULL,
        GameCRC              int NULL,
        CONSTRAINT XAK1PgnGameTag
        UNIQUE (
               GameCRC
        )
               ON "PRIMARY",
        CONSTRAINT XAK2PgnGameTag
        UNIQUE (
               Event,
               Site,
               GameDate,
               Round,
               Result
        )
               ON "PRIMARY"
 )
        ON "PRIMARY"
go
 
 DROP INDEX PgnGameTag.PK__PgnGameTag__6166761E
go
 
 DROP INDEX PgnGameTag.XAK1PgnGameTag
go
 
 DROP INDEX PgnGameTag.XAK2PgnGameTag
go
 
 DROP INDEX PgnGameTag.XIF47PgnGameTag
go
 
 DROP INDEX PgnGameTag.XIF48PgnGameTag
go
 
 CREATE INDEX XIF47PgnGameTag ON PgnGameTag
 (
        BlackPlayerID
 )
go
 
 CREATE INDEX XIF48PgnGameTag ON PgnGameTag
 (
        WhitePlayerID
 )
go
 
 
 ALTER TABLE PgnGameTag
        ADD PRIMARY KEY (GameID)
               ON "PRIMARY"
go
 
 
 DROP TABLE EnginePlayer
go
 
 CREATE TABLE EnginePlayer (
        EnginePlayerID       int NOT NULL,
        ComputerID           int NULL,
        EngineID             int NULL,
        VersionID            int NULL
 )
go
 
 DROP INDEX EnginePlayer.XPKEnginePlayer
go
 
 DROP INDEX EnginePlayer.XIF43EnginePlayer
go
 
 DROP INDEX EnginePlayer.XIF44EnginePlayer
go
 
 CREATE INDEX XIF43EnginePlayer ON EnginePlayer
 (
        EngineID,
        VersionID
 )
go
 
 CREATE INDEX XIF44EnginePlayer ON EnginePlayer
 (
        ComputerID
 )
go
 
 
 ALTER TABLE EnginePlayer
        ADD CONSTRAINT XPKEnginePlayer PRIMARY KEY (EnginePlayerID)
go
 
 
 DROP TABLE Players
go
 
 CREATE TABLE Players (
        HumanPlayerID        int NOT NULL,
        FicsID               int NULL,
        Name                 varchar(255) NOT NULL,
        CountryCode          varchar(3) NULL,
        RO                   int NULL,
        BirthDate            smalldatetime NULL,
        Sex                  char(1) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX Players.PK__Players__634EBE90
go
 
 DROP INDEX Players.XIF49Players
go
 
 CREATE INDEX XIF49Players ON Players
 (
        CountryCode
 )
go
 
 
 ALTER TABLE Players
        ADD PRIMARY KEY (HumanPlayerID)
               ON "PRIMARY"
go
 
 
 DROP TABLE AnyPlayer
go
 
 CREATE TABLE AnyPlayer (
        AnyPlayerID          int IDENTITY
 )
go
 
 DROP INDEX AnyPlayer.XPKAnyPlayer
go
 
 
 ALTER TABLE AnyPlayer
        ADD CONSTRAINT XPKAnyPlayer PRIMARY KEY (AnyPlayerID)
go
 
 
 DROP TABLE Computer
go
 
 CREATE TABLE Computer (
        ComputerID           int NOT NULL,
        MHz                  int NULL,
        MB_Hash              int NULL,
        EGTB_Max_Pieces      int NULL,
        Manufacturer         varchar(255) NULL,
        Model                varchar(255) NULL,
        Notes                varchar(255) NULL
 )
go
 
 DROP INDEX Computer.XPKComputer
go
 
 
 ALTER TABLE Computer
        ADD CONSTRAINT XPKComputer PRIMARY KEY (ComputerID)
go
 
 
 DROP TABLE PositionStatistics
go
 
 CREATE TABLE PositionStatistics (
        EpdID                int NOT NULL,
        Wins                 int NULL,
        Losses               int NULL,
        Draws                int NULL,
        Unfinished           int NULL,
        EloSum               int NULL,
        EloCount             int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX PositionStatistics.PK__PositionStatisti__671F4F74
go
 
 
 ALTER TABLE PositionStatistics
        ADD PRIMARY KEY (EpdID)
               ON "PRIMARY"
go
 
 
 DROP TABLE EngineEvaluation
go
 
 CREATE TABLE EngineEvaluation (
        EpdID                int NOT NULL,
        VersionID            int NULL,
        Flags                int NULL,
        Centipawns           int NULL,
        Depth                int NULL,
        LogNodes             float NULL,
        EngineID             int NOT NULL,
        bm                   varchar(8) NULL,
        er                   varchar(8) NULL,
        am                   varchar(8) NULL,
        dm                   int NULL,
        id                   varchar(255) NULL,
        pv                   varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EngineEvaluation.PK__EngineEvaluation__31EC6D26
go
 
 DROP INDEX EngineEvaluation._WA_Sys_EngineID_182C9B23
go
 
 DROP INDEX EngineEvaluation.XIF37EngineEvaluation
go
 
 CREATE INDEX _WA_Sys_EngineID_182C9B23 ON EngineEvaluation
 (
        EngineID
 )
        ON "PRIMARY"
go
 
 CREATE INDEX XIF37EngineEvaluation ON EngineEvaluation
 (
        VersionID,
        EngineID
 )
        ON "PRIMARY"
go
 
 
 ALTER TABLE EngineEvaluation
        ADD PRIMARY KEY (EpdID)
               ON "PRIMARY"
go
 
 
 DROP TABLE Engines
go
 
 CREATE TABLE Engines (
        EngineID             int IDENTITY,
        VersionID            int NOT NULL,
        EngineName           varchar(255) NULL,
        AuthorID             int NOT NULL,
        EngineDate           datetime NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX Engines.PK__Engines__300424B4
go
 
 DROP INDEX Engines._WA_Sys_AuthorID_117F9D94
go
 
 DROP INDEX Engines.XIF35Engines
go
 
 DROP INDEX Engines.XIF36Engines
go
 
 CREATE INDEX _WA_Sys_AuthorID_117F9D94 ON Engines
 (
        AuthorID
 )
        ON "PRIMARY"
go
 
 CREATE INDEX XIF35Engines ON Engines
 (
        AuthorID
 )
        ON "PRIMARY"
go
 
 CREATE INDEX XIF36Engines ON Engines
 (
        VersionID
 )
        ON "PRIMARY"
go
 
 
 ALTER TABLE Engines
        ADD PRIMARY KEY (EngineID, VersionID)
               ON "PRIMARY"
go
 
 
 DROP TABLE BookOpinion
go
 
 CREATE TABLE BookOpinion (
        NAG                  int NOT NULL,
        BookCode             char(3) NOT NULL,
        EpdID                int NOT NULL,
        ce                   int NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX BookOpinion.XPKBookOpinion
go
 
 
 ALTER TABLE BookOpinion
        ADD CONSTRAINT XPKBookOpinion PRIMARY KEY (EpdID, BookCode)
               ON "PRIMARY"
go
 
 
 DROP TABLE ChessBooks
go
 
 CREATE TABLE ChessBooks (
        BookCode             char(3) NOT NULL,
        BookName             varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX ChessBooks.PK__ChessBooks__46B27FE2
go
 
 
 ALTER TABLE ChessBooks
        ADD PRIMARY KEY (BookCode)
               ON "PRIMARY"
go
 
 
 DROP TABLE EngineAuthors
go
 
 CREATE TABLE EngineAuthors (
        AuthorID             int IDENTITY,
        FirstName            varchar(255) NULL,
        LastName             varchar(255) NULL,
        MiddleName           varchar(255) NULL,
        Title                varchar(255) NULL,
        CountryCode          varchar(3) NOT NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EngineAuthors.PK__EngineAuthors__50FB042B
go
 
 DROP INDEX EngineAuthors._WA_Sys_FirstName_0CBAE877
go
 
 DROP INDEX EngineAuthors._WA_Sys_LastName_0CBAE877
go
 
 DROP INDEX EngineAuthors.XIF40EngineAuthors
go
 
 CREATE INDEX _WA_Sys_FirstName_0CBAE877 ON EngineAuthors
 (
        FirstName
 )
        ON "PRIMARY"
go
 
 CREATE INDEX _WA_Sys_LastName_0CBAE877 ON EngineAuthors
 (
        LastName
 )
        ON "PRIMARY"
go
 
 CREATE INDEX XIF40EngineAuthors ON EngineAuthors
 (
        CountryCode
 )
        ON "PRIMARY"
go
 
 
 ALTER TABLE EngineAuthors
        ADD PRIMARY KEY (AuthorID)
               ON "PRIMARY"
go
 
 
 DROP TABLE CountryCodeDomain
go
 
 CREATE TABLE CountryCodeDomain (
        CountryCode          varchar(3) NOT NULL,
        CountryDescription   varchar(255) NULL,
        CONSTRAINT XAK1CountryCodeDomain
        UNIQUE (
               CountryDescription
        )
               ON "PRIMARY"
 )
        ON "PRIMARY"
go
 
 DROP INDEX CountryCodeDomain.PK__CountryCodeDomai__489AC854
go
 
 DROP INDEX CountryCodeDomain.XAK1CountryCodeDomain
go
 
 
 ALTER TABLE CountryCodeDomain
        ADD PRIMARY KEY (CountryCode)
               ON "PRIMARY"
go
 
 
 DROP TABLE EcoCodeDomain
go
 
 CREATE TABLE EcoCodeDomain (
        EcoCode              varchar(6) NOT NULL,
        EcoCodeDescription   varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EcoCodeDomain.PK__EcoCodeDomain__4C6B5938
go
 
 
 ALTER TABLE EcoCodeDomain
        ADD PRIMARY KEY (EcoCode)
               ON "PRIMARY"
go
 
 
 DROP TABLE EngineVersions
go
 
 CREATE TABLE EngineVersions (
        VersionID            int IDENTITY,
        EngineVersion        varchar(255) NULL,
        VersionDate          datetime NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EngineVersions.PK__EngineVersions__4E53A1AA
go
 
 
 ALTER TABLE EngineVersions
        ADD PRIMARY KEY (VersionID)
               ON "PRIMARY"
go
 
 
 DROP TABLE Epd
go
 
 CREATE TABLE Epd (
        Epd                  varchar(255) NOT NULL,
        EpdID                int IDENTITY,
        HashCode             char(8) NULL,
        SideToMove           char(1) NULL,
        FlagBits             int NULL,
        CONSTRAINT Epd_XAK1Epd
        UNIQUE (
               Epd
        )
               ON "PRIMARY"
 )
        ON "PRIMARY"
go
 
 DROP INDEX Epd.PK__Epd__503BEA1C
go
 
 DROP INDEX Epd.Epd_XAK1Epd
go
 
 
 ALTER TABLE Epd
        ADD PRIMARY KEY (EpdID)
               ON "PRIMARY"
go
 
 
 DROP TABLE NagDomain
go
 
 CREATE TABLE NagDomain (
        NAG                  int NOT NULL,
        NagDescription       varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX NagDomain.PK__NagDomain__52E34C9D
go
 
 
 ALTER TABLE NagDomain
        ADD PRIMARY KEY (NAG)
               ON "PRIMARY"
go
 
 
 DROP TABLE FenPositions
go
 
 CREATE TABLE FenPositions (
        FenID                int IDENTITY,
        FenPosition          varchar(255) NOT NULL,
        CONSTRAINT XAK2FenPositionsFenPosition
        UNIQUE (
               FenPosition
        )
               ON "PRIMARY"
 )
        ON "PRIMARY"
go
 
 DROP INDEX FenPositions.PK__FenPositions__55F4C372
go
 
 DROP INDEX FenPositions.XAK2FenPositionsFenPosition
go
 
 
 ALTER TABLE FenPositions
        ADD PRIMARY KEY (FenID)
               ON "PRIMARY"
go
 
 
 DROP TABLE EpdStaging
go
 
 CREATE TABLE EpdStaging (
        Epd                  varchar(255) NOT NULL,
        acd                  smallint NULL,
        acn                  int NULL,
        ce                   smallint NULL,
        pv                   varchar(255) NULL
 )
        ON "PRIMARY"
go
 
 DROP INDEX EpdStaging.PK__EpdStaging__5224328E
go
 
 
 ALTER TABLE EpdStaging
        ADD PRIMARY KEY (Epd)
               ON "PRIMARY"
go
 
 
 ALTER TABLE MiscellaneousSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE OpeningSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE PlayerSupplementalTag
        ADD FOREIGN KEY (WhiteCountry)
                              REFERENCES CountryCodeDomain
go
 
 
 ALTER TABLE PlayerSupplementalTag
        ADD FOREIGN KEY (BlackCountry)
                              REFERENCES CountryCodeDomain
go
 
 
 ALTER TABLE PlayerSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE TimeControlSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE Nags
        ADD FOREIGN KEY (NAG)
                              REFERENCES NagDomain
go
 
 
 ALTER TABLE Nags
        ADD FOREIGN KEY (GameID, MoveNumberIndication, SanMoveWhite, 
               SanMoveBlack)
                              REFERENCES Movetext
go
 
 
 ALTER TABLE Rav
        ADD FOREIGN KEY (GameID, MoveNumberIndication, SanMoveWhite, 
               SanMoveBlack)
                              REFERENCES Movetext
go
 
 
 ALTER TABLE Movetext
        ADD CONSTRAINT R_42
               FOREIGN KEY (FenIDBlack)
                              REFERENCES FenPositions
go
 
 
 ALTER TABLE Movetext
        ADD CONSTRAINT R_41
               FOREIGN KEY (FenIDWhite)
                              REFERENCES FenPositions
go
 
 
 ALTER TABLE Movetext
        ADD CONSTRAINT wtm_movetext_creates
               FOREIGN KEY (SanMoveWhiteEpdID)
                              REFERENCES Epd
go
 
 
 ALTER TABLE Movetext
        ADD CONSTRAINT btm_movetext_crreates
               FOREIGN KEY (SanMoveBlackEpdID)
                              REFERENCES Epd
go
 
 
 ALTER TABLE Movetext
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE AlternateOpeningClassificationSupplementalTag
        ADD FOREIGN KEY (EcoCode)
                              REFERENCES EcoCodeDomain
go
 
 
 ALTER TABLE AlternateOpeningClassificationSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE AlternateStartingPositionsSupplementalTag
        ADD FOREIGN KEY (FenID)
                              REFERENCES FenPositions
go
 
 
 ALTER TABLE AlternateStartingPositionsSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE DateTimeSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE EventSupplementalTag
        ADD FOREIGN KEY (GameID)
                              REFERENCES PgnGameTag
go
 
 
 ALTER TABLE PgnGameTag
        ADD CONSTRAINT R_48
               FOREIGN KEY (WhitePlayerID)
                              REFERENCES AnyPlayer
go
 
 
 ALTER TABLE PgnGameTag
        ADD CONSTRAINT R_47
               FOREIGN KEY (BlackPlayerID)
                              REFERENCES AnyPlayer
go
 
 
 ALTER TABLE EnginePlayer
        ADD CONSTRAINT R_46
               FOREIGN KEY (EnginePlayerID)
                              REFERENCES AnyPlayer
go
 
 
 ALTER TABLE EnginePlayer
        ADD CONSTRAINT R_44
               FOREIGN KEY (ComputerID)
                              REFERENCES Computer
go
 
 
 ALTER TABLE EnginePlayer
        ADD CONSTRAINT R_43
               FOREIGN KEY (EngineID, VersionID)
                              REFERENCES Engines
go
 
 
 ALTER TABLE Players
        ADD CONSTRAINT R_49
               FOREIGN KEY (CountryCode)
                              REFERENCES CountryCodeDomain
go
 
 
 ALTER TABLE Players
        ADD CONSTRAINT R_45
               FOREIGN KEY (HumanPlayerID)
                              REFERENCES AnyPlayer
go
 
 
 ALTER TABLE PositionStatistics
        ADD FOREIGN KEY (EpdID)
                              REFERENCES Epd
go
 
 
 ALTER TABLE EngineEvaluation
        ADD FOREIGN KEY (EngineID, VersionID)
                              REFERENCES Engines
go
 
 
 ALTER TABLE EngineEvaluation
        ADD FOREIGN KEY (EpdID)
                              REFERENCES Epd
go
 
 
 ALTER TABLE Engines
        ADD FOREIGN KEY (VersionID)
                              REFERENCES EngineVersions
go
 
 
 ALTER TABLE Engines
        ADD FOREIGN KEY (AuthorID)
                              REFERENCES EngineAuthors
go
 
 
 ALTER TABLE BookOpinion
        ADD FOREIGN KEY (BookCode)
                              REFERENCES ChessBooks
go
 
 
 ALTER TABLE BookOpinion
        ADD FOREIGN KEY (EpdID)
                              REFERENCES Epd
go
 
 
 ALTER TABLE BookOpinion
        ADD CONSTRAINT R_38
               FOREIGN KEY (NAG)
                              REFERENCES NagDomain
go
 
 
 ALTER TABLE EngineAuthors
        ADD FOREIGN KEY (CountryCode)
                              REFERENCES CountryCodeDomain
go
 
 
 
 
 create trigger tI_MiscellaneousSupplementalTa on MiscellaneousSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on MiscellaneousSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/16 MiscellaneousSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT MiscellaneousSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_MiscellaneousSupplementalTa on MiscellaneousSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on MiscellaneousSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/16 MiscellaneousSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE MiscellaneousSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_OpeningSupplementalTag on OpeningSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on OpeningSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/6 OpeningSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT OpeningSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_OpeningSupplementalTag on OpeningSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on OpeningSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/6 OpeningSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE OpeningSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_PlayerSupplementalTag on PlayerSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on PlayerSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/19 PlayerSupplementalTag ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(WhiteCountry)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.WhiteCountry = NULL
      from PlayerSupplementalTag,inserted
      where
        /* %JoinPKPK(PlayerSupplementalTag,inserted, = , and) */
        PlayerSupplementalTag.GameID = inserted.GameID and
        not exists (
          select * from CountryCodeDomain
          where
            /* %JoinFKPK(inserted,CountryCodeDomain, = , and) */
            inserted.WhiteCountry = CountryCodeDomain.CountryCode
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/18 PlayerSupplementalTag ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(BlackCountry)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.BlackCountry = NULL
      from PlayerSupplementalTag,inserted
      where
        /* %JoinPKPK(PlayerSupplementalTag,inserted, = , and) */
        PlayerSupplementalTag.GameID = inserted.GameID and
        not exists (
          select * from CountryCodeDomain
          where
            /* %JoinFKPK(inserted,CountryCodeDomain, = , and) */
            inserted.BlackCountry = CountryCodeDomain.CountryCode
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/4 PlayerSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT PlayerSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_PlayerSupplementalTag on PlayerSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on PlayerSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/19 PlayerSupplementalTag ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(WhiteCountry)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.WhiteCountry = NULL
      from PlayerSupplementalTag,inserted
      where
        /* %JoinPKPK(PlayerSupplementalTag,inserted, = , and) */
        PlayerSupplementalTag.GameID = inserted.GameID and 
        not exists (
          select * from CountryCodeDomain
          where
            /* %JoinFKPK(inserted,CountryCodeDomain, = , and) */
            inserted.WhiteCountry = CountryCodeDomain.CountryCode
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/18 PlayerSupplementalTag ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(BlackCountry)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.BlackCountry = NULL
      from PlayerSupplementalTag,inserted
      where
        /* %JoinPKPK(PlayerSupplementalTag,inserted, = , and) */
        PlayerSupplementalTag.GameID = inserted.GameID and 
        not exists (
          select * from CountryCodeDomain
          where
            /* %JoinFKPK(inserted,CountryCodeDomain, = , and) */
            inserted.BlackCountry = CountryCodeDomain.CountryCode
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/4 PlayerSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE PlayerSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_TimeControlSupplementalTag on TimeControlSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on TimeControlSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/9 TimeControlSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT TimeControlSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_TimeControlSupplementalTag on TimeControlSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on TimeControlSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/9 TimeControlSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE TimeControlSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Nags on Nags
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on Nags */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* NagDomain R/17 Nags ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(NAG)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,NagDomain
        where
          /* %JoinFKPK(inserted,NagDomain) */
          inserted.NAG = NagDomain.NAG
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Nags because NagDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/2 Nags ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Movetext
        where
          /* %JoinFKPK(inserted,Movetext) */
          inserted.GameID = Movetext.GameID and
          inserted.MoveNumberIndication = Movetext.MoveNumberIndication and
          inserted.SanMoveWhite = Movetext.SanMoveWhite and
          inserted.SanMoveBlack = Movetext.SanMoveBlack
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Nags because Movetext does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_Nags on Nags
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on Nags */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insSanMoveBlack varchar(8), 
           @insSanMoveWhite varchar(8), 
           @insGameID int, 
           @insMoveNumberIndication int, 
           @insNAG int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* NagDomain R/17 Nags ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(NAG)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,NagDomain
        where
          /* %JoinFKPK(inserted,NagDomain) */
          inserted.NAG = NagDomain.NAG
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Nags because NagDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/2 Nags ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Movetext
        where
          /* %JoinFKPK(inserted,Movetext) */
          inserted.GameID = Movetext.GameID and
          inserted.MoveNumberIndication = Movetext.MoveNumberIndication and
          inserted.SanMoveWhite = Movetext.SanMoveWhite and
          inserted.SanMoveBlack = Movetext.SanMoveBlack
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Nags because Movetext does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Rav on Rav
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on Rav */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/3 Rav ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Movetext
        where
          /* %JoinFKPK(inserted,Movetext) */
          inserted.GameID = Movetext.GameID and
          inserted.MoveNumberIndication = Movetext.MoveNumberIndication and
          inserted.SanMoveWhite = Movetext.SanMoveWhite and
          inserted.SanMoveBlack = Movetext.SanMoveBlack
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Rav because Movetext does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_Rav on Rav
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on Rav */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insSanMoveBlack varchar(8), 
           @insSanMoveWhite varchar(8), 
           @insGameID int, 
           @insMoveNumberIndication int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/3 Rav ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Movetext
        where
          /* %JoinFKPK(inserted,Movetext) */
          inserted.GameID = Movetext.GameID and
          inserted.MoveNumberIndication = Movetext.MoveNumberIndication and
          inserted.SanMoveWhite = Movetext.SanMoveWhite and
          inserted.SanMoveBlack = Movetext.SanMoveBlack
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Rav because Movetext does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_Movetext on Movetext
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on Movetext */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Movetext R/3 Rav ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Rav
      where
        /*  %JoinFKPK(Rav,deleted, = , and) */
        Rav.GameID = deleted.GameID and
        Rav.MoveNumberIndication = deleted.MoveNumberIndication and
        Rav.SanMoveWhite = deleted.SanMoveWhite and
        Rav.SanMoveBlack = deleted.SanMoveBlack
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE Movetext because Rav exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Movetext R/2 Nags ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Nags
      where
        /*  %JoinFKPK(Nags,deleted, = , and) */
        Nags.GameID = deleted.GameID and
        Nags.MoveNumberIndication = deleted.MoveNumberIndication and
        Nags.SanMoveWhite = deleted.SanMoveWhite and
        Nags.SanMoveBlack = deleted.SanMoveBlack
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE Movetext because Nags exists.'
      goto error
    end


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Movetext on Movetext
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on Movetext */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Epd R/38 Movetext ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(EpdID)
  begin
    update Movetext
      set
        /* %SetFK(Movetext,NULL) */
        Movetext.EpdID = NULL
      from Movetext,inserted
      where
        /* %JoinPKPK(Movetext,inserted, = , and) */
        Movetext.GameID = inserted.GameID and
        Movetext.MoveNumberIndication = inserted.MoveNumberIndication and
        Movetext.SanMoveWhite = inserted.SanMoveWhite and
        Movetext.SanMoveBlack = inserted.SanMoveBlack and
        not exists (
          select * from Epd
          where
            /* %JoinFKPK(inserted,Epd, = , and) */
            inserted.EpdID = Epd.EpdID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* FenPositions R/13 Movetext ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(FenID)
  begin
    update Movetext
      set
        /* %SetFK(Movetext,NULL) */
        Movetext.FenID = NULL
      from Movetext,inserted
      where
        /* %JoinPKPK(Movetext,inserted, = , and) */
        Movetext.GameID = inserted.GameID and
        Movetext.MoveNumberIndication = inserted.MoveNumberIndication and
        Movetext.SanMoveWhite = inserted.SanMoveWhite and
        Movetext.SanMoveBlack = inserted.SanMoveBlack and
        not exists (
          select * from FenPositions
          where
            /* %JoinFKPK(inserted,FenPositions, = , and) */
            inserted.FenID = FenPositions.FenID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/1 Movetext ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Movetext because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_Movetext on Movetext
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on Movetext */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int, 
           @insMoveNumberIndication int, 
           @insSanMoveWhite varchar(8), 
           @insSanMoveBlack varchar(8),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/3 Rav ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    if exists (
      select * from deleted,Rav
      where
        /*  %JoinFKPK(Rav,deleted, = , and) */
        Rav.GameID = deleted.GameID and
        Rav.MoveNumberIndication = deleted.MoveNumberIndication and
        Rav.SanMoveWhite = deleted.SanMoveWhite and
        Rav.SanMoveBlack = deleted.SanMoveBlack
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE Movetext because Rav exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Movetext R/2 Nags ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID) or
    update(MoveNumberIndication) or
    update(SanMoveWhite) or
    update(SanMoveBlack)
  begin
    if exists (
      select * from deleted,Nags
      where
        /*  %JoinFKPK(Nags,deleted, = , and) */
        Nags.GameID = deleted.GameID and
        Nags.MoveNumberIndication = deleted.MoveNumberIndication and
        Nags.SanMoveWhite = deleted.SanMoveWhite and
        Nags.SanMoveBlack = deleted.SanMoveBlack
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE Movetext because Nags exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Epd R/38 Movetext ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(EpdID)
  begin
    update Movetext
      set
        /* %SetFK(Movetext,NULL) */
        Movetext.EpdID = NULL
      from Movetext,inserted
      where
        /* %JoinPKPK(Movetext,inserted, = , and) */
        Movetext.GameID = inserted.GameID and
        Movetext.MoveNumberIndication = inserted.MoveNumberIndication and
        Movetext.SanMoveWhite = inserted.SanMoveWhite and
        Movetext.SanMoveBlack = inserted.SanMoveBlack and 
        not exists (
          select * from Epd
          where
            /* %JoinFKPK(inserted,Epd, = , and) */
            inserted.EpdID = Epd.EpdID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* FenPositions R/13 Movetext ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(FenID)
  begin
    update Movetext
      set
        /* %SetFK(Movetext,NULL) */
        Movetext.FenID = NULL
      from Movetext,inserted
      where
        /* %JoinPKPK(Movetext,inserted, = , and) */
        Movetext.GameID = inserted.GameID and
        Movetext.MoveNumberIndication = inserted.MoveNumberIndication and
        Movetext.SanMoveWhite = inserted.SanMoveWhite and
        Movetext.SanMoveBlack = inserted.SanMoveBlack and 
        not exists (
          select * from FenPositions
          where
            /* %JoinFKPK(inserted,FenPositions, = , and) */
            inserted.FenID = FenPositions.FenID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/1 Movetext ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Movetext because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_AlternateOpeningClassificat on AlternateOpeningClassificationSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on AlternateOpeningClassificationSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* EcoCodeDomain R/20 AlternateOpeningClassificationSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(EcoCode)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EcoCodeDomain
        where
          /* %JoinFKPK(inserted,EcoCodeDomain) */
          inserted.EcoCode = EcoCodeDomain.EcoCode
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT AlternateOpeningClassificationSupplementalTag because EcoCodeDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/7 AlternateOpeningClassificationSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT AlternateOpeningClassificationSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_AlternateOpeningClassificat on AlternateOpeningClassificationSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on AlternateOpeningClassificationSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int, 
           @insEcoCode varchar(6),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* EcoCodeDomain R/20 AlternateOpeningClassificationSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(EcoCode)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EcoCodeDomain
        where
          /* %JoinFKPK(inserted,EcoCodeDomain) */
          inserted.EcoCode = EcoCodeDomain.EcoCode
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE AlternateOpeningClassificationSupplementalTag because EcoCodeDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/7 AlternateOpeningClassificationSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE AlternateOpeningClassificationSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_AlternateStartingPositionsS on AlternateStartingPositionsSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on AlternateStartingPositionsSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* FenPositions R/15 AlternateStartingPositionsSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(FenID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,FenPositions
        where
          /* %JoinFKPK(inserted,FenPositions) */
          inserted.FenID = FenPositions.FenID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT AlternateStartingPositionsSupplementalTag because FenPositions does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/10 AlternateStartingPositionsSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT AlternateStartingPositionsSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_AlternateStartingPositionsS on AlternateStartingPositionsSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on AlternateStartingPositionsSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int, 
           @insFenID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* FenPositions R/15 AlternateStartingPositionsSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(FenID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,FenPositions
        where
          /* %JoinFKPK(inserted,FenPositions) */
          inserted.FenID = FenPositions.FenID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE AlternateStartingPositionsSupplementalTag because FenPositions does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/10 AlternateStartingPositionsSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE AlternateStartingPositionsSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_DateTimeSupplementalTag on DateTimeSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on DateTimeSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/8 DateTimeSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT DateTimeSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_DateTimeSupplementalTag on DateTimeSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on DateTimeSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/8 DateTimeSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE DateTimeSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_EventSupplementalTag on EventSupplementalTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on EventSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/5 EventSupplementalTag ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT EventSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_EventSupplementalTag on EventSupplementalTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on EventSupplementalTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/5 EventSupplementalTag ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK( or,update) */
    update(GameID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,PgnGameTag
        where
          /* %JoinFKPK(inserted,PgnGameTag) */
          inserted.GameID = PgnGameTag.GameID
    /* %NotnullFK(inserted, is null,select @nullcnt = count(*) from inserted where, and) */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE EventSupplementalTag because PgnGameTag does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_PgnGameTag on PgnGameTag
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on PgnGameTag */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/16 MiscellaneousSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,MiscellaneousSupplementalTag
      where
        /*  %JoinFKPK(MiscellaneousSupplementalTag,deleted, = , and) */
        MiscellaneousSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because MiscellaneousSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/10 AlternateStartingPositionsSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,AlternateStartingPositionsSupplementalTag
      where
        /*  %JoinFKPK(AlternateStartingPositionsSupplementalTag,deleted, = , and) */
        AlternateStartingPositionsSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because AlternateStartingPositionsSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/9 TimeControlSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,TimeControlSupplementalTag
      where
        /*  %JoinFKPK(TimeControlSupplementalTag,deleted, = , and) */
        TimeControlSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because TimeControlSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/8 DateTimeSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,DateTimeSupplementalTag
      where
        /*  %JoinFKPK(DateTimeSupplementalTag,deleted, = , and) */
        DateTimeSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because DateTimeSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/7 AlternateOpeningClassificationSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,AlternateOpeningClassificationSupplementalTag
      where
        /*  %JoinFKPK(AlternateOpeningClassificationSupplementalTag,deleted, = , and) */
        AlternateOpeningClassificationSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because AlternateOpeningClassificationSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/6 OpeningSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,OpeningSupplementalTag
      where
        /*  %JoinFKPK(OpeningSupplementalTag,deleted, = , and) */
        OpeningSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because OpeningSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/5 EventSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,EventSupplementalTag
      where
        /*  %JoinFKPK(EventSupplementalTag,deleted, = , and) */
        EventSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because EventSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/4 PlayerSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,PlayerSupplementalTag
      where
        /*  %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because PlayerSupplementalTag exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* PgnGameTag R/1 Movetext ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Movetext
      where
        /*  %JoinFKPK(Movetext,deleted, = , and) */
        Movetext.GameID = deleted.GameID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE PgnGameTag because Movetext exists.'
      goto error
    end


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_PgnGameTag on PgnGameTag
  for INSERT
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* INSERT trigger on PgnGameTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/22 PgnGameTag ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(BlackID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.BlackID = NULL
      from PgnGameTag,inserted
      where
        /* %JoinPKPK(PgnGameTag,inserted, = , and) */
        PgnGameTag.GameID = inserted.GameID and
        not exists (
          select * from Players
          where
            /* %JoinFKPK(inserted,Players, = , and) */
            inserted.BlackID = Players.PlayerID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/21 PgnGameTag ON CHILD INSERT SET NULL */
  if
    /* %ChildFK( or,update) */
    update(WhiteID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.WhiteID = NULL
      from PgnGameTag,inserted
      where
        /* %JoinPKPK(PgnGameTag,inserted, = , and) */
        PgnGameTag.GameID = inserted.GameID and
        not exists (
          select * from Players
          where
            /* %JoinFKPK(inserted,Players, = , and) */
            inserted.WhiteID = Players.PlayerID
        )
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_PgnGameTag on PgnGameTag
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on PgnGameTag */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insGameID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/16 MiscellaneousSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,MiscellaneousSupplementalTag
      where
        /*  %JoinFKPK(MiscellaneousSupplementalTag,deleted, = , and) */
        MiscellaneousSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because MiscellaneousSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/10 AlternateStartingPositionsSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,AlternateStartingPositionsSupplementalTag
      where
        /*  %JoinFKPK(AlternateStartingPositionsSupplementalTag,deleted, = , and) */
        AlternateStartingPositionsSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because AlternateStartingPositionsSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/9 TimeControlSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,TimeControlSupplementalTag
      where
        /*  %JoinFKPK(TimeControlSupplementalTag,deleted, = , and) */
        TimeControlSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because TimeControlSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/8 DateTimeSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,DateTimeSupplementalTag
      where
        /*  %JoinFKPK(DateTimeSupplementalTag,deleted, = , and) */
        DateTimeSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because DateTimeSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/7 AlternateOpeningClassificationSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,AlternateOpeningClassificationSupplementalTag
      where
        /*  %JoinFKPK(AlternateOpeningClassificationSupplementalTag,deleted, = , and) */
        AlternateOpeningClassificationSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because AlternateOpeningClassificationSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/6 OpeningSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,OpeningSupplementalTag
      where
        /*  %JoinFKPK(OpeningSupplementalTag,deleted, = , and) */
        OpeningSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because OpeningSupplementalTag exists.'
     goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/5 EventSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,EventSupplementalTag
      where
        /*  %JoinFKPK(EventSupplementalTag,deleted, = , and) */
        EventSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because EventSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/4 PlayerSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,PlayerSupplementalTag
      where
        /*  %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because PlayerSupplementalTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* PgnGameTag R/1 Movetext ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(GameID)
  begin
    if exists (
      select * from deleted,Movetext
      where
        /*  %JoinFKPK(Movetext,deleted, = , and) */
        Movetext.GameID = deleted.GameID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE PgnGameTag because Movetext exists.'
      goto error
    end
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/22 PgnGameTag ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(BlackID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.BlackID = NULL
      from PgnGameTag,inserted
      where
        /* %JoinPKPK(PgnGameTag,inserted, = , and) */
        PgnGameTag.GameID = inserted.GameID and 
        not exists (
          select * from Players
          where
            /* %JoinFKPK(inserted,Players, = , and) */
            inserted.BlackID = Players.PlayerID
        )
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/21 PgnGameTag ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK( or,update) */
    update(WhiteID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.WhiteID = NULL
      from PgnGameTag,inserted
      where
        /* %JoinPKPK(PgnGameTag,inserted, = , and) */
        PgnGameTag.GameID = inserted.GameID and 
        not exists (
          select * from Players
          where
            /* %JoinFKPK(inserted,Players, = , and) */
            inserted.WhiteID = Players.PlayerID
        )
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_EnginePlayer on EnginePlayer for INSERT as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* INSERT trigger on EnginePlayer */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/46 EnginePlayer ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EnginePlayerID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,AnyPlayer
        where
          /* %JoinFKPK(inserted,AnyPlayer) */
          inserted.EnginePlayerID = AnyPlayer.AnyPlayerID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT EnginePlayer because AnyPlayer does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* Computer R/44 EnginePlayer ON CHILD INSERT SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(ComputerID)
  begin
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.ComputerID = NULL
      from EnginePlayer,inserted
      where
        /* %JoinPKPK(EnginePlayer,inserted," = "," and") */
        EnginePlayer.EnginePlayerID = inserted.EnginePlayerID and
        not exists (
          select * from Computer
          where
            /* %JoinFKPK(inserted,Computer," = "," and") */
            inserted.ComputerID = Computer.ComputerID
        )
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* Engines R/43 EnginePlayer ON CHILD INSERT SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(EngineID) or
    update(VersionID)
  begin
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.EngineID = NULL,
        EnginePlayer.VersionID = NULL
      from EnginePlayer,inserted
      where
        /* %JoinPKPK(EnginePlayer,inserted," = "," and") */
        EnginePlayer.EnginePlayerID = inserted.EnginePlayerID and
        not exists (
          select * from Engines
          where
            /* %JoinFKPK(inserted,Engines," = "," and") */
            inserted.EngineID = Engines.EngineID and
            inserted.VersionID = Engines.VersionID
        )
  end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_EnginePlayer on EnginePlayer for UPDATE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* UPDATE trigger on EnginePlayer */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEnginePlayerID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/46 EnginePlayer ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EnginePlayerID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,AnyPlayer
        where
          /* %JoinFKPK(inserted,AnyPlayer) */
          inserted.EnginePlayerID = AnyPlayer.AnyPlayerID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE EnginePlayer because AnyPlayer does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* Computer R/44 EnginePlayer ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(ComputerID)
  begin
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.ComputerID = NULL
      from EnginePlayer,inserted
      where
        /* %JoinPKPK(EnginePlayer,inserted," = "," and") */
        EnginePlayer.EnginePlayerID = inserted.EnginePlayerID and 
        not exists (
          select * from Computer
          where
            /* %JoinFKPK(inserted,Computer," = "," and") */
            inserted.ComputerID = Computer.ComputerID
        )
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* Engines R/43 EnginePlayer ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(EngineID) or
    update(VersionID)
  begin
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.EngineID = NULL,
        EnginePlayer.VersionID = NULL
      from EnginePlayer,inserted
      where
        /* %JoinPKPK(EnginePlayer,inserted," = "," and") */
        EnginePlayer.EnginePlayerID = inserted.EnginePlayerID and 
        not exists (
          select * from Engines
          where
            /* %JoinFKPK(inserted,Engines," = "," and") */
            inserted.EngineID = Engines.EngineID and
            inserted.VersionID = Engines.VersionID
        )
  end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_Players on Players
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on Players */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Players R/22 PgnGameTag ON PARENT DELETE SET NULL */
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.BlackID = NULL
      from PgnGameTag,deleted
      where
        /* %JoinFKPK(PgnGameTag,deleted, = , and) */
        PgnGameTag.BlackID = deleted.PlayerID

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Players R/21 PgnGameTag ON PARENT DELETE SET NULL */
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.WhiteID = NULL
      from PgnGameTag,deleted
      where
        /* %JoinFKPK(PgnGameTag,deleted, = , and) */
        PgnGameTag.WhiteID = deleted.PlayerID


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Players on Players
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 19:33:36 2003 */
/* INSERT trigger on Players */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 19:33:36 2003 */
    /* Players  PgnGameTag ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from PgnGameTag
          where
            /* %JoinFKPK(PgnGameTag,inserted," = "," and") */
            PgnGameTag.BlackID = inserted.PlayerID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Players because PgnGameTag does not.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 19:33:36 2003 */
    /* Players  PgnGameTag ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from PgnGameTag
          where
            /* %JoinFKPK(PgnGameTag,inserted," = "," and") */
            PgnGameTag.WhiteID = inserted.PlayerID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Players because PgnGameTag does not.'
      goto error
    end


  /* ERwin Builtin Fri Jun 20 19:33:36 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_Players on Players
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on Players */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insPlayerID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/22 PgnGameTag ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK( or,update) */
    update(PlayerID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.BlackID = NULL
      from PgnGameTag,deleted
      where
        /* %JoinFKPK(PgnGameTag,deleted, = , and) */
        PgnGameTag.BlackID = deleted.PlayerID
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* Players R/21 PgnGameTag ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK( or,update) */
    update(PlayerID)
  begin
    update PgnGameTag
      set
        /* %SetFK(PgnGameTag,NULL) */
        PgnGameTag.WhiteID = NULL
      from PgnGameTag,deleted
      where
        /* %JoinFKPK(PgnGameTag,deleted, = , and) */
        PgnGameTag.WhiteID = deleted.PlayerID
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_AnyPlayer on AnyPlayer for DELETE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* DELETE trigger on AnyPlayer */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* AnyPlayer R/48 PgnGameTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,PgnGameTag
      where
        /*  %JoinFKPK(PgnGameTag,deleted," = "," and") */
        PgnGameTag.WhitePlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE AnyPlayer because PgnGameTag exists.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* AnyPlayer R/47 PgnGameTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,PgnGameTag
      where
        /*  %JoinFKPK(PgnGameTag,deleted," = "," and") */
        PgnGameTag.BlackPlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE AnyPlayer because PgnGameTag exists.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* AnyPlayer R/46 EnginePlayer ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,EnginePlayer
      where
        /*  %JoinFKPK(EnginePlayer,deleted," = "," and") */
        EnginePlayer.EnginePlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE AnyPlayer because EnginePlayer exists.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* AnyPlayer R/45 Players ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Players
      where
        /*  %JoinFKPK(Players,deleted," = "," and") */
        Players.HumanPlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE AnyPlayer because Players exists.'
      goto error
    end


    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_AnyPlayer on AnyPlayer for UPDATE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* UPDATE trigger on AnyPlayer */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAnyPlayerID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/48 PgnGameTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(AnyPlayerID)
  begin
    if exists (
      select * from deleted,PgnGameTag
      where
        /*  %JoinFKPK(PgnGameTag,deleted," = "," and") */
        PgnGameTag.WhitePlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE AnyPlayer because PgnGameTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/47 PgnGameTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(AnyPlayerID)
  begin
    if exists (
      select * from deleted,PgnGameTag
      where
        /*  %JoinFKPK(PgnGameTag,deleted," = "," and") */
        PgnGameTag.BlackPlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE AnyPlayer because PgnGameTag exists.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/46 EnginePlayer ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(AnyPlayerID)
  begin
    if exists (
      select * from deleted,EnginePlayer
      where
        /*  %JoinFKPK(EnginePlayer,deleted," = "," and") */
        EnginePlayer.EnginePlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE AnyPlayer because EnginePlayer exists.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* AnyPlayer R/45 Players ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(AnyPlayerID)
  begin
    if exists (
      select * from deleted,Players
      where
        /*  %JoinFKPK(Players,deleted," = "," and") */
        Players.HumanPlayerID = deleted.AnyPlayerID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE AnyPlayer because Players exists.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_Computer on Computer for DELETE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* DELETE trigger on Computer */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* Computer R/44 EnginePlayer ON PARENT DELETE SET NULL */
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.ComputerID = NULL
      from EnginePlayer,deleted
      where
        /* %JoinFKPK(EnginePlayer,deleted," = "," and") */
        EnginePlayer.ComputerID = deleted.ComputerID


    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_Computer on Computer for UPDATE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* UPDATE trigger on Computer */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insComputerID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* Computer R/44 EnginePlayer ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK(" or",update) */
    update(ComputerID)
  begin
    update EnginePlayer
      set
        /* %SetFK(EnginePlayer,NULL) */
        EnginePlayer.ComputerID = NULL
      from EnginePlayer,deleted
      where
        /* %JoinFKPK(EnginePlayer,deleted," = "," and") */
        EnginePlayer.ComputerID = deleted.ComputerID
  end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_PositionStatistics on PositionStatistics
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* INSERT trigger on PositionStatistics */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* Epd R/43 PositionStatistics ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Epd
        where
          /* %JoinFKPK(inserted,Epd) */
          inserted.EpdID = Epd.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT PositionStatistics because Epd does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_PositionStatistics on PositionStatistics
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* UPDATE trigger on PositionStatistics */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEpdID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* Epd R/43 PositionStatistics ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Epd
        where
          /* %JoinFKPK(inserted,Epd) */
          inserted.EpdID = Epd.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE PositionStatistics because Epd does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_EngineEvaluation on EngineEvaluation
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* INSERT trigger on EngineEvaluation */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* BoardPosition R/12 EngineEvaluation ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,BoardPosition
        where
          /* %JoinFKPK(inserted,BoardPosition) */
          inserted.EpdID = BoardPosition.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT EngineEvaluation because BoardPosition does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* Engines R/8 EngineEvaluation ON CHILD INSERT SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(EngineID) or
    update(AuthorID) or
    update(VersionID)
  begin
    update EngineEvaluation
      set
        /* %SetFK(EngineEvaluation,NULL) */
        EngineEvaluation.EngineID = NULL,
        EngineEvaluation.AuthorID = NULL,
        EngineEvaluation.VersionID = NULL
      from EngineEvaluation,inserted
      where
        /* %JoinPKPK(EngineEvaluation,inserted," = "," and") */
        EngineEvaluation.EpdID = inserted.EpdID and
        not exists (
          select * from Engines
          where
            /* %JoinFKPK(inserted,Engines," = "," and") */
            inserted.EngineID = Engines.EngineID and
            inserted.AuthorID = Engines.AuthorID and
            inserted.VersionID = Engines.VersionID
        )
  end


  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_EngineEvaluation on EngineEvaluation
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* UPDATE trigger on EngineEvaluation */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEpdID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* BoardPosition R/12 EngineEvaluation ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,BoardPosition
        where
          /* %JoinFKPK(inserted,BoardPosition) */
          inserted.EpdID = BoardPosition.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE EngineEvaluation because BoardPosition does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* Engines R/8 EngineEvaluation ON CHILD UPDATE SET NULL */
  if
    /* %ChildFK(" or",update) */
    update(EngineID) or
    update(AuthorID) or
    update(VersionID)
  begin
    update EngineEvaluation
      set
        /* %SetFK(EngineEvaluation,NULL) */
        EngineEvaluation.EngineID = NULL,
        EngineEvaluation.AuthorID = NULL,
        EngineEvaluation.VersionID = NULL
      from EngineEvaluation,inserted
      where
        /* %JoinPKPK(EngineEvaluation,inserted," = "," and") */
        EngineEvaluation.EpdID = inserted.EpdID and 
        not exists (
          select * from Engines
          where
            /* %JoinFKPK(inserted,Engines," = "," and") */
            inserted.EngineID = Engines.EngineID and
            inserted.AuthorID = Engines.AuthorID and
            inserted.VersionID = Engines.VersionID
        )
  end


  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_Engines on Engines
  for DELETE
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* DELETE trigger on Engines */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
    /* Engines R/8 EngineEvaluation ON PARENT DELETE SET NULL */
    update EngineEvaluation
      set
        /* %SetFK(EngineEvaluation,NULL) */
        EngineEvaluation.EngineID = NULL,
        EngineEvaluation.AuthorID = NULL,
        EngineEvaluation.VersionID = NULL
      from EngineEvaluation,deleted
      where
        /* %JoinFKPK(EngineEvaluation,deleted," = "," and") */
        EngineEvaluation.EngineID = deleted.EngineID and
        EngineEvaluation.AuthorID = deleted.AuthorID and
        EngineEvaluation.VersionID = deleted.VersionID


    /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Engines on Engines
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* INSERT trigger on Engines */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* EngineVersions R/7 Engines ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(VersionID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EngineVersions
        where
          /* %JoinFKPK(inserted,EngineVersions) */
          inserted.VersionID = EngineVersions.VersionID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Engines because EngineVersions does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* EngineAuthors  Engines ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(AuthorID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EngineAuthors
        where
          /* %JoinFKPK(inserted,EngineAuthors) */
          inserted.AuthorID = EngineAuthors.AuthorID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT Engines because EngineAuthors does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_Engines on Engines
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* UPDATE trigger on Engines */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEngineID int, 
           @insAuthorID int, 
           @insVersionID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* Engines R/8 EngineEvaluation ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK(" or",update) */
    update(EngineID) or
    update(AuthorID) or
    update(VersionID)
  begin
    update EngineEvaluation
      set
        /* %SetFK(EngineEvaluation,NULL) */
        EngineEvaluation.EngineID = NULL,
        EngineEvaluation.AuthorID = NULL,
        EngineEvaluation.VersionID = NULL
      from EngineEvaluation,deleted
      where
        /* %JoinFKPK(EngineEvaluation,deleted," = "," and") */
        EngineEvaluation.EngineID = deleted.EngineID and
        EngineEvaluation.AuthorID = deleted.AuthorID and
        EngineEvaluation.VersionID = deleted.VersionID
  end

  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* EngineVersions R/7 Engines ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(VersionID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EngineVersions
        where
          /* %JoinFKPK(inserted,EngineVersions) */
          inserted.VersionID = EngineVersions.VersionID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Engines because EngineVersions does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  /* EngineAuthors  Engines ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(AuthorID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,EngineAuthors
        where
          /* %JoinFKPK(inserted,EngineAuthors) */
          inserted.AuthorID = EngineAuthors.AuthorID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE Engines because EngineAuthors does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_BookOpinion on BookOpinion
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* INSERT trigger on BookOpinion */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* Epd R/42 BookOpinion ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Epd
        where
          /* %JoinFKPK(inserted,Epd) */
          inserted.EpdID = Epd.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT BookOpinion because Epd does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* NagDomain R/40 BookOpinion ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(NAG)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,NagDomain
        where
          /* %JoinFKPK(inserted,NagDomain) */
          inserted.NAG = NagDomain.NAG
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT BookOpinion because NagDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* ChessBooks R/13 BookOpinion ON CHILD INSERT RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(BookCode)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,ChessBooks
        where
          /* %JoinFKPK(inserted,ChessBooks) */
          inserted.BookCode = ChessBooks.BookCode
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT BookOpinion because ChessBooks does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_BookOpinion on BookOpinion
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* UPDATE trigger on BookOpinion */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEpdID int, 
           @insBookCode char(3), 
           @insNAG varchar(20),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* Epd R/42 BookOpinion ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(EpdID)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,Epd
        where
          /* %JoinFKPK(inserted,Epd) */
          inserted.EpdID = Epd.EpdID
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE BookOpinion because Epd does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* NagDomain R/40 BookOpinion ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(NAG)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,NagDomain
        where
          /* %JoinFKPK(inserted,NagDomain) */
          inserted.NAG = NagDomain.NAG
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE BookOpinion because NagDomain does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* ChessBooks R/13 BookOpinion ON CHILD UPDATE RESTRICT */
  if
    /* %ChildFK(" or",update) */
    update(BookCode)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,ChessBooks
        where
          /* %JoinFKPK(inserted,ChessBooks) */
          inserted.BookCode = ChessBooks.BookCode
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */
    
    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE BookOpinion because ChessBooks does not exist.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_ChessBooks on ChessBooks
  for DELETE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* DELETE trigger on ChessBooks */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
    /* ChessBooks R/13 BookOpinion ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,BookOpinion
      where
        /*  %JoinFKPK(BookOpinion,deleted," = "," and") */
        BookOpinion.BookCode = deleted.BookCode
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE ChessBooks because BookOpinion exists.'
      goto error
    end


    /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_ChessBooks on ChessBooks
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 19:33:38 2003 */
/* INSERT trigger on ChessBooks */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 19:33:38 2003 */
    /* ChessBooks  BookOpinion ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from BookOpinion
          where
            /* %JoinFKPK(BookOpinion,inserted," = "," and") */
            BookOpinion.BookCode = inserted.BookCode
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT ChessBooks because BookOpinion does not.'
      goto error
    end


  /* ERwin Builtin Fri Jun 20 19:33:38 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_ChessBooks on ChessBooks
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* UPDATE trigger on ChessBooks */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insBookCode char(3),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* ChessBooks R/13 BookOpinion ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(BookCode)
  begin
    if exists (
      select * from deleted,BookOpinion
      where
        /*  %JoinFKPK(BookOpinion,deleted," = "," and") */
        BookOpinion.BookCode = deleted.BookCode
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE ChessBooks because BookOpinion exists.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_EngineAuthors on EngineAuthors
  for DELETE
  as
/* ERwin Builtin Fri Jun 20 18:26:56 2003 */
/* DELETE trigger on EngineAuthors */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
    /* EngineAuthors  Engines ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Engines
      where
        /*  %JoinFKPK(Engines,deleted," = "," and") */
        Engines.AuthorID = deleted.AuthorID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE EngineAuthors because Engines exists.'
      goto error
    end


    /* ERwin Builtin Fri Jun 20 18:26:56 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_EngineAuthors on EngineAuthors for UPDATE as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* UPDATE trigger on EngineAuthors */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAuthorID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  /* EngineAuthors  Engines ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(AuthorID)
  begin
    if exists (
      select * from deleted,Engines
      where
        /*  %JoinFKPK(Engines,deleted," = "," and") */
        Engines.AuthorID = deleted.AuthorID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE EngineAuthors because Engines exists.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_CountryCodeDomain on CountryCodeDomain
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on CountryCodeDomain */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* CountryCodeDomain R/19 PlayerSupplementalTag ON PARENT DELETE SET NULL */
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.WhiteCountry = NULL
      from PlayerSupplementalTag,deleted
      where
        /* %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.WhiteCountry = deleted.CountryCode

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* CountryCodeDomain R/18 PlayerSupplementalTag ON PARENT DELETE SET NULL */
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.BlackCountry = NULL
      from PlayerSupplementalTag,deleted
      where
        /* %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.BlackCountry = deleted.CountryCode


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_CountryCodeDomain on CountryCodeDomain
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 19:33:33 2003 */
/* INSERT trigger on CountryCodeDomain */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 19:33:33 2003 */
    /* CountryCodeDomain  PlayerSupplementalTag ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from PlayerSupplementalTag
          where
            /* %JoinFKPK(PlayerSupplementalTag,inserted," = "," and") */
            PlayerSupplementalTag.WhiteCountry = inserted.CountryCode
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT CountryCodeDomain because PlayerSupplementalTag does not.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 19:33:33 2003 */
    /* CountryCodeDomain  PlayerSupplementalTag ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from PlayerSupplementalTag
          where
            /* %JoinFKPK(PlayerSupplementalTag,inserted," = "," and") */
            PlayerSupplementalTag.BlackCountry = inserted.CountryCode
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT CountryCodeDomain because PlayerSupplementalTag does not.'
      goto error
    end


  /* ERwin Builtin Fri Jun 20 19:33:33 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_CountryCodeDomain on CountryCodeDomain
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on CountryCodeDomain */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insCountryCode varchar(3),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/19 PlayerSupplementalTag ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK( or,update) */
    update(CountryCode)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.WhiteCountry = NULL
      from PlayerSupplementalTag,deleted
      where
        /* %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.WhiteCountry = deleted.CountryCode
  end

  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* CountryCodeDomain R/18 PlayerSupplementalTag ON PARENT UPDATE SET NULL */
  if
    /* %ParentPK( or,update) */
    update(CountryCode)
  begin
    update PlayerSupplementalTag
      set
        /* %SetFK(PlayerSupplementalTag,NULL) */
        PlayerSupplementalTag.BlackCountry = NULL
      from PlayerSupplementalTag,deleted
      where
        /* %JoinFKPK(PlayerSupplementalTag,deleted, = , and) */
        PlayerSupplementalTag.BlackCountry = deleted.CountryCode
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_EcoCodeDomain on EcoCodeDomain
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on EcoCodeDomain */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* EcoCodeDomain R/20 AlternateOpeningClassificationSupplementalTag ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,AlternateOpeningClassificationSupplementalTag
      where
        /*  %JoinFKPK(AlternateOpeningClassificationSupplementalTag,deleted, = , and) */
        AlternateOpeningClassificationSupplementalTag.EcoCode = deleted.EcoCode
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE EcoCodeDomain because AlternateOpeningClassificationSupplementalTag exists.'
      goto error
    end


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_EcoCodeDomain on EcoCodeDomain
  for UPDATE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* UPDATE trigger on EcoCodeDomain */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insEcoCode varchar(6),
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  /* EcoCodeDomain R/20 AlternateOpeningClassificationSupplementalTag ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK( or,update) */
    update(EcoCode)
  begin
    if exists (
      select * from deleted,AlternateOpeningClassificationSupplementalTag
      where
        /*  %JoinFKPK(AlternateOpeningClassificationSupplementalTag,deleted, = , and) */
        AlternateOpeningClassificationSupplementalTag.EcoCode = deleted.EcoCode
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE EcoCodeDomain because AlternateOpeningClassificationSupplementalTag exists.'
      goto error
    end
  end


  /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_EcoCodeDomain on EcoCodeDomain for INSERT as
/* ERwin Builtin Fri Jun 20 23:23:01 2003 */
/* INSERT trigger on EcoCodeDomain */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
    /* EcoCodeDomain  AlternateOpeningClassificationSupplementalTag ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from AlternateOpeningClassificationSupplementalTag
          where
            /* %JoinFKPK(AlternateOpeningClassificationSupplementalTag,inserted," = "," and") */
            AlternateOpeningClassificationSupplementalTag.EcoCode = inserted.EcoCode
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT EcoCodeDomain because AlternateOpeningClassificationSupplementalTag does not.'
      goto error
    end


  /* ERwin Builtin Fri Jun 20 23:23:01 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_EngineVersions on EngineVersions
  for DELETE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* DELETE trigger on EngineVersions */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
    /* EngineVersions R/7 Engines ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,Engines
      where
        /*  %JoinFKPK(Engines,deleted," = "," and") */
        Engines.VersionID = deleted.VersionID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE EngineVersions because Engines exists.'
      goto error
    end


    /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_EngineVersions on EngineVersions
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 19:33:34 2003 */
/* INSERT trigger on EngineVersions */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 19:33:34 2003 */
    /* EngineVersions  Engines ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from Engines
          where
            /* %JoinFKPK(Engines,inserted," = "," and") */
            Engines.VersionID = inserted.VersionID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT EngineVersions because Engines does not.'
      goto error
    end


  /* ERwin Builtin Fri Jun 20 19:33:34 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tU_EngineVersions on EngineVersions
  for UPDATE
  as
/* ERwin Builtin Fri Jun 20 18:35:42 2003 */
/* UPDATE trigger on EngineVersions */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insVersionID int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  /* EngineVersions R/7 Engines ON PARENT UPDATE RESTRICT */
  if
    /* %ParentPK(" or",update) */
    update(VersionID)
  begin
    if exists (
      select * from deleted,Engines
      where
        /*  %JoinFKPK(Engines,deleted," = "," and") */
        Engines.VersionID = deleted.VersionID
    )
    begin
      select @errno  = 30005,
             @errmsg = 'Cannot UPDATE EngineVersions because Engines exists.'
      goto error
    end
  end


  /* ERwin Builtin Fri Jun 20 18:35:42 2003 */
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tD_Epd on Epd
  for DELETE
  as
/* ERwin Builtin Tue Oct 17 17:04:39 2000 */
/* DELETE trigger on Epd */
begin
  declare  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Epd R/39 AlternateEvals ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,AlternateEvals
      where
        /*  %JoinFKPK(AlternateEvals,deleted, = , and) */
        AlternateEvals.EpdID = deleted.EpdID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE Epd because AlternateEvals exists.'
      goto error
    end

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Epd R/38 Movetext ON PARENT DELETE SET NULL */
    update Movetext
      set
        /* %SetFK(Movetext,NULL) */
        Movetext.EpdID = NULL
      from Movetext,deleted
      where
        /* %JoinFKPK(Movetext,deleted, = , and) */
        Movetext.EpdID = deleted.EpdID

    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    /* Epd R/36 AnalysisSet ON PARENT DELETE RESTRICT */
    if exists (
      select * from deleted,AnalysisSet
      where
        /*  %JoinFKPK(AnalysisSet,deleted, = , and) */
        AnalysisSet.EpdID = deleted.EpdID
    )
    begin
      select @errno  = 30001,
             @errmsg = 'Cannot DELETE Epd because AnalysisSet exists.'
      goto error
    end


    /* ERwin Builtin Tue Oct 17 17:04:39 2000 */
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go


create trigger tI_Epd on Epd
  for INSERT
  as
/* ERwin Builtin Fri Jun 20 19:33:35 2003 */
/* INSERT trigger on Epd */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
    /* ERwin Builtin Fri Jun 20 19:33:35 2003 */
    /* Epd  EngineEvaluation ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from EngineEvaluation
          where
            /* %JoinFKPK(EngineEvaluation,inserted," = "," and") */
            EngineEvaluation.EpdID = inserted.EpdID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Epd because EngineEvaluation does not.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 19:33:35 2003 */
    /* Epd  BookOpinion ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from BookOpinion
          where
            /* %JoinFKPK(BookOpinion,inserted," = "," and") */
            BookOpinion.EpdID = inserted.EpdID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Epd because BookOpinion does not.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 19:33:35 2003 */
    /* Epd  Movetext ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from Movetext
          where
            /* %JoinFKPK(Movetext,inserted," = "," and") */
            Movetext.EpdID = inserted.EpdID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Epd because Movetext does not.'
      goto error
    end

    /* ERwin Builtin Fri Jun 20 19:33:35 2003 */
    /* Epd  PositionStatistics ON PARENT INSERT RESTRICT */
    if exists (select * from inserted
      where not exists (
          select * from PositionStatistics
          where
            /* %JoinFKPK(PositionStatistics,inserted," = "," and") */
            PositionStatistics.EpdID = inserted.EpdID
      )
    )
    begin
      select @errno  = 30011,
             @errmsg = 'Cannot INSERT Epd because PositionStatistics does not.'
      goto error