/*
 Navicat Premium Data Transfer

 Source Server         : 808
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : 120.24.42.142:3306
 Source Schema         : pain_mask

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 06/10/2021 08:00:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for Pile
-- ----------------------------
DROP TABLE IF EXISTS `Pile`;
CREATE TABLE `Pile`  (
  `Pile_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '表单',
  `Status` int(2) NOT NULL COMMENT '记录三种状态，0：预盘点，1：已盘点，-1：撤销',
  PRIMARY KEY (`Pile_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of Pile
-- ----------------------------
INSERT INTO `Pile` VALUES (1, 1);
INSERT INTO `Pile` VALUES (2, 1);
INSERT INTO `Pile` VALUES (3, 0);
INSERT INTO `Pile` VALUES (4, 0);
INSERT INTO `Pile` VALUES (44, 0);
INSERT INTO `Pile` VALUES (45, 0);
INSERT INTO `Pile` VALUES (46, 0);
INSERT INTO `Pile` VALUES (47, 1);
INSERT INTO `Pile` VALUES (48, 0);
INSERT INTO `Pile` VALUES (49, 1);
INSERT INTO `Pile` VALUES (50, 0);
INSERT INTO `Pile` VALUES (51, 1);

-- ----------------------------
-- Table structure for Product
-- ----------------------------
DROP TABLE IF EXISTS `Product`;
CREATE TABLE `Product`  (
  `Product_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Quantity` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`Product_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of Product
-- ----------------------------
INSERT INTO `Product` VALUES (1, '饼干', 11);
INSERT INTO `Product` VALUES (2, '牛奶', 19);
INSERT INTO `Product` VALUES (3, '饮料', 1);

-- ----------------------------
-- Table structure for StockPile
-- ----------------------------
DROP TABLE IF EXISTS `StockPile`;
CREATE TABLE `StockPile`  (
  `StockPile_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '库存编号',
  `P_Quantity` int(11) NOT NULL COMMENT '所存数量',
  `Product_ID` int(11) NOT NULL COMMENT '商品编号, 外键 ( 参照 PRODUCT 表 )',
  `Pile_ID` int(11) NOT NULL COMMENT '表单',
  PRIMARY KEY (`StockPile_ID`) USING BTREE,
  INDEX `StockPile_Product`(`Product_ID`) USING BTREE,
  INDEX `StockPile_Pile`(`Pile_ID`) USING BTREE,
  CONSTRAINT `StockPile_Pile` FOREIGN KEY (`Pile_ID`) REFERENCES `Pile` (`Pile_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `StockPile_Product` FOREIGN KEY (`Product_ID`) REFERENCES `Product` (`Product_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 145 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of StockPile
-- ----------------------------
INSERT INTO `StockPile` VALUES (11, 11, 1, 1);
INSERT INTO `StockPile` VALUES (104, 22, 2, 1);
INSERT INTO `StockPile` VALUES (105, 33, 3, 1);
INSERT INTO `StockPile` VALUES (116, 1, 2, 1);
INSERT INTO `StockPile` VALUES (117, 1, 3, 1);
INSERT INTO `StockPile` VALUES (118, 23, 2, 1);
INSERT INTO `StockPile` VALUES (119, 55, 3, 1);
INSERT INTO `StockPile` VALUES (120, 100, 1, 1);
INSERT INTO `StockPile` VALUES (121, 23, 3, 1);
INSERT INTO `StockPile` VALUES (122, 44, 2, 1);
INSERT INTO `StockPile` VALUES (123, 7, 2, 1);
INSERT INTO `StockPile` VALUES (124, 1, 1, 1);
INSERT INTO `StockPile` VALUES (125, 1, 2, 1);
INSERT INTO `StockPile` VALUES (126, 55, 2, 1);
INSERT INTO `StockPile` VALUES (127, 333, 2, 1);
INSERT INTO `StockPile` VALUES (128, 8888, 1, 1);
INSERT INTO `StockPile` VALUES (129, 55, 2, 1);
INSERT INTO `StockPile` VALUES (130, 55, 3, 1);
INSERT INTO `StockPile` VALUES (131, 55, 3, 1);
INSERT INTO `StockPile` VALUES (132, 44, 2, 2);
INSERT INTO `StockPile` VALUES (133, 55, 2, 2);
INSERT INTO `StockPile` VALUES (134, 55, 2, 45);
INSERT INTO `StockPile` VALUES (135, 88, 2, 47);
INSERT INTO `StockPile` VALUES (136, 11, 1, 47);
INSERT INTO `StockPile` VALUES (137, 10, 1, 49);
INSERT INTO `StockPile` VALUES (138, 20, 2, 49);
INSERT INTO `StockPile` VALUES (139, 10, 1, 49);
INSERT INTO `StockPile` VALUES (140, 10, 1, 49);
INSERT INTO `StockPile` VALUES (141, 20, 1, 49);
INSERT INTO `StockPile` VALUES (142, 22, 2, 50);
INSERT INTO `StockPile` VALUES (143, 11, 1, 51);
INSERT INTO `StockPile` VALUES (144, 19, 2, 51);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '5445');
INSERT INTO `user` VALUES (2, '5454');
INSERT INTO `user` VALUES (3, '653');
INSERT INTO `user` VALUES (4, '55');
INSERT INTO `user` VALUES (5, '');
INSERT INTO `user` VALUES (6, '');
INSERT INTO `user` VALUES (7, '');

SET FOREIGN_KEY_CHECKS = 1;