2014年7月17日 星期四

[Database Design Idea] Designs user table id by unique code rather than by auto_incrementing

Someone designs the appuser table as follows:

appuser_id
candy
abigail
florance
simon
peter
...

rather than
appuser_id
1
2
3
4
5
...

to save the effort on table joining and retrieving. For reference.

2014年7月16日 星期三

2014年7月3日 星期四

[Network] [Port Forwarding] Allow Server Access from External Workstations [Always Failed Stuff]

  1. @ Router, setup port forwarding rule
  2. @ Server, setup firewall rule ( sudo ufw status )