renewenewshmsg_1.php
834 Bytes
<?php
@include("../../inc/header.php");
/*
SoftName : EmpireBak
Author : wm_chief
Copyright: Powered by www.phome.net
*/
E_D("DROP TABLE IF EXISTS `renewenewshmsg`;");
E_C("CREATE TABLE `renewenewshmsg` (
`mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(80) NOT NULL DEFAULT '',
`msgtext` text NOT NULL,
`haveread` tinyint(1) NOT NULL DEFAULT '0',
`msgtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`to_username` varchar(30) NOT NULL DEFAULT '',
`from_userid` int(10) unsigned NOT NULL DEFAULT '0',
`from_username` varchar(30) NOT NULL DEFAULT '',
`isadmin` tinyint(1) NOT NULL DEFAULT '0',
`issys` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `to_username` (`to_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
@include("../../inc/footer.php");
?>