mirror of
https://github.com/marcus-alicia/iRedAdmin-Pro-SQL.git
synced 2026-05-26 15:13:38 +00:00
21 lines
741 B
SQL
21 lines
741 B
SQL
-- mailing list subscription/unsubscription confirms.
|
|
CREATE TABLE IF NOT EXISTS `newsletter_subunsub_confirms` (
|
|
`id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
|
|
-- email of mailing list
|
|
`mail` VARCHAR(255) NOT NULL DEFAULT '',
|
|
-- unique server wide id
|
|
`mlid` VARCHAR(255) NOT NULL DEFAULT '',
|
|
-- email of subscriber
|
|
`subscriber` VARCHAR(255) NOT NULL DEFAULT '',
|
|
-- kinds of 'subscribe', 'unsubscribe'
|
|
`kind` VARCHAR(20) NOT NULL DEFAULT '',
|
|
-- unique server-wide id as confirm token
|
|
`token` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`expired` INT UNSIGNED DEFAULT 0,
|
|
PRIMARY KEY (id),
|
|
INDEX (mail),
|
|
UNIQUE INDEX (mlid, subscriber, kind),
|
|
INDEX (token),
|
|
INDEX (expired)
|
|
) ENGINE=InnoDB;
|