-
Create database
CREATE DATABASE demo;
-
Create table users
CREATE TABLE users( user_id INT PRIMARY KEY AUTO_INCREMENT, user_name VARCHAR(100), user_email VARCHAR(100), user_password VARCHAR(200), user_created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=INNODB;
-
Create table promotions
CREATE TABLE promotions( promotion_id INT PRIMARY KEY AUTO_INCREMENT, promotion_code VARCHAR(100), phone VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=INNODB;
composer install --ignore-platform-reqs
php spark serve
- start with port: php spark serve --port 8081