-- Host: 127.0.0.1 -- Generation Time: Nov 19, 2018 at 03:25 PM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.2.3

SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */;

CREATE DATABASE IF NOT EXISTS lab_webshop DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE lab_webshop;

CREATE TABLE tbl_basket ( id int(11) NOT NULL, id_item int(11) NOT NULL, quantity int(11) NOT NULL, id_cookie int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbl_cookie ( id int(11) NOT NULL, cookie_user varchar(200) NOT NULL, id_user int(11) NOT NULL, logged_in tinyint(1) NOT NULL, expiration_date datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbl_items ( id int(11) NOT NULL, title varchar(100) NOT NULL, price int(11) NOT NULL, description varchar(100) NOT NULL, stock int(11) NOT NULL, image varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbl_orders ( id int(11) NOT NULL, quantity int(11) NOT NULL, price int(11) NOT NULL, id_item int(11) NOT NULL, id_user int(11) NOT NULL, order_date datetime NOT NULL, total_price int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbl_user ( id int(11) NOT NULL, name varchar(100) NOT NULL, address varchar(100) NOT NULL, phone varchar(100) NOT NULL, email varchar(100) NOT NULL, password varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE tbl_basket ADD PRIMARY KEY (id), ADD KEY id_cookie (id_cookie);

ALTER TABLE tbl_cookie ADD PRIMARY KEY (id), ADD KEY id_user (id_user);

ALTER TABLE tbl_items ADD PRIMARY KEY (id);

ALTER TABLE tbl_orders ADD PRIMARY KEY (id), ADD KEY id_item (id_item), ADD KEY tbl_orders_ibfk_1 (id_user);

ALTER TABLE tbl_user ADD PRIMARY KEY (id);

ALTER TABLE tbl_basket MODIFY id int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE tbl_cookie MODIFY id int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE tbl_items MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

ALTER TABLE tbl_orders MODIFY id int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE tbl_user MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

ALTER TABLE tbl_basket ADD CONSTRAINT tbl_basket_ibfk_1 FOREIGN KEY (id_cookie) REFERENCES tbl_cookie (id);

ALTER TABLE tbl_cookie ADD CONSTRAINT tbl_cookie_ibfk_1 FOREIGN KEY (id_user) REFERENCES tbl_user (id);

ALTER TABLE tbl_orders ADD CONSTRAINT tbl_orders_ibfk_1 FOREIGN KEY (id_user) REFERENCES tbl_user (id); SET FOREIGN_KEY_CHECKS=1; COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;