1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
CREATETABLEIFNOTEXISTS `cal_my_calendrier` (
`ID` mediumint(255) unsignedNOTNULLAUTO_INCREMENT,
`titre`varchar(255)NOTNULL,
PRIMARYKEY(`ID`)
) ENGINE=InnoDB DEFAULTCHARSET=latin1 AUTO_INCREMENT=4 ;
INSERTINTO`cal_my_calendrier` (`ID`, `titre`)VALUES
(1,'Voiture_ clio1'),
(2,'Voiture_ clio2'),
(3,'Voiture_ clio3');
CREATETABLEIFNOTEXISTS `cal_my_events` (
`Id_event` mediumint(255) unsignedNOTNULLAUTO_INCREMENT,
`calendrier` mediumint(255) unsignedDEFAULTNULL,
`titre`varchar(255)DEFAULTNULL,
`date_debut`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP,
`date_fin` datetimeDEFAULTNULL,
PRIMARYKEY(`Id_event`)
) ENGINE=InnoDB DEFAULTCHARSET=latin1 AUTO_INCREMENT=6 ;
INSERTINTO`cal_my_events` (`Id_event`, `calendrier`, `all_day`, `date_debut`, `date_fin`)VALUES
(1, 1, 0,'2013-05-08 03:00:00','2013-05-08 12:00:00'),
(2, 1, 0,'2013-05-09 03:00:00','2013-05-09 08:00:00'),
(3, 2, 0,'2013-05-08 06:00:00','2013-05-08 18:00:00'),
(4, 3, 0,'2013-05-05 06:00:00','2013-05-10 18:00:00'),
(5, 2, 0,'2013-05-10 08:00:00','2013-05-10 10:00:00'); |
Partager