gistfile1.txt

app_development=# select * from spree_promotions;
-[ RECORD 1 ]+---------------------------
id           | 1
description  | 
expires_at   | 2014-09-24 16:00:00
starts_at    | 2014-09-16 16:00:00
name         | stepfresh's cool promotion
type         | 
usage_limit  | 1
match_policy | all
code         | awesome
advertise    | t
path         | 
created_at   | 2014-09-17 01:12:19.096237
updated_at   | 2014-09-17 01:12:19.096237

app_development=# select * from spree_promotion_rules;
-[ RECORD 1 ]----+---------------------------------
id               | 1
promotion_id     | 1
user_id          | 
product_group_id | 
type             | Spree::Promotion::Rules::Product
created_at       | 2014-09-17 01:12:31.175775
updated_at       | 2014-09-17 01:12:38.609974
code             | 
preferences      | ---
                 | :match_policy: any
                 | 

app_development=# select * from spree_products_promotion_rules;
-[ RECORD 1 ]-----+--
product_id        | 1
promotion_rule_id | 1

fremantle_press_development=# select * from spree_promotion_actions;
 id | promotion_id | position |                       type                       | deleted_at 
----+--------------+----------+--------------------------------------------------+------------
  1 |            1 |          | Spree::Promotion::Actions::FreeShipping          | 
  2 |            1 |          | Spree::Promotion::Actions::CreateItemAdjustments | 

fremantle_press_development=# select * from spree_calculators;
-[ RECORD 1 ]---+--------------------------------------------
id              | 1
type            | Spree::Calculator::PercentOnLineItem
calculable_id   | 2
calculable_type | Spree::PromotionAction
created_at      | 2014-09-17 01:39:23.829639
updated_at      | 2014-09-17 01:39:30.266876
preferences     | ---
                | :percent: !ruby/object:BigDecimal 18:0.25E2
                |