$ ./mysqldiff -u=$MYSQL_USER -p=$MYSQL_PASS db:pwg-1_3_2 db:pwg-bsf
## mysqldiff 0.33
##
## Run on Wed Nov 17 13:28:22 2004
## Options: password=xxx, user=root
##
## ---   db: pwg-1_3_2 (user=root)
## +++   db: pwg-bsf (user=root)

ALTER TABLE phpwebgallery_categories CHANGE COLUMN site_id site_id tinyint(4) unsigned default '1'; # was tinyint(4) unsigned NOT NULL default '1'
ALTER TABLE phpwebgallery_categories ADD COLUMN commentable enum('true','false') NOT NULL default 'true';
ALTER TABLE phpwebgallery_categories DROP INDEX id_uppercat; # was INDEX (id_uppercat)
ALTER TABLE phpwebgallery_categories ADD INDEX categories_i2 (id_uppercat);
ALTER TABLE phpwebgallery_comments CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00'; # was int(11) unsigned NOT NULL default '0'
ALTER TABLE phpwebgallery_config DROP COLUMN nb_comment_page; # was tinyint(4) NOT NULL default '10'
ALTER TABLE phpwebgallery_config DROP COLUMN max_user_listbox; # was tinyint(3) unsigned NOT NULL default '10'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_available; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_maxheight_thumbnail; # was smallint(5) unsigned NOT NULL default '100'
ALTER TABLE phpwebgallery_config DROP COLUMN mail_notification; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_maxwidth_thumbnail; # was smallint(5) unsigned NOT NULL default '150'
ALTER TABLE phpwebgallery_config DROP COLUMN show_comments; # was enum('true','false') NOT NULL default 'true'
ALTER TABLE phpwebgallery_config DROP COLUMN session_id_size; # was tinyint(3) unsigned NOT NULL default '4'
ALTER TABLE phpwebgallery_config DROP COLUMN mail_webmaster; # was varchar(255) NOT NULL default ''
ALTER TABLE phpwebgallery_config DROP COLUMN log; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN session_time; # was tinyint(3) unsigned NOT NULL default '30'
ALTER TABLE phpwebgallery_config DROP COLUMN comments_validation; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_maxheight; # was smallint(5) unsigned NOT NULL default '600'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_maxwidth; # was smallint(5) unsigned NOT NULL default '800'
ALTER TABLE phpwebgallery_config DROP COLUMN session_keyword; # was varchar(255) default NULL
ALTER TABLE phpwebgallery_config DROP COLUMN prefix_thumbnail; # was varchar(10) default 'TN-'
ALTER TABLE phpwebgallery_config DROP COLUMN webmaster; # was varchar(255) NOT NULL default ''
ALTER TABLE phpwebgallery_config DROP COLUMN authorize_cookies; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN comments_forall; # was enum('true','false') NOT NULL default 'false'
ALTER TABLE phpwebgallery_config DROP COLUMN access; # was enum('free','restricted') default 'free'
ALTER TABLE phpwebgallery_config DROP COLUMN upload_maxfilesize; # was smallint(5) unsigned NOT NULL default '150'
ALTER TABLE phpwebgallery_config ADD COLUMN value varchar(255) default NULL;
ALTER TABLE phpwebgallery_config ADD COLUMN param varchar(40) NOT NULL default '';
ALTER TABLE phpwebgallery_config ADD COLUMN comment varchar(255) default NULL;
ALTER TABLE phpwebgallery_config ADD PRIMARY KEY (param);
ALTER TABLE phpwebgallery_config TYPE=MyISAM COMMENT='configuration table'; # was TYPE=MyISAM
ALTER TABLE phpwebgallery_favorites DROP INDEX user_id; # was INDEX (user_id,image_id)
ALTER TABLE phpwebgallery_favorites ADD PRIMARY KEY (user_id,image_id);
ALTER TABLE phpwebgallery_history CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00'; # was int(11) NOT NULL default '0'
ALTER TABLE phpwebgallery_history ADD PRIMARY KEY (date);
ALTER TABLE phpwebgallery_image_category DROP INDEX image_id; # was INDEX (image_id)
ALTER TABLE phpwebgallery_image_category DROP INDEX category_id; # was INDEX (category_id)
ALTER TABLE phpwebgallery_image_category ADD INDEX image_category_i1 (image_id);
ALTER TABLE phpwebgallery_image_category ADD INDEX image_category_i2 (category_id);
ALTER TABLE phpwebgallery_images CHANGE COLUMN tn_ext tn_ext varchar(4) default ''; # was char(3) NOT NULL default 'jpg'
ALTER TABLE phpwebgallery_images ADD COLUMN path varchar(255) NOT NULL default '';
ALTER TABLE phpwebgallery_images ADD COLUMN date_metadata_update date default NULL;
ALTER TABLE phpwebgallery_images ADD COLUMN average_rate float(5,2) unsigned default NULL;
ALTER TABLE phpwebgallery_images ADD COLUMN representative_ext varchar(4) default NULL;
ALTER TABLE phpwebgallery_images DROP INDEX storage_category_id; # was INDEX (storage_category_id)
ALTER TABLE phpwebgallery_images ADD INDEX images_i1 (storage_category_id);
ALTER TABLE phpwebgallery_images ADD INDEX images_i2 (date_available);
ALTER TABLE phpwebgallery_images ADD INDEX images_i3 (average_rate);
ALTER TABLE phpwebgallery_images ADD INDEX images_i4 (hit);
ALTER TABLE phpwebgallery_sites DROP INDEX galleries_url; # was UNIQUE (galleries_url)
ALTER TABLE phpwebgallery_sites ADD UNIQUE sites_ui1 (galleries_url);
DROP TABLE phpwebgallery_user_category;

ALTER TABLE phpwebgallery_users DROP COLUMN long_period; # was tinyint(3) unsigned NOT NULL default '14'
ALTER TABLE phpwebgallery_users DROP COLUMN short_period; # was tinyint(3) unsigned NOT NULL default '7'
ALTER TABLE phpwebgallery_users ADD COLUMN recent_period tinyint(3) unsigned NOT NULL default '7';
ALTER TABLE phpwebgallery_users DROP INDEX username; # was UNIQUE (username)
ALTER TABLE phpwebgallery_users ADD UNIQUE users_ui1 (username);
CREATE TABLE phpwebgallery_rate (
  user_id smallint(5) unsigned NOT NULL default '0',
  element_id mediumint(8) unsigned NOT NULL default '0',
  rate tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,element_id)
) TYPE=MyISAM;