数字化校园APP


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>

页面列表

ITEM_HTML