php-jquery_example sql

CREATE DATABASE IF NOT EXISTS `php-jquery_example`
  DEFAULT CHARACTER SET utf8
  COLLATE utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `php-jquery_example`.`events` (
  `event_id` INT(11) NOT NULL AUTO_INCREMENT,
  `event_title` VARCHAR(80) DEFAULT NULL,
  `event_desc` TEXT,
  `event_start` TIMESTAMP NOT NULL DEFAULT '2020-01-01 23:59:59',
  `event_end` TIMESTAMP NOT NULL DEFAULT '2020-01-01 23:59:59',
  PRIMARY KEY (`event_id`),
  INDEX (`event_start`)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;

INSERT INTO `php-jquery_example`.`events`
  (`event_title`, `event_desc`, `event_start`, `event_end`) VALUES
  ('New Year's Day', 'Happy New Year!',
    '2020-01-01 00:00:00', '2020-01-01 23:59:59'),
  ('Last Day of January', 'Last day of the month! Yay!',
    '2020-01-31 00:00:00', '2020-01-31 23:59:59');