Dave Jarvis' Repositories

--
-- FOREIGN KEYS [DROP]
-- 

ALTER TABLE recipe_book.book_latex DROP CONSTRAINT fk_book_latex_book_snippet;
ALTER TABLE recipe_book.book_snippet DROP CONSTRAINT fk_book_snippet_code_aspect_code;
ALTER TABLE recipe_book.book_snippet_preference DROP CONSTRAINT fk_book_snippet_preference_book_id;
ALTER TABLE recipe_book.book_snippet_preference DROP CONSTRAINT fk_book_snippet_preference_book_snippet_id;
ALTER TABLE recipe_book.book_theme DROP CONSTRAINT fk_book_theme_book_aspect_name;
ALTER TABLE recipe_book.book_theme DROP CONSTRAINT fk_book_theme_book_snippet;
ALTER TABLE recipe_book.book_theme DROP CONSTRAINT fk_book_theme_book_theme_name;

--
-- VIEWS [DROP]
-- 

DROP VIEW recipe_book.book_theme_vw;
DROP VIEW recipe_book.book_snippet_preference_vw;

--
-- book_aspect_name
-- 

DROP TABLE recipe_book.book_aspect_name;

--
-- book_latex
-- 

DROP TABLE recipe_book.book_latex;

--
-- book_snippet
-- 

DROP TABLE recipe_book.book_snippet;

--
-- book_snippet_preference
-- 

DROP TABLE recipe_book.book_snippet_preference;

--
-- book_theme
-- 

DROP TABLE recipe_book.book_theme;

--
-- book_theme_name
-- 

ALTER TABLE recipe_book.book_theme_name
ADD typeset VARCHAR(64) NOT NULL;
COMMENT ON COLUMN recipe_book.book_theme_name.typeset IS 'Name of the file to include for typesetting the theme.';