<?php


//=======================================Local========================================================================================

/*
$db_mysql_host="localhost";
$db_mysql_user="root";
$db_mysql_password="root";
$db_mysql_database="pkopitiam";
*/
$db_mysql_host="127.0.0.1";
$db_mysql_user="root";
$db_mysql_password="root";
$db_mysql_database="pcartserver";


$remote_db_mysql_host="127.0.0.1";
$remote_db_mysql_user="root";
$remote_db_mysql_password="root";
$remote_db_mysql_database="pcartserver";





echo $remote_db_mysql_host;
echo "<hr>";


//============Database Connection for MySQL  ============================
$dbconn = mysql_connect($db_mysql_host, $db_mysql_user, $db_mysql_password) or die("Could not connect to Database".mysql_error());


//============Select MySQL Database============================================
mysql_select_db($db_mysql_database) or die ("Database not exist");


unset($local_structure);
$query="SHOW TABLES ";
$result = mysql_query($query);
while($line = mysql_fetch_array($result,MYSQL_ASSOC))
{

    //echo "<b>".$line["Tables_in_sugarbun_pos"]."</b><br>";



    $query_column="describe ".$line["Tables_in_".$db_mysql_database]." ;  ";
    $result_column = mysql_query($query_column);
    while($line_column = mysql_fetch_array($result_column,MYSQL_ASSOC))
    {


       // echo $line_column["Field"];
       // echo " - ";
       // echo $line_column["Field"];
       // echo "<br>";

        $local_structure[$line["Tables_in_".$db_mysql_database]][$line_column["Field"]]=$line_column["Field"];
	   $serialize_string = serialize($local_structure);
	   

    }



}

echo "<textarea>";
echo $serialize_string;
echo "</textarea>";


unset($local_structure);

$serialize_string = 
 'a:66:{s:14:"t_server_addon";a:18:{s:6:"add_id";s:6:"add_id";s:8:"add_code";s:8:"add_code";s:8:"add_name";s:8:"add_name";s:7:"add_uom";s:7:"add_uom";s:9:"add_price";s:9:"add_price";s:11:"add_price_2";s:11:"add_price_2";s:11:"add_price_3";s:11:"add_price_3";s:11:"add_price_4";s:11:"add_price_4";s:11:"add_price_5";s:11:"add_price_5";s:8:"add_cost";s:8:"add_cost";s:12:"add_gst_code";s:12:"add_gst_code";s:11:"add_balance";s:11:"add_balance";s:10:"add_status";s:10:"add_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:25:"t_server_addon_assignment";a:8:{s:6:"asg_id";s:6:"asg_id";s:12:"asg_addon_id";s:12:"asg_addon_id";s:14:"asg_product_id";s:14:"asg_product_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:16:"t_server_balance";a:15:{s:6:"bal_id";s:6:"bal_id";s:18:"bal_warehouse_code";s:18:"bal_warehouse_code";s:16:"bal_warehouse_id";s:16:"bal_warehouse_id";s:16:"bal_product_code";s:16:"bal_product_code";s:14:"bal_product_id";s:14:"bal_product_id";s:9:"bal_color";s:9:"bal_color";s:8:"bal_size";s:8:"bal_size";s:11:"bal_pattern";s:11:"bal_pattern";s:7:"bal_uom";s:7:"bal_uom";s:12:"bal_quantity";s:12:"bal_quantity";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:17:"t_server_category";a:10:{s:6:"cat_id";s:6:"cat_id";s:8:"cat_code";s:8:"cat_code";s:8:"cat_name";s:8:"cat_name";s:11:"cat_sorting";s:11:"cat_sorting";s:10:"cat_status";s:10:"cat_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:26:"t_server_collection_header";a:25:{s:6:"coh_id";s:6:"coh_id";s:9:"device_id";s:9:"device_id";s:10:"coh_coh_id";s:10:"coh_coh_id";s:10:"coh_doc_no";s:10:"coh_doc_no";s:17:"coh_customer_code";s:17:"coh_customer_code";s:17:"coh_customer_name";s:17:"coh_customer_name";s:28:"coh_customer_address_billing";s:28:"coh_customer_address_billing";s:29:"coh_customer_address_delivery";s:29:"coh_customer_address_delivery";s:19:"coh_customer_gst_no";s:19:"coh_customer_gst_no";s:8:"coh_date";s:8:"coh_date";s:15:"coh_description";s:15:"coh_description";s:16:"coh_total_amount";s:16:"coh_total_amount";s:19:"coh_rounding_amount";s:19:"coh_rounding_amount";s:24:"coh_total_amount_rounded";s:24:"coh_total_amount_rounded";s:16:"coh_payment_mode";s:16:"coh_payment_mode";s:16:"coh_payment_text";s:16:"coh_payment_text";s:10:"coh_status";s:10:"coh_status";s:12:"coh_latitude";s:12:"coh_latitude";s:13:"coh_longitude";s:13:"coh_longitude";s:17:"coh_closing_batch";s:17:"coh_closing_batch";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:24:"t_server_collection_item";a:13:{s:6:"coi_id";s:6:"coi_id";s:9:"device_id";s:9:"device_id";s:10:"coi_coi_id";s:10:"coi_coi_id";s:13:"coi_header_id";s:13:"coi_header_id";s:10:"coi_doc_no";s:10:"coi_doc_no";s:14:"coi_pay_doc_no";s:14:"coi_pay_doc_no";s:18:"coi_pay_doc_amount";s:18:"coi_pay_doc_amount";s:10:"coi_status";s:10:"coi_status";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:14:"t_server_color";a:9:{s:6:"clr_id";s:6:"clr_id";s:8:"clr_code";s:8:"clr_code";s:8:"clr_name";s:8:"clr_name";s:10:"clr_status";s:10:"clr_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:17:"t_server_customer";a:29:{s:6:"cus_id";s:6:"cus_id";s:8:"cus_code";s:8:"cus_code";s:8:"cus_name";s:8:"cus_name";s:10:"cus_gst_no";s:10:"cus_gst_no";s:9:"cus_group";s:9:"cus_group";s:10:"cus_status";s:10:"cus_status";s:23:"cus_discount_percentage";s:23:"cus_discount_percentage";s:19:"cus_address_billing";s:19:"cus_address_billing";s:20:"cus_address_delivery";s:20:"cus_address_delivery";s:11:"modified_by";s:11:"modified_by";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:13:"cus_mobile_no";s:13:"cus_mobile_no";s:16:"cus_telephone_no";s:16:"cus_telephone_no";s:10:"cus_fax_no";s:10:"cus_fax_no";s:9:"cus_email";s:9:"cus_email";s:9:"cus_ic_no";s:9:"cus_ic_no";s:14:"cus_start_date";s:14:"cus_start_date";s:12:"cus_latitude";s:12:"cus_latitude";s:13:"cus_longitude";s:13:"cus_longitude";s:16:"cus_credit_block";s:16:"cus_credit_block";s:18:"cus_validity_start";s:18:"cus_validity_start";s:16:"cus_validity_end";s:16:"cus_validity_end";s:10:"cus_gender";s:10:"cus_gender";s:17:"cus_date_of_birth";s:17:"cus_date_of_birth";s:8:"cus_race";s:8:"cus_race";s:8:"cus_zone";s:8:"cus_zone";}s:12:"t_server_dbf";a:9:{s:6:"dbf_id";s:6:"dbf_id";s:13:"dbf_file_path";s:13:"dbf_file_path";s:17:"dbf_customer_path";s:17:"dbf_customer_path";s:16:"dbf_product_path";s:16:"dbf_product_path";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:18:"t_server_dbf_field";a:9:{s:6:"fld_id";s:6:"fld_id";s:8:"fld_name";s:8:"fld_name";s:8:"fld_type";s:8:"fld_type";s:10:"fld_length";s:10:"fld_length";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:26:"t_server_dbf_field_mapping";a:9:{s:6:"map_id";s:6:"map_id";s:16:"map_system_field";s:16:"map_system_field";s:13:"map_dbf_field";s:13:"map_dbf_field";s:19:"map_duplicate_check";s:19:"map_duplicate_check";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:15:"t_server_device";a:11:{s:6:"dev_id";s:6:"dev_id";s:14:"dev_android_id";s:14:"dev_android_id";s:8:"dev_name";s:8:"dev_name";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:26:"dev_default_warehouse_code";s:26:"dev_default_warehouse_code";s:23:"dev_stock_posting_stage";s:23:"dev_stock_posting_stage";s:13:"dev_fcm_token";s:13:"dev_fcm_token";s:19:"dev_price_region_id";s:19:"dev_price_region_id";}s:25:"t_server_document_control";a:8:{s:6:"doc_id";s:6:"doc_id";s:10:"doc_module";s:10:"doc_module";s:15:"doc_next_number";s:15:"doc_next_number";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:14:"t_server_drink";a:18:{s:6:"drk_id";s:6:"drk_id";s:8:"drk_code";s:8:"drk_code";s:8:"drk_name";s:8:"drk_name";s:7:"drk_uom";s:7:"drk_uom";s:9:"drk_price";s:9:"drk_price";s:11:"drk_price_2";s:11:"drk_price_2";s:11:"drk_price_3";s:11:"drk_price_3";s:11:"drk_price_4";s:11:"drk_price_4";s:11:"drk_price_5";s:11:"drk_price_5";s:8:"drk_cost";s:8:"drk_cost";s:12:"drk_gst_code";s:12:"drk_gst_code";s:11:"drk_balance";s:11:"drk_balance";s:10:"drk_status";s:10:"drk_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:25:"t_server_drink_assignment";a:8:{s:7:"asgd_id";s:7:"asgd_id";s:13:"asgd_drink_id";s:13:"asgd_drink_id";s:15:"asgd_product_id";s:15:"asgd_product_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:32:"t_server_export_setting_customer";a:10:{s:6:"exp_id";s:6:"exp_id";s:11:"exp_sorting";s:11:"exp_sorting";s:9:"exp_field";s:9:"exp_field";s:8:"exp_name";s:8:"exp_name";s:10:"exp_status";s:10:"exp_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:31:"t_server_export_setting_product";a:10:{s:6:"exp_id";s:6:"exp_id";s:11:"exp_sorting";s:11:"exp_sorting";s:9:"exp_field";s:9:"exp_field";s:8:"exp_name";s:8:"exp_name";s:10:"exp_status";s:10:"exp_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:30:"t_server_export_setting_return";a:10:{s:6:"exp_id";s:6:"exp_id";s:11:"exp_sorting";s:11:"exp_sorting";s:9:"exp_field";s:9:"exp_field";s:8:"exp_name";s:8:"exp_name";s:10:"exp_status";s:10:"exp_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:29:"t_server_export_setting_sales";a:10:{s:6:"exp_id";s:6:"exp_id";s:11:"exp_sorting";s:11:"exp_sorting";s:9:"exp_field";s:9:"exp_field";s:8:"exp_name";s:8:"exp_name";s:10:"exp_status";s:10:"exp_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:13:"t_server_file";a:13:{s:6:"fil_id";s:6:"fil_id";s:8:"fil_name";s:8:"fil_name";s:8:"fil_size";s:8:"fil_size";s:8:"fil_type";s:8:"fil_type";s:7:"fil_mod";s:7:"fil_mod";s:10:"fil_mod_id";s:10:"fil_mod_id";s:13:"fil_mod_field";s:13:"fil_mod_field";s:18:"fil_storage_method";s:18:"fil_storage_method";s:18:"fil_binary_content";s:18:"fil_binary_content";s:12:"CREATED_DATE";s:12:"CREATED_DATE";s:13:"MODIFIED_DATE";s:13:"MODIFIED_DATE";s:10:"CREATOR_ID";s:10:"CREATOR_ID";s:11:"MODIFIER_ID";s:11:"MODIFIER_ID";}s:15:"t_server_flavor";a:18:{s:6:"fav_id";s:6:"fav_id";s:8:"fav_code";s:8:"fav_code";s:8:"fav_name";s:8:"fav_name";s:7:"fav_uom";s:7:"fav_uom";s:9:"fav_price";s:9:"fav_price";s:11:"fav_price_2";s:11:"fav_price_2";s:11:"fav_price_3";s:11:"fav_price_3";s:11:"fav_price_4";s:11:"fav_price_4";s:11:"fav_price_5";s:11:"fav_price_5";s:8:"fav_cost";s:8:"fav_cost";s:12:"fav_gst_code";s:12:"fav_gst_code";s:11:"fav_balance";s:11:"fav_balance";s:10:"fav_status";s:10:"fav_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:26:"t_server_flavor_assignment";a:8:{s:7:"asgf_id";s:7:"asgf_id";s:14:"asgf_flavor_id";s:14:"asgf_flavor_id";s:15:"asgf_product_id";s:15:"asgf_product_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:19:"t_server_floor_plan";a:11:{s:6:"flr_id";s:6:"flr_id";s:8:"flr_code";s:8:"flr_code";s:8:"flr_name";s:8:"flr_name";s:18:"flr_warehouse_code";s:18:"flr_warehouse_code";s:10:"flr_status";s:10:"flr_status";s:12:"flr_sort_key";s:12:"flr_sort_key";s:9:"client_id";s:9:"client_id";s:11:"modified_by";s:11:"modified_by";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:13:"modified_date";s:13:"modified_date";}s:12:"t_server_gst";a:9:{s:6:"gst_id";s:6:"gst_id";s:8:"gst_code";s:8:"gst_code";s:8:"gst_name";s:8:"gst_name";s:14:"gst_percentage";s:14:"gst_percentage";s:9:"client_id";s:9:"client_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";}s:20:"t_server_instruction";a:18:{s:6:"ins_id";s:6:"ins_id";s:8:"ins_code";s:8:"ins_code";s:8:"ins_name";s:8:"ins_name";s:7:"ins_uom";s:7:"ins_uom";s:9:"ins_price";s:9:"ins_price";s:11:"ins_price_2";s:11:"ins_price_2";s:11:"ins_price_3";s:11:"ins_price_3";s:11:"ins_price_4";s:11:"ins_price_4";s:11:"ins_price_5";s:11:"ins_price_5";s:8:"ins_cost";s:8:"ins_cost";s:12:"ins_gst_code";s:12:"ins_gst_code";s:11:"ins_balance";s:11:"ins_balance";s:10:"ins_status";s:10:"ins_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:31:"t_server_instruction_assignment";a:8:{s:7:"asgi_id";s:7:"asgi_id";s:19:"asgi_instruction_id";s:19:"asgi_instruction_id";s:15:"asgi_product_id";s:15:"asgi_product_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:39:"t_server_internal_inventory_transaction";a:16:{s:6:"iit_id";s:6:"iit_id";s:17:"iit_device_iit_id";s:17:"iit_device_iit_id";s:8:"iit_date";s:8:"iit_date";s:17:"iit_location_code";s:17:"iit_location_code";s:16:"iit_product_code";s:16:"iit_product_code";s:8:"iit_type";s:8:"iit_type";s:8:"iit_user";s:8:"iit_user";s:12:"iit_quantity";s:12:"iit_quantity";s:9:"client_id";s:9:"client_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"device_id";s:9:"device_id";s:28:"iit_inventory_posting_status";s:28:"iit_inventory_posting_status";s:36:"iit_inventory_posting_warehouse_code";s:36:"iit_inventory_posting_warehouse_code";}s:23:"t_server_invoice_header";a:32:{s:6:"ivh_id";s:6:"ivh_id";s:9:"device_id";s:9:"device_id";s:10:"ivh_ivh_id";s:10:"ivh_ivh_id";s:10:"ivh_doc_no";s:10:"ivh_doc_no";s:17:"ivh_customer_code";s:17:"ivh_customer_code";s:17:"ivh_customer_name";s:17:"ivh_customer_name";s:28:"ivh_customer_address_billing";s:28:"ivh_customer_address_billing";s:29:"ivh_customer_address_delivery";s:29:"ivh_customer_address_delivery";s:19:"ivh_customer_gst_no";s:19:"ivh_customer_gst_no";s:21:"ivh_customer_discount";s:21:"ivh_customer_discount";s:8:"ivh_date";s:8:"ivh_date";s:18:"ivh_discount_total";s:18:"ivh_discount_total";s:20:"ivh_total_before_gst";s:20:"ivh_total_before_gst";s:14:"ivh_gst_amount";s:14:"ivh_gst_amount";s:16:"ivh_total_amount";s:16:"ivh_total_amount";s:19:"ivh_rounding_amount";s:19:"ivh_rounding_amount";s:24:"ivh_total_amount_rounded";s:24:"ivh_total_amount_rounded";s:18:"ivh_payment_amount";s:18:"ivh_payment_amount";s:17:"ivh_change_amount";s:17:"ivh_change_amount";s:10:"ivh_status";s:10:"ivh_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:12:"ivh_latitude";s:12:"ivh_latitude";s:13:"ivh_longitude";s:13:"ivh_longitude";s:18:"ivh_operation_mode";s:18:"ivh_operation_mode";s:19:"ivh_delivery_status";s:19:"ivh_delivery_status";s:17:"ivh_closing_batch";s:17:"ivh_closing_batch";s:16:"ivh_partial_paid";s:16:"ivh_partial_paid";s:15:"ivh_amount_paid";s:15:"ivh_amount_paid";}s:21:"t_server_invoice_item";a:37:{s:6:"ivi_id";s:6:"ivi_id";s:9:"device_id";s:9:"device_id";s:10:"ivi_ivi_id";s:10:"ivi_ivi_id";s:13:"ivi_header_id";s:13:"ivi_header_id";s:10:"ivi_doc_no";s:10:"ivi_doc_no";s:14:"ivi_product_id";s:14:"ivi_product_id";s:16:"ivi_product_code";s:16:"ivi_product_code";s:19:"ivi_product_barcode";s:19:"ivi_product_barcode";s:16:"ivi_product_name";s:16:"ivi_product_name";s:13:"ivi_serial_no";s:13:"ivi_serial_no";s:10:"ivi_remark";s:10:"ivi_remark";s:9:"ivi_price";s:9:"ivi_price";s:8:"ivi_cost";s:8:"ivi_cost";s:12:"ivi_quantity";s:12:"ivi_quantity";s:7:"ivi_uom";s:7:"ivi_uom";s:13:"ivi_attribute";s:13:"ivi_attribute";s:8:"ivi_size";s:8:"ivi_size";s:9:"ivi_color";s:9:"ivi_color";s:11:"ivi_pattern";s:11:"ivi_pattern";s:15:"ivi_total_addon";s:15:"ivi_total_addon";s:23:"ivi_discount_percentage";s:23:"ivi_discount_percentage";s:18:"ivi_discount_value";s:18:"ivi_discount_value";s:18:"ivi_discount_total";s:18:"ivi_discount_total";s:20:"ivi_total_before_gst";s:20:"ivi_total_before_gst";s:12:"ivi_gst_mode";s:12:"ivi_gst_mode";s:12:"ivi_gst_code";s:12:"ivi_gst_code";s:18:"ivi_gst_percentage";s:18:"ivi_gst_percentage";s:14:"ivi_gst_amount";s:14:"ivi_gst_amount";s:16:"ivi_total_amount";s:16:"ivi_total_amount";s:10:"ivi_status";s:10:"ivi_status";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:21:"ivi_inventory_posting";s:21:"ivi_inventory_posting";s:15:"ivi_salesperson";s:15:"ivi_salesperson";}s:27:"t_server_invoice_item_addon";a:19:{s:6:"ivd_id";s:6:"ivd_id";s:9:"device_id";s:9:"device_id";s:10:"ivd_ivd_id";s:10:"ivd_ivd_id";s:10:"ivd_ivi_id";s:10:"ivd_ivi_id";s:13:"ivd_header_id";s:13:"ivd_header_id";s:10:"ivd_doc_no";s:10:"ivd_doc_no";s:12:"ivd_addon_id";s:12:"ivd_addon_id";s:14:"ivd_addon_code";s:14:"ivd_addon_code";s:14:"ivd_addon_name";s:14:"ivd_addon_name";s:9:"ivd_price";s:9:"ivd_price";s:8:"ivd_cost";s:8:"ivd_cost";s:12:"ivd_quantity";s:12:"ivd_quantity";s:7:"ivd_uom";s:7:"ivd_uom";s:16:"ivd_total_amount";s:16:"ivd_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:24:"t_server_invoice_payment";a:16:{s:6:"ivp_id";s:6:"ivp_id";s:9:"device_id";s:9:"device_id";s:10:"ivp_ivp_id";s:10:"ivp_ivp_id";s:10:"ivp_ivh_id";s:10:"ivp_ivh_id";s:10:"ivp_doc_no";s:10:"ivp_doc_no";s:16:"ivp_payment_code";s:16:"ivp_payment_code";s:16:"ivp_payment_name";s:16:"ivp_payment_name";s:10:"ivp_amount";s:10:"ivp_amount";s:10:"ivp_change";s:10:"ivp_change";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:16:"ivp_reference_no";s:16:"ivp_reference_no";s:15:"ivp_approval_no";s:15:"ivp_approval_no";}s:12:"t_server_log";a:7:{s:6:"log_id";s:6:"log_id";s:11:"log_data_id";s:11:"log_data_id";s:10:"log_module";s:10:"log_module";s:10:"log_action";s:10:"log_action";s:13:"log_user_name";s:13:"log_user_name";s:11:"log_user_id";s:11:"log_user_id";s:12:"created_date";s:12:"created_date";}s:22:"t_server_mssql_setting";a:9:{s:6:"msq_id";s:6:"msq_id";s:14:"msq_ip_address";s:14:"msq_ip_address";s:12:"msq_username";s:12:"msq_username";s:12:"msq_password";s:12:"msq_password";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:16:"t_server_pattern";a:9:{s:6:"ptn_id";s:6:"ptn_id";s:8:"ptn_code";s:8:"ptn_code";s:8:"ptn_name";s:8:"ptn_name";s:10:"ptn_status";s:10:"ptn_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:21:"t_server_payment_mode";a:11:{s:6:"pym_id";s:6:"pym_id";s:8:"pym_code";s:8:"pym_code";s:8:"pym_name";s:8:"pym_name";s:16:"pym_exact_amount";s:16:"pym_exact_amount";s:11:"pym_forfeit";s:11:"pym_forfeit";s:11:"pym_default";s:11:"pym_default";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:21:"t_server_price_region";a:9:{s:6:"reg_id";s:6:"reg_id";s:8:"reg_code";s:8:"reg_code";s:8:"reg_name";s:8:"reg_name";s:10:"reg_status";s:10:"reg_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:16:"t_server_product";a:53:{s:6:"pdt_id";s:6:"pdt_id";s:8:"pdt_code";s:8:"pdt_code";s:11:"pdt_barcode";s:11:"pdt_barcode";s:17:"pdt_category_code";s:17:"pdt_category_code";s:19:"pdt_menu_group_code";s:19:"pdt_menu_group_code";s:8:"pdt_name";s:8:"pdt_name";s:7:"pdt_uom";s:7:"pdt_uom";s:9:"pdt_price";s:9:"pdt_price";s:11:"pdt_price_2";s:11:"pdt_price_2";s:11:"pdt_price_3";s:11:"pdt_price_3";s:11:"pdt_price_4";s:11:"pdt_price_4";s:11:"pdt_price_5";s:11:"pdt_price_5";s:8:"pdt_cost";s:8:"pdt_cost";s:17:"pdt_price_group_1";s:17:"pdt_price_group_1";s:17:"pdt_price_group_2";s:17:"pdt_price_group_2";s:17:"pdt_price_group_3";s:17:"pdt_price_group_3";s:17:"pdt_price_group_4";s:17:"pdt_price_group_4";s:17:"pdt_price_group_5";s:17:"pdt_price_group_5";s:18:"pdt_discount_allow";s:18:"pdt_discount_allow";s:12:"pdt_gst_code";s:12:"pdt_gst_code";s:12:"pdt_gst_mode";s:12:"pdt_gst_mode";s:11:"pdt_balance";s:11:"pdt_balance";s:12:"pdt_supplier";s:12:"pdt_supplier";s:9:"pdt_brand";s:9:"pdt_brand";s:14:"pdt_category_1";s:14:"pdt_category_1";s:14:"pdt_category_2";s:14:"pdt_category_2";s:14:"pdt_category_3";s:14:"pdt_category_3";s:10:"pdt_status";s:10:"pdt_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:16:"pdt_select_color";s:16:"pdt_select_color";s:15:"pdt_select_size";s:15:"pdt_select_size";s:18:"pdt_select_pattern";s:18:"pdt_select_pattern";s:17:"pdt_scale_price_1";s:17:"pdt_scale_price_1";s:17:"pdt_scale_price_2";s:17:"pdt_scale_price_2";s:17:"pdt_scale_price_3";s:17:"pdt_scale_price_3";s:17:"pdt_scale_price_4";s:17:"pdt_scale_price_4";s:17:"pdt_scale_price_5";s:17:"pdt_scale_price_5";s:25:"pdt_scale_price_1_min_qty";s:25:"pdt_scale_price_1_min_qty";s:25:"pdt_scale_price_2_min_qty";s:25:"pdt_scale_price_2_min_qty";s:25:"pdt_scale_price_3_min_qty";s:25:"pdt_scale_price_3_min_qty";s:25:"pdt_scale_price_4_min_qty";s:25:"pdt_scale_price_4_min_qty";s:25:"pdt_scale_price_5_min_qty";s:25:"pdt_scale_price_5_min_qty";s:20:"pdt_decimal_quantity";s:20:"pdt_decimal_quantity";s:12:"pdt_featured";s:12:"pdt_featured";s:22:"pdt_inventory_tracking";s:22:"pdt_inventory_tracking";s:15:"pdt_vendor_code";s:15:"pdt_vendor_code";s:26:"pdt_inventory_costing_mode";s:26:"pdt_inventory_costing_mode";s:26:"pdt_reorder_point_quantity";s:26:"pdt_reorder_point_quantity";s:16:"pdt_max_quantity";s:16:"pdt_max_quantity";}s:22:"t_server_product_photo";a:2:{s:16:"pho_product_code";s:16:"pho_product_code";s:8:"pho_file";s:8:"pho_file";}s:22:"t_server_product_price";a:12:{s:6:"pri_id";s:6:"pri_id";s:14:"pri_product_id";s:14:"pri_product_id";s:11:"pri_group_1";s:11:"pri_group_1";s:11:"pri_group_2";s:11:"pri_group_2";s:11:"pri_group_3";s:11:"pri_group_3";s:11:"pri_group_4";s:11:"pri_group_4";s:11:"pri_group_5";s:11:"pri_group_5";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:29:"t_server_product_region_price";a:9:{s:6:"rpr_id";s:6:"rpr_id";s:14:"rpr_product_id";s:14:"rpr_product_id";s:13:"rpr_region_id";s:13:"rpr_region_id";s:9:"rpr_price";s:9:"rpr_price";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:16:"t_server_project";a:11:{s:6:"prj_id";s:6:"prj_id";s:8:"prj_code";s:8:"prj_code";s:8:"prj_name";s:8:"prj_name";s:14:"prj_start_date";s:14:"prj_start_date";s:12:"prj_end_date";s:12:"prj_end_date";s:10:"prj_status";s:10:"prj_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:21:"t_server_project_link";a:10:{s:6:"plk_id";s:6:"plk_id";s:14:"plk_project_id";s:14:"plk_project_id";s:10:"plk_module";s:10:"plk_module";s:13:"plk_object_id";s:13:"plk_object_id";s:14:"plk_percentage";s:14:"plk_percentage";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:14:"t_server_promo";a:12:{s:6:"pro_id";s:6:"pro_id";s:8:"pro_code";s:8:"pro_code";s:8:"pro_name";s:8:"pro_name";s:14:"pro_start_date";s:14:"pro_start_date";s:12:"pro_end_date";s:12:"pro_end_date";s:16:"pro_barcode_list";s:16:"pro_barcode_list";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:23:"pro_discount_percentage";s:23:"pro_discount_percentage";}s:30:"t_server_purchase_order_header";a:25:{s:6:"poh_id";s:6:"poh_id";s:14:"poh_doc_prefix";s:14:"poh_doc_prefix";s:10:"poh_doc_no";s:10:"poh_doc_no";s:10:"poh_module";s:10:"poh_module";s:8:"poh_date";s:8:"poh_date";s:18:"poh_warehouse_code";s:18:"poh_warehouse_code";s:16:"poh_warehouse_id";s:16:"poh_warehouse_id";s:19:"poh_warehouse_code2";s:19:"poh_warehouse_code2";s:17:"poh_warehouse_id2";s:17:"poh_warehouse_id2";s:17:"poh_customer_code";s:17:"poh_customer_code";s:17:"poh_customer_name";s:17:"poh_customer_name";s:15:"poh_vendor_code";s:15:"poh_vendor_code";s:15:"poh_vendor_name";s:15:"poh_vendor_name";s:16:"poh_reference_no";s:16:"poh_reference_no";s:10:"poh_remark";s:10:"poh_remark";s:10:"poh_status";s:10:"poh_status";s:21:"poh_before_gst_amount";s:21:"poh_before_gst_amount";s:14:"poh_gst_amount";s:14:"poh_gst_amount";s:16:"poh_total_amount";s:16:"poh_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:17:"poh_category_code";s:17:"poh_category_code";}s:28:"t_server_purchase_order_item";a:38:{s:6:"poi_id";s:6:"poi_id";s:13:"poi_header_id";s:13:"poi_header_id";s:14:"poi_doc_prefix";s:14:"poi_doc_prefix";s:10:"poi_doc_no";s:10:"poi_doc_no";s:10:"poi_module";s:10:"poi_module";s:8:"poi_date";s:8:"poi_date";s:18:"poi_warehouse_code";s:18:"poi_warehouse_code";s:16:"poi_warehouse_id";s:16:"poi_warehouse_id";s:19:"poi_warehouse_code2";s:19:"poi_warehouse_code2";s:17:"poi_warehouse_id2";s:17:"poi_warehouse_id2";s:14:"poi_stock_code";s:14:"poi_stock_code";s:11:"poi_barcode";s:11:"poi_barcode";s:16:"poi_factory_code";s:16:"poi_factory_code";s:14:"poi_stock_name";s:14:"poi_stock_name";s:9:"poi_color";s:9:"poi_color";s:8:"poi_size";s:8:"poi_size";s:11:"poi_pattern";s:11:"poi_pattern";s:7:"poi_uom";s:7:"poi_uom";s:12:"poi_base_uom";s:12:"poi_base_uom";s:12:"poi_quantity";s:12:"poi_quantity";s:17:"poi_base_quantity";s:17:"poi_base_quantity";s:14:"poi_conversion";s:14:"poi_conversion";s:13:"poi_unit_cost";s:13:"poi_unit_cost";s:18:"poi_base_unit_cost";s:18:"poi_base_unit_cost";s:14:"poi_total_cost";s:14:"poi_total_cost";s:12:"poi_gst_mode";s:12:"poi_gst_mode";s:12:"poi_gst_code";s:12:"poi_gst_code";s:18:"poi_gst_percentage";s:18:"poi_gst_percentage";s:10:"poi_remark";s:10:"poi_remark";s:10:"poi_status";s:10:"poi_status";s:21:"poi_before_gst_amount";s:21:"poi_before_gst_amount";s:14:"poi_gst_amount";s:14:"poi_gst_amount";s:16:"poi_total_amount";s:16:"poi_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:13:"t_server_race";a:8:{s:6:"rce_id";s:6:"rce_id";s:8:"rce_code";s:8:"rce_code";s:8:"rce_name";s:8:"rce_name";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:22:"t_server_return_header";a:29:{s:6:"rth_id";s:6:"rth_id";s:10:"rth_rth_id";s:10:"rth_rth_id";s:10:"rth_doc_no";s:10:"rth_doc_no";s:17:"rth_customer_code";s:17:"rth_customer_code";s:17:"rth_customer_name";s:17:"rth_customer_name";s:28:"rth_customer_address_billing";s:28:"rth_customer_address_billing";s:29:"rth_customer_address_delivery";s:29:"rth_customer_address_delivery";s:19:"rth_customer_gst_no";s:19:"rth_customer_gst_no";s:21:"rth_customer_discount";s:21:"rth_customer_discount";s:8:"rth_date";s:8:"rth_date";s:18:"rth_discount_total";s:18:"rth_discount_total";s:20:"rth_total_before_gst";s:20:"rth_total_before_gst";s:14:"rth_gst_amount";s:14:"rth_gst_amount";s:16:"rth_total_amount";s:16:"rth_total_amount";s:19:"rth_rounding_amount";s:19:"rth_rounding_amount";s:24:"rth_total_amount_rounded";s:24:"rth_total_amount_rounded";s:18:"rth_payment_amount";s:18:"rth_payment_amount";s:17:"rth_change_amount";s:17:"rth_change_amount";s:10:"rth_status";s:10:"rth_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:9:"device_id";s:9:"device_id";s:12:"rth_latitude";s:12:"rth_latitude";s:13:"rth_longitude";s:13:"rth_longitude";s:19:"rth_delivery_status";s:19:"rth_delivery_status";s:17:"rth_closing_batch";s:17:"rth_closing_batch";}s:20:"t_server_return_item";a:37:{s:6:"rti_id";s:6:"rti_id";s:10:"rti_rti_id";s:10:"rti_rti_id";s:13:"rti_header_id";s:13:"rti_header_id";s:10:"rti_doc_no";s:10:"rti_doc_no";s:14:"rti_product_id";s:14:"rti_product_id";s:16:"rti_product_code";s:16:"rti_product_code";s:19:"rti_product_barcode";s:19:"rti_product_barcode";s:16:"rti_product_name";s:16:"rti_product_name";s:13:"rti_serial_no";s:13:"rti_serial_no";s:10:"rti_remark";s:10:"rti_remark";s:9:"rti_price";s:9:"rti_price";s:8:"rti_cost";s:8:"rti_cost";s:12:"rti_quantity";s:12:"rti_quantity";s:7:"rti_uom";s:7:"rti_uom";s:13:"rti_attribute";s:13:"rti_attribute";s:8:"rti_size";s:8:"rti_size";s:9:"rti_color";s:9:"rti_color";s:11:"rti_pattern";s:11:"rti_pattern";s:15:"rti_total_addon";s:15:"rti_total_addon";s:23:"rti_discount_percentage";s:23:"rti_discount_percentage";s:18:"rti_discount_value";s:18:"rti_discount_value";s:18:"rti_discount_total";s:18:"rti_discount_total";s:20:"rti_total_before_gst";s:20:"rti_total_before_gst";s:12:"rti_gst_mode";s:12:"rti_gst_mode";s:12:"rti_gst_code";s:12:"rti_gst_code";s:18:"rti_gst_percentage";s:18:"rti_gst_percentage";s:14:"rti_gst_amount";s:14:"rti_gst_amount";s:16:"rti_total_amount";s:16:"rti_total_amount";s:10:"rti_status";s:10:"rti_status";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:9:"device_id";s:9:"device_id";s:21:"rti_inventory_posting";s:21:"rti_inventory_posting";s:15:"rti_salesperson";s:15:"rti_salesperson";}s:26:"t_server_return_item_addon";a:19:{s:6:"rtd_id";s:6:"rtd_id";s:9:"device_id";s:9:"device_id";s:10:"rtd_rtd_id";s:10:"rtd_rtd_id";s:10:"rtd_rti_id";s:10:"rtd_rti_id";s:13:"rtd_header_id";s:13:"rtd_header_id";s:10:"rtd_doc_no";s:10:"rtd_doc_no";s:12:"rtd_addon_id";s:12:"rtd_addon_id";s:14:"rtd_addon_code";s:14:"rtd_addon_code";s:14:"rtd_addon_name";s:14:"rtd_addon_name";s:9:"rtd_price";s:9:"rtd_price";s:8:"rtd_cost";s:8:"rtd_cost";s:12:"rtd_quantity";s:12:"rtd_quantity";s:7:"rtd_uom";s:7:"rtd_uom";s:16:"rtd_total_amount";s:16:"rtd_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:16:"t_server_setting";a:21:{s:6:"set_id";s:6:"set_id";s:16:"set_company_name";s:16:"set_company_name";s:11:"set_address";s:11:"set_address";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:18:"set_module_project";s:18:"set_module_project";s:18:"set_module_tagging";s:18:"set_module_tagging";s:40:"set_module_internal_inventory_management";s:40:"set_module_internal_inventory_management";s:24:"set_sync_customer_upload";s:24:"set_sync_customer_upload";s:20:"set_use_product_size";s:20:"set_use_product_size";s:21:"set_use_product_color";s:21:"set_use_product_color";s:23:"set_use_product_pattern";s:23:"set_use_product_pattern";s:26:"set_stock_out_use_customer";s:26:"set_stock_out_use_customer";s:24:"set_stock_out_use_vendor";s:24:"set_stock_out_use_vendor";s:25:"set_stock_in_use_customer";s:25:"set_stock_in_use_customer";s:23:"set_stock_in_use_vendor";s:23:"set_stock_in_use_vendor";s:31:"set_stock_transfer_use_customer";s:31:"set_stock_transfer_use_customer";s:29:"set_stock_transfer_use_vendor";s:29:"set_stock_transfer_use_vendor";}s:13:"t_server_size";a:9:{s:6:"siz_id";s:6:"siz_id";s:8:"siz_code";s:8:"siz_code";s:8:"siz_name";s:8:"siz_name";s:10:"siz_status";s:10:"siz_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:14:"t_server_staff";a:13:{s:6:"stf_id";s:6:"stf_id";s:8:"stf_code";s:8:"stf_code";s:8:"stf_name";s:8:"stf_name";s:9:"stf_ic_no";s:9:"stf_ic_no";s:14:"stf_birth_date";s:14:"stf_birth_date";s:9:"stf_email";s:9:"stf_email";s:13:"stf_mobile_no";s:13:"stf_mobile_no";s:16:"stf_job_position";s:16:"stf_job_position";s:10:"stf_status";s:10:"stf_status";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";}s:19:"t_server_stock_card";a:29:{s:6:"stc_id";s:6:"stc_id";s:9:"device_id";s:9:"device_id";s:8:"stc_date";s:8:"stc_date";s:10:"stc_module";s:10:"stc_module";s:8:"stc_type";s:8:"stc_type";s:10:"stc_doc_no";s:10:"stc_doc_no";s:18:"stc_warehouse_code";s:18:"stc_warehouse_code";s:16:"stc_warehouse_id";s:16:"stc_warehouse_id";s:12:"stc_stock_id";s:12:"stc_stock_id";s:14:"stc_stock_code";s:14:"stc_stock_code";s:11:"stc_barcode";s:11:"stc_barcode";s:16:"stc_factory_code";s:16:"stc_factory_code";s:14:"stc_stock_name";s:14:"stc_stock_name";s:9:"stc_color";s:9:"stc_color";s:8:"stc_size";s:8:"stc_size";s:11:"stc_pattern";s:11:"stc_pattern";s:7:"stc_uom";s:7:"stc_uom";s:12:"stc_base_uom";s:12:"stc_base_uom";s:12:"stc_quantity";s:12:"stc_quantity";s:17:"stc_base_quantity";s:17:"stc_base_quantity";s:14:"stc_conversion";s:14:"stc_conversion";s:18:"stc_balance_before";s:18:"stc_balance_before";s:17:"stc_balance_after";s:17:"stc_balance_after";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:16:"stc_item_data_id";s:16:"stc_item_data_id";}s:35:"t_server_stock_transaction_category";a:8:{s:6:"stc_id";s:6:"stc_id";s:8:"stc_code";s:8:"stc_code";s:8:"stc_name";s:8:"stc_name";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";}s:33:"t_server_stock_transaction_header";a:26:{s:6:"sth_id";s:6:"sth_id";s:14:"sth_doc_prefix";s:14:"sth_doc_prefix";s:10:"sth_doc_no";s:10:"sth_doc_no";s:10:"sth_module";s:10:"sth_module";s:8:"sth_date";s:8:"sth_date";s:18:"sth_warehouse_code";s:18:"sth_warehouse_code";s:16:"sth_warehouse_id";s:16:"sth_warehouse_id";s:19:"sth_warehouse_code2";s:19:"sth_warehouse_code2";s:17:"sth_warehouse_id2";s:17:"sth_warehouse_id2";s:17:"sth_customer_code";s:17:"sth_customer_code";s:17:"sth_customer_name";s:17:"sth_customer_name";s:15:"sth_vendor_code";s:15:"sth_vendor_code";s:15:"sth_vendor_name";s:15:"sth_vendor_name";s:16:"sth_reference_no";s:16:"sth_reference_no";s:10:"sth_remark";s:10:"sth_remark";s:10:"sth_status";s:10:"sth_status";s:21:"sth_before_gst_amount";s:21:"sth_before_gst_amount";s:14:"sth_gst_amount";s:14:"sth_gst_amount";s:16:"sth_total_amount";s:16:"sth_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:17:"sth_category_code";s:17:"sth_category_code";s:9:"device_id";s:9:"device_id";}s:31:"t_server_stock_transaction_item";a:40:{s:6:"sti_id";s:6:"sti_id";s:13:"sti_header_id";s:13:"sti_header_id";s:14:"sti_doc_prefix";s:14:"sti_doc_prefix";s:10:"sti_doc_no";s:10:"sti_doc_no";s:10:"sti_module";s:10:"sti_module";s:8:"sti_date";s:8:"sti_date";s:18:"sti_warehouse_code";s:18:"sti_warehouse_code";s:16:"sti_warehouse_id";s:16:"sti_warehouse_id";s:19:"sti_warehouse_code2";s:19:"sti_warehouse_code2";s:17:"sti_warehouse_id2";s:17:"sti_warehouse_id2";s:14:"sti_stock_code";s:14:"sti_stock_code";s:11:"sti_barcode";s:11:"sti_barcode";s:16:"sti_factory_code";s:16:"sti_factory_code";s:14:"sti_stock_name";s:14:"sti_stock_name";s:9:"sti_color";s:9:"sti_color";s:8:"sti_size";s:8:"sti_size";s:11:"sti_pattern";s:11:"sti_pattern";s:7:"sti_uom";s:7:"sti_uom";s:12:"sti_base_uom";s:12:"sti_base_uom";s:12:"sti_quantity";s:12:"sti_quantity";s:17:"sti_base_quantity";s:17:"sti_base_quantity";s:14:"sti_conversion";s:14:"sti_conversion";s:13:"sti_unit_cost";s:13:"sti_unit_cost";s:18:"sti_base_unit_cost";s:18:"sti_base_unit_cost";s:14:"sti_total_cost";s:14:"sti_total_cost";s:12:"sti_gst_mode";s:12:"sti_gst_mode";s:12:"sti_gst_code";s:12:"sti_gst_code";s:18:"sti_gst_percentage";s:18:"sti_gst_percentage";s:10:"sti_remark";s:10:"sti_remark";s:10:"sti_status";s:10:"sti_status";s:21:"sti_before_gst_amount";s:21:"sti_before_gst_amount";s:14:"sti_gst_amount";s:14:"sti_gst_amount";s:16:"sti_total_amount";s:16:"sti_total_amount";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:9:"device_id";s:9:"device_id";s:21:"sti_inventory_posting";s:21:"sti_inventory_posting";}s:25:"t_server_storage_location";a:15:{s:6:"loc_id";s:6:"loc_id";s:8:"loc_code";s:8:"loc_code";s:8:"loc_name";s:8:"loc_name";s:14:"loc_floor_code";s:14:"loc_floor_code";s:5:"loc_x";s:5:"loc_x";s:5:"loc_y";s:5:"loc_y";s:9:"loc_width";s:9:"loc_width";s:10:"loc_height";s:10:"loc_height";s:9:"client_id";s:9:"client_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"loc_shape";s:9:"loc_shape";s:18:"loc_warehouse_code";s:18:"loc_warehouse_code";}s:33:"t_server_storage_location_balance";a:9:{s:6:"lba_id";s:6:"lba_id";s:17:"lba_location_code";s:17:"lba_location_code";s:16:"lba_product_code";s:16:"lba_product_code";s:12:"lba_quantity";s:12:"lba_quantity";s:9:"client_id";s:9:"client_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";}s:34:"t_server_storage_location_movement";a:16:{s:6:"iot_id";s:6:"iot_id";s:10:"iot_doc_no";s:10:"iot_doc_no";s:17:"iot_location_code";s:17:"iot_location_code";s:8:"iot_type";s:8:"iot_type";s:16:"iot_product_code";s:16:"iot_product_code";s:16:"iot_product_name";s:16:"iot_product_name";s:12:"iot_quantity";s:12:"iot_quantity";s:7:"iot_uom";s:7:"iot_uom";s:8:"iot_user";s:8:"iot_user";s:24:"iot_transaction_datetime";s:24:"iot_transaction_datetime";s:9:"device_id";s:9:"device_id";s:9:"client_id";s:9:"client_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";}s:13:"t_server_user";a:12:{s:6:"usr_id";s:6:"usr_id";s:13:"usr_full_name";s:13:"usr_full_name";s:8:"usr_name";s:8:"usr_name";s:12:"usr_password";s:12:"usr_password";s:9:"usr_email";s:9:"usr_email";s:12:"usr_group_id";s:12:"usr_group_id";s:13:"usr_status_id";s:13:"usr_status_id";s:19:"usr_last_login_date";s:19:"usr_last_login_date";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";}s:20:"t_server_user_device";a:16:{s:7:"dusr_id";s:7:"dusr_id";s:14:"dusr_full_name";s:14:"dusr_full_name";s:9:"dusr_name";s:9:"dusr_name";s:13:"dusr_password";s:13:"dusr_password";s:10:"dusr_group";s:10:"dusr_group";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:18:"dusr_inventory_app";s:18:"dusr_inventory_app";s:23:"dusr_inventory_stock_in";s:23:"dusr_inventory_stock_in";s:24:"dusr_inventory_stock_out";s:24:"dusr_inventory_stock_out";s:29:"dusr_inventory_stock_transfer";s:29:"dusr_inventory_stock_transfer";s:23:"dusr_inventory_check_in";s:23:"dusr_inventory_check_in";s:24:"dusr_inventory_check_out";s:24:"dusr_inventory_check_out";s:27:"dusr_inventory_internal_use";s:27:"dusr_inventory_internal_use";}s:19:"t_server_user_group";a:48:{s:6:"grp_id";s:6:"grp_id";s:8:"grp_name";s:8:"grp_name";s:12:"grp_customer";s:12:"grp_customer";s:16:"grp_picking_list";s:16:"grp_picking_list";s:11:"grp_project";s:11:"grp_project";s:18:"grp_purchase_order";s:18:"grp_purchase_order";s:12:"grp_stock_in";s:12:"grp_stock_in";s:13:"grp_stock_out";s:13:"grp_stock_out";s:18:"grp_stock_transfer";s:18:"grp_stock_transfer";s:21:"grp_stock_transaction";s:21:"grp_stock_transaction";s:28:"grp_reject_stock_transaction";s:28:"grp_reject_stock_transaction";s:19:"grp_balance_display";s:19:"grp_balance_display";s:10:"grp_vendor";s:10:"grp_vendor";s:24:"grp_transaction_category";s:24:"grp_transaction_category";s:11:"grp_product";s:11:"grp_product";s:20:"grp_product_category";s:20:"grp_product_category";s:9:"grp_color";s:9:"grp_color";s:8:"grp_size";s:8:"grp_size";s:11:"grp_pattern";s:11:"grp_pattern";s:9:"grp_addon";s:9:"grp_addon";s:9:"grp_promo";s:9:"grp_promo";s:16:"grp_export_sales";s:16:"grp_export_sales";s:17:"grp_export_return";s:17:"grp_export_return";s:18:"grp_export_product";s:18:"grp_export_product";s:19:"grp_export_customer";s:19:"grp_export_customer";s:28:"grp_report_sales_transaction";s:28:"grp_report_sales_transaction";s:29:"grp_report_return_transaction";s:29:"grp_report_return_transaction";s:33:"grp_report_collection_transaction";s:33:"grp_report_collection_transaction";s:22:"grp_report_daily_sales";s:22:"grp_report_daily_sales";s:27:"grp_report_daily_collection";s:27:"grp_report_daily_collection";s:24:"grp_report_monthly_sales";s:24:"grp_report_monthly_sales";s:29:"grp_report_monthly_collection";s:29:"grp_report_monthly_collection";s:24:"grp_report_stock_balance";s:24:"grp_report_stock_balance";s:25:"grp_report_stock_movement";s:25:"grp_report_stock_movement";s:29:"grp_report_stock_in_by_vendor";s:29:"grp_report_stock_in_by_vendor";s:32:"grp_report_stock_out_by_customer";s:32:"grp_report_stock_out_by_customer";s:18:"grp_administration";s:18:"grp_administration";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";s:38:"grp_report_stock_transfer_by_warehouse";s:38:"grp_report_stock_transfer_by_warehouse";s:30:"grp_stock_transaction_internal";s:30:"grp_stock_transaction_internal";s:33:"grp_report_stock_out_internal_use";s:33:"grp_report_stock_out_internal_use";s:16:"grp_price_region";s:16:"grp_price_region";s:30:"grp_report_stock_replenishment";s:30:"grp_report_stock_replenishment";s:14:"grp_stock_card";s:14:"grp_stock_card";}s:34:"t_server_user_group_warehouse_link";a:8:{s:6:"gwl_id";s:6:"gwl_id";s:12:"gwl_group_id";s:12:"gwl_group_id";s:16:"gwl_warehouse_id";s:16:"gwl_warehouse_id";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:15:"t_server_vendor";a:13:{s:6:"vdr_id";s:6:"vdr_id";s:8:"vdr_code";s:8:"vdr_code";s:8:"vdr_name";s:8:"vdr_name";s:10:"vdr_gst_no";s:10:"vdr_gst_no";s:10:"vdr_status";s:10:"vdr_status";s:23:"vdr_discount_percentage";s:23:"vdr_discount_percentage";s:19:"vdr_address_billing";s:19:"vdr_address_billing";s:20:"vdr_address_delivery";s:20:"vdr_address_delivery";s:11:"modified_by";s:11:"modified_by";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}s:18:"t_server_warehouse";a:9:{s:6:"whs_id";s:6:"whs_id";s:8:"whs_code";s:8:"whs_code";s:8:"whs_name";s:8:"whs_name";s:12:"created_date";s:12:"created_date";s:10:"created_by";s:10:"created_by";s:13:"modified_date";s:13:"modified_date";s:11:"modified_by";s:11:"modified_by";s:9:"client_id";s:9:"client_id";s:10:"whs_status";s:10:"whs_status";}s:13:"t_server_zone";a:8:{s:6:"zon_id";s:6:"zon_id";s:8:"zon_code";s:8:"zon_code";s:8:"zon_name";s:8:"zon_name";s:10:"created_by";s:10:"created_by";s:12:"created_date";s:12:"created_date";s:11:"modified_by";s:11:"modified_by";s:13:"modified_date";s:13:"modified_date";s:9:"client_id";s:9:"client_id";}}';
 
 
 
$local_structure = unserialize($serialize_string);

//======================================remote=========================================================================================




//============Database Connection for MySQL  ============================
$dbconn = mysql_connect($remote_db_mysql_host, $remote_db_mysql_user, $remote_db_mysql_password) or die("Could not connect to Remote Database");


//============Select MySQL Database============================================
mysql_select_db($remote_db_mysql_database) or die ("Database not exist at Remote");


unset($remote_structure);

$query="SHOW TABLES ";
$result = mysql_query($query);
while($line = mysql_fetch_array($result,MYSQL_ASSOC))
{

    //echo "<b>".$line["Tables_in_sugarbun_pos"]."</b><br>";



    $query_column="describe ".$line["Tables_in_".$remote_db_mysql_database]." ;  ";
    $result_column = mysql_query($query_column);
    //echo mysql_error();

    while($line_column = mysql_fetch_array($result_column,MYSQL_ASSOC))
    {


       // echo $line_column["Field"];
       // echo " - ";
       // echo $line_column["Field"];
       // echo "<br>";

        $remote_structure[$line["Tables_in_".$remote_db_mysql_database]][$line_column["Field"]]=$line_column["Field"];


    }



}



//============================Comparison================================================
echo "<hr>";
echo "Table Checking:<br>";

$result = array_diff($local_structure, $remote_structure);
print_r($result);




echo "<hr>";
    foreach($local_structure as $key_table=>$value_table)
    {
        echo $key_table." -  ";

        $result = array_diff($local_structure[$key_table], $remote_structure[$key_table]);

            echo "<font size=1>";
                print_r($result);
            echo "</font>";

        echo "<br>";
    }












?>
