From b33ea637696031c8408b50b20d8d0dfbe12e9076 Mon Sep 17 00:00:00 2001 From: arf20 Date: Fri, 22 Mar 2024 21:32:37 +0100 Subject: Invoice SQL init --- dbinit.sql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 9ee8f0d..a75b146 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -29,7 +29,6 @@ CREATE TABLE `arfnet2`.`orders` ( `billing` VARCHAR(255) NOT NULL , `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `status` ENUM('setting up','active','inactive') NOT NULL DEFAULT 'setting up' , - `duedate` TIMESTAMP NOT NULL DEFAULT 0 , `comments` TEXT NOT NULL , PRIMARY KEY (`id`) ); @@ -45,3 +44,13 @@ CREATE TABLE `arfnet2`.`tickets` ( `asignee` INT NOT NULL , PRIMARY KEY (`id`) ); + +CREATE TABLE `arfnet2`.`invoices` ( + `id` INT NOT NULL AUTO_INCREMENT , + `order` INT NOT NULL , + `desc` VARCHAR(255) NOT NULL , + `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , + `pdf` MEDIUMBLOB NOT NULL , + `status` ENUM('paid','unpaid') NOT NULL DEFAULT 'unpaid' , + PRIMARY KEY (`id`) +); -- cgit v1.2.3