【求助】eggjs本地化开发时每次保存项目文件,egg-sequlize都会重新编译一次,有什么办法可以不让它编译吗?
[eggjs/egg]【求助】eggjs本地化开发时每次保存项目文件,egg-sequlize都会重新编译一次,有什么办法可以不让它编译吗?
回答
举例
2022-08-09 20:16:04,156 INFO 7200 [egg-sequelize](82ms) Executed (default): ALTER TABLE
file_galleryCHANGE
file_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下的数据库文件并没有改变)
举例
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下的数据库文件并没有改变)
每次保存代码都会自动重启 Worker 进程,在重启worker进程的时候egg-sequlize会重新编译,有没有办法在重启worker进程的时候不让egg-sequlize重新编译。
这个是热更新,
老师您好,感谢回复。那热更新有没有办法不让egg-sequlize重新编译,只让它在第一次启动的时候编译。
你贴出的看起来想起sequlize的日志,egg-sequlize是不用编译的
egg 热重启是要重新把项目文件加载进去,如果你实在是想要只有第一次,可以考虑配置到 env里面
可以配置下egg-development插件不启动,这样就不会热更新