dbws/eclipselink.dbws.test/etc/dbsetup_keymappings.sql

CREATE TABLE IF NOT EXISTS XR_KEYMAP_ADDRESS (
    ADDRESS_ID NUMERIC(15) NOT NULL, 
    STREET VARCHAR(80), 
    CITY VARCHAR(80), 
    PROVINCE VARCHAR(80), 
    PRIMARY KEY (ADDRESS_ID) 
)|
INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (1, '20 Pinetrail Cres.', 'Nepean', 'Ont')|
INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (2, 'Davis Side Rd.', 'Carleton Place', 'Ont')|
CREATE TABLE IF NOT EXISTS XR_KEYMAP_EMPLOYEE (
    EMP_ID NUMERIC(15) NOT NULL, 
    F_NAME VARCHAR(40), 
    L_NAME VARCHAR(40), 
    ADDR_ID NUMERIC(15), 
    PRIMARY KEY (EMP_ID), 
    CONSTRAINT XR_KEYMAP_EMPLOYEE_ADDRESS FOREIGN KEY (ADDR_ID) REFERENCES XR_KEYMAP_ADDRESS (ADDRESS_ID) 
)|
INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (1, 'Mike', 'Norman', 1)|
INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (2, 'Rick', 'Barkhouse', 2)|
CREATE TABLE IF NOT EXISTS XR_KEYMAP_PHONE (
    PHONE_ID NUMERIC(15) NOT NULL, 
    OWNER_ID NUMERIC(15) NOT NULL, 
    AREA_CODE VARCHAR(3), 
    P_NUMBER VARCHAR(7), 
    TYPE VARCHAR(15) NOT NULL, 
    PRIMARY KEY (PHONE_ID), 
    CONSTRAINT XR_KEYMAP_PHONE_EMPLOYEE FOREIGN KEY (OWNER_ID) REFERENCES XR_KEYMAP_EMPLOYEE (EMP_ID) 
)|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (1, 1, '613', '2281808', 'Home')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (2, 1, '613', '2884638', 'Work')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (3, 2, '613', '2832684', 'Home')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (4, 2, '613', '2884613', 'Work')|