diff options
| author | Lester Caine <lsces@lsces.co.uk> | 2010-10-05 20:26:41 +0100 |
|---|---|---|
| committer | Lester Caine <lsces@lsces.co.uk> | 2010-10-05 20:26:41 +0100 |
| commit | c9c3683249490846e66190302dde04ab8143a14d (patch) | |
| tree | 9195abfe4b9a16a2b16c8f21a0078b585f92a0fa /admin | |
| parent | 8cf9da7f018b837304ff296f2ba93aa9c23abaee (diff) | |
| download | contact-c9c3683249490846e66190302dde04ab8143a14d.tar.gz contact-c9c3683249490846e66190302dde04ab8143a14d.tar.bz2 contact-c9c3683249490846e66190302dde04ab8143a14d.zip | |
Add load process for sage .csv export files
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 40 |
1 files changed, 39 insertions, 1 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 0b948f3..0e076f7 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -1,7 +1,16 @@ <?php $tables = array( -'contact' => " +'contact_phx' => " + contact_id I8 PRIMARY, + usn I8 NOTNULL, + parent_id I8, + organisation C(100), + last_update_date T DEFAULT CURRENT_TIMESTAMP, + start_date T DEFAULT CURRENT_TIMESTAMP, +", + +'contact_phx' => " contact_id I8 PRIMARY, usn I8 NOTNULL, parent_id I8, @@ -36,6 +45,35 @@ $tables = array( full_start_date C(24) ", +'contact_sage' => " + contact_id I8 PRIMARY, + usn C(16) NOTNULL, + cltype I4, + prefix C(35), + forename C(128), + surname C(128), + suffix C(35), + organisation C(100), + contact_name C(64), + telephone C(16), + fax C(32), + web C(32), + analysis_1 C(16), + analysis_2 C(16), + analysis_3 C(16), + dept_number C(8), + vat_reg_number C(16), + turnover_mtd C(16), + turnover_ytd C(16), + turnover_prior C(16), + credit_limit C(16), + terms C(32), + settlement_due_days C(32), + settlement_disc_rate C(32), + def_nom_code C(32), + def_tax_code C(32) +", + 'contact_xref' => " contact_id I8 NOTNULL, xref_key C(14), |