From 9c0fb70e1e37242f098c0ab0c0c045f26ed9aa8d Mon Sep 17 00:00:00 2001
From: David Heinemeier Hansson <david@loudthinking.com>
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

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