From 4c4b8df824dcd2fd3ac4b8d486181ec87a0f13cd Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
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

