Skip to content

Instantly share code, notes, and snippets.

@gogl92
Created January 8, 2018 17:15
Show Gist options
  • Save gogl92/dcfa808970f98b4419e4100a904247bd to your computer and use it in GitHub Desktop.
Save gogl92/dcfa808970f98b4419e4100a904247bd to your computer and use it in GitHub Desktop.
Service Columns
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
ALTER TABLE `database`.`table`
ADD COLUMN `deleted_at` DATETIME NULL DEFAULT NULL AFTER `observaciones`,
ADD COLUMN `created_at` DATETIME NULL DEFAULT NULL AFTER `deleted_at`,
ADD COLUMN `updated_at` DATETIME NULL DEFAULT NULL AFTER `created_at`,
ADD COLUMN `deleted_by` INT(11) NULL DEFAULT NULL AFTER `updated_at`,
ADD COLUMN `created_by` INT(11) NULL DEFAULT NULL AFTER `deleted_by`,
ADD COLUMN `updated_by` INT(11) NULL DEFAULT NULL AFTER `created_by`;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment