modules/spam/spam.pgsql

CREATE TABLE spam_tokens (
  token varchar(255) PRIMARY KEY default '',
  spam integer NOT NULL default '0',
  notspam integer NOT NULL default '0',
  probability integer NOT NULL default '0',
  last numeric(11,0) NOT NULL default '0'
);
CREATE INDEX spam_tokens_spam_idx ON spam_tokens (spam);
CREATE INDEX spam_tokens_notspam_idx ON spam_tokens (notspam);
CREATE INDEX spam_tokens_probability_idx ON spam_tokens (probability);
CREATE INDEX spam_tokens_last_idx ON spam_tokens (last);

CREATE TABLE spam_statistics (
  name varchar(255) PRIMARY KEY default '',
  value integer NOT NULL default '0',
  last numeric(11,0) NOT NULL default '0'
);

CREATE TABLE spam_comments (
  cid integer PRIMARY KEY default '0',
  rating numeric(2,0) NOT NULL default '0',
  spam numeric(1,0) NOT NULL default '0',
  last numeric(11,0) NOT NULL default '0'
);
CREATE INDEX spam_comments_rating_idx ON spam_comments (rating);
CREATE INDEX spam_comments_spam_idx ON spam_comments (spam);
CREATE INDEX spam_comments_last_idx ON spam_comments (last);

CREATE TABLE spam_custom (
  scid serial PRIMARY KEY,
  filter varchar(255) NOT NULL default '',
  regex numeric(1,0) NOT NULL default '0',
  effect numeric(2,0) NOT NULL default '0',
  autodelete numeric(1,0) NOT NULL default '0',
  matches numeric(11,0) NOT NULL default '0',
  last numeric(11,0) NOT NULL default '0'
);
CREATE INDEX spam_custom_filter_idx ON spam_custom (filter);
CREATE INDEX spam_custom_matches_idx ON spam_custom (matches);
CREATE INDEX spam_custom_last_idx ON spam_custom (last);

CREATE TABLE spam_nodes (
  nid integer PRIMARY KEY default '0',
  rating numeric(2,0) NOT NULL default '0',
  spam numeric(1,0) NOT NULL default '0',
  hostname varchar(128) NOT NULL default '',
  last numeric(11,0) NOT NULL default '0'
);
CREATE INDEX spam_nodes_rating_idx ON spam_nodes (rating);
CREATE INDEX spam_nodes_spam_idx ON spam_nodes (spam);
CREATE INDEX spam_nodes_last_idx ON spam_nodes (last);
1	CREATE TABLE spam_tokens (
2	token varchar(255) PRIMARY KEY default '',
3	spam integer NOT NULL default '0',
4	notspam integer NOT NULL default '0',
5	probability integer NOT NULL default '0',
6	last numeric(11,0) NOT NULL default '0'
7	);
8	CREATE INDEX spam_tokens_spam_idx ON spam_tokens (spam);
9	CREATE INDEX spam_tokens_notspam_idx ON spam_tokens (notspam);
10	CREATE INDEX spam_tokens_probability_idx ON spam_tokens (probability);
11	CREATE INDEX spam_tokens_last_idx ON spam_tokens (last);
12
13	CREATE TABLE spam_statistics (
14	name varchar(255) PRIMARY KEY default '',
15	value integer NOT NULL default '0',
16	last numeric(11,0) NOT NULL default '0'
17	);
18
19	CREATE TABLE spam_comments (
20	cid integer PRIMARY KEY default '0',
21	rating numeric(2,0) NOT NULL default '0',
22	spam numeric(1,0) NOT NULL default '0',
23	last numeric(11,0) NOT NULL default '0'
24	);
25	CREATE INDEX spam_comments_rating_idx ON spam_comments (rating);
26	CREATE INDEX spam_comments_spam_idx ON spam_comments (spam);
27	CREATE INDEX spam_comments_last_idx ON spam_comments (last);
28
29	CREATE TABLE spam_custom (
30	scid serial PRIMARY KEY,
31	filter varchar(255) NOT NULL default '',
32	regex numeric(1,0) NOT NULL default '0',
33	effect numeric(2,0) NOT NULL default '0',
34	autodelete numeric(1,0) NOT NULL default '0',
35	matches numeric(11,0) NOT NULL default '0',
36	last numeric(11,0) NOT NULL default '0'
37	);
38	CREATE INDEX spam_custom_filter_idx ON spam_custom (filter);
39	CREATE INDEX spam_custom_matches_idx ON spam_custom (matches);
40	CREATE INDEX spam_custom_last_idx ON spam_custom (last);
41
42	CREATE TABLE spam_nodes (
43	nid integer PRIMARY KEY default '0',
44	rating numeric(2,0) NOT NULL default '0',
45	spam numeric(1,0) NOT NULL default '0',
46	hostname varchar(128) NOT NULL default '',
47	last numeric(11,0) NOT NULL default '0'
48	);
49	CREATE INDEX spam_nodes_rating_idx ON spam_nodes (rating);
50	CREATE INDEX spam_nodes_spam_idx ON spam_nodes (spam);
51	CREATE INDEX spam_nodes_last_idx ON spam_nodes (last);