26-07-2021, 04:10 PM
Para borrar todas las categorías y productos abre el fichero C:\SYSME\SGC\actualizabdsysme.txt y copia este script:
delete from pack;
delete from tipo_comg_comg;
delete from pnotacocina;
delete from pproveedor;
delete from productoimg;
delete from productoimgs;
delete from comg_tarifa;
delete from combinados;
delete from variaciones;
delete from almacen_complementg;
delete from opencart_comg;
delete from opencart_tipo_comg;
delete from inventario_complementog;
delete from traspasos_complementog;
delete from complementog;
delete from tipo_comg;
Guarda el fichero y reinicia Sysme Tpv.
delete from pack;
delete from tipo_comg_comg;
delete from pnotacocina;
delete from pproveedor;
delete from productoimg;
delete from productoimgs;
delete from comg_tarifa;
delete from combinados;
delete from variaciones;
delete from almacen_complementg;
delete from opencart_comg;
delete from opencart_tipo_comg;
delete from inventario_complementog;
delete from traspasos_complementog;
delete from complementog;
delete from tipo_comg;
Guarda el fichero y reinicia Sysme Tpv.