szhxy-app sql记录
<ol>
<li>访客登记新增字典:</li>
</ol>
<p>INSERT INTO <code>digital_szhxy</code>.<code>base_code</code> (<code>OBJ_ID</code>, <code>B_ID</code>, <code>B_NAME</code>, <code>C_ID</code>, <code>C_NAME</code>, <code>C_ORDER</code>) VALUES (UUID(), 'visitMatter', '来访事由', 'visitMatter_01', '商务洽谈', 1);
INSERT INTO <code>digital_szhxy</code>.<code>base_code</code> (<code>OBJ_ID</code>, <code>B_ID</code>, <code>B_NAME</code>, <code>C_ID</code>, <code>C_NAME</code>, <code>C_ORDER</code>) VALUES (UUID(), 'visitMatter', '来访事由', 'visitMatter_02', '技术交流', 2);
INSERT INTO <code>digital_szhxy</code>.<code>base_code</code> (<code>OBJ_ID</code>, <code>B_ID</code>, <code>B_NAME</code>, <code>C_ID</code>, <code>C_NAME</code>, <code>C_ORDER</code>) VALUES (UUID(), 'visitMatter', '来访事由', 'visitMatter_03', '参观学习', 3);
INSERT INTO <code>digital_szhxy</code>.<code>base_code</code> (<code>OBJ_ID</code>, <code>B_ID</code>, <code>B_NAME</code>, <code>C_ID</code>, <code>C_NAME</code>, <code>C_ORDER</code>) VALUES (UUID(), 'visitMatter', '来访事由', 'visitMatter_04', '其他内容', 4);</p>
<ol>
<li>
<p>sys_serial_number新增记录
INSERT INTO <code>digital_szhxy</code>.<code>sys_serial_number</code> (<code>ID</code>, <code>MODULE_NAME</code>, <code>MODULE_CODE</code>, <code>CONFIG_TEMPLET</code>, <code>MAX_SERIAL</code>, <code>PRE_MAX_NUM</code>, <code>IS_AUOT_INCREMENT</code>) VALUES ('66', '访客申请', 'visitApply', 'FKSQ_${DATE}_000', '0', '100', '0');</p>
</li>
<li>修改angular.org_use 刘萌、赵朋涛new_id
update angular.org_use set NEW<em>ID = '402880ab5d870f57015d885db2670013' where fullname</em> = '赵朋涛';
update angular.org_use set NEW<em>ID = '297efcce5e8d47c9015eb86ed61503c8' where fullname</em> = '刘萌';</li>
</ol>