#
# - Script    : LightForum
# - Version   : 1.8
# - Date      : 2 mai 2003
# Merci de lire le fichier licence.txt / Please read the file licence.txt
#
# Executez cette commande dans phpMyAdmin
#
# Mise à jour de lightforum, versions 1.x vers 1.7
#

ALTER TABLE light_forum_tbl CHANGE id id INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT,
CHANGE reponse_a_id reponse_a_id INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE lect lect MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL,
DROP date,
DROP heure,
ADD recevoirParMail TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD derniereReponse DATETIME NOT NULL,
ADD INDEX derniereReponse (derniereReponse),
ADD INDEX recevoirParMail (recevoirParMail);