Skip to content

Instantly share code, notes, and snippets.

@gsherman
Last active December 9, 2017 02:34
Show Gist options
  • Save gsherman/c880e6f493e39b5b8df5309b37919063 to your computer and use it in GitHub Desktop.
Save gsherman/c880e6f493e39b5b8df5309b37919063 to your computer and use it in GitHub Desktop.
schemascript for zipcode table
<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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment