1 create table ldap_oc_mappings (
2 id int identity (1, 1) not null ,
3 name varchar (64) not null ,
4 keytbl varchar (64) not null ,
5 keycol varchar (64) not null ,
6 create_proc varchar (255) NULL ,
7 delete_proc varchar (255) NULL,
8 expect_return int not null
12 alter table ldap_oc_mappings add
13 constraint pk_ldap_oc_mappings primary key
20 alter table ldap_oc_mappings add
21 constraint unq1_ldap_oc_mappings unique
28 create table ldap_attr_mappings (
29 id int identity (1, 1) not null ,
30 oc_map_id int not null references ldap_oc_mappings(id),
31 name varchar (255) not null ,
32 sel_expr varchar (255) not null ,
33 from_tbls varchar (255) not null ,
34 join_where varchar (255) NULL ,
35 add_proc varchar (255) NULL ,
36 modify_proc varchar (255) NULL ,
37 delete_proc varchar (255) NULL ,
38 param_order int not null,
39 expect_return int not null
43 alter table ldap_attr_mappings add
44 constraint pk_ldap_attr_mappings primary key
51 create table ldap_entries (
52 id int identity (1, 1) not null ,
53 dn varchar (255) not null ,
54 oc_map_id int not null references ldap_oc_mappings(id),
61 alter table ldap_entries add
62 constraint pk_ldap_entries primary key
68 alter table ldap_entries add
69 constraint unq1_ldap_entries unique
76 alter table ldap_entries add
77 constraint unq2_ldap_entries unique
84 create table ldap_referrals
86 entry_id int not null references ldap_entries(id),
91 create index entry_idx on ldap_referrals(entry_id);
93 create table ldap_entry_objclasses
95 entry_id int not null references ldap_entries(id),
100 create index entry_idx on ldap_entry_objclasses(entry_id);