Skip to content

Instantly share code, notes, and snippets.

#!/bin/sh
set -e
# Docker CE for Linux installation script
#
# See https://docs.docker.com/engine/install/ for the installation steps.
#
# This script is meant for quick & easy install via:
# $ curl -fsSL https://get.docker.com -o get-docker.sh
# $ sh get-docker.sh
#
@spartan
spartan / mysql_table_suffix_columns.sql
Last active August 20, 2019 04:50
MySQL Table suffix columns
alter table {name}
add column `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
add column `created_by` int(10) unsigned NOT NULL,
add column `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
add column `updated_by` int(10) unsigned DEFAULT NULL,
/* add column `deleted_at` timestamp DEFAULT NULL, */
/* add column `deleted_by` int(10) unsigned DEFAULT NULL, */
add column `status` tinyint(3) unsigned NOT NULL;