Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Public Pastes
Guest

DB Population

By: a guest on Jun 11th, 2013  |  syntax: MySQL  |  size: 2.12 KB  |  views: 5  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. INSERT INTO `Jeweller`.`Sellers` (`id`, `name`, `address`, `phone`, `email`) VALUES
  2. (123456780, 'Papadopoulos AE', 'Piraeus', '2101234560', 'info@papadopoulos.gr'),
  3. (123336781, 'Kostopoulos AE', 'Piraeus', '2103214561', 'info@kostopoulos.gr'),
  4. (123477782, 'Petropoulos AE', 'Athens', '2108884562', 'info@petropoulos.gr'),
  5. (111456783, 'Markopoulos AE', 'Keratsini', '2101734563', 'info@markopoulos.gr'),
  6. (123456444, 'Stathopoulos AE', 'Piraeus', '2101554564', 'info@stathopoulos.gr');
  7.  
  8. INSERT INTO `Jeweller`.`Product_categories` (`id`, `name`) VALUES
  9. (1, 'Gold'),
  10. (2, 'Silver'),
  11. (3, 'Platinum'),
  12. (4, 'Watches'),
  13. (5, 'Pens');
  14.  
  15. INSERT INTO `Jeweller`.`Products` (`id`, `product_category_id`, `seller_id`, `name`, `description`) VALUES
  16. (1, 1, 123456780, 'Gold Jewel', 'Some Gold Jewel\n'),
  17. (2, 2, 123336781, 'Silver Jewel', 'Some Silver Jewel\n'),
  18. (3, 3, 123477782, 'Platinum Jewel', 'Some Platinum Jewel\n'),
  19. (4, 4, 111456783, 'XYZ Watch', 'Some Watch'),
  20. (5, 5, 123456444, 'ABC Pen', 'Some Pen');
  21.  
  22. INSERT INTO `Jeweller`.`Orders` (`id`, `date`) VALUES
  23. (1, '2013-10-10'),
  24. (2, '2013-05-05'),
  25. (3, '2013-06-06'),
  26. (4, '2013-07-07'),
  27. (5, '2013-02-02'),
  28. (6, '2013-04-04'),
  29. (7, '2013-09-09');
  30.  
  31. INSERT INTO `Jeweller`.`Product_orders` (`order_id`, `product_id`, `quantity`, `value`) VALUES
  32. (1, 1, 1, 100),
  33. (1, 2, 5, 150),
  34. (2, 1, 1, 50),
  35. (3, 3, 2, 200),
  36. (4, 2, 5, 1000),
  37. (4, 4, 4, 500),
  38. (5, 1, 10, 10),
  39. (6, 5, 20, 200),
  40. (7, 4, 10, 1500),
  41. (7, 1, 10, 1000);
  42.  
  43. INSERT INTO `Jeweller`.`Sales` (`id`, `date`) VALUES
  44. (1, '2013-05-05'),
  45. (2, '2013-06-06'),
  46. (3, '2013-07-08'),
  47. (4, '2013-09-10'),
  48. (5, '2013-02-22'),
  49. (6, '2013-11-10'),
  50. (7, '2013-05-10');
  51.  
  52. INSERT INTO `Jeweller`.`Product_sales` (`sale_id`, `product_id`, `quantity`, `value`) VALUES
  53. (1, 1, 1, 10),
  54. (2, 1, 2, 100),
  55. (3, 2, 1, 50),
  56. (4, 3, 2, 100),
  57. (4, 4, 1, 50),
  58. (5, 5, 1, 100),
  59. (6, 1, 2, 50),
  60. (7, 2, 1, 200);
  61.  
  62. INSERT INTO `Jeweller`.`Product_returns` (`sale_id`, `product_id`, `date`, `quantity`, `value`) VALUES
  63. (1, 1, '2013-11-11', 1, 10);
  64.  
  65. INSERT INTO `Jeweller`.`Stock` (`product_id`, `quantity`) VALUES
  66. (1, 18),
  67. (2, 8),
  68. (3, 0),
  69. (4, 13),
  70. (5, 19);
create a new version of this paste RAW Paste Data