[sql] Cc
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
- CREATE TABLE IF NOT EXISTS `images` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `title` text NOT NULL,
- `description` text NOT NULL,
- `path` text NOT NULL,
- `uploaded_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- INSERT INTO `images` (`id`, `title`, `description`, `path`, `uploaded_date`) VALUES
- (1, 'Abandoned Building', '', 'images/abandoned-building.jpg', '2019-07-16 20:09:26'),
- (2, 'Beach', 'Hot summer day at the beach.', 'images/beach.jpg', '2019-07-16 20:10:05'),
- (3, 'City', 'A view down at the city.', 'images/city.jpg', '2019-07-16 20:10:45'),
- (4, 'Mountain', '', 'images/mountain.jpg', '2019-07-16 20:11:27'),
- (5, 'Road', 'Going down the only road I''ve even known.', 'images/road.jpg', '2019-07-16 20:12:00'),
- (6, 'Stars', 'A wonderful view of the night sky.', 'images/stars.jpg', '2019-07-16 20:12:39');
Editor
You can edit this paste and save as new: