SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
CREATE SCHEMA recipe_book;
ALTER SCHEMA recipe_book OWNER TO recipe;
SET search_path = recipe_book, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
CREATE TABLE address (
id bigint NOT NULL,
street_1 character varying(64),
street_2 character varying(64),
street_3 character varying(64),
city character varying(64) NOT NULL,
region character varying(64),
country character varying(64) NOT NULL,
code character varying(16)
);
ALTER TABLE recipe_book.address OWNER TO recipe;
COMMENT ON TABLE address IS 'Represents a general address (for a person or publisher).';
COMMENT ON COLUMN address.id IS 'Primary key.';
COMMENT ON COLUMN address.street_1 IS 'First line of the address.';
COMMENT ON COLUMN address.street_2 IS 'Second line of the street.';
COMMENT ON COLUMN address.street_3 IS 'Third line of the street.';
COMMENT ON COLUMN address.city IS 'City name.';
COMMENT ON COLUMN address.region IS 'Region name.';
COMMENT ON COLUMN address.country IS 'Country name.';
COMMENT ON COLUMN address.code IS 'Postal code, zip code (e.g., zip + zip4).';
CREATE SEQUENCE address_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.address_id_seq OWNER TO recipe;
ALTER SEQUENCE address_id_seq OWNED BY address.id;
CREATE TABLE book (
id integer NOT NULL,
label character varying(128) NOT NULL,
created timestamp with time zone DEFAULT now() NOT NULL,
deleted timestamp with time zone,
updated timestamp with time zone
);
ALTER TABLE recipe_book.book OWNER TO recipe;
COMMENT ON TABLE book IS 'Defines the common items to every book.';
COMMENT ON COLUMN book.id IS 'Primary key.';
COMMENT ON COLUMN book.label IS 'Book title.';
COMMENT ON COLUMN book.created IS 'Date the book was created.';
COMMENT ON COLUMN book.deleted IS 'Date the book was (or is to be?) deleted.';
COMMENT ON COLUMN book.updated IS 'Date the book was last updated.';
CREATE TABLE book_account (
id integer NOT NULL,
book_id integer NOT NULL,
account_id integer NOT NULL
);
ALTER TABLE recipe_book.book_account OWNER TO recipe;
COMMENT ON TABLE book_account IS 'Associates a book with an account.';
COMMENT ON COLUMN book_account.id IS 'Primary key.';
COMMENT ON COLUMN book_account.book_id IS 'The book associated with an account.';
COMMENT ON COLUMN book_account.account_id IS 'The account associated with a book.';
CREATE SEQUENCE book_account_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_account_id_seq OWNER TO recipe;
ALTER SEQUENCE book_account_id_seq OWNED BY book_account.id;
CREATE TABLE book_copyright (
id bigint NOT NULL,
book_id bigint NOT NULL,
copyright_id bigint NOT NULL
);
ALTER TABLE recipe_book.book_copyright OWNER TO recipe;
COMMENT ON TABLE book_copyright IS 'Associates copyright information with a book.';
COMMENT ON COLUMN book_copyright.id IS 'Primary key.';
COMMENT ON COLUMN book_copyright.book_id IS 'FK to the book table.';
COMMENT ON COLUMN book_copyright.copyright_id IS 'FK to the copyright table.';
CREATE SEQUENCE book_copyright_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_copyright_id_seq OWNER TO recipe;
ALTER SEQUENCE book_copyright_id_seq OWNED BY book_copyright.id;
CREATE SEQUENCE book_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_id_seq OWNER TO recipe;
ALTER SEQUENCE book_id_seq OWNED BY book.id;
CREATE TABLE book_isbn (
id integer NOT NULL,
book_id integer NOT NULL,
isbn character varying(13) NOT NULL
);
ALTER TABLE recipe_book.book_isbn OWNER TO recipe;
COMMENT ON TABLE book_isbn IS 'ISBN for the given book.';
COMMENT ON COLUMN book_isbn.id IS 'Primary key.';
COMMENT ON COLUMN book_isbn.book_id IS 'Reference to the book that requires an ISBN code.';
COMMENT ON COLUMN book_isbn.isbn IS 'ISBN book number.';
CREATE SEQUENCE book_isbn_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_isbn_id_seq OWNER TO recipe;
ALTER SEQUENCE book_isbn_id_seq OWNED BY book_isbn.id;
CREATE TABLE book_photograph (
id bigint NOT NULL,
book_id bigint NOT NULL,
photograph_id bigint NOT NULL
);
ALTER TABLE recipe_book.book_photograph OWNER TO recipe;
COMMENT ON TABLE book_photograph IS 'Associates photographs with books.';
COMMENT ON COLUMN book_photograph.id IS 'Primary key.';
COMMENT ON COLUMN book_photograph.book_id IS 'References a book.';
COMMENT ON COLUMN book_photograph.photograph_id IS 'References a photograph.';
CREATE SEQUENCE book_photograph_book_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_photograph_book_id_seq OWNER TO recipe;
ALTER SEQUENCE book_photograph_book_id_seq OWNED BY book_photograph.book_id;
CREATE VIEW book_photograph_category_vw AS
SELECT bpc.id, bpc.label, bpc.description FROM recipe.photograph_category bpc WHERE ((bpc.classification)::text = 'RECIPE'::text) ORDER BY bpc.seq;
ALTER TABLE recipe_book.book_photograph_category_vw OWNER TO recipe;
CREATE SEQUENCE book_photograph_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_photograph_id_seq OWNER TO recipe;
ALTER SEQUENCE book_photograph_id_seq OWNED BY book_photograph.id;
CREATE SEQUENCE book_photograph_photograph_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_photograph_photograph_id_seq OWNER TO recipe;
ALTER SEQUENCE book_photograph_photograph_id_seq OWNED BY book_photograph.photograph_id;
CREATE TABLE book_recipe (
id integer NOT NULL,
book_id integer NOT NULL,
recipe_id integer NOT NULL,
seq integer DEFAULT 0 NOT NULL
);
ALTER TABLE recipe_book.book_recipe OWNER TO recipe;
COMMENT ON TABLE book_recipe IS 'Associates a book with a recipe.';
COMMENT ON COLUMN book_recipe.id IS 'Primary key.';
COMMENT ON COLUMN book_recipe.book_id IS 'Reference to the book table.';
COMMENT ON COLUMN book_recipe.recipe_id IS 'Reference to the recipe table.';
COMMENT ON COLUMN book_recipe.seq IS 'Determines the order of recipes in a book.';
CREATE VIEW book_photograph_vw AS
(SELECT rp.id AS photograph_id, rbbr.book_id, rrp.recipe_id, ru.label AS image_url, rp.photograph_category_id, rpc.label AS photograph_category FROM recipe.photograph rp, recipe.url ru, recipe.recipe_photograph rrp, book_recipe rbbr, recipe.photograph_category rpc WHERE (((((rp.id = rrp.photograph_id) AND (rp.url_id = ru.id)) AND (rrp.id = rbbr.recipe_id)) AND (rp.photograph_category_id = rpc.id)) AND ((rpc.classification)::text = 'RECIPE'::text)) UNION ALL SELECT rp.id AS photograph_id, rbbp.book_id, NULL::bigint AS recipe_id, ru.label AS image_url, rp.photograph_category_id, rpc.label AS photograph_category FROM recipe.photograph rp, recipe.url ru, book_photograph rbbp, recipe.photograph_category rpc WHERE ((((rp.id = rbbp.photograph_id) AND (rp.url_id = ru.id)) AND (rp.photograph_category_id = rpc.id)) AND ((rpc.classification)::text = 'BOOK'::text))) UNION ALL SELECT rp.id AS photograph_id, NULL::bigint AS book_id, rrp.recipe_id, ru.label AS image_url, rp.photograph_category_id, rpc.label AS photograph_category FROM recipe.photograph rp, recipe.url ru, recipe.photograph_category rpc, recipe.recipe_photograph rrp WHERE ((((rp.id = rrp.photograph_id) AND (rp.url_id = ru.id)) AND (rp.photograph_category_id = rpc.id)) AND (NOT (EXISTS (SELECT rbbr.recipe_id FROM book_recipe rbbr WHERE (rbbr.recipe_id = rrp.recipe_id)))));
ALTER TABLE recipe_book.book_photograph_vw OWNER TO recipe;
CREATE SEQUENCE book_recipe_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_recipe_id_seq OWNER TO recipe;
ALTER SEQUENCE book_recipe_id_seq OWNED BY book_recipe.id;
CREATE TABLE book_text (
id bigint NOT NULL,
book_id bigint NOT NULL,
book_text_category_id integer NOT NULL,
label character varying(2560)
);
ALTER TABLE recipe_book.book_text OWNER TO recipe;
COMMENT ON TABLE book_text IS 'Contains different book text types: tag overview (chapters), book overview (introduction), recipe overview, and so forth.';
COMMENT ON COLUMN book_text.id IS 'Primary key.';
COMMENT ON COLUMN book_text.book_id IS 'Foreign key to the book table.';
COMMENT ON COLUMN book_text.book_text_category_id IS 'Foreign key to the book_text_category table.';
COMMENT ON COLUMN book_text.label IS '250 words per page times 2 pages is 2500 characters, rounded up to 2560 to account for markup.';
CREATE SEQUENCE book_text_book_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_text_book_id_seq OWNER TO recipe;
ALTER SEQUENCE book_text_book_id_seq OWNED BY book_text.book_id;
CREATE TABLE book_text_category (
id integer NOT NULL,
label character varying(32) NOT NULL,
description character varying(128) NOT NULL
);
ALTER TABLE recipe_book.book_text_category OWNER TO recipe;
COMMENT ON TABLE book_text_category IS 'Lists book text categories.';
COMMENT ON COLUMN book_text_category.id IS 'Primary key.';
COMMENT ON COLUMN book_text_category.label IS 'Description of the category.';
COMMENT ON COLUMN book_text_category.description IS 'Description of how the label is intended to be used.';
CREATE SEQUENCE book_text_category_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_text_category_id_seq OWNER TO recipe;
ALTER SEQUENCE book_text_category_id_seq OWNED BY book_text_category.id;
CREATE SEQUENCE book_text_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_text_id_seq OWNER TO recipe;
ALTER SEQUENCE book_text_id_seq OWNED BY book_text.id;
CREATE TABLE book_theme_name (
id integer NOT NULL,
code character varying(32) NOT NULL,
label character varying NOT NULL,
typeset character varying(64) NOT NULL
);
ALTER TABLE recipe_book.book_theme_name OWNER TO recipe;
COMMENT ON TABLE book_theme_name IS 'Lists all the book theme names (e.g., maps MODERN_SQUARE to "Modern Square").';
COMMENT ON COLUMN book_theme_name.id IS 'Primary key.';
COMMENT ON COLUMN book_theme_name.code IS 'Uniquely identifies the theme.';
COMMENT ON COLUMN book_theme_name.label IS 'Textual description of the book.';
COMMENT ON COLUMN book_theme_name.typeset IS 'Name of the file to include for typesetting the theme.';
CREATE SEQUENCE book_theme_name_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_theme_name_id_seq OWNER TO recipe;
ALTER SEQUENCE book_theme_name_id_seq OWNED BY book_theme_name.id;
CREATE TABLE book_theme_preference (
id integer NOT NULL,
book_id integer NOT NULL,
book_theme_name_id integer NOT NULL
);
ALTER TABLE recipe_book.book_theme_preference OWNER TO recipe;
COMMENT ON TABLE book_theme_preference IS 'Associates a book_them with a book.';
COMMENT ON COLUMN book_theme_preference.id IS 'Primary key.';
COMMENT ON COLUMN book_theme_preference.book_id IS 'Reference to an existing book.';
COMMENT ON COLUMN book_theme_preference.book_theme_name_id IS 'Reference to the theme that should be applied to the book.';
CREATE SEQUENCE book_theme_preference_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.book_theme_preference_id_seq OWNER TO recipe;
ALTER SEQUENCE book_theme_preference_id_seq OWNED BY book_theme_preference.id;
CREATE TABLE copyright (
id bigint NOT NULL,
label character varying(64) NOT NULL,
publisher_id bigint NOT NULL
);
ALTER TABLE recipe_book.copyright OWNER TO recipe;
COMMENT ON TABLE copyright IS 'Contains copyright information for a book.';
COMMENT ON COLUMN copyright.id IS 'Primary key.';
COMMENT ON COLUMN copyright.label IS 'Name of the copyright holder.';
COMMENT ON COLUMN copyright.publisher_id IS 'FK to the publisher table.';
CREATE SEQUENCE copyright_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.copyright_id_seq OWNER TO recipe;
ALTER SEQUENCE copyright_id_seq OWNED BY copyright.id;
CREATE TABLE copyright_license (
id bigint NOT NULL,
label character varying(256) NOT NULL,
copyright_id bigint
);
ALTER TABLE recipe_book.copyright_license OWNER TO recipe;
COMMENT ON TABLE copyright_license IS 'Text for the book''s copyright licensing.';
COMMENT ON COLUMN copyright_license.id IS 'Primary key.';
COMMENT ON COLUMN copyright_license.label IS 'The license text.';
COMMENT ON COLUMN copyright_license.copyright_id IS 'FK to the copyright table.';
CREATE SEQUENCE copyright_license_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.copyright_license_id_seq OWNER TO recipe;
ALTER SEQUENCE copyright_license_id_seq OWNED BY copyright_license.id;
CREATE TABLE copyright_trademark (
id bigint NOT NULL,
copyright_id bigint NOT NULL,
trademark_id bigint NOT NULL,
seq smallint DEFAULT 1 NOT NULL
);
ALTER TABLE recipe_book.copyright_trademark OWNER TO recipe;
COMMENT ON TABLE copyright_trademark IS 'Books can have multiple trademarks in the copyright section.';
COMMENT ON COLUMN copyright_trademark.id IS 'Primary key.';
COMMENT ON COLUMN copyright_trademark.copyright_id IS 'FK to the copyright table.';
COMMENT ON COLUMN copyright_trademark.trademark_id IS 'FK to the trademark table.';
COMMENT ON COLUMN copyright_trademark.seq IS 'Used for ORDER BY clause.';
CREATE SEQUENCE copyright_trademark_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.copyright_trademark_id_seq OWNER TO recipe;
ALTER SEQUENCE copyright_trademark_id_seq OWNED BY copyright_trademark.id;
CREATE TABLE publisher (
id bigint NOT NULL,
label character varying(64),
address_id bigint NOT NULL
);
ALTER TABLE recipe_book.publisher OWNER TO recipe;
COMMENT ON TABLE publisher IS 'Information about the book''s publisher.';
COMMENT ON COLUMN publisher.id IS 'Primary key.';
COMMENT ON COLUMN publisher.label IS 'Name of the book''s publisher (person or company).';
COMMENT ON COLUMN publisher.address_id IS 'FK to the address table.';
CREATE SEQUENCE publisher_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.publisher_id_seq OWNER TO recipe;
ALTER SEQUENCE publisher_id_seq OWNED BY publisher.id;
CREATE TABLE trademark (
id bigint NOT NULL,
label character varying(256)
);
ALTER TABLE recipe_book.trademark OWNER TO recipe;
COMMENT ON TABLE trademark IS 'Contains text for trademark information.';
COMMENT ON COLUMN trademark.id IS 'Primary key.';
COMMENT ON COLUMN trademark.label IS 'Text for trademark information about a book.';
CREATE SEQUENCE trademark_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE recipe_book.trademark_id_seq OWNER TO recipe;
ALTER SEQUENCE trademark_id_seq OWNED BY trademark.id;
ALTER TABLE ONLY address ALTER COLUMN id SET DEFAULT nextval('address_id_seq'::regclass);
ALTER TABLE ONLY book ALTER COLUMN id SET DEFAULT nextval('book_id_seq'::regclass);
ALTER TABLE ONLY book_account ALTER COLUMN id SET DEFAULT nextval('book_account_id_seq'::regclass);
ALTER TABLE ONLY book_copyright ALTER COLUMN id SET DEFAULT nextval('book_copyright_id_seq'::regclass);
ALTER TABLE ONLY book_isbn ALTER COLUMN id SET DEFAULT nextval('book_isbn_id_seq'::regclass);
ALTER TABLE ONLY book_photograph ALTER COLUMN id SET DEFAULT nextval('book_photograph_id_seq'::regclass);
ALTER TABLE ONLY book_photograph ALTER COLUMN book_id SET DEFAULT nextval('book_photograph_book_id_seq'::regclass);
ALTER TABLE ONLY book_photograph ALTER COLUMN photograph_id SET DEFAULT nextval('book_photograph_photograph_id_seq'::regclass);
ALTER TABLE ONLY book_recipe ALTER COLUMN id SET DEFAULT nextval('book_recipe_id_seq'::regclass);
ALTER TABLE ONLY book_text ALTER COLUMN id SET DEFAULT nextval('book_text_id_seq'::regclass);
ALTER TABLE ONLY book_text ALTER COLUMN book_id SET DEFAULT nextval('book_text_book_id_seq'::regclass);
ALTER TABLE ONLY book_text_category ALTER COLUMN id SET DEFAULT nextval('book_text_category_id_seq'::regclass);
ALTER TABLE ONLY book_theme_name ALTER COLUMN id SET DEFAULT nextval('book_theme_name_id_seq'::regclass);
ALTER TABLE ONLY book_theme_preference ALTER COLUMN id SET DEFAULT nextval('book_theme_preference_id_seq'::regclass);
ALTER TABLE ONLY copyright ALTER COLUMN id SET DEFAULT nextval('copyright_id_seq'::regclass);
ALTER TABLE ONLY copyright_license ALTER COLUMN id SET DEFAULT nextval('copyright_license_id_seq'::regclass);
ALTER TABLE ONLY copyright_trademark ALTER COLUMN id SET DEFAULT nextval('copyright_trademark_id_seq'::regclass);
ALTER TABLE ONLY publisher ALTER COLUMN id SET DEFAULT nextval('publisher_id_seq'::regclass);
ALTER TABLE ONLY trademark ALTER COLUMN id SET DEFAULT nextval('trademark_id_seq'::regclass);
INSERT INTO address VALUES (1, NULL, NULL, NULL, 'Victoria', 'BC', 'Canada', NULL);
SELECT pg_catalog.setval('address_id_seq', 1, true);
INSERT INTO book VALUES (42, 'reddit recipes', '2014-01-08 15:34:41.70851-08', NULL, NULL);
INSERT INTO book VALUES (45, 'Fast Entrées', '2014-01-13 02:09:25.680877-08', NULL, NULL);
INSERT INTO book VALUES (46, '10 Second Recipes', '2014-01-13 02:10:39.128234-08', NULL, NULL);
INSERT INTO book VALUES (50, '/r/recipes', '2014-01-16 23:43:54.298633-08', NULL, NULL);
INSERT INTO book VALUES (51, 'reddit recipes', '2014-01-19 19:00:45.419807-08', NULL, NULL);
INSERT INTO book VALUES (56, 'Book Name', '2014-01-30 17:22:37.628966-08', NULL, NULL);
INSERT INTO book VALUES (57, 'Title', '2014-03-12 20:05:29.2483-07', NULL, NULL);
INSERT INTO book VALUES (58, 'Irish Stew', '2014-03-13 23:19:43.782239-07', NULL, NULL);
INSERT INTO book VALUES (59, 'No Cover', '2014-03-18 20:49:42.387743-07', NULL, NULL);
INSERT INTO book VALUES (60, 'Book Name', '2014-03-21 00:14:38.315456-07', NULL, NULL);
INSERT INTO book VALUES (61, 'Under the Weather', '2014-03-21 00:32:41.376485-07', NULL, NULL);
INSERT INTO book VALUES (1, 'Greatest Recipe Book', '2013-05-30 21:16:31.386168-07', NULL, NULL);
INSERT INTO book VALUES (3, 'Dan''s Delicious Desserts', '2013-06-09 14:09:08.637406-07', NULL, NULL);
INSERT INTO book VALUES (4, 'Dave''s First Recipe Book', '2013-07-02 13:41:55.694058-07', NULL, NULL);
INSERT INTO book VALUES (63, 'Sweet Treats', '2014-03-22 02:58:52.76576-07', NULL, NULL);
INSERT INTO book VALUES (64, 'Title', '2014-04-03 15:36:22.508394-07', NULL, NULL);
INSERT INTO book VALUES (7, 'Colin Newell''s Collection', '2013-07-18 19:45:16.128727-07', NULL, NULL);
INSERT INTO book VALUES (8, 'Erica Ehm''s Collection', '2013-07-18 21:10:42.094987-07', NULL, NULL);
INSERT INTO book VALUES (9, 'Dave''s Kitchen Collection', '2013-07-19 00:24:27.992183-07', NULL, NULL);
INSERT INTO book VALUES (65, 'Book Name', '2014-04-04 01:56:34.848417-07', NULL, NULL);
INSERT INTO book VALUES (11, 'Heidi Fink''s Collection', '2013-07-19 00:27:25.668313-07', NULL, NULL);
INSERT INTO book VALUES (12, 'Amy Bronee''s Collection', '2013-07-19 18:04:51.694635-07', NULL, NULL);
INSERT INTO book VALUES (14, 'Christabel Padmore''s Collection', '2013-07-20 12:15:03.716229-07', NULL, NULL);
INSERT INTO book VALUES (16, 'Theresa''s Collection', '2013-07-20 16:56:10.41103-07', NULL, NULL);
INSERT INTO book VALUES (20, 'Theresa''s Delights', '2013-07-20 19:14:42.991871-07', NULL, NULL);
INSERT INTO book VALUES (21, 'Theresa''s Tasty Treats', '2013-07-20 19:18:13.635447-07', NULL, NULL);
INSERT INTO book VALUES (22, 'Book Name', '2013-07-21 15:16:40.255928-07', NULL, NULL);
INSERT INTO book VALUES (23, 'Therea''s Collection', '2013-07-21 15:42:43.783681-07', NULL, NULL);
INSERT INTO book VALUES (24, 'Therea''s Tasteful Treats', '2013-07-21 17:02:30.638481-07', NULL, NULL);
INSERT INTO book VALUES (25, 'Sam''s Rebar Theft', '2013-07-21 21:16:42.864174-07', NULL, NULL);
INSERT INTO book VALUES (26, 'Dan''s Collection', '2013-07-22 12:29:37.384817-07', NULL, NULL);
INSERT INTO book VALUES (27, 'Audrey the Spoonthrift', '2013-07-22 20:34:52.873629-07', NULL, NULL);
INSERT INTO book VALUES (28, 'Kim Fisher''s Collection', '2013-07-23 13:21:21.388277-07', NULL, NULL);
INSERT INTO book VALUES (29, 'Janice Mansfield', '2013-07-23 19:48:07.085977-07', NULL, NULL);
INSERT INTO book VALUES (30, 'Trick or Treats', '2013-08-02 22:52:33.753587-07', NULL, NULL);
INSERT INTO book VALUES (31, 'Dave''s Delicious Desserts', '2013-08-04 17:04:28.438818-07', NULL, NULL);
INSERT INTO book VALUES (34, 'Recipe 4 Living', '2013-09-04 23:59:36.093721-07', NULL, NULL);
INSERT INTO book VALUES (35, 'The Bitten Word', '2013-09-05 21:06:11.915292-07', NULL, NULL);
INSERT INTO book VALUES (36, 'Sweet Treats', '2013-09-24 12:56:51.438157-07', NULL, NULL);
INSERT INTO book VALUES (37, 'Teradici Staff Recipes', '2013-09-24 13:50:43.859962-07', NULL, NULL);
INSERT INTO book VALUES (76, 'Book Name', '2014-04-04 19:20:50.609026-07', NULL, NULL);
INSERT INTO book VALUES (77, 'Book Name', '2014-04-04 19:23:30.434043-07', NULL, NULL);
INSERT INTO book VALUES (78, 'Book Name', '2014-04-04 19:53:01.6774-07', NULL, NULL);
INSERT INTO book_account VALUES (34, 34, 49);
INSERT INTO book_account VALUES (35, 35, 49);
INSERT INTO book_account VALUES (36, 36, 49);
INSERT INTO book_account VALUES (37, 37, 49);
INSERT INTO book_account VALUES (42, 42, 1);
INSERT INTO book_account VALUES (45, 45, 1);
INSERT INTO book_account VALUES (46, 46, 1);
INSERT INTO book_account VALUES (60, 60, 157);
INSERT INTO book_account VALUES (61, 61, 157);
INSERT INTO book_account VALUES (63, 63, 157);
INSERT INTO book_account VALUES (50, 50, 157);
INSERT INTO book_account VALUES (51, 51, 157);
INSERT INTO book_account VALUES (56, 56, 157);
INSERT INTO book_account VALUES (57, 57, 157);
INSERT INTO book_account VALUES (58, 58, 157);
INSERT INTO book_account VALUES (59, 59, 157);
INSERT INTO book_account VALUES (64, 64, 306);
INSERT INTO book_account VALUES (65, 65, 306);
INSERT INTO book_account VALUES (1, 1, 1);
INSERT INTO book_account VALUES (3, 3, 49);
INSERT INTO book_account VALUES (4, 4, 54);
INSERT INTO book_account VALUES (7, 7, 49);
INSERT INTO book_account VALUES (8, 8, 49);
INSERT INTO book_account VALUES (9, 9, 49);
INSERT INTO book_account VALUES (11, 11, 49);
INSERT INTO book_account VALUES (12, 12, 49);
INSERT INTO book_account VALUES (14, 14, 49);
INSERT INTO book_account VALUES (16, 16, 49);
INSERT INTO book_account VALUES (20, 20, 49);
INSERT INTO book_account VALUES (21, 21, 49);
INSERT INTO book_account VALUES (22, 22, 49);
INSERT INTO book_account VALUES (23, 23, 49);
INSERT INTO book_account VALUES (24, 24, 49);
INSERT INTO book_account VALUES (25, 25, 119);
INSERT INTO book_account VALUES (26, 26, 49);
INSERT INTO book_account VALUES (27, 27, 49);
INSERT INTO book_account VALUES (28, 28, 49);
INSERT INTO book_account VALUES (29, 29, 49);
INSERT INTO book_account VALUES (30, 30, 49);
INSERT INTO book_account VALUES (31, 31, 49);
INSERT INTO book_account VALUES (76, 76, 307);
INSERT INTO book_account VALUES (77, 77, 308);
INSERT INTO book_account VALUES (78, 78, 309);
SELECT pg_catalog.setval('book_account_id_seq', 78, true);
INSERT INTO book_copyright VALUES (1, 50, 1);
SELECT pg_catalog.setval('book_copyright_id_seq', 1, true);
SELECT pg_catalog.setval('book_id_seq', 78, true);
SELECT pg_catalog.setval('book_isbn_id_seq', 1, false);
INSERT INTO book_photograph VALUES (2, 21, 21);
INSERT INTO book_photograph VALUES (3, 23, 22);
INSERT INTO book_photograph VALUES (4, 24, 23);
INSERT INTO book_photograph VALUES (5, 7, 25);
INSERT INTO book_photograph VALUES (6, 27, 30);
INSERT INTO book_photograph VALUES (7, 28, 34);
INSERT INTO book_photograph VALUES (8, 22, 36);
INSERT INTO book_photograph VALUES (9, 34, 44);
INSERT INTO book_photograph VALUES (10, 35, 48);
INSERT INTO book_photograph VALUES (11, 36, 50);
INSERT INTO book_photograph VALUES (12, 37, 51);
INSERT INTO book_photograph VALUES (13, 42, 64);
INSERT INTO book_photograph VALUES (14, 50, 92);
INSERT INTO book_photograph VALUES (15, 51, 93);
INSERT INTO book_photograph VALUES (16, 57, 95);
INSERT INTO book_photograph VALUES (17, 59, 103);
SELECT pg_catalog.setval('book_photograph_book_id_seq', 1, false);
SELECT pg_catalog.setval('book_photograph_id_seq', 18, true);
SELECT pg_catalog.setval('book_photograph_photograph_id_seq', 1, false);
INSERT INTO book_recipe VALUES (343, 11, 132, 1);
INSERT INTO book_recipe VALUES (572, 20, 142, 1);
INSERT INTO book_recipe VALUES (573, 20, 144, 2);
INSERT INTO book_recipe VALUES (574, 20, 143, 3);
INSERT INTO book_recipe VALUES (716, 24, 142, 1);
INSERT INTO book_recipe VALUES (717, 24, 144, 2);
INSERT INTO book_recipe VALUES (16, 1, 2, 1);
INSERT INTO book_recipe VALUES (17, 1, 1, 2);
INSERT INTO book_recipe VALUES (718, 24, 143, 3);
INSERT INTO book_recipe VALUES (357, 12, 135, 1);
INSERT INTO book_recipe VALUES (358, 12, 136, 2);
INSERT INTO book_recipe VALUES (359, 12, 138, 3);
INSERT INTO book_recipe VALUES (360, 12, 137, 4);
INSERT INTO book_recipe VALUES (363, 14, 140, 1);
INSERT INTO book_recipe VALUES (364, 14, 141, 2);
INSERT INTO book_recipe VALUES (1155, 34, 183, 1);
INSERT INTO book_recipe VALUES (587, 21, 142, 1);
INSERT INTO book_recipe VALUES (588, 21, 144, 2);
INSERT INTO book_recipe VALUES (589, 21, 143, 3);
INSERT INTO book_recipe VALUES (1156, 34, 182, 2);
INSERT INTO book_recipe VALUES (306, 3, 49, 1);
INSERT INTO book_recipe VALUES (307, 3, 50, 2);
INSERT INTO book_recipe VALUES (308, 3, 51, 3);
INSERT INTO book_recipe VALUES (309, 3, 52, 4);
INSERT INTO book_recipe VALUES (310, 3, 53, 5);
INSERT INTO book_recipe VALUES (311, 3, 54, 6);
INSERT INTO book_recipe VALUES (312, 3, 55, 7);
INSERT INTO book_recipe VALUES (313, 3, 56, 8);
INSERT INTO book_recipe VALUES (314, 3, 63, 9);
INSERT INTO book_recipe VALUES (315, 3, 57, 10);
INSERT INTO book_recipe VALUES (316, 3, 58, 11);
INSERT INTO book_recipe VALUES (723, 7, 145, 1);
INSERT INTO book_recipe VALUES (724, 7, 125, 2);
INSERT INTO book_recipe VALUES (1157, 34, 185, 3);
INSERT INTO book_recipe VALUES (1158, 34, 184, 4);
INSERT INTO book_recipe VALUES (114, 4, 49, 1);
INSERT INTO book_recipe VALUES (115, 4, 50, 2);
INSERT INTO book_recipe VALUES (116, 4, 51, 3);
INSERT INTO book_recipe VALUES (733, 25, 146, 1);
INSERT INTO book_recipe VALUES (4151, 56, 406, 1);
INSERT INTO book_recipe VALUES (736, 26, 148, 1);
INSERT INTO book_recipe VALUES (332, 8, 131, 1);
INSERT INTO book_recipe VALUES (336, 9, 131, 1);
INSERT INTO book_recipe VALUES (7859, 64, 571, 1);
INSERT INTO book_recipe VALUES (4309, 63, 230, 1);
INSERT INTO book_recipe VALUES (4310, 63, 250, 2);
INSERT INTO book_recipe VALUES (117, 4, 52, 4);
INSERT INTO book_recipe VALUES (118, 4, 53, 5);
INSERT INTO book_recipe VALUES (119, 4, 54, 6);
INSERT INTO book_recipe VALUES (120, 4, 55, 7);
INSERT INTO book_recipe VALUES (121, 4, 56, 8);
INSERT INTO book_recipe VALUES (122, 4, 63, 9);
INSERT INTO book_recipe VALUES (123, 4, 61, 10);
INSERT INTO book_recipe VALUES (124, 4, 57, 11);
INSERT INTO book_recipe VALUES (125, 4, 58, 12);
INSERT INTO book_recipe VALUES (1174, 35, 159, 1);
INSERT INTO book_recipe VALUES (1175, 35, 148, 2);
INSERT INTO book_recipe VALUES (1176, 35, 135, 3);
INSERT INTO book_recipe VALUES (1177, 35, 156, 4);
INSERT INTO book_recipe VALUES (4311, 63, 235, 3);
INSERT INTO book_recipe VALUES (4312, 63, 242, 4);
INSERT INTO book_recipe VALUES (4313, 63, 238, 5);
INSERT INTO book_recipe VALUES (4314, 63, 236, 6);
INSERT INTO book_recipe VALUES (337, 9, 132, 2);
INSERT INTO book_recipe VALUES (338, 9, 125, 3);
INSERT INTO book_recipe VALUES (1182, 36, 61, 1);
INSERT INTO book_recipe VALUES (822, 29, 157, 1);
INSERT INTO book_recipe VALUES (823, 29, 158, 2);
INSERT INTO book_recipe VALUES (4315, 63, 244, 7);
INSERT INTO book_recipe VALUES (1353, 46, 221, 1);
INSERT INTO book_recipe VALUES (1354, 46, 223, 2);
INSERT INTO book_recipe VALUES (1186, 37, 61, 1);
INSERT INTO book_recipe VALUES (1187, 22, 148, 1);
INSERT INTO book_recipe VALUES (692, 16, 142, 1);
INSERT INTO book_recipe VALUES (693, 16, 144, 2);
INSERT INTO book_recipe VALUES (694, 16, 143, 3);
INSERT INTO book_recipe VALUES (758, 27, 150, 1);
INSERT INTO book_recipe VALUES (759, 27, 149, 2);
INSERT INTO book_recipe VALUES (760, 27, 151, 3);
INSERT INTO book_recipe VALUES (1188, 22, 135, 2);
INSERT INTO book_recipe VALUES (1189, 22, 156, 3);
INSERT INTO book_recipe VALUES (1190, 22, 183, 4);
INSERT INTO book_recipe VALUES (1191, 22, 171, 5);
INSERT INTO book_recipe VALUES (4316, 63, 234, 8);
INSERT INTO book_recipe VALUES (909, 30, 148, 1);
INSERT INTO book_recipe VALUES (767, 28, 154, 1);
INSERT INTO book_recipe VALUES (768, 28, 153, 2);
INSERT INTO book_recipe VALUES (769, 28, 152, 3);
INSERT INTO book_recipe VALUES (704, 23, 142, 1);
INSERT INTO book_recipe VALUES (705, 23, 144, 2);
INSERT INTO book_recipe VALUES (706, 23, 143, 3);
INSERT INTO book_recipe VALUES (910, 30, 135, 2);
INSERT INTO book_recipe VALUES (911, 30, 156, 3);
INSERT INTO book_recipe VALUES (912, 30, 154, 4);
INSERT INTO book_recipe VALUES (4317, 63, 248, 9);
INSERT INTO book_recipe VALUES (4318, 63, 251, 10);
INSERT INTO book_recipe VALUES (4319, 63, 233, 11);
INSERT INTO book_recipe VALUES (7998, 60, 230, 1);
INSERT INTO book_recipe VALUES (918, 31, 135, 1);
INSERT INTO book_recipe VALUES (919, 31, 150, 2);
INSERT INTO book_recipe VALUES (920, 31, 155, 3);
INSERT INTO book_recipe VALUES (921, 31, 159, 4);
INSERT INTO book_recipe VALUES (7999, 60, 250, 2);
INSERT INTO book_recipe VALUES (8000, 60, 235, 3);
INSERT INTO book_recipe VALUES (8001, 60, 242, 4);
INSERT INTO book_recipe VALUES (8002, 60, 238, 5);
INSERT INTO book_recipe VALUES (8003, 60, 236, 6);
INSERT INTO book_recipe VALUES (8004, 60, 244, 7);
INSERT INTO book_recipe VALUES (8005, 60, 234, 8);
INSERT INTO book_recipe VALUES (8006, 60, 248, 9);
INSERT INTO book_recipe VALUES (8007, 60, 251, 10);
INSERT INTO book_recipe VALUES (8008, 60, 233, 11);
INSERT INTO book_recipe VALUES (8009, 60, 280, 12);
INSERT INTO book_recipe VALUES (8010, 60, 229, 13);
INSERT INTO book_recipe VALUES (8011, 60, 243, 14);
INSERT INTO book_recipe VALUES (8012, 60, 231, 15);
INSERT INTO book_recipe VALUES (8013, 60, 247, 16);
INSERT INTO book_recipe VALUES (8014, 60, 245, 17);
INSERT INTO book_recipe VALUES (8015, 60, 246, 18);
INSERT INTO book_recipe VALUES (8016, 60, 585, 19);
INSERT INTO book_recipe VALUES (8017, 60, 232, 20);
INSERT INTO book_recipe VALUES (8018, 60, 240, 21);
INSERT INTO book_recipe VALUES (1291, 45, 221, 1);
INSERT INTO book_recipe VALUES (1292, 45, 223, 2);
INSERT INTO book_recipe VALUES (8019, 60, 237, 22);
INSERT INTO book_recipe VALUES (8020, 60, 239, 23);
INSERT INTO book_recipe VALUES (8021, 60, 249, 24);
INSERT INTO book_recipe VALUES (8022, 60, 228, 25);
INSERT INTO book_recipe VALUES (7869, 77, 574, 1);
INSERT INTO book_recipe VALUES (1550, 42, 222, 1);
INSERT INTO book_recipe VALUES (1551, 42, 191, 2);
INSERT INTO book_recipe VALUES (1552, 42, 1, 3);
INSERT INTO book_recipe VALUES (1553, 42, 5, 4);
INSERT INTO book_recipe VALUES (7871, 78, 575, 1);
INSERT INTO book_recipe VALUES (1554, 42, 213, 5);
INSERT INTO book_recipe VALUES (1555, 42, 221, 6);
INSERT INTO book_recipe VALUES (8023, 60, 241, 26);
INSERT INTO book_recipe VALUES (7860, 65, 571, 1);
INSERT INTO book_recipe VALUES (7868, 76, 573, 1);
INSERT INTO book_recipe VALUES (7947, 50, 280, 1);
INSERT INTO book_recipe VALUES (7948, 50, 229, 2);
INSERT INTO book_recipe VALUES (2150, 51, 229, 1);
INSERT INTO book_recipe VALUES (2151, 51, 243, 2);
INSERT INTO book_recipe VALUES (2152, 51, 231, 3);
INSERT INTO book_recipe VALUES (7949, 50, 228, 3);
INSERT INTO book_recipe VALUES (7950, 50, 230, 4);
INSERT INTO book_recipe VALUES (7951, 50, 231, 5);
INSERT INTO book_recipe VALUES (7952, 50, 232, 6);
INSERT INTO book_recipe VALUES (7953, 50, 233, 7);
INSERT INTO book_recipe VALUES (7954, 50, 234, 8);
INSERT INTO book_recipe VALUES (7955, 50, 235, 9);
INSERT INTO book_recipe VALUES (7956, 50, 236, 10);
INSERT INTO book_recipe VALUES (7957, 50, 237, 11);
INSERT INTO book_recipe VALUES (7958, 50, 238, 12);
INSERT INTO book_recipe VALUES (7959, 50, 239, 13);
INSERT INTO book_recipe VALUES (7960, 50, 240, 14);
INSERT INTO book_recipe VALUES (4150, 59, 251, 1);
INSERT INTO book_recipe VALUES (7961, 50, 241, 15);
INSERT INTO book_recipe VALUES (7962, 50, 242, 16);
INSERT INTO book_recipe VALUES (7963, 50, 243, 17);
INSERT INTO book_recipe VALUES (7964, 50, 244, 18);
INSERT INTO book_recipe VALUES (7965, 50, 245, 19);
INSERT INTO book_recipe VALUES (7966, 50, 246, 20);
INSERT INTO book_recipe VALUES (7967, 50, 247, 21);
INSERT INTO book_recipe VALUES (7968, 50, 248, 22);
INSERT INTO book_recipe VALUES (7969, 50, 249, 23);
INSERT INTO book_recipe VALUES (3889, 58, 230, 1);
INSERT INTO book_recipe VALUES (3890, 58, 250, 2);
INSERT INTO book_recipe VALUES (3891, 58, 235, 3);
INSERT INTO book_recipe VALUES (3892, 58, 242, 4);
INSERT INTO book_recipe VALUES (3893, 58, 238, 5);
INSERT INTO book_recipe VALUES (3894, 58, 273, 6);
INSERT INTO book_recipe VALUES (7970, 50, 250, 24);
INSERT INTO book_recipe VALUES (7971, 50, 251, 25);
INSERT INTO book_recipe VALUES (4179, 61, 487, 1);
INSERT INTO book_recipe VALUES (3841, 57, 230, 1);
INSERT INTO book_recipe VALUES (3842, 57, 250, 2);
INSERT INTO book_recipe VALUES (3843, 57, 235, 3);
INSERT INTO book_recipe VALUES (3844, 57, 242, 4);
INSERT INTO book_recipe VALUES (3845, 57, 238, 5);
INSERT INTO book_recipe VALUES (3846, 57, 236, 6);
INSERT INTO book_recipe VALUES (3847, 57, 244, 7);
INSERT INTO book_recipe VALUES (3848, 57, 234, 8);
INSERT INTO book_recipe VALUES (3849, 57, 248, 9);
INSERT INTO book_recipe VALUES (3850, 57, 251, 10);
INSERT INTO book_recipe VALUES (3851, 57, 233, 11);
INSERT INTO book_recipe VALUES (3852, 57, 229, 12);
INSERT INTO book_recipe VALUES (3853, 57, 243, 13);
INSERT INTO book_recipe VALUES (3854, 57, 231, 14);
INSERT INTO book_recipe VALUES (3855, 57, 247, 15);
INSERT INTO book_recipe VALUES (3856, 57, 245, 16);
INSERT INTO book_recipe VALUES (3857, 57, 246, 17);
INSERT INTO book_recipe VALUES (3858, 57, 232, 18);
INSERT INTO book_recipe VALUES (3859, 57, 240, 19);
INSERT INTO book_recipe VALUES (3860, 57, 237, 20);
INSERT INTO book_recipe VALUES (3861, 57, 239, 21);
INSERT INTO book_recipe VALUES (3862, 57, 249, 22);
INSERT INTO book_recipe VALUES (3863, 57, 228, 23);
INSERT INTO book_recipe VALUES (3864, 57, 241, 24);
SELECT pg_catalog.setval('book_recipe_id_seq', 8023, true);
SELECT pg_catalog.setval('book_text_book_id_seq', 1, false);
INSERT INTO book_text_category VALUES (3, 'recipe', 'Recipe overview, usually to introduce a recipe.');
INSERT INTO book_text_category VALUES (1, 'tag', 'Chapter overview, usually associated with a recipe tag (section).');
INSERT INTO book_text_category VALUES (2, 'book', 'Book overview, usually a book''s opening content.');
SELECT pg_catalog.setval('book_text_category_id_seq', 5, true);
SELECT pg_catalog.setval('book_text_id_seq', 1, false);
INSERT INTO book_theme_name VALUES (1, 'MODERN_SQUARE', 'Modern Square', 'modern-square.tex');
INSERT INTO book_theme_name VALUES (2, 'MODERN_CIRCLE', 'Modern Circle', 'modern-circle.tex');
INSERT INTO book_theme_name VALUES (6, 'SVEDISH_SIMPLICITY', 'Svedish Simplicity', 'svedish.tex');
SELECT pg_catalog.setval('book_theme_name_id_seq', 6, true);
SELECT pg_catalog.setval('book_theme_preference_id_seq', 1, false);
INSERT INTO copyright VALUES (1, 'White Magic Software, Ltd', 1);
SELECT pg_catalog.setval('copyright_id_seq', 1, true);
INSERT INTO copyright_license VALUES (2, 'This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.', 1);
SELECT pg_catalog.setval('copyright_license_id_seq', 2, true);
INSERT INTO copyright_trademark VALUES (2, 1, 1, 1);
INSERT INTO copyright_trademark VALUES (3, 1, 2, 2);
SELECT pg_catalog.setval('copyright_trademark_id_seq', 3, true);
INSERT INTO publisher VALUES (1, 'White Magic Software, Ltd.', 1);
SELECT pg_catalog.setval('publisher_id_seq', 1, true);
INSERT INTO trademark VALUES (1, 'All brand names, product names, or trademarks belong to their respective holders.');
INSERT INTO trademark VALUES (2, 'reddit and the reddit Alien logo, trademark and trade dress are registered trademarks owned by reddit Inc., and are used under license.');
SELECT pg_catalog.setval('trademark_id_seq', 2, true);
ALTER TABLE ONLY address
ADD CONSTRAINT pk_address PRIMARY KEY (id);
ALTER TABLE ONLY book
ADD CONSTRAINT pk_book PRIMARY KEY (id);
ALTER TABLE ONLY book_account
ADD CONSTRAINT pk_book_account PRIMARY KEY (id);
ALTER TABLE ONLY book_copyright
ADD CONSTRAINT pk_book_copyright PRIMARY KEY (id);
ALTER TABLE ONLY book_photograph
ADD CONSTRAINT pk_book_photograph PRIMARY KEY (id);
ALTER TABLE ONLY book_recipe
ADD CONSTRAINT pk_book_recipe PRIMARY KEY (id);
ALTER TABLE ONLY book_text
ADD CONSTRAINT pk_book_text PRIMARY KEY (id);
ALTER TABLE ONLY book_text_category
ADD CONSTRAINT pk_book_text_category PRIMARY KEY (id);
ALTER TABLE ONLY book_theme_name
ADD CONSTRAINT pk_book_theme_name PRIMARY KEY (id);
ALTER TABLE ONLY book_theme_preference
ADD CONSTRAINT pk_book_theme_preference PRIMARY KEY (id);
ALTER TABLE ONLY copyright
ADD CONSTRAINT pk_copyright PRIMARY KEY (id);
ALTER TABLE ONLY copyright_license
ADD CONSTRAINT pk_copyright_license PRIMARY KEY (id);
ALTER TABLE ONLY copyright_trademark
ADD CONSTRAINT pk_copyright_trademark PRIMARY KEY (id);
ALTER TABLE ONLY publisher
ADD CONSTRAINT pk_publisher PRIMARY KEY (id);
ALTER TABLE ONLY trademark
ADD CONSTRAINT pk_trademark PRIMARY KEY (id);
ALTER TABLE ONLY book_theme_name
ADD CONSTRAINT uk_book_theme_name_code UNIQUE (code);
ALTER TABLE ONLY book_theme_preference
ADD CONSTRAINT uk_book_theme_preference_book UNIQUE (book_id, book_theme_name_id);
CREATE INDEX idx_book_account ON book_account USING btree (book_id);
CREATE INDEX idx_book_account_0 ON book_account USING btree (account_id);
CREATE INDEX idx_book_recipe ON book_recipe USING btree (recipe_id);
CREATE INDEX idx_book_recipe_0 ON book_recipe USING btree (book_id);
ALTER TABLE ONLY book_account
ADD CONSTRAINT fk_book_account_account_id FOREIGN KEY (account_id) REFERENCES recipe.account(id) ON DELETE CASCADE;
ALTER TABLE ONLY book_account
ADD CONSTRAINT fk_book_account_book_id FOREIGN KEY (book_id) REFERENCES book(id) ON DELETE CASCADE;
ALTER TABLE ONLY book_copyright
ADD CONSTRAINT fk_book_copyright_book FOREIGN KEY (book_id) REFERENCES book(id);
ALTER TABLE ONLY book_copyright
ADD CONSTRAINT fk_book_copyright_copyright FOREIGN KEY (copyright_id) REFERENCES copyright(id);
ALTER TABLE ONLY book_photograph
ADD CONSTRAINT fk_book_photograph_book_id FOREIGN KEY (book_id) REFERENCES book(id);
ALTER TABLE ONLY book_photograph
ADD CONSTRAINT fk_book_photograph_photograph_id FOREIGN KEY (photograph_id) REFERENCES recipe.photograph(id);
ALTER TABLE ONLY book_recipe
ADD CONSTRAINT fk_book_recipe_book_id FOREIGN KEY (book_id) REFERENCES book(id) ON DELETE CASCADE;
ALTER TABLE ONLY book_recipe
ADD CONSTRAINT fk_book_recipe_recipe_id FOREIGN KEY (recipe_id) REFERENCES recipe.recipe(id) ON DELETE CASCADE;
ALTER TABLE ONLY book_text
ADD CONSTRAINT fk_book_text_book_text_category_id FOREIGN KEY (book_text_category_id) REFERENCES book_text_category(id);
ALTER TABLE ONLY book_theme_preference
ADD CONSTRAINT fk_book_theme_preference_book FOREIGN KEY (book_id) REFERENCES book(id);
ALTER TABLE ONLY book_theme_preference
ADD CONSTRAINT fk_book_theme_preference_book_theme_name_id FOREIGN KEY (book_theme_name_id) REFERENCES book_theme_name(id);
ALTER TABLE ONLY copyright_license
ADD CONSTRAINT fk_copyright_license_copyright FOREIGN KEY (copyright_id) REFERENCES copyright(id);
ALTER TABLE ONLY copyright
ADD CONSTRAINT fk_copyright_publisher FOREIGN KEY (publisher_id) REFERENCES publisher(id);
ALTER TABLE ONLY copyright_trademark
ADD CONSTRAINT fk_copyright_trademark_copyright FOREIGN KEY (copyright_id) REFERENCES copyright(id);
ALTER TABLE ONLY copyright_trademark
ADD CONSTRAINT fk_copyright_trademark_trademark FOREIGN KEY (trademark_id) REFERENCES trademark(id);
ALTER TABLE ONLY publisher
ADD CONSTRAINT fk_publisher_address FOREIGN KEY (address_id) REFERENCES address(id);