NODE_ENV = <production/development>
PORT = 5000
JWT_KEY = <your secret key>

SEQUELIZE_URL = mssql://<user>:<password>@<host>:<port>/<database>

ALTER TABLE [dbo].[Character]
ADD
  [HOFWins] [int] NOT NULL DEFAULT(0);

ALTER TABLE [dbo].[MEMB_INFO]
ADD
  [jwt_token] [varchar](255) NULL,
  [admin_lvl] [int] NOT NULL DEFAULT(0),
  [reg_ip] [varchar](30) NULL;

CREATE TABLE [dbo].[_nyxConfig](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](50) NULL,
	[value] [text] NULL
);

docker-machine rm default

docker-machine create -d virtualbox --virtualbox-cpu-count=2 --virtualbox-memory=4096 --virtualbox-disk-size=50000 default

docker-machine stop

version: '3'
services:
  client:
    build:
      context: ./client
      dockerfile: Dockerfile
    image: nyx/client
    ports:
      - '80:80'
    depends_on:
      - server
    container_name: nyxweb_client
  server:
    build:
      context: ./server
      dockerfile: Dockerfile
    image: nyx/server
    ports:
      - '2000:80'
    networks:
      - nyx
    depends_on:
      - db
    container_name: nyxweb_server
  db:
    build:
      context: ./server
      dockerfile: Dockerfile-db
    image: nyx/db
    ports:
      - '1433:1433'
    networks:
      - nyx
    container_name: nyxweb_db
networks:
  nyx:
    external: true

docker network create nyx

docker-compose up --build -d

docker-compose down

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=thepassword.is1" -e "MSSQL_PID=Express" --name nyxweb_db -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest

docker exec -it nyxweb_db mkdir /var/opt/mssql/backup

docker cp "D:\MuOnline.bak" nyxweb_db:/var/opt/mssql/backup

docker exec -it nyxweb_db /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "thepassword.is1" -Q "RESTORE DATABASE MuOnline FROM DISK = '/var/opt/mssql/backup/MuOnline.bak' WITH MOVE 'MuOnline_Data' TO '/var/opt/mssql/data/MuOnline.mdf', MOVE 'MuOnline_Log' TO '/var/opt/mssql/data/MuOnline_Log.ldf'"