1
drop table ldap_oc_mappings;
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
create_keyval varchar(255),
10
delete_proc varchar(255),
11
expect_return integer not null
14
drop table ldap_attr_mappings;
15
create table ldap_attr_mappings
17
id integer not null primary key,
18
oc_map_id integer not null references ldap_oc_mappings(id),
19
name varchar(255) not null,
20
sel_expr varchar(255) not null,
21
sel_expr_u varchar(255),
22
from_tbls varchar(255) not null,
23
join_where varchar(255),
24
add_proc varchar(255),
25
delete_proc varchar(255),
26
param_order integer not null,
27
expect_return integer not null
30
drop table ldap_entries;
31
create table ldap_entries
33
id integer not null primary key,
34
dn varchar(255) not null,
35
oc_map_id integer not null references ldap_oc_mappings(id),
40
alter table ldap_entries add
41
constraint unq1_ldap_entries unique
47
alter table ldap_entries add
48
constraint unq2_ldap_entries unique
53
drop table ldap_entry_objclasses;
54
create table ldap_entry_objclasses
56
entry_id integer not null references ldap_entries(id),