diff options
author | Jeremy Kemper <jeremy@bitsweat.net> | 2005-10-16 03:45:39 +0000 |
---|---|---|
committer | Jeremy Kemper <jeremy@bitsweat.net> | 2005-10-16 03:45:39 +0000 |
commit | 7117fdb8ceeb4d8cc18651a74ea52f1bed2b077c (patch) | |
tree | 20dff4d44de2dcd1401e8cf008ceca0f077d50d8 /activerecord/test/fixtures/db_definitions | |
parent | 22b77daeee65aa80061f247a3b36404bacd7dff5 (diff) | |
download | rails-7117fdb8ceeb4d8cc18651a74ea52f1bed2b077c.tar.gz rails-7117fdb8ceeb4d8cc18651a74ea52f1bed2b077c.tar.bz2 rails-7117fdb8ceeb4d8cc18651a74ea52f1bed2b077c.zip |
r3616@asus: jeremy | 2005-09-26 23:09:28 -0700
Ticket 2292 - Sequences, schemas, and fixtures
r3917@asus: jeremy | 2005-10-15 10:43:24 -0700
fix pk assert
r3918@asus: jeremy | 2005-10-15 10:46:52 -0700
rework query cache connection= override
r3919@asus: jeremy | 2005-10-15 10:47:45 -0700
correct fixtures usage
r3920@asus: jeremy | 2005-10-15 10:53:23 -0700
correct attr assignment
r3921@asus: jeremy | 2005-10-15 12:59:10 -0700
sequences
r3922@asus: jeremy | 2005-10-15 16:36:09 -0700
reset fixtures work with sequences
r3951@asus: jeremy | 2005-10-15 23:23:12 -0700
cut down excess features
r3952@asus: jeremy | 2005-10-15 23:40:30 -0700
don't test for PostgreSQL specifically
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2639 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/postgresql.drop.sql | 1 | ||||
-rw-r--r-- | activerecord/test/fixtures/db_definitions/postgresql.sql | 5 |
2 files changed, 4 insertions, 2 deletions
diff --git a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql index d8d41cf974..7919d13a7f 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql @@ -1,5 +1,6 @@ DROP TABLE accounts; DROP TABLE companies; +DROP SEQUENCE companies_nonstd_seq; DROP TABLE topics; DROP TABLE developers; DROP TABLE projects; diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index feea20b827..67f3673734 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -6,8 +6,10 @@ CREATE TABLE accounts ( ); SELECT setval('accounts_id_seq', 100); +CREATE SEQUENCE companies_nonstd_seq START 101; + CREATE TABLE companies ( - id serial, + id integer DEFAULT nextval('companies_nonstd_seq'), "type" character varying(50), "ruby_type" character varying(50), firm_id integer, @@ -16,7 +18,6 @@ CREATE TABLE companies ( rating integer default 1, PRIMARY KEY (id) ); -SELECT setval('companies_id_seq', 100); CREATE TABLE developers_projects ( developer_id integer NOT NULL, |