create-db.sql

It givces basic reports demo of a java application project

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (7, 10025, DATE('2004-9-01'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (7, 10026, DATE('2004-9-25'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (7, 10027, DATE('2004-10-05'), 'PROCESSING', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10028, DATE('2004-03-08'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10029, DATE('2004-03-19'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10030, DATE('2004-04-05'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10031, DATE('2004-04-27'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10032, DATE('2004-08-15'), 'COMPLETED', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (8, 10033, DATE('2004-08-31'), 'COMPLETED', 'ONLINE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10034, DATE('2004-01-13'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10035, DATE('2004-03-09'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10036, DATE('2004-05-25'), 'COMPLETED', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10037, DATE('2004-07-05'), 'COMPLETED', 'MAIL');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10038, DATE('2004-08-01'), 'CANCELLED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10039, DATE('2004-08-10'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10040, DATE('2004-09-07'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10041, DATE('2004-09-25'), 'COMPLETED', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10042, DATE('2004-09-28'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10043, DATE('2004-09-30'), 'PROCESSING', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10044, DATE('2004-10-03'), 'PROCESSING', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (9, 10045, DATE('2004-10-04'), 'PROCESSING', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10046, DATE('2004-03-14'), 'CANCELLED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10047, DATE('2004-06-22'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10048, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10049, DATE('2004-09-20'), 'COMPLETED', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10050, DATE('2004-08-16'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (10, 10051, DATE('2004-05-03'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (11, 10052, DATE('2004-07-29'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (11, 10053, DATE('2004-09-20'), 'COMPLETED', 'ONLINE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (12, 10054, DATE('2004-02-12'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (12, 10055, DATE('2004-03-14'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (12, 10056, DATE('2004-06-22'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (12, 10057, DATE('2004-08-16'), 'COMPLETED', 'ONLINE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (13, 10058, DATE('2004-07-29'), 'CANCELLED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (13, 10059, DATE('2004-03-14'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (13, 10060, DATE('2004-09-20'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (13, 10061, DATE('2004-05-03'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (13, 10062, DATE('2004-10-02'), 'PROCESSING', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (14, 10089, DATE('2004-02-12'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (14, 10090, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (14, 10091, DATE('2004-09-20'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10063, DATE('2004-07-02'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10064, DATE('2004-03-14'), 'CANCELLED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10065, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10066, DATE('2004-06-22'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10067, DATE('2004-08-16'), 'COMPLETED', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10068, DATE('2004-05-03'), 'CANCELLED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (15, 10069, DATE('2004-02-12'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (16, 10070, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (16, 10071, DATE('2004-03-14'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (16, 10072, DATE('2004-09-20'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (16, 10073, DATE('2004-10-02'), 'PROCESSING', 'FAX');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (16, 10074, DATE('2004-06-22'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (17, 10086, DATE('2004-07-29'), 'COMPLETED', 'PHONE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (17, 10087, DATE('2004-08-16'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (17, 10088, DATE('2004-05-03'), 'COMPLETED', 'FAX');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (18, 10075, DATE('2004-02-12'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (18, 10076, DATE('2004-06-22'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (19, 10077, DATE('2004-10-02'), 'PROCESSING', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (19, 10078, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (19, 10079, DATE('2004-07-02'), 'COMPLETED', 'PHONE');

INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10080, DATE('2004-09-20'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10081, DATE('2004-03-14'), 'CANCELLED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10082, DATE('2004-07-29'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10083, DATE('2004-06-22'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10084, DATE('2004-08-16'), 'COMPLETED', 'ONLINE');
INSERT INTO SAMPLE.CUSTOMER_ORDER (CUSTOMER_ID, ORDER_ID, ORDER_DATE, STATUS, PLACED_BY) VALUES (20, 10085, DATE('2004-05-03'), 'COMPLETED', 'PHONE');

-- Populate the customer referral table
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 2);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 3);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 4);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 5);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 6);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (1, 7);

INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (7, 8);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (7, 9);

INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 10);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 11);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 12);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 13);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 14);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 15);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 16);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (9, 17);

INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (17, 18);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (17, 19);
INSERT INTO SAMPLE.CUSTOMER_REFERRAL (CUSTOMER_ID, REFERRED_CUSTOMER_ID) VALUES (17, 20);

disconnect current;