Dear SQL::Translator peeps
I've been working on improving the ::Diff code - refactoring it so that
its maintainable, and making it so that the MySQL diff gives the
following code:
ALTER TABLE person DROP UNIQUE UC_age_name,
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 description physical_description text,
ADD UNIQUE UC_person_id (person_id),
ADD UNIQUE UC_age_name (age, name),
ENGINE=InnoDB;
I'm just about done with this - and I'd like to be able to commit it
back to the main repository. Can I please have a commit bit? (If people
wish to review it first I'd be more than happy to commit to a branch in
the first instance).
My SourceForge username is ashberlin.
Cheers,
Ash
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
--
sqlfairy-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
