samcao@samcao-Lenovo-IdeaPad-Y470:~/caodjango/caossh$ python manage.py sql getssh

System check identified some issues:

WARNINGS:

?: (1_8.W001) The standalone TEMPLATE_* settings were deprecated in Django 1.8 and the TEMPLATES dictionary takes precedence. You must put the values of the following settings into your default TEMPLATES dict: TEMPLATE_DEBUG.

BEGIN;

CREATE TABLE `getssh_publisher` (

    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

    `name` varchar(30) NOT NULL,

    `address` varchar(50) NOT NULL,

    `city` varchar(60) NOT NULL,

    `state_province` varchar(30) NOT NULL,

    `country` varchar(50) NOT NULL,

    `website` varchar(200) NOT NULL

)

;

CREATE TABLE `getssh_author` (

    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

    `first_name` varchar(30) NOT NULL,

    `last_name` varchar(40) NOT NULL,

    `email` varchar(254) NOT NULL

)

;

CREATE TABLE `getssh_book_authors` (

    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

    `book_id` integer NOT NULL,

    `author_id` integer NOT NULL,

    UNIQUE (`book_id`, `author_id`)

)

;

ALTER TABLE `getssh_book_authors` ADD CONSTRAINT `author_id_refs_id_20f26b36` FOREIGN KEY (`author_id`) REFERENCES `getssh_author` (`id`);

CREATE TABLE `getssh_book` (

    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

    `title` varchar(100) NOT NULL,

    `publisher_id` integer NOT NULL,

    `publication_date` date NOT NULL

)

;

ALTER TABLE `getssh_book` ADD CONSTRAINT `publisher_id_refs_id_99765d4d` FOREIGN KEY (`publisher_id`) REFERENCES `getssh_publisher` (`id`);

ALTER TABLE `getssh_book_authors` ADD CONSTRAINT `book_id_refs_id_2cfb1c02` FOREIGN KEY (`book_id`) REFERENCES `getssh_book` (`id`);

COMMIT;

samcao@samcao-Lenovo-IdeaPad-Y470:~/caodjango/caossh$