create table itemPrice (
    itemId      int
,   price       numeric
,   type        int         -- 0 for normal, 1 for sale
,   validFrom   date        NULL
,   validTo     date        NULL
)