Show sourcecode
The following files exists in this folder. Click to view.
webbserverprogrammering/projects/slutprojekt/setup/
dbsetup.php
dbsetup.sql
dump.sql
show_tables.php
dbsetup.sql
63 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
CREATE DATABASE IF NOT EXISTS antonlm;
USE antonlm;
-- Tabell för vanliga användare
CREATE TABLE IF NOT EXISTS slutprojekt_hungry_users (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(320) NOT NULL,
phonenumber VARCHAR(17) NOT NULL, -- Ändrat från INT(17)
password VARCHAR(255) NOT NULL,
reg_date DATETIME DEFAULT CURRENT_TIMESTAMP,
latest_login DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
login_token VARCHAR(255)
);
-- Tabell för restauranger
CREATE TABLE IF NOT EXISTS slutprojekt_restaurants (
id INT AUTO_INCREMENT PRIMARY KEY,
restaurant_name VARCHAR(255) NOT NULL,
restaurant_enabled TINYINT(1) NOT NULL,
logotype_url VARCHAR(255)
);
-- Tabell för produkter
CREATE TABLE IF NOT EXISTS slutprojekt_menu_items (
id INT AUTO_INCREMENT PRIMARY KEY,
restaurant_id INT NOT NULL,
item_name VARCHAR(50) NOT NULL,
item_description TEXT NOT NULL,
item_price DECIMAL(10,2) NOT NULL, -- Ändrat från INT
item_enabled TINYINT(1) NOT NULL DEFAULT 1,
item_image VARCHAR(255),
FOREIGN KEY (restaurant_id) REFERENCES slutprojekt_restaurants(id) ON DELETE CASCADE
);
-- Tabell för beställningar
CREATE TABLE IF NOT EXISTS slutprojekt_orders (
id INT AUTO_INCREMENT PRIMARY KEY,
item_id INT NOT NULL,
customer_id INT NOT NULL,
restaurant_id INT NOT NULL,
status VARCHAR(255),
price DECIMAL(10,2) NOT NULL, -- Ändrat från INT
token VARCHAR(255),
FOREIGN KEY (item_id) REFERENCES slutprojekt_menu_items(id) ON DELETE CASCADE,
FOREIGN KEY (customer_id) REFERENCES slutprojekt_hungry_users(id) ON DELETE CASCADE,
FOREIGN KEY (restaurant_id) REFERENCES slutprojekt_restaurants(id) ON DELETE CASCADE
);
-- Tabell för restauranganvändare
CREATE TABLE IF NOT EXISTS slutprojekt_restaurant_users (
id INT AUTO_INCREMENT PRIMARY KEY,
restaurant_id INT NOT NULL,
email VARCHAR(320),
password VARCHAR(255) NOT NULL,
FOREIGN KEY (restaurant_id) REFERENCES slutprojekt_restaurants(id) ON DELETE CASCADE
);
-- Tabell för admin
CREATE TABLE IF NOT EXISTS slutprojekt_admin_users (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(320) NOT NULL,
password VARCHAR(255) NOT NULL
);