From 2a0f29497517eca1cde8b2832da5761edefb2268 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sat, 3 Oct 2009 08:37:26 +0000 Subject: [PATCH] Changed structure of tag_association table --- sql/alter2.2.sql | 5 ++--- sql/en_US-demo.sql | 5 ++--- sql/en_US-new.sql | 5 ++--- 3 files changed, 6 insertions(+), 9 deletions(-) diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql index 441c9ba6..430d3126 100644 --- a/sql/alter2.2.sql +++ b/sql/alter2.2.sql @@ -124,11 +124,10 @@ CREATE TABLE `0_tags` ( DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( - `id` int(11) NOT NULL auto_increment, `record_id` varchar(11) NOT NULL, `tag_id` int(11) NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1; + UNIQUE KEY(`record_id`,`tag_id`) +) TYPE=MyISAM; ALTER TABLE `0_suppliers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`; ALTER TABLE `0_cust_branch` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index c9b32399..b74d68d2 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -2090,11 +2090,10 @@ CREATE TABLE `0_tags` ( DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( - `id` int(11) NOT NULL auto_increment, `record_id` varchar(11) NOT NULL, `tag_id` int(11) NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1; + UNIQUE KEY(`record_id`,`tag_id`) +) TYPE=MyISAM; ### Data of table `0_tag_associations` ### diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 0e7fd5b2..53f519a6 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1832,11 +1832,10 @@ CREATE TABLE `0_tags` ( DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( - `id` int(11) NOT NULL auto_increment, `record_id` varchar(11) NOT NULL, `tag_id` int(11) NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1; + UNIQUE KEY(`record_id`,`tag_id`) +) TYPE=MyISAM; ### Data of table `0_tag_associations` ### -- 2.30.2