<changeSet id="CSM-58-01062014" author="k-joseph">
		<preConditions onFail="MARK_RAN">
			<not><tableExists tableName="chartsearch_categories"/></not>
		</preConditions>
		<comment>
			Create the chartsearch_categories table
		</comment>
		<createTable tableName="chartsearch_categories">
			<column name="category_id" type="int" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" />
			</column>
			<column name="name" type="varchar(50)">
				<constraints nullable="false" />
			</column>
			<column name="description" type="varchar(255)" defaultValue="null" />
			<column name="uuid" type="char(38)">
				<constraints nullable="false" />
			</column>
		</createTable>
	</changeSet>



<changeSet id="CSM-58-120620141638" author="k-joseph">
		<preConditions onFail="MARK_RAN">
			<not><tableExists tableName="chartsearch_sub_categories"/></not>
		</preConditions>
		<comment>
			Create the chartsearch_sub_categories table
		</comment>
		<createTable tableName="chartsearch_sub_categories">
			<column name="sub_category_id" type="int" autoIncrement="true">
				<constraints primaryKey="true" nullable="false" />
			</column>
			<column name="category_id" type="int">
				<constraints nullable="false" />
			</column>
			<column name="name" type="varchar(125)">
				<constraints nullable="false" />
			</column>
			<column name="description" type="varchar(255)" defaultValue="null" />
			<column name="uuid" type="char(38)">
				<constraints nullable="false" />
			</column>
		</createTable>
			<addForeignKeyConstraint constraintName="category_sub_category_fk"
			baseTableName="chartsearch_sub_categories" baseColumnNames="category_id"
			referencedTableName="chartsearch_categories" referencedColumnNames="category_id"/>
	</changeSet>