Changeset 1541 for branches/multiuser/schema.php

Timestamp:

08/21/06 19:48:40 (2 years ago)

Author:

mbonetti

Message:

Some more multi-user-hacking

Files:

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

branches/multiuser/schema.php

@@ -52 +52 @@
         "properties" => trim(getTable("properties")),
         "item2user" => trim(getTable("item2user")),
+        "channels2user" => trim(getTable("channels2user")),
+
 
     );
@@ -269 +271 @@
         
         break;
+        case 'm.fkuid':
+            // userid on metatags - added in 0.5.5
+            rss_query('alter table ' . getTable('metatag') . ' add column fkuid bigint(15) not null');
+            rss_query('alter table ' . getTable('metatag') . " add index 'fkuid' ('fkuid')");
+            if (rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR)) {
+                $updated++;
+                rss_error('updated schema for table ' . getTable('metatag'), RSS_ERROR_NOTICE);
+            } else {
+                rss_error('Failed updating schema for table ' . getTable('metatag') . ': '
+                    . rss_sql_error_message(), RSS_ERROR_ERROR);
+            }
+        
+        break;      
     }
     return $updated;
@@ -567 +582 @@
             fid bigint(16) NOT NULL default '0',                    
             tid bigint(16) NOT NULL default '0', 
+            fkuid bigint(16) NOT NULL default '1',
             ttype enum('item','folder','channel') NOT NULL default 'item', 
             KEY fid (fid), 
             KEY tid (tid),
+            KEY fkuid (fkuid),
             KEY ttype (ttype)
         ) TYPE=MyISAM;    
@@ -728 +745 @@
 }
 
+///////////////////////////////////////////////////////////////////////////////
+
+function _init_channels2user() {
+    $table = getTable('channels2user');
+    rss_query_wrapper ('DROP TABLE IF EXISTS ' . $table, true, true);
+    $sql_create = str_replace('__table__',$table, <<< _SQL_
+        CREATE TABLE __table__ (
+          id bigint(16) not null auto_increment,
+          fkcid bigint(16) NOT NULL,
+          fkuid bigint(16) NOT NULL,
+          icon varchar(255) default NULL,
+          position int(11) NOT NULL default '0',
+          parent tinyint(4) default '0',
+          flgprivate tinyint(1) NOT NULL default '0',
+          flgdeleted tinyint(1) not null default '0',
+          primary key (id),
+          KEY flgprivate (flgprivate),
+          KEY flgdeleted (flgdeleted),
+          KEY fkuid (fkuid),
+          KEY iids (fkcid)
+        ) 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 "
+        ." (fkcid,fkuid,icon,position,parent,flgprivate,flgdeleted) "
+        ."select id, " . rss_user_id() . ", icon, position, parent, "
+        ." mode & ".RSS_MODE_PRIVATE_STATE." = ".RSS_MODE_PRIVATE_STATE.", "
+        ." mode & ".RSS_MODE_DELETED_STATE." = ".RSS_MODE_DELETED_STATE." "
+        ." from " .getTable('channels')
+        ." where url != ''";
+        //die($fillSql);
+        rss_query_wrapper($fillSql, false, true);
+        
+        rss_query(
+            'update ' .getTable('metatag') .' m '
+            .'set m.fkuid=' .rss_user_id());
+        /*
+        $rs = rss_query( "select id, fkcid from " .getTable('channels2user'));
+        $cids=array();
+        while(list($c2uid,$cid) = rss_fetch_row($rs)) {
+            $cids[$cid]=$c2uid;
+        }
+        */
+        return rss_is_sql_error(RSS_SQL_ERROR_NO_ERROR);
+    }
+}
+
+
 
 
@@ -776 +849 @@
 
 ";
-    foreach (array("channels","config","folders","item","metatag","tag","rating", "users", "dashboard","item2user") as $tbl) {
+    foreach (array("channels","config","folders","item","metatag","tag","rating", "users", "dashboard","item2user","channels2user") as $tbl) {
         call_user_func("_init_$tbl"); 
     }