endrik-exe

## 0-readme.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                endrik-exe
                / 0-readme.md
            
            
              Last active
              January 30, 2024 20:27
            
              
                Patch chrome-remote-desktop to use DISPLAY 0 - 2023 Version
              
          
    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

  
## duplicate_database.sql
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

## resetterdb.sql
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;
	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
	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;