ispconfig3.sql 62.4 KB
Newer Older
redray's avatar
redray committed
1

redray's avatar
redray committed
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
/*
Copyright (c) 2007, Till Brehm, projektfarm Gmbh
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

redray's avatar
redray committed
30
31
32
33
34
-- ISPConfig 3
-- DB-Version: 3.0.0.8

-- --------------------------------------------------------

35
-- 
redray's avatar
redray committed
36
-- Datenbank: `ispconfig_v3`
37
38
39
40
-- 

-- --------------------------------------------------------

41
-- 
tbrehm's avatar
tbrehm committed
42
-- Tabellenstruktur fr Tabelle `client`
43
44
-- 

daniel's avatar
daniel committed
45
46
SET FOREIGN_KEY_CHECKS = 0;

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
CREATE TABLE `client` (
  `client_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `company_name` varchar(255) default NULL,
  `contact_name` varchar(255) default NULL,
  `street` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `telephone` varchar(255) default NULL,
  `mobile` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `email` varchar(255) default NULL,
redray's avatar
redray committed
65
  `internet` varchar(255) NOT NULL,
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
  `icq` varchar(255) default NULL,
  `notes` text,
  `default_mailserver` int(11) NOT NULL default '1',
  `limit_maildomain` int(11) NOT NULL default '-1',
  `limit_mailbox` int(11) NOT NULL default '-1',
  `limit_mailalias` int(11) NOT NULL default '-1',
  `limit_mailforward` int(11) NOT NULL default '-1',
  `limit_mailcatchall` int(11) NOT NULL default '-1',
  `limit_mailrouting` int(11) NOT NULL default '0',
  `limit_mailfilter` int(11) NOT NULL default '-1',
  `limit_fetchmail` int(11) NOT NULL default '-1',
  `limit_mailquota` int(11) NOT NULL default '-1',
  `limit_spamfilter_wblist` int(11) NOT NULL default '0',
  `limit_spamfilter_user` int(11) NOT NULL default '0',
  `limit_spamfilter_policy` int(11) NOT NULL default '0',
81
82
83
84
85
86
  `default_webserver` int(11) NOT NULL default '1',
  `limit_web_ip` text,
  `limit_web_domain` int(11) NOT NULL default '-1',
  `limit_web_subdomain` int(11) NOT NULL default '-1',
  `limit_web_aliasdomain` int(11) NOT NULL default '-1',
  `limit_ftp_user` int(11) NOT NULL default '-1',
tbrehm's avatar
tbrehm committed
87
  `limit_shell_user` int(11) NOT NULL default '0',
88
89
90
  `default_dnsserver` int(10) unsigned NOT NULL default '1',
  `limit_dns_zone` int(11) NOT NULL default '-1',
  `limit_dns_record` int(11) NOT NULL default '-1',
91
92
  `default_dbserver` int(10) unsigned NOT NULL default '1',
  `limit_database` int(11) NOT NULL default '-1',
93
94
  `limit_client` int(11) NOT NULL default '0',
  `parent_client_id` int(10) unsigned NOT NULL default '0',
95
96
97
98
99
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `language` varchar(255) NOT NULL default 'en',
  `usertheme` varchar(255) NOT NULL default 'default',
  PRIMARY KEY  (`client_id`)
redray's avatar
redray committed
100
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
101
102

-- 
tbrehm's avatar
tbrehm committed
103
-- Daten fr Tabelle `client`
104
105
-- 

tbrehm's avatar
tbrehm committed
106

107
108
-- --------------------------------------------------------

109
-- 
tbrehm's avatar
tbrehm committed
110
-- Tabellenstruktur fr Tabelle `dns_rr`
111
112
113
114
115
116
117
118
119
-- 

CREATE TABLE `dns_rr` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
tbrehm's avatar
tbrehm committed
120
  `server_id` int(11) NOT NULL default '1',
121
122
  `zone` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
tbrehm's avatar
tbrehm committed
123
  `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL,
124
  `data` char(128) NOT NULL,
tbrehm's avatar
tbrehm committed
125
  `aux` int(10) unsigned NOT NULL default '0',
126
  `ttl` int(10) unsigned NOT NULL default '86400',
tbrehm's avatar
tbrehm committed
127
  `active` enum('N','Y') NOT NULL default 'Y',
128
129
  PRIMARY KEY  (`id`),
  UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`)
redray's avatar
redray committed
130
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
131
132
133
134

-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
135
-- Tabellenstruktur fr Tabelle `dns_soa`
136
137
138
139
140
141
142
143
144
-- 

CREATE TABLE `dns_soa` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
tbrehm's avatar
tbrehm committed
145
  `server_id` int(11) NOT NULL default '1',
146
147
148
149
150
151
152
153
154
155
156
157
158
159
  `origin` char(255) NOT NULL,
  `ns` char(255) NOT NULL,
  `mbox` char(255) NOT NULL,
  `serial` int(10) unsigned NOT NULL default '1',
  `refresh` int(10) unsigned NOT NULL default '28800',
  `retry` int(10) unsigned NOT NULL default '7200',
  `expire` int(10) unsigned NOT NULL default '604800',
  `minimum` int(10) unsigned NOT NULL default '86400',
  `ttl` int(10) unsigned NOT NULL default '86400',
  `active` enum('Y','N') NOT NULL,
  `xfer` char(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `origin` (`origin`),
  KEY `active` (`active`)
redray's avatar
redray committed
160
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
161

tbrehm's avatar
tbrehm committed
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `dns_template`
-- 

CREATE TABLE `dns_template` (
  `template_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `name` varchar(255) default NULL,
  `fields` varchar(255) default NULL,
  `template` text,
  `visible` varchar(255) NOT NULL default 'Y',
  PRIMARY KEY  (`template_id`)
redray's avatar
redray committed
180
) ENGINE=MyISAM AUTO_INCREMENT=3 ;
tbrehm's avatar
tbrehm committed
181
182
183
184
185
186
187
188

-- 
-- Daten fr Tabelle `dns_template`
-- 

INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Default', 'DOMAIN,IP,NS1,NS2,EMAIL', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=28800\nretry=7200\nexpire=604800\nminimum=86400\nttl=86400\n\n[DNS_RECORDS]\nA|{DOMAIN}.|{IP}|0|86400\nA|www|{IP}|0|86400\nA|mail|{IP}|0|86400\nNS|{DOMAIN}.|{NS1}.|0|86400\nNS|{DOMAIN}.|{NS2}.|0|86400\nMX|{DOMAIN}.|mail.{DOMAIN}.|10|86400', 'y');


189
190


tbrehm's avatar
tbrehm committed
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `firewall`
-- 

CREATE TABLE `firewall` (
  `firewall_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(11) NOT NULL default '0',
  `tcp_port` varchar(255) default NULL,
  `udp_port` varchar(255) default NULL,
  `active` varchar(255) NOT NULL default 'y',
  PRIMARY KEY  (`firewall_id`)
redray's avatar
redray committed
209
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
tbrehm's avatar
tbrehm committed
210
211
212
213
214
215

-- 
-- Daten fr Tabelle `firewall`



tbrehm's avatar
tbrehm committed
216
217
218
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
219
-- Tabellenstruktur fr Tabelle `ftp_user`
tbrehm's avatar
tbrehm committed
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
-- 

CREATE TABLE `ftp_user` (
  `ftp_user_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(11) NOT NULL default '0',
  `parent_domain_id` int(11) NOT NULL default '0',
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `quota_size` int(11) NOT NULL default '-1',
  `active` varchar(255) NOT NULL default 'y',
tbrehm's avatar
tbrehm committed
235
236
  `uid` varchar(255) default NULL,
  `gid` varchar(255) default NULL,
tbrehm's avatar
tbrehm committed
237
238
239
240
241
242
  `dir` varchar(255) default NULL,
  `quota_files` int(11) NOT NULL default '-1',
  `ul_ratio` int(11) NOT NULL default '-1',
  `dl_ratio` int(11) NOT NULL default '-1',
  `ul_bandwidth` int(11) NOT NULL default '-1',
  `dl_bandwidth` int(11) NOT NULL default '-1',
daniel's avatar
daniel committed
243
244
245
246
247
  PRIMARY KEY  (`ftp_user_id`),
  KEY `active` (`active`),
  KEY `server_id` (`server_id`),
  KEY `username` (`username`),
  KEY `quota_files` (`quota_files`)
redray's avatar
redray committed
248
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
tbrehm's avatar
tbrehm committed
249
250

-- 
tbrehm's avatar
tbrehm committed
251
-- Daten fr Tabelle `ftp_user`
tbrehm's avatar
tbrehm committed
252
253
254
-- 


255
256
257
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
258
-- Tabellenstruktur fr Tabelle `mail_access`
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
-- 

CREATE TABLE `mail_access` (
  `access_id` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_id` int(11) NOT NULL default '0',
  `source` varchar(255) NOT NULL,
  `access` varchar(255) NOT NULL,
  `type` set('recipient','sender','client') NOT NULL,
  `active` enum('n','y') NOT NULL default 'y',
  PRIMARY KEY  (`access_id`),
  KEY `server_id` (`server_id`,`source`)
redray's avatar
redray committed
275
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
276
277

-- 
tbrehm's avatar
tbrehm committed
278
-- Daten fr Tabelle `mail_access`
279
-- 
tbrehm's avatar
tbrehm committed
280
281


282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `mail_content_filter`
-- 

CREATE TABLE `mail_content_filter` (
  `content_filter_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(11) NOT NULL default '0',
  `type` varchar(255) default NULL,
  `pattern` varchar(255) default NULL,
  `data` varchar(255) default NULL,
  `action` varchar(255) default NULL,
  `active` varchar(255) NOT NULL default 'y',
  PRIMARY KEY  (`content_filter_id`)
redray's avatar
redray committed
302
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
303

304
305
306
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
307
-- Tabellenstruktur fr Tabelle `mail_domain`
308
309
310
311
312
313
314
315
316
317
318
319
320
-- 

CREATE TABLE `mail_domain` (
  `domain_id` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_id` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `active` enum('y','n') NOT NULL,
  PRIMARY KEY  (`domain_id`),
321
322
  KEY `server_id` (`server_id`,`domain`),
  KEY `domain_active` (`domain`,`active`)
redray's avatar
redray committed
323
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
324
325

-- 
tbrehm's avatar
tbrehm committed
326
-- Daten fr Tabelle `mail_domain`
327
328
-- 

tbrehm's avatar
tbrehm committed
329

330
331
332
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
333
-- Tabellenstruktur fr Tabelle `mail_forwarding`
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
-- 

CREATE TABLE `mail_forwarding` (
  `forwarding_id` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_id` int(11) NOT NULL default '0',
  `source` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL default '',
  `type` enum('alias','forward','catchall') NOT NULL default 'alias',
  `active` enum('y','n') NOT NULL,
  PRIMARY KEY  (`forwarding_id`),
  KEY `server_id` (`server_id`,`source`)
redray's avatar
redray committed
350
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
351
352

-- 
tbrehm's avatar
tbrehm committed
353
-- Daten fr Tabelle `mail_forwarding`
354
355
-- 

tbrehm's avatar
tbrehm committed
356

357
358
-- --------------------------------------------------------

tbrehm's avatar
tbrehm committed
359
-- 
tbrehm's avatar
tbrehm committed
360
-- Tabellenstruktur fr Tabelle `mail_get`
tbrehm's avatar
tbrehm committed
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
-- 

CREATE TABLE `mail_get` (
  `mailget_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(11) NOT NULL default '0',
  `type` varchar(255) default NULL,
  `source_server` varchar(255) default NULL,
  `source_username` varchar(255) default NULL,
  `source_password` varchar(255) default NULL,
  `source_delete` varchar(255) NOT NULL default 'y',
  `destination` varchar(255) default NULL,
  `active` varchar(255) NOT NULL default 'y',
  PRIMARY KEY  (`mailget_id`)
redray's avatar
redray committed
379
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
tbrehm's avatar
tbrehm committed
380
381

-- 
tbrehm's avatar
tbrehm committed
382
-- Daten fr Tabelle `mail_get`
tbrehm's avatar
tbrehm committed
383
384
-- 

tbrehm's avatar
tbrehm committed
385

tbrehm's avatar
tbrehm committed
386
387
-- --------------------------------------------------------

388
-- 
tbrehm's avatar
tbrehm committed
389
-- Tabellenstruktur fr Tabelle `mail_greylist`
390
391
392
393
394
395
396
397
398
399
400
-- 

CREATE TABLE `mail_greylist` (
  `greylist_id` int(11) NOT NULL auto_increment,
  `relay_ip` varchar(64) default NULL,
  `from_domain` varchar(255) default NULL,
  `block_expires` datetime NOT NULL default '0000-00-00 00:00:00',
  `record_expires` datetime NOT NULL default '0000-00-00 00:00:00',
  `origin_type` enum('MANUAL','AUTO') NOT NULL default 'AUTO',
  `create_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`greylist_id`)
redray's avatar
redray committed
401
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
402
403

-- 
tbrehm's avatar
tbrehm committed
404
-- Daten fr Tabelle `mail_greylist`
405
406
407
408
409
410
-- 


-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
411
-- Tabellenstruktur fr Tabelle `mail_mailman_domain`
412
413
414
415
416
417
418
419
420
421
422
-- 

CREATE TABLE `mail_mailman_domain` (
  `mailman_id` int(11) NOT NULL auto_increment,
  `server_id` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `mm_home` varchar(255) NOT NULL default '',
  `mm_wrap` varchar(255) NOT NULL default '',
  `mm_user` varchar(50) NOT NULL default '',
  `mm_group` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`mailman_id`,`server_id`,`domain`)
redray's avatar
redray committed
423
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
424
425

-- 
tbrehm's avatar
tbrehm committed
426
-- Daten fr Tabelle `mail_mailman_domain`
427
428
-- 

429
430
431
432
433
434
435
436
437
438
439
440
441
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `mail_traffic`
-- 

CREATE TABLE `mail_traffic` (
  `traffic_id` int(10) unsigned NOT NULL auto_increment,
  `mailuser_id` int(10) unsigned NOT NULL,
  `month` char(7) NOT NULL,
  `traffic` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`traffic_id`),
  KEY `mailuser_id` (`mailuser_id`,`month`)
redray's avatar
redray committed
442
) ENGINE=MyISAM AUTO_INCREMENT=2 ;
443
444
445
446
447

-- 
-- Daten fr Tabelle `mail_traffic`
-- 

448
449
450
451

-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
452
-- Tabellenstruktur fr Tabelle `mail_transport`
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
-- 

CREATE TABLE `mail_transport` (
  `transport_id` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_id` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `transport` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL default '5',
  `active` enum('y','n') NOT NULL,
  PRIMARY KEY  (`transport_id`),
  KEY `server_id` (`server_id`,`transport`),
  KEY `server_id_2` (`server_id`,`domain`)
redray's avatar
redray committed
470
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
471
472

-- 
tbrehm's avatar
tbrehm committed
473
-- Daten fr Tabelle `mail_transport`
474
-- 
tbrehm's avatar
tbrehm committed
475
476


477
478
479
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
480
-- Tabellenstruktur fr Tabelle `mail_user`
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
-- 

CREATE TABLE `mail_user` (
  `mailuser_id` int(11) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_id` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL,
  `name` varchar(128) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '5000',
  `gid` int(10) unsigned NOT NULL default '5000',
  `maildir` varchar(255) NOT NULL default '',
497
  `quota` int(11) NOT NULL default '0',
498
499
  `homedir` varchar(255) NOT NULL,
  `autoresponder` enum('n','y') NOT NULL default 'n',
500
  `autoresponder_text` tinytext NULL,
tbrehm's avatar
tbrehm committed
501
  `custom_mailfilter` text,
502
503
  `postfix` enum('y','n') NOT NULL,
  `access` enum('y','n') NOT NULL,
504
505
  `disableimap` enum('0','1') NOT NULL default '0',
  `disablepop3` enum('0','1') NOT NULL default '0',
506
  PRIMARY KEY  (`mailuser_id`),
507
508
  KEY `server_id` (`server_id`,`email`),
  KEY `email_access` (`email`,`access`)
redray's avatar
redray committed
509
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
510
511

-- 
tbrehm's avatar
tbrehm committed
512
-- Daten fr Tabelle `mail_user`
513
514
-- 

tbrehm's avatar
tbrehm committed
515

516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `mail_user_filter`
-- 

CREATE TABLE `mail_user_filter` (
  `filter_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `mailuser_id` int(11) NOT NULL default '0',
  `rulename` varchar(255) default NULL,
  `source` varchar(255) default NULL,
  `searchterm` varchar(255) default NULL,
  `op` varchar(255) default NULL,
  `action` varchar(255) default NULL,
  `target` varchar(255) default NULL,
  `active` varchar(255) NOT NULL default 'y',
  PRIMARY KEY  (`filter_id`)
redray's avatar
redray committed
538
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
539

540
541
542
543
544
545
546
547
548
549
550
551
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `remote_session`
-- 

CREATE TABLE `remote_session` (
  `remote_session` varchar(50) NOT NULL,
  `remote_userid` int(11) NOT NULL,
  `remote_functions` text NOT NULL,
  `tstamp` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`remote_session`)
redray's avatar
redray committed
552
) ENGINE=MyISAM;
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570

-- 
-- Daten fr Tabelle `remote_session`
-- 


-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `remote_user`
-- 

CREATE TABLE `remote_user` (
  `remote_userid` int(11) NOT NULL auto_increment,
  `remote_username` varchar(255) NOT NULL,
  `remote_password` varchar(255) NOT NULL,
  `remote_functions` text NOT NULL,
  PRIMARY KEY  (`remote_userid`)
redray's avatar
redray committed
571
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
572
573
574
575
576
577
578
579

-- 
-- Daten fr Tabelle `remote_user`
-- 




580
581
582
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
583
-- Tabellenstruktur fr Tabelle `server`
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
-- 

CREATE TABLE `server` (
  `server_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) NOT NULL default '',
  `sys_perm_group` varchar(5) NOT NULL default '',
  `sys_perm_other` varchar(5) NOT NULL default '',
  `server_name` varchar(255) NOT NULL default '',
  `mail_server` tinyint(4) NOT NULL default '0',
  `web_server` tinyint(4) NOT NULL default '0',
  `dns_server` tinyint(4) NOT NULL default '0',
  `file_server` tinyint(4) NOT NULL default '0',
  `db_server` tinyint(4) NOT NULL default '0',
  `vserver_server` tinyint(4) NOT NULL default '0',
  `config` text NOT NULL,
  `updated` tinyint(4) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`server_id`)
redray's avatar
redray committed
604
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
605
606

-- 
tbrehm's avatar
tbrehm committed
607
-- Daten fr Tabelle `server`
608
609
-- 

tbrehm's avatar
tbrehm committed
610
611
612
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
613
-- Tabellenstruktur fr Tabelle `server_ip`
tbrehm's avatar
tbrehm committed
614
615
616
617
618
619
620
621
622
623
624
625
626
-- 

CREATE TABLE `server_ip` (
  `server_ip_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(10) unsigned NOT NULL default '0',
  `ip_address` varchar(15) default NULL,
  `virtualhost` char(1) NOT NULL default 'y',
  PRIMARY KEY  (`server_ip_id`)
redray's avatar
redray committed
627
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
tbrehm's avatar
tbrehm committed
628
629

-- 
tbrehm's avatar
tbrehm committed
630
-- Daten fr Tabelle `server_ip`
tbrehm's avatar
tbrehm committed
631
-- 
632

tbrehm's avatar
tbrehm committed
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
-- --------------------------------------------------------

CREATE TABLE `shell_user` (
  `shell_user_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `server_id` int(11) NOT NULL default '0',
  `parent_domain_id` int(11) NOT NULL default '0',
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `quota_size` int(11) NOT NULL default '-1',
  `active` varchar(255) NOT NULL default 'y',
tbrehm's avatar
tbrehm committed
648
649
  `puser` varchar(255) default NULL,
  `pgroup` varchar(255) default NULL,
tbrehm's avatar
tbrehm committed
650
651
  `shell` varchar(255) NOT NULL default '/bin/bash',
  `dir` varchar(255) default NULL,
daniel's avatar
daniel committed
652
  `chroot` varchar(255) NOT NULL,
tbrehm's avatar
tbrehm committed
653
  PRIMARY KEY  (`shell_user_id`)
redray's avatar
redray committed
654
) ENGINE=MyISAM AUTO_INCREMENT=1;
daniel's avatar
daniel committed
655

tbrehm's avatar
tbrehm committed
656
657
658
659
660

-- 
-- Daten fr Tabelle `shell_user`
-- 

tbrehm's avatar
tbrehm committed
661

662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `software_package`
-- 

CREATE TABLE `software_package` (
  `package_id` int(11) NOT NULL auto_increment,
  `software_repo_id` int(11) NOT NULL,
  `package_name` varchar(100) NOT NULL,
  `package_title` varchar(255) NOT NULL,
  `package_description` text,
  `package_version` varchar(255) default NULL,
  PRIMARY KEY  (`package_id`),
  UNIQUE KEY `package_name` (`package_name`)
redray's avatar
redray committed
677
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
678
679
680
681
682

-- 
-- Daten fr Tabelle `software_package`
-- 

683
684
-- --------------------------------------------------------

685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
-- 
-- Tabellenstruktur fr Tabelle `software_repo`
-- 

CREATE TABLE `software_repo` (
  `software_repo_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `repo_name` varchar(40) default NULL,
  `repo_url` varchar(40) default NULL,
  `repo_username` varchar(30) default NULL,
  `repo_password` varchar(30) default NULL,
  `active` varchar(255) NOT NULL default 'y',
  PRIMARY KEY  (`software_repo_id`)
redray's avatar
redray committed
702
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
703
704
705
706
707
708

-- 
-- Daten fr Tabelle `software_repo`
-- 

INSERT INTO `software_repo` (`software_repo_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `repo_name`, `repo_url`, `repo_username`, `repo_password`, `active`) VALUES (1, 1, 1, 'riud', 'riud', '', 'ISPConfig Addons', 'http://repo.ispconfig.org/addons/', '', '', 'n');
709
710
711
712
713
714
715
716
717
718

-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `software_update`
-- 

CREATE TABLE `software_update` (
  `software_update_id` int(11) NOT NULL auto_increment,
  `software_repo_id` int(11) NOT NULL,
719
  `package_name` varchar(255) NOT NULL,
720
721
  `update_url` varchar(255) NOT NULL,
  `update_md5` varchar(255) NOT NULL,
722
  `update_dependencies` varchar(255) NOT NULL,
723
  `update_title` varchar(255) NOT NULL,
724
725
726
727
728
  `v1` tinyint(4) NOT NULL default '0',
  `v2` tinyint(4) NOT NULL default '0',
  `v3` tinyint(4) NOT NULL default '0',
  `v4` tinyint(4) NOT NULL default '0',
  `type` enum('full','update') NOT NULL default 'full',
729
  PRIMARY KEY  (`software_update_id`)
redray's avatar
redray committed
730
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
731
732
733
734
735

-- 
-- Daten fr Tabelle `software_update`
-- 

736
737
738
739
740
741
742
743
744
745
746
747
748
749
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `software_update_inst`
-- 

CREATE TABLE `software_update_inst` (
  `software_update_inst_id` int(10) unsigned NOT NULL auto_increment,
  `software_update_id` int(11) NOT NULL default '0',
  `package_name` varchar(255) NOT NULL,
  `server_id` int(11) NOT NULL,
  `status` enum('none','installing','installed','deleting') NOT NULL default 'none',
  PRIMARY KEY  (`software_update_inst_id`),
  UNIQUE KEY `software_update_id` (`software_update_id`,`package_name`,`server_id`)
redray's avatar
redray committed
750
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
751
752
753
754
755

-- 
-- Daten fr Tabelle `software_update_inst`
-- 

756
757
758
759

-- --------------------------------------------------------


760
-- 
tbrehm's avatar
tbrehm committed
761
-- Tabellenstruktur fr Tabelle `spamfilter_policy`
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
-- 

CREATE TABLE `spamfilter_policy` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
  `policy_name` varchar(32) default NULL,
  `virus_lover` char(1) default NULL,
  `spam_lover` char(1) default NULL,
  `banned_files_lover` char(1) default NULL,
  `bad_header_lover` char(1) default NULL,
  `bypass_virus_checks` char(1) default NULL,
  `bypass_spam_checks` char(1) default NULL,
  `bypass_banned_checks` char(1) default NULL,
  `bypass_header_checks` char(1) default NULL,
  `spam_modifies_subj` char(1) default NULL,
  `virus_quarantine_to` varchar(64) default NULL,
  `spam_quarantine_to` varchar(64) default NULL,
  `banned_quarantine_to` varchar(64) default NULL,
  `bad_header_quarantine_to` varchar(64) default NULL,
  `clean_quarantine_to` varchar(64) default NULL,
  `other_quarantine_to` varchar(64) default NULL,
  `spam_tag_level` float default NULL,
  `spam_tag2_level` float default NULL,
  `spam_kill_level` float default NULL,
  `spam_dsn_cutoff_level` float default NULL,
  `spam_quarantine_cutoff_level` float default NULL,
  `addr_extension_virus` varchar(64) default NULL,
  `addr_extension_spam` varchar(64) default NULL,
  `addr_extension_banned` varchar(64) default NULL,
  `addr_extension_bad_header` varchar(64) default NULL,
  `warnvirusrecip` char(1) default NULL,
  `warnbannedrecip` char(1) default NULL,
  `warnbadhrecip` char(1) default NULL,
  `newvirus_admin` varchar(64) default NULL,
  `virus_admin` varchar(64) default NULL,
  `banned_admin` varchar(64) default NULL,
  `bad_header_admin` varchar(64) default NULL,
  `spam_admin` varchar(64) default NULL,
  `spam_subject_tag` varchar(64) default NULL,
  `spam_subject_tag2` varchar(64) default NULL,
  `message_size_limit` int(11) default NULL,
  `banned_rulenames` varchar(64) default NULL,
  PRIMARY KEY  (`id`)
redray's avatar
redray committed
809
) ENGINE=MyISAM AUTO_INCREMENT=13 ;
810
811

-- 
tbrehm's avatar
tbrehm committed
812
-- Daten fr Tabelle `spamfilter_policy`
813
814
-- 

815
816
817
818
819
820
821
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (1, 1, 0, 'riud', 'riud', 'r', 'Non-paying', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'Y', '', '', '', '', '', '', 3, 7, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (2, 1, 0, 'riud', 'riud', 'r', 'Uncensored', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (3, 1, 0, 'riud', 'riud', 'r', 'Wants all spam', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 999, 999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (4, 1, 0, 'riud', 'riud', 'r', 'Wants viruses', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 6.9, 6.9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (5, 1, 0, 'riud', 'riud', 'r', 'Normal', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 6.9, 6.9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (6, 1, 0, 'riud', 'riud', 'r', 'Trigger happy', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 5, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `spamfilter_policy` (`id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `policy_name`, `virus_lover`, `spam_lover`, `banned_files_lover`, `bad_header_lover`, `bypass_virus_checks`, `bypass_spam_checks`, `bypass_banned_checks`, `bypass_header_checks`, `spam_modifies_subj`, `virus_quarantine_to`, `spam_quarantine_to`, `banned_quarantine_to`, `bad_header_quarantine_to`, `clean_quarantine_to`, `other_quarantine_to`, `spam_tag_level`, `spam_tag2_level`, `spam_kill_level`, `spam_dsn_cutoff_level`, `spam_quarantine_cutoff_level`, `addr_extension_virus`, `addr_extension_spam`, `addr_extension_banned`, `addr_extension_bad_header`, `warnvirusrecip`, `warnbannedrecip`, `warnbadhrecip`, `newvirus_admin`, `virus_admin`, `banned_admin`, `bad_header_admin`, `spam_admin`, `spam_subject_tag`, `spam_subject_tag2`, `message_size_limit`, `banned_rulenames`) VALUES (7, 1, 0, 'riud', 'riud', 'r', 'Permissive', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 3, 10, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
822
823
824
825

-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
826
-- Tabellenstruktur fr Tabelle `spamfilter_users`
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
-- 

CREATE TABLE `spamfilter_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `priority` int(11) NOT NULL default '7',
  `policy_id` int(10) unsigned NOT NULL default '1',
  `email` varchar(255) NOT NULL,
  `fullname` varchar(255) default NULL,
  `local` char(1) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
redray's avatar
redray committed
844
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
845
846

-- 
tbrehm's avatar
tbrehm committed
847
-- Daten fr Tabelle `spamfilter_users`
848
849
-- 

tbrehm's avatar
tbrehm committed
850

851
852
853
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
854
-- Tabellenstruktur fr Tabelle `spamfilter_wblist`
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
-- 

CREATE TABLE `spamfilter_wblist` (
  `wblist_id` int(10) unsigned NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL,
  `sys_groupid` int(11) NOT NULL,
  `sys_perm_user` varchar(5) NOT NULL,
  `sys_perm_group` varchar(5) NOT NULL,
  `sys_perm_other` varchar(5) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `wb` enum('W','B') NOT NULL default 'W',
  `rid` int(10) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `active` enum('y','n') NOT NULL default 'y',
  PRIMARY KEY  (`wblist_id`)
redray's avatar
redray committed
871
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
872
873

-- 
tbrehm's avatar
tbrehm committed
874
-- Daten fr Tabelle `spamfilter_wblist`
875
876
-- 

tbrehm's avatar
tbrehm committed
877

878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
-- --------------------------------------------------------

-- 
-- Tabellenstruktur fr Tabelle `support_message`
-- 

CREATE TABLE `support_message` (
  `support_message_id` bigint(20) NOT NULL auto_increment,
  `sys_userid` int(11) NOT NULL default '0',
  `sys_groupid` int(11) NOT NULL default '0',
  `sys_perm_user` varchar(5) default NULL,
  `sys_perm_group` varchar(5) default NULL,
  `sys_perm_other` varchar(5) default NULL,
  `recipient_id` int(11) NOT NULL default '0',
  `sender_id` int(11) NOT NULL default '0',
  `subject` varchar(255) default NULL,
  `message` varchar(255) default NULL,
  `tstamp` int(11) NOT NULL default '1187707778',
  PRIMARY KEY  (`support_message_id`)
redray's avatar
redray committed
897
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
898

899
900
901
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
902
-- Tabellenstruktur fr Tabelle `sys_datalog`
903
904
905
906
-- 

CREATE TABLE `sys_datalog` (
  `datalog_id` bigint(20) NOT NULL auto_increment,
tbrehm's avatar
tbrehm committed
907
  `server_id` int(11) NOT NULL,
908
909
910
911
912
913
914
  `dbtable` varchar(255) NOT NULL default '',
  `dbidx` varchar(255) NOT NULL default '',
  `action` char(1) NOT NULL default '',
  `tstamp` bigint(20) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `data` text NOT NULL,
  PRIMARY KEY  (`datalog_id`)
redray's avatar
redray committed
915
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
916
917

-- 
tbrehm's avatar
tbrehm committed
918
-- Daten fr Tabelle `sys_datalog`
919
920
-- 

tbrehm's avatar
tbrehm committed
921

922
923
924
-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
925
-- Tabellenstruktur fr Tabelle `sys_dbsync`
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
-- 

CREATE TABLE `sys_dbsync` (
  `id` bigint(20) NOT NULL auto_increment,
  `jobname` varchar(255) NOT NULL default '',
  `sync_interval_minutes` int(11) NOT NULL default '0',
  `db_type` varchar(255) NOT NULL default '',
  `db_host` varchar(255) NOT NULL default '',
  `db_name` varchar(255) NOT NULL default '',
  `db_username` varchar(255) NOT NULL default '',
  `db_password` varchar(255) NOT NULL default '',
  `db_tables` varchar(255) NOT NULL default 'admin,forms',
  `empty_datalog` int(11) NOT NULL default '0',
  `sync_datalog_external` int(11) NOT NULL default '0',
  `active` int(11) NOT NULL default '1',
  `last_datalog_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `last_datalog_id` (`last_datalog_id`)
redray's avatar
redray committed
944
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
945
946

-- 
tbrehm's avatar
tbrehm committed
947
-- Daten fr Tabelle `sys_dbsync`
948
949
950
951
952
953
-- 


-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
954
-- Tabellenstruktur fr Tabelle `sys_filesync`
955
956
957
958
959
960
961
962
963
964
965
966
967
968
-- 

CREATE TABLE `sys_filesync` (
  `id` bigint(20) NOT NULL auto_increment,
  `jobname` varchar(255) NOT NULL default '',
  `sync_interval_minutes` int(11) NOT NULL default '0',
  `ftp_host` varchar(255) NOT NULL default '',
  `ftp_path` varchar(255) NOT NULL default '',
  `ftp_username` varchar(255) NOT NULL default '',
  `ftp_password` varchar(255) NOT NULL default '',
  `local_path` varchar(255) NOT NULL default '',
  `wput_options` varchar(255) NOT NULL default '--timestamping --reupload --dont-continue',
  `active` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
redray's avatar
redray committed
969
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
970
971

-- 
tbrehm's avatar
tbrehm committed
972
-- Daten fr Tabelle `sys_filesync`
973
974
975
976
977
978
-- 


-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
979
-- Tabellenstruktur fr Tabelle `sys_group`
980
981
982
983
984
985
-- 

CREATE TABLE `sys_group` (
  `groupid` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
986
  `client_id` int(11) NOT NULL default '0',
987
  PRIMARY KEY  (`groupid`)
redray's avatar
redray committed
988
) ENGINE=MyISAM AUTO_INCREMENT=4 ;
989
990

-- 
tbrehm's avatar
tbrehm committed
991
-- Daten fr Tabelle `sys_group`
992
993
-- 

994
INSERT INTO `sys_group` (`groupid`, `name`, `description`, `client_id`) VALUES (1, 'admin', 'Administrators group', 0);
995
996
997
998

-- --------------------------------------------------------

-- 
tbrehm's avatar
tbrehm committed
999
-- Tabellenstruktur fr Tabelle `sys_user`
1000
--