
ALTER TABLE collectivite add column `delavillede` varchar(50) NOT NULL default '';

ALTER TABLE droit MODIFY COLUMN droit varchar(50) NOT NULL default '';

INSERT INTO `droit` (`droit`, `profil`) VALUES
('affectation_automatique_des_heures', 4),
('composition_des_bureaux', 4),
('convocation_des_agents', 4),
('convocation_des_presidents', 4),
('recepisse', 4),
('transfert_des_affectations', 4),
('transfert_des_candidatures', 4),
('composition_des_bureaux_edition', 4),
('candidature_p', 4),
('affectation_p', 4),
('affectation_r', 4),
('scrutin_bureau_pdfetat', 3),
('scrutin_president_pdfetat', 3),
('candidature_pdfetat', 3),
('affectation_pdfetat', 3),
('etat', 4),
('sousetat', 4),
('reqmo', 3);
