This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
dndwebapp [2020/01/24 18:30] benbigmac [Project Requirements/UseCases] |
dndwebapp [2020/02/28 19:50] chasty2 [Back End Documentation] |
||
---|---|---|---|
Line 18: | Line 18: | ||
==== Project Requirements/UseCases ==== | ==== Project Requirements/UseCases ==== | ||
^ Page ^ requirements ^ Uses ^ | ^ Page ^ requirements ^ Uses ^ | ||
- | | Index/Home Page | Row 1 Col 2 | Row 1 Col 3 | | + | | 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 | | | | + | | 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 Creation | | | | ||
+ | | Character View | | | | ||
| Item Creation | | | | | Item Creation | | | | ||
| Game Creation | | | | | Game Creation | | | | ||
+ | | Chat Room | | | | ||
+ | |||
===== Documentation===== | ===== Documentation===== | ||
==== Front End Documentation==== | ==== Front End Documentation==== | ||
==== Back End Documentation==== | ==== Back End Documentation==== | ||
+ | __ | ||
+ | Database schema, version 2: | ||
+ | __ | ||
+ | |||
+ | **one baseStats per charSheet | ||
+ | |||
+ | {{:dnd_db_v2.jpg?nolink&400|}} | ||
+ | |||
+ | __ | ||
+ | Docker Notes: | ||
+ | __ | ||
+ | <code bash> | ||
+ | ## 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 | ||
+ | </code> | ||
===== Meeting Notes===== | ===== Meeting Notes===== | ||
==== Meeting 1 [11/09/2018]==== | ==== Meeting 1 [11/09/2018]==== |