Changeset View
Changeset View
Standalone View
Standalone View
docker/mariadb/mysql-init/setup.sh
- This file was added.
Property | Old Value | New Value |
---|---|---|
File Mode | null | 100755 |
#!/bin/bash | |||||
MYSQL_PWD=$MARIADB_ROOT_PASSWORD mysql --protocol=socket -uroot -hlocalhost --socket="/run/mysqld/mysqld.sock" << EOF | |||||
CREATE DATABASE IF NOT EXISTS ${DB_HKCCP_DATABASE}; | |||||
CREATE USER '${DB_HKCCP_USERNAME}'@'%' IDENTIFIED BY '${DB_HKCCP_PASSWORD}'; | |||||
GRANT ALL PRIVILEGES ON ${DB_HKCCP_DATABASE}.* TO '${DB_HKCCP_USERNAME}'@'%' IDENTIFIED BY '${DB_HKCCP_PASSWORD}'; | |||||
FLUSH PRIVILEGES; | |||||
EOF | |||||
# Powerdns setup according to https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/schema.mysql.sql | |||||
# Required for the first boot, afterwards the laravel migration will take over. | |||||
# This is only required so pdns can start cleanly, indexes etc are handled by the laravel migration. | |||||
MYSQL_PWD=$MARIADB_ROOT_PASSWORD mysql --protocol=socket -uroot -hlocalhost --socket="/run/mysqld/mysqld.sock" ${DB_HKCCP_DATABASE} << EOF | |||||
CREATE TABLE powerdns_domains ( | |||||
id INT AUTO_INCREMENT, | |||||
name VARCHAR(255) NOT NULL, | |||||
master VARCHAR(128) DEFAULT NULL, | |||||
last_check INT DEFAULT NULL, | |||||
type VARCHAR(8) NOT NULL, | |||||
notified_serial INT UNSIGNED DEFAULT NULL, | |||||
account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL, | |||||
options VARCHAR(64000) DEFAULT NULL, | |||||
catalog VARCHAR(255) DEFAULT NULL, | |||||
PRIMARY KEY (id) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
CREATE TABLE powerdns_records ( | |||||
id BIGINT AUTO_INCREMENT, | |||||
domain_id INT DEFAULT NULL, | |||||
name VARCHAR(255) DEFAULT NULL, | |||||
type VARCHAR(10) DEFAULT NULL, | |||||
content VARCHAR(64000) DEFAULT NULL, | |||||
ttl INT DEFAULT NULL, | |||||
prio INT DEFAULT NULL, | |||||
disabled TINYINT(1) DEFAULT 0, | |||||
ordername VARCHAR(255) BINARY DEFAULT NULL, | |||||
auth TINYINT(1) DEFAULT 1, | |||||
PRIMARY KEY (id) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
CREATE TABLE powerdns_masters ( | |||||
ip VARCHAR(64) NOT NULL, | |||||
nameserver VARCHAR(255) NOT NULL, | |||||
account VARCHAR(40) CHARACTER SET 'utf8' NOT NULL, | |||||
PRIMARY KEY (ip, nameserver) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
CREATE TABLE powerdns_comments ( | |||||
id INT AUTO_INCREMENT, | |||||
domain_id INT NOT NULL, | |||||
name VARCHAR(255) NOT NULL, | |||||
type VARCHAR(10) NOT NULL, | |||||
modified_at INT NOT NULL, | |||||
account VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL, | |||||
comment TEXT CHARACTER SET 'utf8' NOT NULL, | |||||
PRIMARY KEY (id) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
CREATE TABLE powerdns_cryptokeys ( | |||||
id INT AUTO_INCREMENT, | |||||
domain_id INT NOT NULL, | |||||
flags INT NOT NULL, | |||||
active BOOL, | |||||
published BOOL DEFAULT 1, | |||||
content TEXT, | |||||
PRIMARY KEY(id) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
CREATE TABLE powerdns_tsigkeys ( | |||||
id INT AUTO_INCREMENT, | |||||
name VARCHAR(255), | |||||
algorithm VARCHAR(50), | |||||
secret VARCHAR(255), | |||||
PRIMARY KEY (id) | |||||
) Engine=InnoDB CHARACTER SET 'latin1'; | |||||
EOF |