met2009031901_20090319_7088_1.sql

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

INSERT INTO met_fdparameter VALUES('2','姓名','Name','3','1','1','1');
INSERT INTO met_fdparameter VALUES('3','职务','Duty','4','1','0','1');
INSERT INTO met_fdparameter VALUES('4','Email','Email','5','1','1','1');
INSERT INTO met_fdparameter VALUES('5','电话',' Tel','6','1','0','1');
INSERT INTO met_fdparameter VALUES('6','手机','Mobile','7','1','0','1');
INSERT INTO met_fdparameter VALUES('7','传真','Fax','8','1','0','1');
INSERT INTO met_fdparameter VALUES('8','单位名称','Company','9','1','0','1');
INSERT INTO met_fdparameter VALUES('9','详细地址','Add','11','1','0','1');
INSERT INTO met_fdparameter VALUES('10','邮政编码','Postalcode','12','1','0','1');
INSERT INTO met_fdparameter VALUES('11','省份','Province','10','1','0','2');
INSERT INTO met_fdparameter VALUES('12','反馈类型','Type','1','1','1','2');
INSERT INTO met_fdparameter VALUES('13','','','13','0','0','2');
INSERT INTO met_fdparameter VALUES('14','','','14','0','0','2');
INSERT INTO met_fdparameter VALUES('15','','','15','0','0','2');
INSERT INTO met_fdparameter VALUES('16','信息描述','Infomation','16','1','1','3');
INSERT INTO met_fdparameter VALUES('17','','','17','0','0','3');
INSERT INTO met_fdparameter VALUES('18','','','18','0','0','3');
INSERT INTO met_fdparameter VALUES('19','','','19','0','0','3');
INSERT INTO met_fdparameter VALUES('20','','','20','0','0','3');

DROP TABLE IF EXISTS met_feedback;
CREATE TABLE `met_feedback` (
  `id` int(11) NOT NULL auto_increment,
  `para1` varchar(255) default NULL,
  `para2` varchar(255) default NULL,
  `para3` varchar(255) default NULL,
  `para4` varchar(255) default NULL,
  `para5` varchar(255) default NULL,
  `para6` varchar(255) default NULL,
  `para7` varchar(255) default NULL,
  `para8` varchar(255) default NULL,
  `para9` varchar(255) default NULL,
  `para10` varchar(255) default NULL,
  `para11` varchar(255) default NULL,
  `para12` varchar(255) default NULL,
  `para13` varchar(255) default NULL,
  `para14` varchar(255) default NULL,
  `para15` varchar(255) default NULL,
  `para16` text,
  `para17` text,
  `para18` text,
  `para19` text,
  `para20` text,
  `fdtitle` varchar(255) default NULL,
  `fromurl` varchar(255) default NULL,
  `ip` varchar(255) default NULL,
  `addtime` datetime default NULL,
  `readok` int(11) default '0',
  `useinfo` text,
  `en` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO met_feedback VALUES('1','111','12121','','[e-mail]','','','','','','','湖南','索取资料','','','','ddddd','','','','','关键是变成串的形式以后还能够转化回来--反馈邮件','http://localhost/met/feedback/index.php?title=','127.0.0.1','2009-03-16 13:29:00','0','','');

DROP TABLE IF EXISTS met_img;
CREATE TABLE `met_img` (
  `id` int(11) NOT NULL auto_increment,
  `c_title` varchar(200) default NULL,
  `e_title` varchar(200) default NULL,
  `c_keywords` varchar(200) default NULL,
  `e_keywords` varchar(200) default NULL,
  `c_description` text,
  `e_description` text,
  `c_content` longtext,
  `e_content` longtext,
  `class1` int(11) default '0',
  `class2` int(11) default '0',
  `class3` int(11) default '0',
  `new_ok` int(1) default '0',
  `imgurl` varchar(300) default NULL,
  `imgurls` varchar(300) default NULL,
  `com_ok` int(1) default '0',
  `hits` int(11) default '0',
  `updatetime` datetime default NULL,
  `addtime` datetime default NULL,
  `c_para1` varchar(200) default NULL,
  `c_para2` varchar(200) default NULL,
  `c_para3` varchar(200) default NULL,