CREATE TABLE kaching (
    id SERIAL PRIMARY KEY,
    channel TEXT,
    region TEXT,
    category TEXT,
    brand TEXT,
    product TEXT,
    variant TEXT,
    size TEXT,
    challenge_type TEXT,
    kaching_challenge_prompt TEXT,
    start_date DATE,
    end_date DATE,
    reward TEXT
);


INSERT INTO kaching (
    channel,
    region,
    category,
    brand,
    product,
    variant,
    size,
    challenge_type,
    kaching_challenge_prompt,
    start_date,
    end_date,
    reward
) VALUES
('ALL', 'ALL', 'SPICES/SEASONINGS', 'HINDS', 'HINDS SOUTHERN GRILL', 'ALL VARIANTS', '200G', 'DUAL', 'ACHIEVE MINIMUM 1M FORWARD SHARE AT HOME SHELF', '2024-11-21', '2024-12-15', 'R100'),
('ALL', 'ALL', 'SPICES/SEASONINGS', 'HINDS', 'HINDS SOUTHERN GRILL', 'ALL VARIANTS', '200G', 'DUAL', 'CROSS MERCHANDISE ITEM IN BUTCHERY SECTION', '2024-11-21', '2024-12-15', 'R100'),
('SUPERSPAR', 'FS', 'JAM', 'RHODES', 'SMOOTH APRICOT JAM', 'APRICOT', '900G', 'SINGLE', 'CROSS MERCHANDISE ITEM IN BREAD SECTION', '2024-11-23', '2024-11-29', 'R100'),
('ALL', 'ALL', 'BEVERAGES', 'RHODES', 'RHODES NECTARS', 'ALL VARIANTS', 'ALL', 'SINGLE', 'BUILD DISPLAY WITH A BACK TO SCHOOL THEME ', '2024-11-23', '2024-11-29', 'Competition Prize is R1000');