aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions
diff options
context:
space:
mode:
authorJeremy Kemper <jeremy@bitsweat.net>2006-12-01 21:24:47 +0000
committerJeremy Kemper <jeremy@bitsweat.net>2006-12-01 21:24:47 +0000
commit8ffb22056c2896a67917b813064b2247233d3a08 (patch)
tree770b069ec64cc067611e903d06471d60e6a0de9a /activerecord/test/fixtures/db_definitions
parent2e2bf2d1494aa8b4efc4ff9e132dde4afd15ece1 (diff)
downloadrails-8ffb22056c2896a67917b813064b2247233d3a08.tar.gz
rails-8ffb22056c2896a67917b813064b2247233d3a08.tar.bz2
rails-8ffb22056c2896a67917b813064b2247233d3a08.zip
Subclasses of an abstract class work with single-table inheritance. Closes #5704.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5660 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-rwxr-xr-xactiverecord/test/fixtures/db_definitions/mysql.sql6
-rw-r--r--activerecord/test/fixtures/db_definitions/sqlite.sql4
2 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 c6a78962c6..9e5cf72aba 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -159,14 +159,14 @@ CREATE TABLE `posts` (
`author_id` INTEGER,
`title` VARCHAR(255) NOT NULL,
`body` TEXT NOT NULL,
- `type` VARCHAR(255) NOT NULL
+ `type` VARCHAR(255) default NULL
) TYPE=InnoDB;
CREATE TABLE `comments` (
`id` INTEGER NOT NULL auto_increment PRIMARY KEY,
`post_id` INTEGER NOT NULL,
`body` TEXT NOT NULL,
- `type` VARCHAR(255) NOT NULL
+ `type` VARCHAR(255) default NULL
) TYPE=InnoDB;
CREATE TABLE `authors` (
@@ -184,7 +184,7 @@ CREATE TABLE `tasks` (
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`name` VARCHAR(255) NOT NULL,
- `type` VARCHAR(255) NOT NULL,
+ `type` VARCHAR(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=InnoDB;
diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql
index 8f89c419a1..edf1e815da 100644
--- a/activerecord/test/fixtures/db_definitions/sqlite.sql
+++ b/activerecord/test/fixtures/db_definitions/sqlite.sql
@@ -144,14 +144,14 @@ CREATE TABLE 'posts' (
'id' INTEGER NOT NULL PRIMARY KEY,
'author_id' INTEGER,
'title' VARCHAR(255) NOT NULL,
- 'type' VARCHAR(255) NOT NULL,
+ 'type' VARCHAR(255) DEFAULT NULL,
'body' TEXT NOT NULL
);
CREATE TABLE 'comments' (
'id' INTEGER NOT NULL PRIMARY KEY,
'post_id' INTEGER NOT NULL,
- 'type' VARCHAR(255) NOT NULL,
+ 'type' VARCHAR(255) DEFAULT NULL,
'body' TEXT NOT NULL
);