mirror of
https://github.com/quentin-g-dev/afup.git
synced 2026-03-24 09:12:16 +01:00
18 lines
663 B
SQL
18 lines
663 B
SQL
-- STORY
|
|
-- As the account manager
|
|
-- I want to tell that a line in `compta` doesn't require any attachment
|
|
-- So that I can have a quick look onto which lines require one.
|
|
|
|
-- Add `attachment_required` column in compta
|
|
ALTER TABLE `compta`
|
|
ADD COLUMN `attachment_required` TINYINT(1) DEFAULT 0 AFTER `comment`;
|
|
|
|
-- STORY
|
|
-- As the account manager
|
|
-- I want to know what attachment filename is linked to a line in `compta`
|
|
-- Because I need to export a complete and structured summary sheet.
|
|
|
|
-- Add `attachment_filename` column in compta
|
|
ALTER TABLE `compta`
|
|
ADD COLUMN `attachment_filename` VARCHAR(255) NULL DEFAULT NULL AFTER `attachment_required`;
|