From 35cc8e898cdb88c690de679b79df7bc061203d4f Mon Sep 17 00:00:00 2001
From: jakubvrana <jakubvrana@7c3ca157-0c34-0410-bff1-cbf682f78f5c>
Date: Wed, 15 Aug 2007 12:43:48 +0000
Subject: [PATCH] Empty value drops DEFAULT

git-svn-id: https://adminer.svn.sourceforge.net/svnroot/adminer/trunk@340 7c3ca157-0c34-0410-bff1-cbf682f78f5c
---
 edit.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/edit.inc.php b/edit.inc.php
index b184299a..21945d26 100644
--- a/edit.inc.php
+++ b/edit.inc.php
@@ -21,7 +21,7 @@ if ($_POST && !$error) {
 				} elseif ($field["type"] == "timestamp") {
 					$set[] = " MODIFY " . idf_escape($name) . " timestamp" . ($field["null"] ? " NULL" : "") . " DEFAULT $val" . ($_POST["on_update"][bracket_escape($name)] ? " ON UPDATE CURRENT_TIMESTAMP" : "");
 				} else {
-					$set[] = " ALTER " . idf_escape($name) . ($val == "NULL" ? " DROP DEFAULT" : " SET DEFAULT $val");
+					$set[] = " ALTER " . idf_escape($name) . ($val == ($field["null"] ? "NULL" : "''") ? " DROP DEFAULT" : " SET DEFAULT $val");
 				}
 			}
 		}
-- 
2.39.5