168 lines
40 KiB
SQL
168 lines
40 KiB
SQL
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info';
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "TABLE_NAME", "TABLE_DESCRIBE", "TABLE_TYPE", "TABLE_CLASSIFY", "TABLE_ID_TYPE", "TABLE_SELECT", "IS_DB_SYNC", "IS_DES_FORM", "SUB_TABLE_MAPPING", "SUB_TABLE_SORT", "SUB_TABLE_TITLE", "THEME_TEMPLATE", "DESFORM_WEB_ID", "TREE_STYLE", "TREE_MODE", "TREE_LABEL_FIELD", "OPERATE_MENU_STYLE", "MAX_MENU_NUM", "FORM_STYLE", "SUB_TABLE_LIST_STR", "VIEW_DEFAULT_FIELD", "GROUP_DBFORM_ID", "ORDERBY_CONFIG", "WHERE_CONFIG", "DATA_CONFIG", "BASIC_FUNCTION", "BASIC_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "TABLE_STYLE", "IMPORT_DUPLICATE_TYPE") values(1960952987557363713, 1, 1, '2025-08-27 10:01:55', 100, 1, '2025-09-25 15:56:30', 0, 'campus_info', '园区表', 1, 1, 'NATIVE', 'multiple', 'Y', 'N', '', 0, '', 'normal', null, 'default', 'default', '', 'more', 1, 2, '', 'N', null, '[{"order":"desc","column":"id"}]', null, 'page,initDataReq,authFalse', 'addBtn,editBtn,viewBtn,delBtn,batchDelBtn,importBtn,exportBtn', '', 'height,header,menu,index,border,rollBottom', '', '{"singleStyle":"default","singleCardSpan":"","expandShowNum":null,"expandMode":"","searchStyle":"default"}', 'update');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_ENHANCE_JAVA" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_ENHANCE_JS" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_ENHANCE_SQL" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255938, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '主键', 128, 0, '', 'BigInt', '', 'Y', 'N', 1, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255939, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', '阿里园区主键', 128, 0, '', 'BigInt', '', 'N', 'Y', 2, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255940, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', '园区名称', 256, 0, '', 'String', '', 'N', 'Y', 3, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255941, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', '园区状态', 128, 0, '', 'Integer', '', 'N', 'Y', 4, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255942, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '租户编号', 128, 0, '', 'BigInt', '', 'N', 'Y', 7, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255943, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '创建人', 128, 0, '', 'BigInt', '', 'N', 'Y', 8, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255944, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '创建时间', 128, 0, '', 'DateTime', '', 'N', 'Y', 9, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255945, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '创建部门id', 128, 0, '', 'BigInt', '', 'N', 'Y', 10, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255946, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '更新人', 128, 0, '', 'BigInt', '', 'N', 'Y', 11, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255947, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '更新时间', 128, 0, '', 'DateTime', '', 'N', 'Y', 12, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960523136921255948, 1, 1, '2025-08-27 10:01:55', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '是否删除', 2, 0, '0', 'Integer', '', 'N', 'Y', 13, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960526529018478594, 1, 1, '2025-08-27 10:15:24', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', '区域ID_', 128, 0, '', 'BigInt', '', 'N', 'Y', 5, 'Y');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_LEN", "FIELD_POINT_LEN", "FIELD_DEFAULT_VAL", "FIELD_TYPE", "FIELD_REMARK", "IS_PRIMARY_KEY", "IS_NULL", "SORT_NUM", "IS_DB") values(1960526529018478595, 1, 1, '2025-08-27 10:15:24', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', '园区形象图', 256, 0, '', 'String', '', 'N', 'Y', 6, 'Y');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147202, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147203, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147204, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147205, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147206, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147207, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147208, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147209, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147210, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147211, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147212, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147213, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '', '', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_DICT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "DICT_TYPE", "DICT_CODE", "DICT_TABLE", "DICT_TEXT", "DICT_TABLE_COLUMN", "DICT_TEXT_FORMATTER", "DICT_TABLE_SEARCH") values(1971108898788147214, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '', '', '', '', '', '', '');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587713, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587714, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587715, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587716, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587717, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587718, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587719, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587720, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587721, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587722, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587723, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587724, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_EXPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_IMPORT", "IS_EXPORT", "IMPORT_EXAMPLE_TXT", "IS_IMPORT_DUPLICATE") values(1971108898905587725, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '', '', '', '');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307969, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307970, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307971, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307972, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307973, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307974, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307975, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307976, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307977, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307978, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307979, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307980, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_FOREIGNKEY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "MAIN_TABLE", "MAIN_FIELD") values(1971108898964307981, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '', '');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942785, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942786, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942787, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942788, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942789, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942790, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942791, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942792, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942793, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942794, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942795, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942796, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '', '', '', '', '');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_QUERY"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "QUERY_CONFIG", "QUERY_DEFAULT_VAL") values(1971108899085942797, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '', '', '', '', '');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445314, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'id', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''主键'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445315, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_id', 'Y', 'N', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''阿里园区主键'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445316, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'campus_name', 'Y', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445317, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'status', 'Y', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区状态'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445318, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'region_id', 'Y', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''区域ID_'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445319, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'pic_url', 'Y', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区形象图'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445320, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'tenant_id', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''租户编号'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445321, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_user', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''创建人'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445322, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_time', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''创建时间'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445323, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'create_dept', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''创建部门id'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445324, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_user', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''更新人'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445325, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'update_time', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''更新时间'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_DBFORM_FIELD_WEB"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "DBFORM_ID", "FIELD_CODE", "IS_DB_SELECT", "IS_SHOW_LIST", "IS_SHOW_FORM", "IS_SHOW_COLUMN", "IS_SHOW_SORT", "IS_REQUIRED", "CONTROL_TYPE", "CONTROLS_CONFIG", "CELL_WIDTH", "CELL_WIDTH_TYPE", "VERIFY_CONFIG", "FORMAT_CONFIG", "LABEL_I18N") values(1971108899010445326, 1, 1, '2025-09-25 15:05:58', 100, null, '2025-09-25 15:56:30', 0, 1960952987557363713, 'is_deleted', '', '', '', '', '', '', '', '', '', '', '', '{"formatType":"","formatJson":{"sql":{},"java":{},"fun":""}}', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''是否删除'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DBFORM_BUTTON" where dbform_id in (select id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|
|
|
|
delete from "LOWCODE_FRAME"."LOWCODE_DESFORM" where id in (select desform_web_id from "LOWCODE_FRAME"."LOWCODE_DBFORM" where TABLE_NAME = 'campus_info');
|