a:1:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:31:"fv2_shipping_doship_doit_import";s:4:"nome";s:9:"onExecute";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:802:"$clear_table = 'Truncate table doship';
$import_table = "Insert into doship select * from veratex2.doship";
sc_exec_sql($clear_table);
sc_exec_sql($import_table);
$clear_table = 'Truncate table doit';
$import_table = "Insert into doit select * from veratex2.doit";
sc_exec_sql($clear_table);
sc_exec_sql($import_table);
//$clean_doit="
//DELETE FROM 
//	fairlanevrtx2.doit
//WHERE 
//	LEFT(style,1)='V'
//OR
// 	LEFT(style,4)='4018'
//OR 
//	LEFT(style,4)='5034'
//";
//sc_exec_sql($clean_doit);	
//$clean_doit="
//DELETE FROM 
//WHERE 
//	SM NOT IN (SELECT f.sm 
//                        FROM doit f)";
//sc_exec_sql($clean_doit);
//$update_doship="
//UPDATE
//	fairlanevrtx2.doship
//SET
//	status='$'
//";
//sc_exec_sql($update_doship);
echo "Tables Initialized.";
";}}