数据库文件/transaction.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50130
Source Host           : localhost:3306
Source Database       : transaction

Target Server Type    : MYSQL
Target Server Version : 50130
File Encoding         : 65001

Date: 2017-11-03 22:24:01
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `adminId` char(32) NOT NULL,
  `adminName` varchar(32) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`adminId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('2', '王俊', '12345678');
INSERT INTO `admin` VALUES ('3', 'hello', '12345678');

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `cartId` char(32) NOT NULL,
  `userId` char(32) DEFAULT NULL,
  `goodsId` char(32) DEFAULT NULL,
  `quantity` int(10) DEFAULT NULL,
  PRIMARY KEY (`cartId`),
  KEY `userId` (`userId`),
  KEY `goodsId` (`goodsId`),
  CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`uid`),
  CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`goodsId`) REFERENCES `goods` (`goodsId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cart
-- ----------------------------
INSERT INTO `cart` VALUES ('35C93EE899A14B80BFC88B0A39ACAF43', '420854A825D14C3F93DEB725567A48A1', 'D9F9554424804465898939FE46EC5B4D', '1');
INSERT INTO `cart` VALUES ('47FAB3054FE24F87BD7021B72CEA5E83', '420854A825D14C3F93DEB725567A48A1', '13FBF28E608D438286CA35F1B1543FE6', '1');
INSERT INTO `cart` VALUES ('6FFB0B76769F4BAF8DA494A9B20A8D7D', '5B5215596F8E4899AB48620749DDFCEC', '40BAAC5ABC7A43D8947B9C919D614041', '1');
INSERT INTO `cart` VALUES ('8C88045831274C6CB6B6F11B9E47ABFE', '420854A825D14C3F93DEB725567A48A1', 'CA07FE50868B4012BC279676614904FB', '2');
INSERT INTO `cart` VALUES ('9C1863039DFD4CDE9C61DBC0B34647EF', 'ECA7FF703F714239B7EBF786F42A4259', '3EB228B679B241629FDE2660F33A3A33', '0');
INSERT INTO `cart` VALUES ('9C2174311DE643C09DC9947E9C9331F6', '5B5215596F8E4899AB48620749DDFCEC', '247B6BC71A9C4088901B779045B3208B', '3');
INSERT INTO `cart` VALUES ('9ECE976648C0452F93AC442600772C3E', '7D3CBCF7050F42A0AF89B15971B706DA', '3EB228B679B241629FDE2660F33A3A33', '2');