Ivan Aranda zendo108

Virtual Hosts

Update the hosts file in /etc/hosts to maintain multiple domains/hostnames on a local machine for 127.0.0.1 and setup a VirtualHost container in /Applications/MAMP/conf/apache/extra/httpd-vhost.conf via /Applications/MAMP/conf/apache/httpd.conf for a name-based virtual host.

Related tutorial: http://osxdaily.com/2012/08/07/edit-hosts-file-mac-os-x/
Documentation: http://httpd.apache.org/docs/2.2/vhosts/

Only suitable for MAMP users under OS X Lion, OS X Mountain Lion, and OS X Mavericks on Apache-Port 80 and MySQL-Port 3306.

	#…or create a new repository on the command line
	echo "# pichula" >> README.md
	git init
	git add README.md
	git commit -m "first commit"
	git remote add origin https://github.com/zendo108/pichula.git
	git push -u origin master

	#…or push an existing repository from the command line
	git remote add origin https://github.com/zendo108/pichula.git

	#301 Redirects for .htaccess

	#Redirect a single page:
	Redirect 301 /pagename.php http://www.domain.com/pagename.html

	#Redirect an entire site:
	Redirect 301 / http://www.domain.com/

	#Redirect an entire site to a sub folder
	Redirect 301 / http://www.domain.com/subfolder/

	group: loan example
	description[[ the data for this dataset was generated using <http://www.generatedata.com/>

	* the relation _customers_ contains basic information about the customers of the bank.
	* the relation _account_ contains the basic information of a single account. Note that a customer can
	have any number of accounts.
	* the relation _branch_ branch name and city
	]]

	customer = { name street city

	group: bank example
	description[[ the data for this dataset was generated using <http://www.generatedata.com/>

	* the relation _Customers_ contains basic information about the customers of the bank.
	* the relation _Accounts_ contains the basic information of a single account. Note that a customer can
	have any number of accounts.
	* the relation _PremiumCustomers_ contains the customer-ids of all customers with a total balance over
	1000
	]]

	UPDATE Unit INNER JOIN UnitType
	ON Unit.`UnitType_unit_type_id` = UnitType.`unit_type_id`
	SET Unit.notes = UnitType.unit_type;

	UPDATE Space INNER JOIN SpaceType
	ON Space.`SpaceType_space_type_id` = SpaceType.`space_type_id`
	SET Space.notes = SpaceType.`space_type`

	UPDATE Appliance INNER JOIN AppType
	ON Appliance.`AppType_app_type_id` = AppType.`app_type_id`

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console