mysql条码生成

于 2024-06-11 10:09:08 发布
阅读量400 收藏 8
点赞数 3
文章标签： mysql android 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/oThrowsException/article/details/139591515
版权 
/*
Navicat MySQL Data Transfer

Source Server         : 玲玲
Source Server Version : 50733
Source Host           : 124.71.198.32:3306
Source Database       : tiaoma

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

Date: 2023-04-01 15:02:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for custom_tiaoma_sequence
-- ----------------------------
DROP TABLE IF EXISTS `custom_tiaoma_sequence`;
CREATE TABLE `custom_tiaoma_sequence` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `company_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `state` varchar(20) DEFAULT '0' COMMENT '数据状态',
  `create_user` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '创建人部门名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '创建人部门名Id',
  `note` text COMMENT '说明',
  `name` varchar(255) NOT NULL COMMENT '编号名',
  `value` int(11) NOT NULL DEFAULT '1' COMMENT '编号值',
  `next` int(11) DEFAULT '1' COMMENT '递增值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=' 条码规则 ';

-- ----------------------------
-- Records of custom_tiaoma_sequence
-- ----------------------------

-- ----------------------------
-- Table structure for custom_tiaoma_upload附件
-- ----------------------------
DROP TABLE IF EXISTS `custom_tiaoma_upload附件`;
CREATE TABLE `custom_tiaoma_upload附件` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `company_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `state` varchar(20) DEFAULT '0' COMMENT '数据状态',
  `create_user` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '创建人部门名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '创建人部门名Id',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `size` varchar(20) DEFAULT NULL COMMENT '大小',
  `img_path` varchar(255) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=' upload附件 ';

-- ----------------------------
-- Records of custom_tiaoma_upload附件
-- ----------------------------
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7233590139035852861', '2023-01-20 17:39:47', null, null, '0', null, null, null, null, '9c2e6f873da59aab375a175a14af849b.jpg', '472325', 'upload/f688fa03901f4692b4a96103fd2815b0.jpg');
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7272499656519589915', '2023-02-02 20:19:17', '', '', '0', 'admin', '1', '默认部门', '100', '主表字段1', '', '');
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7274415280653082625', '2023-02-03 09:22:47', null, null, '0', 'admin', '1', '默认部门', '100', null, null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336881', '2023-02-06 14:29:46', null, null, '0', 'admin', '1', '默认部门', '100', 'dsds', null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336884', '2023-02-06 14:30:39', null, null, '0', 'admin', '1', '默认部门', '100', '新增测设', null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336889', '2023-02-06 14:38:29', null, null, '0', 'admin', '1', '默认部门', '100', 'xxxx', null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336899', '2023-02-06 15:13:16', null, null, '0', 'admin', '1', '默认部门', '100', 'dsdsdsds', null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336903', '2023-02-06 15:13:47', null, null, '0', 'admin', '1', '默认部门', '100', 'abc', null, null);
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336928', '2023-02-06 15:29:55', null, null, '0', 'admin', '1', '默认部门', '100', null, null, 'sdf');
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336932', '2023-02-06 15:34:34', null, null, '0', 'admin', '1', '默认部门', '100', null, null, 'dfgfdf');
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336937', '2023-02-06 15:52:28', null, null, '0', 'admin', '1', '默认部门', '100', '999', null, 'dsdsdsds');
INSERT INTO `custom_tiaoma_upload附件` VALUES ('7283409148329336941', '2023-02-06 15:39:14', null, null, '0', 'admin', '1', '默认部门', '100', null, null, 'dsdsds');

-- ----------------------------
-- Table structure for custom_tiaoma_子表
-- ----------------------------
DROP TABLE IF EXISTS `custom_tiaoma_子表`;
CREATE TABLE `custom_tiaoma_子表` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `company_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `state` varchar(20) DEFAULT '0' COMMENT '数据状态',
  `create_user` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '创建人部门名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '创建人部门名Id',
  `pid` bigint(20) DEFAULT NULL COMMENT 'pid',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `age_a_b` varchar(255) DEFAULT NULL COMMENT 'age',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=' 子表 ';

-- ----------------------------
-- Records of custom_tiaoma_子表
-- ----------------------------
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336866', '2023-02-02 20:19:17', '', '', '0', '', '0', '', '0', '7272499656519589915', '中华人民共和国121', 'b');
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336882', '2023-02-06 16:14:36', null, null, '0', null, null, null, null, '7283409148329336881', 'sd', 'D');
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336885', '2023-02-06 16:15:03', null, null, '0', null, null, null, null, '7283409148329336884', '新增测设', '1');
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336890', '2023-02-06 16:15:04', null, null, '0', null, null, null, null, '7283409148329336889', '1xxx', '2');
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336900', '2023-02-06 16:15:05', null, null, '0', null, null, null, null, '7283409148329336899', '1', '3');
INSERT INTO `custom_tiaoma_子表` VALUES ('7283409148329336904', '2023-02-06 16:15:06', null, null, '0', null, null, null, null, '7283409148329336937', 'lxs123', '4');

-- ----------------------------
-- Table structure for custom_tiaoma_子表_copy
-- ----------------------------
DROP TABLE IF EXISTS `custom_tiaoma_子表_copy`;
CREATE TABLE `custom_tiaoma_子表_copy` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `company_scope` varchar(255) DEFAULT NULL COMMENT '数据隔离',
  `state` varchar(20) DEFAULT '0' COMMENT '数据状态',
  `create_user` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `dept_name` varchar(50) DEFAULT NULL COMMENT '创建人部门名',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '创建人部门名Id',
  `pid` bigint(20) DEFAULT NULL COMMENT 'pid',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `age_a_b` varchar(255) DEFAULT NULL COMMENT 'age',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=' 子表 ';

-- ----------------------------
-- Records of custom_tiaoma_子表_copy
-- ----------------------------
INSERT INTO `custom_tiaoma_子表_copy` VALUES ('7283409148329336925', '2023-02-06 16:14:07', null, null, '0', null, null, null, null, '7283409148329336924', 'sdf', '1');
INSERT INTO `custom_tiaoma_子表_copy` VALUES ('7283409148329336929', '2023-02-06 15:29:55', null, null, '0', null, null, null, null, '7283409148329336928', 'sdf', null);
INSERT INTO `custom_tiaoma_子表_copy` VALUES ('7283409148329336933', '2023-02-06 15:34:34', null, null, '0', null, null, null, null, '7283409148329336932', 'aaaa', null);
INSERT INTO `custom_tiaoma_子表_copy` VALUES ('7283409148329336938', '2023-02-06 15:52:20', null, null, '0', null, null, null, null, '7283409148329336937', '666', null);

-- ----------------------------
-- Function structure for get_trans_num
-- ----------------------------
DROP FUNCTION IF EXISTS `get_trans_num`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` FUNCTION `get_trans_num`(`seq_name` VARCHAR(30)) RETURNS varchar(24) CHARSET utf8mb4
BEGIN

DECLARE getval VARCHAR (24);


SET getval = (
	SELECT
		CONCAT(seq_name,
			DATE_FORMAT(NOW(), '%Y%m%d%H%i%s'),
			LPAD(
				(
					SELECT
						next_trans_num (seq_name)
				),
				5,
				'0'
			)
		)
);

RETURN getval;


END
;;
DELIMITER ;

-- ----------------------------
-- Function structure for next_trans_num
-- ----------------------------
DROP FUNCTION IF EXISTS `next_trans_num`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` FUNCTION `next_trans_num`(`seq_name` VARCHAR(30)) RETURNS int(11)
BEGIN
	UPDATE custom_tiaoma_sequence
SET
VALUE
	= last_insert_id(VALUE + next)
WHERE
	NAME = `seq_name`;

RETURN last_insert_id();


END
;;
DELIMITER ;

-- ----------------------------
-- Event structure for clearnsequence
-- ----------------------------
DROP EVENT IF EXISTS `clearnsequence`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` EVENT `clearnsequence` ON SCHEDULE EVERY 1 DAY STARTS '2022-12-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE COMMENT '定时清空表custom_tiaoma_sequence中的value值' DO UPDATE custom_tiaoma_sequence
SET
`VALUE`
	= 0
;;
DELIMITER ;
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

梁晓山（ben）

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值