From 9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d Mon Sep 17 00:00:00 2001 From: David Heinemeier Hansson Date: Sat, 3 Jun 2006 21:52:22 +0000 Subject: For Firebird adapter git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4423 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- .../fixtures/db_definitions/firebird3.drop.sql | 11 +++++ .../test/fixtures/db_definitions/firebird3.sql | 49 ++++++++++++++++++++++ 2 files changed, 60 insertions(+) create mode 100644 activerecord/test/fixtures/db_definitions/firebird3.drop.sql create mode 100644 activerecord/test/fixtures/db_definitions/firebird3.sql (limited to 'activerecord/test') 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; -- cgit v1.2.3