endrik-exe

Usage

curl -o- https://gist.githubusercontent.com/endrik-exe/69131bd787a3b4cdfd862f971aaa82bc/raw/855ad141ae056c528bac0fd725351c7220c86c53/chrome-remote-desktop.patch | sudo patch /opt/google/chrome-remote-desktop/chrome-remote-desktop
sudo /opt/google/chrome-remote-desktop --stop
sudo /opt/google/chrome-remote-desktop --start

endrik-exe

SELECT @tbl_template := 'vcerp_template', @tbl_target := 'vcerp';

SELECT 'SET FOREIGN_KEY_CHECKS=0;'
UNION
SELECT Concat('DROP TABLE IF EXISTS ', @tbl_target, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = @tbl_template
UNION
SELECT Concat('CREATE TABLE ', @tbl_target, '.', TABLE_NAME, ' LIKE ', @tbl_template, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES

endrik-exe

SELECT * FROm tr_salesorderdetail;
SELECT * FROM tr_salesorderdetailmenu;


SELECT * FROM tr_productionprocesshead;
SELECT * FROM tr_productionprocessdetail;
SELECT * FROM tr_productionprocessformula;

SELECT * FROM tr_stockrequisitionhead;
SELECT * FROM tr_stockrequisitiondetail;