-- Receipt pictures for expenses. Private: only staff with the expenses permission can open them (never served from /api/media).
CREATE TABLE expense_receipts (
  id          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  expense_id  INT UNSIGNED NOT NULL,
  filename    VARCHAR(64) NOT NULL,
  created_by  INT UNSIGNED NULL,
  created_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_expense (expense_id),
  KEY idx_file (filename),
  FOREIGN KEY (expense_id) REFERENCES expenses(id) ON DELETE CASCADE
) ENGINE=InnoDB;
INSERT INTO migrations (name) VALUES ('007_expense_receipts');
