Vervis/migrations/2020_02_09_tup_mig.model
fr33domlover 5e9dd3555d DB: Add and populate TicketUnderProject table
A row in this table will be required for local-project-local-author tickets
hosted under the project, and non-existence of a row will be required for such
tickets hosted by the author. So I'll need to CAREFULLY update all the ticket
route handler code and all the ticket related AP code. The latter includes C2S
and S2S for tickets, ticket deps, ticket discussion... everything that is under
tickets.
2020-02-08 11:49:30 +00:00

32 lines
652 B
Text

Ticket
LocalTicket
ticket TicketId
discuss Int64
followers Int64
UniqueLocalTicket ticket
UniqueLocalTicketDiscussion discuss
UniqueLocalTicketFollowers followers
TicketProjectLocal
ticket TicketId
project Int64
accept Int64
UniqueTicketProjectLocal ticket
UniqueTicketProjectLocalAccept accept
TicketAuthorLocal
ticket LocalTicketId
author Int64
open Int64
UniqueTicketAuthorLocal ticket
UniqueTicketAuthorLocalOpen open
TicketUnderProject
project TicketProjectLocalId
author TicketAuthorLocalId
UniqueTicketUnderProject project author