From c9c3683249490846e66190302dde04ab8143a14d Mon Sep 17 00:00:00 2001
From: Lester Caine <lsces@lsces.co.uk>
Date: Tue, 5 Oct 2010 20:26:41 +0100
Subject: Add load process for sage .csv export files

---
 admin/schema_inc.php | 40 +++++++++++++++++++++++++++++++++++++++-
 1 file changed, 39 insertions(+), 1 deletion(-)

(limited to 'admin')

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),
-- 
cgit v1.3