Plan 9 from Bell Labs’s /usr/web/sources/contrib/lucio/pub/openldap/servers/slapd/back-sql/rdbms_depend/timesten/testdb_create.sql

Copyright © 2021 Plan 9 Foundation.
Distributed under the MIT License.
Download the Plan 9 distribution.


CREATE TABLE persons (
	id int NOT NULL primary key,
	name varchar(255) NOT NULL
) 
unique hash on (id) pages=100;

CREATE TABLE institutes (
	id int NOT NULL primary key,
	name varchar(255)
)
unique hash on (id) pages=100;

CREATE TABLE documents (
	id int NOT NULL primary key,
	title varchar(255) NOT NULL,
	abstract varchar(255)
)
unique hash on (id) pages=100;

CREATE TABLE authors_docs (
	pers_id int NOT NULL,
	doc_id int NOT NULL,
	PRIMARY KEY  
	(
		pers_id,
		doc_id
	)
) unique hash on (pers_id, doc_id) pages=100;

CREATE TABLE phones (
	id int NOT NULL primary key,
	phone varchar(255) NOT NULL ,
	pers_id int NOT NULL 
)
unique hash on (id) pages=100;


Bell Labs OSI certified Powered by Plan 9

(Return to Plan 9 Home Page)

Copyright © 2021 Plan 9 Foundation. All Rights Reserved.
Comments to webmaster@9p.io.