aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/postgresql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/postgresql.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/postgresql.sql12
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
+);