Skip to content

Ga release - v0.7.0.

Choose a tag to compare

@shigenobu shigenobu released this 25 Sep 14:17
· 9 commits to master since this release
  • Support for MySQL 8.0.31, 8.0.32.
  • Refacter several.

(Notice) upgrade from 0.6.3 to 0.7.0 for web.

Modify sqlite table below commands.

ALTER TABLE project RENAME TO project_tmp;
CREATE TABLE project (
    projectId integer primary key autoincrement,
    title text,
    explanation text,
    host text,
    port integer,
    user text,
    pass text,
    charset text,
    dbType text,
    baseDatabase text,
    compareDatabase text
);
INSERT INTO project 
SELECT projectId, title, explanation, host, port, user, pass, charset, 'mariadb', baseDatabase, compareDatabase FROM project_tmp;

If modify auto_increment, check and update auto increment.

SELECT seq FROM sqlite_sequence WHERE name = 'project_tmp';
UPDATE sqlite_sequence SET seq = ${seq} WHERE name = 'project';

Finally, drop tmp.

DROP TABLE project_tmp;