aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/db2.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/db2.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/db2.sql20
1 files changed, 20 insertions, 0 deletions
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,