For Firebird adapter

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4423 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

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;