<?xml version="1.0" encoding="UTF-8"?>
    <!-- @AutoRun -->

    <OBJECTS name="" xmlns:oneit="http://www.1iT.com.au"><NODE name="Script" factory="Vector">

        <NODE name="DDL" factory="Participant" class="oneit.sql.transfer.DefineTableOperation">
			<tableName factory="String">tl_job</tableName>
			<column name="object_id" type="Long" nullable="false" length="11"/>
			<column name="object_last_updated_date" type="Date" nullable="false" length="22"/>
			<column name="object_created_date" type="Date" nullable="false" length="22"/>
			<column name="job_title" type="String" nullable="false" length="60"/>
			<column name="job_description" type="CLOB" nullable="false"/>
			<column name="job_status" type="String" nullable="false" length="200"/>
			<column name="open_date" type="Date" nullable="true"/>
			<column name="apply_by" type="Date" nullable="true"/>
			<column name="include_assessment_criteria" type="Boolean" nullable="false"/>
			<column name="include_culture" type="Boolean" nullable="false"/>
			<column name="assessment_type" type="String" nullable="false" length="200"/>
			<column name="random_key" type="String" nullable="true" length="10"/>
			<column name="job_type" type="String" nullable="false" length="200"/>
			<column name="ref_number" type="String" nullable="true" length="10"/>
			<column name="last_status_change_date" type="Date" nullable="true"/>
			<column name="remote" type="Boolean" nullable="true"/>
			<column name="city" type="String" nullable="true" length="100"/>
			<column name="postcode" type="String" nullable="true" length="100"/>
			<column name="location_radius" type="String" nullable="false" length="200"/>
			<column name="state" type="String" nullable="true" length="200"/>
			<column name="country" type="String" nullable="true" length="200"/>
			<column name="require_cv" type="Boolean" nullable="true"/>
			<column name="manually_closed" type="Boolean" nullable="true"/>
			<column name="last_edited" type="Date" nullable="true"/>
			<column name="is_ppj" type="Boolean" nullable="true"/>
			<column name="industry" type="String" nullable="false" length="200"/>
			<column name="culture_statement" type="String" nullable="true" length="2000"/>
			<column name="draft_location" type="String" nullable="true" length="200"/>
			<column name="google_address_text" type="String" nullable="false" length="300"/>
			<column name="diversity_included" type="Boolean" nullable="true"/>
			<column name="level_id" type="Long" length="11" nullable="true"/>
			<column name="client_id" type="Long" length="11" nullable="true"/>
			<column name="job_owner_id" type="Long" length="11" nullable="true"/>
			<column name="company_user_id" type="Long" length="11" nullable="true"/>
			<column name="hiring_team_id" type="Long" length="11" nullable="true"/>
			<column name="occupation_id" type="Long" length="11" nullable="false"/>
			<column name="shortened_url_id" type="Long" length="11" nullable="true"/>
			<column name="template_id" type="Long" length="11" nullable="true"/>
			<column name="job_title_id" type="Long" length="11" nullable="false"/>
			<column name="work_flow_template_id" type="Long" length="11" nullable="true"/>
			</NODE>
        
    <NODE name="INDEX" factory="Participant" class="oneit.sql.transfer.DefineIndexOperation" tableName="tl_job" indexName="idx_tl_job_client_id" isUnique="false"><column name="client_id"/></NODE>
        
    <NODE name="INDEX" factory="Participant" class="oneit.sql.transfer.DefineIndexOperation" tableName="tl_job" indexName="idx_tl_job_work_flow_template_id" isUnique="false"><column name="work_flow_template_id"/></NODE>

        </NODE></OBJECTS>