Advertisement
Guest User

Untitled

a guest
Sep 12th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement