CREATE TABLE [dbo].[awl] (
[username] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[email] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[count] [int] NOT NULL ,
[totscore] [float] NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_awl] ON [dbo].[awl] ([username], [email], [ip])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE TABLE [dbo].[bayes_vars] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[spam_count] [int] NOT NULL ,
[ham_count] [int] NOT NULL ,
[token_count] [int] NOT NULL ,
[last_expire] [int] NOT NULL ,
[last_atime_delta] [int] NOT NULL ,
[last_expire_reduce] [int] NOT NULL ,
[oldest_token_age] [int] NOT NULL ,
[newest_token_age] [int] NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_bayes_vars] ON [dbo].[bayes_vars] ([id])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE UNIQUE
INDEX [bayes_vars_idx1] ON [dbo].[bayes_vars] ([username])
WITH
IGNORE_DUP_KEY
,DROP_EXISTING
ON [PRIMARY];
CREATE TABLE [dbo].[bayes_expire] (
[id] [int] NOT NULL ,
[runtime] [int] NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_bayes_expire] ON [dbo].[bayes_expire] ([id])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE TABLE [dbo].[bayes_global_vars] (
[variable] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[value] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_bayes_global_vars] ON [dbo].[bayes_global_vars] ([variable])
WITH
DROP_EXISTING
ON [PRIMARY];
INSERT INTO bayes_global_vars VALUES ('VERSION','3');
CREATE TABLE [dbo].[bayes_seen] (
[id] [int] NOT NULL ,
[msgid] [varbinary] (200) NOT NULL ,
[flag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_bayes_seen] ON [dbo].[bayes_seen] ([id], [msgid])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE TABLE [dbo].[bayes_token] (
[id] [int] NOT NULL ,
[token] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[spam_count] [int] NOT NULL ,
[ham_count] [int] NOT NULL ,
[atime] [int] NOT NULL
) ON [PRIMARY];
CREATE UNIQUE CLUSTERED
INDEX [PK_bayes_token] ON [dbo].[bayes_token] ([id], [token])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE
INDEX [bayes_token_idx1] ON [dbo].[bayes_token] ([token])
WITH
DROP_EXISTING
ON [PRIMARY];
CREATE
INDEX [bayes_token_idx2] ON [dbo].[bayes_token] ([id], [atime])
WITH
DROP_EXISTING
ON [PRIMARY];
|