: !/bin/sh

#cd /u/catcom/database

#su catcom -c runisql <<SQLCMD0

txsql -d catcom -s <<SQLCMD0
drop view acodeconf;
SQLCMD0

txsql -d catcom -s <<SQLCMD1
create view acodeconf 
(
	RecordNo,
	AccCode, CustomID, sdate, edate,
	Description,
	Updated,
	msg1, msg2, msg3, msg4, msg5, msg6, msg7, msg8, msg9
)
AS select
	RecordNo,
	sid, sidmainttype, sdate, edate,
	genfld1,
	dateupdated,
	msg1, msg2, msg3, msg4, msg5, msg6, msg7, msg8, msg9
 from sidconf
 where sidmainttype matches "acccode_*"
SQLCMD1

txsql -d catcom -s -q "grant select on acodeconf to public"
txsql -d catcom -s -q "grant delete on acodeconf to public"
txsql -d catcom -s -q "grant insert on acodeconf to public"
txsql -d catcom -s -q "grant update on acodeconf to public"

exit 0