<?xml version="1.0" encoding="utf-8" ?>

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.0.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

    <preConditions>
        <runningAs username="liquibase"/>
    </preConditions>

    <changeSet id="1" author="user">
        <createTable tableName="Users_2">
            <column name="Id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="Name" type="nvarchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="Email" type="nvarchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="Password" type="nvarchar(50)">
                <constraints nullable="false"/>
            </column>
            <column name="EmailConfirmed" type="bit">
                <constraints nullable="false"/>
            </column>
            <column name="Subscriptions" type="nvarchar(max)">
                <constraints nullable="true"/>
            </column>
            <column name="Keywords" type="nvarchar(50)">
                <constraints nullable="true"/>
            </column>
            <column name="GuidValidation" type="uniqueidentifier">
                <constraints nullable="false"/>
            </column>
        </createTable>
    </changeSet>
</databaseChangeLog>