create table person(
      pnr int,
      name nchar varying(50),
      surname nchar varying(50),
   primary key(pnr));

create table person_address(
      address_id int default next_value of address_id_seq,
      pnr int,
      phone nchar(10),
      zipcode nchar(10),
      address nchar varying(100),
      city nchar varying(50),
   primary key(address_id),
   foreign key(pnr) references person(pnr));

create table audit(
      logts timestamp,
      action nchar varying(50));

create statement select_persons
   select pnr, name, surname from person;
create statement select_address
   select address_id, phone, zipcode, address, city from person_address
   where pnr=:pnr_value;
create statement insert_audit
   insert into audit(logts, action)
   values(current_timestamp, :action_value);
create statement select_audit
   select logts, action from audit;
create statement clear_audit
   delete from audit;
create statement insert_person
   insert into person(pnr, name, surname)
   values(:pnr, :name, :surname);
create statement insert_address
   insert into person_address(pnr, phone, zipcode, address, city)
   values(:pnr, :phone, :zipcode, :address, :city);

read 'mobile.sql';