Changeset 1524 for branches/multiuser/schema.php

Timestamp:

08/05/06 11:53:58 (2 years ago)

Author:

mbonetti

Message:

first mu checkin

Files:

• branches/multiuser/schema.php (modified) (5 diffs)

branches/multiuser/schema.php

@@ -50 +50 @@
         "dashboard" => trim(getTable("dashboard")),
         "properties" => trim(getTable("properties")),
+        "item2user" => trim(getTable("item2user")),
 
     );
@@ -64 +65 @@
         }
     }
-    
     $updated  = 0;
     if (count($missing_tables) > 0) {
@@ -258 +258 @@
             // guid of an item - added in 0.5.3
             rss_query('alter table ' . getTable('item') . ' add column guid text null');
-            rss_query('alter table ' . getTable('item') . ' add index `guid` (`guid`(10))');
+            rss_query('alter table ' . getTable('item') . " add index 'guid' ('guid'(10))");
             if (rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR)) {
                 $updated++;
@@ -681 +681 @@
 }
 
+
+///////////////////////////////////////////////////////////////////////////////
+
+function _init_item2user() {
+    $table = getTable('item2user');
+    rss_query_wrapper ('DROP TABLE IF EXISTS ' . $table, true, true);
+    $sql_create = str_replace('__table__',$table, <<< _SQL_
+        CREATE TABLE __table__ (
+          fkiid bigint(16) NOT NULL,
+          fkuid bigint(16) NOT NULL,
+          fkcid bigint(11) NOT NULL,
+          flgunread tinyint(1) NOT NULL default '1',
+          flgsticky tinyint(1) NOT NULL default '0',
+          flgprivate tinyint(1) NOT NULL default '0',
+          flgdeleted tinyint(1) NOT NULL default '0',
+          flgflagged tinyint(1) NOT NULL default '0',
+          KEY flgunread (flgunread),
+          KEY flgsticky (flgsticky),
+          KEY flgprivate (flgprivate),
+          KEY flgdeleted (flgdeleted),
+          KEY flgflagged (flgflagged),
+          KEY fkuid (fkuid),
+          KEY iids (fkiid)
+        ) ENGINE=MyISAM;        
+_SQL_
+);
+
+    rss_query_wrapper($sql_create, false, true);
+
+    if (!rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR)) {
+        rss_error('The ' . $table . 'table doesn\'t exist and I couldn\'t create it! Please create it manually.', RSS_ERROR_ERROR);
+        return 0;
+    } else {
+        $fillSql = "insert into $table (fkiid,fkuid,fkcid,flgunread,flgsticky,flgprivate,flgdeleted,flgflagged) "
+        ."select id, " . rss_user_id() . ", cid, "
+        ." unread & ".RSS_MODE_UNREAD_STATE." = ".RSS_MODE_UNREAD_STATE.", "
+        ." unread & ".RSS_MODE_STICKY_STATE." = ".RSS_MODE_STICKY_STATE.", "
+        ." unread & ".RSS_MODE_PRIVATE_STATE." = ".RSS_MODE_PRIVATE_STATE.", "
+        ." unread & ".RSS_MODE_DELETED_STATE." = ".RSS_MODE_DELETED_STATE.", "
+        ." unread & ".RSS_MODE_FLAG_STATE." = ".RSS_MODE_FLAG_STATE." from " .getTable('item');
+        rss_query_wrapper($fillSql, false, true);
+
+        return rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR);
+    }
+}
+
+
+
 ///////////////////////////////////////////////////////////////////////////////
 
@@ -727 +775 @@
 
 ";
-    foreach (array("channels","config","folders","item","metatag","tag","rating", "users", "dashboard") as $tbl) {
+    foreach (array("channels","config","folders","item","metatag","tag","rating", "users", "dashboard","item2user") as $tbl) {
         call_user_func("_init_$tbl"); 
     }