AAAAhome/academiac/www/administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06.sql000064400000000630151374612660025040 0ustar00CREATE TABLE IF NOT EXISTS `#__associations` ( `id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.', `context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.', `key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.', PRIMARY KEY `idx_context_id` (`context`, `id`), INDEX `idx_key` (`key`) ) DEFAULT CHARSET=utf8;