<?php
require("../../inc/header.php");
/*
SoftName : EmpireBak Version 2010
Author : wm_chief
Copyright: Powered by www.phome.net
*/
DoSetDbChar('gbk');
E_D("DROP TABLE IF EXISTS `qs_jobs`;");
E_C("CREATE TABLE `qs_jobs` (
`id` int(10) unsigned NOT NULL auto_increment,
`subsite_id` int(10) unsigned NOT NULL default '0',
`uid` int(10) unsigned NOT NULL,
`jobs_name` varchar(30) NOT NULL,
`companyname` varchar(50) NOT NULL,
`company_id` int(10) unsigned NOT NULL,
`company_addtime` int(10) unsigned NOT NULL,
`company_audit` tinyint(1) unsigned NOT NULL default '0',
`recommend` tinyint(3) unsigned NOT NULL default '0',
`emergency` tinyint(3) unsigned NOT NULL default '0',
`highlight` varchar(7) NOT NULL,
`stick` tinyint(1) NOT NULL,
`nature` tinyint(3) unsigned NOT NULL,
`nature_cn` varchar(30) NOT NULL,
`sex` tinyint(3) unsigned NOT NULL default '3',
`sex_cn` varchar(30) NOT NULL,
`amount` smallint(5) unsigned NOT NULL,
`category` smallint(5) unsigned NOT NULL,
`subclass` smallint(5) unsigned NOT NULL,
`category_cn` varchar(30) NOT NULL,
`trade` smallint(5) unsigned NOT NULL,
`trade_cn` varchar(30) NOT NULL,
`district` smallint(5) unsigned NOT NULL,
`sdistrict` smallint(5) unsigned NOT NULL,
`district_cn` varchar(30) NOT NULL,
`education` smallint(5) unsigned NOT NULL,
`education_cn` varchar(30) NOT NULL,
`experience` smallint(5) unsigned NOT NULL,
`experience_cn` varchar(30) NOT NULL,
`wage` smallint(5) unsigned NOT NULL,
`wage_cn` varchar(30) NOT NULL,
`graduate` tinyint(1) unsigned NOT NULL default '0',
`rest` tinyint(1) unsigned NOT NULL default '0',
`insurance` tinyint(1) unsigned NOT NULL default '0',
`contents` varchar(1800) NOT NULL,
`addtime` int(10) unsigned NOT NULL,
`deadline` int(10) unsigned NOT NULL,
`refreshtime` int(10) unsigned NOT NULL,
`setmeal_deadline` int(10) unsigned NOT NULL default '0',
`audit` tinyint(3) unsigned NOT NULL default '1',
`display` tinyint(3) unsigned NOT NULL default '1',
`click` int(10) unsigned NOT NULL default '1',
`key` text NOT NULL,
`user_status` tinyint(3) unsigned NOT NULL default '1',
`robot` tinyint(3) unsigned NOT NULL default '0',
`tpl` varchar(60) NOT NULL,
`add_mode` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `refreshtime` (`refreshtime`),
KEY `trade` (`trade`),
KEY `district` (`district`,`category`,`subclass`),
KEY `category` (`category`,`district`,`sdistrict`),
KEY `stick` (`stick`,`refreshtime`),
FULLTEXT KEY `key` (`key`)
) ENGINE=MyISAM AUTO_INCREMENT=581 DEFAULT CHARSET=gbk");
E_D("replace into `qs_jobs` values('1','0','1','西门子PLC销售工程师','北京华业环球科技有限公司','1','1320508227','0','0','0','','0','62','全职','3','不限','3','74','79','销售工程师','7','仪器仪表/工业自动化','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508227','1322841027','1320508227','0','1','1','1','西000 门000 子000 P000 L000 C000 销000 售000 工000 程000 师000 北000 京000 华000 业000 环000 球000 科000 技000 有000 限000 公000 司000 销000 售000 工000 程000 师000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('2','0','2','呼叫中心客服/坐席代表','北京国博和泰科技发展有限公司','2','1320508227','0','0','0','','0','62','全职','3','不限','20','49','58','客户代表','2','计算机系统/维修服务','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508227','1324309827','1320508227','0','1','1','1','呼000 叫000 中000 心000 客000 服000 坐000 席000 代000 表000 北000 京000 国000 博000 和000 泰000 科000 技000 发000 展000 有000 限000 公000 司000 客000 户000 代000 表000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('3','0','3','行政专员/助理','北京泰普工贸有限公司','3','1320508227','0','0','0','','0','62','全职','3','不限','3','203','206','行政专员/助理','4','互联网/电子商务','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508227','1325346627','1320508227','0','1','1','1','行000 政000 专000 员000 助000 理000 北000 京000 泰000 普000 工000 贸000 有000 限000 公000 司000 行000 政000 专000 员000 助000 理000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('4','0','1','销售工程师','北京华业环球科技有限公司','1','1320508227','0','0','0','','0','62','全职','3','不限','5','74','79','销售工程师','7','仪器仪表/工业自动化','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508228','1323359428','1320508228','0','1','1','1','销000 售000 工000 程000 师000 北000 京000 华000 业000 环000 球000 科000 技000 有000 限000 公000 司000 销000 售000 工000 程000 师000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('5','0','4','java开发','北京中软联动科技有限公司','4','1320508228','0','0','0','','0','62','全职','3','不限','8','1','8','人力资源总监','1','计算机软件/硬件','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508228','1323532228','1320508228','0','1','1','1','j000 a000 v000 a000 开000 发000 北000 京000 中000 软000 联000 动000 科000 技000 有000 限000 公000 司000 人000 力000 资000 源000 总000 监000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('6','0','5','《中国商标年鉴》广告销售业务员','中国知识产权报社商标周刊','5','1320508228','0','0','0','','0','62','全职','3','不限','6','520','521','公务员','45','其他行业','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508228','1322495428','1320508228','0','1','1','1','《000 中000 国000 商000 标000 年000 鉴000 》000 广000 告000 销000 售000 业000 务000 员000 中000 国000 知000 识000 产000 权000 报000 社000 商000 标000 周000 刊000 公000 务000 员000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('7','0','6','技术员','北京绿旗创科科技有限公司','6','1320508228','0','0','0','','0','62','全职','3','不限','2','394','403','配色技术员','37','交通/运输/物流','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508228','1322236228','1320508228','0','1','1','1','技000 术000 员000 北000 京000 绿000 旗000 创000 科000 科000 技000 有000 限000 公000 司000 配000 色000 技000 术000 员000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('8','0','1','PLC销售工程师','北京华业环球科技有限公司','1','1320508227','0','0','0','','0','62','全职','3','不限','5','74','79','销售工程师','7','仪器仪表/工业自动化','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508229','1324828229','1320508229','0','1','1','1','P000 L000 C000 销000 售000 工000 程000 师000 北000 京000 华000 业000 环000 球000 科000 技000 有000 限000 公000 司000 销000 售000 工000 程000 师000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('9','0','5','记者','中国知识产权报社商标周刊','5','1320508228','0','0','0','','0','62','全职','3','不限','3','1','8','人力资源总监','45','其他行业','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508229','1324137029','1320508229','0','1','1','1','记000 者000 中000 国000 知000 识000 产000 权000 报000 社000 商000 标000 周000 刊000 人000 力000 资000 源000 总000 监000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('10','0','7','销售助理','北京国宝时代工艺技术研究院','7','1320508229','0','0','0','','0','62','全职','3','不限','6','74','75','销售部经理','15','家具/家电/工艺品/玩具','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0','','1320508229','1322754629','1320508229','0','1','1','1','销000 售000 助000 理000 北000 京000 国000 宝000 时000 代000 工000 艺000 技000 术000 研000 究000 院000 销000 售000 部000 经000 理000 地000 区000 ','1','1','','1');");
E_D("replace into `qs_jobs` values('11','0','1','高级销售工程师','北京华业环球科技有限公司','1','1320508227','0','0','0','','0','62','全职','3','不限','2','74','79','销售工程师','7','仪器仪表/工业自动化','0','1','地区1','69','大专','76','1-3年','57','1500~2000','0','0','0'