SHARE
TWEET

Untitled

a guest Apr 22nd, 2019 91 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO EndUser VALUES (1,'esong','password','Edward','Song',1,0,NULL); -- manager
  2. INSERT INTO EndUser VALUES (2,'ehsong','password','Eddie','Song',0,1,1); -- sales
  3. INSERT INTO EndUser VALUES (3,'mkern','password','Michael','Kern',0,1,1); -- sales
  4. INSERT INTO EndUser VALUES (4,'anguyen','password','Adam','Nguyen',0,1,1); -- sales
  5. INSERT INTO EndUser VALUES (5,'vafa','password','Vafa','Vafa',0,1,1); -- sales
  6. INSERT INTO EndUser VALUES (6,'edsong','password','Ed','Song',1,1,null); -- executive
  7. INSERT INTO EndUser VALUES (7,'dsanchez','password','Derrick','Sanchez',0,1,6); -- sales
  8. INSERT INTO EndUser VALUES (8,'thunt','password','Tim','Hunt',0,1,6); -- sales
  9. INSERT INTO EndUser VALUES (9,'kschultz','password','Kyle','Schultz',0,1,6); -- sales
  10. INSERT INTO EndUser VALUES (10,'bmccoy','password','Ben','Mccoy',0,1,6); -- sales
  11.  
  12. INSERT INTO Account VALUES (1,'Comet Pharma', 'Pharmacy', '12345 Synergy', 'Richardson', 'TX', 75252, '2141515151', 'www.cometpharma.com',2);
  13. INSERT INTO Account VALUES (2,'Temocs Pancakes', 'Resturant', '17251 Waterview Pkwy', 'Dallas', 'TX', 75252, '9724548585', 'www.temocspancakes.com',3);
  14. INSERT INTO Account VALUES (3,'Comet Psychiatrist', 'Evaluation and perscriptions', '1059 Synergy', 'Richardson', 'TX', 75252, '9727271543', 'www.cometpsych.com', 5);
  15. INSERT INTO Account VALUES (4,'Pizza Johns', 'Pizza delivery', '819 W Arapaho Rd Ste 24a', 'Richardson', 'TX', 75252, '9727271655', 'www.pizzajohns.com', 9);
  16. INSERT INTO Account VALUES (5,'Air Force 1', 'Aircraft sales', '4727 Frankford Rd Ste 341', 'Richardson', 'TX', 75252, '9727271999', 'www.af1.com', 10);
  17. 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);
  18. INSERT INTO Account VALUES (7,'Opal Sands', 'Resort', '430 S Gulfview Blvd', 'Clearwater Beach', 'FL', 33767, '2147271333', 'www.opalsands.com', 8);
  19. 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);
  20.  
  21. INSERT INTO Contact VALUES (1,'IT Director', 1,'Temoc', 'Jesus', '2145854568', 'tjesus@cometpharma.com', 1);
  22. INSERT INTO Contact VALUES (2,'Pancake Master', 0,'Temoc', 'Pancakehead', '2145525234', 'tpancakes@tenmocspancakes.com', 1);
  23. INSERT INTO Contact VALUES (3,'Psychiatrist Overseer', 1,'Jane', 'Mo', '9727434566', 'janemo234@gmail.com', 3);
  24. INSERT INTO Contact VALUES (4,'Pizza Man', 0,'Joe', 'Bigs', '9726432733', 'joepizza22@gmail.com', 4);
  25. INSERT INTO Contact VALUES (5,'Piolot', 0,'Sal', 'Bucana', '2147338444', 'salbfive@gmail.com', 5);
  26. INSERT INTO Contact VALUES (6,'Electrician', 0,'James', 'Borne', '9722233332', 'jamesfastelectric@hotmail.com', 6);
  27. INSERT INTO Contact VALUES (7,'Resort Manager', 1,'Ellie', 'Roma', '9728765433', 'ellier1234@gmail.com', 7);
  28. INSERT INTO Contact VALUES (8,'Marketing Manager', 1,'Susan', 'Anthony', '9723343332', 'sueanthony1@gmail.com', 8);
  29.  
  30.  
  31. INSERT INTO Activity VALUES (1, 'email', '2019-02-28', 'Server Opp', 'emailed Temoc to confirm details for server opportunity', 1);
  32. INSERT INTO Activity VALUES (2, 'phone', '2019-03-30', 'Grills', 'Tenmoc needs to expand business. Needs more gas grills.', 1);
  33. INSERT INTO Activity VALUES (3, 'phone', '2019-02-30', 'New Building', 'Psychiatrist Overseer would like to expand building', 3);
  34. INSERT INTO Activity VALUES (4, 'email', '2019-01-30', 'New Store', 'Joe Bigs is looking to open a new pizza shop', 4);
  35. INSERT INTO Activity VALUES (5, 'telegram', '2018-03-30', 'App Development', 'Air Force 1 would like to create an app', 5);
  36. INSERT INTO Activity VALUES (6, 'skype', '2019-04-15', 'Advertizing', 'Electrician James Borne needs help advertizing lava lamps', 6);
  37. INSERT INTO Activity VALUES (7, 'email', '2019-04-22', 'Resort Advertizing', 'Ms. Romma is looking to contract us for advertizing', 7);
  38. INSERT INTO Activity VALUES (8, 'phone', '2019-05-23', 'Selling marketing tools', 'Susan Anthony wants to sell us marketing tools', 8);
  39. INSERT INTO Activity VALUES (8, 'phone', '2019-05-24', 'Marketing tools rejected', 'We decided Susans marketing tools are of no need to us', 8);
  40.  
  41.  
  42. INSERT INTO Opportunity VALUES (1,'Comet Pharma Servers',15023.00,'Proposal','2019-01-26',2,1);
  43. INSERT INTO Opportunity VALUES (2,'Tenmocs Pancakes Grills',5,'Closed Lost','2019-2-26',3,2);
  44. INSERT INTO Opportunity VALUES (3,'Building Help',100300.00,'Proposal','2019-03-26',3,3);
  45. INSERT INTO Opportunity VALUES (4,'Services for Opening',15000.00,'Proposal','2019-02-20',4,4);
  46. INSERT INTO Opportunity VALUES (5,'App Development',20000.00,'In Progress','2019-01-26',5,5);
  47. INSERT INTO Opportunity VALUES (6,'Advertizing',16000.00,'Approved','2019-05-26',6,6);
  48. INSERT INTO Opportunity VALUES (7,'Resort Advertizing',60000.00,'Campaign in progress','2019-04-25',7,7);
  49. INSERT INTO Opportunity VALUES (8,'Marketing Tools', 00.00,'Rejected','2019-05-24',8,8);
  50.  
  51.  
  52. SELECT * FROM Account;
  53. SELECT * FROM EndUser;
  54.  
  55. SELECT * FROM Contact;
  56.  
  57. SELECT * FROM Activity;
  58. SELECT * FROM Opportunity;
  59. SELECT * FROM ManagerView;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top