使用oms的4.2.1版本:
使用oms的数据迁移功能,在结构迁移中其中有四张表报错,报错如下,这个是什么原因造成的呢
(conn=14230) Table doesn’t exist Query: – [WARN] [CONVERT] The table charset: utf8 → utf8mb4
– [WARN] [CONVERT] The table collation: utf8_general_ci → utf8mb4_general_ci
create table nyt_notification
(
id
int(11) not null auto_increment,
message
longtext not null,
url
varchar(200),
is_viewed
tinyint(1) not null,
is_emailed
tinyint(1) not null,
created
datetime(6) not null,
occurrences
int(10) unsigned not null,
subscription_id
int(11),
user_id
int(11),
modified
datetime(6) not null,
primary key (id
),
constraint nyt_notification_subscription_id_5a132ae1_fk_nyt_subscription_id
foreign key (subscription_id
) references nyt_subscription
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT,
constraint nyt_notification_user_id_acbb5c10_fk_account_user_id
foreign key (user_id
) references account_user
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT
)
auto_increment=1
default charset=utf8mb4
default collate=utf8mb4_general_ci Parameters: []