ISP/interface/sql/db_installer_sandbox/defs.resellers_clients.php at 8ac9a4cfb4bd0de6d82244f489f385dbac1e706c · ghzhost/ISP · GitHub

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
<?php


//*************************************************************************************
// Resellers, clients etc
//*************************************************************************************
$tables['client'] = "
`client_id` bigint(20) NOT NULL AUTO PRIMARY,
`sys_userid` int(11) NOTNULL DEFAULT '0',
`sys_groupid` int(11) NOTNULL DEFAULT '0',
`sys_perm_user` C(5),
`sys_perm_group` C(5),
`sys_perm_other` C(5),
`company_name` C(255),
`contact_name` C(255),
`street` C(255),
`zip` C(255),
`city` C(255),
`state` C(255),
`country` C(255),
`telephone` C(255),
`mobile` C(255),
`fax` C(255),
`email` C(255),
`internet` C(255) NOTNULL DEFAULT 'http://',
`icq` C(255),
`notes` text,
`default_mailserver` int(11) NOTNULL DEFAULT '1',
`limit_maildomain` int(11) NOTNULL DEFAULT '-1',
`limit_mailbox` int(11) NOTNULL DEFAULT '-1',
`limit_mailalias` int(11) NOTNULL DEFAULT '-1',
`limit_mailforward` int(11) NOTNULL DEFAULT '-1',
`limit_mailcatchall` int(11) NOTNULL DEFAULT '-1',
`limit_mailrouting` int(11) NOTNULL DEFAULT '0',
`limit_mailfilter` int(11) NOTNULL DEFAULT '-1',
`limit_fetchmail` int(11) NOTNULL DEFAULT '-1',
`limit_mailquota` int(11) NOTNULL DEFAULT '-1',
`limit_spamfilter_wblist` int(11) NOTNULL DEFAULT '0',
`limit_spamfilter_user` int(11) NOTNULL DEFAULT '0',
`limit_spamfilter_policy` int(11) NOTNULL DEFAULT '0',
`default_webserver` int(11) NOT NULL,
`limit_web_ip` text NOT NULL,
`username` C(255) ,
`password` C(255) ,
`language` C(255) NOTNULL DEFAULT 'en',
`usertheme` C(255) NOTNULL DEFAULT 'default'
";


$tables['reseller'] = "
reseller_id bigint(20) NOTNULL AUTO PRIMARY,
sys_userid I NOTNULL DEFAULT '0',
sys_groupid I NOTNULL DEFAULT '0',
sys_perm_user C(5) NOTNULL DEFAULT '',
sys_perm_group C(5) NOTNULL DEFAULT '',
sys_perm_other C(5) NOTNULL DEFAULT '',
company C(255) NOTNULL DEFAULT '',
title C(255) NOTNULL DEFAULT '',
firstname C(255) NOTNULL DEFAULT '',
surname C(255) NOTNULL DEFAULT '',
street C(255) NOTNULL DEFAULT '',
zip C(255) NOTNULL DEFAULT '',
city C(255) NOTNULL DEFAULT '',
country C(255) NOTNULL DEFAULT '',
telephone C(255) NOTNULL DEFAULT '',
mobile C(255) NOTNULL DEFAULT '',
fax C(255) NOTNULL DEFAULT '',
email C(255) NOTNULL DEFAULT '',
internet C(255) NOTNULL DEFAULT '',
icq C(255) NOTNULL DEFAULT '',
notes text NOTNULL,
limit_client I NOTNULL DEFAULT '-1',
limit_domain I NOTNULL DEFAULT '-1',
limit_subdomain I NOTNULL DEFAULT '-1',
limit_mailbox I NOTNULL DEFAULT '-1',
limit_mailalias I NOTNULL DEFAULT '-1',
limit_webquota I NOTNULL DEFAULT '-1',
limit_mailquota I NOTNULL DEFAULT '-1',
limit_database I NOTNULL DEFAULT '-1',
ip_address text NOTNULL
";


?>