Opened 7 weeks ago

Closed 7 weeks ago

#111 closed Bug report (Fixed)

Sanitize Database Keys

Reported by: florian Owned by:
Milestone: Mode Menu – Fixes Keywords:
Cc:

Description

  • Add a PRIMARY KEY to all tables
  • Replace "key" INTEGER PRIMARY KEY, "identifier" TEXT UNIQUE by "identifier" PRIMARY KEY, because come on
  • Use multi-column PRIMARY KEYs where applicable

. Make sure FOREIGN KEYs are PRIMARY KEYs

How did that happen in the first place?

Change History (1)

comment:1 Changed 7 weeks ago by florian

Resolution: → Fixed
Status: new → closed

Implemented in commit ​f4e10069 (GitLab) / ​10de69136798ea02a9955d5d6662981d2b880f2309d3a69646abff6f7567e484 (Fossil).

Note: See TracTickets for help on using tickets.