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

2024-06-28 99 views
9

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

回答

6

举例

6

2022-08-09 20:16:04,156 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLEfile_galleryCHANGEfile_size`file_size VARCHAR(255); 2022-08-09 20:16:04,255 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_gallery CHANGE file_type file_type VARCHAR(255); 2022-08-09 20:16:04,371 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_gallery CHANGE file_status file_status INTEGER DEFAULT 0; 2022-08-09 20:16:04,470 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_gallery CHANGE file_remark file_remark VARCHAR(255) DEFAULT ''; 2022-08-09 20:16:04,561 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_gallery CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:04,643 INFO 7200 egg-sequelize Executed (default): ALTER TABLE file_gallery CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:04,644 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM file_gallery FROM hhy 2022-08-09 20:16:04,684 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS image_text (id INTEGER auto_increment , target VARCHAR(255), cate VARCHAR(255), content TEXT, image TEXT, status INTEGER DEFAULT 1, is_top INTEGER DEFAULT 0, views INTEGER DEFAULT 0, user_type VARCHAR(255), user_id VARCHAR(255), user_avatar VARCHAR(255), user_name VARCHAR(255), mobile VARCHAR(255), area VARCHAR(255), areaCode VARCHAR(255), address VARCHAR(255), ip VARCHAR(255), ip_addr VARCHAR(255), is_deleted INTEGER DEFAULT 0, is_online INTEGER DEFAULT 1, createdAt DATETIME 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_text CHANGE target target VARCHAR(255); 2022-08-09 20:16:04,887 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE cate cate VARCHAR(255); 2022-08-09 20:16:04,969 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE content content TEXT; 2022-08-09 20:16:05,052 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE image image TEXT; 2022-08-09 20:16:05,135 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE status status INTEGER DEFAULT 1; 2022-08-09 20:16:05,236 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE is_top is_top INTEGER DEFAULT 0; 2022-08-09 20:16:05,452 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE views views INTEGER DEFAULT 0; 2022-08-09 20:16:05,655 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE user_type user_type VARCHAR(255); 2022-08-09 20:16:05,801 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE user_id user_id VARCHAR(255); 2022-08-09 20:16:05,900 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE user_avatar user_avatar VARCHAR(255); 2022-08-09 20:16:05,990 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE user_name user_name VARCHAR(255); 2022-08-09 20:16:06,090 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE mobile mobile VARCHAR(255); 2022-08-09 20:16:06,181 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE area area VARCHAR(255); 2022-08-09 20:16:06,271 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE address address VARCHAR(255); 2022-08-09 20:16:06,353 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE ip ip VARCHAR(255); 2022-08-09 20:16:06,445 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE ip_addr ip_addr VARCHAR(255); 2022-08-09 20:16:06,535 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:06,888 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:07,000 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE areaCode areaCode VARCHAR(255); 2022-08-09 20:16:07,108 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE is_deleted is_deleted INTEGER DEFAULT 0; 2022-08-09 20:16:07,208 INFO 7200 egg-sequelize Executed (default): ALTER TABLE image_text CHANGE is_online is_online INTEGER DEFAULT 1; 2022-08-09 20:16:07,212 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM image_text FROM hhy 2022-08-09 20:16:07,261 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS live (id INTEGER auto_increment , title VARCHAR(255), desc TEXT, poster VARCHAR(255), start_time DATETIME, end_time DATETIME, status VARCHAR(255) DEFAULT '1', show_image_text INTEGER DEFAULT 0, show_desc INTEGER DEFAULT 1, show_heart_animate INTEGER DEFAULT 1, heart_color VARCHAR(255) DEFAULT '#ee0a24', show_switch INTEGER DEFAULT 1, show_live_source_cover INTEGER DEFAULT 1, show_views INTEGER DEFAULT 1, praised_limit INTEGER DEFAULT 1, allow_comment INTEGER DEFAULT 1, allow_weixin INTEGER DEFAULT 1, show_go_to_app INTEGER DEFAULT 1, preset_comment TEXT, weixin_desc TEXT, notice_text TEXT, show_notice INTEGER DEFAULT 0, theme_color VARCHAR(255) DEFAULT '#000', font_color VARCHAR(255) DEFAULT '#fff', tab_title_background VARCHAR(255) DEFAULT '#000', tab_title_active_color VARCHAR(255) DEFAULT '#ee0a24', tab_title_inactive_color VARCHAR(255) DEFAULT '#fff', tab_active_color VARCHAR(255) DEFAULT '#ee0a24', comment_input_background VARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)', comment_background VARCHAR(255) DEFAULT '#1d1d1d', comment_user_color VARCHAR(255) DEFAULT '#747884', comment_text_color VARCHAR(255) DEFAULT '#c1c4cb', createdAt DATETIME 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 live CHANGE status status VARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:07,459 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:07,525 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:07,616 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE title title VARCHAR(255); 2022-08-09 20:16:07,689 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE desc desc TEXT; 2022-08-09 20:16:07,780 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE poster poster VARCHAR(255); 2022-08-09 20:16:07,854 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE start_time start_time DATETIME; 2022-08-09 20:16:07,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE end_time end_time DATETIME; 2022-08-09 20:16:08,020 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE theme_color theme_color VARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:08,118 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_image_text show_image_text INTEGER DEFAULT 0; 2022-08-09 20:16:08,209 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_desc show_desc INTEGER DEFAULT 1; 2022-08-09 20:16:08,300 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_heart_animate show_heart_animate INTEGER DEFAULT 1; 2022-08-09 20:16:08,383 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_switch show_switch INTEGER DEFAULT 1; 2022-08-09 20:16:08,466 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_live_source_cover show_live_source_cover INTEGER DEFAULT 1; 2022-08-09 20:16:08,547 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_views show_views INTEGER DEFAULT 1; 2022-08-09 20:16:08,638 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE praised_limit praised_limit INTEGER DEFAULT 1; 2022-08-09 20:16:08,721 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE allow_comment allow_comment INTEGER DEFAULT 1; 2022-08-09 20:16:08,812 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE allow_weixin allow_weixin INTEGER DEFAULT 1; 2022-08-09 20:16:08,904 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_go_to_app show_go_to_app INTEGER DEFAULT 1; 2022-08-09 20:16:09,002 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE preset_comment preset_comment TEXT; 2022-08-09 20:16:09,094 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE weixin_desc weixin_desc TEXT; 2022-08-09 20:16:09,209 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE tab_title_active_color tab_title_active_color VARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,291 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE tab_title_inactive_color tab_title_inactive_color VARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,382 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE tab_active_color tab_active_color VARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:09,472 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE tab_title_background tab_title_background VARCHAR(255) DEFAULT '#000'; 2022-08-09 20:16:09,571 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE comment_background comment_background VARCHAR(255) DEFAULT '#1d1d1d'; 2022-08-09 20:16:09,654 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE comment_user_color comment_user_color VARCHAR(255) DEFAULT '#747884'; 2022-08-09 20:16:09,745 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE comment_text_color comment_text_color VARCHAR(255) DEFAULT '#c1c4cb'; 2022-08-09 20:16:09,836 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE font_color font_color VARCHAR(255) DEFAULT '#fff'; 2022-08-09 20:16:09,927 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE comment_input_background comment_input_background VARCHAR(255) DEFAULT 'rgba(0, 0, 0, 0.3)'; 2022-08-09 20:16:10,018 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE notice_text notice_text TEXT; 2022-08-09 20:16:10,117 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE show_notice show_notice INTEGER DEFAULT 0; 2022-08-09 20:16:10,208 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live CHANGE heart_color heart_color VARCHAR(255) DEFAULT '#ee0a24'; 2022-08-09 20:16:10,209 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM live FROM hhy 2022-08-09 20:16:10,246 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS live_source (id INTEGER auto_increment , live_id INTEGER, name VARCHAR(255), type INTEGER, url VARCHAR(255), cover_img VARCHAR(255), status INTEGER DEFAULT 1, sort INTEGER, user_id INTEGER, createdAt DATETIME 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_source CHANGE live_id live_id INTEGER; 2022-08-09 20:16:10,444 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE name name VARCHAR(255); 2022-08-09 20:16:10,543 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE type type INTEGER; 2022-08-09 20:16:10,633 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE url url VARCHAR(255); 2022-08-09 20:16:10,707 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE cover_img cover_img VARCHAR(255); 2022-08-09 20:16:10,789 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE status status INTEGER DEFAULT 1; 2022-08-09 20:16:10,864 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE sort sort INTEGER; 2022-08-09 20:16:10,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:11,021 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:11,111 INFO 7200 egg-sequelize Executed (default): ALTER TABLE live_source CHANGE user_id user_id INTEGER; 2022-08-09 20:16:11,112 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM live_source FROM hhy 2022-08-09 20:16:11,148 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS menu (id INTEGER auto_increment , pid INTEGER DEFAULT 0, name VARCHAR(255), title VARCHAR(255), path VARCHAR(255), redirect VARCHAR(255), icon VARCHAR(255), component VARCHAR(255), hidden VARCHAR(255) DEFAULT '1', order VARCHAR(255) DEFAULT 0, createdAt DATETIME 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 menu CHANGE pid pid INTEGER DEFAULT 0; 2022-08-09 20:16:11,288 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE name name VARCHAR(255); 2022-08-09 20:16:11,371 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE title title VARCHAR(255); 2022-08-09 20:16:11,454 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE path path VARCHAR(255); 2022-08-09 20:16:11,545 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE redirect redirect VARCHAR(255); 2022-08-09 20:16:11,627 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE icon icon VARCHAR(255); 2022-08-09 20:16:11,717 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE component component VARCHAR(255); 2022-08-09 20:16:11,800 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE hidden hidden VARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:11,900 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE order order VARCHAR(255) DEFAULT 0; 2022-08-09 20:16:11,990 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:12,081 INFO 7200 egg-sequelize Executed (default): ALTER TABLE menu CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:12,082 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM menu FROM hhy 2022-08-09 20:16:12,109 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS organization (id INTEGER auto_increment , pid INTEGER DEFAULT 0, name VARCHAR(255), desc VARCHAR(255), function VARCHAR(255), leader VARCHAR(255), charge_leader VARCHAR(255), status INTEGER DEFAULT 1, order INTEGER DEFAULT 0, createdAt DATETIME 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 organization CHANGE pid pid INTEGER DEFAULT 0; 2022-08-09 20:16:12,608 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE name name VARCHAR(255); 2022-08-09 20:16:12,691 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE order order INTEGER DEFAULT 0; 2022-08-09 20:16:12,781 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:12,855 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:12,946 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE desc desc VARCHAR(255); 2022-08-09 20:16:13,037 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE function function VARCHAR(255); 2022-08-09 20:16:13,119 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE leader leader VARCHAR(255); 2022-08-09 20:16:13,202 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE charge_leader charge_leader VARCHAR(255); 2022-08-09 20:16:13,301 INFO 7200 egg-sequelize Executed (default): ALTER TABLE organization CHANGE status status INTEGER DEFAULT 1; 2022-08-09 20:16:13,302 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM organization FROM hhy 2022-08-09 20:16:13,337 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS paper (id INTEGER auto_increment , cate_id INTEGER DEFAULT 0, user_id INTEGER, name VARCHAR(255), type VARCHAR(255) DEFAULT '1', status VARCHAR(255) DEFAULT '0', single_num INTEGER DEFAULT 0, single_total_score INTEGER DEFAULT 0, multiple_num INTEGER DEFAULT 0, multiple_total_score INTEGER DEFAULT 0, total_num INTEGER DEFAULT 0, total_score INTEGER DEFAULT 0, createdAt DATETIME 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 paper CHANGE cate_id cate_id INTEGER DEFAULT 0; 2022-08-09 20:16:13,511 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE user_id user_id INTEGER; 2022-08-09 20:16:13,603 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE name name VARCHAR(255); 2022-08-09 20:16:13,693 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE type type VARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:13,776 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE status status VARCHAR(255) DEFAULT '0'; 2022-08-09 20:16:13,866 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE single_num single_num INTEGER DEFAULT 0; 2022-08-09 20:16:13,982 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE single_total_score single_total_score INTEGER DEFAULT 0; 2022-08-09 20:16:14,073 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE multiple_num multiple_num INTEGER DEFAULT 0; 2022-08-09 20:16:14,165 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE multiple_total_score multiple_total_score INTEGER DEFAULT 0; 2022-08-09 20:16:14,255 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE total_num total_num INTEGER DEFAULT 0; 2022-08-09 20:16:14,345 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE total_score total_score INTEGER DEFAULT 0; 2022-08-09 20:16:14,428 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:14,519 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:14,520 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM paper FROM hhy 2022-08-09 20:16:14,564 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS paper_cate (id INTEGER auto_increment , name VARCHAR(255), remark VARCHAR(255) DEFAULT '', createdAt DATETIME NOT NULL, updatedAt DATETIME NOT NULL, UNIQUE column (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_cate CHANGE name name VARCHAR(255); 2022-08-09 20:16:14,762 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_cate CHANGE remark remark VARCHAR(255) DEFAULT ''; 2022-08-09 20:16:14,854 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_cate CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:14,953 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_cate CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:14,954 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM paper_cate FROM hhy 2022-08-09 20:16:14,999 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS paper_question (id INTEGER auto_increment , paper_id INTEGER, question_id INTEGER, score INTEGER, sort INTEGER, createdAt DATETIME 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_question CHANGE paper_id paper_id INTEGER; 2022-08-09 20:16:15,189 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_question CHANGE question_id question_id INTEGER; 2022-08-09 20:16:15,287 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_question CHANGE score score INTEGER; 2022-08-09 20:16:15,386 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_question CHANGE sort sort INTEGER; 2022-08-09 20:16:15,494 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_question CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:15,585 INFO 7200 egg-sequelize Executed (default): ALTER TABLE paper_question CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:15,586 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM paper_question FROM hhy 2022-08-09 20:16:15,621 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS position (id INTEGER auto_increment , name VARCHAR(255), order INTEGER DEFAULT 0, intro VARCHAR(255), createdAt DATETIME 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 position CHANGE name name VARCHAR(255); 2022-08-09 20:16:15,812 INFO 7200 egg-sequelize Executed (default): ALTER TABLE position CHANGE intro intro VARCHAR(255); 2022-08-09 20:16:15,895 INFO 7200 egg-sequelize Executed (default): ALTER TABLE position CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:15,968 INFO 7200 egg-sequelize Executed (default): ALTER TABLE position CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:16,050 INFO 7200 egg-sequelize Executed (default): ALTER TABLE position CHANGE order order INTEGER DEFAULT 0; 2022-08-09 20:16:16,052 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM position FROM hhy 2022-08-09 20:16:16,088 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS praise (id INTEGER auto_increment , target_type VARCHAR(255), target_id INTEGER, comment_id INTEGER, user_id INTEGER, user_avatar VARCHAR(255), user_name VARCHAR(255), status VARCHAR(255) DEFAULT '1', createdAt DATETIME 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 praise CHANGE target_type target_type VARCHAR(255); 2022-08-09 20:16:16,244 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE target_id target_id INTEGER; 2022-08-09 20:16:16,318 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE comment_id comment_id INTEGER; 2022-08-09 20:16:16,393 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE user_id user_id INTEGER; 2022-08-09 20:16:16,484 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE user_avatar user_avatar VARCHAR(255); 2022-08-09 20:16:16,574 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE user_name user_name VARCHAR(255); 2022-08-09 20:16:16,657 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE status status VARCHAR(255) DEFAULT '1'; 2022-08-09 20:16:16,739 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE createdAt createdAt DATETIME NOT NULL; 2022-08-09 20:16:16,830 INFO 7200 egg-sequelize Executed (default): ALTER TABLE praise CHANGE updatedAt updatedAt DATETIME NOT NULL; 2022-08-09 20:16:16,832 INFO 7200 egg-sequelize Executed (default): SHOW INDEX FROM praise FROM hhy 2022-08-09 20:16:16,859 INFO 7200 egg-sequelize Executed (default): CREATE TABLE IF NOT EXISTS question (id INTEGER auto_increment , cate_id INTEGER DEFAULT 0, user_id INTEGER, type INTEGER, difficulty VARCHAR(255), score INTEGER DEFAULT 0, case_problem TEXT, choose_num INTEGER, options TEXT, correct_answer VARCHAR(255), analysis TEXT, status INTEGER DEFAULT 1, createdAt DATETIME 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 question CHANGE cate_id cate_id INTEGER DEFAULT 0; 2022-08-09 20:16:17,041 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE user_id user_id INTEGER; 2022-08-09 20:16:17,123 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE type type INTEGER; 2022-08-09 20:16:17,205 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE difficulty difficulty VARCHAR(255); 2022-08-09 20:16:17,304 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE score score INTEGER DEFAULT 0; 2022-08-09 20:16:17,379 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE case_problem case_problem TEXT; 2022-08-09 20:16:17,470 INFO 7200 egg-sequelize Executed (default): ALTER TABLE question CHANGE choose_num choose_num `INTEGER;

如上,每一次保存文件,egg-sequelize都会像这样执行(model下的数据库文件并没有改变)

7

举例

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;

如上,每一次保存文件,egg-sequelize都会像这样执行(model下的数据库文件并没有改变)

6

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

9

这个是热更新,

0

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

1

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

5

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

3

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