Changeset 1425

Timestamp:

04/09/06 23:45:25 (3 years ago)

Author:

mbonetti

Message:

delay the index creation of the properties table, in a hope to be more sqlite friendly

Files:

• trunk/rss/schema.php (modified) (2 diffs)

trunk/rss/schema.php

@@ -684 +684 @@
           proptype enum('item','feed','folder','category','plugin','tag','theme','misc') NOT NULL default 'item',
           property varchar(128) NOT NULL default '',
-          value text NOT NULL,
-          UNIQUE KEY uniq (fk_ref_object_id(180),property,proptype)
+          value text NOT NULL
         ) TYPE=MyISAM;
         
@@ -696 +695 @@
         return 0;
     } else {
-        return 1;
+        $idSql = "alter table $table add UNIQUE KEY uniq (fk_ref_object_id(180),property,proptype)";
+        rss_query_wrapper($idSql, false, true);
+        return rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR);
     }
 }