Index: /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql	(revision 21568)
+++ /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql	(revision 21643)
@@ -537,5 +537,5 @@
     order_job int,
     subtotal numeric,
-    discount numeric,
+    discount numeric NOT NULL DEFAULT 0,
     deliv_id int,
     deliv_fee numeric,
@@ -594,5 +594,5 @@
     order_job int,
     subtotal numeric,
-    discount numeric,
+    discount numeric NOT NULL DEFAULT 0,
     deliv_id int,
     deliv_fee numeric,
Index: /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	(revision 21574)
+++ /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	(revision 21643)
@@ -537,5 +537,5 @@
     order_job int,
     subtotal numeric,
-    discount numeric,
+    discount numeric NOT NULL DEFAULT 0,
     deliv_id int,
     deliv_fee numeric,
@@ -594,5 +594,5 @@
     order_job int,
     subtotal numeric,
-    discount numeric,
+    discount numeric NOT NULL DEFAULT 0,
     deliv_id int,
     deliv_fee numeric,