69 lines
2.7 KiB
Java
69 lines
2.7 KiB
Java
|
-- phpMyAdmin SQL Dump
|
|||
|
|
-- version 5.2.0
|
|||
|
|
-- https://www.phpmyadmin.net/
|
|||
|
|
--
|
|||
|
|
-- 主机： localhost
|
|||
|
|
-- 生成日期： 2023-08-16 17:41:46
|
|||
|
|
-- 服务器版本： 5.7.40-log
|
|||
|
|
-- PHP 版本： 7.4.33
|
|||
|
|
|
|||
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|||
|
|
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 */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- 数据库： `jeecg-boot`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
-- --------------------------------------------------------
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- 表的结构 `purchase_supplier`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
CREATE TABLE `purchase_supplier` (
|
|||
|
|
`id` varchar(36) NOT NULL,
|
|||
|
|
`create_by` varchar(50) DEFAULT NULL COMMENT '创建人',
|
|||
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建日期',
|
|||
|
|
`update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
|
|||
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新日期',
|
|||
|
|
`sys_org_code` varchar(64) DEFAULT NULL COMMENT '所属部门',
|
|||
|
|
`name` varchar(32) DEFAULT NULL COMMENT '供应商名称 ',
|
|||
|
|
`address` varchar(100) DEFAULT NULL COMMENT '地址',
|
|||
|
|
`phone` varchar(20) DEFAULT NULL COMMENT '联系人电话',
|
|||
|
|
`business_scope` varchar(100) DEFAULT NULL COMMENT '业务范围',
|
|||
|
|
`collaborations_number` int(11) DEFAULT '0' COMMENT '合作次数',
|
|||
|
|
`flowing_water` double(10,2) DEFAULT '0.00' COMMENT '历史流水',
|
|||
|
|
`evaluation` varchar(32) DEFAULT NULL COMMENT '综合评价'
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- 转存表中的数据 `purchase_supplier`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
INSERT INTO `purchase_supplier` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `sys_org_code`, `name`, `address`, `phone`, `business_scope`, `collaborations_number`, `flowing_water`, `evaluation`) VALUES
|
|||
|
|
('1690444013968150530', 'admin', '2023-08-13 03:23:54', 'admin', '2023-08-13 17:51:14', 'A01A03', '黄晖有限公司', '福建省厦门市思明区厦禾路', '15960801986', '1,2,3,4,5', 3, 20100000.00, '价格过高'),
|
|||
|
|
('1690736576735887362', 'admin', '2023-08-13 22:46:27', 'admin', '2023-08-14 14:36:35', 'A01A03', 'super军用火炬有限公司', '美国德克萨斯州欧几里得街道火炬开发区', '+1 60366666', '6', 2, 73790000.00, 'Nice Weapon'),
|
|||
|
|
('1691365161122471937', 'admin', '2023-08-15 16:24:13', NULL, NULL, 'A01A03', '测试流程', 'CRUD', 'aaaaaa?为什么可以输入中文', '1,3,5', 0, 0.00, NULL);
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- 转储表的索引
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- 表的索引 `purchase_supplier`
|
|||
|
|
--
|
|||
|
|
ALTER TABLE `purchase_supplier`
|
|||
|
|
ADD PRIMARY KEY (`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 */;
|