mirror of
https://github.com/v0l/route96.git
synced 2025-06-15 07:56:32 +00:00

Some checks failed
continuous-integration/drone/push Build is failing
* Initial plan for issue * Implement Admin Reporting UI with backend and frontend Co-authored-by: v0l <1172179+v0l@users.noreply.github.com> * Implement reviewed flag for reports instead of deletion and revert upload.tsx changes Co-authored-by: v0l <1172179+v0l@users.noreply.github.com> * Remove legacy files migration logic from upload UI Co-authored-by: v0l <1172179+v0l@users.noreply.github.com> * Delete ui_src/package-lock.json * Delete ui_src/yarn.lock * Restore yarn.lock file to original state Co-authored-by: v0l <1172179+v0l@users.noreply.github.com> --------- Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com> Co-authored-by: v0l <1172179+v0l@users.noreply.github.com> Co-authored-by: Kieran <kieran@harkin.me>
5 lines
223 B
SQL
5 lines
223 B
SQL
-- Add reviewed flag to reports table
|
|
alter table reports add column reviewed boolean not null default false;
|
|
|
|
-- Index for efficient filtering of non-reviewed reports
|
|
create index ix_reports_reviewed on reports (reviewed); |