diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-rwxr-xr-x | activerecord/test/fixtures/db_definitions/mysql.sql | 6 | ||||
-rw-r--r-- | activerecord/test/fixtures/db_definitions/sqlite.sql | 4 |
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 ); |