Skip to content

Instantly share code, notes, and snippets.

@cesarAugusto1994

cesarAugusto1994/AlterTables.sql

Created January 25, 2016 15:51
Show Gist options
  • Save cesarAugusto1994/0b77435c33090714421a to your computer and use it in GitHub Desktop.
Save cesarAugusto1994/0b77435c33090714421a to your computer and use it in GitHub Desktop.
Download ZIP
Alteração nas tabelas para criação de log
Raw
AlterTables.sql
ALTER TABLE webpdv.produto
ADD COLUMN id_usuario_alteracao INT,
ADD COLUMN data_alteracao DATETIME;
ALTER TABLE webpdv.produto_campo_livre
ADD COLUMN id_usuario_alteracao INT,
ADD COLUMN data_alteracao DATETIME;
ALTER TABLE webpdv.produto_caracteristica
ADD COLUMN id_usuario_alteracao INT,
ADD COLUMN data_alteracao DATETIME;
ALTER TABLE webpdv.produto_sped
ADD COLUMN id_usuario_alteracao INT,
ADD COLUMN data_alteracao DATETIME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment