1drop table persons;
2CREATE TABLE persons (
3	id int NOT NULL,
4	name varchar(255) NOT NULL,
5	surname varchar(255) NOT NULL,
6	password varchar(64)
7);
8
9drop table institutes;
10CREATE TABLE institutes (
11	id int NOT NULL,
12	name varchar(255)
13);
14
15drop table documents;
16CREATE TABLE documents (
17	id int NOT NULL,
18	title varchar(255) NOT NULL,
19	abstract varchar(255)
20);
21
22drop table authors_docs;
23CREATE TABLE authors_docs (
24	pers_id int NOT NULL,
25	doc_id int NOT NULL
26);
27
28drop table phones;
29CREATE TABLE phones (
30	id int NOT NULL ,
31	phone varchar(255) NOT NULL ,
32	pers_id int NOT NULL 
33);
34
35drop table referrals;
36CREATE TABLE referrals (
37	id int NOT NULL,
38	name varchar(255) NOT NULL,
39	url varchar(255) NOT NULL
40);
41
42
43
44ALTER TABLE authors_docs  ADD 
45	CONSTRAINT PK_authors_docs PRIMARY KEY  
46	(
47		pers_id,
48		doc_id
49	);
50
51ALTER TABLE documents  ADD 
52	CONSTRAINT PK_documents PRIMARY KEY  
53	(
54		id
55	); 
56
57ALTER TABLE institutes  ADD 
58	CONSTRAINT PK_institutes PRIMARY KEY  
59	(
60		id
61	);  
62
63
64ALTER TABLE persons  ADD 
65	CONSTRAINT PK_persons PRIMARY KEY  
66	(
67		id
68	); 
69
70ALTER TABLE phones  ADD 
71	CONSTRAINT PK_phones PRIMARY KEY  
72	(
73		id
74	); 
75
76