dndwebapp
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dndwebapp [2018/11/29 20:17] benbigmac |
dndwebapp [2020/02/21 21:35] chasty2 [Back End Documentation] |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| ==== Project Leads==== | ==== Project Leads==== | ||
| ^ Position ^ Name ^ Email ^ | ^ Position ^ Name ^ Email ^ | ||
| - | ^ **Project Lead/Manager:** | Misha Ryabko | mryabk2@uic.edu | | + | ^ **Project Lead/Manager:** | Amy Ngo | | |
| - | ^ **Front End Lead** | Josh Castor (Senior Technical Officer) | joshua.castor@joshuacastor.me | | + | ^ **Alumni Project Advisor** | Bennett Maciorowski (LUG Alumni Advisor| bennettmaciorowski@gmail.com | |
| - | ^ **Back End Lead** | Brent Yurek (Senior Technical Officer) | | | + | ^ **Alumni Project Advisor** | Josh Castor (Senior Technical Officer) | joshua.castor@joshuacastor.me | |
| + | ^ **Alumni Project Advisor** | Will Toher| | | ||
| ==== Participants==== | ==== Participants==== | ||
| Line 15: | 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 firewall rule for docker container 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
