X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fdata%2Fxml%2Fschema-basic.xml;h=949d1bf2c130704285ac58027837f27fd9a3ce3c;hb=5ff70f1ac9dd66a8fec633b4ec71fa6a395fa210;hp=cd7bf3c47a9f2500ec71f7d1968c0485f23afe14;hpb=02069e4070b1bda9ebc9c12faeac5cec492fef26;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/data/xml/schema-basic.xml b/t/data/xml/schema-basic.xml
index cd7bf3c..949d1bf 100644
--- 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>