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