diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions')
10 files changed, 98 insertions, 2 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.drop.sql b/activerecord/test/fixtures/db_definitions/db2.drop.sql index 88e6516c81..e718d4b321 100644 --- a/activerecord/test/fixtures/db_definitions/db2.drop.sql +++ b/activerecord/test/fixtures/db_definitions/db2.drop.sql @@ -15,5 +15,8 @@ DROP TABLE mixins; DROP TABLE people; DROP TABLE binaries; DROP TABLE computers; +DROP TABLE posts; +DROP TABLE comments; +DROP TABLE authors; DROP TABLE tasks; diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql index 856847e500..a24318bf4b 100644 --- a/activerecord/test/fixtures/db_definitions/db2.sql +++ b/activerecord/test/fixtures/db_definitions/db2.sql @@ -129,6 +129,26 @@ CREATE TABLE computers ( developer int NOT NULL ); +CREATE TABLE posts ( + id int generated by default as identity (start with +10000), + author_id int default NULL, + title varchar(255) default NULL, + type varchar(255) default NULL, + body varchar(3000) default NULL +); + +CREATE TABLE comments ( + id int generated by default as identity (start with +10000), + post_id int default NULL, + type varchar(255) default NULL, + body varchar(3000) default NULL +); + +CREATE TABLE authors ( + id int generated by default as identity (start with +10000), + name varchar(255) default NULL +); + CREATE TABLE tasks ( id int generated by default as identity (start with +10000), starting timestamp default NULL, diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql index 235a1c84d1..17d443bffd 100755 --- a/activerecord/test/fixtures/db_definitions/mysql.sql +++ b/activerecord/test/fixtures/db_definitions/mysql.sql @@ -133,13 +133,15 @@ CREATE TABLE `posts` ( `id` INTEGER NOT NULL PRIMARY KEY, `author_id` INTEGER NOT NULL, `title` VARCHAR(255) NOT NULL, - `body` TEXT NOT NULL + `body` TEXT NOT NULL, + `type` VARCHAR(255) NOT NULL ) TYPE=InnoDB; CREATE TABLE `comments` ( `id` INTEGER NOT NULL PRIMARY KEY, `post_id` INTEGER NOT NULL, - `body` TEXT NOT NULL + `body` TEXT NOT NULL, + `type` VARCHAR(255) NOT NULL ) TYPE=InnoDB; CREATE TABLE `authors` ( diff --git a/activerecord/test/fixtures/db_definitions/oci.drop.sql b/activerecord/test/fixtures/db_definitions/oci.drop.sql index 255e024531..c98a8790c9 100644 --- a/activerecord/test/fixtures/db_definitions/oci.drop.sql +++ b/activerecord/test/fixtures/db_definitions/oci.drop.sql @@ -14,5 +14,8 @@ drop table colnametests; drop table mixins; drop table people; drop table binaries; +drop table posts; +drop table comments; +drop table authors; drop table computers; drop sequence rails_sequence; diff --git a/activerecord/test/fixtures/db_definitions/oci.sql b/activerecord/test/fixtures/db_definitions/oci.sql index b17b1091cb..bb4726caaa 100644 --- a/activerecord/test/fixtures/db_definitions/oci.sql +++ b/activerecord/test/fixtures/db_definitions/oci.sql @@ -167,6 +167,26 @@ create table computers ( developer integer not null references developers initially deferred disable ); +create table posts ( + id integer not null primary key, + author_id integer default null, + title varchar(255) default null, + type varchar(255) default null, + body varchar(3000) default null +); + +create table comments ( + id integer not null primary key, + post_id integer default null, + type varchar(255) default null, + body varchar(3000) default null +); + +create table authors ( + id integer not null primary key, + name varchar(255) default null +); + create table tasks ( id integer not null primary key, starting date default null, diff --git a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql index 88e6516c81..e718d4b321 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.drop.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.drop.sql @@ -15,5 +15,8 @@ DROP TABLE mixins; DROP TABLE people; DROP TABLE binaries; DROP TABLE computers; +DROP TABLE posts; +DROP TABLE comments; +DROP TABLE authors; DROP TABLE tasks; diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index 53618b653d..01d6ee288c 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -147,6 +147,26 @@ CREATE TABLE computers ( developer integer NOT NULL ); +CREATE TABLE posts ( + id serial, + author_id integer, + title varchar(255), + type varchar(255), + body text +); + +CREATE TABLE comments ( + id serial, + post_id integer, + type varchar(255), + body text +); + +CREATE TABLE authors ( + id serial, + name varchar(255) default NULL +); + CREATE TABLE taske ( id serial, starting timestamp, diff --git a/activerecord/test/fixtures/db_definitions/sqlite.sql b/activerecord/test/fixtures/db_definitions/sqlite.sql index 8639182266..0d05ca6932 100644 --- a/activerecord/test/fixtures/db_definitions/sqlite.sql +++ b/activerecord/test/fixtures/db_definitions/sqlite.sql @@ -120,12 +120,14 @@ CREATE TABLE 'posts' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'author_id' INTEGER NOT NULL, 'title' VARCHAR(255) NOT NULL, + 'type' VARCHAR(255) NOT NULL, 'body' TEXT NOT NULL ); CREATE TABLE 'comments' ( 'id' INTEGER NOT NULL PRIMARY KEY, 'post_id' INTEGER NOT NULL, + 'type' VARCHAR(255) NOT NULL, 'body' TEXT NOT NULL ); diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql index 480b2703c4..2ec7dbf026 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.drop.sql @@ -15,4 +15,7 @@ DROP TABLE mixins; DROP TABLE people; DROP TABLE binaries; DROP TABLE computers; +DROP TABLE posts; +DROP TABLE comments; +DROP TABLE authors; DROP TABLE tasks; diff --git a/activerecord/test/fixtures/db_definitions/sqlserver.sql b/activerecord/test/fixtures/db_definitions/sqlserver.sql index de746efb57..8e0d78bb61 100644 --- a/activerecord/test/fixtures/db_definitions/sqlserver.sql +++ b/activerecord/test/fixtures/db_definitions/sqlserver.sql @@ -116,6 +116,26 @@ CREATE TABLE computers ( developer int NOT NULL ); +CREATE TABLE posts ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + author_id int default NULL, + title varchar(255) default NULL, + type varchar(255) default NULL, + body text default NULL +); + +CREATE TABLE comments ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + post_id int default NULL, + type varchar(255) default NULL, + body text default NULL +); + +CREATE TABLE authors ( + id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, + name varchar(255) default NULL +); + CREATE TABLE tasks ( id int NOT NULL IDENTITY(1, 1) PRIMARY KEY, starting datetime default NULL, |