aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord
diff options
context:
space:
mode:
authorDavid Heinemeier Hansson <david@loudthinking.com>2005-04-02 07:46:41 +0000
committerDavid Heinemeier Hansson <david@loudthinking.com>2005-04-02 07:46:41 +0000
commit52e5d748bc75de51bf1e1765ef7db1858860407b (patch)
tree420121e31251bbffd215c48d8b60899f6e73490c /activerecord
parent8d488264b5177966217982740cdd152bfc4f8903 (diff)
downloadrails-52e5d748bc75de51bf1e1765ef7db1858860407b.tar.gz
rails-52e5d748bc75de51bf1e1765ef7db1858860407b.tar.bz2
rails-52e5d748bc75de51bf1e1765ef7db1858860407b.zip
Made sure all MySQL tables are created as InnoDB
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1054 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord')
-rwxr-xr-xactiverecord/test/fixtures/db_definitions/mysql.sql26
-rw-r--r--activerecord/test/fixtures/db_definitions/mysql2.sql2
2 files changed, 14 insertions, 14 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
index c864074dbd..ca61159b74 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -38,19 +38,19 @@ CREATE TABLE `developers` (
`name` varchar(100) default NULL,
`salary` int(11) default 70000,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `projects` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `developers_projects` (
`developer_id` int(11) NOT NULL,
`project_id` int(11) NOT NULL,
`joined_on` date default NULL
-);
+) TYPE=InnoDB;
CREATE TABLE `customers` (
`id` int(11) NOT NULL auto_increment,
@@ -61,31 +61,31 @@ CREATE TABLE `customers` (
`address_country` varchar(100) default NULL,
`gps_location` varchar(100) default NULL,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `movies` (
`movieid` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
PRIMARY KEY (`movieid`)
-);
+) TYPE=InnoDB;
CREATE TABLE `subscribers` (
`nick` varchar(100) NOT NULL,
`name` varchar(100) default NULL,
PRIMARY KEY (`nick`)
-);
+) TYPE=InnoDB;
CREATE TABLE `booleantests` (
`id` int(11) NOT NULL auto_increment,
`value` integer default NULL,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `auto_id_tests` (
`auto_id` int(11) NOT NULL auto_increment,
`value` integer default NULL,
PRIMARY KEY (`auto_id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `entrants` (
`id` INTEGER NOT NULL PRIMARY KEY,
@@ -97,7 +97,7 @@ CREATE TABLE `colnametests` (
`id` int(11) NOT NULL auto_increment,
`references` int(11) NOT NULL,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `mixins` (
`id` int(11) NOT NULL auto_increment,
@@ -110,22 +110,22 @@ CREATE TABLE `mixins` (
`root_id` int(11) default NULL,
`type` varchar(40) default NULL,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `people` (
`id` INTEGER NOT NULL PRIMARY KEY,
`first_name` VARCHAR(40) NOT NULL,
`lock_version` INTEGER NOT NULL DEFAULT 0
-);
+) TYPE=InnoDB;
CREATE TABLE `binaries` (
`id` int(11) NOT NULL auto_increment,
`data` mediumblob,
PRIMARY KEY (`id`)
-);
+) TYPE=InnoDB;
CREATE TABLE `computers` (
`id` INTEGER NOT NULL PRIMARY KEY,
`developer` INTEGER NOT NULL
-);
+) TYPE=InnoDB;
diff --git a/activerecord/test/fixtures/db_definitions/mysql2.sql b/activerecord/test/fixtures/db_definitions/mysql2.sql
index 551e0ecc7d..0bfd2e6fca 100644
--- a/activerecord/test/fixtures/db_definitions/mysql2.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql2.sql
@@ -1,5 +1,5 @@
CREATE TABLE `courses` (
`id` INTEGER NOT NULL PRIMARY KEY,
`name` VARCHAR(255) NOT NULL
-);
+) TYPE=InnoDB;