 ('Weight', '', 't'),
 ('material', '', '');
 
-INSERT INTO `product` (`name`, `description`, `image`, `price`, in_stock) VALUES 
-('Artur_B', 'sjkd ew fwef ', 'data/images/artur_b.jpg', 100, 31), 
-('Artur_R', 'nfjkwen', 'data/images/artur_r.jpg', 150, 15), 
-('Nexin', 'weklmf kewfm ekf', 'data/images/nexin.jpg', 20, 412),
-('C130', 'kfmewfwe', 'data/images/c130.jpg', 20000, 14),
-('R8', 'weklmf kewfefwm ekf', 'data/images/r8.jpg', 200000, 2);
+INSERT INTO `product` (`name`, `slug`, `description`, `image`, `price`, in_stock) VALUES 
+('Artur_B', 'artur_b', 'sjkd ew fwef ', 'data/images/artur_b.jpg', 100, 31), 
+('Artur_R', 'artur_r', 'nfjkwen', 'data/images/artur_r.jpg', 150, 15), 
+('Nexin', 'nexin', 'weklmf kewfm ekf', 'data/images/nexin.jpg', 20, 412),
+('C130', 'c130', 'kfmewfwe', 'data/images/c130.jpg', 20000, 14),
+('R8', 'r8', 'weklmf kewfefwm ekf', 'data/images/r8.jpg', 200000, 2);
 
 INSERT INTO `type_properties` VALUES 
 (1, 1, 'Black'), 

   PRIMARY KEY (product_id, customer_id)
);

CREATE TABLE ordered_products
(
   product_id     integer not null,
   order_id       integer not null,
   quantity       integer not null,
   FOREIGN KEY (product_id) REFERENCES product(product_id),
   PRIMARY KEY (order_id)
);

CREATE TABLE shipping
(
   shipping_id    integer not null,

(2, 2, 'je to somarina', 10, '2015-09-06 07:14:31'); 


INSERT INTO `pyngshop`.`shipping` (`shipping_id`, `name`, `price`) VALUES 
('1', 'PPL', '129'), 
('2', 'Czech Post', '99');



