[imp] oci8/phplib problem

[Andrew Draskoy]

Figured it out... I hadn't read through every thread on this list.
The old oracle_create.sql needs to be replaced.   I followed through the
threads on that to come up with the following, dropped the tables
and ran it.  Seems to get me through the phplib test, anyway.  This
works with Oracle 8.0.5.

Andrew
------

CREATE TABLE active_sessions (
    sid varchar2(32) NOT NULL,
    name varchar2(32) NOT NULL,
    val varchar2(4000),
    changed varchar2(14) NOT NULL,
    constraint PK_ACTIVE_SESSIONS primary key (NAME, SID)
);  
    
create index CHANGED on ACTIVE_SESSIONS (CHANGED asc);

CREATE TABLE imp_addr (
    username varchar2(255) NOT NULL,
    address varchar2(255) NOT NULL,
    nickname varchar2(255),
    fullname varchar2(255) 
);  
    
CREATE TABLE imp_pref (
    username varchar2(255) NOT NULL,
    sig varchar2(2000),
    fullname varchar2(70),
    replyto varchar2(70),
    lang varchar2(30)
);  
    
ALTER TABLE IMP_ADDR ADD (
      CONSTRAINT PK_IMP_ADDR
      PRIMARY KEY (USERNAME,
                   ADDRESS)
);

ALTER TABLE IMP_PREF ADD (
      CONSTRAINT PK_IMP_PREF
      PRIMARY KEY (USERNAME)
);

ALTER TABLE IMP_ADDR ADD (
      CONSTRAINT FK_PREF_ADDR
      FOREIGN KEY (USERNAME)
      REFERENCES  IMP_PREF (
                   USERNAME)
);