Home | History | Annotate | Line # | Download | only in timesten 
      1 CREATE 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 ) 
      9 unique hash on (id) pages=100;
     10 create index personsx1 on persons(title_U);
     11 create index personsx2 on persons(name_u);
     12 
     13 CREATE TABLE institutes (
     14 	id int NOT NULL primary key,
     15 	name varchar(255)
     16 )
     17 unique hash on (id) pages=100;
     18 
     19 CREATE TABLE documents (
     20 	id int NOT NULL primary key,
     21 	title varchar(255) NOT NULL,
     22 	abstract varchar(255)
     23 )
     24 unique hash on (id) pages=100;
     25 
     26 CREATE 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 
     36 CREATE TABLE phones (
     37 	id int NOT NULL primary key,
     38 	phone varchar(255) NOT NULL ,
     39 	pers_id int NOT NULL 
     40 )
     41 unique hash on (id) pages=100;
     42 
     43