modules/spam/spam.mysql

CREATE TABLE spam_tokens (
  token varchar(255) NOT NULL default '',
  spam int(10) unsigned default '0',
  notspam int(10) unsigned default '0',
  probability int(10) unsigned default '0',
  last int(11) unsigned default '0',
  PRIMARY KEY token (token),
  KEY spam (spam),
  KEY notspam (notspam),
  KEY probablitiy (probability),
  KEY last (last)
) TYPE=MyISAM;

CREATE TABLE spam_statistics (
  name varchar(255) NOT NULL default '',
  value int(10) unsigned default '0',
  last int(11) unsigned default '0',
  PRIMARY KEY name (name)
) TYPE=MyISAM;

CREATE TABLE spam_comments (
  cid int(10) unsigned NOT NULL default '0',
  rating int(2) unsigned default '0',
  spam tinyint(1) unsigned default '0',
  last int(11) unsigned default '0',
  PRIMARY KEY cid (cid),
  KEY rating (rating),
  KEY spam (spam),
  KEY last (last)
) TYPE=MyISAM;

CREATE TABLE spam_custom (
  scid int(10) unsigned NOT NULL auto_increment,
  filter varchar(255) NOT NULL default '',
  regex tinyint(1) unsigned default '0',
  effect int(2) unsigned default '0',
  autodelete tinyint(1) unsigned default '0',
  matches int(11) unsigned default '0',
  last int(11) unsigned default '0',
  PRIMARY KEY scid (scid),
  KEY filter (filter),
  KEY matches (matches),
  KEY last (last)
) TYPE=MyISAM;

CREATE TABLE spam_nodes (
  nid int(10) unsigned NOT NULL default '0',
  rating int(2) unsigned default '0',
  spam tinyint(1) unsigned default '0',
  hostname varchar(128) NOT NULL default '',
  last int(11) unsigned default '0',
  PRIMARY KEY nid (nid),
  KEY rating (rating),
  KEY spam (spam),
  KEY last (last)
) TYPE=MyISAM;
1	CREATE TABLE spam_tokens (
2	token varchar(255) NOT NULL default '',
3	spam int(10) unsigned default '0',
4	notspam int(10) unsigned default '0',
5	probability int(10) unsigned default '0',
6	last int(11) unsigned default '0',
7	PRIMARY KEY token (token),
8	KEY spam (spam),
9	KEY notspam (notspam),
10	KEY probablitiy (probability),
11	KEY last (last)
12	) TYPE=MyISAM;
13
14	CREATE TABLE spam_statistics (
15	name varchar(255) NOT NULL default '',
16	value int(10) unsigned default '0',
17	last int(11) unsigned default '0',
18	PRIMARY KEY name (name)
19	) TYPE=MyISAM;
20
21	CREATE TABLE spam_comments (
22	cid int(10) unsigned NOT NULL default '0',
23	rating int(2) unsigned default '0',
24	spam tinyint(1) unsigned default '0',
25	last int(11) unsigned default '0',
26	PRIMARY KEY cid (cid),
27	KEY rating (rating),
28	KEY spam (spam),
29	KEY last (last)
30	) TYPE=MyISAM;
31
32	CREATE TABLE spam_custom (
33	scid int(10) unsigned NOT NULL auto_increment,
34	filter varchar(255) NOT NULL default '',
35	regex tinyint(1) unsigned default '0',
36	effect int(2) unsigned default '0',
37	autodelete tinyint(1) unsigned default '0',
38	matches int(11) unsigned default '0',
39	last int(11) unsigned default '0',
40	PRIMARY KEY scid (scid),
41	KEY filter (filter),
42	KEY matches (matches),
43	KEY last (last)
44	) TYPE=MyISAM;
45
46	CREATE TABLE spam_nodes (
47	nid int(10) unsigned NOT NULL default '0',
48	rating int(2) unsigned default '0',
49	spam tinyint(1) unsigned default '0',
50	hostname varchar(128) NOT NULL default '',
51	last int(11) unsigned default '0',
52	PRIMARY KEY nid (nid),
53	KEY rating (rating),
54	KEY spam (spam),
55	KEY last (last)
56	) TYPE=MyISAM;