egg 【求助】eggjs本地化开发时每次保存项目文件，egg-sequlize都会重新编译一次，有什么办法可以不让它编译吗？

【求助】eggjs本地化开发时每次保存项目文件，egg-sequlize都会重新编译一次，有什么办法可以不让它编译吗？

Open huxiaoliang123 opened this issue 1 year ago • 9 comments

【求助】eggjs本地化开发时每次保存项目文件，egg-sequlize都会重新编译一次，有什么办法可以不让它编译吗？

举例

Aug 09 '22 09:08 beesprite

2022-08-09 20:16:04,156 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLE file_galleryCHANGEfile_size file_sizeVARCHAR(255); 2022-08-09 20:16:04,255 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEfile_galleryCHANGEfile_type file_typeVARCHAR(255); 2022-08-09 20:16:04,371 INFO 7200 [egg-sequelize](115ms) Executed (default): ALTER TABLEfile_galleryCHANGEfile_status file_statusINTEGER DEFAULT 0; 2022-08-09 20:16:04,470 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEfile_galleryCHANGEfile_remark file_remarkVARCHAR(255) DEFAULT ''; 2022-08-09 20:16:04,561 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEfile_galleryCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:04,643 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEfile_galleryCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:04,644 INFO 7200 [egg-sequelize](0ms) Executed (default): SHOW INDEX FROMfile_galleryFROMhhy2022-08-09 20:16:04,684 INFO 7200 [egg-sequelize](39ms) Executed (default): CREATE TABLE IF NOT EXISTSimage_text (idINTEGER auto_increment ,targetVARCHAR(255),cateVARCHAR(255),contentTEXT,imageTEXT,statusINTEGER DEFAULT 1,is_topINTEGER DEFAULT 0,viewsINTEGER DEFAULT 0,user_typeVARCHAR(255),user_idVARCHAR(255),user_avatarVARCHAR(255),user_nameVARCHAR(255),mobileVARCHAR(255),areaVARCHAR(255),areaCodeVARCHAR(255),addressVARCHAR(255),ipVARCHAR(255),ip_addrVARCHAR(255),is_deletedINTEGER DEFAULT 0,is_onlineINTEGER DEFAULT 1,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:04,690 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM image_text; 2022-08-09 20:16:04,692 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'image_text' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:04,796 INFO 7200 [egg-sequelize](103ms) Executed (default): ALTER TABLE image_textCHANGEtarget targetVARCHAR(255); 2022-08-09 20:16:04,887 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEimage_textCHANGEcate cateVARCHAR(255); 2022-08-09 20:16:04,969 INFO 7200 [egg-sequelize](79ms) Executed (default): ALTER TABLEimage_textCHANGEcontent contentTEXT; 2022-08-09 20:16:05,052 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEimage_textCHANGEimage image TEXT; 2022-08-09 20:16:05,135 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEimage_textCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:05,236 INFO 7200 [egg-sequelize](100ms) Executed (default): ALTER TABLEimage_textCHANGEis_top is_topINTEGER DEFAULT 0; 2022-08-09 20:16:05,452 INFO 7200 [egg-sequelize](215ms) Executed (default): ALTER TABLEimage_textCHANGEviews viewsINTEGER DEFAULT 0; 2022-08-09 20:16:05,655 INFO 7200 [egg-sequelize](202ms) Executed (default): ALTER TABLEimage_textCHANGEuser_type user_typeVARCHAR(255); 2022-08-09 20:16:05,801 INFO 7200 [egg-sequelize](145ms) Executed (default): ALTER TABLEimage_textCHANGEuser_id user_idVARCHAR(255); 2022-08-09 20:16:05,900 INFO 7200 [egg-sequelize](97ms) Executed (default): ALTER TABLEimage_textCHANGEuser_avatar user_avatarVARCHAR(255); 2022-08-09 20:16:05,990 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEimage_textCHANGEuser_name user_nameVARCHAR(255); 2022-08-09 20:16:06,090 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEimage_textCHANGEmobile mobileVARCHAR(255); 2022-08-09 20:16:06,181 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEimage_textCHANGEarea areaVARCHAR(255); 2022-08-09 20:16:06,271 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEimage_textCHANGEaddress addressVARCHAR(255); 2022-08-09 20:16:06,353 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEimage_textCHANGEip ipVARCHAR(255); 2022-08-09 20:16:06,445 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEimage_textCHANGEip_addr ip_addrVARCHAR(255); 2022-08-09 20:16:06,535 INFO 7200 [egg-sequelize](88ms) Executed (default): ALTER TABLEimage_textCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:06,888 INFO 7200 [egg-sequelize](351ms) Executed (default): ALTER TABLEimage_textCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:07,000 INFO 7200 [egg-sequelize](112ms) Executed (default): ALTER TABLEimage_textCHANGEareaCode areaCodeVARCHAR(255); 2022-08-09 20:16:07,108 INFO 7200 [egg-sequelize](106ms) Executed (default): ALTER TABLEimage_textCHANGEis_deleted is_deletedINTEGER DEFAULT 0; 2022-08-09 20:16:07,208 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEimage_textCHANGEis_online is_onlineINTEGER DEFAULT 1; 2022-08-09 20:16:07,212 INFO 7200 [egg-sequelize](2ms) Executed (default): SHOW INDEX FROMimage_textFROMhhy2022-08-09 20:16:07,261 INFO 7200 [egg-sequelize](45ms) Executed (default): CREATE TABLE IF NOT EXISTSlive (idINTEGER auto_increment ,titleVARCHAR(255),descTEXT,posterVARCHAR(255),start_timeDATETIME,end_timeDATETIME,statusVARCHAR(255) DEFAULT '1',show_image_textINTEGER DEFAULT 0,show_descINTEGER DEFAULT 1,show_heart_animateINTEGER DEFAULT 1,heart_colorVARCHAR(255) DEFAULT '#ee0a24',show_switchINTEGER DEFAULT 1,show_live_source_coverINTEGER DEFAULT 1,show_viewsINTEGER DEFAULT 1,praised_limitINTEGER DEFAULT 1,allow_commentINTEGER DEFAULT 1,allow_weixinINTEGER DEFAULT 1,show_go_to_appINTEGER DEFAULT 1,preset_commentTEXT,weixin_descTEXT,notice_textTEXT, show_noticeINTEGER DEFAULT 0,theme_colorVARCHAR(255) DEFAULT '#000',font_colorVARCHAR(255) DEFAULT '#fff',tab_title_backgroundVARCHAR(255) DEFAULT '#000',tab_title_active_colorVARCHAR(255) DEFAULT '#ee0a24',tab_title_inactive_colorVARCHAR(255) DEFAULT '#fff',tab_active_colorVARCHAR(255) DEFAULT '#ee0a24',comment_input_backgroundVARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)',comment_backgroundVARCHAR(255) DEFAULT '#1d1d1d',comment_user_colorVARCHAR(255) DEFAULT '#747884',comment_text_colorVARCHAR(255) DEFAULT '#c1c4cb',createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:07,266 INFO 7200 [egg-sequelize](3ms) Executed (default): SHOW FULL COLUMNS FROM live; 2022-08-09 20:16:07,267 INFO 7200 [egg-sequelize](4ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'live' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:07,360 INFO 7200 [egg-sequelize](92ms) Executed (default): ALTER TABLE liveCHANGEstatus statusVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:07,459 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEliveCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:07,525 INFO 7200 [egg-sequelize](66ms) Executed (default): ALTER TABLEliveCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:07,616 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEliveCHANGEtitle titleVARCHAR(255); 2022-08-09 20:16:07,689 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLEliveCHANGEdesc descTEXT; 2022-08-09 20:16:07,780 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEposter posterVARCHAR(255); 2022-08-09 20:16:07,854 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLEliveCHANGEstart_time start_timeDATETIME; 2022-08-09 20:16:07,946 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEliveCHANGEend_time end_time DATETIME; 2022-08-09 20:16:08,020 INFO 7200 [egg-sequelize](72ms) Executed (default): ALTER TABLEliveCHANGEtheme_color theme_colorVARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:08,118 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEliveCHANGEshow_image_text show_image_textINTEGER DEFAULT 0; 2022-08-09 20:16:08,209 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEshow_desc show_descINTEGER DEFAULT 1; 2022-08-09 20:16:08,300 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEshow_heart_animate show_heart_animateINTEGER DEFAULT 1; 2022-08-09 20:16:08,383 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEliveCHANGEshow_switch show_switchINTEGER DEFAULT 1; 2022-08-09 20:16:08,466 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEliveCHANGEshow_live_source_cover show_live_source_coverINTEGER DEFAULT 1; 2022-08-09 20:16:08,547 INFO 7200 [egg-sequelize](80ms) Executed (default): ALTER TABLEliveCHANGEshow_views show_viewsINTEGER DEFAULT 1; 2022-08-09 20:16:08,638 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEpraised_limit praised_limitINTEGER DEFAULT 1; 2022-08-09 20:16:08,721 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEliveCHANGEallow_comment allow_commentINTEGER DEFAULT 1; 2022-08-09 20:16:08,812 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEallow_weixin allow_weixinINTEGER DEFAULT 1; 2022-08-09 20:16:08,904 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEliveCHANGEshow_go_to_app show_go_to_appINTEGER DEFAULT 1; 2022-08-09 20:16:09,002 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEliveCHANGEpreset_comment preset_commentTEXT; 2022-08-09 20:16:09,094 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEliveCHANGEweixin_desc weixin_descTEXT; 2022-08-09 20:16:09,209 INFO 7200 [egg-sequelize](113ms) Executed (default): ALTER TABLEliveCHANGEtab_title_active_color tab_title_active_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,291 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEliveCHANGEtab_title_inactive_color tab_title_inactive_colorVARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,382 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEtab_active_color tab_active_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,472 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEliveCHANGEtab_title_background tab_title_backgroundVARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:09,571 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEliveCHANGEcomment_background comment_backgroundVARCHAR(255) DEFAULT '#1d1d1d'; 2022-08-09 20:16:09,654 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEliveCHANGEcomment_user_color comment_user_colorVARCHAR(255) DEFAULT '#747884'; 2022-08-09 20:16:09,745 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEcomment_text_color comment_text_colorVARCHAR(255) DEFAULT '#c1c4cb'; 2022-08-09 20:16:09,836 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEfont_color font_colorVARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,927 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEcomment_input_background comment_input_backgroundVARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)'; 2022-08-09 20:16:10,018 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEnotice_text notice_textTEXT; 2022-08-09 20:16:10,117 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEliveCHANGEshow_notice show_noticeINTEGER DEFAULT 0; 2022-08-09 20:16:10,208 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEliveCHANGEheart_color heart_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:10,209 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMliveFROMhhy2022-08-09 20:16:10,246 INFO 7200 [egg-sequelize](36ms) Executed (default): CREATE TABLE IF NOT EXISTSlive_source (idINTEGER auto_increment ,live_idINTEGER,nameVARCHAR(255),typeINTEGER,urlVARCHAR(255),cover_imgVARCHAR(255),statusINTEGER DEFAULT 1,sortINTEGER,user_idINTEGER,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:10,249 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM live_source; 2022-08-09 20:16:10,261 INFO 7200 [egg-sequelize](13ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'live_source' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:10,352 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLE live_sourceCHANGElive_id live_idINTEGER; 2022-08-09 20:16:10,444 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLElive_sourceCHANGEname nameVARCHAR(255); 2022-08-09 20:16:10,543 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLElive_sourceCHANGEtype typeINTEGER; 2022-08-09 20:16:10,633 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLElive_sourceCHANGEurl urlVARCHAR(255); 2022-08-09 20:16:10,707 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLElive_sourceCHANGEcover_img cover_imgVARCHAR(255); 2022-08-09 20:16:10,789 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLElive_sourceCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:10,864 INFO 7200 [egg-sequelize](74ms) Executed (default): ALTER TABLElive_sourceCHANGEsort sortINTEGER; 2022-08-09 20:16:10,946 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLElive_sourceCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:11,021 INFO 7200 [egg-sequelize](74ms) Executed (default): ALTER TABLElive_sourceCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:11,111 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLElive_sourceCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:11,112 INFO 7200 [egg-sequelize](0ms) Executed (default): SHOW INDEX FROMlive_sourceFROMhhy2022-08-09 20:16:11,148 INFO 7200 [egg-sequelize](35ms) Executed (default): CREATE TABLE IF NOT EXISTSmenu (idINTEGER auto_increment ,pidINTEGER DEFAULT 0,nameVARCHAR(255),titleVARCHAR(255),pathVARCHAR(255),redirectVARCHAR(255),iconVARCHAR(255),componentVARCHAR(255),hiddenVARCHAR(255) DEFAULT '1',orderVARCHAR(255) DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:11,151 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM menu; 2022-08-09 20:16:11,153 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'menu' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:11,223 INFO 7200 [egg-sequelize](69ms) Executed (default): ALTER TABLE menuCHANGEpid pidINTEGER DEFAULT 0; 2022-08-09 20:16:11,288 INFO 7200 [egg-sequelize](65ms) Executed (default): ALTER TABLEmenuCHANGEname nameVARCHAR(255); 2022-08-09 20:16:11,371 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEmenuCHANGEtitle titleVARCHAR(255); 2022-08-09 20:16:11,454 INFO 7200 [egg-sequelize](83ms) Executed (default): ALTER TABLEmenuCHANGEpath pathVARCHAR(255); 2022-08-09 20:16:11,545 INFO 7200 [egg-sequelize](88ms) Executed (default): ALTER TABLEmenuCHANGEredirect redirect VARCHAR(255); 2022-08-09 20:16:11,627 INFO 7200 [egg-sequelize](80ms) Executed (default): ALTER TABLEmenuCHANGEicon iconVARCHAR(255); 2022-08-09 20:16:11,717 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEmenuCHANGEcomponent componentVARCHAR(255); 2022-08-09 20:16:11,800 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEmenuCHANGEhidden hiddenVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:11,900 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEmenuCHANGEorder orderVARCHAR(255) DEFAULT 0; 2022-08-09 20:16:11,990 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEmenuCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:12,081 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEmenuCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:12,082 INFO 7200 [egg-sequelize](0ms) Executed (default): SHOW INDEX FROMmenuFROMhhy2022-08-09 20:16:12,109 INFO 7200 [egg-sequelize](25ms) Executed (default): CREATE TABLE IF NOT EXISTSorganization (id INTEGER auto_increment ,pidINTEGER DEFAULT 0,nameVARCHAR(255),descVARCHAR(255),functionVARCHAR(255),leaderVARCHAR(255),charge_leaderVARCHAR(255),statusINTEGER DEFAULT 1,orderINTEGER DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:12,111 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM organization; 2022-08-09 20:16:12,114 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'organization' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:12,201 INFO 7200 [egg-sequelize](86ms) Executed (default): ALTER TABLE organizationCHANGEpid pidINTEGER DEFAULT 0; 2022-08-09 20:16:12,608 INFO 7200 [egg-sequelize](406ms) Executed (default): ALTER TABLEorganizationCHANGEname nameVARCHAR(255); 2022-08-09 20:16:12,691 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEorganizationCHANGEorder orderINTEGER DEFAULT 0; 2022-08-09 20:16:12,781 INFO 7200 [egg-sequelize](88ms) Executed (default): ALTER TABLEorganizationCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:12,855 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLEorganizationCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:12,946 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEorganizationCHANGEdesc desc VARCHAR(255); 2022-08-09 20:16:13,037 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEorganizationCHANGEfunction functionVARCHAR(255); 2022-08-09 20:16:13,119 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEorganizationCHANGEleader leaderVARCHAR(255); 2022-08-09 20:16:13,202 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEorganizationCHANGEcharge_leader charge_leaderVARCHAR(255); 2022-08-09 20:16:13,301 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEorganizationCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:13,302 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMorganizationFROMhhy2022-08-09 20:16:13,337 INFO 7200 [egg-sequelize](34ms) Executed (default): CREATE TABLE IF NOT EXISTSpaper (idINTEGER auto_increment ,cate_idINTEGER DEFAULT 0,user_idINTEGER,nameVARCHAR(255),typeVARCHAR(255) DEFAULT '1',statusVARCHAR(255) DEFAULT '0',single_numINTEGER DEFAULT 0,single_total_scoreINTEGER DEFAULT 0,multiple_numINTEGER DEFAULT 0,multiple_total_scoreINTEGER DEFAULT 0,total_numINTEGER DEFAULT 0,total_scoreINTEGER DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:13,341 INFO 7200 [egg-sequelize](0ms) Executed (default): SHOW FULL COLUMNS FROM paper; 2022-08-09 20:16:13,343 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:13,437 INFO 7200 [egg-sequelize](93ms) Executed (default): ALTER TABLE paperCHANGEcate_id cate_idINTEGER DEFAULT 0; 2022-08-09 20:16:13,511 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLEpaperCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:13,603 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEpaperCHANGEname nameVARCHAR(255); 2022-08-09 20:16:13,693 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEpaperCHANGEtype typeVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:13,776 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpaperCHANGEstatus statusVARCHAR(255) DEFAULT '0'; 2022-08-09 20:16:13,866 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEpaperCHANGEsingle_num single_numINTEGER DEFAULT 0; 2022-08-09 20:16:13,982 INFO 7200 [egg-sequelize](116ms) Executed (default): ALTER TABLEpaperCHANGEsingle_total_score single_total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,073 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEpaperCHANGEmultiple_num multiple_numINTEGER DEFAULT 0; 2022-08-09 20:16:14,165 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEpaperCHANGEmultiple_total_score multiple_total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,255 INFO 7200 [egg-sequelize](88ms) Executed (default): ALTER TABLEpaperCHANGEtotal_num total_numINTEGER DEFAULT 0; 2022-08-09 20:16:14,345 INFO 7200 [egg-sequelize](89ms) Executed (default): ALTER TABLEpaperCHANGEtotal_score total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,428 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpaperCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:14,519 INFO 7200 [egg-sequelize](88ms) Executed (default): ALTER TABLEpaperCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:14,520 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMpaperFROMhhy2022-08-09 20:16:14,564 INFO 7200 [egg-sequelize](43ms) Executed (default): CREATE TABLE IF NOT EXISTSpaper_cate (idINTEGER auto_increment ,nameVARCHAR(255),remarkVARCHAR(255) DEFAULT '',createdAtDATETIME NOT NULL,updatedAtDATETIME NOT NULL, UNIQUEcolumn (name), PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:14,566 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM paper_cate; 2022-08-09 20:16:14,568 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper_cate' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:14,663 INFO 7200 [egg-sequelize](93ms) Executed (default): ALTER TABLE paper_cateCHANGEname nameVARCHAR(255); 2022-08-09 20:16:14,762 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEpaper_cateCHANGEremark remarkVARCHAR(255) DEFAULT ''; 2022-08-09 20:16:14,854 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEpaper_cateCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:14,953 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEpaper_cateCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:14,954 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMpaper_cateFROMhhy2022-08-09 20:16:14,999 INFO 7200 [egg-sequelize](44ms) Executed (default): CREATE TABLE IF NOT EXISTSpaper_question (idINTEGER auto_increment ,paper_idINTEGER,question_idINTEGER,scoreINTEGER,sortINTEGER,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:15,000 INFO 7200 [egg-sequelize](0ms) Executed (default): SHOW FULL COLUMNS FROM paper_question; 2022-08-09 20:16:15,003 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper_question' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:15,097 INFO 7200 [egg-sequelize](93ms) Executed (default): ALTER TABLE paper_questionCHANGEpaper_id paper_idINTEGER; 2022-08-09 20:16:15,189 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEpaper_questionCHANGEquestion_id question_idINTEGER; 2022-08-09 20:16:15,287 INFO 7200 [egg-sequelize](96ms) Executed (default): ALTER TABLEpaper_questionCHANGEscore scoreINTEGER; 2022-08-09 20:16:15,386 INFO 7200 [egg-sequelize](99ms) Executed (default): ALTER TABLEpaper_questionCHANGEsort sortINTEGER; 2022-08-09 20:16:15,494 INFO 7200 [egg-sequelize](107ms) Executed (default): ALTER TABLEpaper_questionCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:15,585 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEpaper_questionCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:15,586 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMpaper_questionFROMhhy2022-08-09 20:16:15,621 INFO 7200 [egg-sequelize](34ms) Executed (default): CREATE TABLE IF NOT EXISTSposition (idINTEGER auto_increment ,nameVARCHAR(255),orderINTEGER DEFAULT 0,introVARCHAR(255),createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:15,623 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM position; 2022-08-09 20:16:15,626 INFO 7200 [egg-sequelize](4ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'position' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:15,721 INFO 7200 [egg-sequelize](94ms) Executed (default): ALTER TABLE positionCHANGEname nameVARCHAR(255); 2022-08-09 20:16:15,812 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEpositionCHANGEintro introVARCHAR(255); 2022-08-09 20:16:15,895 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpositionCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:15,968 INFO 7200 [egg-sequelize](71ms) Executed (default): ALTER TABLEpositionCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:16,050 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpositionCHANGEorder orderINTEGER DEFAULT 0; 2022-08-09 20:16:16,052 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMpositionFROMhhy2022-08-09 20:16:16,088 INFO 7200 [egg-sequelize](36ms) Executed (default): CREATE TABLE IF NOT EXISTSpraise (idINTEGER auto_increment ,target_typeVARCHAR(255),target_idINTEGER,comment_idINTEGER,user_idINTEGER,user_avatarVARCHAR(255),user_nameVARCHAR(255),statusVARCHAR(255) DEFAULT '1',createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:16,090 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM praise; 2022-08-09 20:16:16,092 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'praise' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:16,162 INFO 7200 [egg-sequelize](68ms) Executed (default): ALTER TABLE praiseCHANGEtarget_type target_typeVARCHAR(255); 2022-08-09 20:16:16,244 INFO 7200 [egg-sequelize](80ms) Executed (default): ALTER TABLEpraiseCHANGEtarget_id target_idINTEGER; 2022-08-09 20:16:16,318 INFO 7200 [egg-sequelize](73ms) Executed (default): ALTER TABLEpraiseCHANGEcomment_id comment_idINTEGER; 2022-08-09 20:16:16,393 INFO 7200 [egg-sequelize](74ms) Executed (default): ALTER TABLEpraiseCHANGEuser_id user_id INTEGER; 2022-08-09 20:16:16,484 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEpraiseCHANGEuser_avatar user_avatarVARCHAR(255); 2022-08-09 20:16:16,574 INFO 7200 [egg-sequelize](87ms) Executed (default): ALTER TABLEpraiseCHANGEuser_name user_nameVARCHAR(255); 2022-08-09 20:16:16,657 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpraiseCHANGEstatus statusVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:16,739 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEpraiseCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:16,830 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEpraiseCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:16,832 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW INDEX FROMpraiseFROMhhy2022-08-09 20:16:16,859 INFO 7200 [egg-sequelize](27ms) Executed (default): CREATE TABLE IF NOT EXISTSquestion (idINTEGER auto_increment ,cate_idINTEGER DEFAULT 0,user_idINTEGER,typeINTEGER,difficultyVARCHAR(255),scoreINTEGER DEFAULT 0,case_problemTEXT,choose_numINTEGER,optionsTEXT,correct_answerVARCHAR(255),analysisTEXT,statusINTEGER DEFAULT 1,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:16,861 INFO 7200 [egg-sequelize](1ms) Executed (default): SHOW FULL COLUMNS FROM question; 2022-08-09 20:16:16,863 INFO 7200 [egg-sequelize](3ms) Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'question' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:16,950 INFO 7200 [egg-sequelize](87ms) Executed (default): ALTER TABLE questionCHANGEcate_id cate_idINTEGER DEFAULT 0; 2022-08-09 20:16:17,041 INFO 7200 [egg-sequelize](91ms) Executed (default): ALTER TABLEquestionCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:17,123 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEquestionCHANGEtype typeINTEGER; 2022-08-09 20:16:17,205 INFO 7200 [egg-sequelize](81ms) Executed (default): ALTER TABLEquestionCHANGEdifficulty difficultyVARCHAR(255); 2022-08-09 20:16:17,304 INFO 7200 [egg-sequelize](98ms) Executed (default): ALTER TABLEquestionCHANGEscore scoreINTEGER DEFAULT 0; 2022-08-09 20:16:17,379 INFO 7200 [egg-sequelize](74ms) Executed (default): ALTER TABLEquestionCHANGEcase_problem case_problemTEXT; 2022-08-09 20:16:17,470 INFO 7200 [egg-sequelize](90ms) Executed (default): ALTER TABLEquestionCHANGEchoose_num choose_num INTEGER;

Aug 09 '22 12:08 huxiaoliang123

ä¸¾ä¾

2022-08-09 20:16:04,156 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_galleryCHANGEfile_size file_sizeVARCHAR(255); 2022-08-09 20:16:04,255 INFO 7200 egg-sequelize Executed (default): ALTER TABLEfile_galleryCHANGEfile_type file_typeVARCHAR(255); 2022-08-09 20:16:04,371 INFO 7200 egg-sequelize Executed (default): ALTER TABLEfile_galleryCHANGEfile_status file_statusINTEGER DEFAULT 0; 2022-08-09 20:16:04,470 INFO 7200 egg-sequelize Executed (default): ALTER TABLEfile_galleryCHANGEfile_remark file_remarkVARCHAR(255) DEFAULT ''; 2022-08-09 20:16:04,561 INFO 7200 egg-sequelize Executed (default): ALTER TABLEfile_galleryCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:04,643 INFO 7200 egg-sequelize Executed (default): ALTER TABLEfile_galleryCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:04,644 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMfile_galleryFROMhhy2022-08-09 20:16:04,684 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSimage_text (idINTEGER auto_increment ,targetVARCHAR(255),cateVARCHAR(255),contentTEXT,imageTEXT,statusINTEGER DEFAULT 1,is_topINTEGER DEFAULT 0,viewsINTEGER DEFAULT 0,user_typeVARCHAR(255),user_idVARCHAR(255),user_avatarVARCHAR(255),user_nameVARCHAR(255),mobileVARCHAR(255),areaVARCHAR(255),areaCodeVARCHAR(255),addressVARCHAR(255),ipVARCHAR(255),ip_addrVARCHAR(255),is_deletedINTEGER DEFAULT 0,is_onlineINTEGER DEFAULT 1,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:04,690 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM image_text; 2022-08-09 20:16:04,692 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'image_text' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:04,796 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_textCHANGEtarget targetVARCHAR(255); 2022-08-09 20:16:04,887 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEcate cateVARCHAR(255); 2022-08-09 20:16:04,969 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEcontent contentTEXT; 2022-08-09 20:16:05,052 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEimage image TEXT; 2022-08-09 20:16:05,135 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:05,236 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEis_top is_topINTEGER DEFAULT 0; 2022-08-09 20:16:05,452 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEviews viewsINTEGER DEFAULT 0; 2022-08-09 20:16:05,655 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEuser_type user_typeVARCHAR(255); 2022-08-09 20:16:05,801 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEuser_id user_idVARCHAR(255); 2022-08-09 20:16:05,900 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEuser_avatar user_avatarVARCHAR(255); 2022-08-09 20:16:05,990 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEuser_name user_nameVARCHAR(255); 2022-08-09 20:16:06,090 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEmobile mobileVARCHAR(255); 2022-08-09 20:16:06,181 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEarea areaVARCHAR(255); 2022-08-09 20:16:06,271 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEaddress addressVARCHAR(255); 2022-08-09 20:16:06,353 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEip ipVARCHAR(255); 2022-08-09 20:16:06,445 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEip_addr ip_addrVARCHAR(255); 2022-08-09 20:16:06,535 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:06,888 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:07,000 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEareaCode areaCodeVARCHAR(255); 2022-08-09 20:16:07,108 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEis_deleted is_deletedINTEGER DEFAULT 0; 2022-08-09 20:16:07,208 INFO 7200 egg-sequelize Executed (default): ALTER TABLEimage_textCHANGEis_online is_onlineINTEGER DEFAULT 1; 2022-08-09 20:16:07,212 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMimage_textFROMhhy2022-08-09 20:16:07,261 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSlive (idINTEGER auto_increment ,titleVARCHAR(255),descTEXT,posterVARCHAR(255),start_timeDATETIME,end_timeDATETIME,statusVARCHAR(255) DEFAULT '1',show_image_textINTEGER DEFAULT 0,show_descINTEGER DEFAULT 1,show_heart_animateINTEGER DEFAULT 1,heart_colorVARCHAR(255) DEFAULT '#ee0a24',show_switchINTEGER DEFAULT 1,show_live_source_coverINTEGER DEFAULT 1,show_viewsINTEGER DEFAULT 1,praised_limitINTEGER DEFAULT 1,allow_commentINTEGER DEFAULT 1,allow_weixinINTEGER DEFAULT 1,show_go_to_appINTEGER DEFAULT 1,preset_commentTEXT,weixin_descTEXT,notice_textTEXT, show_noticeINTEGER DEFAULT 0,theme_colorVARCHAR(255) DEFAULT '#000',font_colorVARCHAR(255) DEFAULT '#fff',tab_title_backgroundVARCHAR(255) DEFAULT '#000',tab_title_active_colorVARCHAR(255) DEFAULT '#ee0a24',tab_title_inactive_colorVARCHAR(255) DEFAULT '#fff',tab_active_colorVARCHAR(255) DEFAULT '#ee0a24',comment_input_backgroundVARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)',comment_backgroundVARCHAR(255) DEFAULT '#1d1d1d',comment_user_colorVARCHAR(255) DEFAULT '#747884',comment_text_colorVARCHAR(255) DEFAULT '#c1c4cb',createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:07,266 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM live; 2022-08-09 20:16:07,267 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'live' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:07,360 INFO 7200 egg-sequelize Executed (default): ALTER TABLE liveCHANGEstatus statusVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:07,459 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:07,525 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:07,616 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtitle titleVARCHAR(255); 2022-08-09 20:16:07,689 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEdesc descTEXT; 2022-08-09 20:16:07,780 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEposter posterVARCHAR(255); 2022-08-09 20:16:07,854 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEstart_time start_timeDATETIME; 2022-08-09 20:16:07,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEend_time end_time DATETIME; 2022-08-09 20:16:08,020 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtheme_color theme_colorVARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:08,118 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_image_text show_image_textINTEGER DEFAULT 0; 2022-08-09 20:16:08,209 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_desc show_descINTEGER DEFAULT 1; 2022-08-09 20:16:08,300 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_heart_animate show_heart_animateINTEGER DEFAULT 1; 2022-08-09 20:16:08,383 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_switch show_switchINTEGER DEFAULT 1; 2022-08-09 20:16:08,466 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_live_source_cover show_live_source_coverINTEGER DEFAULT 1; 2022-08-09 20:16:08,547 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_views show_viewsINTEGER DEFAULT 1; 2022-08-09 20:16:08,638 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEpraised_limit praised_limitINTEGER DEFAULT 1; 2022-08-09 20:16:08,721 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEallow_comment allow_commentINTEGER DEFAULT 1; 2022-08-09 20:16:08,812 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEallow_weixin allow_weixinINTEGER DEFAULT 1; 2022-08-09 20:16:08,904 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_go_to_app show_go_to_appINTEGER DEFAULT 1; 2022-08-09 20:16:09,002 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEpreset_comment preset_commentTEXT; 2022-08-09 20:16:09,094 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEweixin_desc weixin_descTEXT; 2022-08-09 20:16:09,209 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtab_title_active_color tab_title_active_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,291 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtab_title_inactive_color tab_title_inactive_colorVARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,382 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtab_active_color tab_active_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,472 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEtab_title_background tab_title_backgroundVARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:09,571 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEcomment_background comment_backgroundVARCHAR(255) DEFAULT '#1d1d1d'; 2022-08-09 20:16:09,654 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEcomment_user_color comment_user_colorVARCHAR(255) DEFAULT '#747884'; 2022-08-09 20:16:09,745 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEcomment_text_color comment_text_colorVARCHAR(255) DEFAULT '#c1c4cb'; 2022-08-09 20:16:09,836 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEfont_color font_colorVARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,927 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEcomment_input_background comment_input_backgroundVARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)'; 2022-08-09 20:16:10,018 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEnotice_text notice_textTEXT; 2022-08-09 20:16:10,117 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEshow_notice show_noticeINTEGER DEFAULT 0; 2022-08-09 20:16:10,208 INFO 7200 egg-sequelize Executed (default): ALTER TABLEliveCHANGEheart_color heart_colorVARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:10,209 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMliveFROMhhy2022-08-09 20:16:10,246 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSlive_source (idINTEGER auto_increment ,live_idINTEGER,nameVARCHAR(255),typeINTEGER,urlVARCHAR(255),cover_imgVARCHAR(255),statusINTEGER DEFAULT 1,sortINTEGER,user_idINTEGER,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:10,249 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM live_source; 2022-08-09 20:16:10,261 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'live_source' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:10,352 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_sourceCHANGElive_id live_idINTEGER; 2022-08-09 20:16:10,444 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEname nameVARCHAR(255); 2022-08-09 20:16:10,543 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEtype typeINTEGER; 2022-08-09 20:16:10,633 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEurl urlVARCHAR(255); 2022-08-09 20:16:10,707 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEcover_img cover_imgVARCHAR(255); 2022-08-09 20:16:10,789 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:10,864 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEsort sortINTEGER; 2022-08-09 20:16:10,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:11,021 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:11,111 INFO 7200 egg-sequelize Executed (default): ALTER TABLElive_sourceCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:11,112 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMlive_sourceFROMhhy2022-08-09 20:16:11,148 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSmenu (idINTEGER auto_increment ,pidINTEGER DEFAULT 0,nameVARCHAR(255),titleVARCHAR(255),pathVARCHAR(255),redirectVARCHAR(255),iconVARCHAR(255),componentVARCHAR(255),hiddenVARCHAR(255) DEFAULT '1',orderVARCHAR(255) DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:11,151 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM menu; 2022-08-09 20:16:11,153 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'menu' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:11,223 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menuCHANGEpid pidINTEGER DEFAULT 0; 2022-08-09 20:16:11,288 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEname nameVARCHAR(255); 2022-08-09 20:16:11,371 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEtitle titleVARCHAR(255); 2022-08-09 20:16:11,454 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEpath pathVARCHAR(255); 2022-08-09 20:16:11,545 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEredirect redirect VARCHAR(255); 2022-08-09 20:16:11,627 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEicon iconVARCHAR(255); 2022-08-09 20:16:11,717 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEcomponent componentVARCHAR(255); 2022-08-09 20:16:11,800 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEhidden hiddenVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:11,900 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEorder orderVARCHAR(255) DEFAULT 0; 2022-08-09 20:16:11,990 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:12,081 INFO 7200 egg-sequelize Executed (default): ALTER TABLEmenuCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:12,082 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMmenuFROMhhy2022-08-09 20:16:12,109 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSorganization (id INTEGER auto_increment ,pidINTEGER DEFAULT 0,nameVARCHAR(255),descVARCHAR(255),functionVARCHAR(255),leaderVARCHAR(255),charge_leaderVARCHAR(255),statusINTEGER DEFAULT 1,orderINTEGER DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:12,111 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM organization; 2022-08-09 20:16:12,114 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'organization' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:12,201 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organizationCHANGEpid pidINTEGER DEFAULT 0; 2022-08-09 20:16:12,608 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEname nameVARCHAR(255); 2022-08-09 20:16:12,691 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEorder orderINTEGER DEFAULT 0; 2022-08-09 20:16:12,781 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:12,855 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:12,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEdesc desc VARCHAR(255); 2022-08-09 20:16:13,037 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEfunction functionVARCHAR(255); 2022-08-09 20:16:13,119 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEleader leaderVARCHAR(255); 2022-08-09 20:16:13,202 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEcharge_leader charge_leaderVARCHAR(255); 2022-08-09 20:16:13,301 INFO 7200 egg-sequelize Executed (default): ALTER TABLEorganizationCHANGEstatus statusINTEGER DEFAULT 1; 2022-08-09 20:16:13,302 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMorganizationFROMhhy2022-08-09 20:16:13,337 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSpaper (idINTEGER auto_increment ,cate_idINTEGER DEFAULT 0,user_idINTEGER,nameVARCHAR(255),typeVARCHAR(255) DEFAULT '1',statusVARCHAR(255) DEFAULT '0',single_numINTEGER DEFAULT 0,single_total_scoreINTEGER DEFAULT 0,multiple_numINTEGER DEFAULT 0,multiple_total_scoreINTEGER DEFAULT 0,total_numINTEGER DEFAULT 0,total_scoreINTEGER DEFAULT 0,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:13,341 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM paper; 2022-08-09 20:16:13,343 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:13,437 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paperCHANGEcate_id cate_idINTEGER DEFAULT 0; 2022-08-09 20:16:13,511 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:13,603 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEname nameVARCHAR(255); 2022-08-09 20:16:13,693 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEtype typeVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:13,776 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEstatus statusVARCHAR(255) DEFAULT '0'; 2022-08-09 20:16:13,866 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEsingle_num single_numINTEGER DEFAULT 0; 2022-08-09 20:16:13,982 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEsingle_total_score single_total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,073 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEmultiple_num multiple_numINTEGER DEFAULT 0; 2022-08-09 20:16:14,165 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEmultiple_total_score multiple_total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,255 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEtotal_num total_numINTEGER DEFAULT 0; 2022-08-09 20:16:14,345 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEtotal_score total_scoreINTEGER DEFAULT 0; 2022-08-09 20:16:14,428 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:14,519 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaperCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:14,520 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMpaperFROMhhy2022-08-09 20:16:14,564 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSpaper_cate (idINTEGER auto_increment ,nameVARCHAR(255),remarkVARCHAR(255) DEFAULT '',createdAtDATETIME NOT NULL,updatedAtDATETIME NOT NULL, UNIQUEcolumn (name), PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:14,566 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM paper_cate; 2022-08-09 20:16:14,568 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper_cate' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:14,663 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_cateCHANGEname nameVARCHAR(255); 2022-08-09 20:16:14,762 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_cateCHANGEremark remarkVARCHAR(255) DEFAULT ''; 2022-08-09 20:16:14,854 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_cateCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:14,953 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_cateCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:14,954 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMpaper_cateFROMhhy2022-08-09 20:16:14,999 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSpaper_question (idINTEGER auto_increment ,paper_idINTEGER,question_idINTEGER,scoreINTEGER,sortINTEGER,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:15,000 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM paper_question; 2022-08-09 20:16:15,003 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'paper_question' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:15,097 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_questionCHANGEpaper_id paper_idINTEGER; 2022-08-09 20:16:15,189 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_questionCHANGEquestion_id question_idINTEGER; 2022-08-09 20:16:15,287 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_questionCHANGEscore scoreINTEGER; 2022-08-09 20:16:15,386 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_questionCHANGEsort sortINTEGER; 2022-08-09 20:16:15,494 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_questionCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:15,585 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpaper_questionCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:15,586 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMpaper_questionFROMhhy2022-08-09 20:16:15,621 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSposition (idINTEGER auto_increment ,nameVARCHAR(255),orderINTEGER DEFAULT 0,introVARCHAR(255),createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:15,623 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM position; 2022-08-09 20:16:15,626 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'position' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:15,721 INFO 7200 egg-sequelize Executed (default): ALTER TABLE positionCHANGEname nameVARCHAR(255); 2022-08-09 20:16:15,812 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpositionCHANGEintro introVARCHAR(255); 2022-08-09 20:16:15,895 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpositionCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:15,968 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpositionCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:16,050 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpositionCHANGEorder orderINTEGER DEFAULT 0; 2022-08-09 20:16:16,052 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMpositionFROMhhy2022-08-09 20:16:16,088 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSpraise (idINTEGER auto_increment ,target_typeVARCHAR(255),target_idINTEGER,comment_idINTEGER,user_idINTEGER,user_avatarVARCHAR(255),user_nameVARCHAR(255),statusVARCHAR(255) DEFAULT '1',createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:16,090 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM praise; 2022-08-09 20:16:16,092 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'praise' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:16,162 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praiseCHANGEtarget_type target_typeVARCHAR(255); 2022-08-09 20:16:16,244 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEtarget_id target_idINTEGER; 2022-08-09 20:16:16,318 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEcomment_id comment_idINTEGER; 2022-08-09 20:16:16,393 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEuser_id user_id INTEGER; 2022-08-09 20:16:16,484 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEuser_avatar user_avatarVARCHAR(255); 2022-08-09 20:16:16,574 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEuser_name user_nameVARCHAR(255); 2022-08-09 20:16:16,657 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEstatus statusVARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:16,739 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEcreatedAt createdAtDATETIME NOT NULL; 2022-08-09 20:16:16,830 INFO 7200 egg-sequelize Executed (default): ALTER TABLEpraiseCHANGEupdatedAt updatedAtDATETIME NOT NULL; 2022-08-09 20:16:16,832 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROMpraiseFROMhhy2022-08-09 20:16:16,859 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTSquestion (idINTEGER auto_increment ,cate_idINTEGER DEFAULT 0,user_idINTEGER,typeINTEGER,difficultyVARCHAR(255),scoreINTEGER DEFAULT 0,case_problemTEXT,choose_numINTEGER,optionsTEXT,correct_answerVARCHAR(255),analysisTEXT,statusINTEGER DEFAULT 1,createdAtDATETIME NOT NULL,updatedAt DATETIME NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 2022-08-09 20:16:16,861 INFO 7200 egg-sequelize Executed (default): SHOW FULL COLUMNS FROM question; 2022-08-09 20:16:16,863 INFO 7200 egg-sequelize Executed (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'question' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='hhy' AND REFERENCED_TABLE_NAME IS NOT NULL; 2022-08-09 20:16:16,950 INFO 7200 egg-sequelize Executed (default): ALTER TABLE questionCHANGEcate_id cate_idINTEGER DEFAULT 0; 2022-08-09 20:16:17,041 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEuser_id user_idINTEGER; 2022-08-09 20:16:17,123 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEtype typeINTEGER; 2022-08-09 20:16:17,205 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEdifficulty difficultyVARCHAR(255); 2022-08-09 20:16:17,304 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEscore scoreINTEGER DEFAULT 0; 2022-08-09 20:16:17,379 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEcase_problem case_problemTEXT; 2022-08-09 20:16:17,470 INFO 7200 egg-sequelize Executed (default): ALTER TABLEquestionCHANGEchoose_num choose_num INTEGER;

Aug 12 '22 11:08 huxiaoliang123

每次保存代码都会自动重启 Worker 进程，在重启worker进程的时候egg-sequlize会重新编译，有没有办法在重启worker进程的时候不让egg-sequlize重新编译。

Aug 15 '22 02:08 huxiaoliang123

这个是热更新，

Aug 15 '22 13:08 huihuicn

老师您好，感谢回复。那热更新有没有办法不让egg-sequlize重新编译，只让它在第一次启动的时候编译。

---原始邮件--- 发件人: @.> 发送时间: 2022年8月15日(周一) 晚上9:42 收件人: @.>; 抄送: @.@.>; 主题: Re: [eggjs/egg] 【求助】eggjs本地化开发时每次保存项目文件，egg-sequlize都会重新编译一次，有什么办法可以不让它编译吗？ (Issue #4988)

这个是热更新，

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

Aug 15 '22 15:08 huxiaoliang123

你贴出的看起来想起sequlize的日志，egg-sequlize是不用编译的

Sep 01 '22 05:09 ckvv

egg 热重启是要重新把项目文件加载进去，如果你实在是想要只有第一次，可以考虑配置到 env里面

Sep 05 '22 10:09 beesprite

可以配置下egg-development插件不启动，这样就不会热更新

Mar 24 '23 10:03 sinkhaha

egg egg copied to clipboard

【求助】eggjs本地化开发时每次保存项目文件，egg-sequlize都会重新编译一次，有什么办法可以不让它编译吗？

egg
egg copied to clipboard