
#05.08.2013
CREATE TABLE IF NOT EXISTS `link_category_i18n` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `link_link_i18n` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `description` varchar(500) NOT NULL,
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


INSERT INTO link_category_i18n (id, title) SELECT id, title FROM link_category;
INSERT INTO link_link_i18n (id, title, description) SELECT id, title, description FROM link_link;

ALTER TABLE `link_category` DROP `title`;
ALTER TABLE `link_link` DROP `title`;
ALTER TABLE `link_link` DROP `description`;

