CREATE TABLE adstats (
  clientnum char(11) DEFAULT '' NOT NULL,
  clicked int(11) DEFAULT '0' NOT NULL,
  dadate date DEFAULT '0000-00-00' NOT NULL,
  adsused int(11) DEFAULT '0' NOT NULL
)