ALTER TABLE `events` ADD `registration_status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `enabled`;

CREATE TABLE `galleries_event` (
  `id` int(11) NOT NULL,
  `events` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `insertAt` datetime NOT NULL,
  `isEnabled` tinyint(1) NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


ALTER TABLE `galleries_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_G89R7RN82FF40061` (`events`);

--
-- AUTO_INCREMENT pour la table `galleries_event`
--
ALTER TABLE `galleries_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Contraintes pour la table `galleries_event`
--
ALTER TABLE `galleries_event`
  ADD CONSTRAINT `FK_G89R7RN82FF40061` FOREIGN KEY (`events`) REFERENCES `events` (`id`);



ALTER TABLE `offices`
ADD `tel` INT(50) NULL AFTER `cv`,
ADD `email` VARCHAR(50) NULL AFTER `tel`,
ADD `bio` LONGTEXT NULL AFTER `email`,
ADD `company` VARCHAR(250) NULL AFTER `bio`,
ADD `sector` VARCHAR(250) NULL AFTER `company`;


CREATE TABLE IF NOT EXISTS `presidents` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `surname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tel` int(100) NOT NULL,
  `fax` int(100) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `insertAt` datetime NOT NULL,
  `updateAt` datetime NOT NULL,
  `lang_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `logs_be` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `users_id` int(100) DEFAULT NULL,
  `log` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `action_table` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action_id` int(100) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `lang_id` int(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


ALTER TABLE `sliders` ADD `link` VARCHAR(255) NULL AFTER `description`;


CREATE TABLE IF NOT EXISTS `article_adherent` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `user_id` int(100) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `insertAt` datetime NOT NULL,
  `updateAt` datetime NOT NULL,
  `lang_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `news_letter_front` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `insertAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `users_type` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `surname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `organisation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  `insertAt` datetime NOT NULL,
  `updateAt` datetime DEFAULT NULL,
  `lang_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;