Tue 20 Jun 2006 09:40:42 PM UTC, comment #1:
The following changes has been done in the database:
ALTER TABLE album MODIFY id_album MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE album MODIFY id_author MEDIUMINT unsigned NOT NULL;
ALTER TABLE album_allow_to_add_list MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE album_allow_to_add_list MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE album_allow_to_see_list MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE album_allow_to_see_list MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE comment MODIFY id_comment SMALLINT unsigned NOT NULL auto_increment;
ALTER TABLE comment MODIFY id_info MEDIUMINT unsigned default NULL;
ALTER TABLE comment MODIFY id_author MEDIUMINT unsigned default NULL;
ALTER TABLE comment MODIFY father_comment SMALLINT unsigned default NULL;
ALTER TABLE diary MODIFY id_diary MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE diary MODIFY id_author MEDIUMINT unsigned default NULL;
ALTER TABLE info MODIFY id_info MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE info MODIFY id_author MEDIUMINT unsigned default NULL;
ALTER TABLE info_album MODIFY id_info MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE photo_album MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE photo_album MODIFY id_author MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE users MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;
|