#!/bin/sh
# MySQL Import Script
# db21.pair.com routt_routt.IssuePermits
# db21.pair.com routt_routt.AllContractors

##
# import issued permits for the building dept.
##
/usr/local/bin/mysqlimport --local -d  -s --fields-optionally-enclosed-by=\" --host=db21.pair.com --user=routt_w --password=7F7e4XAd --port=3306 routt_routt /usr/home/routt/permits/IssuePermits.txt

##
# import all contractors for the building dept.
##
/usr/local/bin/mysqlimport --local -d  -s --fields-optionally-enclosed-by=\" --host=db21.pair.com --user=routt_w --password=7F7e4XAd --port=3306 routt_routt /usr/home/routt/permits/AllContractors.txt

##
# import all activities for the planning dept.
##
/usr/local/bin/mysqlimport --local -d  -s --fields-optionally-enclosed-by=\" --host=db21.pair.com --user=routt_w --password=7F7e4XAd --port=3306 routt_routt /usr/home/routt/permits/P_All_APD_Web.txt

##
# import current for the planning dept.
##
/usr/local/bin/mysqlimport --local -d  -s --fields-optionally-enclosed-by=\" --host=db21.pair.com --user=routt_w --password=7F7e4XAd --port=3306 routt_routt /usr/home/routt/permits/P_Current_APD_web.txt