diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-rwxr-xr-x | activerecord/test/fixtures/db_definitions/mysql.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index d105090355..5a24ea3768 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -155,26 +155,26 @@ CREATE TABLE `tasks` ( `starting` datetime NOT NULL default '0000-00-00 00:00:00', `ending` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) -); +) TYPE=InnoDB; CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) -); +) TYPE=InnoDB; CREATE TABLE `categories_posts` ( `category_id` int(11) NOT NULL, `post_id` int(11) NOT NULL -); +) TYPE=InnoDB; CREATE TABLE `fk_test_has_pk` ( `id` INTEGER NOT NULL PRIMARY KEY -); +) TYPE=InnoDB; CREATE TABLE `fk_test_has_fk` ( `id` INTEGER NOT NULL PRIMARY KEY, `fk_id` INTEGER NOT NULL, FOREIGN KEY (`fk_id`) REFERENCES `fk_test_has_pk`(`id`) -); +) TYPE=InnoDB; |