diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
-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; |