CREATE TABLE cssl (
  kunde varchar(16) DEFAULT '' NOT NULL,
  anbieter varchar(8) DEFAULT '' NOT NULL,
  privatekey text DEFAULT '' NOT NULL,
  crt text DEFAULT '' NOT NULL,
  csr text DEFAULT '' NOT NULL,
  neu smallint DEFAULT '0' NOT NULL,
  loeschen smallint DEFAULT '0' NOT NULL,
  aendern smallint 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)
);
