CREATE TABLE cssl (
  kunde varchar(16) DEFAULT '' NOT NULL,
  anbieter varchar(8) DEFAULT '' NOT NULL,
  privatekey blob DEFAULT '' NOT NULL,
  crt blob DEFAULT '' NOT NULL,
  csr blob DEFAULT '' NOT NULL,
  neu tinyint(4) DEFAULT '0' NOT NULL,
  loeschen tinyint DEFAULT '0' NOT NULL,
  aendern tinyint DEFAULT '0' NOT NULL,
  countrycode varchar(4) DEFAULT '' NOT NULL,
  state varchar(255) DEFAULT '' NOT NULL,
  city varchar(255) DEFAULT '' NOT NULL,
  firm varchar(255) DEFAULT '' NOT NULL,
  unit varchar(255) DEFAULT '' NOT NULL,
  common varchar(255) DEFAULT '' NOT NULL,
  email varchar(255) DEFAULT '' NOT NULL,
  challenge varchar(255) DEFAULT '' NOT NULL,
  optional varchar(255) DEFAULT '' NOT NULL,
  PRIMARY KEY (kunde)
);
