File: awl_mysql.sql

package info (click to toggle)
spamassassin 3.0.3-2sarge1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 4,532 kB
  • ctags: 1,570
  • sloc: perl: 29,159; ansic: 2,329; sh: 1,353; makefile: 181; sql: 109
file content (8 lines) | stat: -rw-r--r-- 253 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
 
CREATE TABLE awl (
  username varchar(100) NOT NULL default '',
  email varchar(200) NOT NULL default '',
  ip varchar(10) NOT NULL default '',
  count int(11) default '0',
  totscore float default '0',
  PRIMARY KEY  (username,email,ip)
) TYPE=MyISAM;