CREATE TABLE client (
  clientnum char(11) DEFAULT '' NOT NULL,
  orgname char(35) DEFAULT '' NOT NULL,
  email char(85) DEFAULT '' NOT NULL,
  adurl char(95) DEFAULT '' NOT NULL,
  adalt char(115) DEFAULT '' NOT NULL,
  adsbought int(11) DEFAULT '0' NOT NULL,
  adsused int(11) DEFAULT '0' NOT NULL,
  clicked int(11) DEFAULT '0' NOT NULL,
  pswd char(10) DEFAULT '' NOT NULL,
  ratio int(11) DEFAULT '0' NOT NULL,
  date_started date,
  status int(11) DEFAULT '0' NOT NULL,
  siteurl char(85) DEFAULT '' NOT NULL,
  ban_height int(11),
  ban_width int(11),
  category char(75),
  htjsh char(1) DEFAULT '' NOT NULL,
  PRIMARY KEY (clientnum)
)
