CORE-POS/IS4C

<?php
/*
Table: houseCouponItems

Columns:
    coupID int
    upc varchar
    type varchar

Depends on:
    houseCoupons

Use:
WFC runs custom barcoded coupons with
upc prefix 499999. See houseCoupons for
more detail. Type here should be 'QUALIFIER',
'DISCOUNT', or 'BOTH'.
*/
$CREATE['op.houseCouponItems'] = "
    CREATE TABLE houseCouponItems (
        coupID int,
        upc varchar(13),
        type varchar(15),
        PRIMARY KEY (coupID,upc),
        INDEX (coupID),
        INDEX (upc)
    )
";

if ($dbms == 'PDOLITE'){
    $CREATE['op.houseCouponItems'] = str_replace('INDEX (coupID),','',$CREATE['op.houseCouponItems']);
    $CREATE['op.houseCouponItems'] = str_replace('INDEX (upc)','',$CREATE['op.houseCouponItems']);
    $CREATE['op.houseCouponItems'] = str_replace('KEY (coupID,upc),','KEY (coupID,upc)',$CREATE['op.houseCouponItems']);
}
?>