SHARE
TWEET

Untitled

a guest Sep 12th, 2019 79 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `event` (
  2.   `id` bigint(20) NOT NULL,
  3.   `description` varchar(255) DEFAULT NULL,
  4.   `finish` datetime DEFAULT NULL,
  5.   `start` datetime DEFAULT NULL,
  6.   `title` varchar(255) DEFAULT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  8.  
  9. INSERT INTO `event` (`id`, `description`, `finish`, `start`, `title`) VALUES
  10. (1, 'description1', '2015-09-01 02:00:00', '2019-09-01 01:00:00', 'event1'),
  11. (2, 'description2', '2015-09-02 03:00:00', '2019-09-02 02:00:00', 'event2'),
  12. (3, 'description3', '2015-09-03 02:00:00', '2019-09-03 01:00:00', 'event3'),
  13. (4, 'description4', '2015-09-04 02:00:00', '2019-09-04 01:00:00', 'event4');
  14.  
  15. ALTER TABLE `event`
  16.   ADD PRIMARY KEY (`id`);
  17.  
  18. ALTER TABLE `event`
  19.   MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top