DROP TABLE IF EXISTS bqz_qcms_admin;
CREATE TABLE `bqz_qcms_admin` (
  `id` int(11) NOT NULL auto_increment,
  `admin_name` varchar(50) NOT NULL,
  `admin_password` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_bq;
CREATE TABLE `bqz_qcms_bq` (
  `id` int(11) NOT NULL auto_increment,
  `bq` text NOT NULL,
  `names` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_category;
CREATE TABLE `bqz_qcms_category` (
  `cid` int(11) NOT NULL auto_increment,
  `pcid` int(11) NOT NULL default '0',
  `cname` varchar(50) default NULL,
  `cimg` varchar(250) NOT NULL,
  `curl` varchar(250) NOT NULL,
  `linkture` int(11) default NULL,
  `link` varchar(250) default NULL,
  `keyword` varchar(250) default NULL,
  `info` text,
  `types` int(11) default '0',
  `ons` int(11) default NULL,
  `px` int(11) default NULL,
  `ctemp` varchar(250) default NULL,
  `ntemp` varchar(250) default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_discuss;
CREATE TABLE `bqz_qcms_discuss` (
  `did` int(11) NOT NULL auto_increment,
  `posttime` varchar(50) NOT NULL,
  `poster` varchar(50) NOT NULL,
  `dcontent` text NOT NULL,
  `newsid` int(11) NOT NULL,
  PRIMARY KEY  (`did`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_diy;
CREATE TABLE `bqz_qcms_diy` (
  `id` int(11) NOT NULL auto_increment,
  `names` varchar(50) NOT NULL,
  `diy` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_guest;
CREATE TABLE `bqz_qcms_guest` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(250) default NULL,
  `name` varchar(50) default NULL,
  `tel` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  `qq` int(12) default NULL,
  `ip` varchar(50) default NULL,
  `hf` text,
  `content` text,
  `times` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_jss;
CREATE TABLE `bqz_qcms_jss` (
  `id` int(11) NOT NULL auto_increment,
  `js_name` varchar(50) NOT NULL,
  `js_code` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_news;
CREATE TABLE `bqz_qcms_news` (
  `newsid` int(11) NOT NULL auto_increment,
  `ntitle` varchar(250) NOT NULL,
  `nkeyword` varchar(250) default NULL,
  `ninfo` varchar(250) default NULL,
  `ncontent` text NOT NULL,
  `posttime` varchar(250) default NULL,
  `types` int(11) default '0',
  `cid` int(11) default '0',
  `attpic` int(11) default '0',
  `readcount` int(11) default '0',
  `img` varchar(250) default NULL,
  `tuijian` int(11) default '0',
  `pinyin` varchar(250) NULL,
  PRIMARY KEY  (`newsid`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_olink;
CREATE TABLE `bqz_qcms_olink` (
  `id` int(11) NOT NULL auto_increment,
  `link_name` varchar(50) NOT NULL,
  `link_url` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_system;
CREATE TABLE `bqz_qcms_system` (
  `id` int(11) NOT NULL auto_increment,
  `webname` varchar(50) NOT NULL,
  `index` varchar(50) NOT NULL,
  `itemp` varchar(250) NOT NULL,
  `email` varchar(50) NOT NULL,
  `keywords` varchar(250) NOT NULL,
  `info` varchar(250) NOT NULL,
  `copyright` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_tags;
CREATE TABLE `bqz_qcms_tags` (
  `id` int(11) NOT NULL auto_increment,
  `tag_name` varchar(50) NOT NULL,
  `tag_num` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_users;
CREATE TABLE `bqz_qcms_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `userpwd` varchar(50) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `email` varchar(50) NOT NULL,
  `qq` varchar(50) NOT NULL,
  `tel` varchar(50) NOT NULL,
  `truename` varchar(50) NOT NULL,
  `address` varchar(250) NOT NULL,
  `money` int(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;

DROP TABLE IF EXISTS bqz_qcms_plus;
CREATE TABLE `bqz_qcms_plus` (
  `id` int(11) NOT NULL auto_increment,
  `plus_name` VARCHAR( 50 ) NOT NULL,
  `plus_manage` VARCHAR( 250 ) NOT NULL,
  `plus_setup` VARCHAR( 250 ) NOT NULL,
  `plus_on` INT( 10 ) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;

INSERT INTO bqz_qcms_admin VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3');

INSERT INTO bqz_qcms_category VALUES ('1','0','','','/xinwen/','0','','','','0','1','1','newslist.html','view.html');
INSERT INTO bqz_qcms_category VALUES ('2','0','Ʒ','','/chanpin/','0','','','','0','1','2','prolist.html','view.html');
INSERT INTO bqz_qcms_category VALUES ('3','0','','','/liuyan/','1','guest.php','','','0','1','3','prolist.html','view.html');

INSERT INTO bqz_qcms_news VALUES ('1','qcms²һ','{1}','','qcms²һqcms²һqcms²һqcms²һqcms²һqcms²һ','1257127440','0','1','0','0','','0','qcmswenzhangceshiyi');
INSERT INTO bqz_qcms_news VALUES ('2','qcms²Զ','','','qcms²Զqcms²Զqcms²Զqcms²Զqcms²Զqcms²Զ','1244011261','0','1','0','0','','0','qcmswenzhangceshier');
INSERT INTO bqz_qcms_news VALUES ('3','qcms²','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshisan');
INSERT INTO bqz_qcms_news VALUES ('4','qcms²','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshisi');
INSERT INTO bqz_qcms_news VALUES ('5','qcms²','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshiwu');
INSERT INTO bqz_qcms_news VALUES ('7','qcms²','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshiqi');
INSERT INTO bqz_qcms_news VALUES ('8','qcms²԰','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshiba');
INSERT INTO bqz_qcms_news VALUES ('9','qcms²Ծ','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshijiu');
INSERT INTO bqz_qcms_news VALUES ('10','qcms²ʮ','','','qcms²qcms²qcms²qcms²qcms²qcms²','1244011261','0','1','0','0','','0','qcmswenzhangceshishi');
INSERT INTO bqz_qcms_news VALUES ('11','qcmsƷһ','','','qcmsƷһqcmsƷһqcmsƷһqcmsƷһqcmsƷһqcmsƷһ','1244011261','0','2','0','0','images/chanpin.jpg','0','qcmschanpinceshiyi');
INSERT INTO bqz_qcms_news VALUES ('12','qcmsƷԶ','','','qcmsƷԶqcmsƷԶqcmsƷԶqcmsƷԶqcmsƷԶqcmsƷԶ','1244011261','0','2','0','0','images/chanpin.jpg','0','qcmschanpinceshier');
INSERT INTO bqz_qcms_news VALUES ('13','qcmsƷ','','','qcmsƷqcmsƷqcmsƷqcmsƷqcmsƷqcmsƷ','1244011261','0','2','0','0','images/chanpin.jpg','0','qcmschanpinceshisan');
INSERT INTO bqz_qcms_news VALUES ('14','qcmsƷ','','','qcmsƷqcmsƷqcmsƷqcmsƷqcmsƷqcmsƷ','1244011261','0','2','0','0','images/chanpin.jpg','0','qcmschanpinceshisi');
INSERT INTO bqz_qcms_news VALUES ('15','qcmsƷ','','','qcmsƷqcmsƷqcmsƷqcmsƷqcmsƷqcmsƷ','1244011261','0','2','0','0','images/chanpin.jpg','0','qcmschanpinceshiwu');

INSERT INTO bqz_qcms_system VALUES ('1','QCMSվϵͳ','index.php','index.html','qesy@163.com','QCMSվϵͳ','QCMSվϵͳ','Copyright @ www.q-cms.cn 2009. All Rights Reserved.');