--
-- This SQL script generated on Sat Apr 02 2005 at 12:30:05.155
--

----------------------------------------------------------------------
-- Entity: Author
-- A book author - Simple entity with no relationships.
----------------------------------------------------------------------

drop table author;

create table author (
    author_id integer not null,
    name varchar(80),
    pen_name varchar(80),
    constraint pk_author primary key (author_id)
);

grant all on author to public;