gistfile1.txt

CREATE TABLE serendipity_spamblocklog (
                        timestamp int(10) default null,
                        type varchar(255),
                        reason text,
                        entry_id int(10) not null default '0',
                        author varchar(80),
                        email varchar(200),
                        url varchar(200),
                        useragent varchar(255),
                        ip varchar(15),
                        referer varchar(255),
                        body text)
);

CREATE INDEX kspamidx ON serendipity_spamblocklog (timestamp);
CREATE INDEX kspamtypeidx ON serendipity_spamblocklog (type);
CREATE INDEX kspamentryidx ON serendipity_spamblocklog (entry_id);