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