CREATE TABLE pw_msg(
mid
INT
(
10
)
UNSIGNED
NOT
NULL
AUTO_INCREMENT
,
touid MEDIUMINT ( 8 ) UNSIGNED NOT NULL DEFAULT '0' ,
togroups VARCHAR ( 80 ) NOT NULL DEFAULT '' ,
fromuid MEDIUMINT ( 8 ) UNSIGNED NOT NULL DEFAULT '0' ,
username VARCHAR ( 15 ) NOT NULL DEFAULT '' ,
`type` ENUM ( 'rebox' , 'sebox' , 'public' ) NOT NULL DEFAULT 'rebox' ,
ifnew TINYINT ( 1 ) NOT NULL DEFAULT '0' ,
mdate INT ( 10 ) UNSIGNED NOT NULL DEFAULT '0' ,
PRIMARY KEY ( mid ) ,
KEY touid ( touid ) ,
KEY fromuid ( fromuid , mdate ) ,
KEY `type` ( `type` ) ,
KEY touids ( touid , mdate )
touid MEDIUMINT ( 8 ) UNSIGNED NOT NULL DEFAULT '0' ,
togroups VARCHAR ( 80 ) NOT NULL DEFAULT '' ,
fromuid MEDIUMINT ( 8 ) UNSIGNED NOT NULL DEFAULT '0' ,
username VARCHAR ( 15 ) NOT NULL DEFAULT '' ,
`type` ENUM ( 'rebox' , 'sebox' , 'public' ) NOT NULL DEFAULT 'rebox' ,
ifnew TINYINT ( 1 ) NOT NULL DEFAULT '0' ,
mdate INT ( 10 ) UNSIGNED NOT NULL DEFAULT '0' ,
PRIMARY KEY ( mid ) ,
KEY touid ( touid ) ,
KEY fromuid ( fromuid , mdate ) ,
KEY `type` ( `type` ) ,
KEY touids ( touid , mdate )
) ENGINE = MYISAM DEFAULT CHARSET = gbk;
注意 ENGINE = MYISAM符合自己mysql设置的ENGINE
CHARSET = gbk根据自己数据库设置的编码类型