diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2006-02-28 04:23:44 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2006-02-28 04:23:44 +0000 |
commit | b56cac56dd0e8c38a5725490a86f05cb77aee6ca (patch) | |
tree | 30cfc577cc7af397395b6486e1217a6d34d772d9 /activerecord/test/fixtures/db_definitions | |
parent | 1383d1c3b981972723050aeeced26e942f036716 (diff) | |
download | rails-b56cac56dd0e8c38a5725490a86f05cb77aee6ca.tar.gz rails-b56cac56dd0e8c38a5725490a86f05cb77aee6ca.tar.bz2 rails-b56cac56dd0e8c38a5725490a86f05cb77aee6ca.zip |
Added new column to all db definitions. Where, oh where, is our hereo that will convert all the legacy fixture schemas to schema.rb? (closes #3993) [Bob Silva]
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3695 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
13 files changed, 46 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.drop.sql b/activerecord/test/fixtures/db_definitions/db2.drop.sql index f669b88109..c5b32bb9fc 100644 --- a/activerecord/test/fixtures/db_definitions/db2.drop.sql +++ b/activerecord/test/fixtures/db_definitions/db2.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP TABLE topics; DROP TABLE developers; diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql index d570f925e9..2f67e9ce53 100644 --- a/activerecord/test/fixtures/db_definitions/db2.sql +++ b/activerecord/test/fixtures/db_definitions/db2.sql @@ -5,6 +5,12 @@ CREATE TABLE accounts ( PRIMARY KEY (id) ); +CREATE TABLE funny_jokes ( + id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000), + name VARCHAR(50) DEFAULT NULL, + PRIMARY KEY (id) +); + CREATE TABLE companies ( id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000), type VARCHAR(50) DEFAULT NULL, diff --git a/activerecord/test/fixtures/db_definitions/firebird.drop.sql b/activerecord/test/fixtures/db_definitions/firebird.drop.sql index 97a4e66d91..cb454c2971 100644 --- a/activerecord/test/fixtures/db_definitions/firebird.drop.sql +++ b/activerecord/test/fixtures/db_definitions/firebird.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP TABLE topics; DROP TABLE developers; @@ -32,6 +33,7 @@ DROP TABLE legacy_things; DROP DOMAIN D_BOOLEAN; DROP GENERATOR accounts_seq; +DROP GENERATOR funny_jokes_seq; DROP GENERATOR companies_nonstd_seq; DROP GENERATOR topics_seq; DROP GENERATOR developers_seq; diff --git a/activerecord/test/fixtures/db_definitions/firebird.sql b/activerecord/test/fixtures/db_definitions/firebird.sql index 87eb00c53f..729c2097df 100644 --- a/activerecord/test/fixtures/db_definitions/firebird.sql +++ b/activerecord/test/fixtures/db_definitions/firebird.sql @@ -9,6 +9,14 @@ CREATE TABLE accounts ( CREATE GENERATOR accounts_seq; SET GENERATOR accounts_seq TO 10000; +CREATE TABLE funny_jokes ( + id BIGINT NOT NULL, + name VARCHAR(50), + PRIMARY KEY (id) +); +CREATE GENERATOR funny_jokes_seq; +SET GENERATOR funny_jokes_seq TO 10000; + CREATE TABLE companies ( id BIGINT NOT NULL, "TYPE" VARCHAR(50), diff --git a/activerecord/test/fixtures/db_definitions/mysql.drop.sql b/activerecord/test/fixtures/db_definitions/mysql.drop.sql index c6a8c51fa3..14df93fd2a 100644 --- a/activerecord/test/fixtures/db_definitions/mysql.drop.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP TABLE topics; DROP TABLE developers; diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index 6e5232e82d..2b4c1b9f07 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -5,6 +5,12 @@ CREATE TABLE `accounts` ( PRIMARY KEY (`id`) ) TYPE=InnoDB; +CREATE TABLE `funny_jokes` ( + `id` int(11) NOT NULL auto_increment, + `name` varchar(50) default NULL, + PRIMARY KEY (`id`) +) TYPE=InnoDB; + CREATE TABLE `companies` ( `id` int(11) NOT NULL auto_increment, `type` varchar(50) default NULL, diff --git a/activerecord/test/fixtures/db_definitions/oci.drop.sql b/activerecord/test/fixtures/db_definitions/oci.drop.sql index 0a8684fb88..4d4ddb835d 100644 --- a/activerecord/test/fixtures/db_definitions/oci.drop.sql +++ b/activerecord/test/fixtures/db_definitions/oci.drop.sql @@ -1,4 +1,5 @@ drop table accounts; +drop table funny_jokes; drop table companies; drop table topics; drop synonym subjects; @@ -30,6 +31,7 @@ drop table keyboards; drop table legacy_things; drop sequence accounts_seq; +drop sequence funny_jokes_seq; drop sequence companies_nonstd_seq; drop sequence topics_seq; drop sequence developers_seq; diff --git a/activerecord/test/fixtures/db_definitions/oci.sql b/activerecord/test/fixtures/db_definitions/oci.sql index 31d601b734..7ecbea29b0 100644 --- a/activerecord/test/fixtures/db_definitions/oci.sql +++ b/activerecord/test/fixtures/db_definitions/oci.sql @@ -14,6 +14,13 @@ create table companies ( -- create sequence companies_nonstd_seq minvalue 10000; +create table funny_jokes ( + id integer not null, + name varchar(50) default null, + primary key (id) +); +create sequence funny_jokes_seq minvalue 10000; + create table accounts ( id integer not null, firm_id integer default null references companies initially deferred disable, diff --git a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql index 5382e1ddc0..01d620e708 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP SEQUENCE companies_nonstd_seq; DROP TABLE topics; diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index 490f915791..bbdf38c605 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -7,6 +7,11 @@ CREATE TABLE accounts ( PRIMARY KEY (id) ); +CREATE TABLE funny_jokes ( + id serial + name character varying(50) +); + CREATE SEQUENCE companies_nonstd_seq START 101; CREATE TABLE companies ( diff --git a/activerecord/test/fixtures/db_definitions/sqlite.drop.sql b/activerecord/test/fixtures/db_definitions/sqlite.drop.sql index c6a8c51fa3..14df93fd2a 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.drop.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP TABLE topics; DROP TABLE developers; diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql index 18e4dc2bd3..ea14697bd3 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql @@ -1,4 +1,5 @@ DROP TABLE accounts; +DROP TABLE funny_jokes; DROP TABLE companies; DROP TABLE topics; DROP TABLE developers; diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index 5999bdd1b4..2cb1df0c04 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -4,6 +4,11 @@ CREATE TABLE accounts ( credit_limit int default NULL ); +CREATE TABLE funny_jokes ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + name varchar(50) default NULL +); + CREATE TABLE companies ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, type varchar(50) default NULL, |