#!/bin/sh
#
# Setup tables for the Texis nntp importer (clari)
#
# This script, clari, chkind, and texisd should all be
# run under the same userid
#
# Add a line similar to the following to your inetd.conf
#nntp	stream	tcp	nowait	texis	/usr/local/morph3/bin/clari	clari
# then feed this machine as if it were a normal news server (rcv only)
#
d=/usr2/pub/db/realtime
creatdb $d
if [ ! -d $d ];then
	exit
fi
tsql -d $d "create table events(\
id		counter,\
Date		date,\
Category	varchar(100),\
Msgid		varchar(100),\
To		varchar(100),\
From		varchar(100),\
Body		varchar(100),\
Keywords	varchar(100),\
Subject		varchar(100)\
);"
tsql -d $d "create table profiles(\
id		counter,\
Date		date,\
From		varchar(100),\
To		varchar(100),\
Msgid		varchar(100),\
Category	varchar(100),\
Subject		varchar(100),\
Keywords	varchar(100),\
Body		varchar(100),\
Email		varchar(100),\
Description	varchar(100),\
Password	varchar(100),\
Table		varchar(100)\
);"
tsql -d $d "create metamorph index xevsub on events(Subject);"
tsql -d $d "create metamorph index xevbod on events(Body);"
tsql -d $d "create           index xevdte on events(Date);"
tsql -d $d "create inverted  index xievdt on events(Date desc);"
tsql -d $d "create           index xevid  on events(id);"
tsql -d $d "create           index xevcat on events(Category);"
tsql -d $d "insert into SYSMETAINDEX values('xevsub',0,10000);"
tsql -d $d "insert into SYSMETAINDEX values('xevbod',0,100000);"