Kent Johnson kentoj

#Create bitbucket branch

##Create local branch

$ git checkout -b sync
Switched to a new branch 'sync'
$ git branch
  master
* sync

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

Setup Mac OS X

I'm in a hospital in Spain and my MacBook was stolen.

Now I bought a new one and need to configure it. I have an external hard drive that backup everything using Time Machine, but I don't want all the crap I had in the old one.

1. Run Software Update

Safest way to clean up boot partition - Ubuntu 14.04LTS-x64, Ubuntu 16.04LTS-x64

Reference

Case I: if /boot is not 100% full and apt is working

1. Check the current kernel version

$ uname -r

	-- Retrieve descendants
	-- ====================
	-- retrieve descendants of #4

	SELECT c.*
	FROM Comments AS c
	JOIN TreePaths AS t ON c.comment_id = t.descendant
	WHERE t.ancestor = 4;

	-- Retrieve ancestors