Modify sample file table
<changeSet id="20170403-1907-2"
author="rovats">
<comment>1907: Physical Spec Definition: create tables</comment>
- <createTable tableName="physical_spec_defn_file"
- remarks="Stores physical spec definition files">
+ <createTable tableName="physical_spec_defn_sample_file"
+ remarks="Stores physical spec definition sample file data">
<column name="id"
type="${id.type}"
autoIncrement="true">
<constraints nullable="false"
primaryKey="true"
- primaryKeyName="physical_spec_defn_file_pkey"/>
+ primaryKeyName="phy_spec_defn_sample_file_pkey"/>
</column>
<column name="spec_defn_id"
type="${id.type}">
<constraints nullable="false"/>
</column>
- <column name="type"
- type="${enum.type}">
+ <column name="name"
+ type="${name.type}">
<constraints nullable="false"/>
</column>
<column name="file_data"
- type="${blob.type}">
+ type="${clob.type}">
<constraints nullable="false"/>
</column>
</createTable>
