-- $Id: DISCOUNT_TRANSLATIONS.sql /main/1 2009/07/25 16:53:55 tfisher Exp $
REM DISCOUNT_TRANSLATIONS_ID
REM DISCOUNT_ID
REM DESCRIPTION
REM LANGUAGE
REM SOURCE_LANGUAGE
REM CREATED_BY
REM CREATION_DATE
REM LAST_UPDATED_BY
REM LAST_UPDATE_DATE
REM OBJECT_VERSION_ID

insert into DISCOUNT_TRANSLATIONS VALUES(
    1,
    1,
    '$10 Dollars off any item.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);


insert into DISCOUNT_TRANSLATIONS VALUES(
    2,
    2,
    '$10 Dollars off any item, plus free shipping.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

insert into DISCOUNT_TRANSLATIONS VALUES(
    3,
    3,
    'Value shipping for members.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);


insert into DISCOUNT_TRANSLATIONS VALUES(
    4,
    4,
    'Silver membership discount.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

insert into DISCOUNT_TRANSLATIONS VALUES(
    5,
    5,
    'Gold membership discount.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

insert into DISCOUNT_TRANSLATIONS VALUES(
    6,
    6,
    'Basic corporate discount.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

insert into DISCOUNT_TRANSLATIONS VALUES(
    7,
    7,
    'Basic partner discount.',
    'EN',
    'EN',
    0,
    SYSDATE,
    0,
    SYSDATE,
    0
);

-- Clone for alternative languages
insert into DISCOUNT_TRANSLATIONS select null,discount_id, description, 'FR', 'EN', 0, SYSDATE, 0, SYSDATE, 0 from DISCOUNT_TRANSLATIONS where LANGUAGE = 'EN';
insert into DISCOUNT_TRANSLATIONS select null,discount_id, description, 'DE', 'EN', 0, SYSDATE, 0, SYSDATE, 0 from DISCOUNT_TRANSLATIONS where LANGUAGE = 'EN';
insert into DISCOUNT_TRANSLATIONS select null,discount_id, description, 'EL', 'EN', 0, SYSDATE, 0, SYSDATE, 0 from DISCOUNT_TRANSLATIONS where LANGUAGE = 'EN';
insert into DISCOUNT_TRANSLATIONS select null,discount_id, description, 'JA', 'EN', 0, SYSDATE, 0, SYSDATE, 0 from DISCOUNT_TRANSLATIONS where LANGUAGE = 'EN';
