1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
create table ldap_oc_mappings (
id int identity (1, 1) not null ,
name varchar (64) not null ,
keytbl varchar (64) not null ,
keycol varchar (64) not null ,
create_proc varchar (255) NULL ,
delete_proc varchar (255) NULL,
expect_return int not null
)
GO
alter table ldap_oc_mappings add
constraint pk_ldap_oc_mappings primary key
(
id
)
GO
alter table ldap_oc_mappings add
constraint unq1_ldap_oc_mappings unique
(
name
)
GO
create table ldap_attr_mappings (
id int identity (1, 1) not null ,
oc_map_id int not null references ldap_oc_mappings(id),
name varchar (255) not null ,
sel_expr varchar (255) not null ,
sel_expr_u varchar(255),
from_tbls varchar (255) not null ,
join_where varchar (255) NULL ,
add_proc varchar (255) NULL ,
delete_proc varchar (255) NULL ,
param_order int not null,
expect_return int not null
)
GO
alter table ldap_attr_mappings add
constraint pk_ldap_attr_mappings primary key
(
id
)
GO
create table ldap_entries (
id int identity (1, 1) not null ,
dn varchar (255) not null ,
oc_map_id int not null references ldap_oc_mappings(id),
parent int not null ,
keyval int not null
)
GO
alter table ldap_entries add
constraint pk_ldap_entries primary key
(
id
)
GO
alter table ldap_entries add
constraint unq1_ldap_entries unique
(
oc_map_id,
keyval
)
GO
alter table ldap_entries add
constraint unq2_ldap_entries unique
(
dn
)
GO
create table ldap_referrals
(
entry_id int not null references ldap_entries(id),
url text not null
)
GO
create index entry_idx on ldap_referrals(entry_id);
create table ldap_entry_objclasses
(
entry_id int not null references ldap_entries(id),
oc_name varchar(64)
)
GO
create index entry_idx on ldap_entry_objclasses(entry_id);
|
