r7498: ldb_sqlite3 work in progress
[jra/samba/.git] / source4 / lib / ldb / ldb_sqlite3 / schema
index dddca8d48f3cdbd88d147161508d21d235a23a11..b02b8061501d4cc2ced8f8e80c011ae954c8d6bf 100644 (file)
                   create_timestamp      INTEGER,
 
                   -- Time when the entry was last modified
-                  modify_timestamp      INTEGER,
-
-                  -- Attributes of this entry, in the form
-                  --   attr\1value\0[attr\1value\0]*\0
-                  entry_data            TEXT
+                  modify_timestamp      INTEGER
                 );
 
 
                   tree_key              TEXT UNIQUE
                 );
 
+                /*
+                 * We keep a full listing of attribute/value pairs here
+                 */
+                CREATE TABLE ldb_attribute_values
+                (
+                  eid                   INTEGER REFERENCES ldb_entry,
+
+                  attr_name             TEXT, -- see ldb_attr_ATTRIBUTE_NAME
+
+                  attr_value            TEXT
+                );
+
+
                 /*
                  * There is one attribute table per searchable attribute.
                  */