DBKeeperNet - Keeps Your DB Schema Up-to-date

<?xml version="1.0" encoding="utf-8" ?>
<upd:Updates xmlns:upd="http://code.google.com/p/dbkeepernet/Updates-1.0.xsd"
                	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	              xsi:schemaLocation="http://code.google.com/p/dbkeepernet/Updates-1.0.xsd Updates-1.0.xsd"
                AssemblyName="DbKeeperNet.Engine">
  <DefaultPreconditions>
    <Precondition FriendlyName="Update step executed" Precondition="StepNotExecuted"/>
  </DefaultPreconditions>
  <Update Version="1.00">
    <UpdateStep xsi:type="upd:UpdateDbStepType" FriendlyName="Create table dbkeepernet_assembly" Id="1"
                MarkAsExecuted="false">
      <Preconditions>
        <Precondition FriendlyName="Table dbkeepernet_assembly not found" Precondition="DbTableNotFound">
          <Param>dbkeepernet_assembly</Param>
        </Precondition>
      </Preconditions>
      <AlternativeStatement DbType="mysql">
        CREATE TABLE dbkeepernet_assembly
        (
        id int NOT NULL AUTO_INCREMENT,
        assembly varchar(255) NOT NULL,
        created datetime not null,
        CONSTRAINT UQ_dbkeepernet_assembly UNIQUE (assembly),
        CONSTRAINT PK_dbkeepernet_assembly PRIMARY KEY (id)
        )
      </AlternativeStatement>
    </UpdateStep>
    <UpdateStep xsi:type="upd:UpdateDbStepType" FriendlyName="Create table dbkeepernet_version" Id="2"
                MarkAsExecuted="false">
      <Preconditions>
        <Precondition FriendlyName="Table dbkeepernet_version not found" Precondition="DbTableNotFound">
          <Param>dbkeepernet_version</Param>
        </Precondition>
      </Preconditions>
      <AlternativeStatement DbType="mysql">
        CREATE TABLE dbkeepernet_version
        (
        id int NOT NULL AUTO_INCREMENT,
        dbkeepernet_assembly_id int not null,
        version varchar(32) not null,
        created datetime not null,
        CONSTRAINT UQ_dbkeepernet_version UNIQUE (dbkeepernet_assembly_id, version),
        CONSTRAINT PK_dbkeepernet_version PRIMARY KEY (id),
        CONSTRAINT FK_dbknetver_dbknetasm_id FOREIGN KEY (dbkeepernet_assembly_id) REFERENCES dbkeepernet_assembly(id)
        )
      </AlternativeStatement>
    </UpdateStep>
    <UpdateStep xsi:type="upd:UpdateDbStepType" FriendlyName="Create table dbkeepernet_step" Id="3"
                MarkAsExecuted="false">
      <Preconditions>
        <Precondition FriendlyName="Table dbkeepernet_step not found" Precondition="DbTableNotFound">
          <Param>dbkeepernet_step</Param>
        </Precondition>
      </Preconditions>
      <AlternativeStatement DbType="mysql">
        CREATE TABLE dbkeepernet_step
        (
        id int NOT NULL AUTO_INCREMENT,
        dbkeepernet_version_id int not null,
        step int not null,
        created datetime not null,
        CONSTRAINT UQ_dbkeepernet_step UNIQUE (dbkeepernet_version_id, step),
        CONSTRAINT PK_dbkeepernet_step PRIMARY KEY (id),
        CONSTRAINT FK_dbknetstep_dbknetver_id FOREIGN KEY (dbkeepernet_version_id) REFERENCES dbkeepernet_version(id)
        )
      </AlternativeStatement>
    </UpdateStep>
  </Update>
</upd:Updates>