-- Parse::SQL::Dia      version 0.20                              
-- Documentation        http://search.cpan.org/dist/Parse-Dia-SQL/
-- Environment          Perl 5.014002, /usr/bin/perl              
-- Architecture         i486-linux-gnu-thread-multi-64int         
-- Target Database      postgres                                  
-- Input file           Desktop/database.dia                      
-- Generated at         Sun Oct 28 12:27:02 2012                  
-- Typemap for postgres not found in input file                   

-- get_constraints_drop 
alter table book drop constraint fk_author_id ;

-- get_permissions_drop 

-- get_view_drop

-- get_schema_drop
drop table Author;
drop table book;

-- get_smallpackage_pre_sql 

-- get_schema_create
create table Author (
   id            serial    not null,
   name          varchar           ,
   surname       varchar           ,
   date_of_birth timestamp         ,
   date_of_death timestamp         ,
   pen_name      varchar           ,
   constraint pk_Author primary key (id)
)   ;
create table book (
   isbn      isbn    not null,
   title     varchar         ,
   author_id integer         ,
   constraint pk_book primary key (isbn)
)   ;

-- get_view_create

-- get_permissions_create

-- get_inserts

-- get_smallpackage_post_sql

-- get_associations_create
alter table book add constraint fk_author_id 
    foreign key (author_id)
    references Author (id) ;