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),
    Bundle char(30),
    MACaddress char(12),
    SubscriptionDesc char(32),
    DeviceType char(32),
    PhoneType char(32),
    BasicPhone char(1),
    OnTheMove char(1),
    ConnectedAndAccessible 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);