1 2insert into ldap_oc_mappings 3(id,name, keytbl, keycol, create_proc, 4delete_proc,expect_return) 5values 6(1,'inetOrgPerson','persons','id', 'insert into persons (name) values ('');\n select last_insert_id();', 7NULL,0); 8 9insert into ldap_oc_mappings 10(id, name, keytbl, keycol,create_proc,delete_proc,expect_return) 11values 12(2, 'document','documents','id', NULL, NULL, 0); 13 14insert into ldap_oc_mappings 15(id,name, keytbl, keycol,create_proc,delete_proc,expect_return) 16values 17(3,'organization','institutes','id', NULL, NULL, 0); 18 19 20insert into ldap_attr_mappings 21(id, oc_map_id, name, sel_expr, from_tbls,join_where,add_proc, 22delete_proc,param_order,expect_return) 23values 24(1, 1, 'cn', 'persons.name', 'persons',NULL, NULL, 25NULL, 3, 0); 26 27insert into ldap_attr_mappings 28(id, oc_map_id,name, sel_expr, from_tbls, 29join_where, add_proc,delete_proc,param_order,expect_return) 30values 31(2, 1, 'telephoneNumber','phones.phone','persons,phones', 32'phones.pers_id=persons.id', NULL, NULL, 3, 0); 33 34insert into ldap_attr_mappings 35(id,oc_map_id, name, sel_expr, from_tbls, join_where,add_proc, 36delete_proc,param_order,expect_return) 37values 38(3, 1, 'sn', 'persons.name','persons', NULL, NULL, 39NULL, 3, 0); 40 41insert into ldap_attr_mappings 42(id, oc_map_id, name, sel_expr, from_tbls, join_where, 43add_proc,delete_proc,param_order,expect_return) 44values 45(4, 2, 'description', 'documents.abstract','documents', NULL, 46NULL, NULL, 3, 0); 47 48insert into ldap_attr_mappings 49(id, oc_map_id, name, sel_expr, from_tbls, join_where, 50add_proc,delete_proc,param_order,expect_return) 51values 52(5, 2, 'documentTitle','documents.title','documents',NULL, 53NULL, NULL, 3, 0); 54 55-- insert into ldap_attr_mappings (id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return) 56-- values (6,2,'documentAuthor','persons.name','persons,documents,authors_docs', 57-- 'persons.id=authors_docs.pers_id AND documents.id=authors_docs.doc_id', 58-- NULL,NULL,3,0); 59 60insert into ldap_attr_mappings 61(id, oc_map_id, name, sel_expr, from_tbls, join_where,add_proc, 62delete_proc,param_order,expect_return) 63values 64(7, 3, 'o', 'institutes.name', 'institutes', NULL, NULL, 65NULL, 3, 0); 66 67insert into ldap_attr_mappings (id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return) 68values (8,1,'documentDN','ldap_entries.dn','ldap_entries,documents,authors_docs,persons', 69 'ldap_entries.keyval=documents.id AND ldap_entries.oc_map_id=2 AND authors_docs.doc_id=documents.id AND authors_docs.pers_id=persons.id', 70 NULL,NULL,3,0); 71 72insert into ldap_attr_mappings (id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return) 73values (9,2,'documentAuthor','ldap_entries.dn','ldap_entries,documents,authors_docs,persons', 74 'ldap_entries.keyval=persons.id AND ldap_entries.oc_map_id=1 AND authors_docs.doc_id=documents.id AND authors_docs.pers_id=persons.id', 75 NULL,NULL,3,0); 76 77-- entries 78 79insert into ldap_entries 80(id, dn, oc_map_id, parent, keyval) 81values 82(1, 'o=sql,c=RU', 3, 0, 1); 83 84insert into ldap_entries 85(id, dn, oc_map_id, parent, keyval) 86values 87(2, 'cn=Mitya Kovalev,o=sql,c=RU', 1, 1, 1); 88 89insert into ldap_entries (id,dn,oc_map_id,parent,keyval) 90values (3,'cn=Torvlobnor Puzdoy,o=sql,c=RU',1,1,2); 91 92insert into ldap_entries (id,dn,oc_map_id,parent,keyval) 93values (4,'cn=Akakiy Zinberstein,o=sql,c=RU',1,1,3); 94 95insert into ldap_entries (id,dn,oc_map_id,parent,keyval) 96values (5,'documentTitle=book1,o=sql,c=RU',2,1,1); 97 98insert into ldap_entries (id,dn,oc_map_id,parent,keyval) 99values (6,'documentTitle=book2,o=sql,c=RU',2,1,2); 100 101 102-- referrals 103 104insert into ldap_entry_objclasses (entry_id,oc_name) 105values (4,'referral'); 106 107insert into ldap_referrals (entry_id,url) 108values (4,'ldap://localhost:9012'); 109