Avoid the posibility of having 'NOT NULL DEFAULT NULL' with primary keys in MySQL...

[dbsrgits/SQL-Translator.git] / t / 64xml-to-mysql.t

diff --git a/t/64xml-to-mysql.t b/t/64xml-to-mysql.t
index fea07b0..2beb6d0 100644 (file)
--- a/t/64xml-to-mysql.t
+++ b/t/64xml-to-mysql.t
@@ -35,7 +35,7 @@ my @want = (
 
     q[DROP TABLE IF EXISTS `Basic`],
     q[CREATE TABLE `Basic` (
-  `id` integer(10) zerofill NOT NULL auto_increment,
+  `id` integer(10) zerofill auto_increment,
   `title` varchar(100) NOT NULL DEFAULT 'hello',
   `description` text DEFAULT '',
   `email` varchar(500),
@@ -54,7 +54,7 @@ my @want = (
 
     q[DROP TABLE IF EXISTS `Another`],
     q[CREATE TABLE `Another` (
-  `id` integer(10) NOT NULL auto_increment,
+  `id` integer(10) auto_increment,
   `num` numeric(10, 2),
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB],