spec/scheman/diff_spec.rb in scheman-0.0.2 vs spec/scheman/diff_spec.rb in scheman-0.0.3

@@ -18,11 +18,12 @@
   end
 
   let(:before_schema) do
     <<-EOS.strip_heredoc
       CREATE TABLE `table1` (
-        `column1` INTEGER(11) PRIMARY KEY NOT NULL AUTO INCREMENT
+        `column1` INTEGER(11) PRIMARY KEY NOT NULL AUTO INCREMENT,
+        `column2` DATETIME DEFAULT NOW()
       );
 
       CREATE TABLE `table2` (
         `column1` INTEGER(11) NOT NULL AUTO INCREMENT,
         PRIMARY KEY (`column1`)
@@ -32,11 +33,12 @@
 
   let(:after_schema) do
     <<-EOS.strip_heredoc
       CREATE TABLE `table1` (
         `column1` CHAR(11) NOT NULL AUTO INCREMENT,
-        `column2` VARCHAR(255) NOT NULL,
+        `column2` DATETIME DEFAULT CURRENT_TIMESTAMP(),
+        `column3` VARCHAR(255) NOT NULL DEFAULT "a",
         PRIMARY KEY (`column2`)
       );
 
       CREATE TABLE `table3` (
         `column1` INTEGER(11) NOT NULL AUTO INCREMENT,
@@ -59,10 +61,10 @@
         CREATE TABLE `table3` (
           `column1` INTEGER(11) NOT NULL AUTO INCREMENT,
           PRIMARY KEY (`column1`)
         );
 
-        ALTER TABLE `table1` ADD COLUMN `column2` VARCHAR(255) NOT NULL,
+        ALTER TABLE `table1` ADD COLUMN `column3` VARCHAR(255) NOT NULL DEFAULT "a",
           CHANGE COLUMN `column1` CHAR(11) NOT NULL AUTO INCREMENT,
           DROP PRIMARY KEY,
           ADD PRIMARY KEY `column2`;
 
         DROP TABLE `table2`;