search

dogsheep / github-to-sqlite

Save data from GitHub to a SQLite database
https://github-to-sqlite.dogsheep.net/
Apache License 2.0
415 stars 43 forks source link

Issues milestone column is the wrong type #30

Closed simonw closed 4 years ago

simonw commented 4 years ago

https://github-to-sqlite.dogsheep.net/github/issues?milestone=2857392

2A4C1185-2434-4F29-9EA0-3246E2F03F77

It is TEXT when it should be an INTEGER - which is why the foreign key label is not correctly displayed.

simonw commented 4 years ago

assignee looks like it's the incorrect type too.

simonw commented 4 years ago

Demo of fix: https://github-to-sqlite.dogsheep.net/github/issues?assignee__notblank=1&milestone__notblank=1

github__issues__4_rows_where_where_assignee_is_not_blank_and_milestone_is_not_blank_sorted_by_updated_at_descending