begin;

create schema front;
create schema back;

alter database bugreport set search_path to front,back,public;

create table back.some_table (id serial primary key);
create view front.some_table as select * from back.some_table;

create table public.another (id serial primary key);
create table back.another (id serial primary key);
create table front.another (id serial primary key);

commit;
