-- Definitions for Pam's book database
-- Bruno Wolff III
-- Started May 28, 2001
-- Last updated August 11, 2001

-- Drop all tables script

drop table item;
drop table editillu;
drop table editauth;
drop table edit;
drop table acce;
drop table colo;
drop table booktopi;
drop table bookgenr;
drop table titl;
drop table book;
drop table topi;
drop table genr;
drop table medi;
drop table illu;
drop table auth;
drop table lang;

drop sequence lang_langcode_seq;
drop sequence auth_authcode_seq;
drop sequence illu_illucode_seq;
drop sequence medi_medicode_seq;
drop sequence genr_genrcode_seq;
drop sequence topi_topicode_seq;
drop sequence titl_titlcode_seq;
drop sequence acce_accecode_seq;
drop sequence colo_colocode_seq;
drop sequence book_bookcode_seq;
drop sequence edit_editcode_seq;
drop sequence item_itemcode_seq;