From 10d458b0aadc9f44bfadda6e59d08be8ea661029 Mon Sep 17 00:00:00 2001 From: David Heinemeier Hansson Date: Wed, 23 Feb 2005 13:34:57 +0000 Subject: Added a OCI8-based Oracle adapter that has been verified to work with Oracle 8 and 9 #629 [Graham Jenkins]. Removed Maiks Oracle adapter until it can be merged with the OCI one. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@761 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- activerecord/test/fixtures/db_definitions/oci.sql | 167 ++++++++++++++++++++++ 1 file changed, 167 insertions(+) create mode 100644 activerecord/test/fixtures/db_definitions/oci.sql (limited to 'activerecord/test/fixtures/db_definitions/oci.sql') diff --git a/activerecord/test/fixtures/db_definitions/oci.sql b/activerecord/test/fixtures/db_definitions/oci.sql new file mode 100644 index 0000000000..86d7a03165 --- /dev/null +++ b/activerecord/test/fixtures/db_definitions/oci.sql @@ -0,0 +1,167 @@ +create sequence rails_sequence minvalue 10000; + +create table companies ( + id integer not null, + type varchar(50) default null, + ruby_type varchar(50) default null, + firm_id integer default null references companies initially deferred disable, + name varchar(50) default null, + client_of integer default null references companies initially deferred disable, + companies_count integer default 0, + rating integer default 1, + primary key (id) +); + +create table accounts ( + id integer not null, + firm_id integer default null references companies initially deferred disable, + credit_limit integer default null, + primary key (id) +); + +create table topics ( + id integer not null, + title varchar(255) default null, + author_name varchar(255) default null, + author_email_address varchar(255) default null, + written_on timestamp default null, + bonus_time timestamp default null, + last_read timestamp default null, + content varchar(4000), + approved integer default 1, + replies_count integer default 0, + parent_id integer references topics initially deferred disable, + type varchar(50) default null, + primary key (id) +); +-- try again for 8i +create table topics ( + id integer not null, + title varchar(255) default null, + author_name varchar(255) default null, + author_email_address varchar(255) default null, + written_on date default null, + bonus_time date default null, + last_read date default null, + content varchar(4000), + approved integer default 1, + replies_count integer default 0, + parent_id integer references topics initially deferred disable, + type varchar(50) default null, + primary key (id) +); + +create table developers ( + id integer not null, + name varchar(100) default null, + salary integer default 70000, + primary key (id) +); + +create table projects ( + id integer not null, + name varchar(100) default null, + primary key (id) +); + +create table developers_projects ( + developer_id integer not null references developers initially deferred disable, + project_id integer not null references projects initially deferred disable, + joined_on timestamp default null +); +-- Try again for 8i +create table developers_projects ( + developer_id integer not null references developers initially deferred disable, + project_id integer not null references projects initially deferred disable, + joined_on date default null +); + +create table customers ( + id integer not null, + name varchar(100) default null, + balance integer default 0, + address_street varchar(100) default null, + address_city varchar(100) default null, + address_country varchar(100) default null, + primary key (id) +); + +create table movies ( + movieid integer not null, + name varchar(100) default null, + primary key (movieid) +); + +create table subscribers ( + nick varchar(100) not null, + name varchar(100) default null, + primary key (nick) +); + +create table booleantests ( + id integer not null, + value integer default null, + primary key (id) +); + +create table auto_id_tests ( + auto_id integer not null, + value integer default null, + primary key (auto_id) +); + +create table entrants ( + id integer not null primary key, + name varchar(255) not null, + course_id integer not null +); + +create table colnametests ( + id integer not null, + references integer not null, + primary key (id) +); + +create table mixins ( + id integer not null, + parent_id integer default null references mixins initially deferred disable, + type varchar(40) default null, + pos integer default null, + lft integer default null, + rgt integer default null, + root_id integer default null, + created_at timestamp default null, + updated_at timestamp default null, + primary key (id) +); +-- try again for 8i +create table mixins ( + id integer not null, + parent_id integer default null references mixins initially deferred disable, + type varchar(40) default null, + pos integer default null, + lft integer default null, + rgt integer default null, + root_id integer default null, + created_at date default null, + updated_at date default null, + primary key (id) +); + +create table people ( + id integer not null, + first_name varchar(40) null, + lock_version integer default 0, + primary key (id) +); + +create table binaries ( + id integer not null, + data blob null, + primary key (id) +); + +create table computers ( + id integer not null primary key, + developer integer not null references developers initially deferred disable +); -- cgit v1.2.3