Na}{

File Content: `202405280000_InitialSchema.sql`

-- Copyright 1999-2024. WebPros International GmbH. All rights reserved.
CREATE TABLE IF NOT EXISTS Mail (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    queueId VARCHAR(64) NOT NULL,
    messageId VARCHAR(998) DEFAULT NULL,
    `from` VARCHAR(998) DEFAULT NULL,
    `to` VARCHAR(998) DEFAULT NULL,
    status VARCHAR(16) DEFAULT NULL,
    extendedStatus TEXT DEFAULT NULL,
    dsn VARCHAR(32) DEFAULT NULL,
    size INTEGER DEFAULT NULL,
    CHECK(status IN ('sent', 'deferred', 'bounced', 'pending', 'force-expired', 'expired', 'rejected'))
);
-- Mail.messageId, Mail.from, Mail.to:
-- https://datatracker.ietf.org/doc/html/rfc5322#section-2.1.1
-- Each line of characters MUST be no more than 998 characters
--
-- Mail.status:
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/global/bounce.c#L521
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/global/defer.c#L273
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/global/bounce.c#L328
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/global/sent.c#L162
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/global/trace.c#L140
-- https://github.com/vdukhovni/postfix/blob/master/postfix/src/qmgr/qmgr_active.c#L452
-- src/plib/library/Database/Mail/Table.php:61

CREATE TABLE IF NOT EXISTS MailEvents (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    mailId INTEGER NOT NULL,
    timestamp INTEGER,
    entry TEXT,
    FOREIGN KEY(mailId) REFERENCES Mail(id) ON DELETE CASCADE
);

Name	Size	Permission
202405280000_InitialSchema.sql	1519 bytes	0644
202407280000_AddIndexes.sql	268 bytes	0644
202507110000_TrackRelayDirection.sql	192 bytes	0644
init_schema.sql	250 bytes	0644

File Content: 202405280000_InitialSchema.sql

File Content: `202405280000_InitialSchema.sql`