Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
18 lines (14 sloc) 289 Bytes
DROP TABLE IF EXISTS authors;
DROP TABLE IF EXISTS books;
CREATE TABLE authors(
id SERIAL PRIMARY KEY,
name VARCHAR,
nationality VARCHAR,
birth_year INTEGER
);
CREATE TABLE books(
id SERIAL PRIMARY KEY,
title VARCHAR,
publication_date INTEGER,
author_id INTEGER
);