The '''IPIX''' ''project''


Makes use of the `CCPKI` project.

The table layout is a simple:
<pre>
SQL> desc ipixusers
 Name									 Null?	 Type
 ------------------------------- -------- ----
 PASS									 NOT NULL VARCHAR2(64)
 BUSUNIT								 NOT NULL VARCHAR2(64)
 USERNAME								NOT NULL VARCHAR2(64)
 
SQL> desc ipixads
 Name									 Null?	 Type
 ------------------------------- -------- ----
 FIRSTNAME										  VARCHAR2(64)
 LASTNAME											VARCHAR2(64)
 ADDR1												VARCHAR2(64)
 ADDR2												VARCHAR2(64)
 CITY												 VARCHAR2(64)
 STATE												VARCHAR2(64)
 ZIP												  VARCHAR2(64)
 PHONE												VARCHAR2(64)
 EMAIL												VARCHAR2(64)
 ADTEXT											  VARCHAR2(256)
 PIC1												 VARCHAR2(128)
 PIC2												 VARCHAR2(128)
 PIC3												 VARCHAR2(128)
 PIC4												 VARCHAR2(128)
 PIC5												 VARCHAR2(128)
 CLASSIFICATION									VARCHAR2(64)
 IMAGECOUNT										 NUMBER(10,4)
 STARTDATE										  DATE
 DURATION											NUMBER(10,4)
 RUNONLYON										  VARCHAR2(64)
 CCNUMBER											VARCHAR2(64)
 CCTYPE											  VARCHAR2(64)
 CCEXP												DATE
 BUSUNIT											 VARCHAR2(64)
 SESSIONID										  VARCHAR2(128)
 PROCSTATE							  NOT NULL VARCHAR2(32)
 LOCALID											 VARCHAR2(128)
 PICSENT											 VARCHAR2(10)
 INPRINT											 VARCHAR2(10)
 DATECREATED										DATE

</pre>