forked from sqlc-dev/sqlc
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschema.sql
More file actions
20 lines (17 loc) · 690 Bytes
/
schema.sql
File metadata and controls
20 lines (17 loc) · 690 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
CREATE TABLE authors (
author_id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
name text NOT NULL
);
CREATE INDEX authors_name_idx ON authors(name);
CREATE TABLE books (
book_id integer NOT NULL PRIMARY KEY AUTOINCREMENT,
author_id integer NOT NULL,
isbn varchar(255) NOT NULL DEFAULT '' UNIQUE,
book_type text NOT NULL DEFAULT 'FICTION',
title text NOT NULL,
yr integer NOT NULL DEFAULT 2000,
available datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
tag text NOT NULL,
CHECK (book_type = 'FICTION' OR book_type = 'NONFICTION')
);
CREATE INDEX books_title_idx ON books(title, yr);