1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| -- Structure de la table `calendar_event`
--
DROP TABLE IF EXISTS `calendar_event`;
CREATE TABLE IF NOT EXISTS `calendar_event` (
`event_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`event_date` date NOT NULL,
`event_time` time NOT NULL,
`event_name` varchar(100) NOT NULL,
`event_comment` text NOT NULL,
`event_allday` tinyint(1) NOT NULL,
PRIMARY KEY (`event_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1695 DEFAULT CHARSET=latin1;
--
-- Déchargement des données de la table `calendar_event`
--
INSERT INTO `calendar_event` (`event_id`, `event_date`, `event_time`, `event_name`, `event_comment`, `event_allday`) VALUES
(1693, '2018-03-21', '00:00:00', 'bb', 'bb', 0),
(1694, '2018-03-01', '00:00:00', 'ww', 'ww', 0);
COMMIT; |
Partager