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:32] 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. | ||
Line 46: | Line 48: | ||
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 | ||
Line 68: | Line 66: | ||
use lugdb | use lugdb | ||
- | CREATE TABLE account( | + | 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)); |
- | 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. | ## (in mysql) Show table. | ||
Line 83: | Line 75: | ||
quit | quit | ||
+ | </code> | ||
===== Meeting Notes===== | ===== Meeting Notes===== | ||
==== Meeting 1 [11/09/2018]==== | ==== Meeting 1 [11/09/2018]==== |