1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
<?php
$tables = [
'contact_phx' => "
content_id I8 PRIMARY,
contact C(10),
cltype I4,
prefix C(35),
forename C(128),
surname C(128),
spouse C(35),
organisation C(100),
note C(40),
memo X,
contact1 C(128),
contact2 C(128),
cname2 C(128),
contact3 C(128),
cname3 C(128),
key1 C(128),
tel1 C(128),
mob1 C(128),
key2 C(128),
tel2 C(128),
mob2 C(128),
key3 C(128),
tel3 C(128),
mob3 C(128),
key4 C(128),
tel4 C(128),
mob4 C(128),
passwd C(128),
prompt C(128),
email1 C(128),
email2 C(128),
full_start_date C(24),
payment C(64),
maintain C(128),
code C(128),
key_seal C(128),
break_seal C(128),
code C(128),
start_date T DEFAULT CURRENT_TIMESTAMP,
last_update_date T DEFAULT CURRENT_TIMESTAMP
",
'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_wande' => "
content_id I8 PRIMARY,
contract C(10),
username C(128),
passwd C(128),
djidnumber C(128),
forename C(128),
surname C(128),
organisation C(100),
home_phone C(128),
work_phone C(128),
mobile_phone C(128),
fax C(128),
email C(128),
website C(128),
last_time C(128),
last_date C(128),
lockout_overide C(128),
lockout_state C(128),
notes X,
customer_number C(128),
birthday C(128),
changelog X,
country C(128),
import_helper C(128),
last_change T DEFAULT CURRENT_TIMESTAMP
",
];
global $gBitInstaller;
foreach( array_keys( $tables ) AS $tableName ) {
$gBitInstaller->registerSchemaTable( CONTACT_PKG_NAME, $tableName, $tables[$tableName] );
}
?>
|
