dndwebapp
Differences
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/02/21 21:29] chasty2 [Back End Documentation] |
dndwebapp [2020/02/28 19:50] chasty2 [Back End Documentation] |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| Database schema, version 2: | Database schema, version 2: | ||
| __ | __ | ||
| + | |||
| + | **one baseStats per charSheet | ||
| {{:dnd_db_v2.jpg?nolink&400|}} | {{:dnd_db_v2.jpg?nolink&400|}} | ||
| Line 39: | Line 41: | ||
| Docker Notes: | Docker Notes: | ||
| __ | __ | ||
| + | <code bash> | ||
| ## Enter these commands in bash on a Linux environment. | ## Enter these commands in bash on a Linux environment. | ||
| + | |||
| ## Pull mysql 5.7 docker image (mysql 8 works, but a bugfix is needed). | ## Pull mysql 5.7 docker image (mysql 8 works, but a bugfix is needed). | ||
| + | |||
| docker pull mysql:5.7 | docker pull mysql:5.7 | ||
| - | ## Insert firewall rule for docker container and save. | + | ## 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. |
| - | ## NOTE: Docker daemon must be started after iptables is running. | + | |
| - | ## NOTE: 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 | iptables -A INPUT -i docker0 -p tcp -m tcp --dport 3306 -j ACCEPT | ||
| + | |||
| service iptables save | service iptables save | ||
| ## create and start docker image | ## 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 | docker run -d --name=lugdb -e MYSQL_ROOT_PASSWORD=test -e MYSQL_DATABASE=lugdb -p 3306:3306 mysql:5.7 | ||
| ## enter container | ## enter container | ||
| + | |||
| docker exec -it lugdb -p | docker exec -it lugdb -p | ||
| ## (in mysql) Create accounts table. | ## (in mysql) Create accounts table. | ||
| + | |||
| use lugdb | use lugdb | ||
| - | CREATE TABLE account( | + | |
| - | id INT NOT NULL AUTO_INCREMENT, | + | 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)); |
| - | accountName VARCHAR(20) NOT NULL, | + | |
| - | password VARCHAR(100) NOT NULL, | + | |
| - | email VARCHAR(254) NOT NULL, | + | |
| - | PRIMARY KEY ( id ) | + | |
| - | ); | + | |
| ## (in mysql) Show table. | ## (in mysql) Show table. | ||
| + | |||
| SELECT * from account; | SELECT * from account; | ||
| ## (in myqsl) Exit the container. | ## (in myqsl) Exit the container. | ||
| + | |||
| quit | quit | ||
| + | </code> | ||
| ===== 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
