We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
A bunch of tables have no primary key, making it very difficult to work with these tables. We should add a computed primary key to allo of them.
select table_name from information_schema.tables where table_schema='ifdb' and table_type='BASE TABLE' and table_name not in (select table_name from information_schema.columns where table_schema='ifdb' and column_key='PRI') order by table_name; +------------------+ | table_name | +------------------+ | audit | | clubmembers | | compgames | | compprofilelinks | | comps_history | | downloadhelp | | extreviews | | formatprivs | | gamelinks | | gameprofilelinks | | games_history | | gametags | | gamexrefs | | iso639x | | logins | | nonces | | osprivs | | playedgames | | pollcomments | | pollvotes | | privileges | | reclistitems | | reviewflags | | reviewtags | | reviewvotes | | tagstats | | unwishlists | | userfilters | | wishlists | +------------------+
The text was updated successfully, but these errors were encountered:
This will make it easier to port to InnoDB #1016
Sorry, something went wrong.
No branches or pull requests
A bunch of tables have no primary key, making it very difficult to work with these tables. We should add a computed primary key to allo of them.
List of tables with no primary key
The text was updated successfully, but these errors were encountered: