From 860b55463fd106f3c0f51ffb9d8537e0c83175e7 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 22 Aug 2006 22:10:09 +0000
Subject: [PATCH] Normalizing a bit all the float/double generators.

---
 lib/xmldb/classes/generators/mssql/mssql.class.php         | 7 ++++---
 lib/xmldb/classes/generators/mysql/mysql.class.php         | 7 ++++++-
 lib/xmldb/classes/generators/postgres7/postgres7.class.php | 2 +-
 3 files changed, 11 insertions(+), 5 deletions(-)

diff --git a/lib/xmldb/classes/generators/mssql/mssql.class.php b/lib/xmldb/classes/generators/mssql/mssql.class.php
index 3172075a43..38e690fffb 100644
--- a/lib/xmldb/classes/generators/mssql/mssql.class.php
+++ b/lib/xmldb/classes/generators/mssql/mssql.class.php
@@ -92,9 +92,10 @@ class XMLDBmssql extends XMLDBgenerator {
                 break;
             case XMLDB_TYPE_FLOAT:
                 $dbtype = 'FLOAT';
-                if (!empty($xmldb_length)) {
-                    $dbtype .= '(' . $xmldb_length;
-                    $dbtype .= ')';
+                if (!empty($xmldb_decimals)) {
+                    if ($xmldb_decimals < 6) {
+                        $dbtype = 'REAL';
+                    }
                 }
                 break;
             case XMLDB_TYPE_CHAR:
diff --git a/lib/xmldb/classes/generators/mysql/mysql.class.php b/lib/xmldb/classes/generators/mysql/mysql.class.php
index dfa3af2b9f..6e4016b9d5 100644
--- a/lib/xmldb/classes/generators/mysql/mysql.class.php
+++ b/lib/xmldb/classes/generators/mysql/mysql.class.php
@@ -92,7 +92,12 @@ class XMLDBmysql extends XMLDBGenerator {
                 }
                 break;
             case XMLDB_TYPE_FLOAT:
-                $dbtype = 'FLOAT';
+                $dbtype = 'DOUBLE';
+                if (!empty($xmldb_decimals)) {
+                    if ($xmldb_decimals < 6) {
+                        $dbtype = 'FLOAT';
+                    }
+                }
                 if (!empty($xmldb_length)) {
                     $dbtype .= '(' . $xmldb_length;
                     if (!empty($xmldb_decimals)) {
diff --git a/lib/xmldb/classes/generators/postgres7/postgres7.class.php b/lib/xmldb/classes/generators/postgres7/postgres7.class.php
index e9e2599bad..4a0d9d174b 100644
--- a/lib/xmldb/classes/generators/postgres7/postgres7.class.php
+++ b/lib/xmldb/classes/generators/postgres7/postgres7.class.php
@@ -87,7 +87,7 @@ class XMLDBpostgres7 extends XMLDBgenerator {
                 }
                 break;
             case XMLDB_TYPE_FLOAT:
-                $dbtype = 'DOUBLE PRECISION';
+                $dbtype = 'DOUBLE';
                 if (!empty($xmldb_decimals)) {
                     if ($xmldb_decimals < 6) {
                         $dbtype = 'REAL';
-- 
2.39.5