-- sample database

CREATE DATABASE sample_test CHARACTER SET UTF8;

use sample_test;

-- books table

CREATE TABLE IF NOT EXISTS `books` (
`id` INT(11) PRIMARY KEY AUTO_INCREMENT,
`title` VARCHAR(100),
`author` VARCHAR(50)
) DEFAULT CHARSET=utf8;