cek tools.php utk buat coding tools database

query yg digunakan sementara



SELECT * FROM information_schema.tables
WHERE table_schema = 'isnet-venom';

-- 
SELECT CONCAT('truncate ',table_name,';')FROM information_schema.tables
WHERE table_schema = 'isnet-venom' AND table_type = 'base table' AND table_name LIKE 'tx%';

SELECT CONCAT('truncate ',table_name,';')FROM information_schema.tables
WHERE table_schema = 'isnet-venom' AND table_type = 'base table' AND table_name LIKE 'tl%'
	AND table_name != 'tlabsen' AND table_name != 'tlallowance_type' AND table_name != 'tlabsen' AND table_name != 'tlaplication'
	AND table_name != 'tlasset_category' AND table_name != 'tlbranch' AND table_name != 'tlbranch_group' AND table_name != 'tlbranch_type' 	
	AND table_name != 'tlcoa' AND table_name != 'tlcoa_group' AND table_name != 'tlcoa_setting' AND table_name != 'tlcoa_subgroup' 
	AND table_name != 'tlday'AND table_name != 'tldepartment' AND table_name != 'tleducation' AND table_name != 'tlgroup_pengajian'
	AND table_name != 'tlholiday' AND table_name != 'tlkategory_perkiraan' AND table_name != 'tlleave_type' AND table_name != 'tlmenu'
	AND table_name != 'tlnotes_type' AND table_name != 'tloutsource_type' AND table_name != 'tlovertime' AND table_name != 'tlpph21'
	AND table_name != 'tlrating' AND table_name != 'tlreligion' AND table_name != 'tlreport' AND table_name != 'tlsalary'
	AND table_name != 'tlsalary_category' AND table_name != 'tlsales_type' AND table_name != 'tlsecurity' AND table_name != 'tlsecurity_setting'
	AND table_name != 'tlstock_type' AND table_name != 'tltype_form' AND table_name != 'tluom' AND table_name != 'tluser'
	AND table_name != 'tluser_access' AND table_name != 'tluser_access_setting' AND table_name != 'tluser_group' AND table_name != 'tluser_group_access'
	
TRUNCATE thsaldoperkiraan;
	
SELECT * FROM tluser;
DELETE FROM tluser WHERE ftusername != 'admin';
ALTER TABLE tluser AUTO_INCREMENT = 2;


SELECT * FROM tluser_access ORDER BY fnid;
DELETE FROM tluser_access WHERE ftusername != 'admin';
ALTER TABLE tluser_access AUTO_INCREMENT = 2000;

SELECT * FROM tluser_access_setting ORDER BY fnid;
DELETE FROM tluser_access_setting WHERE ftusername != 'admin';
ALTER TABLE tluser_access_setting AUTO_INCREMENT = 10;




	