UPDATE `u03_00_uri_list` SET `uri` = 'showtoextend/{advert_id}', `uri_name` = 'show_to_extend', `method` = 'ShowtoExtend', `created_at` = '2019-12-10 14:50:00', `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00033';
UPDATE `u03_00_uri_list` SET `uri` = 'extendadvert', `uri_name` = 'extend_advertistment', `url_method` = 'POST', `method` = 'extendAd', `created_at` = '2019-12-10 15:26:00', `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00030';
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 ('URI00034', 'showtodiscontinue/{advert_id}', '', 'show_to_discontinue', 'GET', 'ShowtoDiscontinueNRate', 'ADVERT', '1', '0', '1', '2019-12-12 09:55:00', NULL);
INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00034', '2019-12-12 09:55:00', NULL);
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 ('URI00035', 'discontinuenrate/{advert_id}', '', 'discontinue_n_rate', 'POST', 'DiscontinueNRate', 'ADVERT', '1', '0', '1', '2019-12-12 09:55:00', NULL);
INSERT INTO `u02_01_user_role_uri` (`role_id`, `uri_id`, `created_at`, `updated_at`) VALUES ('USER', 'URI00035', '2019-12-12 09:55:00', NULL);
UPDATE `u03_00_uri_list` SET `uri` = 'discontinuenrate', `updated_at` = NULL WHERE `u03_00_uri_list`.`uri_id` = 'URI00035';
ALTER TABLE `t00_02adverts_discontinued` CHANGE `made_atransaction` `made_atransaction` CHAR(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '9' COMMENT '1- YES, 0 - NO, Default 9 - Not answered';
ALTER TABLE `u001_02users` ADD `mobile` VARCHAR(12) NOT NULL AFTER `email`;
INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'ACT', 'Active', ' සක්‍රීයයි', 'செயலில்', 'ACTIVE_STATUS', '1');
INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'EXP', 'Expired', ' කල් ඉකුත් වි ඇත', 'காலாவதியான', 'ACTIVE_STATUS', '2');
INSERT INTO `s01_fxdval` (`rowno`, `val_id`, `val_des_en`, `val_des_si`, `val_des_ta`, `val_type`, `val_ord`) VALUES (NULL, 'DISC', 'Discontinued', 'අත්හිටුවා ඇත', 'நிறுத்தப்பட்டது', 'ACTIVE_STATUS', '3');