forked from andey-robins/bookshop-go
-
Notifications
You must be signed in to change notification settings - Fork 0
/
init.sql
27 lines (24 loc) · 1.04 KB
/
init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CREATE TABLE Books (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
author TEXT NOT NULL,
price REAL NOT NULL
);
CREATE TABLE Customers (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
shippingAddress TEXT NOT NULL,
accountBalance REAL
);
-- SQLITE has no boolean type, 1 is true, 0 false
CREATE TABLE PurchaseOrders (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
bookId INTEGER NOT NULL REFERENCES Books(id),
customerId INTEGER NOT NULL REFERENCES Customers(id),
shipped INTEGER NOT NULL
);
INSERT INTO Books (title, author, price) VALUES ('The Hitchhikers Guide to the Galaxy', 'Douglas Adams', 12.99);
INSERT INTO Books (title, author, price) VALUES ('Dune', 'Frank Herbert', 9.99);
INSERT INTO Books (title, author, price) VALUES ('The Left Hand of Darkness', 'Ursula K. Le Guin', 8.99);
INSERT INTO Books (title, author, price) VALUES ('Foundation', 'Isaac Asimov', 7.99);
INSERT INTO Books (title, author, price) VALUES ('The Player of Games', 'Iain M. Banks', 6.99);