: /bin/sh
# create custom directory table & indexes

# /*
# *************************************************************************
# **									*
# **	Copyright (C) 2013 Trans-Mit Pty. Ltd. Melbourne Australia	*
# **	This software may not be loaned, resold, changed or copied	*
# **	in any way without the express written permission of author	*
# **	and Trans-Mit Pty. Ltd., Australia.				*
# **									*
# *************************************************************************
# **
# **	$Header: /u/catcom/Directory/PT2/Direc/RCS/directcustom,v 1.5 2010/09/21 12:33:51 catcom Exp catcom $
# **	$Author: catcom $
# **	$Date: 2010/09/21 12:33:51 $
# **	$Locker: catcom $
# **
# *************************************************************************
# */

su catcom -c runisql <<SQLCMD
create table "catcom".directcustom
  (
    recordno integer not null,
    date_updated date not null,
    surname char(15),
    firstname char(10),
    title char(40),
    telephone char(10),
    empid char(10),
    section char(14),
    division char(3),
    location char(25),
    faxno char(10),
    mobile char(10),
    pager char(11),
    voicemail char(20),
    jobno char(20),
    email char(50),

    UserID char(32),
    Instrument char(24),
--# (in Hierarchy)   Bundle char(30),
    MACaddress char(12),
    SubscriptionDesc char(50),
    DeviceType char(32),
    PhoneType char(32),
    BasicPhone char(1),
    OnTheMove char(1),
    ConAndAccesible char(1)
  );

create unique index "catcom".uidx_dc_recno on "catcom".directcustom (recordno);
create index "catcom".idx_dc_upddate on "catcom".directcustom (date_updated);
create index "catcom".idx_dc_surname on "catcom".directcustom (surname);
create index "catcom".idx_dc_firstname on "catcom".directcustom (firstname);
create index "catcom".idx_dc_telephone on "catcom".directcustom (telephone);
create index "catcom".idx_dc_empid on "catcom".directcustom (empid);
create index "catcom".idx_dc_email on "catcom".directcustom (email);
create index "catcom".idx_dc_userid on "catcom".directcustom (UserID);

SQLCMD


# /*
# **	$Log: directcustom,v $
# **	Revision 1.5  2010/09/21 12:33:51  catcom
# **	empid 6->10
# **
# **	Revision 1.4  2010/05/26 01:33:25  catcom
# **	increase4d title and location
# **
# **	Revision 1.3  2005/05/17 05:29:27  catcom
# **	NCR914
# **
# **	Revision 1.2  2001/04/18 04:53:21  catcom
# **	NCR596 - email 35 - 50
# **
# **	Revision 1.1  2000/05/18 23:21:29  catcom
# **	Initial revision
# **
# **	$Revision: 1.5 $
# **	$Source: /u/catcom/Directory/PT2/Direc/RCS/directcustom,v $
# **	$State: Exp $
# */