1CREATE TABLE persons ( 2 id int NOT NULL primary key, 3 name varchar(255) NOT NULL, 4 name_u varchar(255), 5 title varchar(255), 6 title_U varchar(255), 7 organization varchar(255) 8) 9unique hash on (id) pages=100; 10create index personsx1 on persons(title_U); 11create index personsx2 on persons(name_u); 12 13CREATE TABLE institutes ( 14 id int NOT NULL primary key, 15 name varchar(255) 16) 17unique hash on (id) pages=100; 18 19CREATE TABLE documents ( 20 id int NOT NULL primary key, 21 title varchar(255) NOT NULL, 22 abstract varchar(255) 23) 24unique hash on (id) pages=100; 25 26CREATE TABLE authors_docs ( 27 pers_id int NOT NULL, 28 doc_id int NOT NULL, 29 PRIMARY KEY 30 ( 31 pers_id, 32 doc_id 33 ) 34) unique hash on (pers_id, doc_id) pages=100; 35 36CREATE TABLE phones ( 37 id int NOT NULL primary key, 38 phone varchar(255) NOT NULL , 39 pers_id int NOT NULL 40) 41unique hash on (id) pages=100; 42 43