1 2create table ldap_oc_mappings 3 ( 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 11); 12 13create table ldap_attr_mappings 14 ( 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) 27); 28 29create table ldap_entries 30 ( 31 id integer not null primary key, 32 dn varchar(255) not null, 33 dn_ru varchar(255), 34 oc_map_id integer not null, 35 parent int NOT NULL , 36 keyval int NOT NULL, 37 foreign key (oc_map_id) references ldap_oc_mappings(id) 38); 39 40create index ldap_entriesx1 on ldap_entries(dn_ru); 41 42create unique index unq1_ldap_entries on ldap_entries 43 ( 44 oc_map_id, 45 keyval 46 ); 47 48create unique index unq2_ldap_entries on ldap_entries 49 ( 50 dn 51 ); 52 53create table ldap_referrals 54 ( 55 entry_id integer not null, 56 url varchar(4096) not null, 57 foreign key (entry_id) references ldap_entries(id) 58); 59 60create table ldap_entry_objclasses 61 ( 62 entry_id integer not null, 63 oc_name varchar(64), 64 foreign key (entry_id) references ldap_entries(id) 65 ); 66 67