INSERT INTO EndUser VALUES (1,'esong','password','Edward','Song',1,0,NULL); -- manager
INSERT INTO EndUser VALUES (2,'ehsong','password','Eddie','Song',0,1,1); -- sales
INSERT INTO EndUser VALUES (3,'mkern','password','Michael','Kern',0,1,1); -- sales
INSERT INTO EndUser VALUES (4,'anguyen','password','Adam','Nguyen',0,1,1); -- sales
INSERT INTO EndUser VALUES (5,'vafa','password','Vafa','Vafa',0,1,1); -- sales
INSERT INTO EndUser VALUES (6,'edsong','password','Ed','Song',1,1,null); -- executive
INSERT INTO EndUser VALUES (7,'dsanchez','password','Derrick','Sanchez',0,1,6); -- sales
INSERT INTO EndUser VALUES (8,'thunt','password','Tim','Hunt',0,1,6); -- sales
INSERT INTO EndUser VALUES (9,'kschultz','password','Kyle','Schultz',0,1,6); -- sales
INSERT INTO EndUser VALUES (10,'bmccoy','password','Ben','Mccoy',0,1,6); -- sales

INSERT INTO Account VALUES (1,'Comet Pharma', 'Pharmacy', '12345 Synergy', 'Richardson', 'TX', 75252, '2141515151', 'www.cometpharma.com',2);
INSERT INTO Account VALUES (2,'Temocs Pancakes', 'Resturant', '17251 Waterview Pkwy', 'Dallas', 'TX', 75252, '9724548585', 'www.temocspancakes.com',3);
INSERT INTO Account VALUES (3,'Comet Psychiatrist', 'Evaluation and perscriptions', '1059 Synergy', 'Richardson', 'TX', 75252, '9727271543', 'www.cometpsych.com', 5);
INSERT INTO Account VALUES (4,'Pizza Johns', 'Pizza delivery', '819 W Arapaho Rd Ste 24a', 'Richardson', 'TX', 75252, '9727271655', 'www.pizzajohns.com', 9);
INSERT INTO Account VALUES (5,'Air Force 1', 'Aircraft sales', '4727 Frankford Rd Ste 341', 'Richardson', 'TX', 75252, '9727271999', 'www.af1.com', 10);
INSERT INTO Account VALUES (6,'Lava Lamps', 'Sells lights and lava lamps', '4733 Frankford Rd Ste 235', 'Richardson', 'TX', 75252, '9727271333', 'www.lavallamps.com', 6);
INSERT INTO Account VALUES (7,'Opal Sands', 'Resort', '430 S Gulfview Blvd', 'Clearwater Beach', 'FL', 33767, '2147271333', 'www.opalsands.com', 8);
INSERT INTO Account VALUES (8,'Michaels Marketing', 'Marketing services', '2435 N Central Expy 12th Floor Ste 2233A', 'Richardson', 'TX', 75080, '9727271333', 'www.michaelmarketing.com', 7);

INSERT INTO Contact VALUES (1,'IT Director', 1,'Temoc', 'Jesus', '2145854568', 'tjesus@cometpharma.com', 1);
INSERT INTO Contact VALUES (2,'Pancake Master', 0,'Temoc', 'Pancakehead', '2145525234', 'tpancakes@tenmocspancakes.com', 1);
INSERT INTO Contact VALUES (3,'Psychiatrist Overseer', 1,'Jane', 'Mo', '9727434566', 'janemo234@gmail.com', 3);
INSERT INTO Contact VALUES (4,'Pizza Man', 0,'Joe', 'Bigs', '9726432733', 'joepizza22@gmail.com', 4);
INSERT INTO Contact VALUES (5,'Piolot', 0,'Sal', 'Bucana', '2147338444', 'salbfive@gmail.com', 5);
INSERT INTO Contact VALUES (6,'Electrician', 0,'James', 'Borne', '9722233332', 'jamesfastelectric@hotmail.com', 6);
INSERT INTO Contact VALUES (7,'Resort Manager', 1,'Ellie', 'Roma', '9728765433', 'ellier1234@gmail.com', 7);
INSERT INTO Contact VALUES (8,'Marketing Manager', 1,'Susan', 'Anthony', '9723343332', 'sueanthony1@gmail.com', 8);


INSERT INTO Activity VALUES (1, 'email', '2019-02-28', 'Server Opp', 'emailed Temoc to confirm details for server opportunity', 1);
INSERT INTO Activity VALUES (2, 'phone', '2019-03-30', 'Grills', 'Tenmoc needs to expand business. Needs more gas grills.', 1);
INSERT INTO Activity VALUES (3, 'phone', '2019-02-30', 'New Building', 'Psychiatrist Overseer would like to expand building', 3);
INSERT INTO Activity VALUES (4, 'email', '2019-01-30', 'New Store', 'Joe Bigs is looking to open a new pizza shop', 4);
INSERT INTO Activity VALUES (5, 'telegram', '2018-03-30', 'App Development', 'Air Force 1 would like to create an app', 5);
INSERT INTO Activity VALUES (6, 'skype', '2019-04-15', 'Advertizing', 'Electrician James Borne needs help advertizing lava lamps', 6);
INSERT INTO Activity VALUES (7, 'email', '2019-04-22', 'Resort Advertizing', 'Ms. Romma is looking to contract us for advertizing', 7);
INSERT INTO Activity VALUES (8, 'phone', '2019-05-23', 'Selling marketing tools', 'Susan Anthony wants to sell us marketing tools', 8);
INSERT INTO Activity VALUES (8, 'phone', '2019-05-24', 'Marketing tools rejected', 'We decided Susans marketing tools are of no need to us', 8);


INSERT INTO Opportunity VALUES (1,'Comet Pharma Servers',15023.00,'Proposal','2019-01-26',2,1);
INSERT INTO Opportunity VALUES (2,'Tenmocs Pancakes Grills',5,'Closed Lost','2019-2-26',3,2);
INSERT INTO Opportunity VALUES (3,'Building Help',100300.00,'Proposal','2019-03-26',3,3);
INSERT INTO Opportunity VALUES (4,'Services for Opening',15000.00,'Proposal','2019-02-20',4,4);
INSERT INTO Opportunity VALUES (5,'App Development',20000.00,'In Progress','2019-01-26',5,5);
INSERT INTO Opportunity VALUES (6,'Advertizing',16000.00,'Approved','2019-05-26',6,6);
INSERT INTO Opportunity VALUES (7,'Resort Advertizing',60000.00,'Campaign in progress','2019-04-25',7,7);
INSERT INTO Opportunity VALUES (8,'Marketing Tools', 00.00,'Rejected','2019-05-24',8,8);


SELECT * FROM Account;
SELECT * FROM EndUser;

SELECT * FROM Contact;

SELECT * FROM Activity;
SELECT * FROM Opportunity;
SELECT * FROM ManagerView;