File: txrep_mysql.sql

package info (click to toggle)
spamassassin 4.0.1%2Bsvn1923525-1
  • links: PTS, VCS
  • area: main
  • in suites: experimental
  • size: 22,104 kB
  • sloc: perl: 87,831; ansic: 5,193; sh: 3,712; javascript: 339; sql: 295; makefile: 209; python: 49
file content (11 lines) | stat: -rw-r--r-- 443 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
 
CREATE TABLE txrep (
  username varchar(100) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  ip varchar(40) NOT NULL default '',
  msgcount int(11) NOT NULL default '0',
  totscore float NOT NULL default '0',
  signedby varchar(255) NOT NULL default '',
  last_hit timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (username,email,signedby,ip),
  KEY last_hit (last_hit)
) ENGINE=InnoDB;