INSERT INTO ACCOUNT VALUES
(100001, 'Gamer1', 'gamer1@gmail.com', '1234 Gamer Ln Ames, IA 50010', TO_DATE('01/01/1995','mm/dd/yyy'), 0),
(100002, 'Gamer2', 'gamer3@gmail.com', '1235 Gamer Ln Ames, IA 50010', TO_DATE('01/02/1995','mm/dd/yyy'), -10.00),
(100003, 'Gamer3', 'gamer3@gmail.com', '1236 Gamer Ln Ames, IA 50010', TO_DATE('01/03/1995','mm/dd/yyy'), 10.00),
(100004, 'Gamer4', 'gamer4@gmail.com', '1237 Gamer Ln Ames, IA 50010', TO_DATE('01/04/1995','mm/dd/yyy'), 9999.99),
(100005, 'Gamer5', 'gamer5@gmail.com', '1238 Gamer Ln Ames, IA 50010', TO_DATE('01/05/1995','mm/dd/yyy'), 100.00);

INSERT INTO FRIENDSHIP VALUES
(100001,100002, TO_DATE('04/13/2015','mm/dd/yyy')),
(100002,100003, TO_DATE('04/13/2016','mm/dd/yyy')),
(100005,100003, TO_DATE('04/15/2016','mm/dd/yyy')),
(100003,100001, TO_DATE('04/13/2016','mm/dd/yyy'));

INSERT INTO GROUP VALUES
(1000, 'Gamers Unite', 'Place for gamers to make friends and play games'),
(1001, 'MIS320', 'Group for students taking MIS320 to unwind and play some games');

INSERT INTO MEMBERSHIP VALUES
(TO_DATE('04/13/2015','mm/dd/yyy'), 100001, 1000),
(TO_DATE('04/10/2015','mm/dd/yyy'), 100002, 1000),
(TO_DATE('04/19/2016','mm/dd/yyy'), 100004, 1001),
(TO_DATE('04/28/2015','mm/dd/yyy'), 100005, 1001);

INSERT INTO EMPLOYEE VALUES
(100, 'Employee1', TO_DATE('11/05/2008','mm/dd/yyy'), NULL, 'Customer Service') ,
(101, 'Employee2', TO_DATE('11/05/2008','mm/dd/yyy'), NULL, 'Public Relations'),
(102, 'Employee3', TO_DATE('11/22/2008','mm/dd/yyy'), NULL, 'Publisher Relations')
(103, 'Employee4', TO_DATE('11/05/2008','mm/dd/yyy'), TO_DATE('01/01/2016','mm/dd/yyyy'), 'Customer Service');

INSERT INTO SUPPORT_TICKET
(10000,  TO_DATE('09/09/2016','mm/dd/yyy'), TO_DATE('09/10/2016','mm/dd/yyy'), 'Refund needed on No Man"s Sky', 100, 100001),
(10001,  TO_DATE('11/04/2016','mm/dd/yyy'), TO_DATE('11/05/2016','mm/dd/yyy'), 'Refund needed for Call of Duty: Infinite Warfare', 101, 100002),
(10002,  TO_DATE('13/04/2017','mm/dd/yyy'), NULL, 'Request for Battletoads', 101, 100003);

INSERT INTO ITEM
(100, 'CSGOSKIN', 0.99),
(101, 'TF2HAT', 10.00),
(102, 'PROFILEBACKGROUND', .50),
(103, 'CSGOSKIN', 500.00);

INSERT INTO INVENTORY
(10000,  TO_DATE('01/01/2017','mm/dd/yyy'), 100001, 100),
(10001,  TO_DATE('04/01/2017','mm/dd/yyy'), 100002, 101),
(10000,  TO_DATE('04/13/2017','mm/dd/yyy'), 100001, 102);