fiee

CREATE TABLE adressen.land
(
	isocode_2 character(2) not null, -- ISO 3166 ALPHA-2
	isocode_3 character(3) not null, -- ISO 3166 ALPHA-3
	name character varying not null, -- deutscher Name des Landes (international besser via ISO-Code ankoppeln!) // German name of the country
	vorwahl integer default null, -- internationale Vorwahl // international phone code
	null_bei_vorwahl boolean default FALSE, -- muss man die Null der Ortsvorwahl auch nach der internationalen Vorwahl wählen? // must one dial zero between international and local phone code?
	vorwahl_lokal boolean default FALSE, -- muss man vor Ort die Vorwahl wählen? // must one dial the local phone code also locally?
	tld character varying default NULL, -- Top Level Domain
	kfz character varying default NULL, -- KFZ-Kennzeichen // car code

adhipg

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

leommoore

#Nginx Basics for Ubuntu

Please see http://wiki.nginx.org/Main for more information. See http://arstechnica.com/gadgets/2012/11/how-to-set-up-a-safe-and-secure-web-server/ for a tutorial on how to install Nginx.

##Installation To install, you can install the version which is in the standard Ubuntu repositories but it is normally quite old and will not have the latest security patches. The best way is to update the repositories first:

apt-get update
apt-get install python-software-properties

apt-get upgrade

kimus

UFW

I use Ubuntu’s Uncomplicated firewall because it is available on Ubuntu and it's very simple.

Install UFW

if ufw is not installed by default be sure to install it first.

vickyRuiz

var StrippedString = OriginalString.replace(/(<([^>]+)>)/ig,"");

//From http://css-tricks.com/snippets/javascript/strip-html-tags-in-javascript/

soarez

How to setup your own CA with OpenSSL

For educational reasons I've decided to create my own CA. Here is what I learned.

First things first

Lets get some context first.

Iman

#!/bin/sh

#Check the Drive Space Used by Cached Files
du -sh /var/cache/apt/archives

#Clean all the log file
#for logs in `find /var/log -type f`;  do > $logs; done

logs=`find /var/log -type f`
for i in $logs

x3rAx

# +----------------------------+
# |         IDE files          |
# +----------------------------+
/.idea


# +----------------------------+
# |          Vagrant           |
# +----------------------------+
/.vagrant

sam-artuso

Setting up Babel and nodemon

Inital set-up

Set up project:

mkdir project
cd project
npm init -y

trandaison

Note: This is the guide for v 2.x.

For the v3, please follow this url: https://blog.csdn.net/sam_shan/article/details/80585240 Thanks @liy-cn for contributing.

StarUML

Download: StarUML.io

Crack

Source: jorgeancal