-- 

-- @author Joel Aufrecht (joel@aufrecht.org)
-- @creation-date 2004-02-01
-- @cvs-id $Id: vocabulary-tables-drop.sql,v 1.1 2004/02/23 23:00:07 joela Exp $
--


select content_type__drop_type(
    'vocab_sentence',
    't',
    't'
);

drop table vocab_phonetic_example;
drop table vocab_phonetic;
drop table vocab_definition;

drop function vocab_word__name (integer);
drop function vocab_word__new(
    integer,     -- id
    integer,     -- package_id
    varchar,     -- word
    varchar,     -- locale
    varchar,     -- ipa_phonetic
    varchar,     -- local_phonetic
    timestamptz, -- entry_date
    integer,     -- creation_user
    varchar      -- creation_ip
);
drop function vocab_word__delete (integer);

drop table vocab_word;
select acs_object_type__drop_type ('vocab_word', true);