#———ezmlm DB create script——————#

create TABLE list (
    hash TINYINT UNSIGNED NOT NULL,
    address VARCHAR(255) NOT NULL,
    INDEX  h  (hash),
    INDEX  a  (address(12)));

create TABLE list_slog (
    tai TIMESTAMP,
    address VARCHAR(255) NOT NULL,
    fromline VARCHAR(255) NOT NULL,
    edir CHAR(1) NOT NULL,
    etype CHAR(1) NOT NULL,
    INDEX (tai));

create TABLE list_digest (
    hash TINYINT UNSIGNED NOT NULL,
    address VARCHAR(255) NOT NULL,
    INDEX h (hash),
    INDEX a (address(12)));

create TABLE list_digest_slog (
    tai TIMESTAMP,
    address VARCHAR(255) NOT NULL,
    fromline VARCHAR(255) NOT NULL,
    edir CHAR(1) NOT NULL,
    etype CHAR(1) NOT NULL,
    INDEX (tai));

create TABLE list_mod (
    hash TINYINT UNSIGNED NOT NULL,
    address VARCHAR(255) NOT NULL,
    INDEX h (hash),
    INDEX a (address(12)));

create TABLE list_mod_slog (
    tai TIMESTAMP,
    address VARCHAR(255) NOT NULL,
    fromline VARCHAR(255) NOT NULL,
    edir CHAR(1) NOT NULL,
    etype CHAR(1) NOT NULL,
    INDEX (tai));

create TABLE list_allow (
    hash TINYINT UNSIGNED NOT NULL,
    address VARCHAR(255) NOT NULL,
    INDEX h (hash),
    INDEX a (address(12)));

create TABLE list_allow_slog (
    tai TIMESTAMP,
    address VARCHAR(255) NOT NULL,
    fromline VARCHAR(255) NOT NULL,
    edir CHAR(1) NOT NULL,
    etype CHAR(1) NOT NULL,
    INDEX (tai));

create TABLE list_deny (
    hash TINYINT UNSIGNED NOT NULL,
    address VARCHAR(255) NOT NULL,
    INDEX h (hash),
    INDEX a (address(12)));

create TABLE list_deny_slog (
    tai TIMESTAMP,
    address VARCHAR(255) NOT NULL,
    fromline VARCHAR(255) NOT NULL,
    edir CHAR(1) NOT NULL,
    etype CHAR(1) NOT NULL,
    INDEX (tai));

CREATE TABLE list_cookie (
    msgnum INTEGER UNSIGNED NOT NULL,
    tai TIMESTAMP NOT NULL,
    cookie CHAR(20) NOT NULL,
    chunk TINYINT UNSIGNED NOT NULL DEFAULT 0,
    bodysize INTEGER UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (msgnum));

CREATE TABLE list_mlog (
    msgnum INTEGER UNSIGNED NOT NULL,
    listno INTEGER UNSIGNED NOT NULL,
    tai TIMESTAMP,
    subs INTEGER UNSIGNED NOT NULL DEFAULT 0,
    done TINYINT NOT NULL DEFAULT 0,
    PRIMARY KEY listmsg (listno,msgnum,done));

CREATE TABLE list_digest_cookie (
    msgnum INTEGER UNSIGNED NOT NULL,
    tai TIMESTAMP NOT NULL,
    cookie CHAR(20) NOT NULL,
    chunk TINYINT UNSIGNED NOT NULL DEFAULT 0,
    bodysize INTEGER UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (msgnum));

CREATE TABLE list_digest_mlog (
    msgnum INTEGER UNSIGNED NOT NULL,
    listno INTEGER UNSIGNED NOT NULL,
    tai TIMESTAMP,
    subs INT UNSIGNED NOT NULL DEFAULT 0,
    done TINYINT NOT NULL DEFAULT 0,
    PRIMARY KEY listmsg (listno,msgnum,done));

#———ezmlm DB create script END——————#