User Tools

Site Tools


dndwebapp

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
dndwebapp [2019/09/25 02:46]
benbigmac
dndwebapp [2020/02/21 21:36]
chasty2 [Back End Documentation]
Line 16: Line 16:
  
 ===== Project Structure===== ===== Project Structure=====
 +==== Project Requirements/​UseCases ====
 +^ Page      ^ requirements ​      ^ Uses         ^
 +| Index/Home Page    | Clean friendly design, good color balance ​    | A landing page which'​ll allow people to understand what the app is and register/​login ​      |
 +| Account Creation ​   | easy to navigate with data fields containing tooltips to aid in entering data| allows new users of the app to register accounts ​ |
 +| Profile View   ​| ​    ​| ​        |
 +| Character Creation ​   |     ​| ​        |
 +| Character View    |     ​| ​        |
 +| Item Creation ​   |     ​| ​        |
 +| Game Creation ​   |     ​| ​        |
 +| Chat Room    |     ​| ​        |
 +
 ===== Documentation===== ===== Documentation=====
 ==== Front End Documentation==== ==== Front End Documentation====
 ==== Back End Documentation==== ==== Back End Documentation====
 +__
 +Database schema, version 2:
 +__
 +
 +{{:​dnd_db_v2.jpg?​nolink&​400|}}
 +
 +__
 +Docker Notes:
 +__
 +
 +## Enter these commands in bash on a Linux environment.
 +
 +## Pull mysql 5.7 docker image (mysql 8 works, but a bugfix is needed).
 +
 +docker pull mysql:5.7
 +
 +## Insert iptables firewall rule for docker container at port 3306 and save. Note that the docker daemon must be started after iptables is running. If iptables or a firewall is not running this is not necessary. ​
 +
 +iptables -A INPUT -i docker0 -p tcp -m tcp --dport 3306 -j ACCEPT
 +
 +service iptables save
 +
 +## create and start docker image
 +
 +docker run -d --name=lugdb -e MYSQL_ROOT_PASSWORD=test -e MYSQL_DATABASE=lugdb -p 3306:3306 mysql:5.7
 +
 +## enter container
 +
 +docker exec -it lugdb -p
 +
 +## (in mysql) Create accounts table.
 +
 +use lugdb
 +
 +CREATE TABLE account(id INT NOT NULL AUTO_INCREMENT,​ accountName VARCHAR(20) NOT NULL, password VARCHAR(100) NOT NULL, email VARCHAR(254) NOT NULL, PRIMARY KEY (id));
 +
 +## (in mysql) Show table.
 +
 +SELECT * from account;
 +
 +## (in myqsl) Exit the container.
 +
 +quit
 ===== Meeting Notes===== ===== Meeting Notes=====
 ==== Meeting 1 [11/​09/​2018]==== ==== Meeting 1 [11/​09/​2018]====
dndwebapp.txt ยท Last modified: 2020/02/28 21:11 by chasty2