/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50638
Source Host : localhost:3306
Source Database : rsfms
Target Server Type : MYSQL
Target Server Version : 50638
File Encoding : 65001
Date: 2018-06-12 15:04:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`aid` int(2) NOT NULL AUTO_INCREMENT,
`aname` varchar(10) COLLATE utf8_bin DEFAULT NULL,
`sex` varchar(6) COLLATE utf8_bin DEFAULT NULL,
`age` int(2) DEFAULT NULL,
`phone` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`grade` int(2) DEFAULT NULL,
`apass` varchar(10) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', '1', null, null, null, null, '1');
INSERT INTO `admin` VALUES ('2', '你猜', '0', '22', '大盗', '1', '222222222');
INSERT INTO `admin` VALUES ('3', 'cc', '0', '34', '34343', '1', '2222');
INSERT INTO `admin` VALUES ('4', 'dasdad', '0', '3434', 'dsa', '1', '44444');
INSERT INTO `admin` VALUES ('5', 'dasdad', '0', '3434', 'dsa', '1', '44444');
-- ----------------------------
-- Table structure for buy
-- ----------------------------
DROP TABLE IF EXISTS `buy`;
CREATE TABLE `buy` (
`meid` int(10) NOT NULL AUTO_INCREMENT,
`mename` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`meprice` int(10) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`bnub` int(10) DEFAULT NULL,
`menub` int(10) DEFAULT NULL,
PRIMARY KEY (`meid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of buy
-- ----------------------------
-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
`grade` int(2) NOT NULL,
`gradename` varchar(10) COLLATE utf8_bin NOT NULL,
`incentive` int(3) DEFAULT NULL,
PRIMARY KEY (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of grade
-- ----------------------------
INSERT INTO `grade` VALUES ('0', '普通', null);
INSERT INTO `grade` VALUES ('1', '超级', null);
-- ----------------------------
-- Table structure for jilu
-- ----------------------------
DROP TABLE IF EXISTS `jilu`;
CREATE TABLE `jilu` (
`meid` int(10) NOT NULL AUTO_INCREMENT,
`mename` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`meprice` int(10) DEFAULT NULL,
`time` datetime DEFAULT NULL,
`bnub` int(10) DEFAULT NULL,
PRIMARY KEY (`meid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of jilu
-- ----------------------------
INSERT INTO `jilu` VALUES ('3', '3333', '333', '2018-06-12 13:53:51', '1');
INSERT INTO `jilu` VALUES ('4', '4666', '888', '2018-06-12 13:54:49', '1');
INSERT INTO `jilu` VALUES ('5', '4666', '888', '2018-06-12 13:55:43', '1');
INSERT INTO `jilu` VALUES ('6', '3333', '333', '2018-06-12 13:57:24', '1');
INSERT INTO `jilu` VALUES ('7', '4666', '888', '2018-06-12 13:57:30', '1');
INSERT INTO `jilu` VALUES ('8', '3333', '333', '2018-06-12 14:22:26', '1');
-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
`mid` int(5) NOT NULL AUTO_INCREMENT,
`mname` varchar(10) COLLATE utf8_bin NOT NULL,
`sex` varchar(6) COLLATE utf8_bin DEFAULT NULL,
`age` int(2) DEFAULT NULL,
`phone` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`grade` int(2) DEFAULT NULL,
`Cardpass` varchar(11) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`mid`),
KEY `grade` (`grade`),
CONSTRAINT `member_ibfk_1` FOREIGN KEY (`grade`) REFERENCES `grade` (`grade`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of member
-- ----------------------------
INSERT INTO `member` VALUES ('2', '2', '0', '22', '2222222', '0', '2');
INSERT INTO `member` VALUES ('3', '21', '0', '22', '2222222', '0', '3');
INSERT INTO `member` VALUES ('4', '我的', '0', '22', '2222222', '0', '2');
INSERT INTO `member` VALUES ('5', 'dasdad', '0', '3434', 'dsa', '0', '44444');
-- ----------------------------
-- Table structure for merchandise
-- ----------------------------
DROP TABLE IF EXISTS `merchandise`;
CREATE TABLE `merchandise` (
`meid` int(10) NOT NULL AUTO_INCREMENT,
`mename` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`meprice` int(10) DEFAULT NULL,
`menub` int(10) DEFAULT NULL,
PRIMARY KEY (`meid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of merchandise
-- ----------------------------
INSERT INTO `merchandise` VALUES ('1', '双排轮滑', '15', '3');
INSERT INTO `merchandise` VALUES ('2', '3333', '333', '4');
INSERT INTO `merchandise` VALUES ('4', '4666', '888', '5');