USE [% agbook %];

## mysqldiff 0.30
## 
## run on Tue Jan 15 09:24:16 2008
##
## ---   db: cpaddons_agbook1 (host=192.168.98.20 port=3306 user=cpaddons_agbook1)
## +++   db: cpaddons_agb243 (host=192.168.98.20 port=3306 user=cpaddons_agb243)

ALTER TABLE `[% table_prefix %]_book_com` CHANGE COLUMN `host` `host` varchar(255) NOT NULL default ''; # was varchar(60) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `url` `url` varchar(255) NOT NULL default ''; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `host` `host` varchar(255) NOT NULL default ''; # was varchar(60) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `email` `email` varchar(100) NOT NULL default ''; # was varchar(60) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `location` `location` varchar(100) NOT NULL default ''; # was varchar(50) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `aim` `aim` varchar(100) NOT NULL default ''; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_data` CHANGE COLUMN `browser` `browser` tinytext; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `url` `url` varchar(255) NOT NULL default ''; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `host` `host` varchar(255) NOT NULL default ''; # was varchar(60) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `email` `email` varchar(100) NOT NULL default ''; # was varchar(60) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `location` `location` varchar(100) NOT NULL default ''; # was varchar(50) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `aim` `aim` varchar(100) NOT NULL default ''; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_private` CHANGE COLUMN `browser` `browser` tinytext; # was varchar(70) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_book_words` CHANGE COLUMN `word` `word` varchar(50) NOT NULL default ''; # was varchar(30) NOT NULL default ''
