bWqMrsk0

1FROM postgres:10.1
2
3COPY init-db.sh /docker-entrypoint-initdb.d/init-db.sh
4	
5#!/bin/bash
6set -e
7
8psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
9    CREATE DATABASE foodb;
10
11    c foodb;
12    DROP TABLE IF EXISTS users;
13
14CREATE TABLE users (
15    id SERIAL,
16    username VARCHAR(25) NOT NULL,
17    pw VARCHAR(128) NOT NULL,
18    super INT NOT NULL DEFAULT 0,
19    PRIMARY KEY (id)
20  );
21
22CREATE UNIQUE INDEX users_username ON users (username);
23
24INSERT INTO users (username, pw) 
25VALUES ('jjolie', 
26        'PBKDF2$sha256$901$x8mf3JIFTUFU9C23$ic9J6mFDSz0rETKux/Co9TzCPOX50j+V8Vky5GkY5v0=');
27	
28docker exec -it postgres_1 bash
29psql -U postgres
30c foodb
31select * from users;
32	
33id | username |                   pw                    | super
34----+----------+-----------------------------------------+-------
35  1 | jjolie   | PBKDF201/Co9TzCPOX50j+V8Vky5GkY5v0=     |     0