Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Primary key with AUTO_INCREMENT not converted right #1

Open
timint opened this issue May 1, 2021 · 1 comment
Open

Primary key with AUTO_INCREMENT not converted right #1

timint opened this issue May 1, 2021 · 1 comment
Labels
bug Something isn't working

Comments

@timint
Copy link

timint commented May 1, 2021

A problem with AUTO INCREMENT:

This

CREATE TABLE IF NOT EXISTS `table_name` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  ...
  PRIMARY KEY (`id`)
);

Should become

CREATE TABLE IF NOT EXISTS `table_name` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT,
  ...
);

Not

CREATE TABLE IF NOT EXISTS `table_name` (
  `id` INTEGER NOT NULL,
  ...
  PRIMARY KEY (`id`)
);
@ww9
Copy link
Owner

ww9 commented Dec 2, 2021

Hi! I am so sorry that I took this long to answer. I'll make sure GitHub notify me when someone creates an issue.

I think the best way to improve the tool is to create tests. I'll be doing that in the near future but I can't guarantee when.

I appreciate your submission. Thank you! <3

@ww9 ww9 added the bug Something isn't working label Jan 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants