Joseph Bassey JosephmBassey
JosephmBassey
/ nginx.conf
Last active
March 1, 2020 17:29
An nginx conf for routing sub domain request to different port with ssl support. You can repeat this for as many sites as required, you just defines an additional server block(s) for each site(sub domain). Note that this strategy requires TLS SNI support on both server and client
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| server { | |
| listen 80; | |
| server_name admin.mysite.com www.admin.mysite.com; | |
| } | |
| server{ | |
| location / { | |
| proxy_set_header Host $host; | |
| proxy_pass http://127.0.0.1:3000; | |
| proxy_redirect off; |
JosephmBassey
/ States_and_lga.sql
Last active
April 16, 2020 14:05
Nigeria States and LGAs sql Dump
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Replace with your SQL commands */ | |
| CREATE TABLE lga( | |
| id VARCHAR PRIMARY KEY, | |
| name VARCHAR, | |
| slug VARCHAR, | |
| state_id VARCHAR, | |
| created_at TIMESTAMPTZ DEFAULT NOW(), | |
| updated_at TIMESTAMPTZ DEFAULT NOW() | |
| ); | |
| INSERT INTO lga (id,state_id, name) VALUES |