UPDATE `s01_00prodsvcs` SET `product_name_en` = 'Other (Eqp./Feed/Etc.)', `created_at` = NULL, `updated_at` = NULL WHERE `s01_00prodsvcs`.`prodsvc_id` = 'EQU';

INSERT INTO `s01_00prodsvcs` (`prodsvc_id`, `product_name_en`, `product_name_si`, `product_name_ta`, `main_prodid`, `is_mainprod`, `have_child`, `created_at`, `created_by`, `updated_at`, `edited_by`) VALUES ('EQPMNT', 'Equipment', 'Equipment_si', 'Equipment_ta', 'EQU', '0', '0', NULL, '', NULL, '');

INSERT INTO `s01_00prodsvcs` (`prodsvc_id`, `product_name_en`, `product_name_si`, `product_name_ta`, `main_prodid`, `is_mainprod`, `have_child`, `created_at`, `created_by`, `updated_at`, `edited_by`) VALUES ('EQU_FEED', 'Feed', 'Feed_si', 'Feed_ta', 'EQU', '0', '0', NULL, '', NULL, ''), ('EQU_FERTI', 'Fertilizer', 'Fertilizer_si', 'Fertilizer_ta', '0', '0', '0', NULL, '', NULL, '');

UPDATE `s01_00prodsvcs` SET `main_prodid` = 'EQU' WHERE `s01_00prodsvcs`.`prodsvc_id` = 'EQU_FERTI';

INSERT INTO `s01_00prodsvcs` (`prodsvc_id`, `product_name_en`, `product_name_si`, `product_name_ta`, `main_prodid`, `is_mainprod`, `have_child`, `created_at`, `created_by`, `updated_at`, `edited_by`) VALUES ('EQU_PHAR', 'Pharmaceuticals', 'Pharmaceuticals_si', 'Pharmaceuticals_ta', 'EQU', '0', '0', NULL, '', NULL, ''), ('EQU_OTHR', 'Others', 'Others_si', 'Others_ta', 'EQU', '0', '0', NULL, '', NULL, '');

ALTER TABLE `s02_02equip_categories` ADD `prodsvc_id` VARCHAR(10) NOT NULL AFTER `equip_cat_name_ta`;

UPDATE `s02_02equip_categories` SET `prodsvc_id` = 'EQPMNT', `created_at` = NULL, `updated_at` = NULL WHERE `s02_02equip_categories`.`equip_catid` = 'EQ19000001'; 

UPDATE `s02_02equip_categories` SET `prodsvc_id` = 'EQPMNT' WHERE `s02_02equip_categories`.`equip_catid` = 'TRACTER';

ALTER TABLE `s02_02equip_categories` ADD CONSTRAINT `fk_equip_categories_productid` FOREIGN KEY (`prodsvc_id`) REFERENCES `s01_00prodsvcs`(`prodsvc_id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

INSERT INTO `u03_00_uri_list` (`uri_id`, `uri`, `uri_des`, `uri_name`, `url_method`, `method`, `class_id`, `allow_mob_access`, `allow_web_access`, `is_active`, `created_at`, `updated_at`) VALUES ('URI00051', 'equipments_for_id/{list_id}', 'equipments for list id', 'equipmentsForListID', 'GET', 'equipmentsForListID', 'ADEQU', '1', '0', '0', '2020-06-08 09:12:00', NULL);

INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00051', '2020-10-12 09:31:00', NULL);

ALTER TABLE `t06_02equip_sale_categories` ADD `equip_desc` TEXT NOT NULL AFTER `equip_comments`, ADD `equip_unit` VARCHAR(20) NOT NULL DEFAULT '' AFTER `equip_desc`;

ALTER TABLE `t06_04equip_purch_categories` ADD `equip_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' AFTER `equip_purch_comments`, ADD `brand_name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `equip_price`, ADD `equip_desc` TEXT NOT NULL AFTER `brand_name`, ADD `equip_unit` VARCHAR(20) NOT NULL DEFAULT '' AFTER `equip_desc`;



\\192.168.1.120\www\html\mod\app\Models\ServiceType.php

\\192.168.1.120\www\html\mod\app\Models\EquipmentCategories.php

\\192.168.1.120\www\html\mod\app\Models\EquipmentSalesCategories.php

\\192.168.1.120\www\html\mod\app\Models\EquipmentPurchasingCategories.php

\\192.168.1.120\www\html\mod\app\Models\EquipmentSales.php

\\192.168.1.120\www\html\mod\app\Models\EquipmentPurchasing.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\AdvertEquipController.php


\\192.168.1.120\www\html\mod\app\Http\Requests\AdvertEquipRequest.php

\\192.168.1.120\www\html\mod\routes\api.php

================================================================================================================

\\192.168.1.120\www\html\mod\app\Models\EquipmentCategories.php

\\192.168.1.120\www\html\mod\app\Http\Requests\EquipmentCategoryRequest.php

\\192.168.1.120\www\html\mod\app\Http\Controllers\Admin\EquipmentCategoryController.php

\\192.168.1.120\www\html\mod\resources\views\equipmentcate\equipmentcate_result.blade.php

\\192.168.1.120\www\html\mod\resources\views\equipmentcate\equipmentcate_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\svcsengaged\svcs_engaged_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\cattlebreed\cattlebreed_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\sementype\sementype_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\feedtype\feedtype_form.blade.php

\\192.168.1.120\www\html\mod\resources\views\equipmentcate\equipmentcate_search.blade.php

======================================================================================================

\\192.168.1.120\www\html\mod\resources\views\advertmaster\advert_master_search.blade.php

\\192.168.1.120\www\html\mod\app\Models\AdvertMaster.php