<Property Id="SQLDATABASEEXISTS" Value="dummy" />

<Binary Id="CustomActions" SourceFile="..CustomActionsbin$(var.Configuration)CustomActions.CA.dll" />

<CustomAction Id="CheckDatabaseExistence" BinaryKey="CustomActions" DllEntry="CheckSqlServerExistence" Return="check" Execute="immediate" />

<InstallExecuteSequence>
    <Custom Action="CheckDatabaseExistence" Before="CostFinalize" />
</InstallExecuteSequence>

<util:User Id="SqlUser" Name="username" Password="password" />
<sql:SqlDatabase Id="SqlExistingDatabase" Database="Data_[CUSTOMER_NAME]" Instance="SQLEXPRESS" Server="." User="SqlUser" />

<Binary Id="SqlCreateScript" SourceFile="SqlCreateScript.sql" />
<Binary Id="SqlUpdateScript" SourceFile="SqlUpdateScript.sql" />

<ComponentGroup Id="DatabaseComponents">
    <Component Id="DBNewDatabase" Directory="DATA_DIR" Guid="*" KeyPath="yes">
        <Condition><![CDATA[NOT SQLDATABASEEXISTS]]></Condition>
        <sql:SqlDatabase Id="SqlNewDatabase" Database="Data_[CUSTOMER_NAME]" ConfirmOverwrite="yes" CreateOnInstall="yes" CreateOnReinstall="yes" CreateOnUninstall="no" DropOnInstall="no" DropOnReinstall="no" DropOnUninstall="no" Instance="SQLEXPRESS" Server="." User="SqlUser">
            <sql:SqlFileSpec Id="SqlDatabaseDataFile" Name="DB_Data" Filename="C:DB[CUSTOMER_NAME]DB_Data.mdf" />
            <sql:SqlLogFileSpec Id="SqlDatabaseLogFile" Name="DB_Log" Filename="C:DB[CUSTOMER_NAME]DB_Data.ldf" />
            <sql:SqlScript Id="SqlCreateScript" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" ExecuteOnUninstall="no" BinaryKey="SqlCreateScript" />
        </sql:SqlDatabase>
    </Component>
    <Component Id="DBExistingDatabase" Directory="DATA_DIR" Guid="*" KeyPath="yes">
        <Condition><![CDATA[SQLDATABASEEXISTS]]></Condition>
        <sql:SqlScript Id="SqlUpdateScript" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" ExecuteOnUninstall="no" BinaryKey="SqlUpdateScript" User="SqlUser" SqlDb="SqlExistingDatabase" />
    </Component>
</ComponentGroup>

<Condition><![CDATA[SQLDATABASEEXISTS = "false"]]></Condition>

<Condition><![CDATA[SQLDATABASEEXISTS = "true"]]></Condition>

<Custom Action="CheckDatabaseExistence" After="CostInitialize" />

<Condition><![CDATA[SQLDATABASEEXISTS = "false"]]></Condition>
<Condition><![CDATA[SQLDATABASEEXISTS = "true"]]></Condition>