diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/db2.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/db2.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/db2.sql b/activerecord/test/fixtures/db_definitions/db2.sql index 5977dc4bb2..9c41f7eede 100644 --- a/activerecord/test/fixtures/db_definitions/db2.sql +++ b/activerecord/test/fixtures/db_definitions/db2.sql @@ -55,6 +55,14 @@ CREATE TABLE developers_projects ( access_level smallint default 1 ); +CREATE TABLE orders ( + id int generated by default as identity (start with +10000), + name varchar(100) default NULL, + billing_customer_id int default NULL, + shipping_customer_id int default NULL, + PRIMARY KEY (id) +); + CREATE TABLE customers ( id int generated by default as identity (start with +10000), name varchar(100) default NULL, |