--
-- Structure de la table `gtb_annotation_effacer`
--

CREATE TABLE IF NOT EXISTS `gtb_annotation_effacer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fkid_groupe` varchar(32) NOT NULL,
  `fkid_annotation` int(11) NOT NULL,
  `fkid_user` varchar(32) NOT NULL,
  `date_effacer` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Alteration de la table `notes`
--

ALTER TABLE `notes` CHANGE `RECORD_ID` `RECORD_ID` BIGINT( 8 ) NOT NULL;

--
-- Alteration de la table `usergroups`
--

ALTER TABLE `usergroups` CHANGE `GDD` `GDD_CREATION` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N';

ALTER TABLE `usergroups` ADD `GDD_AFFICHAGE` VARCHAR( 1 ) NOT NULL DEFAULT 'N';

-- --------------------------------------------------------

--
-- Alteration de la table `gdd_demande`
--

ALTER TABLE `gdd_demande` ADD `fkid_code_rue` VARCHAR( 9 ) NOT NULL AFTER `rue`;

-- --------------------------------------------------------

--
-- Alteration de la table `gdd_elu`
--

ALTER TABLE `gdd_elu` ADD `fkid_user` VARCHAR( 32 ) NOT NULL;

ALTER TABLE `gdd_elu` CHANGE `statut` `statut` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

-- --------------------------------------------------------

--
-- Alteration de la table `gdd_intervention`
--

ALTER TABLE `gdd_intervention`  ADD `date_reponse` DATE NOT NULL AFTER `date_cloture`,  ADD `realisation_cloturer` VARCHAR(1) NOT NULL DEFAULT 'N' AFTER `date_reponse`,  ADD `reponse_cloturer` VARCHAR(1) NOT NULL DEFAULT 'N' AFTER `realisation_cloturer`;

-- --------------------------------------------------------

--
-- Alteration de la table `gdd_intervention`
--
ALTER TABLE `usergroup_content` ADD `PRIMARY_GROUP_GDD` CHAR( 1 ) NOT NULL DEFAULT 'N';
