X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F30sqlt-new-diff-mysql.t;h=9ed3108ee0b9214a99f73dd4d0c73d823bde9ce5;hb=06baeb2195df54daf9e50033a2050b473271b07d;hp=a3ed806b14d128414d9ff41ec1de8063f61ec978;hpb=1c8ec56e310980f823b2ea35fab59d7a139fa96a;p=dbsrgits%2FSQL-Translator.git diff --git a/t/30sqlt-new-diff-mysql.t b/t/30sqlt-new-diff-mysql.t index a3ed806..9ed3108 100644 --- a/t/30sqlt-new-diff-mysql.t +++ b/t/30sqlt-new-diff-mysql.t @@ -72,15 +72,15 @@ ALTER TABLE employee DROP COLUMN job_title; ALTER TABLE new_name ADD COLUMN new_field integer; -ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT '1'; +ALTER TABLE person ADD COLUMN is_rock_star tinyint(4) DEFAULT 1; ALTER TABLE person CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment; ALTER TABLE person CHANGE COLUMN name name varchar(20) NOT NULL; -ALTER TABLE person CHANGE COLUMN age age integer(11) DEFAULT '18'; +ALTER TABLE person CHANGE COLUMN age age integer(11) DEFAULT 18; -ALTER TABLE person CHANGE COLUMN iq iq integer(11) DEFAULT '0'; +ALTER TABLE person CHANGE COLUMN iq iq integer(11) DEFAULT 0; ALTER TABLE person CHANGE COLUMN description physical_description text; @@ -128,11 +128,11 @@ ALTER TABLE old_name RENAME TO new_name, ADD COLUMN new_field integer; ALTER TABLE person DROP INDEX UC_age_name, - ADD COLUMN is_rock_star tinyint(4) DEFAULT '1', + ADD COLUMN is_rock_star tinyint(4) DEFAULT 1, CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment, CHANGE COLUMN name name varchar(20) NOT NULL, - CHANGE COLUMN age age integer(11) DEFAULT '18', - CHANGE COLUMN iq iq integer(11) DEFAULT '0', + CHANGE COLUMN age age integer(11) DEFAULT 18, + CHANGE COLUMN iq iq integer(11) DEFAULT 0, CHANGE COLUMN description physical_description text, ADD UNIQUE UC_person_id (person_id), ADD UNIQUE UC_age_name (age, name), @@ -198,11 +198,11 @@ ALTER TABLE employee DROP FOREIGN KEY FK5302D47D93FE702E, ALTER TABLE person DROP INDEX UC_age_name, DROP INDEX u_name, - ADD COLUMN is_rock_star tinyint(4) DEFAULT '1', + ADD COLUMN is_rock_star tinyint(4) DEFAULT 1, CHANGE COLUMN person_id person_id integer(11) NOT NULL auto_increment, CHANGE COLUMN name name varchar(20) NOT NULL, - CHANGE COLUMN age age integer(11) DEFAULT '18', - CHANGE COLUMN iq iq integer(11) DEFAULT '0', + CHANGE COLUMN age age integer(11) DEFAULT 18, + CHANGE COLUMN iq iq integer(11) DEFAULT 0, CHANGE COLUMN description physical_description text, ADD UNIQUE INDEX unique_name (name), ADD UNIQUE UC_person_id (person_id),