开源 企业版 高校版 私有云 模力方舟 AI 队友
代码拉取完成,页面将自动刷新
捐赠
捐赠前请先登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
1 Star 0 Fork 29

java生态链/shardingsphere分库分表

加入 Gitee
与超过 1400万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
已有帐号? 立即登录
文件
master
分支 (2)
标签 (2)
master
develop
V1.1_snowFlake
V1.0_base_db_table
master
分支 (2)
标签 (2)
master
develop
V1.1_snowFlake
V1.0_base_db_table
克隆/下载
克隆/下载
提示
下载代码请复制以下命令到终端执行
为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置
初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置
1 生成 RSA 密钥
2 获取 RSA 公钥内容,并配置到 SSH公钥 中
在 Gitee 上使用 SVN,请访问 使用指南
使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议 配置并使用私人令牌 替代登录密码进行克隆、推送等操作
Username for 'https://gitee.com': userName
Password for 'https://userName@gitee.com': # 私人令牌
master
分支 (2)
标签 (2)
master
develop
V1.1_snowFlake
V1.0_base_db_table
ss-db-table
/
sql
/
data_source.sql
ss-db-table
/
sql
/
data_source.sql
data_source.sql 9.31 KB
一键复制 编辑 原始数据 按行查看 历史
在我的歌声里 提交于 2020年04月24日 13:43 +08:00 . sql文件同步 
/*

 Navicat Premium Data Transfer



 Source Server : localhostt3306

 Source Server Type : MySQL

 Source Server Version : 50725

 Source Host : localhost:3306

 Source Schema : data_source



 Target Server Type : MySQL

 Target Server Version : 50725

 File Encoding : 65001



 Date: 24/04/2020 13:42:09

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for area

-- ----------------------------

DROP TABLE IF EXISTS `area`;

CREATE TABLE `area` (

 `id` bigint(20) UNSIGNED NOT NULL COMMENT 'id',

 `area_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地区编号',

 `area_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地区名称',

 `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

 `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地区表(单库单表)' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of area

-- ----------------------------

INSERT INTO `area` VALUES (1252894829990465537, '110000', '北京市', '2020-04-22 17:39:40', '2020-04-22 17:39:40');

INSERT INTO `area` VALUES (1252894833933111297, '110101', '东城区', '2020-04-22 17:39:42', '2020-04-22 17:39:42');

INSERT INTO `area` VALUES (1252894833941499906, '110102', '西城区', '2020-04-22 17:39:42', '2020-04-22 17:39:42');

INSERT INTO `area` VALUES (1252894833945694209, '110106', '丰台区', '2020-04-22 17:39:42', '2020-04-22 17:39:42');

INSERT INTO `area` VALUES (1253127290766794753, '110000', '北京市', '2020-04-23 09:03:23', '2020-04-23 09:03:23');

INSERT INTO `area` VALUES (1253127292574539778, '110101', '东城区', '2020-04-23 09:03:23', '2020-04-23 09:03:23');

INSERT INTO `area` VALUES (1253127292599705602, '110102', '西城区', '2020-04-23 09:03:23', '2020-04-23 09:03:23');

INSERT INTO `area` VALUES (1253127292599705603, '110106', '丰台区', '2020-04-23 09:03:23', '2020-04-23 09:03:23');

INSERT INTO `area` VALUES (1253127990993235970, '110000', '北京市', '2020-04-23 09:06:10', '2020-04-23 09:06:10');

INSERT INTO `area` VALUES (1253127992847118337, '110101', '东城区', '2020-04-23 09:06:10', '2020-04-23 09:06:10');

INSERT INTO `area` VALUES (1253127992855506945, '110102', '西城区', '2020-04-23 09:06:10', '2020-04-23 09:06:10');

INSERT INTO `area` VALUES (1253127992859701250, '110106', '丰台区', '2020-04-23 09:06:10', '2020-04-23 09:06:10');

INSERT INTO `area` VALUES (1253128695036538881, '110000', '北京市', '2020-04-23 09:08:58', '2020-04-23 09:08:58');

INSERT INTO `area` VALUES (1253128696999473154, '110101', '东城区', '2020-04-23 09:08:58', '2020-04-23 09:08:58');

INSERT INTO `area` VALUES (1253128697007861762, '110102', '西城区', '2020-04-23 09:08:58', '2020-04-23 09:08:58');

INSERT INTO `area` VALUES (1253128697012056066, '110106', '丰台区', '2020-04-23 09:08:58', '2020-04-23 09:08:58');

INSERT INTO `area` VALUES (1253128998561542146, '110000', '北京市', '2020-04-23 09:10:09', '2020-04-23 09:10:09');

INSERT INTO `area` VALUES (1253128998662205442, '110101', '东城区', '2020-04-23 09:10:09', '2020-04-23 09:10:09');

INSERT INTO `area` VALUES (1253128998662205443, '110102', '西城区', '2020-04-23 09:10:09', '2020-04-23 09:10:09');

INSERT INTO `area` VALUES (1253128998662205444, '110106', '丰台区', '2020-04-23 09:10:09', '2020-04-23 09:10:09');

INSERT INTO `area` VALUES (1253130139168960514, '110000', '北京市', '2020-04-23 09:14:41', '2020-04-23 09:14:41');

INSERT INTO `area` VALUES (1253130139194126337, '110101', '东城区', '2020-04-23 09:14:41', '2020-04-23 09:14:41');

INSERT INTO `area` VALUES (1253130139202514946, '110102', '西城区', '2020-04-23 09:14:41', '2020-04-23 09:14:41');



-- ----------------------------

-- Table structure for config

-- ----------------------------

DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (

 `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',

 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',

 `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

 `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 PRIMARY KEY (`code`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表(单库单表,UUID主键)' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of config

-- ----------------------------

INSERT INTO `config` VALUES ('0ed3bc37cfc24420b548cf3164204fa5', '停止', '2020-04-23 09:45:14', '2020-04-23 09:45:14');

INSERT INTO `config` VALUES ('1857e8c0462b4a7e9b9721211cc2d19d', '结束', '2020-04-23 09:45:14', '2020-04-23 09:45:14');

INSERT INTO `config` VALUES ('3b8367aa39f84b8d86b011abeefda9eb', '结束', '2020-04-23 09:44:51', '2020-04-23 09:44:51');

INSERT INTO `config` VALUES ('7d994341ee0d4d018e43659f9928fde4', '开始', '2020-04-23 09:45:14', '2020-04-23 09:45:14');

INSERT INTO `config` VALUES ('7f3ccd9c5b814b28939c0ec16ba974f1', '开始', '2020-04-23 09:46:17', '2020-04-23 09:46:17');

INSERT INTO `config` VALUES ('91b5bfac57544255aeaf7c6750029e5f', '停止', '2020-04-23 09:44:51', '2020-04-23 09:44:51');

INSERT INTO `config` VALUES ('9c6bceaa38354f1c9f84bae59886bb05', '静止', '2020-04-23 09:45:14', '2020-04-23 09:45:14');

INSERT INTO `config` VALUES ('9f23028c792048eb86f0e07cc3f5f2d2', '静止', '2020-04-23 09:44:51', '2020-04-23 09:44:51');

INSERT INTO `config` VALUES ('a0190eee639140a88886794dc3c286e3', '关闭', '2020-04-23 09:44:51', '2020-04-23 09:44:51');

INSERT INTO `config` VALUES ('a7fe2d935ea64ce4b90281225d1073e2', '开始', '2020-04-23 09:44:51', '2020-04-23 09:44:51');

INSERT INTO `config` VALUES ('a898eb0c7af8430b99a85d4c0274fef7', '停止', '2020-04-23 09:46:17', '2020-04-23 09:46:17');

INSERT INTO `config` VALUES ('c1c109aad93e43bea209c4815c093ffb', '静止', '2020-04-23 09:46:17', '2020-04-23 09:46:17');

INSERT INTO `config` VALUES ('c453070235f344c5b153e138cd7d25b4', '关闭', '2020-04-23 09:46:17', '2020-04-23 09:46:17');

INSERT INTO `config` VALUES ('fa45566df09142fd963c88badb810bae', '结束', '2020-04-23 09:46:17', '2020-04-23 09:46:17');

INSERT INTO `config` VALUES ('fc8e4099cc3c4c29981d22c5b0f9ac4e', '天津市', '2020-04-23 09:45:14', '2020-04-23 09:45:14');



-- ----------------------------

-- Table structure for factory

-- ----------------------------

DROP TABLE IF EXISTS `factory`;

CREATE TABLE `factory` (

 `factory_id` bigint(20) UNSIGNED NOT NULL COMMENT '工厂id',

 `factory_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工厂名称',

 `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

 `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 PRIMARY KEY (`factory_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工厂表(广播表)' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of factory

-- ----------------------------

INSERT INTO `factory` VALUES (1253145436781338625, '富土康', '2020-04-23 10:15:29', '2020-04-23 10:15:29');

INSERT INTO `factory` VALUES (1253145439478276097, '血汗工厂', '2020-04-23 10:15:30', '2020-04-23 10:15:30');

INSERT INTO `factory` VALUES (1253145439495053313, '深圳厂', '2020-04-23 10:15:30', '2020-04-23 10:15:30');

INSERT INTO `factory` VALUES (1253145439503441921, '南宁厂', '2020-04-23 10:15:30', '2020-04-23 10:15:30');

INSERT INTO `factory` VALUES (1253146102031507457, '富土康', '2020-04-23 10:18:07', '2020-04-23 10:18:07');

INSERT INTO `factory` VALUES (1253146102115393538, '血汗工厂', '2020-04-23 10:18:07', '2020-04-23 10:18:07');

INSERT INTO `factory` VALUES (1253146102123782146, '深圳厂', '2020-04-23 10:18:07', '2020-04-23 10:18:07');

INSERT INTO `factory` VALUES (1253146102136365057, '南宁厂', '2020-04-23 10:18:07', '2020-04-23 10:18:07');



-- ----------------------------

-- Table structure for warehouse

-- ----------------------------

DROP TABLE IF EXISTS `warehouse`;

CREATE TABLE `warehouse` (

 `warehouse_id` bigint(20) UNSIGNED NOT NULL COMMENT '仓库id',

 `warehouse_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '仓库名称',

 `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

 `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 PRIMARY KEY (`warehouse_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '仓库表(广播表)' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of warehouse

-- ----------------------------

INSERT INTO `warehouse` VALUES (1253150081998163970, '湖南仓', '2020-04-23 10:33:57', '2020-04-23 10:33:57');

INSERT INTO `warehouse` VALUES (1253150084200173570, '北京仓', '2020-04-23 10:33:57', '2020-04-23 10:33:57');

INSERT INTO `warehouse` VALUES (1253150084208562177, '深圳仓', '2020-04-23 10:33:57', '2020-04-23 10:33:57');

INSERT INTO `warehouse` VALUES (1253150084216950785, '广西仓', '2020-04-23 10:33:57', '2020-04-23 10:33:57');



SET FOREIGN_KEY_CHECKS = 1;
Loading...
举报
举报成功
我们将于2个工作日内通过站内信反馈结果给你!
请认真填写举报原因,尽可能描述详细。
请选择举报类型
取消
发送
误判申诉

此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。

如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。

取消
提交

简介

springboot2.x + shardingjdbc + mybatisPlus3.x + mysql 实现分库分表,将不同的功能打成tag,拿来简单修改即可使用。
暂无标签
Apache-2.0
使用 Apache-2.0 开源许可协议
取消

发行版

暂无发行版

贡献者

全部

近期动态

不能加载更多了
编辑仓库简介
简介内容
主页
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/java_cloud/ss-db-table.git
git@gitee.com:java_cloud/ss-db-table.git
java_cloud
ss-db-table
shardingsphere分库分表
master
点此查找更多帮助

搜索帮助

评论
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号,请先登录后再操作。
立即登录
没有帐号,去注册

AltStyle によって変換されたページ (->オリジナル) /