<?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>