CREATE SEQUENCE objectclass_seq INCREMENT 1 START 1;

CREATE TABLE objectclass (
    id INT NOT NULL DEFAULT nextval('objectclass_seq') ,
    description VARCHAR (255),
    uid VARCHAR (128),
    sup VARCHAR (128),
    may VARCHAR (255),
    must VARCHAR (255),
    rfc VARCHAR (64),
    auxiliary CHAR (1),
    structural CHAR (1),
    longdescription VARCHAR (1024)
);
CREATE  INDEX objectclass__id_index on objectclass (id);


CREATE SEQUENCE attribute_seq INCREMENT 1 START 1;

CREATE TABLE attribute (
    id INT NOT NULL DEFAULT nextval('attribute_seq') ,
    cn VARCHAR (64),
    uid VARCHAR (128),
    description VARCHAR (255),
    sup VARCHAR (128),
    equality VARCHAR (128),
    substr VARCHAR (128),
    syntax VARCHAR (128),
    singlevalue VARCHAR (32),
    rfc VARCHAR (64),
    longdescription VARCHAR (1024)
);
CREATE  INDEX attribute__id_index on attribute (id);


CREATE SEQUENCE syntax_seq INCREMENT 1 START 1;

CREATE TABLE syntax (
    id INT NOT NULL DEFAULT nextval('syntax_seq') ,
    uid VARCHAR (64),
    description VARCHAR (255),
    sup VARCHAR (128),
    rfc VARCHAR (64),
    longdescription VARCHAR (1024)
);
CREATE  INDEX syntax__id_index on syntax (id);


CREATE SEQUENCE matching_seq INCREMENT 1 START 1;

CREATE TABLE matching (
    id INT NOT NULL DEFAULT nextval('matching_seq') ,
    cn VARCHAR (64),
    uid VARCHAR (64),
    description VARCHAR (255),
    syntax VARCHAR (128),
    rfc VARCHAR (64),
    longDescription VARCHAR (1024)
);
CREATE  INDEX matching__id_index on matching (id);