Differences

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

--- dndwebapp [2020/01/24 21:57]
benbigmac [Project Requirements/UseCases]
+++ dndwebapp [2020/02/28 19:50]
chasty2 [Back End Documentation]
@@ Line 30: / Line 30: @@
 ==== Front 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 1 [11/09/2018]====

LUG @ UIC