tableinfo

为什么80%的码农都做不了架构师？>>>   

INSERT INTO `tableinfo` (`TABLE_NAME`, `TABLE_ID_NAME`, `TABLE_ID_INCREMENT`, `TABLE_ID_VALUE`, `TABLE_ID_GENERATOR`, `TABLE_ID_TYPE`, `TABLE_ID_PREFIX`) VALUES
('TB_SM_INPUTTYPE', 'INPUT_TYPE_ID', 1, 9, 'SEQ_TB_SM_INPUTTYPE', 'sequence', ' '),
('td_cms_channel', 'channel_id', 1, 1, NULL, 'int', NULL),
('td_cms_collect_answer', 'answer_id', 1, 0, NULL, 'int', NULL),
('td_cms_collect_ipctrl2', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_collect_title', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOCCOMMENT_DICT', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOCCOM_IMPEACHINFO', 'ID', 1, 0, NULL, 'int', NULL),
('td_cms_docsource', 'docsource_id', 1, 1, NULL, 'int', NULL),
('td_cms_document', 'document_id', 1, 2, NULL, 'int', NULL),
('td_cms_doc_attach', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_DOC_COMMENT', 'COMMENT_ID', 1, 0, 'SEQ_TD_CMS_DOC_COMMENT', 'sequence', NULL),
('td_cms_doc_task', 'task_id', 1, 6, NULL, 'int', NULL),
('td_cms_doc_template', 'id', 1, 0, 'SEQ_TD_CMS_DOC_TEMPLATE', 'sequence', NULL),
('td_cms_extfield', 'field_id', 1, 0, NULL, 'int', NULL),
('TD_CMS_EXTVALUESCOPE', 'ID', 1, 0, NULL, 'int', NULL),
('td_cms_mailserverinfo', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_site', 'site_id', 1, 1, NULL, 'int', NULL),
('td_cms_site_search', 'id', 1, 1, NULL, 'int', NULL),
('td_cms_template', 'template_id', 1, 3, NULL, 'int', NULL),
('TD_CMS_TEMPLATE_STYLE', 'STYLE_ID', 1, -1, NULL, 'int', NULL),
('TD_CMS_VOTE_ANSWER', 'ANSER_ID', 1, 0, 'SEQ_TD_CMS_VOTE_ANSWER', 'sequence', NULL),
('TD_CMS_VOTE_IPCTRL', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_vote_items', 'id', 1, 0, NULL, 'int', NULL),
('td_cms_vote_questions', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_VOTE_TIMECTRL', 'id', 1, 0, NULL, 'int', NULL),
('TD_CMS_VOTE_TITLE', 'id', 1, 0, NULL, 'int', NULL),
('TD_ESB_BUSINESS_LINE', 'BUSINESS_LINE_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_GLOBAL_PARAM', 'PARAM_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_GROUP', 'GROUP_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_METADATA', 'METADATA_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_METADATA_SET', 'METADATA_SET_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_RESOUCE_PERMISSION', 'resouce_permission_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE', 'service_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_METADATA', 'service_metadata_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RESOURCE', 'id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RESOURCE_DETAIL', 'service_res_detail_id', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_RES_CALLED_LOG', 'LOG_ID', 1, 0, NULL, 'uuid', NULL),
('TD_ESB_SERVICE_RES_STATUS_LOG', 'ID', 1, 0, '', 'uuid', ''),
('TD_ESB_SERVICE_STATUS_LOG', 'ID', 1, 0, '', 'uuid', ''),
('td_remindinfo', 'id', 1, 0, NULL, 'int', NULL),
('td_sd_notepaper', 'notepaper_id', 1, 0, 'SEQ_TD_SD_NOTEPAPER', 'sequence', ' '),
('td_sd_notic', 'notic_id', 1, 0, 'SEQ_TD_SD_NOTIC', 'sequence', ' '),
('td_sd_ratifyadvice', 'ratifyadvice_id', 1, 0, 'SEQ_TD_SD_RATIFYADVICE', 'sequence', ' '),
('td_sd_remind', 'remind_id', 1, 0, 'SEQ_TD_SD_REMIND', 'sequence', ' '),
('td_sd_schedular', 'schedular_id', 1, 0, 'SEQ_TD_SD_SCHEDULAR', 'sequence', ' '),
('td_sm_dictdata', 'dictdata_id', 1, 193, 'SEQ_TD_SM_DICTDATA', 'sequence', ' '),
('TD_SM_DICTKEYWORDS', 'KEYWORD_ID', 1, 0, 'SEQ_DICTKEYWORD', 'sequence', ' '),
('td_sm_dicttype', 'dicttype_id', 1, 2312, 'SEQ_TD_SM_DICTTYPE', 'sequence', ' '),
('td_sm_group', 'group_id', 1, 0, 'SEQ_TD_SM_GROUP', 'sequence', ' '),
('td_sm_job', 'job_id', 1, 1, 'SEQ_TD_SM_JOB', 'sequence', ' '),
('TD_SM_LOG', 'LOG_ID', 1, 121, 'SEQ_LOG', 'sequence', ' '),
('TD_SM_LOGDETAIL', 'DETAIL_ID', 1, 0, 'SEQ_LOG_DETAIL', 'sequence', ' '),
('TD_SM_LOGMODULE', 'id', 1, 3, 'SEQ_TD_SM_LOGMODULE', 'sequence', ' '),
('td_sm_organization', 'org_id', 1, 1, 'SEQ_TD_SM_ORGANIZATION', 'sequence', ' '),
('td_sm_res', 'res_id', 1, 0, 'SEQ_TD_SM_RES', 'sequence', ' '),
('td_sm_role', 'role_id', 1, 4, 'SEQ_TD_SM_ROLE', 'sequence', ' '),
('td_sm_roletype', 'type_id', 1, 1, 'SEQ_TD_SM_ROLETYPE', 'sequence', ' '),
('td_sm_user', 'user_id', 1, 1, 'SEQ_TD_SM_USER', 'sequence', ' '),
('tl_cms_doc_oper_log\n', 'id', 1, 0, NULL, 'int', NULL);

转载于:https://my.oschina.net/bboss/blog/638840