diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
4 files changed, 5 insertions, 1 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index 6af00eb7f0..c86a7e0141 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -36,6 +36,7 @@ CREATE TABLE `topics` ( CREATE TABLE `developers` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) default NULL, + `salary` int(11) NULL, PRIMARY KEY (`id`) ); diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index e79a8cf023..e061c214d2 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -29,6 +29,7 @@ CREATE TABLE developers_projects ( CREATE TABLE developers ( id serial, name character varying(100), + salary integer, PRIMARY KEY (id) ); SELECT setval('developers_id_seq', 100); diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql index 9863fc779f..c278651f3b 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.sql @@ -32,7 +32,8 @@ CREATE TABLE 'topics' ( CREATE TABLE 'developers' ( 'id' INTEGER PRIMARY KEY NOT NULL, - 'name' TEXT DEFAULT NULL + 'name' TEXT DEFAULT NULL, + 'salary' INTEGER NULL ); CREATE TABLE 'projects' ( diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index 555ff00f90..d5ed66c55b 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -41,6 +41,7 @@ CREATE TABLE developers ( CREATE TABLE projects ( id int NOT NULL IDENTITY(1, 1), name varchar(100) default NULL, + salary int default NULL, PRIMARY KEY (id) ); |