Skip to content

Instantly share code, notes, and snippets.

@alena1108

alena1108/dump.xml

Created January 12, 2015 22:57
Show Gist options
  • Save alena1108/bfb960109e6ba6315ba6 to your computer and use it in GitHub Desktop.
Save alena1108/bfb960109e6ba6315ba6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dump.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
<property name="mediumtext" value="TEXT" dbms="postgresql" />
<property name="mediumtext" value="MEDIUMTEXT" />
<changeSet author="alena (generated)" id="dump1" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="load_balancer">
<column autoIncrement="true" name="id" type="BIGINT">
<constraints primaryKey="true"/>
</column>
<column name="name" type="VARCHAR(255)"/>
<column name="account_id" type="BIGINT"/>
<column name="kind" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(1024)"/>
<column name="state" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="created" type="datetime"/>
<column name="removed" type="datetime"/>
<column name="remove_time" type="datetime"/>
<column name="data" type="TEXT"/>
<column name="host_id" type="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="alena (generated)" id="dump2" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="load_balancer_lb_host_map">
<column autoIncrement="true" name="id" type="BIGINT">
<constraints primaryKey="true"/>
</column>
<column name="name" type="VARCHAR(255)"/>
<column name="account_id" type="BIGINT"/>
<column name="kind" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(1024)"/>
<column name="state" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="created" type="datetime"/>
<column name="removed" type="datetime"/>
<column name="remove_time" type="datetime"/>
<column name="data" type="TEXT"/>
<column name="weight" type="BIGINT"/>
<column name="host_id" type="BIGINT"/>
<column name="load_balancer_id" type="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="alena (generated)" id="dump3" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="load_balancer_lb_listener_map">
<column autoIncrement="true" name="id" type="BIGINT">
<constraints primaryKey="true"/>
</column>
<column name="name" type="VARCHAR(255)"/>
<column name="account_id" type="BIGINT"/>
<column name="kind" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(1024)"/>
<column name="state" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="created" type="datetime"/>
<column name="removed" type="datetime"/>
<column name="remove_time" type="datetime"/>
<column name="data" type="TEXT"/>
<column name="load_balancer_id" type="BIGINT"/>
<column name="load_balancer_listener_id" type="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="alena (generated)" id="dump4" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="load_balancer_listener">
<column autoIncrement="true" name="id" type="BIGINT">
<constraints primaryKey="true"/>
</column>
<column name="name" type="VARCHAR(255)"/>
<column name="account_id" type="BIGINT"/>
<column name="kind" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(1024)"/>
<column name="state" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="created" type="datetime"/>
<column name="removed" type="datetime"/>
<column name="remove_time" type="datetime"/>
<column name="data" type="TEXT"/>
<column name="src_port" type="BIGINT"/>
<column name="source_protocol" type="VARCHAR(255)"/>
<column name="target_port" type="BIGINT"/>
<column name="target_protocol" type="VARCHAR(255)"/>
</createTable>
</changeSet>
<changeSet author="alena (generated)" id="dump5" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createTable tableName="load_balancer_target_map">
<column autoIncrement="true" name="id" type="BIGINT">
<constraints primaryKey="true"/>
</column>
<column name="name" type="VARCHAR(255)"/>
<column name="account_id" type="BIGINT"/>
<column name="kind" type="VARCHAR(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="description" type="VARCHAR(1024)"/>
<column name="state" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="created" type="datetime"/>
<column name="removed" type="datetime"/>
<column name="remove_time" type="datetime"/>
<column name="data" type="TEXT"/>
<column name="address" type="VARCHAR(255)"/>
<column name="instance_id" type="BIGINT"/>
</createTable>
</changeSet>
<changeSet author="alena (generated)" id="dump6" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="host_id, load_balancer_id" constraintName="idx_load_balancer_lb_host_map_host_id_lb_id" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer_lb_host_map"/>
</changeSet>
<changeSet author="alena (generated)" id="dump7" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="uuid" constraintName="idx_load_balancer_lb_host_map_uuid" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer_lb_host_map"/>
</changeSet>
<changeSet author="alena (generated)" id="dump8" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="uuid" constraintName="idx_load_balancer_lb_listener_map_uuid" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer_lb_listener_map"/>
</changeSet>
<changeSet author="alena (generated)" id="dump9" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="uuid" constraintName="idx_load_balancer_listener_uuid" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer_listener"/>
</changeSet>
<changeSet author="alena (generated)" id="dump10" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="uuid" constraintName="idx_load_balancer_target_map_uuid" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer_target_map"/>
</changeSet>
<changeSet author="alena (generated)" id="dump11" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addUniqueConstraint columnNames="uuid" constraintName="idx_load_balancer_uuid" deferrable="false" disabled="false" initiallyDeferred="false" tableName="load_balancer"/>
</changeSet>
<changeSet author="alena (generated)" id="dump12" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="account_id" baseTableName="load_balancer" constraintName="fk_load_balancer__account_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump13" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="host_id" baseTableName="load_balancer" constraintName="fk_load_balancer__host_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="host"/>
</changeSet>
<changeSet author="alena (generated)" id="dump14" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="account_id" baseTableName="load_balancer_lb_host_map" constraintName="fk_load_balancer_lb_host_map__account_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump15" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="host_id" baseTableName="load_balancer_lb_host_map" constraintName="fk_load_balancer_lb_host_map__host_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="host"/>
</changeSet>
<changeSet author="alena (generated)" id="dump16" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="load_balancer_id" baseTableName="load_balancer_lb_host_map" constraintName="fk_load_balancer_lb_host_map__load_balancer_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="load_balancer"/>
</changeSet>
<changeSet author="alena (generated)" id="dump17" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="account_id" baseTableName="load_balancer_lb_listener_map" constraintName="fk_load_balancer_lb_listener_map__account_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump18" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="load_balancer_id" baseTableName="load_balancer_lb_listener_map" constraintName="fk_load_balancer_lb_listener_map__load_balancer_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="load_balancer"/>
</changeSet>
<changeSet author="alena (generated)" id="dump19" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="load_balancer_listener_id" baseTableName="load_balancer_lb_listener_map" constraintName="fk_load_balancer_lb_listener_map__load_balancer_listener_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="load_balancer_listener"/>
</changeSet>
<changeSet author="alena (generated)" id="dump20" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="account_id" baseTableName="load_balancer_listener" constraintName="fk_load_balancer_listener__account_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump21" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="account_id" baseTableName="load_balancer_target_map" constraintName="fk_load_balancer_target_map__account_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump22" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<addForeignKeyConstraint baseColumnNames="instance_id" baseTableName="load_balancer_target_map" constraintName="fk_load_balancer_target_map__instance_id" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="id" referencedTableName="instance"/>
</changeSet>
<changeSet author="alena (generated)" id="dump23" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_host_map_name" tableName="load_balancer_lb_host_map" unique="false">
<column name="name"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump24" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_host_map_remove_time" tableName="load_balancer_lb_host_map" unique="false">
<column name="remove_time"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump25" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_host_map_removed" tableName="load_balancer_lb_host_map" unique="false">
<column name="removed"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump26" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_host_map_state" tableName="load_balancer_lb_host_map" unique="false">
<column name="state"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump27" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_listener_map_name" tableName="load_balancer_lb_listener_map" unique="false">
<column name="name"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump28" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_listener_map_remove_time" tableName="load_balancer_lb_listener_map" unique="false">
<column name="remove_time"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump29" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_listener_map_removed" tableName="load_balancer_lb_listener_map" unique="false">
<column name="removed"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump30" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_lb_listener_map_state" tableName="load_balancer_lb_listener_map" unique="false">
<column name="state"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump31" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_listener_name" tableName="load_balancer_listener" unique="false">
<column name="name"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump32" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_listener_remove_time" tableName="load_balancer_listener" unique="false">
<column name="remove_time"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump33" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_listener_removed" tableName="load_balancer_listener" unique="false">
<column name="removed"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump34" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_listener_state" tableName="load_balancer_listener" unique="false">
<column name="state"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump35" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_name" tableName="load_balancer" unique="false">
<column name="name"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump36" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_remove_time" tableName="load_balancer" unique="false">
<column name="remove_time"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump37" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_removed" tableName="load_balancer" unique="false">
<column name="removed"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump38" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_state" tableName="load_balancer" unique="false">
<column name="state"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump39" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_target_map_name" tableName="load_balancer_target_map" unique="false">
<column name="name"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump40" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_target_map_remove_time" tableName="load_balancer_target_map" unique="false">
<column name="remove_time"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump41" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_target_map_removed" tableName="load_balancer_target_map" unique="false">
<column name="removed"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump42" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<createIndex indexName="idx_load_balancer_target_map_state" tableName="load_balancer_target_map" unique="false">
<column name="state"/>
</createIndex>
</changeSet>
<changeSet author="alena (generated)" id="dump43" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<dropColumn columnName="created" tableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump44" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<dropColumn columnName="data" tableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump45" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<dropColumn columnName="description" tableName="account"/>
</changeSet>
<changeSet author="alena (generated)" id="dump46" objectQuotingStrategy="QUOTE_ALL_OBJECTS">
<dropColumn columnName="kind" tableName="account"/>
</changeSet>
</databaseChangeLog>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment