<?php
@include("../../inc/header.php");

/*
		SoftName : EmpireBak
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

E_D("DROP TABLE IF EXISTS `phome_enewssearch`;");
E_C("CREATE TABLE `phome_enewssearch` (
  `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 AUTO_INCREMENT=6 DEFAULT CHARSET=gbk");
E_D("replace into `phome_enewssearch` values('1','深度','1398260760','title','1','192.168.1.1','','1','newstime','0','18d5ec81958aba14bcab47be18791f76','article','1','0',' and ((title LIKE ''%深度%''))','0');");
E_D("replace into `phome_enewssearch` values('2','萝卜','1399027882','title','1','14.135.184.250','','1','newstime','0','e3218a05a4337d9dbc56d142c7c9d4df','article','1','0',' and ((title LIKE ''%萝卜%''))','0');");
E_D("replace into `phome_enewssearch` values('3','雨林','1414385448','title','8','1.50.186.17','','3','newstime','0','a5260f3810b12d7bd367b6d688a8ec13','article','1','0',' and ((title LIKE ''%雨林%''))','0');");
E_D("replace into `phome_enewssearch` values('4','sp3','1409039350','title','12','61.242.114.156','','1','newstime','0','4f2f622c44aeae57fcb8a0478e34351f','article','1','0',' and ((title LIKE ''%sp3%''))','0');");
E_D("replace into `phome_enewssearch` values('5','xp','1409920039','title','12','111.206.50.5','','1','newstime','0','d5655220f6d6bfa58e3199b291a594b9','article','1','0',' and ((title LIKE ''%xp%''))','0');");

@include("../../inc/footer.php");
?>