Revision 577

Date:
2016/06/14 18:46:02
Author:
ahitrov
Revision Log:
Dirty bug - duplacated coupon link - database unique index

Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/plugins/webshop/sql/TOAST/order_coupons.sql

     
    14 14 );
    15 15
    16 16 CREATE INDEX webshop_order_coupons_user ON webshop_order_coupons USING btree (uid, session);
    17 CREATE UNIQUE INDEX webshop_order_coupons_in_order ON webshop_order_coupons USING btree (source_id, dest_id) where source_id > 0;
    17 18 create index webshop_order_coupons_source on webshop_order_coupons (source_id);
    18 19 create index webshop_order_coupons_dest on webshop_order_coupons (dest_id);

  • utf8/plugins/webshop/sql/TOAST/order_coupons.update.573.sql

     
    1 CREATE UNIQUE INDEX webshop_order_coupons_in_order ON webshop_order_coupons USING btree (source_id, dest_id) where source_id > 0;