tree_key TEXT PRIMARY KEY,
parent_tree_key TEXT,
- full_path TEXT,
+ dn TEXT,
attr_name TEXT REFERENCES ldb_attributes,
attr_value TEXT,
-- ------------------------------------------------------
- CREATE INDEX ldb_object_full_path_idx
- ON ldb_object (full_path);
+ CREATE INDEX ldb_object_dn_idx
+ ON ldb_object (dn);
CREATE INDEX ldb_attributes_tree_key_ids
ON ldb_attributes (tree_key);
/* Create root object */
INSERT INTO ldb_object
(tree_key, parent_tree_key,
- full_path,
+ dn,
object_type, max_child_num)
VALUES ('', NULL,
'',
INSERT OR IGNORE INTO ldb_object
(parent_tree_key
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('',
'c=US',
INSERT INTO ldb_object
(parent_tree_key,
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('0001',
'o=University of Michigan,c=US',
INSERT INTO ldb_object
(parent_tree_key,
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001',
NULL,
INSERT INTO ldb_object
(parent_tree_key,
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001',
NULL,
BEGIN;
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'l', 'Ann Arbor, Michigan', 2, 0);
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'st', 'Michigan', 2, 0);
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'o', 'University of Michigan', 2, 0);
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'o', 'UMICH', 2, 0);
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'seeAlso', '', 2, 0);
INSERT INTO ldb_object
- (parent_tree_key, full_path,
+ (parent_tree_key, dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001', NULL,
'telephonenumber', '+1 313 764-1817', 2, 0);