From 8a1f665f1ff9c5084b9c6372d21b49e8a36713b3 Mon Sep 17 00:00:00 2001 From: arf20 Date: Sun, 24 Mar 2024 01:41:55 +0100 Subject: Invoice management --- dbinit.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index a75b146..f3476d9 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -47,10 +47,11 @@ CREATE TABLE `arfnet2`.`tickets` ( CREATE TABLE `arfnet2`.`invoices` ( `id` INT NOT NULL AUTO_INCREMENT , - `order` INT NOT NULL , + `client` INT NOT NULL , `desc` VARCHAR(255) NOT NULL , - `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , + `amount` DECIMAL(10, 4) NOT NULL , `pdf` MEDIUMBLOB NOT NULL , + `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` ENUM('paid','unpaid') NOT NULL DEFAULT 'unpaid' , PRIMARY KEY (`id`) ); -- cgit v1.2.3