File: tables.mysql

package info (click to toggle)
postfix-gld 1.7-11
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 580 kB
  • sloc: ansic: 2,287; sql: 169; sh: 115; makefile: 71
file content (16 lines) | stat: -rw-r--r-- 484 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
CREATE TABLE greylist (
  ip char(45) NOT NULL default '',
  sender char(242) NOT NULL default '',
  recipient char(242) NOT NULL default '',
  first int(11) NOT NULL default '0',
  last int(11) NOT NULL default '0',
  n int(11) NOT NULL default '0',
  PRIMARY KEY  (ip,sender,recipient)
) ENGINE=MyISAM CHARSET=latin1;
    

CREATE TABLE whitelist (
  mail char(242) NOT NULL default '',
  comment char(242) NOT NULL default '',
  PRIMARY KEY  (mail)
) ENGINE=MyISAM CHARSET=latin1;