DB Population

INSERT INTO `Jeweller`.`Sellers` (`id`, `name`, `address`, `phone`, `email`) VALUES
(123456780, 'Papadopoulos AE', 'Piraeus', '2101234560', 'info@papadopoulos.gr'),
(123336781, 'Kostopoulos AE', 'Piraeus', '2103214561', 'info@kostopoulos.gr'),
(123477782, 'Petropoulos AE', 'Athens', '2108884562', 'info@petropoulos.gr'),
(111456783, 'Markopoulos AE', 'Keratsini', '2101734563', 'info@markopoulos.gr'),
(123456444, 'Stathopoulos AE', 'Piraeus', '2101554564', 'info@stathopoulos.gr');

INSERT INTO `Jeweller`.`Product_categories` (`id`, `name`) VALUES
(1, 'Gold'),
(2, 'Silver'),
(3, 'Platinum'),
(4, 'Watches'),
(5, 'Pens');

INSERT INTO `Jeweller`.`Products` (`id`, `product_category_id`, `seller_id`, `name`, `description`) VALUES
(1, 1, 123456780, 'Gold Jewel', 'Some Gold Jewel\n'),
(2, 2, 123336781, 'Silver Jewel', 'Some Silver Jewel\n'),
(3, 3, 123477782, 'Platinum Jewel', 'Some Platinum Jewel\n'),
(4, 4, 111456783, 'XYZ Watch', 'Some Watch'),
(5, 5, 123456444, 'ABC Pen', 'Some Pen');

INSERT INTO `Jeweller`.`Orders` (`id`, `date`) VALUES
(1, '2013-10-10'),
(2, '2013-05-05'),
(3, '2013-06-06'),
(4, '2013-07-07'),
(5, '2013-02-02'),
(6, '2013-04-04'),
(7, '2013-09-09');

INSERT INTO `Jeweller`.`Product_orders` (`order_id`, `product_id`, `quantity`, `value`) VALUES
(1, 1, 1, 100),
(1, 2, 5, 150),
(2, 1, 1, 50),
(3, 3, 2, 200),
(4, 2, 5, 1000),
(4, 4, 4, 500),
(5, 1, 10, 10),
(6, 5, 20, 200),
(7, 4, 10, 1500),
(7, 1, 10, 1000);

INSERT INTO `Jeweller`.`Sales` (`id`, `date`) VALUES
(1, '2013-05-05'),
(2, '2013-06-06'),
(3, '2013-07-08'),
(4, '2013-09-10'),
(5, '2013-02-22'),
(6, '2013-11-10'),
(7, '2013-05-10');

INSERT INTO `Jeweller`.`Product_sales` (`sale_id`, `product_id`, `quantity`, `value`) VALUES
(1, 1, 1, 10),
(2, 1, 2, 100),
(3, 2, 1, 50),
(4, 3, 2, 100),
(4, 4, 1, 50),
(5, 5, 1, 100),
(6, 1, 2, 50),
(7, 2, 1, 200);

INSERT INTO `Jeweller`.`Product_returns` (`sale_id`, `product_id`, `date`, `quantity`, `value`) VALUES
(1, 1, '2013-11-11', 1, 10);

INSERT INTO `Jeweller`.`Stock` (`product_id`, `quantity`) VALUES
(1, 18),
(2, 8),
(3, 0),
(4, 13),
(5, 19);