File: spamd_sql.mysql.sql

package info (click to toggle)
horde-sam 0.1-1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 1,292 kB
  • ctags: 363
  • sloc: php: 1,449; xml: 646; makefile: 64; sql: 60; sh: 30
file content (11 lines) | stat: -rw-r--r-- 331 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
 
-- $Horde: sam/scripts/sql/spamd_sql.mysql.sql,v 1.1 2004/09/18 20:18:58 chuck Exp $

CREATE TABLE userpref (
    prefid int(11) NOT NULL auto_increment,
    username VARCHAR(255) NOT NULL,
    preference VARCHAR(30) NOT NULL,
    value VARCHAR(100) NOT NULL,

    PRIMARY KEY  (prefid),
    KEY username (username)
) TYPE=MyISAM;