|
To use, simply include the liquibase-vertica-<version>.jar file in your classpath.
All tags strive to be as close as possible to the product documentation.
Creates a table. this supports the additional properties such as segmentation, ksafe etc.
Creates a table projection.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:vert="http://www.liquibase.org/xml/ns/dbchangelog-ext/vert"
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.1.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext/vert
../liquibase/ext/vertica/xml/dbchangelog-ext.xsd">
<changeSet author="jony" id="1">
<vert:createTable tableName="t7">
<column name="id" type="INT">
<constraints primaryKey="true" primaryKeyName="C_PRIMARY"/>
</column>
<column name="i1" type="INT">
<constraints nullable="false"/>
</column>
<column name="i2" type="INT"/>
</vert:createTable>
</changeSet>
<changeSet author="jony" id="2">
<vert:createProjection nodes="ALL NODES" orderby="id" projectionName="t7_super" schemaName="bla" segmentedby="hash(t7.id)" subquery="Select * from t7" ksafe="">
<vert:columnv encoding="AUTO" name="id" type="INT"/>
<vert:columnv encoding="AUTO" name="i1" type="INT"/>
<vert:columnv encoding="AUTO" name="i2" type="INT"/>
</vert:createProjection>
</changeSet>
</databaseChangeLog> |
April 01, 2014 | 1.1 - Initial release |