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

Add primary keys to every table #1017

Open
dfabulich opened this issue Nov 7, 2024 · 1 comment
Open

Add primary keys to every table #1017

dfabulich opened this issue Nov 7, 2024 · 1 comment
Labels
admin required Only IFDB administrators can work on this code cleanup

Comments

@dfabulich
Copy link
Collaborator

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

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        |
+------------------+

@dfabulich
Copy link
Collaborator Author

This will make it easier to port to InnoDB #1016

@dfabulich dfabulich added the admin required Only IFDB administrators can work on this label Dec 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
admin required Only IFDB administrators can work on this code cleanup
Projects
None yet
Development

No branches or pull requests

1 participant