1drop table if exists 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 if exists institutes;
10CREATE TABLE institutes (
11	id int NOT NULL,
12	name varchar(255)
13);
14
15drop table if exists documents;
16CREATE TABLE documents (
17	id int NOT NULL,
18	title varchar(255) NOT NULL,
19	abstract varchar(255)
20);
21
22drop table if exists authors_docs;
23CREATE TABLE authors_docs (
24	pers_id int NOT NULL,
25	doc_id int NOT NULL
26);
27
28drop table if exists 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 if exists certs;
36CREATE TABLE certs (
37	id int NOT NULL ,
38	cert LONGBLOB NOT NULL,
39	pers_id int NOT NULL 
40);
41
42ALTER TABLE authors_docs  ADD 
43	CONSTRAINT PK_authors_docs PRIMARY KEY  
44	(
45		pers_id,
46		doc_id
47	);
48
49ALTER TABLE documents  ADD 
50	CONSTRAINT PK_documents PRIMARY KEY  
51	(
52		id
53	); 
54
55ALTER TABLE institutes  ADD 
56	CONSTRAINT PK_institutes PRIMARY KEY  
57	(
58		id
59	);  
60
61
62ALTER TABLE persons  ADD 
63	CONSTRAINT PK_persons PRIMARY KEY  
64	(
65		id
66	); 
67
68ALTER TABLE phones  ADD 
69	CONSTRAINT PK_phones PRIMARY KEY  
70	(
71		id
72	); 
73
74ALTER TABLE certs  ADD 
75	CONSTRAINT PK_certs PRIMARY KEY  
76	(
77		id
78	); 
79
80drop table if exists referrals;
81CREATE TABLE referrals (
82	id int NOT NULL,
83	name varchar(255) NOT NULL,
84	url varchar(255) NOT NULL
85);
86
87