File: userpref_mysql.sql

package info (click to toggle)
spamassassin 4.0.2-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 22,268 kB
  • sloc: perl: 88,850; ansic: 5,193; sh: 3,737; javascript: 339; sql: 295; makefile: 209; python: 49
file content (8 lines) | stat: -rw-r--r-- 267 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
 
CREATE TABLE userpref (
  username varchar(100) NOT NULL default '',
  preference varchar(50) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  prefid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (prefid),
  KEY username (username)
) ENGINE=InnoDB;