renewenewssearch_1.php
1.11 KB
<?php
@include("../../inc/header.php");
/*
SoftName : EmpireBak
Author : wm_chief
Copyright: Powered by www.phome.net
*/
E_D("DROP TABLE IF EXISTS `renewenewssearch`;");
E_C("CREATE TABLE `renewenewssearch` (
`searchid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`keyboard` varchar(255) NOT NULL DEFAULT '',
`searchtime` int(10) unsigned NOT NULL DEFAULT '0',
`searchclass` varchar(255) NOT NULL DEFAULT '',
`result_num` int(10) unsigned NOT NULL DEFAULT '0',
`searchip` varchar(20) NOT NULL DEFAULT '',
`classid` varchar(255) NOT NULL DEFAULT '',
`onclick` int(10) unsigned NOT NULL DEFAULT '0',
`orderby` varchar(30) NOT NULL DEFAULT '0',
`myorder` tinyint(1) NOT NULL DEFAULT '0',
`checkpass` varchar(32) NOT NULL DEFAULT '',
`tbname` varchar(60) NOT NULL DEFAULT '',
`tempid` smallint(5) unsigned NOT NULL DEFAULT '0',
`iskey` tinyint(1) NOT NULL DEFAULT '0',
`andsql` text NOT NULL,
`trueclassid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`searchid`),
KEY `checkpass` (`checkpass`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
@include("../../inc/footer.php");
?>