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