代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : remote
Source Server Version : 50534
Source Host : 120.27.101.70:3306
Source Database : fashion
Target Server Type : MYSQL
Target Server Version : 50534
File Encoding : 65001
Date: 2017-05-03 20:43:54
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
`admin_name` varchar(20) NOT NULL,
`admin_pwd` varchar(20) NOT NULL,
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin');
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`category_id` int(4) NOT NULL AUTO_INCREMENT,
`category_name` varchar(16) NOT NULL,
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '二胡');
INSERT INTO `category` VALUES ('2', '小提琴');
INSERT INTO `category` VALUES ('3', '吉他');
INSERT INTO `category` VALUES ('4', '钢琴');
INSERT INTO `category` VALUES ('5', '琵琶');
INSERT INTO `category` VALUES ('6', '古筝');
-- ----------------------------
-- Table structure for floor
-- ----------------------------
DROP TABLE IF EXISTS `floor`;
CREATE TABLE `floor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`t_id` int(11) NOT NULL,
`createTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`num` int(11) DEFAULT '1',
`context` text COLLATE utf8_unicode_ci,
`user_id` int(11) DEFAULT NULL,
`user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `TK_t_id` (`t_id`),
CONSTRAINT `TK_t_id` FOREIGN KEY (`t_id`) REFERENCES `tz` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of floor
-- ----------------------------
INSERT INTO `floor` VALUES ('1', '1', '2017-04-24 21:17:39', '1', '测试内容', '0', '管理员');
INSERT INTO `floor` VALUES ('2', '3', '2017-04-25 03:39:27', '1', 'testtest', '22', 'pzqu@qq.com');
INSERT INTO `floor` VALUES ('3', '3', '2017-04-25 16:19:38', '2', '抢个沙发', '22', 'pzqu@qq.com');
INSERT INTO `floor` VALUES ('4', '4', '2017-04-25 16:21:14', '1', '我就是试试', '22', 'pzqu@qq.com');
-- ----------------------------
-- Table structure for order_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail` (
`o_id` int(4) NOT NULL,
`p_id` int(4) NOT NULL,
`p_count` int(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`o_id`,`p_id`),
KEY `FK_order_detail` (`o_id`),
KEY `order_detail` (`p_id`),
CONSTRAINT `FK_o_id` FOREIGN KEY (`o_id`) REFERENCES `orders` (`od_id`),
CONSTRAINT `FK_p_id` FOREIGN KEY (`p_id`) REFERENCES `products` (`prdct_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_detail
-- ----------------------------
INSERT INTO `order_detail` VALUES ('12', '10', '3');
INSERT INTO `order_detail` VALUES ('12', '14', '1');
INSERT INTO `order_detail` VALUES ('13', '2', '5');
INSERT INTO `order_detail` VALUES ('13', '4', '2');
INSERT INTO `order_detail` VALUES ('13', '7', '1');
INSERT INTO `order_detail` VALUES ('13', '10', '4');
INSERT INTO `order_detail` VALUES ('13', '14', '1');
INSERT INTO `order_detail` VALUES ('17', '4', '1');
INSERT INTO `order_detail` VALUES ('17', '8', '1');
INSERT INTO `order_detail` VALUES ('18', '2', '2');
INSERT INTO `order_detail` VALUES ('18', '10', '2');
INSERT INTO `order_detail` VALUES ('19', '2', '1');
INSERT INTO `order_detail` VALUES ('21', '7', '1');
INSERT INTO `order_detail` VALUES ('22', '15', '2');
INSERT INTO `order_detail` VALUES ('23', '15', '6');
INSERT INTO `order_detail` VALUES ('25', '2', '1');
INSERT INTO `order_detail` VALUES ('26', '17', '1');
INSERT INTO `order_detail` VALUES ('27', '17', '1');
INSERT INTO `order_detail` VALUES ('28', '4', '1');
INSERT INTO `order_detail` VALUES ('28', '10', '5');
INSERT INTO `order_detail` VALUES ('28', '18', '1');
-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`od_id` int(4) NOT NULL AUTO_INCREMENT,
`od_no` varchar(30) DEFAULT NULL,
`user_id` int(4) DEFAULT NULL,
`od_date` varchar(30) DEFAULT '2015-05-27 18:09:39',
`od_money` double DEFAULT NULL,
`od_state` varchar(16) DEFAULT '等待付款',
`od_receiver` varchar(20) DEFAULT NULL,
`od_address` varchar(200) DEFAULT NULL,
`od_phone` varchar(11) DEFAULT NULL,
PRIMARY KEY (`od_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('12', '20150512235247', '1', '2015-05-12 23:52:47', '142.3', '交易完成', '袁健', '上海市浦东新区金海路2360号', '18817800168');
INSERT INTO `orders` VALUES ('13', '20150513002906', '20', '2015-05-13 00:29:06', '884.5', '已发货', '朱嘉艺', '江苏省南通市吕四港镇吕滨村6组', '13052395439');
INSERT INTO `orders` VALUES ('14', '20150513081725', '1', '2015-05-13 08:17:25', '22', '已取消', 'yuanji', 'yuj', '1881');
INSERT INTO `orders` VALUES ('16', '20150513085438', '1', '2015-05-13 08:54:38', '4.2', '已取消', '1', '1', '1');
INSERT INTO `orders` VALUES ('17', '20150513101625', '1', '2015-05-13 10:16:25', '33.1', '已取消', 'fsd', 'fdsf', '18817800168');
INSERT INTO `orders` VALUES ('18', '20150513101956', '1', '2015-05-13 10:19:56', '288.2', '等待发货', 'fs', 'sdf', '18817800168');
INSERT INTO `orders` VALUES ('19', '20150513102102', '1', '2015-05-13 10:21:02', '122', '交易完成', 'f', 'fs', '18817800168');
INSERT INTO `orders` VALUES ('21', '20150513170411', '20', '2015-05-13 17:04:11', '22.1', '等待发货', '袁健', '上海', '13052395439');
INSERT INTO `orders` VALUES ('22', '20150513211817', '1', '2015-05-13 21:18:17', '1140', '已取消', '袁健', '上海', '18817800168');
INSERT INTO `orders` VALUES ('23', '20150513234117', '1', '2015-05-13 23:41:17', '720', '已发货', '袁健', '上海', '18817800168');
INSERT INTO `orders` VALUES ('24', '20150513234214', '1', '2015-05-13 23:42:14', '1200', '等待付款', '袁健', '上海', '18817800168');
INSERT INTO `orders` VALUES ('25', '20150513235631', '1', '2015-05-13 23:56:31', '122', '已取消', '1', '1', '1');
INSERT INTO `orders` VALUES ('26', '20170421220239', '1', '2017-04-21 22:02:39', '600', '等待发货', '倩', '十里桃花园', '15829231820');
INSERT INTO `orders` VALUES ('27', '20170421220504', '1', '2017-04-21 22:05:04', '600', '已发货', '幸宝', '十里桃花园', '15819131821');
INSERT INTO `orders` VALUES ('28', '20170422210345', '21', '2017-04-22 21:03:45', '476.80000000000007', '等待付款', '123', '12434564', '13254345');
-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`prdct_id` int(4) NOT NULL AUTO_INCREMENT,
`prdct_name` varchar(100) NOT NULL,
`prdct_price` double DEFAULT '1',
`prdct_special` varchar(4) DEFAULT '0',
`prdct_stock` int(4) DEFAULT '1',
`prdct_view` int(4) DEFAULT '0',
`prdct_buy` int(4) DEFAULT '0',
`prdct_date` varchar(30) DEFAULT '2015-05-07 00:00:00',
`prdct_img` varchar(200) DEFAULT 'default.jpg',
`prdct_intro` varchar(200) DEFAULT '暂无信息',
`catg_id` int(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`prdct_id`),
KEY `FK_products` (`catg_id`),
CONSTRAINT `FK_products` FOREIGN KEY (`catg_id`) REFERENCES `category` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES ('2', ' 二胡', '122', '1', '98', '24', '4', '2017-04-21 21:37:51', 'p1.jpg', '二胡，始于唐朝，称“奚琴\"，至今已有一千多年的历史。是一种中国传统拉弦乐器。二胡，即二弦胡琴，又名“南胡”、嗡子，二胡是中华民族乐器家族中主要的弓弦乐器（擦弦乐器）之一。', '1');
INSERT INTO `products` VALUES ('4', ' 二胡1', '22.1', '1', '119', '39', '2', '2015-05-27 18:09:39', 'p1.jpg', '声音好听', '1');
INSERT INTO `products` VALUES ('7', ' 二胡1', '22.1', '0', '11', '18', '3', '2015-05-27 00:02:00', 'p1.jpg', '声音好听', '1');
INSERT INTO `products` VALUES ('8', ' 二胡1', '22.1', '1', '120', '34', '1', '2015-05-27 18:09:39', 'p1.jpg', '声音好听', '1');
INSERT INTO `products` VALUES ('9', ' 二胡1', '22.1', '0', '12', '26', '1', '2015-05-07 18:09:14', 'p1.jpg', '声音好听', '1');
INSERT INTO `products` VALUES ('10', ' 二胡1', '22.1', '0', '8', '23', '8', '2015-05-07 18:11:09', 'p1.jpg', '声音好听', '1');
INSERT INTO `products` VALUES ('14', '吉他', '32', '1', '1', '35', '6', '2017-04-21 21:46:36', '20150510175557.jpg', '吉他（意大利语：Chitarra），又译为结他或六弦琴。是一种弹拨乐器，通常有六条弦，形状与提琴相似。\r\n吉他在流行音乐、摇滚音乐、蓝调、民歌、佛朗明哥中，常被视为主要乐器。而在古典音乐的领域里，吉他常以独奏或二重奏的型式演出；当然，在室内乐和管弦乐中，吉他亦扮演着相当程度的陪衬角色。\r\n古典吉他与小提琴、钢琴并列为世界著名三大乐器。', '3');
INSERT INTO `products` VALUES ('15', '钢琴', '120', '1', '90', '6', '10', '2017-04-22 21:18:50', '20150513201027.jpg', '声音好听', '4');
INSERT INTO `products` VALUES ('17', '小提琴', '600', '0', '18', '2', '2', '2017-04-21 21:22:41', '20170421212241.jpg', '小提琴广泛流传于世界各国，是现代管弦乐队弦乐组中最主要的乐器。它在器乐中占非常重要的地位，是现代交响乐队的支柱，也是具有高难度演奏技巧的独奏乐器，与钢琴、古典吉他并称为世界三大乐器。', '2');
INSERT INTO `products` VALUES ('18', '钢琴', '300', '0', '22', '0', '1', '2017-04-21 21:44:23', '20170421214423.jpg', '钢琴音域范围从A2（27.5Hz）至 c5（4186Hz），几乎囊括了乐音体系中的全部乐音，是除了管风琴以外音域最广的乐器。钢琴普遍用于独奏、重奏、伴奏等演出，作曲和排练音乐十分方便。演奏者通过按下键盘上的琴键，牵动钢琴里面包着绒毡的小木槌，继而敲击钢丝弦发出声音。钢琴需定时的护理，来保证它的音色不变。', '4');
INSERT INTO `products` VALUES ('19', '吉他', '1000', '1', '33', '1', '0', '2017-04-21 21:45:58', '20170421214558.jpg', '吉他（意大利语：Chitarra），又译为结他或六弦琴。是一种弹拨乐器，通常有六条弦，形状与提琴相似。\r\n吉他在流行音乐、摇滚音乐、蓝调、民歌、佛朗明哥中，常被视为主要乐器。而在古典音乐的领域里，吉他常以独奏或二重奏的型式演出；当然，在室内乐和管弦乐中，吉他亦扮演着相当程度的陪衬角色。\r\n古典吉他与小提琴、钢琴并列为世界著名三大乐器。', '3');
-- ----------------------------
-- Table structure for section
-- ----------------------------
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`tz_num` int(11) DEFAULT '0',
`floor_num` int(11) DEFAULT '0',
`tz_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT '新开版块',
`lastTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT '管理员',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of section
-- ----------------------------
INSERT INTO `section` VALUES ('1', '版块1', '4', '4', 'test1', '2017-04-25 16:19:38', 'pzqu@qq.com');
INSERT INTO `section` VALUES ('2', '版块2', '0', '0', '新开版块', '2017-04-24 18:02:20', '管理员');
INSERT INTO `section` VALUES ('3', '版块3', '0', '0', '新开版块', '2017-04-24 18:02:28', '管理员');
INSERT INTO `section` VALUES ('4', '版块4', '1', '1', '换个版块发帖', '2017-04-25 16:21:14', 'pzqu@qq.com');
INSERT INTO `section` VALUES ('5', ' 版块5', '0', '0', '新开版块', '2017-04-24 18:02:30', '管理员');
-- ----------------------------
-- Table structure for tz
-- ----------------------------
DROP TABLE IF EXISTS `tz`;
CREATE TABLE `tz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`b_id` int(11) NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`createTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`lastTime` timestamp NULL DEFAULT NULL,
`reply_num` int(11) NOT NULL DEFAULT '0',
`click_num` int(11) NOT NULL DEFAULT '0',
`ishot` int(11) NOT NULL DEFAULT '0',
`isgood` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `TK_b_id` (`b_id`),
CONSTRAINT `TK_b_id` FOREIGN KEY (`b_id`) REFERENCES `section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tz
-- ----------------------------
INSERT INTO `tz` VALUES ('1', '1', '测试帖子', ' 测试内容', '0', ' 管理员', ' 管理员', '2017-04-25 02:43:17', '2017-04-24 21:17:14', '0', '2', '0', '0');
INSERT INTO `tz` VALUES ('3', '1', 'test1', 'testtest', '22', 'pzqu@qq.com', 'pzqu@qq.com', '2017-04-25 03:39:27', '2017-04-25 16:19:38', '1', '55', '0', '0');
INSERT INTO `tz` VALUES ('4', '4', '换个版块发帖', '我就是试试', '22', 'pzqu@qq.com', 'pzqu@qq.com', '2017-04-25 16:21:14', '2017-04-25 16:21:14', '0', '2', '0', '0');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) NOT NULL,
`user_pwd` varchar(20) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('7', 'fffds2f@aa.com', '123456');
INSERT INTO `users` VALUES ('13', 'fsfsd', '1');
INSERT INTO `users` VALUES ('14', 'fsdfsf', '1');
INSERT INTO `users` VALUES ('15', 'a@qq.com', 'yuanjian');
INSERT INTO `users` VALUES ('16', '232423@qq.com', 'yuanjian');
INSERT INTO `users` VALUES ('17', 'fsdf@qq.com', 'yuanjian');
INSERT INTO `users` VALUES ('18', 'ffsdf@qq.com', 'yuanjian');
INSERT INTO `users` VALUES ('19', 'yuanjian323@qq.com', 'yuanjian');
INSERT INTO `users` VALUES ('20', 'yiff@163.com', 'yuanjian');
INSERT INTO `users` VALUES ('21', '1679433698@qq.com', '123456');
INSERT INTO `users` VALUES ('22', 'pzqu@qq.com', '123123');
INSERT INTO `users` VALUES ('23', '123456@qq.com', '123456');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手