CREATE TABLE objectclass (
    id INT NOT NULL AUTO_INCREMENT ,
    description CHAR (255),
    uid CHAR (128),
    sup CHAR (128),
    may CHAR (255),
    must CHAR (255),
    rfc CHAR (64),
    auxiliary CHAR (64),
    structural CHAR (64),
    longdescription LONGTEXT,
   PRIMARY KEY(id)
);
ALTER TABLE objectclass ADD  INDEX  id_index (id);



CREATE TABLE attribute (
    id INT NOT NULL AUTO_INCREMENT ,
    cn CHAR (64),
    uid CHAR (128),
    description CHAR (255),
    sup CHAR (128),
    equality CHAR (128),
    substr CHAR (128),
    syntax CHAR (128),
    singlevalue CHAR (32),
    rfc CHAR (64),
    longdescription LONGTEXT,
   PRIMARY KEY(id)
);
ALTER TABLE attribute ADD  INDEX  id_index (id);



CREATE TABLE syntax (
    id INT NOT NULL AUTO_INCREMENT ,
    uid CHAR (64),
    description CHAR (255),
    sup CHAR (128),
    rfc CHAR (64),
    longdescription LONGTEXT,
   PRIMARY KEY(id)
);
ALTER TABLE syntax ADD  INDEX  id_index (id);



CREATE TABLE matching (
    id INT NOT NULL AUTO_INCREMENT ,
    cn CHAR (64),
    uid CHAR (64),
    description CHAR (255),
    syntax CHAR (128),
    rfc CHAR (64),
    longDescription LONGTEXT,
   PRIMARY KEY(id)
);
ALTER TABLE matching ADD  INDEX  id_index (id);