diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
4 files changed, 7 insertions, 3 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index 137fbaa73e..7bd06e6243 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -102,10 +102,11 @@ CREATE TABLE `mixins` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `pos` int(11) default NULL, - `lft` int(11) default NULL, - `rgt` int(11) default NULL, - `root_id` int(11) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, + `lft` int(11) default NULL, + `rgt` int(11) default NULL, + `root_id` int(11) default NULL, + `type` varchar(40) default NULL, PRIMARY KEY (`id`) ); diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index 4ca0e9ddc3..305852ba7f 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -118,6 +118,7 @@ CREATE TABLE colnametests ( CREATE TABLE mixins ( id serial, parent_id integer, + type character varying, pos integer, lft integer, rgt integer, diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql index 832a1a7d31..1e9aed1e1b 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.sql @@ -90,6 +90,7 @@ CREATE TABLE 'colnametests' ( CREATE TABLE 'mixins' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'parent_id' INTEGER DEFAULT NULL, + 'type' VARCHAR(40) DEFAULT NULL, 'pos' INTEGER DEFAULT NULL, 'lft' INTEGER DEFAULT NULL, 'rgt' INTEGER DEFAULT NULL, diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index 0cc8899945..4152ef59cb 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -99,6 +99,7 @@ CREATE TABLE colnametests ( CREATE TABLE mixins ( id int NOT NULL IDENTITY(1, 1), parent_id int default NULL, + type varchar(40) default NULL, pos int default NULL, lft int default NULL, rgt int default NULL, |