diff options
author | David Heinemeier Hansson <david@loudthinking.com> | 2006-06-03 21:52:22 +0000 |
---|---|---|
committer | David Heinemeier Hansson <david@loudthinking.com> | 2006-06-03 21:52:22 +0000 |
commit | 9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d (patch) | |
tree | 2432646ab704e5389a9dad4574f592de6df1ad27 | |
parent | d016d9a6d4d6f998bc4feb2c63908bb75a1529e3 (diff) | |
download | rails-9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d.tar.gz rails-9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d.tar.bz2 rails-9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d.zip |
For Firebird adapter
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4423 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
-rw-r--r-- | activerecord/test/fixtures/db_definitions/firebird3.drop.sql | 11 | ||||
-rw-r--r-- | activerecord/test/fixtures/db_definitions/firebird3.sql | 49 |
2 files changed, 60 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/firebird3.drop.sql b/activerecord/test/fixtures/db_definitions/firebird3.drop.sql new file mode 100644 index 0000000000..fc654212bd --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/firebird3.drop.sql @@ -0,0 +1,11 @@ +DROP TABLE taggings; +DROP TABLE tags; +DROP TABLE categorizations; +DROP TABLE author_addresses; +DROP TABLE author_favorites; + +DROP GENERATOR taggings_seq; +DROP GENERATOR tags_seq; +DROP GENERATOR categorizations_seq; +DROP GENERATOR author_addresses_seq; +DROP GENERATOR author_favorites_seq; diff --git a/activerecord/test/fixtures/db_definitions/firebird3.sql b/activerecord/test/fixtures/db_definitions/firebird3.sql new file mode 100644 index 0000000000..1d8e709d29 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/firebird3.sql @@ -0,0 +1,49 @@ +CREATE TABLE taggings ( + id BIGINT NOT NULL, + tag_id BIGINT, + super_tag_id BIGINT, + taggable_type VARCHAR(255), + taggable_id BIGINT, + PRIMARY KEY (id) +); +CREATE GENERATOR taggings_seq; +SET GENERATOR taggings_seq TO 10000; + +CREATE TABLE tags ( + id BIGINT NOT NULL, + name VARCHAR(255), + taggings_count BIGINT DEFAULT 0, + PRIMARY KEY (id) +); +CREATE GENERATOR tags_seq; +SET GENERATOR tags_seq TO 10000; + +CREATE TABLE categorizations ( + id BIGINT NOT NULL, + category_id BIGINT, + post_id BIGINT, + author_id BIGINT, + PRIMARY KEY (id) +); +CREATE GENERATOR categorizations_seq; +SET GENERATOR categorizations_seq TO 10000; + +ALTER TABLE posts ADD taggings_count BIGINT DEFAULT 0; +ALTER TABLE authors ADD author_address_id BIGINT; + +CREATE TABLE author_addresses ( + id BIGINT NOT NULL, + author_address_id BIGINT, + PRIMARY KEY (id) +); +CREATE GENERATOR author_addresses_seq; +SET GENERATOR author_addresses_seq TO 10000; + +CREATE TABLE author_favorites ( + id BIGINT NOT NULL, + author_id BIGINT, + favorite_author_id BIGINT, + PRIMARY KEY (id) +); +CREATE GENERATOR author_favorites_seq; +SET GENERATOR author_favorites_seq TO 10000; |