DB Population

INSERT INTO `Jeweller`.`Sellers` (`id`, `name`, `address`, `phone`, `email`) VALUES
(123456780, 'Papadopoulos AE', 'Piraeus', '2101234560', '[email protected]'),
(123336781, 'Kostopoulos AE', 'Piraeus', '2103214561', '[email protected]'),
(123477782, 'Petropoulos AE', 'Athens', '2108884562', '[email protected]'),
(111456783, 'Markopoulos AE', 'Keratsini', '2101734563', '[email protected]'),
(123456444, 'Stathopoulos AE', 'Piraeus', '2101554564', '[email protected]');

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);