DROP TABLE IF EXISTS admin;
CREATE TABLE `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=3 DEFAULT CHARSET=utf8;

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

DROP TABLE IF EXISTS category;
CREATE TABLE `category` (
  `cid` int(11) NOT NULL auto_increment,
  `pcid` int(11) NOT NULL default '0',
  `cname` varchar(50) default NULL,
  `linkture` int(11) default NULL,
  `link` varchar(250) default NULL,
  `keyword` varchar(250) default NULL,
  `info` varchar(250) default NULL,
  `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=utf8;

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

DROP TABLE IF EXISTS diy;
CREATE TABLE `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=utf8;

DROP TABLE IF EXISTS guest;
CREATE TABLE `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` time NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS jss;
CREATE TABLE `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=2 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS news;
CREATE TABLE `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` time 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',
  PRIMARY KEY  (`newsid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS olink;
CREATE TABLE `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 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS system;
CREATE TABLE `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=utf8;

DROP TABLE IF EXISTS tags;
CREATE TABLE `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 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `userpwd` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO admin VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3');
INSERT INTO category VALUES ('1', '0', '新闻', '0', NULL, NULL, NULL, '0', '1', '1', 'templist/newslist.html', 'templist/view.html');
INSERT INTO category VALUES ('2', '0', '产品', '0', NULL, NULL, NULL, '0', '1', '2', 'templist/prolist.html', 'templist/view.html');
INSERT INTO category VALUES ('3', '0', '留言', '1', 'guest.php', NULL, NULL, '0', '1', '3', 'templist/prolist.html', 'templist/view.html');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('1', 'qcms文章测试一',  'qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('2', 'qcms文章测试二',  'qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('3', 'qcms文章测试三',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('4', 'qcms文章测试四',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('5', 'qcms文章测试五',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('6', 'qcms文章测试六',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('7', 'qcms文章测试七',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('8', 'qcms文章测试八',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('9', 'qcms文章测试九',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('10', 'qcms文章测试十',  'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '08:49:09','1');

INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('11', 'qcms产品测试一',  'qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` ,`img`)VALUES ('12', 'qcms产品测试二',  'qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('13', 'qcms产品测试三',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('14', 'qcms产品测试四',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('15', 'qcms产品测试五',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('16', 'qcms产品测试六',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` ,`img`)VALUES ('17', 'qcms产品测试七',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` ,`img`)VALUES ('18', 'qcms产品测试八',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('19', 'qcms产品测试九',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('20', 'qcms产品测试十',  'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '08:49:09','2','images/chanpin.jpg');
INSERT INTO bq VALUES ('1','一个以ASP为蓝本基础技术架构新的PHP版的CMS，比较容易上手，适合网页设计师需要PHP程序环境开发网站。没有下载，分类信息等模块，适合做文章为主的网站。可以方便的更换模板和灵活调用标签。个人企业都免费使用。','qcms简介');
INSERT INTO system VALUES ('1','QCMS网站管理系统','index.php1','templist/index.html','qesy@163.com','QCMS网站管理系统1','QCMS网站管理系统1','Copyright @ www.q-cms.cn 2009. All Rights Reserved.');






