Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `event` (
- `id` bigint(20) NOT NULL,
- `description` varchar(255) DEFAULT NULL,
- `finish` datetime DEFAULT NULL,
- `start` datetime DEFAULT NULL,
- `title` varchar(255) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `event` (`id`, `description`, `finish`, `start`, `title`) VALUES
- (1, 'description1', '2015-09-01 02:00:00', '2019-09-01 01:00:00', 'event1'),
- (2, 'description2', '2015-09-02 03:00:00', '2019-09-02 02:00:00', 'event2'),
- (3, 'description3', '2015-09-03 02:00:00', '2019-09-03 01:00:00', 'event3'),
- (4, 'description4', '2015-09-04 02:00:00', '2019-09-04 01:00:00', 'event4');
- ALTER TABLE `event`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `event`
- MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement