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 ) 
      5 unique hash on (id) pages=100;
      6 
      7 CREATE TABLE institutes (
      8 	id int NOT NULL primary key,
      9 	name varchar(255)
     10 )
     11 unique hash on (id) pages=100;
     12 
     13 CREATE TABLE documents (
     14 	id int NOT NULL primary key,
     15 	title varchar(255) NOT NULL,
     16 	abstract varchar(255)
     17 )
     18 unique hash on (id) pages=100;
     19 
     20 CREATE TABLE authors_docs (
     21 	pers_id int NOT NULL,
     22 	doc_id int NOT NULL,
     23 	PRIMARY KEY  
     24 	(
     25 		pers_id,
     26 		doc_id
     27 	)
     28 ) unique hash on (pers_id, doc_id) pages=100;
     29 
     30 CREATE TABLE phones (
     31 	id int NOT NULL primary key,
     32 	phone varchar(255) NOT NULL ,
     33 	pers_id int NOT NULL 
     34 )
     35 unique hash on (id) pages=100;
     36 
     37