CREATE TABLE `authors` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `first_name` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci', `last_name` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci', `email` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci', `birthdate` DATE NOT NULL, `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `email` (`email`) ) COLLATE='utf8_unicode_ci' ENGINE=InnoDB; CREATE TABLE `posts` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `author_id` INT(11) NOT NULL, `title` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci', `description` VARCHAR(500) NOT NULL COLLATE 'utf8_unicode_ci', `content` TEXT NOT NULL COLLATE 'utf8_unicode_ci', `date` DATE NOT NULL, PRIMARY KEY (`id`) ) COLLATE='utf8_unicode_ci' ENGINE=InnoDB;