2 create table ldap_oc_mappings
4 id integer not null primary key,
5 name varchar(64) not null,
6 keytbl varchar(64) not null,
7 keycol varchar(64) not null,
8 create_proc varchar(255),
9 delete_proc varchar(255),
10 expect_return tinyint not null
13 create table ldap_attr_mappings
15 id integer not null primary key,
16 oc_map_id integer not null,
17 name varchar(255) not null,
18 sel_expr varchar(255) not null,
19 sel_expr_u varchar(255),
20 from_tbls varchar(255) not null,
21 join_where varchar(255),
22 add_proc varchar(255),
23 delete_proc varchar(255),
24 param_order tinyint not null,
25 expect_return tinyint not null,
26 foreign key (oc_map_id) references ldap_oc_mappings(id)
29 create table ldap_entries
31 id integer not null primary key,
32 dn varchar(255) not null,
34 oc_map_id integer not null,
37 foreign key (oc_map_id) references ldap_oc_mappings(id)
40 create index ldap_entriesx1 on ldap_entries(dn_ru);
42 create unique index unq1_ldap_entries on ldap_entries
48 create unique index unq2_ldap_entries on ldap_entries
53 create table ldap_referrals
55 entry_id integer not null,
56 url varchar(4096) not null,
57 foreign key (entry_id) references ldap_entries(id)
60 create table ldap_entry_objclasses
62 entry_id integer not null,
64 foreign key (entry_id) references ldap_entries(id)