diff options
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/postgresql.sql')
-rw-r--r-- | activerecord/test/fixtures/db_definitions/postgresql.sql | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql index 175e8494bb..ce2c775aba 100644 --- a/activerecord/test/fixtures/db_definitions/postgresql.sql +++ b/activerecord/test/fixtures/db_definitions/postgresql.sql @@ -118,7 +118,8 @@ CREATE TABLE defaults ( char2 character varying(50) default 'a varchar field', char3 text default 'a text field', positive_integer integer default 1, - negative_integer integer default -1 + negative_integer integer default -1, + decimal_number decimal(3,2) default 2.78 ); CREATE TABLE auto_id_tests ( @@ -246,3 +247,12 @@ CREATE TABLE legacy_things ( tps_report_number integer, version integer default 0 ); + +CREATE TABLE numeric_data ( + id serial primary key, + bank_balance decimal(10,2), + big_bank_balance decimal(15,2), + world_population decimal(10), + my_house_population decimal(2), + decimal_number_with_default decimal(3,2) default 2.78 +); |