/* SQL Script to create the tables for the Headline RDM */
/* Created by S.Graham on 8th September 1999 */
/* last modified on 3rd May 2000 */

create table vendors
(vendor_id varchar (20) primary key,
vendorname varchar (150) not null,
vendoraddress text,
contactname varchar (50),
contactno varchar (50),
helpno varchar (50),
helpemail varchar (60),
vendorurl varchar (100),
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table service
(service_id varchar (20) primary key,
servicename varchar (100) not null,
servicedescription text,
servicesummary text,
institution_available varchar (10),
keywords text,
language varchar (30),
topic text,
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table serviceinstance
(serviceinstance_id varchar (20) primary key,
service_id varchar (20) not null,
searchprotocol varchar (15),
ipaddress varchar (15),
portno varchar (5),
dbname varchar (20),
zsyntax varchar (30),
ippermissionedurl text,
indpasswdurl text,
genericpasswdurl text,
nonrestrictedlinkurl text,
accesstype varchar (15),
gusername varchar (15),
gpasswd varchar (15),
indpasswd varchar (15),
indusername varchar (15),
locationmessage text,
accessmessage text,
medium varchar (15),
depth varchar (20),
vendor_id varchar (30) not null,
adminid varchar (30),
graphicurl varchar (40),
daterange varchar (20),
motd text,
showtousers varchar (3),
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table resourceinstance
(resourceinstance_id varchar (20) primary key,
daterange varchar (30),
depth varchar (20),
service_id varchar (30),
resource_id varchar (10) not null,
sameaccessasservice varchar (3),
sameasserviceurl varchar (3),
nonrestrictedurl text,
ippermissionedurl text,
indpermissionedurl text,
genericpasswdurl text,
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table individualresource
(resource_id varchar (20) primary key,
indresourcename varchar (100) not null,
object_ID varchar (20),
keywords text,
language varchar (15),
topic text,
pub_id varchar (20),
type varchar (10),
description text,
creator varchar (40),
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table publisher
(pub_id varchar (20) primary key,
pubname varchar (100) not null,
pubaddress text,
pubtelno varchar (50),
pubemail varchar (50),
puburl varchar (90),
date_record_created varchar (20),
date_record_modified varchar (20),
record_created_by varchar (50));

create table access
(access_id varchar (20) primary key,
id varchar (20) not null,
rights varchar (20),
groups varchar (30));

create table subjects
(subject_id varchar (20) primary key,
id varchar (20) not null,
subject_term varchar (30),
subjectrelevance int4);

create table ipaddresses
(ip_id varchar (20) primary key,
ipaddress varchar (20),
serviceinstance_id varchar (20));