aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/mysql.sql')
-rwxr-xr-xactiverecord/test/fixtures/db_definitions/mysql.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
index 4107155450..61ba43e954 100755
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ b/activerecord/test/fixtures/db_definitions/mysql.sql
@@ -217,3 +217,12 @@ CREATE TABLE `legacy_things` (
`version` int(11) NOT NULL default 0,
PRIMARY KEY (`id`)
) TYPE=InnoDB;
+
+CREATE TABLE `numeric_data` (
+ `id` INTEGER NOT NULL 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
+) TYPE=InnoDB;