Changeset 78

Timestamp:

04/22/2005 12:54:10 AM (20 years ago)

Author:

matt

Message:

Foundations for tagging

Location:

trunk

Files:

• bb-admin/upgrade-schema.php (modified) (1 diff)
• bb-settings.php (modified) (2 diffs)

trunk/bb-admin/upgrade-schema.php

@@ -62 +62 @@
   PRIMARY KEY  (user_id),
   UNIQUE KEY username (username)
-);";
+);
+CREATE TABLE $bbdb->tags (
+  tag_id bigint(20) unsigned NOT NULL auto_increment,
+  tag varchar(30) NOT NULL default '',
+  raw_tag varchar(50) NOT NULL default '',
+  PRIMARY KEY  (id)
+);
+CREATE TABLE $bbdb->tagged (
+  tag_id bigint(20) unsigned NOT NULL default '0',
+  user_id bigint(20) unsigned NOT NULL default '0',
+  topic_id bigint(20) unsigned NOT NULL default '0',
+  tagged_on datetime NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY (`tag_id`,`user_id`,`topic_id`),
+  KEY `tag_id_index` (`tag_id`),
+  KEY `user_id_index` (`user_id`),
+  KEY `topic_id_index` (`topic_id`)
+);
+";
 
 function dbDelta($queries, $execute = true) {

trunk/bb-settings.php

@@ -19 +19 @@
 else
     require( BBPATH . '/bb-includes/db.php');
+
+$plugins = glob( BBPATH . '/bb-plugins/*.php');
+if ( $plugins ) : foreach ( $plugins as $plugin ) :
+    echo $plugin;
+endforeach; endif;
+
 require( BBPATH . '/bb-includes/functions.php');
 require( BBPATH . '/bb-includes/formatting-functions.php');
@@ -28 +34 @@
 $bbdb->topics  = $table_prefix . 'topics';
 $bbdb->users   = $table_prefix . 'users';
+$bbdb->tags    = $table_prefix . 'tags';
+$bbdb->tagged  = $table_prefix . 'tagged';
 
 if ( defined('CUSTOM_USER_TABLE') )