SQLite format 3@ -) 'y'P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)?--1tablemail_unsubscribemail_unsubscribeCREATE TABLE `mail_unsubscribe` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `created` INTEGER NOT NULL, `recipient` varchar(320) NOT NULL, -- 收件人 `etype` INTEGER NOT NULL DEFAULT 1, -- 邮件类型id `active` tinyint(1) NOT NULL DEFAULT 0, -- 0 取消订阅 1订阅 `task_id` INTEGER DEFAULT 0, -- 群发任务 id (退订有关联id 订阅没有) UNIQUE(etype, recipient) )?S-indexsqlite_autoindex_mail_unsubscribe_1mail_unsubscribe