2 drop sequence persons_id_seq;
4 id serial not null primary key,
5 name varchar(255) not null,
6 surname varchar(255) not null,
10 drop table institutes;
11 drop sequence institutes_id_seq;
12 create table institutes (
13 id serial not null primary key,
18 drop sequence documents_id_seq;
19 create table documents (
20 id serial not null primary key,
21 title varchar(255) not null,
25 drop table authors_docs;
26 create table authors_docs (
29 primary key ( pers_id, doc_id )
33 drop sequence phones_id_seq;
35 id serial not null primary key,
36 phone varchar(255) not null ,
41 drop sequence certs_id_seq;
43 id int not null primary key,
49 drop sequence referrals_id_seq;
50 create table referrals (
51 id serial not null primary key,
52 name varchar(255) not null,
53 url varchar(255) not null