Fixed default value bug in Parser::SqlfXML.

[dbsrgits/SQL-Translator.git] / t / data / xml / schema-basic.xml

diff --git a/t/data/xml/schema-basic.xml b/t/data/xml/schema-basic.xml
index cd7bf3c..949d1bf 100644 (file)
--- a/t/data/xml/schema-basic.xml
+++ b/t/data/xml/schema-basic.xml
@@ -6,7 +6,7 @@ Created on Fri Aug  1 11:24:58 2003
  -->
 
 <sqlf:schema xmlns:sqlf="http://sqlfairy.sourceforge.net/sqlfairy.xml">
-       
+    
   <sqlf:table>
     <sqlf:name>Basic</sqlf:name>
     <sqlf:order>1</sqlf:order>
@@ -16,6 +16,7 @@ Created on Fri Aug  1 11:24:58 2003
         <sqlf:is_primary_key>1</sqlf:is_primary_key>
         <sqlf:is_auto_increment>1</sqlf:is_auto_increment>
         <sqlf:data_type>int</sqlf:data_type>
+        <sqlf:is_nullable>0</sqlf:is_nullable>
         <sqlf:size>10</sqlf:size>
         <sqlf:order>1</sqlf:order>
       </sqlf:field>
@@ -24,31 +25,47 @@ Created on Fri Aug  1 11:24:58 2003
         <sqlf:data_type>varchar</sqlf:data_type>
         <sqlf:size>100</sqlf:size>
         <sqlf:default_value>hello</sqlf:default_value>
+        <sqlf:is_nullable>0</sqlf:is_nullable>
         <sqlf:order>2</sqlf:order>
       </sqlf:field>
       <sqlf:field>
-               <sqlf:name>description</sqlf:name>
+        <sqlf:name>description</sqlf:name>
         <sqlf:data_type>text</sqlf:data_type>
-        <sqlf:is_nullable>1</sqlf:is_nullable>
+        <sqlf:default_value></sqlf:default_value>
         <sqlf:order>3</sqlf:order>
       </sqlf:field>
       <sqlf:field>
-           <sqlf:name>email</sqlf:name>
+        <sqlf:name>email</sqlf:name>
         <sqlf:data_type>varchar</sqlf:data_type>
-               <sqlf:size>255</sqlf:size>
+        <sqlf:is_nullable>1</sqlf:is_nullable>
+        <sqlf:size>255</sqlf:size>
         <sqlf:order>4</sqlf:order>
       </sqlf:field>
-       </sqlf:fields>
-       
-       <sqlf:indices>
+      <sqlf:field>
+        <sqlf:name>explicitnulldef</sqlf:name>
+        <sqlf:data_type>varchar</sqlf:data_type>
+        <sqlf:is_nullable>1</sqlf:is_nullable>
+        <sqlf:default_value>NULL</sqlf:default_value>
+        <sqlf:order>5</sqlf:order>
+      </sqlf:field>
+      <sqlf:field>
+        <sqlf:name>explicitemptystring</sqlf:name>
+        <sqlf:data_type>varchar</sqlf:data_type>
+        <sqlf:is_nullable>1</sqlf:is_nullable>
+        <sqlf:default_value>EMPTY_STRING</sqlf:default_value>
+        <sqlf:order>5</sqlf:order>
+      </sqlf:field>
+    </sqlf:fields>
+    
+    <sqlf:indices>
       <sqlf:index>
-           <sqlf:fields>title</sqlf:fields>
+        <sqlf:fields>title</sqlf:fields>
         <sqlf:name>titleindex</sqlf:name>
         <sqlf:type>NORMAL</sqlf:type>
       </sqlf:index>
     </sqlf:indices>
-       
-       <sqlf:constraints>
+    
+    <sqlf:constraints>
       <sqlf:constraint>
         <sqlf:deferrable>1</sqlf:deferrable>
         <sqlf:fields>email</sqlf:fields>