 ('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'), 

   email          varchar(255)  not null,
   address_1      varchar(255)  not null,
   address_2      varchar(255)  not null,
   telephone      numeric(20),
   city           varchar(255)  not null,
   state          varchar(255)  not null,
   postal_code    numeric(20)   not null,


CREATE TABLE customer_order
(
   order_id       integer not null auto_increment,
   customer_id    integer not null,
   shipping_id    integer not null,
   timestamp      date    not null,
   status          varchar(255) not null,
   full_price     integer(11) not null,
   FOREIGN KEY (customer_id) REFERENCES customer(customer_id),
   FOREIGN KEY (shipping_id) REFERENCES shipping(shipping_id),
   PRIMARY KEY (order_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),
   FOREIGN KEY (order_id) REFERENCES customer_order(order_id),
   PRIMARY KEY (order_id, product_id)
);

CREATE TABLE settings
