gistfile1.txt

		<createTable tableName="contact">
			<column name="id" type="bigint" autoIncrement="true">
				<constraints primaryKey="true" 
							 nullable="false" />
			</column>
			<column name="first_name" type="varchar(50)" />
			<column name="middle_initial" type="varchar(5)" />
			<column name="last_name" type="varchar(50)" />
			<column name="gender" type="varchar(50)" />
			<column name="email_address" type="varchar(100)" />
			<column name="address_1" type="varchar(50)" />
			<column name="city" type="varchar(50)" />
			<column name="state_province" type="varchar(50)" />
			<column name="postal_code" type="varchar(50)" />
			<column name="country" type="varchar(50)" />
			<column name="birthday" type="datetime" />
			<column name="occupation" type="varchar(50)" />
			<column name="national_id" type="varchar(50)" />
		</createTable>
		<createTable tableName="security_info">
			<column name="id" type="bigint" autoIncrement="true">
				<constraints primaryKey="true" 
							 nullable="false" />
			</column>
			<column name="password" type="varchar(50)" />
			<column name="mothers-maiden-name" type="varchar(50)" />
		</createTable>
		<createTable tableName="credit_card">
			<column name="id" type="bigint" autoIncrement="true">
				<constraints primaryKey="true" 
							 nullable="false" />
			</column>
			<column name="contact_id" type="bigint" />
			<column name="card_type" type="varchar(15)" />
			<column name="card_number" type="varchar(25)" />
			<column name="expiration" type="datetime" />
			<column name="cvv" type="varchar(3)" />
		</createTable>