gistfile1.sql

begin transaction;
                  
create table "user" (
    id serial not null
        constraint pk_user primary key,
    password bytea null,               
    created timestamp                  
);                                     
                                       
create table "user_email" (            
    id serial not null                 
        constraint pk_user_email primary key, 
    user_id integer not null                  
        constraint "fk_user" references "user" ( id ),
    email varchar(255) not null,                                              
    primary boolean                                                           
);                                                                            
                                                                                                                                                      │
commit transaction;