met2009031901_20090319_7088_1.sql

MetInfo企业网站管理系统采用PHP+Mysql架构

  `c_para4` varchar(200) default NULL,
  `c_para5` varchar(200) default NULL,
  `c_para6` varchar(200) default NULL,
  `c_para7` varchar(200) default NULL,
  `c_para8` varchar(200) default NULL,
  `c_para9` text,
  `c_para10` text,
  `e_para1` varchar(200) default NULL,
  `e_para2` varchar(200) default NULL,
  `e_para3` varchar(200) default NULL,
  `e_para4` varchar(200) default NULL,
  `e_para5` varchar(200) default NULL,
  `e_para6` varchar(200) default NULL,
  `e_para7` varchar(200) default NULL,
  `e_para8` varchar(200) default NULL,
  `e_para9` text,
  `e_para10` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_img VALUES('1','演示图片1','Demo image 1','','','','','<p>演示图片1</p>','<p>Demo image 1</p>','16','0','0','0','../upload/200903/watermark/1237385960.jpg','../upload/200903/thumb/1237385960.jpg','0','1','2009-03-18 22:02:55','2009-03-18 22:02:55','','','','','','','','','','','','','','','','','','','','');
INSERT INTO met_img VALUES('2','演示图片2','Demo image 2','','','','','<p>演示图片2</p>','<p>Demo image 2</p>','16','0','0','0','../upload/200903/watermark/1237385210.jpg','../upload/200903/thumb/1237385210.jpg','0','0','2009-03-18 22:04:35','2009-03-18 22:04:35','','','','','','','','','','','','','','','','','','','','');
INSERT INTO met_img VALUES('3','演示图片3','Demo image 3','','','','','<p>演示图片3</p>','<p>Demo image 3</p>','16','0','0','0','../upload/200903/watermark/1237385774.jpg','../upload/200903/thumb/1237385774.jpg','0','0','2009-03-19 11:35:51','2009-03-18 22:05:18','','','','','','','','','','','','','','','','','','','','');

DROP TABLE IF EXISTS met_index;
CREATE TABLE `met_index` (
  `id` int(11) NOT NULL auto_increment,
  `c_content` text,
  `e_content` text,
  `online_type` int(11) default NULL,
  `news_no` int(11) default NULL,
  `product_no` int(11) default NULL,
  `img_no` int(11) default NULL,
  `download_no` int(11) default NULL,
  `link_ok` int(11) default NULL,
  `link_img` int(11) default NULL,
  `link_text` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_index VALUES('1','<p><img height=\"150\" hspace=\"5\" width=\"200\" align=\"left\" vspace=\"5\" alt=\"\" src=\"upload/hibuilding2_004.jpg\" /><span style=\"font-size: 10.5pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">米特信息（MetInfo.cn</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">）</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">专注于</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">网络信息化及</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">网络营销领域，通过整合团队专业的市场营销理念与网络技术为客户提供优质的网络营销服务。</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><o:p></o:p></span></span></p>\r\n<p class=\"p17\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">米特信息的主要业务包括：</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">网站系统开发、</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">网站建设、网站推广、空间域名以及网络营销策划与运行。</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><o:p></o:p></span></p>\r\n<p class=\"p17\" style=\"margin-top: 0pt; margin-bottom: 0pt\">&nbsp;</p>\r\n<p class=\"p17\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">米特信息</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">主打产品&mdash;&mdash;</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">MetInfo企业网站管理系统采用PHP+Mysql架构，全站内置了SEO搜索引擎优化机制，拥有企业网站常用的模块功能（企业简介模块、新闻模块、产品模块、下载模块、图片模块、招聘模块、在线留言、反馈系统、在线交流、友情链接）。强大灵活的后台管理功能、静态页面生成功能、个性化模块添加功能等可为企业打造出大气漂亮且具有营销力的精品网站。</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><o:p></o:p></span></p>\r\n<!--EndFragment-->','<p><br />\r\n<img height=\"150\" hspace=\"5\" width=\"200\" align=\"left\" vspace=\"5\" alt=\"\" src=\"upload/hibuilding2_004.jpg\" /><span style=\"font-size: 10.5pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><font face=\"Arial\">MatISS is focused and specialized in the simulation of Materials and Information Service System. Our business includes the design and implementation of calculation and simulation of materials, the implementation and development of information service system, and so on. </font></span></span></p>\r\n<p><span style=\"font-size: 10.5pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><font face=\"Arial\">Our core value is &ldquo;Create Value for Partners&rdquo;, and &ldquo;Honesty, allowance, innovation, service&rdquo; is spirit of MatISS. We will make efforts to create value for materials industry and information service industry with the self-directed innovation and collaboration.</font></span></span></p>','1','8','4','10','10','1','10','20');

DROP TABLE IF EXISTS met_job;
CREATE TABLE `met_job` (
  `id` int(11) NOT NULL auto_increment,
  `c_position` varchar(200) default NULL,
  `e_position` varchar(200) default NULL,
  `count` int(11) default '0',
  `c_place` varchar(200) default NULL,
  `e_place` varchar(200) default NULL,
  `c_deal` varchar(200) default NULL,
  `e_deal` varchar(200) default NULL,
  `addtime` date default NULL,
  `useful_life` int(11) default NULL,
  `c_content` longtext,
  `e_content` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_job VALUES('1','销售工程师','Sales','5','长沙','changsha','面议','','2008-11-20','30','<p>1、本科以上学位</p>\r\n<p>2、市场营销专业</p>','<p>1、本科以上学位</p>\r\n<p>2、市场营销专业</p>');
INSERT INTO met_job VALUES('2','销售经理','sales manager','1','长沙','changsha','面议','','2009-03-08','0','<div>1、具有大专学历及以上学历，市场营销专业优先；</div>\r\n<div>2、具有3年以上的汽车行业营销经验，其中至少1年的销售管理经验；有驾驶执照，能熟练驾驶汽车；</div>\r\n<div>3、深入的营销知识和商务车产品知识，基本的财务和法律知识；</div>\r\n<div>4、具有出众的团队领带能力和发展他人能力，良好的关系建立能力、 沟通能力和冲突解决能力，良好的客户服务理念。</div>\r\n<!-- 联系方式 -->','<div>1、具有大专学历及以上学历，市场营销专业优先；</div>\r\n<div>2、具有3年以上的汽车行业营销经验，其中至少1年的销售管理经验；有驾驶执照，能熟练驾驶汽车；</div>\r\n<div>3、深入的营销知识和商务车产品知识，基本的财务和法律知识；</div>\r\n<div>4、具有出众的团队领带能力和发展他人能力，良好的关系建立能力、 沟通能力和冲突解决能力，良好的客户服务理念。</div>\r\n<!-- 联系方式 -->');

DROP TABLE IF EXISTS met_label;
CREATE TABLE `met_label` (
  `id` int(11) NOT NULL auto_increment,
  `oldwords` varchar(255) default NULL,
  `newwords` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_label VALUES('1','米特信息','米特信息','www.metinfo.com.cn');
INSERT INTO met_label VALUES('2','网站建设','网站建设','http://www.metinfo.cn/');
INSERT INTO met_label VALUES('3','Metinfo','Metinfo','http://www.metinfo.cn/');
INSERT INTO met_label VALUES('4','Web site','Web site','http://www.metinfo.cn/');

DROP TABLE IF EXISTS met_link;
CREATE TABLE `met_link` (
  `id` int(11) NOT NULL auto_increment,