Sample Data

INSERT INTO Location (loc_id, loc_country, loc_city, loc_region, loc_zip, loc_add1)
VALUES
(1, 'United States', 'Miami', 'Florida', '12345', 'Fake Street 123');

INSERT INTO Location (loc_id, loc_country, loc_city, loc_region, loc_zip, loc_add1)
VALUES
(2, 'Norway', 'Kristiansand', 'Vest-Agder', '4630', 'Tryms Vei 303');

INSERT INTO Location (loc_id, loc_country, loc_city, loc_region, loc_zip, loc_add1)
VALUES
(3, 'France', 'Paris', NULL, '53211', 'Rue de la Baguette 66');

INSERT INTO ContactPerson (cp_id, cp_email, cp_firstName, cp_lastName, cp_phone)
VALUES
(1, 'generic@gmail.com', 'Generic', 'Genericson', '113');

INSERT INTO ContactPerson (cp_id, cp_email, cp_firstName, cp_LastName, cp_phone)
VALUES
(2, 'fakeemail1@fake.fake', 'Fake', 'Fakerman', '12345');

INSERT INTO ContactPerson (cp_id, cp_email, cp_firstName, cp_LastName, cp_phone)
VALUES
(3, 'sendmeallthecharity@yahoo.com', 'John', 'Smith', '77777777');

INSERT INTO ContactPerson (cp_id, cp_email, cp_firstName, cp_LastName, cp_phone)
VALUES
(4, 'aaa@bbb.com', 'James', 'Hetfield', '13371234');

INSERT INTO Account (ac_id, loc_id, ac_firstName, ac_lastName, ac_password, ac_phone, ac_Email, ac_recieveNews, ac_interests, ac_skills)
VALUES
(1, 1, 'Taylor', 'Swift', 'shakeitoff', '4443331212', 'taylor@swift.com', 'true', 'singing, tweeting', 'singing, dancing, shooting');

INSERT INTO Account (ac_id, loc_id, ac_firstName, ac_lastName, ac_password, ac_phone, ac_Email, ac_recieveNews, ac_interests, ac_skills)
VALUES
(2, 3, 'Even', 'Odd', 'hemmelig', '109110202211', 'rolodex@gmail.com', 'false', 'coding', 'coding, teaching');

INSERT INTO Account (ac_id, loc_id, ac_firstName, ac_lastName, ac_password, ac_phone, ac_Email, ac_recieveNews, ac_interests, ac_skills)
VALUES
(3, 1, 'Stephen', 'Fry', 'qqqiii', '99988333', 'quiteinteresting@bbc.co.uk', 'true', 'reading, writing', 'hosting tv shows, reading out loud, acting');

INSERT INTO Account
(ac_id, loc_id, ac_firstName, ac_lastName, ac_password, ac_phone, ac_Email, ac_recieveNews, ac_interests, ac_skills)
VALUES
(4, 2, 'Another', 'Person', 'password', '123', 'gmail@hotmail.com', 'false', 'cooking, reading, running', 'cooking, math');

INSERT INTO SocialDetails(sd_id, sd_website, sd_facebook, sd_linkedin, sd_twitter, sd_image)
VALUES
(1, 'www.website.com', 'www.website.com', 'www.website.com', 'www.website.com', 'imagelinkhere');

INSERT INTO SocialDetails (sd_id, sd_website, sd_facebook, sd_linkedin, sd_twitter, sd_image)
VALUES
(3, 'redcross.com', null, null, 'twitter.com/redcross', 'redcross.png');

INSERT INTO Organization (org_id, sd_id, cp_id, loc_id, org_opportunityList, org_name, org_missionStatement, org_description, org_phone, org_type, org_creationDate, org_causes)
VALUES
(1, 1, 1, 1, 'Opportunities', 'Organization', 'We are generic', 'We do generic things', '911', 'Righthanded', TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 'No causes' );

INSERT INTO Organization (org_id, sd_id, cp_id, loc_id, org_opportunityList, org_name, org_missionStatement, org_description, org_phone, org_type, org_creationDate, org_causes)
VALUES
(2, 1, 1, 1, 'Our opportunities are: Cooking for the homeless, teaching kids math, write songs for Taylor Swift', 'The Taylor Swift Foundation', 'Our mission statement is to help people in need', 'What is this organization? A very good question', '19281 01', 'Non-profit charity', TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 'Causes of this organization is to help people not die');

INSERT INTO Organization
(org_id, sd_id, cp_id, loc_id, org_opportunityList, org_name, org_missionStatement, org_description, org_phone, org_type, org_creationDate, org_causes)
VALUES
(3, 1, 1, 1, 'Help starving kids in Africa.', 'Red Cross', 'Our mission statement is helping everyone', 'Red Cross is a non-profit organization helping people across the world', '5555555', 'Non-profit charity', TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), 'Our causes is helping people in need');

INSERT INTO Organization
(org_id, sd_id, cp_id, loc_id, org_opportunityList, org_name, org_missionStatement, org_description, org_phone, org_type, org_creationDate, org_causes)
VALUES
(4, 1, 2, 2, 'Being an assistant teacher, Cleaning the cafeteria.', 'University of Agder', 'Teaching people', 'The university in the southern part of Norway', '1234566777', 'University', TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), 'We give people an education');


INSERT INTO Opportunity (op_id, org_id, op_title, op_description, cp_id, loc_id, op_creationDate, op_neededSkills, op_minAge, op_maxVolunteers, op_requirements, op_startDate, op_startTime, op_endDate, op_endTime, op_status, op_greatFor)
VALUES
(
    1,
    1,
    'Title',
    'A description',
    1,
    1,
    (TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss')),
    'Needed skills',
    '16',
    '10',
    'Need some requirements',
    (TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss')),
    CURRENT_TIMESTAMP,
    sysdate,
    CURRENT_TIMESTAMP,
    'Approved',
    'Kids'
);

INSERT INTO Opportunity
(op_id, org_id, op_title, op_description, cp_id, loc_id, op_creationDate, op_neededSkills, op_minAge, op_maxVolunteers, op_requirements, op_startDate, op_startTime, op_endDate, op_endTime, op_status, op_greatFor)
VALUES
(3, 1, 'Cooking for the homeless', 'Pretty much title, cook food for the homeless people here', 1, 4, TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), 'Cooking, smiling', '16', null, null, TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), CURRENT_TIMESTAMP, TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), CURRENT_TIMESTAMP, 'OK', 'Chefs');

INSERT INTO AccountOpportunity
(ac_id, op_id, ao_creationDate, ao_creationTime, ac_Email, ao_status, ao_comStartDate, ao_comEndDate)
VALUES
(1, 1, TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), CURRENT_TIMESTAMP, 'seurgn@ujnire.com', 'OK', TO_DATE('2017-03-03', 'yyyy/mm/dd hh24:mi:ss'), TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'));

INSERT INTO AccountOpportunity
(ac_id, op_id, ao_creationDate, ao_creationTime, ac_Email, ao_status, ao_comStartDate, ao_comEndDate)
VALUES
(2, 1, TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'), CURRENT_TIMESTAMP, 'seurgn@ujnire.com', 'OK', TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'),
TO_DATE('1904-03-02', 'yyyy/mm/dd hh24:mi:ss'));

INSERT INTO TimeSheet
(ts_id, ac_id, op_id, ts_volunteerDate, ts_hours, ts_dataEntryDate, ts_approvedBy, ts_approval)
VALUES
(2, 1, 1, TO_DATE('2017-03-03', 'yyyy/mm/dd hh24:mi:ss'), 1, TO_DATE('2017-03-03', 'yyyy/mm/dd hh24:mi:ss'), 1, 'true');

INSERT INTO TimeSheet
(ts_id, ac_id, op_id, ts_volunteerDate, ts_hours, ts_dataEntryDate, ts_approvedBy, ts_approval)
VALUES
(3, 2, 1, TO_DATE('2017-03-03', 'yyyy/mm/dd hh24:mi:ss'), 6, TO_DATE('2017-03-03', 'yyyy/mm/dd hh24:mi:ss'), 1, 'true');