met2009031901_20090319_7088_1.sql

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

#MetInfo.cn Created
# --------------------------------------------------------


DROP TABLE IF EXISTS met_admin_table;
CREATE TABLE `met_admin_table` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `admin_type` text NOT NULL,
  `admin_id` char(15) NOT NULL,
  `admin_pass` char(64) default NULL,
  `admin_name` varchar(30) NOT NULL,
  `admin_sex` tinyint(1) NOT NULL default '1',
  `admin_tel` varchar(20) default NULL,
  `admin_mobile` varchar(20) default NULL,
  `admin_email` varchar(150) default NULL,
  `admin_qq` varchar(12) NOT NULL,
  `admin_msn` varchar(40) NOT NULL,
  `admin_taobao` varchar(40) NOT NULL,
  `admin_introduction` text,
  `admin_login` int(11) unsigned NOT NULL default '0',
  `admin_modify_ip` varchar(20) default NULL,
  `admin_modify_date` datetime default NULL,
  `admin_register_date` datetime default NULL,
  `admin_approval_date` datetime default NULL,
  `admin_ok` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `admin_id` (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_admin_table VALUES('1','metinfo','admin','e10adc3949ba59abbe56e057f20f883e','','1','','','[e-mail]','','','','创始人','1','127.0.0.1','2009-03-19 11:22:54','2009-03-19 08:49:31','','1');

DROP TABLE IF EXISTS met_column;
CREATE TABLE `met_column` (
  `id` int(11) NOT NULL auto_increment,
  `c_name` char(100) default NULL,
  `e_name` char(100) default NULL,
  `foldername` char(50) default NULL,
  `filename` varchar(50) default NULL,
  `bigclass` int(11) default '0',
  `module` int(11) default NULL,
  `no_order` int(11) default NULL,
  `if_in` char(1) NOT NULL default '1',
  `nav` char(1) default '0',
  `c_keywords` varchar(200) default NULL,
  `e_keywords` varchar(200) default NULL,
  `c_content` text,
  `e_content` text,
  `c_description` text,
  `e_description` text,
  `c_out_url` char(200) default NULL,
  `list_order` int(11) default '0',
  `new_windows` char(50) default NULL,
  `classtype` int(11) default '1',
  `e_out_url` char(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_column VALUES('1','关于我们','About','about','about','0','1','1','0','1','','','<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><img height=\"150\" hspace=\"3\" width=\"150\" align=\"left\" vspace=\"3\" alt=\"\" src=\"../upload/logoimg.gif\" />米特信息（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></p>\r\n<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\">&nbsp;</p>\r\n<p class=\"p16\" 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></p>\r\n<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\">&nbsp;</p>\r\n<p class=\"p16\" 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></p>\r\n<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\">&nbsp;</p>\r\n<p class=\"p16\" 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\'\">秉承&ldquo;为合作伙伴创造价值&rdquo;的核心价值观，并以&ldquo;诚实、宽容、创新、服务&rdquo;为企业精神，通过自主创新和真诚合作为电子商务及信息服务行业创造价值。</span></p>\r\n<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\">&nbsp;</p>\r\n<p class=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-weight: bold; font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">关于&ldquo;为合作伙伴创造价值&rdquo;</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><o:p></o:p></span></p>\r\n<p class=\"p16\" 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=\"p16\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><br />\r\n</span><span style=\"font-weight: bold; font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\">关于&ldquo;诚实、宽容、创新、服务&rdquo;</span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><o:p></o:p></span></p>\r\n<p class=\"p0\" style=\"margin-top: 0pt; margin-bottom: 0pt\"><span style=\"font-size: 10.5pt; font-family: \'Times New Roman\'; mso-spacerun: \'yes\'\"><font face=\"宋体\">　&nbsp;</font></span><span style=\"font-size: 10.5pt; font-family: \'宋体\'; mso-spacerun: \'yes\'\"><font face=\"宋体\">米特信息</font></span><span style=\"font-size: 10.5pt; font-family: \'Times New Roman\'; mso-spacerun: \'yes\'\"><font face=\"宋体\">认为诚信是一切合作的基础，宽容是解决问题的前提，创新是发展事业的利器，服务是创造价值的根本。</font></span></p>\r\n<!--EndFragment-->','<p class=\"style2 style6\"><img height=\"150\" hspace=\"3\" width=\"150\" align=\"left\" vspace=\"3\" alt=\"\" src=\"../upload/logoimg.gif\" />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.</p>\r\n<p class=\"style7\">MatISS Co.,Ltd is located in Changsha , developing the talent and technology of Central South University . We will do our best to offering the best service by gathering talents and technology innovation.</p>\r\n<p class=\"style7\">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.</p>\r\n<p class=\"style7\"><strong>Materials Science Department </strong></p>\r\n<p class=\"style7\">There are including Materials Science Department and Information Service System Department in our company. By cooperating with Information Service System Department, Materials Science Department is focused and specialized in the fields of material science, and do our best to offering the whole enterprise solution of the simulation of Materials and Information Service for clients.</p>\r\n<p class=\"style7\"><strong>About &ldquo;Create Value for Partners&rdquo; </strong></p>\r\n<p class=\"style7\">MatISS thinks that all organization and persons which have cooperative relation with us are our partners, which include clients, suppliers, shareholders, employee and so on. Only doing our best to creating value for partners, MatISS will embody our value, develop and be successful.</p>\r\n<p class=\"style7\"><strong>About &ldquo;Honesty, Allowance, Innovation, Service&rdquo; </strong></p>\r\n<p class=\"style7\">Honesty is the base of all cooperation. Allowance is the prerequisite of solving problem, Innovation is the edge tool of development causes. Service is the basic of creating value.</p>','米特信息的主要业务包括：网站系统开发、网站建设、网站推广、空间域名以及网络营销策划与运行。','MatISS Co.,Ltd is located in Changsha , developing the talent and technology of Central South University . We will do our best to offering the best service by gathering talents and technology innovation. ','','0','','1','');
INSERT INTO met_column VALUES('2','联系我们','Contact','about','contant','1','1','1','0','2','','','<p>&nbsp;</p>\r\n<p>地址：长沙市天心区赤岭路348号</p>\r\n<p>电话：[phone] 13873185250</p>\r\n<p>QQ：426507856</p>\r\n<p>邮编：410076</p>\r\n<p>email：<a href=\"mailto:[e-mail]\">[e-mail]</a></p>\r\n<p>网址：<a href=\"http://www.metinfo.cn/\">www.MetInfo.cn</a></p>','<p>&nbsp;</p>\r\n<p>Add:No 348,Chiling Road, Tianxin area, Changsha City</p>\r\n<p>Tel：[phone] 13873185250</p>\r\n<p>QQ：426507856</p>\r\n<p>Code：410076</p>\r\n<p>Email：<a href=\"mailto:[e-mail]\">[e-mail]</a></p>\r\n<p>Web：<a href=\"http://www.metinfo.cn/\">www.MetInfo.cn</a></p>','','','','0','','2','');
INSERT INTO met_column VALUES('3','业务范围','Operation','about','operation','1','1','2','0','0','','','<p>1、网站系统开发、信息系统开发；<br />\r\n2、网站建设、网站设计； <br />\r\n3、网站推广与网络营销；<br />\r\n4、营销策划；<br />\r\n5、空间域名</p>','<p>1、Developing web system and information system；<br />\r\n2、Web building,web design； <br />\r\n3、Web extend and web marketing；<br />\r\n4、Marketing；<br />\r\n5、Domain and IDC；</p>','','','','0','','2','');
INSERT INTO met_column VALUES('4','新闻中心','News','news','','0','2','2','0','1','','','','','','','','1','','1','');
INSERT INTO met_column VALUES('5','企业新闻','Enterprise News','news','','4','2','1','0','0','','','','','','','','1','','2','');
INSERT INTO met_column VALUES('6','行业新闻','Industry News','news','','4','2','2','0','0','','','','','','','','1','','2','');
INSERT INTO met_column VALUES('7','产品中心','Product','product','','0','3','3','0','1','','','','','','','','3','','1','');
INSERT INTO met_column VALUES('8','家用电器','Household Appliances','product','','7','3','1','0','0','','','','','','','','3','','2','');
INSERT INTO met_column VALUES('9','电视机','TV','product','','8','3','1','0','0','','','','','','','','3','','3','');
INSERT INTO met_column VALUES('10','洗衣机','Washer','product','','8','3','2','0','0','','','','','','','','3','','3','');
INSERT INTO met_column VALUES('11','办公电脑','Transacting Computer','product','','7','3','2','0','0','','','','','','','','3','','2','');
INSERT INTO met_column VALUES('12','数码通讯','Digital Communication','product','','7','3','3','0','0','','','','','','','','3','','2','');
INSERT INTO met_column VALUES('13','下载中心','Download','download','','0','4','4','0','3','','','','','','','','1','','1','');
INSERT INTO met_column VALUES('14','文件下载','File Download','download','','13','4','1','0','0','','','','','','','','1','','2','');
INSERT INTO met_column VALUES('15','软件下载','Software Download','download','','13','4','2','0','0','','','','','','','','1','','2','');
INSERT INTO met_column VALUES('16','图片中心','Image','img','','0','5','6','0','1','','','','','','','','1','','1','');
INSERT INTO met_column VALUES('17','常见问答','FAQ','faq','','0','2','7','0','3','','','','','','','','1','','1','');
INSERT INTO met_column VALUES('18','招聘中心','Job','job','','0','6','8','0','3','','','','','','','','0','','1','');
INSERT INTO met_column VALUES('19','在线反馈','Feedback','','','0','0','9','1','1','','','','','','','feedback/index.php','0','','1','feedback/index.php?en=en');
INSERT INTO met_column VALUES('20','网站管理','Administer','','','0','0','20','1','2','','','','','','','admin/','0','target=\'_blank\'','1','admin/');
INSERT INTO met_column VALUES('21','交流论坛','Forum','','','0','0','10','1','1','','','','','','','http://bbs.metinfo.cn','0','target=\'_blank\'','1','http://bbs.metinfo.cn');
INSERT INTO met_column VALUES('22','在线留言','Leave Word','message','','0','7','9','0','2','','','','','','','','0','','1','');