Created
October 18, 2018 16:52
-
-
Save LeoFalco/e27419019c4408021e9e804fb738b906 to your computer and use it in GitHub Desktop.
deleta notas
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update consumo set id_consumo_juncao = null | |
where id_consumo_juncao is not null; | |
delete from consumo_item; | |
update nota_item SET ID_ITEM_PAI = null | |
where ID_ITEM_PAI is not null; | |
delete from nota_item; | |
delete from consumo; | |
delete from nota_finalizadora; | |
delete from consumo_mapa; | |
delete from nota; | |
ALTER TABLE nota_item AUTO_INCREMENT = 1; | |
ALTER TABLE nota_finalizadora AUTO_INCREMENT = 1; | |
ALTER TABLE nota AUTO_INCREMENT = 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment