CREATE TABLE `des` (
  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `level` enum('--','px','cl','cf','sf','fa','dm','sp') NOT NULL DEFAULT '--',
  `classification` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(7) NOT NULL DEFAULT '',
  `description` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `das` (`id`,`description`),
  UNIQUE KEY `all_sfs_idx` (`level`,`id`,`description`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
