HVtFSeii

1CREATE DATABASE IF NOT EXISTS `example_db`
2USE `example_db`;
3
4CREATE TABLE IF NOT EXISTS `authors` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `image` char(255) NOT NULL,
7  `name` char(30) NOT NULL,
8  `surname` char(30) NOT NULL,
9  `bio` text NOT NULL,
10  KEY `id` (`id`)
11) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
12
13INSERT INTO `authors` (`id`, `image`, `name`, `surname`, `bio`) VALUES
14	(1, 'img/authors/george-orwell.jpg', 'George', 'Orwell', 'Example author 1'),
15	(2, 'img/authors/william-shakespeare.jpg', 'William', 'Shakespeare', 'Example author 2'),
16	(3, 'img/authors/jk-rowling.jpg', 'Joanne', 'Rowling', 'Example author 3'),
17	(4, 'img/authors/lewis-carroll.jpg', 'Lewis', 'Carroll', 'Example author 4');