# Host: localhost (Version: 5.5.25a)
# Date: 2017-12-11 05:25:32
# Generator: MySQL-Front 5.3 (Build 2.42)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
DROP DATABASE IF EXISTS `mydb`;
CREATE DATABASE `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `mydb`;
#
# Source for table "blog"
#
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`content` text,
`type` varchar(255) DEFAULT NULL,
`datetime` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "blog"
#
#
# Source for table "cart"
#
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`pname` varchar(255) DEFAULT NULL,
`pprice` varchar(255) DEFAULT NULL,
`pnum` varchar(255) DEFAULT NULL,
`pmode` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
#
# Data for table "cart"
#
INSERT INTO `cart` VALUES (1,'zhangsan','鞋子','188','2','防水闪光'),(2,'zhangsan','鞋子','188','2','耐脏防水'),(3,'zhangsan','步步高运动鞋','200','1','防水闪光'),(4,'zhangsan','步步高运动鞋','200','1','动感'),(5,'zhangsan','三星运动鞋','200','3','动感耐脏'),(6,'zhangsan','耐克鞋','188','1','动感'),(7,'zhangsan','耐克鞋','188','1','动感耐脏防水');
#
# Source for table "comment"
#
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`content` text,
`blog` varchar(255) DEFAULT NULL,
`datetime` varchar(255) DEFAULT NULL,
`user` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "comment"
#
#
# Source for table "myuser"
#
DROP TABLE IF EXISTS `myuser`;
CREATE TABLE `myuser` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`type` int(11) DEFAULT '0',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
#
# Data for table "myuser"
#
INSERT INTO `myuser` VALUES (1,'zhangsan','456',0),(4,'呵呵','123',0),(5,'哈哈','123',0),(6,'我是谁 ','123',0),(9,'2','22',0),(10,'张三丰','123',1),(12,'zhangsan1','123',0),(14,'zaaaa','aaaa',0),(15,'zzzzzzz','zzzz',0),(16,'zzzz','4444',0),(17,'ssss','sssss',0),(18,'ddddd','dddd',0);
#
# Source for table "news"
#
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`datetime` varchar(255) DEFAULT NULL,
`times` varchar(255) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
#
# Data for table "news"
#
INSERT INTO `news` VALUES (1,'ddd','dddddd','2017-11-21 13:35:22','0','ntk2503.jpg'),(2,'sss','ssss','2017-11-21 13:41:09','0','ninja148637318694673.jpg');
#
# Source for table "product"
#
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`pname` varchar(255) DEFAULT NULL,
`pprice` varchar(255) DEFAULT NULL,
`pnum` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
#
# Data for table "product"
#
INSERT INTO `product` VALUES (1,'耐克鞋','188','20'),(2,'步步高运动鞋','200','50'),(3,'匹克鞋','100','40'),(4,'三星运动鞋','200','30');
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
