Provides Control of BLOB data dictionary feature

ADOdb automatically disallows setting of NOT NULL or DEFAULT values on
blob type fields. This was due to historic limitations on data types
that no longer exists.

This commit takes the work done in PR #118  by @obmsch  and adds the
driver for SQLite.

Fixes #292

3 files changed, 8 insertions, 2 deletions

diff --git a/datadict/datadict-mysql.inc.php b/datadict/datadict-mysql.inc.php
index 640fb87a..5ae33b1d 100644
--- a/datadict/datadict-mysql.inc.php
+++ b/datadict/datadict-mysql.inc.php
@@ -24,6 +24,8 @@ class ADODB2_mysql extends ADODB_DataDict {
 	var $dropIndex = 'DROP INDEX %s ON %s';
 	var $renameColumn = 'ALTER TABLE %s CHANGE COLUMN %s %s %s';	// needs column-definition!
 
+	public $blobAllowsNotNull = true;
+	
 	function MetaType($t,$len=-1,$fieldobj=false)
 	{
 		
diff --git a/datadict/datadict-postgres.inc.php b/datadict/datadict-postgres.inc.php
index 8fcb5712..68bdeddc 100644
--- a/datadict/datadict-postgres.inc.php
+++ b/datadict/datadict-postgres.inc.php
@@ -25,6 +25,9 @@ class ADODB2_postgres extends ADODB_DataDict {
 	var $renameTable = 'ALTER TABLE %s RENAME TO %s'; // at least since 7.1
 	var $dropTable = 'DROP TABLE %s CASCADE';
 
+	public $blobAllowsDefaultValue = true;
+	public $blobAllowsNotNull      = true;
+	
 	function MetaType($t,$len=-1,$fieldobj=false)
 	{
 		if (is_object($t)) {
diff --git a/datadict/datadict-sqlite.inc.php b/datadict/datadict-sqlite.inc.php
index 44b949c9..52c031ca 100644
--- a/datadict/datadict-sqlite.inc.php
+++ b/datadict/datadict-sqlite.inc.php
@@ -25,8 +25,9 @@ class ADODB2_sqlite extends ADODB_DataDict {
 	var $dropIndex = 'DROP INDEX IF EXISTS %s';
 	var $renameTable = 'ALTER TABLE %s RENAME TO %s';
 
-
-
+	public $blobAllowsDefaultValue = true;
+	public $blobAllowsNotNull      = true;
+    
 	function ActualType($meta)
 	{
 		switch(strtoupper($meta)) {