diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/db2.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/db2.sql | 20 |
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, |