23 lines
964 B
MySQL
23 lines
964 B
MySQL
|
-- 插入主表
|
|||
|
|
INSERT INTO `sys_code_rule` (
|
|||
|
|
`remark`, `create_by`, `create_time`, `update_by`, `update_time`,
|
|||
|
|
`number`, `name`, `basic_domain`, `status`
|
|||
|
|
) VALUES (
|
|||
|
|
'报工质检单号生成规则：BGZJ + 年月日 + 3位流水号（每天重置）',
|
|||
|
|
'admin', NOW(), 'admin', NOW(),
|
|||
|
|
'BGZJ', '报工质检编码规则', 'ReportQuality', 'active'
|
|||
|
|
);
|
|||
|
|
|
|||
|
|
-- 获取主表ID并批量插入子表
|
|||
|
|
SET @new_rule_id = LAST_INSERT_ID();
|
|||
|
|
|
|||
|
|
INSERT INTO `sys_code_rule_entry` (
|
|||
|
|
`rule_id`, `sort`, `type_id`, `length_flow`, `max_flow`,
|
|||
|
|
`date_format`, `constant_char`, `element_source_table`, `source_attribute`,
|
|||
|
|
`source_value`, `code_cover`, `max_date`
|
|||
|
|
) VALUES
|
|||
|
|
(@new_rule_id, 1, 'B', NULL, NULL, '', 'BGZJ', NULL, NULL, NULL, '', NULL),
|
|||
|
|
(@new_rule_id, 2, 'C', NULL, NULL, 'yyyyMMdd', '', NULL, NULL, NULL, '', NULL),
|
|||
|
|
(@new_rule_id, 3, 'A', 3, 1, '', '', NULL, NULL, NULL, '0', NULL);
|
|||
|
|
|
|||
|
|
COMMIT;
|