From b4160ddcc413ed87d5bcbd68d865ae430a435e48 Mon Sep 17 00:00:00 2001 From: Chuck Hagenbuch Date: Tue, 12 Jan 2010 21:54:30 -0500 Subject: [PATCH] Update for how composite primary keys are now available. --- content/migrations/2_rampage_tag_tables.php | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) diff --git a/content/migrations/2_rampage_tag_tables.php b/content/migrations/2_rampage_tag_tables.php index 80cc21561..c1638de52 100644 --- a/content/migrations/2_rampage_tag_tables.php +++ b/content/migrations/2_rampage_tag_tables.php @@ -12,15 +12,13 @@ class RampageTagTables extends Horde_Db_Migration_Base // rampage_tagged - $t = $this->createTable('rampage_tagged', array('primaryKey' => false)); + $t = $this->createTable('rampage_tagged', array('primaryKey' => array('user_id', 'object_id', 'tag_id'))); $t->column('user_id', 'integer', array('null' => false, 'unsigned' => true)); $t->column('object_id', 'integer', array('null' => false, 'unsigned' => true)); $t->column('tag_id', 'integer', array('null' => false, 'unsigned' => true)); $t->column('created', 'datetime'); $t->end(); - $this->addIndex('rampage_tagged', array('user_id', 'object_id', 'tag_id'), array('rampage_tagged_pkey', 'primary' => true)); - // rampage_tag_stats $t = $this->createTable('rampage_tag_stats', array('primaryKey' => 'tag_id')); @@ -29,13 +27,12 @@ class RampageTagTables extends Horde_Db_Migration_Base // rampage_user_tag_stats - $t = $this->createTable('rampage_user_tag_stats', array('primaryKey' => false)); + $t = $this->createTable('rampage_user_tag_stats', array('primaryKey' => array('user_id', 'tag_id'))); $t->column('user_id', 'integer', array('null' => false, 'unsigned' => true)); $t->column('tag_id', 'integer', array('null' => false, 'unsigned' => true)); $t->column('count', 'integer', array('unsigned' => true)); $t->end(); - $this->addIndex('rampage_user_tag_stats', array('user_id', 'tag_id'), array('rampage_user_tag_stats_pkey', 'primary' => true)); $this->addIndex('rampage_user_tag_stats', array('tag_id'), array('name' => 'rampage_user_tag_stats_tag_id')); } -- 2.11.0