-- Archived board cards (oxygenhub#293): off the board, kept, found with

-- the board's archive view and restorable. NULL while on the board.

ALTER TABLE project_cards ADD COLUMN archived_ms INTEGER;

-- When a card joined its column, so a column's cards can be archived some

-- days after they reached it (Done after 14 days).

ALTER TABLE project_cards ADD COLUMN moved_ms INTEGER NOT NULL DEFAULT 0;

UPDATE project_cards SET moved_ms = created_ms;

-- A column whose cards are archived this many days after they joined it;

-- NULL never.

ALTER TABLE project_columns ADD COLUMN archive_after_days INTEGER;