diff --git a/README.md b/README.md
index 0462562..42bef96 100644
--- a/README.md
+++ b/README.md
@@ -118,3 +118,139 @@
 # mysql -u root -p
 Input Password
 ```
+
+Apabila telah login selanjutnya buat database, user dan password untuk service PowerDNS.
+
+> ```
+MariaDB [(none)]> Create database testpdns;
+MariaDB [(none)]> grant all privileges on testdns.* to pdns@localhost identified by 'pdnspassword';
+MariaDB [(none)]> flush privileges; 
+```
+
+Setelah itu pilih database testpdns;
+
+> ```
+MariaDB [(none)]>use testpdns;
+MariaDB [testpdns]>
+```
+
+Buat table baru untuk menyimpan record pdns pada database testpdns.
+
+> ```
+MariaDB [testpdns]> CREATE TABLE domains (
+  id                    INT AUTO_INCREMENT,
+  name                  VARCHAR(255) NOT NULL,
+  master                VARCHAR(128) DEFAULT NULL,
+  last_check            INT DEFAULT NULL,
+  type                  VARCHAR(6) NOT NULL,
+  notified_serial       INT UNSIGNED DEFAULT NULL,
+  account               VARCHAR(40) CHARACTER SET 'utf8' DEFAULT NULL,
+  PRIMARY KEY (id)
+) Engine=InnoDB CHARACTER SET 'latin1';
+```
+
+> ```
+MariaDB [testpdns]> CREATE UNIQUE INDEX name_index ON domains(name);
+```
+
+> ```
+MariaDB [testpdns]>CREATE TABLE 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';
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX nametype_index ON records(name,type);
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX domain_id ON records(domain_id);
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX ordername ON records (ordername);
+```
+
+> ```
+MariaDB [testpdns]> CREATE TABLE supermasters (
+  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';
+```
+
+> ```
+MariaDB [testpdns]> CREATE TABLE 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';
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX comments_name_type_idx ON comments (name, type);
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX comments_order_idx ON comments (domain_id, modified_at);
+```
+
+> ```
+MariaDB [testpdns]> CREATE TABLE domainmetadata (
+  id                    INT AUTO_INCREMENT,
+  domain_id             INT NOT NULL,
+  kind                  VARCHAR(32),
+  content               TEXT,
+  PRIMARY KEY (id)
+) Engine=InnoDB CHARACTER SET 'latin1';
+```
+
+> ```
+MariaDB [testpdns]> CREATE INDEX domainmetadata_idx ON domainmetadata (domain_id, kind);
+```
+
+> ```
+MariaDB [testpdns]> CREATE TABLE 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';
+```
+
+> ```
+MariaDB [testpdns]>CREATE INDEX domainidindex ON cryptokeys(domain_id);
+```
+
+> ```
+MariaDB [testpdns]> CREATE TABLE tsigkeys (
+  id                    INT AUTO_INCREMENT,
+  name                  VARCHAR(255),
+  algorithm             VARCHAR(50),
+  secret                VARCHAR(255),
+  PRIMARY KEY (id)
+) Engine=InnoDB CHARACTER SET 'latin1';
+```
+
+> ```
+MariaDB [testpdns]> CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm);
+```