client/
: FrontEnd of the project
server/
: BackEnd of the project, sql commands used in backends are mostly in createTable.sql
and routes/
SQL/
: All you need on how to create and load our sample database, as well as test-sample.sql
database/
: Contains the data we use as well as toy data
If first time starting this project, please run npm install
in both frontEnd and backEnd
Inside Command line, Login in MySql and do setup:
mysql -u root -p mysql
CREATE SCHEMA IF NOT EXISTS steamdb;
CREATE USER IF NOT EXISTS 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON steamdb.* TO 'newuser'@'localhost';
Then under the project directory, run ./Run.sh
to start up both backend and frontend
- Posts(Review)
- Comments for the Posts(Review) (Must Login)
- Login
- Register
- Password protection
- JWT Authentication