db

Database Schema

Meta

Using a MySQL implemented by MariaDB. Output of mysql --version on the server:

mysql  Ver 15.1 Distrib 10.0.28-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

The DB name, username, and password are temporarily hard coded in dao.go.

Schema

See the init.sql in this repo's root folder. Sourcing this script in a DB can make a fully functioning environment.

Some comments:

• Passwords are stored and transferred in base64-encoded SHA-256 values.