日期:2014-05-17 浏览次数:20464 次
01.
CREATE
TABLE
email (
02.
emailid mediumint(8) unsigned
NOT
NULL
auto_increment COMMENT
'邮件id'
,
03.
04.
fromid
int
(10) unsigned
NOT
NULL
default
'0'
COMMENT
'发送人ID'
,
05.
06.
toid
int
(10) unsigned
NOT
NULL
default
'0'
COMMENT
'收件人ID'
,
07.
content text unsigned
NOT
NULL
COMMENT
'邮件内容'
,
08.
subject
varchar
(100) unsigned
NOT
NULL
COMMENT
'邮件标题'
,
09.
10.
sendtime
int
(10)
NOT
NULL
COMMENT
'发送时间'
,
11.