SHARE
TWEET

DB Population

a guest Jun 11th, 2013 5 Never
  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);
RAW Paste Data
Top