1 Star 1 Fork 1

大湿胸/iFramework By Jeesite-Eclipse

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
创建数据库列表.sql 66.20 KB
一键复制 编辑 原始数据 按行查看 历史
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822
SET SESSION FOREIGN_KEY_CHECKS=0;
/* Drop Indexes */
DROP INDEX ACT_FK_BYTEARR_DEPL ON act_ge_bytearray;
DROP INDEX ACT_IDX_HI_ACT_INST_END ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_EXEC ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_PROCINST ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_START ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_DETAIL_ACT_INST ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_NAME ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_PROC_INST ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_TASK_ID ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_TIME ON act_hi_detail;
DROP INDEX ACT_IDX_HI_IDENT_LNK_PROCINST ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_IDENT_LNK_TASK ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_IDENT_LNK_USER ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_PRO_I_BUSKEY ON act_hi_procinst;
DROP INDEX ACT_IDX_HI_PRO_INST_END ON act_hi_procinst;
DROP INDEX ACT_IDX_HI_PROCVAR_NAME_TYPE ON act_hi_varinst;
DROP INDEX ACT_IDX_HI_PROCVAR_PROC_INST ON act_hi_varinst;
DROP INDEX ACT_FK_MEMB_GROUP ON act_id_membership;
DROP INDEX ACT_FK_MODEL_DEPLOYMENT ON act_re_model;
DROP INDEX ACT_FK_MODEL_SOURCE ON act_re_model;
DROP INDEX ACT_FK_MODEL_SOURCE_EXTRA ON act_re_model;
DROP INDEX ACT_UNIQ_PROCDEF ON act_re_procdef;
DROP INDEX ACT_FK_EVENT_EXEC ON act_ru_event_subscr;
DROP INDEX ACT_IDX_EVENT_SUBSCR_CONFIG_ ON act_ru_event_subscr;
DROP INDEX ACT_FK_EXE_PARENT ON act_ru_execution;
DROP INDEX ACT_FK_EXE_PROCDEF ON act_ru_execution;
DROP INDEX ACT_FK_EXE_PROCINST ON act_ru_execution;
DROP INDEX ACT_FK_EXE_SUPER ON act_ru_execution;
DROP INDEX ACT_IDX_EXEC_BUSKEY ON act_ru_execution;
DROP INDEX ACT_FK_IDL_PROCINST ON act_ru_identitylink;
DROP INDEX ACT_FK_TSKASS_TASK ON act_ru_identitylink;
DROP INDEX ACT_IDX_ATHRZ_PROCEDEF ON act_ru_identitylink;
DROP INDEX ACT_IDX_IDENT_LNK_GROUP ON act_ru_identitylink;
DROP INDEX ACT_IDX_IDENT_LNK_USER ON act_ru_identitylink;
DROP INDEX ACT_FK_JOB_EXCEPTION ON act_ru_job;
DROP INDEX ACT_FK_TASK_EXE ON act_ru_task;
DROP INDEX ACT_FK_TASK_PROCDEF ON act_ru_task;
DROP INDEX ACT_FK_TASK_PROCINST ON act_ru_task;
DROP INDEX ACT_IDX_TASK_CREATE ON act_ru_task;
DROP INDEX ACT_FK_VAR_BYTEARRAY ON act_ru_variable;
DROP INDEX ACT_FK_VAR_EXE ON act_ru_variable;
DROP INDEX ACT_FK_VAR_PROCINST ON act_ru_variable;
DROP INDEX ACT_IDX_VARIABLE_TASK_ID ON act_ru_variable;
DROP INDEX cms_article_category_id ON cms_article;
DROP INDEX cms_article_create_by ON cms_article;
DROP INDEX cms_article_del_flag ON cms_article;
DROP INDEX cms_article_keywords ON cms_article;
DROP INDEX cms_article_title ON cms_article;
DROP INDEX cms_article_update_date ON cms_article;
DROP INDEX cms_article_weight ON cms_article;
DROP INDEX cms_category_del_flag ON cms_category;
DROP INDEX cms_category_module ON cms_category;
DROP INDEX cms_category_name ON cms_category;
DROP INDEX cms_category_office_id ON cms_category;
DROP INDEX cms_category_parent_id ON cms_category;
DROP INDEX cms_category_site_id ON cms_category;
DROP INDEX cms_category_sort ON cms_category;
DROP INDEX cms_comment_category_id ON cms_comment;
DROP INDEX cms_comment_content_id ON cms_comment;
DROP INDEX cms_comment_status ON cms_comment;
DROP INDEX cms_guestbook_del_flag ON cms_guestbook;
DROP INDEX cms_link_category_id ON cms_link;
DROP INDEX cms_link_create_by ON cms_link;
DROP INDEX cms_link_del_flag ON cms_link;
DROP INDEX cms_link_title ON cms_link;
DROP INDEX cms_link_update_date ON cms_link;
DROP INDEX cms_link_weight ON cms_link;
DROP INDEX cms_site_del_flag ON cms_site;
DROP INDEX gen_scheme_del_flag ON gen_scheme;
DROP INDEX gen_table_del_flag ON gen_table;
DROP INDEX gen_table_name ON gen_table;
DROP INDEX gen_table_column_del_flag ON gen_table_column;
DROP INDEX gen_table_column_name ON gen_table_column;
DROP INDEX gen_table_column_sort ON gen_table_column;
DROP INDEX gen_table_column_table_id ON gen_table_column;
DROP INDEX gen_template_del_falg ON gen_template;
DROP INDEX oa_leave_create_by ON oa_leave;
DROP INDEX oa_leave_del_flag ON oa_leave;
DROP INDEX oa_leave_process_instance_id ON oa_leave;
DROP INDEX oa_notify_del_flag ON oa_notify;
DROP INDEX oa_notify_record_notify_id ON oa_notify_record;
DROP INDEX oa_notify_record_read_flag ON oa_notify_record;
DROP INDEX oa_notify_record_user_id ON oa_notify_record;
DROP INDEX OA_TEST_AUDIT_del_flag ON oa_test_audit;
DROP INDEX sys_area_del_flag ON sys_area;
DROP INDEX sys_area_parent_id ON sys_area;
DROP INDEX sys_dict_del_flag ON sys_dict;
DROP INDEX sys_dict_label ON sys_dict;
DROP INDEX sys_dict_value ON sys_dict;
DROP INDEX sys_log_create_by ON sys_log;
DROP INDEX sys_log_create_date ON sys_log;
DROP INDEX sys_log_request_uri ON sys_log;
DROP INDEX sys_log_type ON sys_log;
DROP INDEX sys_mdict_del_flag ON sys_mdict;
DROP INDEX sys_mdict_parent_id ON sys_mdict;
DROP INDEX sys_menu_del_flag ON sys_menu;
DROP INDEX sys_menu_parent_id ON sys_menu;
DROP INDEX sys_office_del_flag ON sys_office;
DROP INDEX sys_office_parent_id ON sys_office;
DROP INDEX sys_office_type ON sys_office;
DROP INDEX sys_role_del_flag ON sys_role;
DROP INDEX sys_role_enname ON sys_role;
DROP INDEX sys_user_company_id ON sys_user;
DROP INDEX sys_user_del_flag ON sys_user;
DROP INDEX sys_user_login_name ON sys_user;
DROP INDEX sys_user_office_id ON sys_user;
DROP INDEX sys_user_update_date ON sys_user;
DROP INDEX test_data_del_flag ON test_data;
DROP INDEX test_data_child_del_flag ON test_data_child;
DROP INDEX test_data_main_del_flag ON test_data_main;
DROP INDEX test_data_parent_id ON test_tree;
DROP INDEX test_tree_del_flag ON test_tree;
/* Drop Tables */
DROP TABLE IF EXISTS act_re_model;
DROP TABLE IF EXISTS act_ru_job;
DROP TABLE IF EXISTS act_ru_variable;
DROP TABLE IF EXISTS act_ge_bytearray;
DROP TABLE IF EXISTS act_ge_property;
DROP TABLE IF EXISTS act_hi_actinst;
DROP TABLE IF EXISTS act_hi_attachment;
DROP TABLE IF EXISTS act_hi_comment;
DROP TABLE IF EXISTS act_hi_detail;
DROP TABLE IF EXISTS act_hi_identitylink;
DROP TABLE IF EXISTS act_hi_procinst;
DROP TABLE IF EXISTS act_hi_taskinst;
DROP TABLE IF EXISTS act_hi_varinst;
DROP TABLE IF EXISTS act_id_membership;
DROP TABLE IF EXISTS act_id_group;
DROP TABLE IF EXISTS act_id_info;
DROP TABLE IF EXISTS act_id_user;
DROP TABLE IF EXISTS act_re_deployment;
DROP TABLE IF EXISTS act_ru_event_subscr;
DROP TABLE IF EXISTS act_ru_identitylink;
DROP TABLE IF EXISTS act_ru_task;
DROP TABLE IF EXISTS act_ru_execution;
DROP TABLE IF EXISTS act_re_procdef;
DROP TABLE IF EXISTS cms_article;
DROP TABLE IF EXISTS cms_article_data;
DROP TABLE IF EXISTS cms_db;
DROP TABLE IF EXISTS cms_bussines_system;
DROP TABLE IF EXISTS cms_category;
DROP TABLE IF EXISTS cms_comment;
DROP TABLE IF EXISTS cms_guestbook;
DROP TABLE IF EXISTS cms_link;
DROP TABLE IF EXISTS cms_site;
DROP TABLE IF EXISTS gen_scheme;
DROP TABLE IF EXISTS gen_table;
DROP TABLE IF EXISTS gen_table_column;
DROP TABLE IF EXISTS gen_template;
DROP TABLE IF EXISTS oa_leave;
DROP TABLE IF EXISTS oa_notify;
DROP TABLE IF EXISTS oa_notify_record;
DROP TABLE IF EXISTS oa_test_audit;
DROP TABLE IF EXISTS sys_area;
DROP TABLE IF EXISTS sys_dict;
DROP TABLE IF EXISTS sys_log;
DROP TABLE IF EXISTS sys_mdict;
DROP TABLE IF EXISTS sys_menu;
DROP TABLE IF EXISTS sys_office;
DROP TABLE IF EXISTS sys_role;
DROP TABLE IF EXISTS sys_role_menu;
DROP TABLE IF EXISTS sys_role_office;
DROP TABLE IF EXISTS sys_user;
DROP TABLE IF EXISTS sys_user_role;
DROP TABLE IF EXISTS test_data;
DROP TABLE IF EXISTS test_data_child;
DROP TABLE IF EXISTS test_data_main;
DROP TABLE IF EXISTS test_tree;
/* Create Tables */
CREATE TABLE act_ge_bytearray
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
NAME_ varchar(255) BINARY,
DEPLOYMENT_ID_ varchar(64) BINARY,
BYTES_ longblob,
GENERATED_ tinyint,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ge_property
(
NAME_ varchar(64) BINARY NOT NULL,
VALUE_ varchar(300) BINARY,
REV_ int,
PRIMARY KEY (NAME_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_actinst
(
ID_ varchar(64) BINARY NOT NULL,
PROC_DEF_ID_ varchar(64) BINARY NOT NULL,
PROC_INST_ID_ varchar(64) BINARY NOT NULL,
EXECUTION_ID_ varchar(64) BINARY NOT NULL,
ACT_ID_ varchar(255) BINARY NOT NULL,
TASK_ID_ varchar(64) BINARY,
CALL_PROC_INST_ID_ varchar(64) BINARY,
ACT_NAME_ varchar(255) BINARY,
ACT_TYPE_ varchar(255) BINARY NOT NULL,
ASSIGNEE_ varchar(255) BINARY,
START_TIME_ datetime NOT NULL,
END_TIME_ datetime,
DURATION_ bigint(20),
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_attachment
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
USER_ID_ varchar(255) BINARY,
NAME_ varchar(255) BINARY,
DESCRIPTION_ varchar(4000) BINARY,
TYPE_ varchar(255) BINARY,
TASK_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
URL_ varchar(4000) BINARY,
CONTENT_ID_ varchar(64) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_comment
(
ID_ varchar(64) BINARY NOT NULL,
TYPE_ varchar(255) BINARY,
TIME_ datetime NOT NULL,
USER_ID_ varchar(255) BINARY,
TASK_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
ACTION_ varchar(255) BINARY,
MESSAGE_ varchar(4000) BINARY,
FULL_MSG_ longblob,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_detail
(
ID_ varchar(64) BINARY NOT NULL,
TYPE_ varchar(255) BINARY NOT NULL,
PROC_INST_ID_ varchar(64) BINARY,
EXECUTION_ID_ varchar(64) BINARY,
TASK_ID_ varchar(64) BINARY,
ACT_INST_ID_ varchar(64) BINARY,
NAME_ varchar(255) BINARY NOT NULL,
VAR_TYPE_ varchar(255) BINARY,
REV_ int,
TIME_ datetime NOT NULL,
BYTEARRAY_ID_ varchar(64) BINARY,
DOUBLE_ double,
LONG_ bigint(20),
TEXT_ varchar(4000) BINARY,
TEXT2_ varchar(4000) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_identitylink
(
ID_ varchar(64) BINARY NOT NULL,
GROUP_ID_ varchar(255) BINARY,
TYPE_ varchar(255) BINARY,
USER_ID_ varchar(255) BINARY,
TASK_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_procinst
(
ID_ varchar(64) BINARY NOT NULL,
PROC_INST_ID_ varchar(64) BINARY NOT NULL,
BUSINESS_KEY_ varchar(255) BINARY,
PROC_DEF_ID_ varchar(64) BINARY NOT NULL,
START_TIME_ datetime NOT NULL,
END_TIME_ datetime,
DURATION_ bigint(20),
START_USER_ID_ varchar(255) BINARY,
START_ACT_ID_ varchar(255) BINARY,
END_ACT_ID_ varchar(255) BINARY,
SUPER_PROCESS_INSTANCE_ID_ varchar(64) BINARY,
DELETE_REASON_ varchar(4000) BINARY,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_),
UNIQUE (PROC_INST_ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_taskinst
(
ID_ varchar(64) BINARY NOT NULL,
PROC_DEF_ID_ varchar(64) BINARY,
TASK_DEF_KEY_ varchar(255) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
EXECUTION_ID_ varchar(64) BINARY,
NAME_ varchar(255) BINARY,
PARENT_TASK_ID_ varchar(64) BINARY,
DESCRIPTION_ varchar(4000) BINARY,
OWNER_ varchar(255) BINARY,
ASSIGNEE_ varchar(255) BINARY,
START_TIME_ datetime NOT NULL,
CLAIM_TIME_ datetime,
END_TIME_ datetime,
DURATION_ bigint(20),
DELETE_REASON_ varchar(4000) BINARY,
PRIORITY_ int,
DUE_DATE_ datetime,
FORM_KEY_ varchar(255) BINARY,
CATEGORY_ varchar(255) BINARY,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_hi_varinst
(
ID_ varchar(64) BINARY NOT NULL,
PROC_INST_ID_ varchar(64) BINARY,
EXECUTION_ID_ varchar(64) BINARY,
TASK_ID_ varchar(64) BINARY,
NAME_ varchar(255) BINARY NOT NULL,
VAR_TYPE_ varchar(100) BINARY,
REV_ int,
BYTEARRAY_ID_ varchar(64) BINARY,
DOUBLE_ double,
LONG_ bigint(20),
TEXT_ varchar(4000) BINARY,
TEXT2_ varchar(4000) BINARY,
CREATE_TIME_ datetime,
LAST_UPDATED_TIME_ datetime,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_id_group
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
NAME_ varchar(255) BINARY,
TYPE_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_id_info
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
USER_ID_ varchar(64) BINARY,
TYPE_ varchar(64) BINARY,
KEY_ varchar(255) BINARY,
VALUE_ varchar(255) BINARY,
PASSWORD_ longblob,
PARENT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_id_membership
(
USER_ID_ varchar(64) BINARY NOT NULL,
GROUP_ID_ varchar(64) BINARY NOT NULL,
PRIMARY KEY (USER_ID_, GROUP_ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_id_user
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
FIRST_ varchar(255) BINARY,
LAST_ varchar(255) BINARY,
EMAIL_ varchar(255) BINARY,
PWD_ varchar(255) BINARY,
PICTURE_ID_ varchar(64) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_re_deployment
(
ID_ varchar(64) BINARY NOT NULL,
NAME_ varchar(255) BINARY,
CATEGORY_ varchar(255) BINARY,
TENANT_ID_ varchar(255) BINARY,
DEPLOY_TIME_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_re_model
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
NAME_ varchar(255) BINARY,
KEY_ varchar(255) BINARY,
CATEGORY_ varchar(255) BINARY,
CREATE_TIME_ timestamp,
LAST_UPDATE_TIME_ timestamp,
VERSION_ int,
META_INFO_ varchar(4000) BINARY,
DEPLOYMENT_ID_ varchar(64) BINARY,
EDITOR_SOURCE_VALUE_ID_ varchar(64) BINARY,
EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64) BINARY,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_re_procdef
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
CATEGORY_ varchar(255) BINARY,
NAME_ varchar(255) BINARY,
KEY_ varchar(255) BINARY NOT NULL,
VERSION_ int NOT NULL,
DEPLOYMENT_ID_ varchar(64) BINARY,
RESOURCE_NAME_ varchar(4000) BINARY,
DGRM_RESOURCE_NAME_ varchar(4000) BINARY,
DESCRIPTION_ varchar(4000) BINARY,
HAS_START_FORM_KEY_ tinyint,
SUSPENSION_STATE_ int,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_event_subscr
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
EVENT_TYPE_ varchar(255) BINARY NOT NULL,
EVENT_NAME_ varchar(255) BINARY,
EXECUTION_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
ACTIVITY_ID_ varchar(64) BINARY,
CONFIGURATION_ varchar(255) BINARY,
CREATED_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
PROC_DEF_ID_ varchar(64) BINARY,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_execution
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
PROC_INST_ID_ varchar(64) BINARY,
BUSINESS_KEY_ varchar(255) BINARY,
PARENT_ID_ varchar(64) BINARY,
PROC_DEF_ID_ varchar(64) BINARY,
SUPER_EXEC_ varchar(64) BINARY,
ACT_ID_ varchar(255) BINARY,
IS_ACTIVE_ tinyint,
IS_CONCURRENT_ tinyint,
IS_SCOPE_ tinyint,
IS_EVENT_SCOPE_ tinyint,
SUSPENSION_STATE_ int,
CACHED_ENT_STATE_ int,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_identitylink
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
GROUP_ID_ varchar(255) BINARY,
TYPE_ varchar(255) BINARY,
USER_ID_ varchar(255) BINARY,
TASK_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
PROC_DEF_ID_ varchar(64) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_job
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
TYPE_ varchar(255) BINARY NOT NULL,
LOCK_EXP_TIME_ timestamp,
LOCK_OWNER_ varchar(255) BINARY,
EXCLUSIVE_ boolean,
EXECUTION_ID_ varchar(64) BINARY,
PROCESS_INSTANCE_ID_ varchar(64) BINARY,
PROC_DEF_ID_ varchar(64) BINARY,
RETRIES_ int,
EXCEPTION_STACK_ID_ varchar(64) BINARY,
EXCEPTION_MSG_ varchar(4000) BINARY,
DUEDATE_ timestamp,
REPEAT_ varchar(255) BINARY,
HANDLER_TYPE_ varchar(255) BINARY,
HANDLER_CFG_ varchar(4000) BINARY,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_task
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
EXECUTION_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
PROC_DEF_ID_ varchar(64) BINARY,
NAME_ varchar(255) BINARY,
PARENT_TASK_ID_ varchar(64) BINARY,
DESCRIPTION_ varchar(4000) BINARY,
TASK_DEF_KEY_ varchar(255) BINARY,
OWNER_ varchar(255) BINARY,
ASSIGNEE_ varchar(255) BINARY,
DELEGATION_ varchar(64) BINARY,
PRIORITY_ int,
CREATE_TIME_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
DUE_DATE_ datetime,
CATEGORY_ varchar(255) BINARY,
SUSPENSION_STATE_ int,
TENANT_ID_ varchar(255) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE act_ru_variable
(
ID_ varchar(64) BINARY NOT NULL,
REV_ int,
TYPE_ varchar(255) BINARY NOT NULL,
NAME_ varchar(255) BINARY NOT NULL,
EXECUTION_ID_ varchar(64) BINARY,
PROC_INST_ID_ varchar(64) BINARY,
TASK_ID_ varchar(64) BINARY,
BYTEARRAY_ID_ varchar(64) BINARY,
DOUBLE_ double,
LONG_ bigint(20),
TEXT_ varchar(4000) BINARY,
TEXT2_ varchar(4000) BINARY,
PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE cms_article
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏍忕洰缂栧彿
category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
-- 鏍囬
title varchar(255) NOT NULL COMMENT '鏍囬',
-- 鏂囩珷閾炬帴
link varchar(255) COMMENT '鏂囩珷閾炬帴',
-- 鏍囬棰滆壊
color varchar(50) COMMENT '鏍囬棰滆壊',
-- 鏂囩珷鍥剧墖
image varchar(255) COMMENT '鏂囩珷鍥剧墖',
-- 鍏抽敭瀛� keywords varchar(255) COMMENT '鍏抽敭瀛�,
-- 鎻忚堪銆佹憳瑕� description varchar(255) COMMENT '鎻忚堪銆佹憳瑕�,
-- 鏉冮噸锛岃秺澶ц秺闈犲墠
weight int DEFAULT 0 COMMENT '鏉冮噸锛岃秺澶ц秺闈犲墠',
-- 鏉冮噸鏈熼檺
weight_date datetime COMMENT '鏉冮噸鏈熼檺',
-- 鐐瑰嚮鏁� hits int DEFAULT 0 COMMENT '鐐瑰嚮鏁�,
-- 鎺ㄨ崘浣嶏紝澶氶�
posid varchar(10) COMMENT '鎺ㄨ崘浣嶏紝澶氶�',
-- 鑷畾涔夊唴瀹硅鍥� custom_content_view varchar(255) COMMENT '鑷畾涔夊唴瀹硅鍥�,
-- 瑙嗗浘閰嶇疆
view_config text COMMENT '瑙嗗浘閰嶇疆',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_article_data
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏂囩珷鍐呭
content text COMMENT '鏂囩珷鍐呭',
-- 鏂囩珷鏉ユ簮
copyfrom varchar(255) COMMENT '鏂囩珷鏉ユ簮',
-- 鐩稿叧鏂囩珷
relation varchar(255) COMMENT '鐩稿叧鏂囩珷',
-- 鏄惁鍏佽璇勮
allow_comment char COMMENT '鏄惁鍏佽璇勮',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_bussines_system
(
-- 涓氬姟绯荤粺缂栧彿
buss_sys_id varchar(64) NOT NULL COMMENT '涓氬姟绯荤粺缂栧彿',
-- 涓氬姟绯荤粺鍚嶇О
name text NOT NULL COMMENT '涓氬姟绯荤粺鍚嶇О',
-- 绯荤粺寮�彂鍏徃
company text NOT NULL COMMENT '绯荤粺寮�彂鍏徃',
-- 缁存姢浜哄憳
maintenance_personnel text COMMENT '缁存姢浜哄憳',
-- 缁存姢鑱旂郴鐢佃瘽
Maintenance_call varchar(64) COMMENT '缁存姢鑱旂郴鐢佃瘽',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
PRIMARY KEY (buss_sys_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_category
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 绔欑偣缂栧彿
site_id varchar(64) DEFAULT '1' COMMENT '绔欑偣缂栧彿',
-- 褰掑睘鏈烘瀯
office_id varchar(64) COMMENT '褰掑睘鏈烘瀯',
-- 鏍忕洰妯″潡
module varchar(20) COMMENT '鏍忕洰妯″潡',
-- 鏍忕洰鍚嶇О
name varchar(100) NOT NULL COMMENT '鏍忕洰鍚嶇О',
-- 鏍忕洰鍥剧墖
image varchar(255) COMMENT '鏍忕洰鍥剧墖',
-- 閾炬帴
href varchar(255) COMMENT '閾炬帴',
-- 鐩爣
target varchar(20) COMMENT '鐩爣',
-- 鎻忚堪
description varchar(255) COMMENT '鎻忚堪',
-- 鍏抽敭瀛� keywords varchar(255) COMMENT '鍏抽敭瀛�,
-- 鎺掑簭锛堝崌搴忥級
sort int DEFAULT 30 COMMENT '鎺掑簭锛堝崌搴忥級',
-- 鏄惁鍦ㄥ鑸腑鏄剧ず
in_menu char DEFAULT '1' COMMENT '鏄惁鍦ㄥ鑸腑鏄剧ず',
-- 鏄惁鍦ㄥ垎绫婚〉涓樉绀哄垪琛� in_list char DEFAULT '1' COMMENT '鏄惁鍦ㄥ垎绫婚〉涓樉绀哄垪琛�,
-- 灞曠幇鏂瑰紡
show_modes char DEFAULT '0' COMMENT '灞曠幇鏂瑰紡',
-- 鏄惁鍏佽璇勮
allow_comment char COMMENT '鏄惁鍏佽璇勮',
-- 鏄惁闇�瀹℃牳
is_audit char COMMENT '鏄惁闇�瀹℃牳',
-- 鑷畾涔夊垪琛ㄨ鍥� custom_list_view varchar(255) COMMENT '鑷畾涔夊垪琛ㄨ鍥�,
-- 鑷畾涔夊唴瀹硅鍥� custom_content_view varchar(255) COMMENT '鑷畾涔夊唴瀹硅鍥�,
-- 瑙嗗浘閰嶇疆
view_config text COMMENT '瑙嗗浘閰嶇疆',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_comment
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏍忕洰缂栧彿
category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
-- 鏍忕洰鍐呭鐨勭紪鍙� content_id varchar(64) NOT NULL COMMENT '鏍忕洰鍐呭鐨勭紪鍙�,
-- 鏍忕洰鍐呭鐨勬爣棰� title varchar(255) COMMENT '鏍忕洰鍐呭鐨勬爣棰�,
-- 璇勮鍐呭
content varchar(255) COMMENT '璇勮鍐呭',
-- 璇勮濮撳悕
name varchar(100) COMMENT '璇勮濮撳悕',
-- 璇勮IP
ip varchar(100) COMMENT '璇勮IP',
-- 璇勮鏃堕棿
create_date datetime NOT NULL COMMENT '璇勮鏃堕棿',
-- 瀹℃牳浜� audit_user_id varchar(64) COMMENT '瀹℃牳浜�,
-- 瀹℃牳鏃堕棿
audit_date datetime COMMENT '瀹℃牳鏃堕棿',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_db
(
-- 鏁版嵁搴撶紪鍙� db_id varchar(64) NOT NULL COMMENT '鏁版嵁搴撶紪鍙�,
-- 鍚嶇О
name text NOT NULL COMMENT '鍚嶇О',
-- 绫诲瀷
type int NOT NULL COMMENT '绫诲瀷',
-- 鎿嶄綔绯荤粺绫诲瀷
system_type int NOT NULL COMMENT '鎿嶄綔绯荤粺绫诲瀷',
-- 寤哄簱鏃堕棿
construction_time datetime NOT NULL COMMENT '寤哄簱鏃堕棿',
-- 鏈�悗鎿嶄綔鏃堕棿
last_action_time datetime COMMENT '鏈�悗鎿嶄綔鏃堕棿',
-- 閰嶇疆鏂囦欢璺緞
profile_path longtext NOT NULL COMMENT '閰嶇疆鏂囦欢璺緞',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
-- 涓氬姟绯荤粺缂栧彿
buss_sys_id varchar(64) NOT NULL COMMENT '涓氬姟绯荤粺缂栧彿',
PRIMARY KEY (db_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_guestbook
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐣欒█鍒嗙被
type char NOT NULL COMMENT '鐣欒█鍒嗙被',
-- 鐣欒█鍐呭
content varchar(255) NOT NULL COMMENT '鐣欒█鍐呭',
-- 濮撳悕
name varchar(100) NOT NULL COMMENT '濮撳悕',
-- 閭
email varchar(100) NOT NULL COMMENT '閭',
-- 鐢佃瘽
phone varchar(100) NOT NULL COMMENT '鐢佃瘽',
-- 鍗曚綅
workunit varchar(100) NOT NULL COMMENT '鍗曚綅',
-- IP
ip varchar(100) NOT NULL COMMENT 'IP',
-- 鐣欒█鏃堕棿
create_date datetime NOT NULL COMMENT '鐣欒█鏃堕棿',
-- 鍥炲浜� re_user_id varchar(64) COMMENT '鍥炲浜�,
-- 鍥炲鏃堕棿
re_date datetime COMMENT '鍥炲鏃堕棿',
-- 鍥炲鍐呭
re_content varchar(100) COMMENT '鍥炲鍐呭',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_link
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏍忕洰缂栧彿
category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
-- 閾炬帴鍚嶇О
title varchar(255) NOT NULL COMMENT '閾炬帴鍚嶇О',
-- 鏍囬棰滆壊
color varchar(50) COMMENT '鏍囬棰滆壊',
-- 閾炬帴鍥剧墖
image varchar(255) COMMENT '閾炬帴鍥剧墖',
-- 閾炬帴鍦板潃
href varchar(255) COMMENT '閾炬帴鍦板潃',
-- 鏉冮噸锛岃秺澶ц秺闈犲墠
weight int DEFAULT 0 COMMENT '鏉冮噸锛岃秺澶ц秺闈犲墠',
-- 鏉冮噸鏈熼檺
weight_date datetime COMMENT '鏉冮噸鏈熼檺',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE cms_site
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 绔欑偣鍚嶇О
name varchar(100) NOT NULL COMMENT '绔欑偣鍚嶇О',
-- 绔欑偣鏍囬
title varchar(100) NOT NULL COMMENT '绔欑偣鏍囬',
-- 绔欑偣Logo
logo varchar(255) COMMENT '绔欑偣Logo',
-- 绔欑偣鍩熷悕
domain varchar(255) COMMENT '绔欑偣鍩熷悕',
-- 鎻忚堪
description varchar(255) COMMENT '鎻忚堪',
-- 鍏抽敭瀛� keywords varchar(255) COMMENT '鍏抽敭瀛�,
-- 涓婚
theme varchar(255) DEFAULT 'default' COMMENT '涓婚',
-- 鐗堟潈淇℃伅
copyright text COMMENT '鐗堟潈淇℃伅',
-- 鑷畾涔夌珯鐐归椤佃鍥� custom_index_view varchar(255) COMMENT '鑷畾涔夌珯鐐归椤佃鍥�,
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE gen_scheme
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鍚嶇О
name varchar(200) COMMENT '鍚嶇О',
-- 鍒嗙被
category varchar(2000) COMMENT '鍒嗙被',
-- 鐢熸垚鍖呰矾寰� package_name varchar(500) COMMENT '鐢熸垚鍖呰矾寰�,
-- 鐢熸垚妯″潡鍚� module_name varchar(30) COMMENT '鐢熸垚妯″潡鍚�,
-- 鐢熸垚瀛愭ā鍧楀悕
sub_module_name varchar(30) COMMENT '鐢熸垚瀛愭ā鍧楀悕',
-- 鐢熸垚鍔熻兘鍚� function_name varchar(500) COMMENT '鐢熸垚鍔熻兘鍚�,
-- 鐢熸垚鍔熻兘鍚嶏紙绠�啓锛� function_name_simple varchar(100) COMMENT '鐢熸垚鍔熻兘鍚嶏紙绠�啓锛�,
-- 鐢熸垚鍔熻兘浣滆�
function_author varchar(100) COMMENT '鐢熸垚鍔熻兘浣滆�',
-- 鐢熸垚琛ㄧ紪鍙� gen_table_id varchar(200) COMMENT '鐢熸垚琛ㄧ紪鍙�,
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE gen_table
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鍚嶇О
name varchar(200) COMMENT '鍚嶇О',
-- 鎻忚堪
comments varchar(500) COMMENT '鎻忚堪',
-- 瀹炰綋绫诲悕绉� class_name varchar(100) COMMENT '瀹炰綋绫诲悕绉�,
-- 鍏宠仈鐖惰〃
parent_table varchar(200) COMMENT '鍏宠仈鐖惰〃',
-- 鍏宠仈鐖惰〃澶栭敭
parent_table_fk varchar(100) COMMENT '鍏宠仈鐖惰〃澶栭敭',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE gen_table_column
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 褰掑睘琛ㄧ紪鍙� gen_table_id varchar(64) COMMENT '褰掑睘琛ㄧ紪鍙�,
-- 鍚嶇О
name varchar(200) COMMENT '鍚嶇О',
-- 鎻忚堪
comments varchar(500) COMMENT '鎻忚堪',
-- 鍒楃殑鏁版嵁绫诲瀷鐨勫瓧鑺傞暱搴� jdbc_type varchar(100) COMMENT '鍒楃殑鏁版嵁绫诲瀷鐨勫瓧鑺傞暱搴�,
-- JAVA绫诲瀷
java_type varchar(500) COMMENT 'JAVA绫诲瀷',
-- JAVA瀛楁鍚� java_field varchar(200) COMMENT 'JAVA瀛楁鍚�,
-- 鏄惁涓婚敭
is_pk char COMMENT '鏄惁涓婚敭',
-- 鏄惁鍙负绌� is_null char COMMENT '鏄惁鍙负绌�,
-- 鏄惁涓烘彃鍏ュ瓧娈� is_insert char COMMENT '鏄惁涓烘彃鍏ュ瓧娈�,
-- 鏄惁缂栬緫瀛楁
is_edit char COMMENT '鏄惁缂栬緫瀛楁',
-- 鏄惁鍒楄〃瀛楁
is_list char COMMENT '鏄惁鍒楄〃瀛楁',
-- 鏄惁鏌ヨ瀛楁
is_query char COMMENT '鏄惁鏌ヨ瀛楁',
-- 鏌ヨ鏂瑰紡锛堢瓑浜庛�涓嶇瓑浜庛�澶т簬銆佸皬浜庛�鑼冨洿銆佸乏LIKE銆佸彸LIKE銆佸乏鍙矻IKE锛� query_type varchar(200) COMMENT '鏌ヨ鏂瑰紡锛堢瓑浜庛�涓嶇瓑浜庛�澶т簬銆佸皬浜庛�鑼冨洿銆佸乏LIKE銆佸彸LIKE銆佸乏鍙矻IKE锛�,
-- 瀛楁鐢熸垚鏂规锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佸瓧鍏搁�鎷┿�浜哄憳閫夋嫨銆侀儴闂ㄩ�鎷┿�鍖哄煙閫夋嫨锛� show_type varchar(200) COMMENT '瀛楁鐢熸垚鏂规锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佸瓧鍏搁�鎷┿�浜哄憳閫夋嫨銆侀儴闂ㄩ�鎷┿�鍖哄煙閫夋嫨锛�,
-- 瀛楀吀绫诲瀷
dict_type varchar(200) COMMENT '瀛楀吀绫诲瀷',
-- 鍏跺畠璁剧疆锛堟墿灞曞瓧娈礘SON锛� settings varchar(2000) COMMENT '鍏跺畠璁剧疆锛堟墿灞曞瓧娈礘SON锛�,
-- 鎺掑簭锛堝崌搴忥級
sort decimal COMMENT '鎺掑簭锛堝崌搴忥級',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE gen_template
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鍚嶇О
name varchar(200) COMMENT '鍚嶇О',
-- 鍒嗙被
category varchar(2000) COMMENT '鍒嗙被',
-- 鐢熸垚鏂囦欢璺緞
file_path varchar(500) COMMENT '鐢熸垚鏂囦欢璺緞',
-- 鐢熸垚鏂囦欢鍚� file_name varchar(200) COMMENT '鐢熸垚鏂囦欢鍚�,
-- 鍐呭
content text COMMENT '鍐呭',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE oa_leave
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 娴佺▼瀹炰緥缂栧彿
process_instance_id varchar(64) COMMENT '娴佺▼瀹炰緥缂栧彿',
-- 寮�鏃堕棿
start_time datetime COMMENT '寮�鏃堕棿',
-- 缁撴潫鏃堕棿
end_time datetime COMMENT '缁撴潫鏃堕棿',
-- 璇峰亣绫诲瀷
leave_type varchar(20) COMMENT '璇峰亣绫诲瀷',
-- 璇峰亣鐞嗙敱
reason varchar(255) COMMENT '璇峰亣鐞嗙敱',
-- 鐢宠鏃堕棿
apply_time datetime COMMENT '鐢宠鏃堕棿',
-- 瀹為檯寮�鏃堕棿
reality_start_time datetime COMMENT '瀹為檯寮�鏃堕棿',
-- 瀹為檯缁撴潫鏃堕棿
reality_end_time datetime COMMENT '瀹為檯缁撴潫鏃堕棿',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE oa_notify
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 绫诲瀷
type char COMMENT '绫诲瀷',
-- 鏍囬
title varchar(200) COMMENT '鏍囬',
-- 鍐呭
content varchar(2000) COMMENT '鍐呭',
-- 闄勪欢
files varchar(2000) COMMENT '闄勪欢',
-- 鐘舵�
status char COMMENT '鐘舵�',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE oa_notify_record
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 閫氱煡閫氬憡ID
oa_notify_id varchar(64) COMMENT '閫氱煡閫氬憡ID',
-- 鎺ュ彈浜� user_id varchar(64) COMMENT '鎺ュ彈浜�,
-- 闃呰鏍囪
read_flag char DEFAULT '0' COMMENT '闃呰鏍囪',
-- 闃呰鏃堕棿
read_date date COMMENT '闃呰鏃堕棿',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE oa_test_audit
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 娴佺▼瀹炰緥ID
PROC_INS_ID varchar(64) COMMENT '娴佺▼瀹炰緥ID',
-- 鍙樺姩鐢ㄦ埛
USER_ID varchar(64) COMMENT '鍙樺姩鐢ㄦ埛',
-- 褰掑睘閮ㄩ棬
OFFICE_ID varchar(64) COMMENT '褰掑睘閮ㄩ棬',
-- 宀椾綅
POST varchar(255) COMMENT '宀椾綅',
-- 鎬у埆
AGE char COMMENT '鎬у埆',
-- 瀛﹀巻
EDU varchar(255) COMMENT '瀛﹀巻',
-- 璋冩暣鍘熷洜
CONTENT varchar(255) COMMENT '璋冩暣鍘熷洜',
-- 鐜拌鏍囧噯 钖叕妗g骇
OLDA varchar(255) COMMENT '鐜拌鏍囧噯 钖叕妗g骇',
-- 鐜拌鏍囧噯 鏈堝伐璧勯
OLDB varchar(255) COMMENT '鐜拌鏍囧噯 鏈堝伐璧勯',
-- 鐜拌鏍囧噯 骞磋柂鎬婚
OLDC varchar(255) COMMENT '鐜拌鏍囧噯 骞磋柂鎬婚',
-- 璋冩暣鍚庢爣鍑�钖叕妗g骇
NEWA varchar(255) COMMENT '璋冩暣鍚庢爣鍑�钖叕妗g骇',
-- 璋冩暣鍚庢爣鍑�鏈堝伐璧勯
NEWB varchar(255) COMMENT '璋冩暣鍚庢爣鍑�鏈堝伐璧勯',
-- 璋冩暣鍚庢爣鍑�骞磋柂鎬婚
NEWC varchar(255) COMMENT '璋冩暣鍚庢爣鍑�骞磋柂鎬婚',
-- 鏈堝璧� ADD_NUM varchar(255) COMMENT '鏈堝璧�,
-- 鎵ц鏃堕棿
EXE_DATE varchar(255) COMMENT '鎵ц鏃堕棿',
-- 浜哄姏璧勬簮閮ㄩ棬鎰忚
HR_TEXT varchar(255) COMMENT '浜哄姏璧勬簮閮ㄩ棬鎰忚',
-- 鍒嗙棰嗗鎰忚
LEAD_TEXT varchar(255) COMMENT '鍒嗙棰嗗鎰忚',
-- 闆嗗洟涓昏棰嗗鎰忚
MAIN_LEAD_TEXT varchar(255) COMMENT '闆嗗洟涓昏棰嗗鎰忚',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_area
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 鍚嶇О
name varchar(100) NOT NULL COMMENT '鍚嶇О',
-- 鎺掑簭
sort decimal NOT NULL COMMENT '鎺掑簭',
-- 鍖哄煙缂栫爜
code varchar(100) COMMENT '鍖哄煙缂栫爜',
-- 鍖哄煙绫诲瀷
type char COMMENT '鍖哄煙绫诲瀷',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_dict
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏁版嵁鍊� value varchar(100) NOT NULL COMMENT '鏁版嵁鍊�,
-- 鏍囩鍚� label varchar(100) NOT NULL COMMENT '鏍囩鍚�,
-- 绫诲瀷
type varchar(100) NOT NULL COMMENT '绫诲瀷',
-- 鎻忚堪
description varchar(100) NOT NULL COMMENT '鎻忚堪',
-- 鎺掑簭锛堝崌搴忥級
sort decimal NOT NULL COMMENT '鎺掑簭锛堝崌搴忥級',
-- 鐖剁骇缂栧彿
parent_id varchar(64) DEFAULT '0' COMMENT '鐖剁骇缂栧彿',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_log
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鏃ュ織绫诲瀷
type char DEFAULT '1' COMMENT '鏃ュ織绫诲瀷',
-- 鏃ュ織鏍囬
title varchar(255) COMMENT '鏃ュ織鏍囬',
-- 鍒涘缓鑰� create_by varchar(64) COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime COMMENT '鍒涘缓鏃堕棿',
-- 鎿嶄綔IP鍦板潃
remote_addr varchar(255) COMMENT '鎿嶄綔IP鍦板潃',
-- 鐢ㄦ埛浠g悊
user_agent varchar(255) COMMENT '鐢ㄦ埛浠g悊',
-- 璇锋眰URI
request_uri varchar(255) COMMENT '璇锋眰URI',
-- 鎿嶄綔鏂瑰紡
method varchar(5) COMMENT '鎿嶄綔鏂瑰紡',
-- 鎿嶄綔鎻愪氦鐨勬暟鎹� params text COMMENT '鎿嶄綔鎻愪氦鐨勬暟鎹�,
-- 寮傚父淇℃伅
exception text COMMENT '寮傚父淇℃伅',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_mdict
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 鍚嶇О
name varchar(100) NOT NULL COMMENT '鍚嶇О',
-- 鎺掑簭
sort decimal NOT NULL COMMENT '鎺掑簭',
-- 鎻忚堪
description varchar(100) COMMENT '鎻忚堪',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_menu
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 鍚嶇О
name varchar(100) NOT NULL COMMENT '鍚嶇О',
-- 鎺掑簭
sort decimal NOT NULL COMMENT '鎺掑簭',
-- 閾炬帴
href varchar(2000) COMMENT '閾炬帴',
-- 鐩爣
target varchar(20) COMMENT '鐩爣',
-- 鍥炬爣
icon varchar(100) COMMENT '鍥炬爣',
-- 鏄惁鍦ㄨ彍鍗曚腑鏄剧ず
is_show char NOT NULL COMMENT '鏄惁鍦ㄨ彍鍗曚腑鏄剧ず',
-- 鏉冮檺鏍囪瘑
permission varchar(200) COMMENT '鏉冮檺鏍囪瘑',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_office
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 鍚嶇О
name varchar(100) NOT NULL COMMENT '鍚嶇О',
-- 鎺掑簭
sort decimal NOT NULL COMMENT '鎺掑簭',
-- 褰掑睘鍖哄煙
area_id varchar(64) NOT NULL COMMENT '褰掑睘鍖哄煙',
-- 鍖哄煙缂栫爜
code varchar(100) COMMENT '鍖哄煙缂栫爜',
-- 鏈烘瀯绫诲瀷
type char NOT NULL COMMENT '鏈烘瀯绫诲瀷',
-- 鏈烘瀯绛夌骇
grade char NOT NULL COMMENT '鏈烘瀯绛夌骇',
-- 鑱旂郴鍦板潃
address varchar(255) COMMENT '鑱旂郴鍦板潃',
-- 閭斂缂栫爜
zip_code varchar(100) COMMENT '閭斂缂栫爜',
-- 璐熻矗浜� master varchar(100) COMMENT '璐熻矗浜�,
-- 鐢佃瘽
phone varchar(200) COMMENT '鐢佃瘽',
-- 浼犵湡
fax varchar(200) COMMENT '浼犵湡',
-- 閭
email varchar(200) COMMENT '閭',
-- 鏄惁鍚敤
USEABLE varchar(64) COMMENT '鏄惁鍚敤',
-- 涓昏礋璐d汉
PRIMARY_PERSON varchar(64) COMMENT '涓昏礋璐d汉',
-- 鍓礋璐d汉
DEPUTY_PERSON varchar(64) COMMENT '鍓礋璐d汉',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_role
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 褰掑睘鏈烘瀯
office_id varchar(64) COMMENT '褰掑睘鏈烘瀯',
-- 瑙掕壊鍚嶇О
name varchar(100) NOT NULL COMMENT '瑙掕壊鍚嶇О',
-- 鑻辨枃鍚嶇О
enname varchar(255) COMMENT '鑻辨枃鍚嶇О',
-- 瑙掕壊绫诲瀷
role_type varchar(255) COMMENT '瑙掕壊绫诲瀷',
-- 鏁版嵁鑼冨洿
data_scope char COMMENT '鏁版嵁鑼冨洿',
-- 鏄惁绯荤粺鏁版嵁
is_sys varchar(64) COMMENT '鏄惁绯荤粺鏁版嵁',
-- 鏄惁鍙敤
useable varchar(64) COMMENT '鏄惁鍙敤',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_role_menu
(
-- 瑙掕壊缂栧彿
role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
-- 鑿滃崟缂栧彿
menu_id varchar(64) NOT NULL COMMENT '鑿滃崟缂栧彿',
PRIMARY KEY (role_id, menu_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_role_office
(
-- 瑙掕壊缂栧彿
role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
-- 鏈烘瀯缂栧彿
office_id varchar(64) NOT NULL COMMENT '鏈烘瀯缂栧彿',
PRIMARY KEY (role_id, office_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_user
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 褰掑睘鍏徃
company_id varchar(64) NOT NULL COMMENT '褰掑睘鍏徃',
-- 褰掑睘閮ㄩ棬
office_id varchar(64) NOT NULL COMMENT '褰掑睘閮ㄩ棬',
-- 鐧诲綍鍚� login_name varchar(100) NOT NULL COMMENT '鐧诲綍鍚�,
-- 瀵嗙爜
password varchar(100) NOT NULL COMMENT '瀵嗙爜',
-- 宸ュ彿
no varchar(100) COMMENT '宸ュ彿',
-- 濮撳悕
name varchar(100) NOT NULL COMMENT '濮撳悕',
-- 閭
email varchar(200) COMMENT '閭',
-- 鐢佃瘽
phone varchar(200) COMMENT '鐢佃瘽',
-- 鎵嬫満
mobile varchar(200) COMMENT '鎵嬫満',
-- 鐢ㄦ埛绫诲瀷
user_type char COMMENT '鐢ㄦ埛绫诲瀷',
-- 鐢ㄦ埛澶村儚
photo varchar(1000) COMMENT '鐢ㄦ埛澶村儚',
-- 鏈�悗鐧婚檰IP
login_ip varchar(100) COMMENT '鏈�悗鐧婚檰IP',
-- 鏈�悗鐧婚檰鏃堕棿
login_date datetime COMMENT '鏈�悗鐧婚檰鏃堕棿',
-- 鏄惁鍙櫥褰� login_flag varchar(64) COMMENT '鏄惁鍙櫥褰�,
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE sys_user_role
(
-- 鐢ㄦ埛缂栧彿
user_id varchar(64) NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
-- 瑙掕壊缂栧彿
role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
PRIMARY KEY (user_id, role_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE test_data
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 褰掑睘鐢ㄦ埛
user_id varchar(64) COMMENT '褰掑睘鐢ㄦ埛',
-- 褰掑睘閮ㄩ棬
office_id varchar(64) COMMENT '褰掑睘閮ㄩ棬',
-- 褰掑睘鍖哄煙
area_id varchar(64) COMMENT '褰掑睘鍖哄煙',
-- 鍚嶇О
name varchar(100) COMMENT '鍚嶇О',
-- 鎬у埆
sex char COMMENT '鎬у埆',
-- 鍔犲叆鏃ユ湡
in_date date COMMENT '鍔犲叆鏃ユ湡',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE test_data_child
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 涓氬姟涓昏〃ID
test_data_main_id varchar(64) COMMENT '涓氬姟涓昏〃ID',
-- 鍚嶇О
name varchar(100) COMMENT '鍚嶇О',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE test_data_main
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 褰掑睘鐢ㄦ埛
user_id varchar(64) COMMENT '褰掑睘鐢ㄦ埛',
-- 褰掑睘閮ㄩ棬
office_id varchar(64) COMMENT '褰掑睘閮ㄩ棬',
-- 褰掑睘鍖哄煙
area_id varchar(64) COMMENT '褰掑睘鍖哄煙',
-- 鍚嶇О
name varchar(100) COMMENT '鍚嶇О',
-- 鎬у埆
sex char COMMENT '鎬у埆',
-- 鍔犲叆鏃ユ湡
in_date date COMMENT '鍔犲叆鏃ユ湡',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE test_tree
(
-- 缂栧彿
id varchar(64) NOT NULL COMMENT '缂栧彿',
-- 鐖剁骇缂栧彿
parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
-- 鎵�湁鐖剁骇缂栧彿
parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
-- 鍚嶇О
name varchar(100) NOT NULL COMMENT '鍚嶇О',
-- 鎺掑簭
sort decimal NOT NULL COMMENT '鎺掑簭',
-- 鍒涘缓鑰� create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
-- 鍒涘缓鏃堕棿
create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
-- 鏇存柊鑰� update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
-- 鏇存柊鏃堕棿
update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
-- 澶囨敞淇℃伅
remarks varchar(255) COMMENT '澶囨敞淇℃伅',
-- 鍒犻櫎鏍囪
del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Create Foreign Keys */
ALTER TABLE act_re_model
ADD CONSTRAINT ACT_FK_MODEL_SOURCE_EXTRA FOREIGN KEY (EDITOR_SOURCE_EXTRA_VALUE_ID_)
REFERENCES act_ge_bytearray (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_re_model
ADD CONSTRAINT ACT_FK_MODEL_SOURCE FOREIGN KEY (EDITOR_SOURCE_VALUE_ID_)
REFERENCES act_ge_bytearray (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_job
ADD CONSTRAINT ACT_FK_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_)
REFERENCES act_ge_bytearray (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_variable
ADD CONSTRAINT ACT_FK_VAR_BYTEARRAY FOREIGN KEY (BYTEARRAY_ID_)
REFERENCES act_ge_bytearray (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_id_membership
ADD CONSTRAINT ACT_FK_MEMB_GROUP FOREIGN KEY (GROUP_ID_)
REFERENCES act_id_group (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_id_membership
ADD CONSTRAINT ACT_FK_MEMB_USER FOREIGN KEY (USER_ID_)
REFERENCES act_id_user (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ge_bytearray
ADD CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_)
REFERENCES act_re_deployment (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_re_model
ADD CONSTRAINT ACT_FK_MODEL_DEPLOYMENT FOREIGN KEY (DEPLOYMENT_ID_)
REFERENCES act_re_deployment (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_execution
ADD CONSTRAINT ACT_FK_EXE_PROCDEF FOREIGN KEY (PROC_DEF_ID_)
REFERENCES act_re_procdef (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_identitylink
ADD CONSTRAINT ACT_FK_ATHRZ_PROCEDEF FOREIGN KEY (PROC_DEF_ID_)
REFERENCES act_re_procdef (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_task
ADD CONSTRAINT ACT_FK_TASK_PROCDEF FOREIGN KEY (PROC_DEF_ID_)
REFERENCES act_re_procdef (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_event_subscr
ADD CONSTRAINT ACT_FK_EVENT_EXEC FOREIGN KEY (EXECUTION_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_execution
ADD CONSTRAINT ACT_FK_EXE_PROCINST FOREIGN KEY (PROC_INST_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE CASCADE
ON DELETE CASCADE
;
ALTER TABLE act_ru_execution
ADD CONSTRAINT ACT_FK_EXE_PARENT FOREIGN KEY (PARENT_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_execution
ADD CONSTRAINT ACT_FK_EXE_SUPER FOREIGN KEY (SUPER_EXEC_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_identitylink
ADD CONSTRAINT ACT_FK_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_task
ADD CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_task
ADD CONSTRAINT ACT_FK_TASK_PROCINST FOREIGN KEY (PROC_INST_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_variable
ADD CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_variable
ADD CONSTRAINT ACT_FK_VAR_PROCINST FOREIGN KEY (PROC_INST_ID_)
REFERENCES act_ru_execution (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE act_ru_identitylink
ADD CONSTRAINT ACT_FK_TSKASS_TASK FOREIGN KEY (TASK_ID_)
REFERENCES act_ru_task (ID_)
ON UPDATE NO ACTION
ON DELETE NO ACTION
;
ALTER TABLE cms_db
ADD FOREIGN KEY (buss_sys_id)
REFERENCES cms_bussines_system (buss_sys_id)
ON UPDATE RESTRICT
ON DELETE RESTRICT
;
/* Create Indexes */
CREATE INDEX ACT_FK_BYTEARR_DEPL USING BTREE ON act_ge_bytearray (DEPLOYMENT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_END USING BTREE ON act_hi_actinst (END_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_EXEC USING BTREE ON act_hi_actinst (EXECUTION_ID_ ASC, ACT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_PROCINST USING BTREE ON act_hi_actinst (PROC_INST_ID_ ASC, ACT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_START USING BTREE ON act_hi_actinst (START_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_ACT_INST USING BTREE ON act_hi_detail (ACT_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_NAME USING BTREE ON act_hi_detail (NAME_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_PROC_INST USING BTREE ON act_hi_detail (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_TASK_ID USING BTREE ON act_hi_detail (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_TIME USING BTREE ON act_hi_detail (TIME_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_PROCINST USING BTREE ON act_hi_identitylink (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_TASK USING BTREE ON act_hi_identitylink (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_USER USING BTREE ON act_hi_identitylink (USER_ID_ ASC);
CREATE INDEX ACT_IDX_HI_PRO_I_BUSKEY USING BTREE ON act_hi_procinst (BUSINESS_KEY_ ASC);
CREATE INDEX ACT_IDX_HI_PRO_INST_END USING BTREE ON act_hi_procinst (END_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_PROCVAR_NAME_TYPE USING BTREE ON act_hi_varinst (NAME_ ASC, VAR_TYPE_ ASC);
CREATE INDEX ACT_IDX_HI_PROCVAR_PROC_INST USING BTREE ON act_hi_varinst (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_MEMB_GROUP USING BTREE ON act_id_membership (GROUP_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_DEPLOYMENT USING BTREE ON act_re_model (DEPLOYMENT_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_SOURCE USING BTREE ON act_re_model (EDITOR_SOURCE_VALUE_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_SOURCE_EXTRA USING BTREE ON act_re_model (EDITOR_SOURCE_EXTRA_VALUE_ID_ ASC);
CREATE UNIQUE INDEX ACT_UNIQ_PROCDEF USING BTREE ON act_re_procdef (KEY_ ASC, VERSION_ ASC, TENANT_ID_ ASC);
CREATE INDEX ACT_FK_EVENT_EXEC USING BTREE ON act_ru_event_subscr (EXECUTION_ID_ ASC);
CREATE INDEX ACT_IDX_EVENT_SUBSCR_CONFIG_ USING BTREE ON act_ru_event_subscr (CONFIGURATION_ ASC);
CREATE INDEX ACT_FK_EXE_PARENT USING BTREE ON act_ru_execution (PARENT_ID_ ASC);
CREATE INDEX ACT_FK_EXE_PROCDEF USING BTREE ON act_ru_execution (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_FK_EXE_PROCINST USING BTREE ON act_ru_execution (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_EXE_SUPER USING BTREE ON act_ru_execution (SUPER_EXEC_ ASC);
CREATE INDEX ACT_IDX_EXEC_BUSKEY USING BTREE ON act_ru_execution (BUSINESS_KEY_ ASC);
CREATE INDEX ACT_FK_IDL_PROCINST USING BTREE ON act_ru_identitylink (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_TSKASS_TASK USING BTREE ON act_ru_identitylink (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_ATHRZ_PROCEDEF USING BTREE ON act_ru_identitylink (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_IDX_IDENT_LNK_GROUP USING BTREE ON act_ru_identitylink (GROUP_ID_ ASC);
CREATE INDEX ACT_IDX_IDENT_LNK_USER USING BTREE ON act_ru_identitylink (USER_ID_ ASC);
CREATE INDEX ACT_FK_JOB_EXCEPTION USING BTREE ON act_ru_job (EXCEPTION_STACK_ID_ ASC);
CREATE INDEX ACT_FK_TASK_EXE USING BTREE ON act_ru_task (EXECUTION_ID_ ASC);
CREATE INDEX ACT_FK_TASK_PROCDEF USING BTREE ON act_ru_task (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_FK_TASK_PROCINST USING BTREE ON act_ru_task (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_TASK_CREATE USING BTREE ON act_ru_task (CREATE_TIME_ ASC);
CREATE INDEX ACT_FK_VAR_BYTEARRAY USING BTREE ON act_ru_variable (BYTEARRAY_ID_ ASC);
CREATE INDEX ACT_FK_VAR_EXE USING BTREE ON act_ru_variable (EXECUTION_ID_ ASC);
CREATE INDEX ACT_FK_VAR_PROCINST USING BTREE ON act_ru_variable (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_VARIABLE_TASK_ID USING BTREE ON act_ru_variable (TASK_ID_ ASC);
CREATE INDEX cms_article_category_id USING BTREE ON cms_article (category_id ASC);
CREATE INDEX cms_article_create_by USING BTREE ON cms_article (create_by ASC);
CREATE INDEX cms_article_del_flag USING BTREE ON cms_article (del_flag ASC);
CREATE INDEX cms_article_keywords USING BTREE ON cms_article (keywords ASC);
CREATE INDEX cms_article_title USING BTREE ON cms_article (title ASC);
CREATE INDEX cms_article_update_date USING BTREE ON cms_article (update_date ASC);
CREATE INDEX cms_article_weight USING BTREE ON cms_article (weight ASC);
CREATE INDEX cms_category_del_flag USING BTREE ON cms_category (del_flag ASC);
CREATE INDEX cms_category_module USING BTREE ON cms_category (module ASC);
CREATE INDEX cms_category_name USING BTREE ON cms_category (name ASC);
CREATE INDEX cms_category_office_id USING BTREE ON cms_category (office_id ASC);
CREATE INDEX cms_category_parent_id USING BTREE ON cms_category (parent_id ASC);
CREATE INDEX cms_category_site_id USING BTREE ON cms_category (site_id ASC);
CREATE INDEX cms_category_sort USING BTREE ON cms_category (sort ASC);
CREATE INDEX cms_comment_category_id USING BTREE ON cms_comment (category_id ASC);
CREATE INDEX cms_comment_content_id USING BTREE ON cms_comment (content_id ASC);
CREATE INDEX cms_comment_status USING BTREE ON cms_comment (del_flag ASC);
CREATE INDEX cms_guestbook_del_flag USING BTREE ON cms_guestbook (del_flag ASC);
CREATE INDEX cms_link_category_id USING BTREE ON cms_link (category_id ASC);
CREATE INDEX cms_link_create_by USING BTREE ON cms_link (create_by ASC);
CREATE INDEX cms_link_del_flag USING BTREE ON cms_link (del_flag ASC);
CREATE INDEX cms_link_title USING BTREE ON cms_link (title ASC);
CREATE INDEX cms_link_update_date USING BTREE ON cms_link (update_date ASC);
CREATE INDEX cms_link_weight USING BTREE ON cms_link (weight ASC);
CREATE INDEX cms_site_del_flag USING BTREE ON cms_site (del_flag ASC);
CREATE INDEX gen_scheme_del_flag USING BTREE ON gen_scheme (del_flag ASC);
CREATE INDEX gen_table_del_flag USING BTREE ON gen_table (del_flag ASC);
CREATE INDEX gen_table_name USING BTREE ON gen_table (name ASC);
CREATE INDEX gen_table_column_del_flag USING BTREE ON gen_table_column (del_flag ASC);
CREATE INDEX gen_table_column_name USING BTREE ON gen_table_column (name ASC);
CREATE INDEX gen_table_column_sort USING BTREE ON gen_table_column (sort ASC);
CREATE INDEX gen_table_column_table_id USING BTREE ON gen_table_column (gen_table_id ASC);
CREATE INDEX gen_template_del_falg USING BTREE ON gen_template (del_flag ASC);
CREATE INDEX oa_leave_create_by USING BTREE ON oa_leave (create_by ASC);
CREATE INDEX oa_leave_del_flag USING BTREE ON oa_leave (del_flag ASC);
CREATE INDEX oa_leave_process_instance_id USING BTREE ON oa_leave (process_instance_id ASC);
CREATE INDEX oa_notify_del_flag USING BTREE ON oa_notify (del_flag ASC);
CREATE INDEX oa_notify_record_notify_id USING BTREE ON oa_notify_record (oa_notify_id ASC);
CREATE INDEX oa_notify_record_read_flag USING BTREE ON oa_notify_record (read_flag ASC);
CREATE INDEX oa_notify_record_user_id USING BTREE ON oa_notify_record (user_id ASC);
CREATE INDEX OA_TEST_AUDIT_del_flag USING BTREE ON oa_test_audit (del_flag ASC);
CREATE INDEX sys_area_del_flag USING BTREE ON sys_area (del_flag ASC);
CREATE INDEX sys_area_parent_id USING BTREE ON sys_area (parent_id ASC);
CREATE INDEX sys_dict_del_flag USING BTREE ON sys_dict (del_flag ASC);
CREATE INDEX sys_dict_label USING BTREE ON sys_dict (label ASC);
CREATE INDEX sys_dict_value USING BTREE ON sys_dict (value ASC);
CREATE INDEX sys_log_create_by USING BTREE ON sys_log (create_by ASC);
CREATE INDEX sys_log_create_date USING BTREE ON sys_log (create_date ASC);
CREATE INDEX sys_log_request_uri USING BTREE ON sys_log (request_uri ASC);
CREATE INDEX sys_log_type USING BTREE ON sys_log (type ASC);
CREATE INDEX sys_mdict_del_flag USING BTREE ON sys_mdict (del_flag ASC);
CREATE INDEX sys_mdict_parent_id USING BTREE ON sys_mdict (parent_id ASC);
CREATE INDEX sys_menu_del_flag USING BTREE ON sys_menu (del_flag ASC);
CREATE INDEX sys_menu_parent_id USING BTREE ON sys_menu (parent_id ASC);
CREATE INDEX sys_office_del_flag USING BTREE ON sys_office (del_flag ASC);
CREATE INDEX sys_office_parent_id USING BTREE ON sys_office (parent_id ASC);
CREATE INDEX sys_office_type USING BTREE ON sys_office (type ASC);
CREATE INDEX sys_role_del_flag USING BTREE ON sys_role (del_flag ASC);
CREATE INDEX sys_role_enname USING BTREE ON sys_role (enname ASC);
CREATE INDEX sys_user_company_id USING BTREE ON sys_user (company_id ASC);
CREATE INDEX sys_user_del_flag USING BTREE ON sys_user (del_flag ASC);
CREATE INDEX sys_user_login_name USING BTREE ON sys_user (login_name ASC);
CREATE INDEX sys_user_office_id USING BTREE ON sys_user (office_id ASC);
CREATE INDEX sys_user_update_date USING BTREE ON sys_user (update_date ASC);
CREATE INDEX test_data_del_flag USING BTREE ON test_data (del_flag ASC);
CREATE INDEX test_data_child_del_flag USING BTREE ON test_data_child (del_flag ASC);
CREATE INDEX test_data_main_del_flag USING BTREE ON test_data_main (del_flag ASC);
CREATE INDEX test_data_parent_id USING BTREE ON test_tree (parent_id ASC);
CREATE INDEX test_tree_del_flag USING BTREE ON test_tree (del_flag ASC);
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/iframework/iFramework-By-Jeesite-Eclipse.git
git@gitee.com:iframework/iFramework-By-Jeesite-Eclipse.git
iframework
iFramework-By-Jeesite-Eclipse
iFramework By Jeesite-Eclipse
develop

搜索帮助