From 4c4b8df824dcd2fd3ac4b8d486181ec87a0f13cd Mon Sep 17 00:00:00 2001 From: arf20 Date: Mon, 18 Mar 2024 17:55:48 +0100 Subject: Add manageorders, fix services edit --- dbinit.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 7fdc06e..7f7dec9 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -20,3 +20,14 @@ CREATE TABLE `arfnet2`.`services` ( `description` TEXT NOT NULL , PRIMARY KEY (`id`) ); + +CREATE TABLE `arfnet2`.`orders` ( + `id` INT NOT NULL AUTO_INCREMENT , + `service` INT NOT NULL , + `name` VARCHAR(255) NOT NULL , + `client` INT NOT NULL , + `billing` VARCHAR(255) NOT NULL , + `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , + `comments` TEXT NOT NULL , + PRIMARY KEY (`id`) +); -- cgit v1.2.3