mysql-schema-sync icon indicating copy to clipboard operation
mysql-schema-sync copied to clipboard

db_index parse failed,unsupported,line:

Open mengerchou opened this issue 5 years ago • 2 comments

2019/12/30 schemaSync.go:270: Index : 73 Table : sheet_histories 2019/12/30 db.go:86: [SQL] [source] show create table sheet_histories [] 2019/12/30 db.go:86: [SQL] [dest] show create table sheet_histories [] 2019/12/30 index.go:113: db_index parse failed,unsupported,line: ) ENGINE=InnoDB AUTO_INCREMENT=7814 DEFAULT CHARSET=utf8

what does this mean

mengerchou avatar Dec 30 '19 10:12 mengerchou

what you tables's schema?

hidu avatar Jan 01 '20 01:01 hidu

CREATE TABLE sheet_histories ( id bigint(11) NOT NULL AUTO_INCREMENT, delta longtext CHARACTER SET utf8mb4 NOT NULL, rev int(11) NOT NULL, base_rev int(11) NOT NULL, user_id bigint(20) NOT NULL, file_id bigint(20) NOT NULL, file_guid varchar(50) NOT NULL DEFAULT '', client_id varchar(255) DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, deleted_at datetime DEFAULT NULL, PRIMARY KEY (id,file_id), UNIQUE KEY sheet_histories_file_id_rev (file_id,rev) ) ENGINE=InnoDB AUTO_INCREMENT=7814 DEFAULT CHARSET=utf8

mengerchou avatar Jan 16 '20 06:01 mengerchou