X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F30sqlt-new-diff-sqlite.t;h=5d6ad92bd7a7b66ed3bca6720a9af0a13e6d8e8d;hb=06baeb2195df54daf9e50033a2050b473271b07d;hp=143f6a57e112834cf2883348dacbe1f84e98d69b;hpb=1c8ec56e310980f823b2ea35fab59d7a139fa96a;p=dbsrgits%2FSQL-Translator.git diff --git a/t/30sqlt-new-diff-sqlite.t b/t/30sqlt-new-diff-sqlite.t index 143f6a5..5d6ad92 100644 --- a/t/30sqlt-new-diff-sqlite.t +++ b/t/30sqlt-new-diff-sqlite.t @@ -60,7 +60,7 @@ DROP INDEX u_name; ALTER TABLE new_name ADD COLUMN new_field int; -ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT '1'; +ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT 1; -- SQL::Translator::Producer::SQLite cant alter_field; @@ -122,10 +122,10 @@ ALTER TABLE new_name ADD COLUMN new_field int; CREATE TEMPORARY TABLE person_temp_alter ( person_id INTEGER PRIMARY KEY NOT NULL, name varchar(20) NOT NULL, - age int(11) DEFAULT '18', + age int(11) DEFAULT 18, weight double(11,2), - iq int(11) DEFAULT '0', - is_rock_star tinyint(4) DEFAULT '1', + iq int(11) DEFAULT 0, + is_rock_star tinyint(4) DEFAULT 1, physical_description text ); @@ -136,10 +136,10 @@ DROP TABLE person; CREATE TABLE person ( person_id INTEGER PRIMARY KEY NOT NULL, name varchar(20) NOT NULL, - age int(11) DEFAULT '18', + age int(11) DEFAULT 18, weight double(11,2), - iq int(11) DEFAULT '0', - is_rock_star tinyint(4) DEFAULT '1', + iq int(11) DEFAULT 0, + is_rock_star tinyint(4) DEFAULT 1, physical_description text );