diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2005-04-02 07:46:41 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2005-04-02 07:46:41 +0000 |
commit | 52e5d748bc75de51bf1e1765ef7db1858860407b (patch) | |
tree | 420121e31251bbffd215c48d8b60899f6e73490c /activerecord/test/fixtures/db_definitions | |
parent | 8d488264b5177966217982740cdd152bfc4f8903 (diff) | |
download | rails-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/test/fixtures/db_definitions')
-rwxr-xr-x | activerecord/test/fixtures/db_definitions/mysql.sql | 26 | ||||
-rw-r--r-- | activerecord/test/fixtures/db_definitions/mysql2.sql | 2 |
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; |