create table location (
        location_id    serial not null primary key,
        location_name   text not null
);