# --------------------------------------------------------
# version 1.06 -> 1.07
# --------------------------------------------------------

# table collectivite
ALTER TABLE `collectivite` ADD `departement` VARCHAR( 2 ) NOT NULL ,
ADD `commune` VARCHAR( 7 ) NOT NULL;
ALTER TABLE `collectivite` ADD `circonscription` VARCHAR( 2 ) NOT NULL ;
# table canton
ALTER TABLE `canton` ADD `canton_prefecture` VARCHAR( 2 ) NOT NULL ;
# table election_resultat
ALTER TABLE `election_candidat` ADD `liste_prefecture` INT( 4 ) NOT NULL ;
# table liste
ALTER TABLE `liste` ADD `siege` INT( 4 ) NOT NULL ;