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 ('URI00050', 'get_vs_ranges/{district}', 'get vs ranges for district', 'get_vs_ranges', 'GET', 'getVSRangesForDistrict', 'DISTRICT', '1', '0', '1', '2020-06-08 09:12:00', NULL);

INSERT INTO `u002_00classes` (`class_id`, `cls_option_des`, `class_name`, `is_active`, `created_at`, `updated_at`) VALUES ('VSRANGE', 'VS Ranges Controller', 'VSRangesController', '1', '2020-06-08 09:14:00', NULL);

UPDATE `u03_00_uri_list` SET `class_id` = 'VSRANGE', `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00050';

INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00050', '2020-06-08 09:31:00', NULL);

UPDATE `u03_00_uri_list` SET `is_active` = '0' WHERE `u03_00_uri_list`.`uri_id` = 'URI00050';


CREATE TABLE s03_03vetranges(
	vetrange_id varchar(10),
	dist_id varchar(10),
	vetrange_name_en varchar(100),
	vetrange_name_si varchar(100),
	vetrange_name_ta varchar(100)
);

ALTER TABLE `s03_03vetranges` ADD PRIMARY KEY(`vetrange_id`);

ALTER TABLE `s03_03vetranges` CHANGE `vetrange_id` `vetrange_id` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, CHANGE `dist_id` `dist_id` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `vetrange_name_en` `vetrange_name_en` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `vetrange_name_si` `vetrange_name_si` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `vetrange_name_ta` `vetrange_name_ta` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `s03_03vetranges` ADD CONSTRAINT `fk_dist_id` FOREIGN KEY (`dist_id`) REFERENCES `s03_02district`(`dist_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;


ALTER TABLE `t05_01aisvc_vetranges` CHANGE `vet_range` `vetrange_id` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;

ALTER TABLE `t05_01aisvc_vetranges` ADD CONSTRAINT `fk_aiscvven_vet_rangeid` FOREIGN KEY (`vetrange_id`) REFERENCES `s03_03vetranges`(`vetrange_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;


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