CREATE TABLE client (
  client_id int(10) DEFAULT '0' NOT NULL auto_increment,
  client_name text,
  client_prename text,
  client_street text,
  client_city text,
  client_code text,
  client_phone text,
  client_fax text,
  client_note text,
  client_username char(100),
  client_passwd char(100),
  client_email text,
  PRIMARY KEY (client_id)
);
