| 1234567891011121314151617181920212223242526 |
- CREATE table email
- (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- type tinyint(4) NOT NULL DEFAULT 0 ,
- subject varchar(1000) NOT NULL DEFAULT '' ,
- reply_to json ,
- from_name varchar(50) NOT NULL DEFAULT '' ,
- from_address varchar(150) NOT NULL DEFAULT '' ,
- `to` json ,
- bcc json ,
- cc json ,
- `text` text ,
- html text ,
- sender json ,
- attachments json ,
- spf_check tinyint(1) DEFAULT 0 ,
- dkim_check tinyint(1) DEFAULT 0 ,
- status tinyint(4) NOT NULL DEFAULT 0 ,
- send_user_id int unsigned NOT NULL DEFAULT 0 ,
- is_read tinyint(1) NOT NULL DEFAULT 0 ,
- error text ,
- cron_send_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
- send_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
- create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ,
- update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
- )
|
