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>

		<sql>
			INSERT INTO contact (first_name, middle_initial, last_name, gender, email_address, address_1, city, state_province, postal_code, country, birthday, occupation, national_id)
			SELECT 
				givenname AS first_name, 
				middleinitial AS middle_initial, 
				surname AS last_name, 
				gender AS gender, 
				emailaddress AS email_address, 
				streetaddress AS address_1, 
				city AS city, 
				state AS state_province, 
				zipcode AS postal_code, 
				country AS country, 
				birthday AS birthday, 
				occupation AS occupation, 
				nationalid AS national_id
				FROM contact_ball_of_mud;
		</sql>