Skip to content

Instantly share code, notes, and snippets.

View gitlab_jira_integration.md
@spartan
spartan / mysql_table_suffix_columns.sql
Last active Aug 20, 2019
MySQL Table suffix columns
View mysql_table_suffix_columns.sql
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;