summaryrefslogtreecommitdiff
path: root/source4/lib/ldb/ldb_sqlite3
diff options
context:
space:
mode:
authorDerrell Lipman <derrell@samba.org>2005-06-04 02:31:45 +0000
committerGerald (Jerry) Carter <jerry@samba.org>2007-10-10 13:17:33 -0500
commit6ade5fc245a6f56b991b1b66742509270d65479d (patch)
treed4d1ab17725649d5f32ac6f12b06d44b76fa1a90 /source4/lib/ldb/ldb_sqlite3
parent6113066fa5f191bceb6b0e1e554a19b33d3ca317 (diff)
downloadsamba-6ade5fc245a6f56b991b1b66742509270d65479d.tar.gz
samba-6ade5fc245a6f56b991b1b66742509270d65479d.tar.bz2
samba-6ade5fc245a6f56b991b1b66742509270d65479d.zip
r7260: save current schema before I blow it away to try something different
(This used to be commit 676a9824934576056208d30ce34716cfb734ce58)
Diffstat (limited to 'source4/lib/ldb/ldb_sqlite3')
-rw-r--r--source4/lib/ldb/ldb_sqlite3/schema28
1 files changed, 14 insertions, 14 deletions
diff --git a/source4/lib/ldb/ldb_sqlite3/schema b/source4/lib/ldb/ldb_sqlite3/schema
index 45be5b578f..08dc50de08 100644
--- a/source4/lib/ldb/ldb_sqlite3/schema
+++ b/source4/lib/ldb/ldb_sqlite3/schema
@@ -30,7 +30,7 @@
tree_key TEXT PRIMARY KEY,
parent_tree_key TEXT,
- full_path TEXT,
+ dn TEXT,
attr_name TEXT REFERENCES ldb_attributes,
attr_value TEXT,
@@ -85,8 +85,8 @@
-- ------------------------------------------------------
- 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);
@@ -159,7 +159,7 @@
/* Create root object */
INSERT INTO ldb_object
(tree_key, parent_tree_key,
- full_path,
+ dn,
object_type, max_child_num)
VALUES ('', NULL,
'',
@@ -186,7 +186,7 @@ BEGIN;
INSERT OR IGNORE INTO ldb_object
(parent_tree_key
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('',
'c=US',
@@ -194,7 +194,7 @@ INSERT OR IGNORE INTO ldb_object
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',
@@ -208,7 +208,7 @@ INSERT OR IGNORE INTO ldb_attributes
INSERT INTO ldb_object
(parent_tree_key,
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001',
NULL,
@@ -221,7 +221,7 @@ INSERT OR IGNORE INTO ldb_attributes
INSERT INTO ldb_object
(parent_tree_key,
- full_path,
+ dn,
attr_name, attr_value, object_type, max_child_num)
VALUES ('00010001',
NULL,
@@ -243,37 +243,37 @@ COMMIT;
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);