Changes between Version 8 and Version 9 of ddlScript-with-help-of-AI.sql

Timestamp:

01/09/26 20:28:58 (11 days ago)

Author:

235018

Comment:

--

ddlScript-with-help-of-AI.sql

@@ -154 +154 @@
     last_date_mod TIMESTAMP NOT NULL,
     payment_method VARCHAR (250) NOT NULL,                  -- Format : "credit card, **** **** **** 6750" , or "cash", or "paypal, user@gmail.com",... Contains important information that are going to be needed when issuing a refund 
-    discount DECIMAL(5,2) DEFAULT 0.0 CHECK(discount>=0.0 AND discount<= 100.00)
-    --CONSTRAINT check_status (status IN ('placed order', 'being processed', 'shipping', 'delivered', 'canceled'))
+    discount DECIMAL(5,2) DEFAULT 0.0 CHECK(discount>=0.0 AND discount<= 100.00),
+    delivery_address VARCHAR NOT NULL,                        -- Combined, street, city and postcode of client's chosen address. Default is the delivery address marked by client
+    CONSTRAINT check_status (status IN ('placed order', 'being processed', 'shipping', 'delivered', 'canceled'))
 );