kQdsJ7rr

1CREATE DATABASE IF NOT EXISTS `php-jquery_example`
2  DEFAULT CHARACTER SET utf8
3  COLLATE utf8_unicode_ci;
4
5CREATE TABLE IF NOT EXISTS `php-jquery_example`.`events` (
6  `event_id` INT(11) NOT NULL AUTO_INCREMENT,
7  `event_title` VARCHAR(80) DEFAULT NULL,
8  `event_desc` TEXT,
9  `event_start` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
10  `event_end` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
11  PRIMARY KEY (`event_id`),
12  INDEX (`event_start`)
13) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
14
15INSERT INTO `php-jquery_example`.`events`
16  (`event_title`, `event_desc`, `event_start`, `event_end`) VALUES
17  ('New Year's Day', 'Happy New Year!',
18    '2020-01-01 00:00:00', '2020-01-01 23:59:59'),
19  ('Last Day of January', 'Last day of the month! Yay!',
20    '2020-01-31 00:00:00', '2020-01-31 23:59:59');