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

