From ba23590c5043fcf593e566cfdb2fd2045207c2b2 Mon Sep 17 00:00:00 2001 From: Joni Kokko Date: Fri, 23 Jan 2009 15:18:16 +0200 Subject: [PATCH] dependencies updated. --- database/irreco-database.sql | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/database/irreco-database.sql b/database/irreco-database.sql index a0dedfa7..4ba06eaf 100644 --- a/database/irreco-database.sql +++ b/database/irreco-database.sql @@ -156,7 +156,7 @@ CREATE TABLE IF NOT EXISTS `irreco`.`remote` ( `download_count` int(11) NOT NULL default '0', `downloadable` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Table for remotes'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Table for remotes'; /* * Configurations of remote @@ -164,9 +164,10 @@ CREATE TABLE IF NOT EXISTS `irreco`.`remote` ( CREATE TABLE IF NOT EXISTS `irreco`.`remote_configuration` ( `id` int(10) NOT NULL auto_increment, `remote_id` int(10) NOT NULL, - `configuration_id` int(10) NOT NULL, + `configuration_id` int(10) NOT NULL, + FOREIGN KEY(remote_id) REFERENCES remote(id) ON DELETE CASCADE, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Configurations of remote'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Configurations of remote'; /* * Themes of remote @@ -174,9 +175,10 @@ CREATE TABLE IF NOT EXISTS `irreco`.`remote_configuration` ( CREATE TABLE IF NOT EXISTS `irreco`.`remote_theme` ( `id` int(10) NOT NULL auto_increment, `remote_id` int(10) NOT NULL, - `theme_id` int(10) NOT NULL, + `theme_id` int(10) NOT NULL, + FOREIGN KEY(remote_id) REFERENCES remote(id) ON DELETE CASCADE, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Themes of remote'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Themes of remote'; -- 2.11.4.GIT