--- ldap

create table ldap_directories (
    id bigint primary key,
    name varchar not null,
    deleted boolean not null,

    hostname varchar not null,
    port integer not null,
    use_ssl boolean not null,
    username varchar not null,
    password varchar not null,
    base_dn varchar,
    
    attr_login varchar,
    attr_first_name varchar,
    attr_last_name varchar,
    attr_display_name varchar,
    attr_email varchar,

    created_at timestamptz not null,
    updated_at timestamptz not null
);

create sequence ldap_directories_id_seq;
