schemascript for zipcode table

zipcode.schemascript.xml

<schemaScript xmlns="http://www.dovetailsoftware.com/2006/10/SchemaScript.xsd">

  <addTable name="zipcode" id="3555">
    <description>Stores zipcodes and related city, state, country, timezone info</description>
    <groupName>Customer Srvc Mgr</groupName>
  </addTable>

  <addColumn name="objid" dataType="Integer" table="zipcode" >
    <description>Internal record number</description>
    <clarifyGenericFieldID>3</clarifyGenericFieldID>
  </addColumn>
  <addColumn name="zipcode" dataType="String" table="zipcode" >
    <length>30</length>
    <description>Zipcode</description>
  </addColumn>
  <addColumn name="city" dataType="String" table="zipcode" >
    <length>30</length>
    <description>City</description>
  </addColumn>
  <addColumn name="state" dataType="String" table="zipcode" >
    <length>20</length>
    <description>State</description>
  </addColumn>
  <addColumn name="country" dataType="String" table="zipcode" >
    <length>40</length>
    <description>Country</description>
  </addColumn>
  <addColumn name="time_zone" dataType="String" table="zipcode" >
    <length>20</length>
    <description>Time zone</description>
  </addColumn>
  <addColumn name="preferred_city" dataType="String" table="zipcode" >
    <length>1</length>
    <description>Preferred City</description>
  </addColumn>
  <addColumn name="x_county" dataType="String" table="zipcode" >
    <description>County for this zipcode</description>
    <length>80</length>
  </addColumn>  
  <addColumn name="dev" dataType="Integer" table="zipcode" >
    <isNullable>true</isNullable>
    <description>Row version number for mobile distribution purposes</description>
    <clarifyGenericFieldID>151</clarifyGenericFieldID>
  </addColumn>

  <addIndex name="zip_index" columns="zipcode" table="zipcode" ></addIndex>

</schemaScript>