-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- 主机: sql.m762.vhostgo.com
-- 生成日期: 2025-08-04 11:29:37
-- 服务器版本: 5.6.51
-- PHP 版本: 7.2.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 utf8mb4 */;
--
-- 数据库: `winstin`
--
-- --------------------------------------------------------
--
-- 表的结构 `bancai`
--
CREATE TABLE `bancai` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`houdu` double DEFAULT NULL,
`caizhi_id` int(11) DEFAULT NULL,
`kucun_id` int(11) DEFAULT NULL,
`mupi1_id` int(11) DEFAULT NULL,
`mupi2_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `bancai`
--
INSERT INTO `bancai` (`id`, `deleted`, `deleted_at`, `last_updated`, `houdu`, `caizhi_id`, `kucun_id`, `mupi1_id`, `mupi2_id`) VALUES
(1, 0, NULL, '2025-06-29 19:58:31', 15, 1, NULL, 1, 1),
(2, 0, NULL, '2025-07-01 07:43:57', 3, 1, NULL, 2, 2),
(5, 0, NULL, '2025-07-01 12:33:30', 3, 1, NULL, 2, 3),
(6, 0, NULL, '2025-07-01 12:36:40', 3, 1, NULL, 4, 2),
(7, 0, NULL, '2025-07-01 12:43:47', 5, 1, NULL, 2, 2),
(8, 0, NULL, '2025-07-01 12:46:40', 5, 1, NULL, 2, 5),
(9, 0, NULL, '2025-07-01 12:49:02', 6, 1, NULL, 2, 2),
(10, 0, NULL, '2025-07-01 12:49:29', 6, 1, NULL, 1, 2),
(26, 0, NULL, '2025-07-02 11:38:06', 6, 1, NULL, 2, 7),
(27, 0, NULL, '2025-07-02 11:40:24', 6, 1, NULL, 2, 8),
(28, 0, NULL, '2025-07-02 11:44:33', 6, 1, NULL, 1, 5),
(29, 0, NULL, '2025-07-02 11:46:27', 9, 1, NULL, 9, 5),
(30, 0, NULL, '2025-07-02 11:46:47', 9, 1, NULL, 2, 5),
(31, 0, NULL, '2025-07-02 11:47:00', 9, 1, NULL, 2, 2),
(32, 0, NULL, '2025-07-02 11:47:13', 9, 1, NULL, 2, 3),
(33, 0, NULL, '2025-07-02 11:51:16', 12, 1, NULL, 1, 2),
(34, 0, NULL, '2025-07-02 11:51:38', 15, 1, NULL, 2, 8),
(35, 0, NULL, '2025-07-02 11:52:03', 15, 1, NULL, 1, 5),
(36, 0, NULL, '2025-07-02 11:52:23', 15, 1, NULL, 1, 2),
(37, 0, NULL, '2025-07-02 11:53:16', 18, 1, NULL, 9, 2),
(38, 0, NULL, '2025-07-02 11:53:31', 18, 1, NULL, 2, 2),
(39, 0, NULL, '2025-07-02 12:23:46', 55, 1, NULL, 2, 3),
(40, 0, NULL, '2025-07-02 12:57:24', 15, 1, NULL, 2, 7),
(41, 0, NULL, '2025-07-02 13:07:13', 3, 1, NULL, 1, 3),
(42, 0, NULL, '2025-07-02 13:07:30', 5, 1, NULL, 4, 2),
(43, 0, NULL, '2025-07-02 13:08:10', 6, 1, NULL, 1, 1),
(44, 0, NULL, '2025-07-02 13:08:22', 9, 1, NULL, 1, 1),
(45, 0, NULL, '2025-07-02 13:09:42', 5, 1, NULL, 4, 13),
(46, 0, NULL, '2025-07-02 13:09:55', 12, 1, NULL, 4, 13),
(47, 0, NULL, '2025-07-02 13:10:09', 18, 1, NULL, 1, 1),
(49, 0, NULL, '2025-07-02 13:20:03', 6, 1, NULL, 4, 5),
(56, 0, NULL, '2025-07-03 02:10:26', 9, 1, NULL, 4, 7),
(57, 0, NULL, '2025-07-03 02:11:42', 15, 1, NULL, 4, 7),
(58, 0, NULL, '2025-07-03 03:29:35', 9, 1, NULL, 2, 14),
(59, 0, NULL, '2025-07-08 14:33:23', 88888, 2, NULL, 2, 3);
-- --------------------------------------------------------
--
-- 表的结构 `caizhi`
--
CREATE TABLE `caizhi` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `caizhi`
--
INSERT INTO `caizhi` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`) VALUES
(1, 0, NULL, '2025-06-29 19:58:33', '纤维板'),
(2, 0, NULL, '2025-07-01 12:35:55', '香杉');
-- --------------------------------------------------------
--
-- 表的结构 `chanpin`
--
CREATE TABLE `chanpin` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`bianhao` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `chanpin`
--
INSERT INTO `chanpin` (`id`, `deleted`, `deleted_at`, `last_updated`, `bianhao`) VALUES
(1, 0, NULL, '2025-06-29 19:58:34', 'AN-1210'),
(2, 0, NULL, '2025-06-30 07:09:34', 'AN-1208'),
(3, 0, NULL, '2025-07-01 07:39:46', 'AN-1140'),
(4, 0, NULL, '2025-07-01 12:30:30', 'AN-1133'),
(5, 0, NULL, '2025-07-01 12:34:49', 'AN-1157'),
(6, 0, NULL, '2025-07-01 12:37:35', 'AN-1159'),
(7, 0, NULL, '2025-07-01 12:43:09', 'AN-1212'),
(8, 0, NULL, '2025-07-02 13:05:30', 'AN-1081-H'),
(9, 0, NULL, '2025-07-02 13:06:11', 'AP-1109-H'),
(10, 0, NULL, '2025-07-02 13:19:23', 'AP-1278'),
(11, 0, NULL, '2025-07-02 13:23:57', 'AP-1271'),
(13, 0, NULL, '2025-07-03 03:24:33', 'AN-1032'),
(14, 0, NULL, '2025-08-04 02:13:39', 'sssssssssssss');
-- --------------------------------------------------------
--
-- 表的结构 `chanpin_zujian`
--
CREATE TABLE `chanpin_zujian` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`one_howmany` double DEFAULT NULL,
`zujianshu` double DEFAULT NULL,
`bancai_id` int(11) DEFAULT NULL,
`chanpin_id` int(11) DEFAULT NULL,
`zujian_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `chanpin_zujian`
--
INSERT INTO `chanpin_zujian` (`id`, `deleted`, `deleted_at`, `last_updated`, `one_howmany`, `zujianshu`, `bancai_id`, `chanpin_id`, `zujian_id`) VALUES
(1, 0, NULL, '2025-06-29 19:58:34', 20, NULL, 1, 1, 1),
(2, 0, NULL, '2025-06-30 08:00:42', 11, NULL, 1, 2, 1),
(3, 0, NULL, '2025-07-01 15:05:59', 1, NULL, 1, 3, 1),
(4, 0, NULL, '2025-07-03 03:26:52', 1, NULL, 8, 13, 2);
-- --------------------------------------------------------
--
-- 表的结构 `dingdan`
--
CREATE TABLE `dingdan` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`jiaohuo` datetime DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
`xiadan` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `dingdan`
--
INSERT INTO `dingdan` (`id`, `deleted`, `deleted_at`, `last_updated`, `jiaohuo`, `number`, `xiadan`) VALUES
(1, 0, NULL, '2025-06-29 19:58:35', NULL, '2025-31', '2025-06-28 00:00:00'),
(2, 0, NULL, '2025-06-30 03:43:23', NULL, '2025-33', NULL),
(3, 0, NULL, '2025-07-01 07:39:01', NULL, '2025-034', '2025-07-01 00:00:00'),
(4, 0, NULL, '2025-07-02 12:44:38', NULL, '2025-034增加单', '2025-07-02 00:00:00'),
(5, 0, NULL, '2025-07-02 12:54:57', NULL, '2025-031', '2025-07-02 00:00:00'),
(6, 0, NULL, '2025-07-02 13:04:50', '2025-07-13 00:00:00', '2025-036', '2025-06-13 00:00:00'),
(7, 0, NULL, '2025-07-02 13:19:03', '2025-07-16 00:00:00', '2025-037', '2025-06-16 00:00:00'),
(8, 0, NULL, '2025-07-02 13:23:35', '2025-08-17 00:00:00', '2025-038', '2025-06-17 00:00:00'),
(44, 0, NULL, '2025-07-03 03:24:17', '2025-08-03 00:00:00', '梦5', '2025-07-03 00:00:00');
-- --------------------------------------------------------
--
-- 表的结构 `dingdan_bancai`
--
CREATE TABLE `dingdan_bancai` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`shuliang` int(11) DEFAULT NULL,
`bancai_id` int(11) DEFAULT NULL,
`chanpin_id` int(11) DEFAULT NULL,
`dingdan_id` int(11) DEFAULT NULL,
`zujian_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `dingdan_bancai`
--
INSERT INTO `dingdan_bancai` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `bancai_id`, `chanpin_id`, `dingdan_id`, `zujian_id`) VALUES
(1, 0, NULL, '2025-06-29 13:50:38', 0, 1, 1, 1, 1),
(2, 0, NULL, '2025-07-01 07:44:59', 42, 2, 3, 3, NULL),
(3, 0, NULL, '2025-07-01 12:31:33', 16, 2, 4, 3, NULL),
(4, 0, NULL, '2025-07-01 12:34:10', 15, 5, 4, 3, NULL),
(5, 0, NULL, '2025-07-01 12:53:36', 12, 6, 5, 3, NULL),
(6, 0, NULL, '2025-07-01 12:38:15', 14, 5, 6, 3, NULL),
(7, 0, NULL, '2025-07-01 12:44:31', 20, 7, 7, 3, NULL),
(8, 0, NULL, '2025-07-01 12:47:31', 6, 8, 7, 3, NULL),
(9, 0, NULL, '2025-07-01 12:48:00', 6, 8, 5, 3, NULL),
(10, 0, NULL, '2025-07-01 12:50:00', 20, 9, 7, 3, NULL),
(11, 0, NULL, '2025-07-01 12:50:21', 25, 9, 3, 3, NULL),
(12, 0, NULL, '2025-07-01 12:50:41', 15, 9, 4, 3, NULL),
(13, 0, NULL, '2025-07-01 12:52:12', 15, 10, 6, 3, NULL),
(14, 0, NULL, '2025-07-02 11:38:58', 14, 26, 3, 3, NULL),
(15, 0, NULL, '2025-07-02 11:40:48', 9, 27, 5, 3, NULL),
(16, 0, NULL, '2025-07-02 11:45:06', 15, 28, 4, 3, NULL),
(17, 0, NULL, '2025-07-02 11:47:49', 4, 29, 7, 3, NULL),
(18, 0, NULL, '2025-07-02 11:48:22', 18, 30, 7, 3, NULL),
(19, 0, NULL, '2025-07-02 11:48:54', 12, 31, 7, 3, NULL),
(20, 0, NULL, '2025-07-02 11:49:18', 14, 32, 3, 3, NULL),
(21, 0, NULL, '2025-07-02 11:49:39', 18, 32, 4, 3, NULL),
(22, 0, NULL, '2025-07-02 11:54:16', 14, 33, 6, 3, NULL),
(23, 0, NULL, '2025-07-02 11:54:43', 15, 34, 5, 3, NULL),
(24, 0, NULL, '2025-07-02 11:55:20', 29, 35, 4, 3, NULL),
(25, 0, NULL, '2025-07-02 11:55:59', 9, 36, 4, 3, NULL),
(26, 0, NULL, '2025-07-02 11:56:55', 15, 1, 4, 3, NULL),
(27, 0, NULL, '2025-07-02 11:57:27', 48, 37, 7, 3, NULL),
(28, 0, NULL, '2025-07-02 11:57:48', 20, 38, 7, 3, NULL),
(29, 0, NULL, '2025-07-02 12:17:42', 2222, 1, 1, 2, 1),
(30, 0, NULL, '2025-07-02 12:49:30', 14, 2, 4, 4, NULL),
(31, 0, NULL, '2025-07-02 12:49:54', 13, 5, 4, 4, NULL),
(32, 0, NULL, '2025-07-02 12:50:33', 13, 9, 4, 4, NULL),
(33, 0, NULL, '2025-07-02 12:51:06', 13, 28, 4, 4, NULL),
(34, 0, NULL, '2025-07-02 12:51:36', 16, 32, 4, 4, NULL),
(35, 0, NULL, '2025-07-02 12:52:09', 26, 35, 4, 4, NULL),
(36, 0, NULL, '2025-07-02 12:52:39', 8, 36, 4, 4, NULL),
(37, 0, NULL, '2025-07-02 12:52:54', 13, 1, 4, 4, NULL),
(38, 0, NULL, '2025-07-02 12:58:45', 14, NULL, NULL, NULL, NULL),
(39, 0, NULL, '2025-07-02 13:14:51', 17, 41, 8, 6, NULL),
(40, 0, NULL, '2025-07-02 13:15:44', 25, 42, 9, 6, NULL),
(41, 0, NULL, '2025-07-02 13:16:15', 32, 7, 8, 6, NULL),
(42, 0, NULL, '2025-07-02 13:16:39', 32, 43, 8, 6, NULL),
(43, 0, NULL, '2025-07-02 13:17:01', 66, 44, 8, 6, NULL),
(44, 0, NULL, '2025-07-02 13:17:23', 6, 47, 8, 6, NULL),
(45, 0, NULL, '2025-07-02 13:17:46', 42, 45, 9, 6, NULL),
(46, 0, NULL, '2025-07-02 13:18:02', 70, 46, 9, 6, NULL),
(47, 0, NULL, '2025-07-02 13:20:48', 15, 49, 10, 7, NULL),
(48, 0, NULL, '2025-07-03 02:09:29', 6, 42, 11, 8, NULL),
(49, 0, NULL, '2025-07-03 02:09:53', 9, 49, 11, 8, NULL),
(50, 0, NULL, '2025-07-03 02:11:24', 9, 56, 11, 8, NULL),
(51, 0, NULL, '2025-07-03 02:12:03', 15, 57, 11, 8, NULL),
(52, 0, NULL, '2025-07-03 03:27:48', 57, 8, 13, 44, 2),
(53, 0, NULL, '2025-07-03 03:30:58', 112, NULL, NULL, NULL, NULL),
(54, 0, NULL, '2025-07-03 03:38:24', 7, 40, 1, 5, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `dingdan_chanpin`
--
CREATE TABLE `dingdan_chanpin` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`shuliang` int(11) DEFAULT NULL,
`chanpin_id` int(11) DEFAULT NULL,
`dingdan_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `dingdan_chanpin`
--
INSERT INTO `dingdan_chanpin` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `chanpin_id`, `dingdan_id`) VALUES
(5, 0, NULL, '2025-07-01 07:41:38', 200, 3, 3),
(6, 0, NULL, '2025-07-01 12:30:48', 220, 4, 3),
(7, 0, NULL, '2025-07-01 12:35:02', 200, 5, 3),
(8, 0, NULL, '2025-07-01 12:37:58', 300, 6, 3),
(9, 0, NULL, '2025-07-01 12:43:26', 40, 7, 3),
(10, 0, NULL, '2025-07-01 15:03:30', 1, 1, 2),
(11, 0, NULL, '2025-07-01 15:05:22', 1, 2, 2),
(12, 0, NULL, '2025-07-01 15:05:29', 1, 3, 2),
(13, 0, NULL, '2025-07-02 12:45:01', 200, 4, 4),
(14, 0, NULL, '2025-07-02 12:56:20', 30, 1, 5),
(15, 0, NULL, '2025-07-02 13:05:53', 500, 8, 6),
(16, 0, NULL, '2025-07-02 13:06:30', 500, 9, 6),
(17, 0, NULL, '2025-07-02 13:19:41', 500, 10, 7),
(32, 0, NULL, '2025-07-03 02:08:44', 200, 11, 8),
(33, 0, NULL, '2025-07-03 03:25:03', 5000, 13, 44);
-- --------------------------------------------------------
--
-- 表的结构 `jinhuo`
--
CREATE TABLE `jinhuo` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date` datetime DEFAULT NULL,
`shuliang` int(11) DEFAULT NULL,
`text` varchar(255) DEFAULT NULL,
`the_type_of_operation` int(11) DEFAULT NULL,
`dingdan_bancai_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `jinhuo`
--
INSERT INTO `jinhuo` (`id`, `deleted`, `deleted_at`, `last_updated`, `date`, `shuliang`, `text`, `the_type_of_operation`, `dingdan_bancai_id`, `user_id`) VALUES
(3, 0, NULL, '2025-07-01 07:45:00', '2025-07-01 07:47:35', 42, NULL, NULL, 2, 1),
(4, 0, NULL, '2025-07-01 12:31:34', '2025-07-01 12:34:11', 16, NULL, NULL, 3, 1),
(5, 0, NULL, '2025-07-01 12:34:10', '2025-07-01 12:36:47', 15, NULL, NULL, 4, 1),
(6, 0, NULL, '2025-07-01 12:37:12', '2025-07-01 12:39:49', 6, NULL, NULL, 5, 1),
(7, 0, NULL, '2025-07-01 12:38:15', '2025-07-01 12:40:52', 14, NULL, NULL, 6, 1),
(8, 0, NULL, '2025-07-01 12:44:31', '2025-07-01 12:47:08', 20, NULL, NULL, 7, 1),
(9, 0, NULL, '2025-07-01 12:47:31', '2025-07-01 12:50:08', 6, NULL, NULL, 8, 1),
(10, 0, NULL, '2025-07-01 12:48:01', '2025-07-01 12:50:38', 6, NULL, NULL, 9, 1),
(11, 0, NULL, '2025-07-01 12:50:01', '2025-07-01 12:52:37', 20, NULL, NULL, 10, 1),
(12, 0, NULL, '2025-07-01 12:50:21', '2025-07-01 12:52:58', 25, NULL, NULL, 11, 1),
(13, 0, NULL, '2025-07-01 12:50:41', '2025-07-01 12:53:18', 15, NULL, NULL, 12, 1),
(14, 0, NULL, '2025-07-01 12:52:12', '2025-07-01 12:54:49', 15, NULL, NULL, 13, 1),
(15, 0, NULL, '2025-07-01 12:53:36', '2025-07-01 12:56:13', 12, NULL, NULL, 5, 1),
(16, 0, NULL, '2025-07-02 11:39:01', '2025-07-02 11:41:39', 14, NULL, NULL, 14, 1),
(17, 0, NULL, '2025-07-02 11:40:49', '2025-07-02 11:43:28', 9, NULL, NULL, 15, 1),
(18, 0, NULL, '2025-07-02 11:45:07', '2025-07-02 11:47:46', 15, NULL, NULL, 16, 1),
(19, 0, NULL, '2025-07-02 11:47:49', '2025-07-02 11:50:29', 4, NULL, NULL, 17, 1),
(20, 0, NULL, '2025-07-02 11:48:22', '2025-07-02 11:51:01', 18, NULL, NULL, 18, 1),
(21, 0, NULL, '2025-07-02 11:48:54', '2025-07-02 11:51:34', 12, NULL, NULL, 19, 1),
(22, 0, NULL, '2025-07-02 11:49:18', '2025-07-02 11:51:58', 14, NULL, NULL, 20, 1),
(23, 0, NULL, '2025-07-02 11:49:39', '2025-07-02 11:52:18', 18, NULL, NULL, 21, 1),
(24, 0, NULL, '2025-07-02 11:54:16', '2025-07-02 11:56:56', 14, NULL, NULL, 22, 1),
(25, 0, NULL, '2025-07-02 11:54:43', '2025-07-02 11:57:23', 15, NULL, NULL, 23, 1),
(26, 0, NULL, '2025-07-02 11:55:21', '2025-07-02 11:58:00', 29, NULL, NULL, 24, 1),
(27, 0, NULL, '2025-07-02 11:55:59', '2025-07-02 11:58:38', 9, NULL, NULL, 25, 1),
(28, 0, NULL, '2025-07-02 11:56:56', '2025-07-02 11:59:35', 15, NULL, NULL, 26, 1),
(29, 0, NULL, '2025-07-02 11:57:27', '2025-07-02 12:00:07', 48, NULL, NULL, 27, 1),
(30, 0, NULL, '2025-07-02 11:57:48', '2025-07-02 12:00:27', 20, NULL, NULL, 28, 1),
(31, 0, NULL, '2025-07-02 12:17:42', '2025-07-02 12:17:42', 2222, NULL, NULL, 29, NULL),
(32, 0, NULL, '2025-07-02 12:17:43', '2025-07-02 12:17:42', 2222, NULL, NULL, 29, 1),
(33, 0, NULL, '2025-07-02 12:49:30', '2025-07-02 12:49:30', 14, NULL, NULL, 30, NULL),
(34, 0, NULL, '2025-07-02 12:49:30', '2025-07-02 12:52:10', 14, NULL, NULL, 30, 1),
(35, 0, NULL, '2025-07-02 12:49:54', '2025-07-02 12:49:54', 13, NULL, NULL, 31, NULL),
(36, 0, NULL, '2025-07-02 12:49:55', '2025-07-02 12:52:34', 13, NULL, NULL, 31, 1),
(37, 0, NULL, '2025-07-02 12:50:33', '2025-07-02 12:50:33', 13, NULL, NULL, 32, NULL),
(38, 0, NULL, '2025-07-02 12:50:33', '2025-07-02 12:53:13', 13, NULL, NULL, 32, 1),
(39, 0, NULL, '2025-07-02 12:51:06', '2025-07-02 12:51:06', 13, NULL, NULL, 33, NULL),
(40, 0, NULL, '2025-07-02 12:51:07', '2025-07-02 12:53:45', 13, NULL, NULL, 33, 1),
(41, 0, NULL, '2025-07-02 12:51:36', '2025-07-02 12:51:36', 16, NULL, NULL, 34, NULL),
(42, 0, NULL, '2025-07-02 12:51:36', '2025-07-02 12:54:15', 16, NULL, NULL, 34, 1),
(43, 0, NULL, '2025-07-02 12:52:09', '2025-07-02 12:52:09', 26, NULL, NULL, 35, NULL),
(44, 0, NULL, '2025-07-02 12:52:09', '2025-07-02 12:54:49', 26, NULL, NULL, 35, 1),
(45, 0, NULL, '2025-07-02 12:52:39', '2025-07-02 12:52:39', 8, NULL, NULL, 36, NULL),
(46, 0, NULL, '2025-07-02 12:52:39', '2025-07-02 12:55:19', 8, NULL, NULL, 36, 1),
(47, 0, NULL, '2025-07-02 12:52:54', '2025-07-02 12:52:54', 13, NULL, NULL, 37, NULL),
(48, 0, NULL, '2025-07-02 12:52:54', '2025-07-02 12:55:33', 13, NULL, NULL, 37, 1),
(49, 0, NULL, '2025-07-02 12:58:15', '2025-07-02 12:58:15', 7, NULL, NULL, 38, NULL),
(50, 0, NULL, '2025-07-02 12:58:15', '2025-07-02 13:00:54', 7, NULL, NULL, 38, 1),
(51, 0, NULL, '2025-07-02 12:58:45', '2025-07-02 12:58:45', 7, NULL, NULL, 38, NULL),
(52, 0, NULL, '2025-07-02 12:58:45', '2025-07-02 13:01:25', 14, NULL, NULL, 38, 1),
(53, 0, NULL, '2025-07-02 13:14:51', '2025-07-02 13:14:51', 17, NULL, NULL, 39, NULL),
(54, 0, NULL, '2025-07-02 13:14:52', '2025-07-02 13:17:31', 17, NULL, NULL, 39, 1),
(55, 0, NULL, '2025-07-02 13:15:44', '2025-07-02 13:15:44', 25, NULL, NULL, 40, NULL),
(56, 0, NULL, '2025-07-02 13:15:44', '2025-07-02 13:18:23', 25, NULL, NULL, 40, 1),
(57, 0, NULL, '2025-07-02 13:16:15', '2025-07-02 13:16:15', 32, NULL, NULL, 41, NULL),
(58, 0, NULL, '2025-07-02 13:16:15', '2025-07-02 13:18:55', 32, NULL, NULL, 41, 1),
(59, 0, NULL, '2025-07-02 13:16:39', '2025-07-02 13:16:39', 32, NULL, NULL, 42, NULL),
(60, 0, NULL, '2025-07-02 13:16:39', '2025-07-02 13:19:19', 32, NULL, NULL, 42, 1),
(61, 0, NULL, '2025-07-02 13:17:01', '2025-07-02 13:17:01', 66, NULL, NULL, 43, NULL),
(62, 0, NULL, '2025-07-02 13:17:01', '2025-07-02 13:19:41', 66, NULL, NULL, 43, 1),
(63, 0, NULL, '2025-07-02 13:17:23', '2025-07-02 13:17:23', 6, NULL, NULL, 44, NULL),
(64, 0, NULL, '2025-07-02 13:17:23', '2025-07-02 13:20:03', 6, NULL, NULL, 44, 1),
(65, 0, NULL, '2025-07-02 13:17:46', '2025-07-02 13:17:46', 42, NULL, NULL, 45, NULL),
(66, 0, NULL, '2025-07-02 13:17:47', '2025-07-02 13:20:26', 42, NULL, NULL, 45, 1),
(67, 0, NULL, '2025-07-02 13:18:02', '2025-07-02 13:18:02', 70, NULL, NULL, 46, NULL),
(68, 0, NULL, '2025-07-02 13:18:02', '2025-07-02 13:20:42', 70, NULL, NULL, 46, 1),
(69, 0, NULL, '2025-07-02 13:20:48', '2025-07-02 13:20:48', 15, NULL, NULL, 47, NULL),
(70, 0, NULL, '2025-07-02 13:20:49', '2025-07-02 13:23:28', 15, NULL, NULL, 47, 1),
(71, 0, NULL, '2025-07-03 02:09:29', '2025-07-03 02:09:29', 6, NULL, NULL, 48, NULL),
(72, 0, NULL, '2025-07-03 02:09:30', '2025-07-03 02:12:10', 6, NULL, NULL, 48, 1),
(73, 0, NULL, '2025-07-03 02:09:54', '2025-07-03 02:09:54', 9, NULL, NULL, 49, NULL),
(74, 0, NULL, '2025-07-03 02:09:54', '2025-07-03 02:12:34', 9, NULL, NULL, 49, 1),
(75, 0, NULL, '2025-07-03 02:11:24', '2025-07-03 02:11:24', 9, NULL, NULL, 50, NULL),
(76, 0, NULL, '2025-07-03 02:11:24', '2025-07-03 02:14:05', 9, NULL, NULL, 50, 1),
(77, 0, NULL, '2025-07-03 02:12:03', '2025-07-03 02:12:03', 15, NULL, NULL, 51, NULL),
(78, 0, NULL, '2025-07-03 02:12:04', '2025-07-03 02:14:44', 15, NULL, NULL, 51, 1),
(79, 0, NULL, '2025-07-03 03:27:48', '2025-07-03 03:27:48', 57, NULL, NULL, 52, NULL),
(80, 0, NULL, '2025-07-03 03:27:48', '2025-07-03 03:27:57', 57, NULL, NULL, 52, 2),
(81, 0, NULL, '2025-07-03 03:30:27', '2025-07-03 03:30:27', 56, NULL, NULL, 53, NULL),
(82, 0, NULL, '2025-07-03 03:30:27', '2025-07-03 03:30:36', 56, NULL, NULL, 53, 2),
(83, 0, NULL, '2025-07-03 03:30:58', '2025-07-03 03:30:58', 56, NULL, NULL, 53, NULL),
(84, 0, NULL, '2025-07-03 03:30:58', '2025-07-03 03:31:07', 112, NULL, NULL, 53, 2),
(85, 0, NULL, '2025-07-03 03:33:53', '2025-07-03 03:33:53', -2200, '手动调整库存: 2250 → 50', NULL, NULL, 1),
(86, 0, NULL, '2025-07-03 03:37:26', '2025-07-03 03:37:26', -7, '手动调整库存: 7 → 0', NULL, NULL, 1),
(87, 0, NULL, '2025-07-03 03:38:24', '2025-07-03 03:38:24', 7, NULL, NULL, 54, NULL),
(88, 0, NULL, '2025-07-03 03:38:24', '2025-07-03 03:38:24', 7, NULL, NULL, 54, 1);
-- --------------------------------------------------------
--
-- 表的结构 `kucun`
--
CREATE TABLE `kucun` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`shuliang` int(11) DEFAULT NULL,
`bancai_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `kucun`
--
INSERT INTO `kucun` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `bancai_id`) VALUES
(2, 0, NULL, '2025-07-02 12:49:30', 72, 2),
(3, 0, NULL, '2025-07-02 12:49:54', 42, 5),
(4, 0, NULL, '2025-07-01 12:53:36', 6, 6),
(6, 0, NULL, '2025-07-02 13:16:15', 52, 7),
(8, 0, NULL, '2025-07-03 03:27:48', 69, 8),
(11, 0, NULL, '2025-07-02 12:50:33', 73, 9),
(12, 0, NULL, '2025-07-01 12:52:12', 15, 10),
(29, 0, NULL, '2025-07-02 11:39:00', 14, 26),
(31, 0, NULL, '2025-07-02 11:40:49', 9, 27),
(33, 0, NULL, '2025-07-02 12:51:06', 28, 28),
(37, 0, NULL, '2025-07-02 12:51:36', 48, 32),
(38, 0, NULL, '2025-07-02 11:47:50', 4, 29),
(39, 0, NULL, '2025-07-02 11:48:23', 18, 30),
(40, 0, NULL, '2025-07-02 11:48:55', 12, 31),
(41, 0, NULL, '2025-07-02 11:54:16', 14, 33),
(42, 0, NULL, '2025-07-02 11:54:43', 15, 34),
(43, 0, NULL, '2025-07-02 12:52:09', 55, 35),
(44, 0, NULL, '2025-07-02 12:52:39', 17, 36),
(45, 0, NULL, '2025-07-02 11:57:27', 48, 37),
(46, 0, NULL, '2025-07-02 11:57:48', 20, 38),
(47, 0, NULL, '2025-07-03 03:33:53', 50, 1),
(49, 0, NULL, '2025-07-03 03:38:24', 7, 40),
(53, 0, NULL, '2025-07-02 13:14:51', 17, 41),
(54, 0, NULL, '2025-07-03 02:09:29', 31, 42),
(55, 0, NULL, '2025-07-02 13:16:39', 32, 43),
(56, 0, NULL, '2025-07-02 13:17:01', 66, 44),
(57, 0, NULL, '2025-07-02 13:17:46', 42, 45),
(58, 0, NULL, '2025-07-02 13:18:02', 70, 46),
(59, 0, NULL, '2025-07-02 13:17:23', 6, 47),
(60, 0, NULL, '2025-07-03 02:09:54', 24, 49),
(68, 0, NULL, '2025-07-03 02:11:24', 9, 56),
(70, 0, NULL, '2025-07-03 02:12:03', 15, 57),
(72, 0, NULL, '2025-07-03 03:30:27', 56, 58),
(74, 0, NULL, '2025-07-03 03:30:58', 56, NULL),
(76, 0, NULL, '2025-07-08 14:33:24', 0, 59);
-- --------------------------------------------------------
--
-- 表的结构 `mupi`
--
CREATE TABLE `mupi` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`name` varchar(255) DEFAULT NULL,
`you` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `mupi`
--
INSERT INTO `mupi` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`, `you`) VALUES
(1, 0, NULL, '2025-06-29 19:58:37', '桃花心', b'1'),
(2, 0, NULL, '2025-07-01 07:43:23', '桃花芯', b'1'),
(3, 0, NULL, '2025-07-01 12:33:13', '无', b'1'),
(4, 0, NULL, '2025-07-01 12:36:20', '香杉', b'1'),
(5, 0, NULL, '2025-07-01 12:46:09', '杂皮', b'1'),
(6, 0, NULL, '2025-07-02 11:35:59', '', b'1'),
(7, 0, NULL, '2025-07-02 11:37:46', '杂皮20C', b'1'),
(8, 0, NULL, '2025-07-02 11:39:59', '花梨', b'1'),
(9, 0, NULL, '2025-07-02 11:46:02', '黑橡', b'1'),
(12, 0, NULL, '2025-07-02 12:51:16', '黑橡', b'1'),
(13, 0, NULL, '2025-07-02 13:09:19', '科技黑檀', b'1'),
(14, 0, NULL, '2025-07-03 03:29:15', '科技花梨', b'1');
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
CREATE TABLE `user` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`andy` varchar(255) NOT NULL,
`incumbency` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`role` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `user`
--
INSERT INTO `user` (`id`, `deleted`, `deleted_at`, `last_updated`, `andy`, `incumbency`, `name`, `pass`, `role`) VALUES
(1, 0, NULL, '2025-07-01 07:34:48', 'winstin', 0, '超管', '$2a$12$v/PRjTPl9PcrrN.09YK3nOsnsM3sLdJp42rFQp8tDjILF295XRple', 3),
(2, 0, NULL, '2025-07-03 02:01:35', '吴蓉', 0, '吴蓉', '$2a$12$NmbaLeziwxvJ0FZpZ1gY.uDqopho/ig4H9KzvTdX6QDRgqtfOUsuS', 2);
-- --------------------------------------------------------
--
-- 表的结构 `wechat_user`
--
CREATE TABLE `wechat_user` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`avatar_url` varchar(255) DEFAULT NULL,
`create_time` datetime NOT NULL,
`nickname` varchar(255) DEFAULT NULL,
`openid` varchar(255) NOT NULL,
`phone_number` varchar(255) DEFAULT NULL,
`session_key` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`user_id` int(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `zujian`
--
CREATE TABLE `zujian` (
`id` int(11) NOT NULL,
`deleted` tinyint(1) DEFAULT '0',
`deleted_at` datetime DEFAULT NULL,
`last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `zujian`
--
INSERT INTO `zujian` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`) VALUES
(1, 0, NULL, '2025-06-29 19:58:38', '侧板'),
(2, 0, NULL, '2025-07-03 03:25:49', '底板');
--
-- 转储表的索引
--
--
-- 表的索引 `bancai`
--
ALTER TABLE `bancai`
ADD PRIMARY KEY (`id`),
ADD KEY `FKaqqiwbo1buldyylxfd10t6s9i` (`caizhi_id`),
ADD KEY `FKhho2rndsbrfcuoxh2v5ckpita` (`kucun_id`),
ADD KEY `FKgtpa2iv2jjkpn6p1nupuf48ox` (`mupi1_id`),
ADD KEY `FKdvk13swyjj5lq6tbj5hghw1we` (`mupi2_id`);
--
-- 表的索引 `caizhi`
--
ALTER TABLE `caizhi`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK46crvqr6m8o69hxu1fu3ctmeb` (`name`);
--
-- 表的索引 `chanpin`
--
ALTER TABLE `chanpin`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK6p18raa21f5nawnh7dmxy0f0k` (`bianhao`);
--
-- 表的索引 `chanpin_zujian`
--
ALTER TABLE `chanpin_zujian`
ADD PRIMARY KEY (`id`),
ADD KEY `FKjt74g1bjy5lnga2o8xw5132ox` (`bancai_id`),
ADD KEY `FKqngnl03a9s8phk062o30cljy` (`chanpin_id`),
ADD KEY `FKgxbe3qiv95l9u9njm6v9vv5n6` (`zujian_id`);
--
-- 表的索引 `dingdan`
--
ALTER TABLE `dingdan`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UKl8nwl8iqj6auj1gb2t5fdaq0v` (`number`);
--
-- 表的索引 `dingdan_bancai`
--
ALTER TABLE `dingdan_bancai`
ADD PRIMARY KEY (`id`),
ADD KEY `FKlgqich8uvb1awk3109pxqmx5v` (`bancai_id`),
ADD KEY `FK1pg8lh7gtykip0t05f9mk14ys` (`chanpin_id`),
ADD KEY `FK9vsra9m3j8dcj4eci750llh62` (`dingdan_id`),
ADD KEY `FKkj9ko6sx8f5drnlqbivovgg3d` (`zujian_id`);
--
-- 表的索引 `dingdan_chanpin`
--
ALTER TABLE `dingdan_chanpin`
ADD PRIMARY KEY (`id`),
ADD KEY `FK54x70yfucrdc76kqmutvf4fgj` (`chanpin_id`),
ADD KEY `FKsj1dcqlcg8jjx5xevfbrvr0me` (`dingdan_id`);
--
-- 表的索引 `jinhuo`
--
ALTER TABLE `jinhuo`
ADD PRIMARY KEY (`id`),
ADD KEY `FKeyk51dk8uw0ykh665tpbkyx8f` (`dingdan_bancai_id`),
ADD KEY `FKmdwa2a1qj1ln6mepmop8896r8` (`user_id`);
--
-- 表的索引 `kucun`
--
ALTER TABLE `kucun`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK5dbsvfo4b6xk8is5lo6d4lucl` (`bancai_id`);
--
-- 表的索引 `mupi`
--
ALTER TABLE `mupi`
ADD PRIMARY KEY (`id`);
--
-- 表的索引 `user`
--
ALTER TABLE `user`
ADD PRIMARY KEY (`id`);
--
-- 表的索引 `wechat_user`
--
ALTER TABLE `wechat_user`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK_kjbpuy6m988ge98tbn765ho08` (`openid`),
ADD UNIQUE KEY `UK_4lovtxwijxu13sj2g0khuxq04` (`user_id`);
--
-- 表的索引 `zujian`
--
ALTER TABLE `zujian`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `bancai`
--
ALTER TABLE `bancai`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;
--
-- 使用表AUTO_INCREMENT `caizhi`
--
ALTER TABLE `caizhi`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `chanpin`
--
ALTER TABLE `chanpin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- 使用表AUTO_INCREMENT `chanpin_zujian`
--
ALTER TABLE `chanpin_zujian`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- 使用表AUTO_INCREMENT `dingdan`
--
ALTER TABLE `dingdan`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
--
-- 使用表AUTO_INCREMENT `dingdan_bancai`
--
ALTER TABLE `dingdan_bancai`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
--
-- 使用表AUTO_INCREMENT `dingdan_chanpin`
--
ALTER TABLE `dingdan_chanpin`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- 使用表AUTO_INCREMENT `jinhuo`
--
ALTER TABLE `jinhuo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;
--
-- 使用表AUTO_INCREMENT `kucun`
--
ALTER TABLE `kucun`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;
--
-- 使用表AUTO_INCREMENT `mupi`
--
ALTER TABLE `mupi`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- 使用表AUTO_INCREMENT `user`
--
ALTER TABLE `user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `wechat_user`
--
ALTER TABLE `wechat_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `zujian`
--
ALTER TABLE `zujian`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 限制导出的表
--
--
-- 限制表 `bancai`
--
ALTER TABLE `bancai`
ADD CONSTRAINT `FKaqqiwbo1buldyylxfd10t6s9i` FOREIGN KEY (`caizhi_id`) REFERENCES `caizhi` (`id`),
ADD CONSTRAINT `FKdvk13swyjj5lq6tbj5hghw1we` FOREIGN KEY (`mupi2_id`) REFERENCES `mupi` (`id`),
ADD CONSTRAINT `FKgtpa2iv2jjkpn6p1nupuf48ox` FOREIGN KEY (`mupi1_id`) REFERENCES `mupi` (`id`),
ADD CONSTRAINT `FKhho2rndsbrfcuoxh2v5ckpita` FOREIGN KEY (`kucun_id`) REFERENCES `kucun` (`id`);
--
-- 限制表 `chanpin_zujian`
--
ALTER TABLE `chanpin_zujian`
ADD CONSTRAINT `FKgxbe3qiv95l9u9njm6v9vv5n6` FOREIGN KEY (`zujian_id`) REFERENCES `zujian` (`id`),
ADD CONSTRAINT `FKjt74g1bjy5lnga2o8xw5132ox` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`),
ADD CONSTRAINT `FKqngnl03a9s8phk062o30cljy` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`);
--
-- 限制表 `dingdan_bancai`
--
ALTER TABLE `dingdan_bancai`
ADD CONSTRAINT `FK1pg8lh7gtykip0t05f9mk14ys` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`),
ADD CONSTRAINT `FK9vsra9m3j8dcj4eci750llh62` FOREIGN KEY (`dingdan_id`) REFERENCES `dingdan` (`id`),
ADD CONSTRAINT `FKkj9ko6sx8f5drnlqbivovgg3d` FOREIGN KEY (`zujian_id`) REFERENCES `zujian` (`id`),
ADD CONSTRAINT `FKlgqich8uvb1awk3109pxqmx5v` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`);
--
-- 限制表 `dingdan_chanpin`
--
ALTER TABLE `dingdan_chanpin`
ADD CONSTRAINT `FK54x70yfucrdc76kqmutvf4fgj` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`),
ADD CONSTRAINT `FKsj1dcqlcg8jjx5xevfbrvr0me` FOREIGN KEY (`dingdan_id`) REFERENCES `dingdan` (`id`);
--
-- 限制表 `jinhuo`
--
ALTER TABLE `jinhuo`
ADD CONSTRAINT `FKeyk51dk8uw0ykh665tpbkyx8f` FOREIGN KEY (`dingdan_bancai_id`) REFERENCES `dingdan_bancai` (`id`),
ADD CONSTRAINT `FKmdwa2a1qj1ln6mepmop8896r8` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
--
-- 限制表 `kucun`
--
ALTER TABLE `kucun`
ADD CONSTRAINT `FK49m3supvamn3l93c5amcu3vlg` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`);
COMMIT;
/*!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 */;
------------------业务主要是板材的购入和使用,估算30m的MySQL5.6数据库空间大概可以多少条数据
最新发布