DROP TABLE IF EXISTS `phpcms_message_group`; CREATE TABLE `phpcms_message_group` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `typeid` smallint(5) unsigned NOT NULL DEFAULT '0', `groupid` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '用户组id', `subject` char(80) DEFAULT NULL, `content` text NOT NULL COMMENT '内容', `inputtime` int(10) unsigned DEFAULT '0', `status` tinyint(2) unsigned DEFAULT '1', PRIMARY KEY (`id`) ) TYPE=MyISAM;