From 0db2d6bb98e5243415f9ad9d7fc01ed1e94506a1 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Mon, 25 Sep 2006 21:44:21 +0000
Subject: [PATCH] Prevent NOT NULL fields to have one DEFAULT NULL clause

---
 lib/xmldb/classes/generators/XMLDBGenerator.class.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/xmldb/classes/generators/XMLDBGenerator.class.php b/lib/xmldb/classes/generators/XMLDBGenerator.class.php
index 7786bfc47d..fccf3d52c0 100644
--- a/lib/xmldb/classes/generators/XMLDBGenerator.class.php
+++ b/lib/xmldb/classes/generators/XMLDBGenerator.class.php
@@ -440,7 +440,7 @@ class XMLDBgenerator {
             /// never applying defaults to TEXT and BINARY fields
                 if ($this->drop_default_clause_required &&
                     $xmldb_field->getType() != XMLDB_TYPE_TEXT &&
-                    $xmldb_field->getType() != XMLDB_TYPE_BINARY) {
+                    $xmldb_field->getType() != XMLDB_TYPE_BINARY && !$xmldb_field->getNotNull()) {
                     $default = ' DEFAULT ' . $this->drop_default_clause;
                 }
             }
-- 
2.39.5