/************** 30 October 2019 Start ****************/


CREATE TABLE `jp_custom_ads` (
  `id` int(11) NOT NULL,
  `home_page` varchar(50) DEFAULT NULL,
  `link1` varchar(250) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `single_page_top` varchar(50) DEFAULT NULL,
  `single_page_bottom` varchar(50) DEFAULT NULL,
  `both_page` varchar(50) DEFAULT NULL,
  `add_img` varchar(300) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `jp_custom_ads` (`id`, `home_page`, `link1`, `status`, `single_page_top`, `single_page_bottom`, `both_page`, `add_img`) VALUES
(1, 'yes', 'http://a.net', 'InActive', 'yes', 'yes', 'no', 'uploads/ads/marker.png');
ALTER TABLE `jp_custom_ads`
 ADD PRIMARY KEY (`id`);
  ALTER TABLE `jp_custom_ads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

CREATE TABLE `jp_notification` (
  `id` int(11) NOT NULL,
  `title` text CHARACTER SET utf8,
  `message` text CHARACTER SET utf8,
  `date1` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `jp_notification`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `jp_notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

ALTER TABLE `jp_setting` ADD `paypal_status` TEXT NULL AFTER `privacy_policy`;
ALTER TABLE `jp_setting` ADD `paypal_email` TEXT NULL AFTER `paypal_status`;
ALTER TABLE `jp_setting` ADD `payu_status` TEXT NULL AFTER `paypal_email`;
ALTER TABLE `jp_setting` ADD `merchant_key` TEXT NULL AFTER `payu_status`;
ALTER TABLE `jp_setting` ADD `merchant_salt` TEXT NULL AFTER `merchant_key`;
ALTER TABLE `jp_setting` ADD `terms_condition_update_date` TEXT NULL AFTER `merchant_salt`;
ALTER TABLE `jp_setting` ADD `privacy_policy_update_date` TEXT NULL AFTER `terms_condition_update_date`;
ALTER TABLE `jp_setting` ADD `google_client_id` TEXT NULL AFTER `privacy_policy_update_date`;
ALTER TABLE `jp_setting` ADD `google_client_secret` TEXT NULL AFTER `google_client_id`;
ALTER TABLE `jp_setting` ADD `	google_login_status` TEXT NULL AFTER `google_client_secret`;


/************** 30 October 2019 End ****************/

/************** 30 April 2020 Start ****************/


ALTER TABLE `jp_setting` ADD `chat_system` varchar(100) DEFAULT 'false' AFTER `google_login_status`;

INSERT INTO `jp_language` (`language_key`, `language_type`, `english`) VALUES
('chat_text', 'menu_header', 'Chats'),('chat_btn_text', 'home_page', 'Chat'),('rchat_btn_text', 'recruiter_home', 'Chat'),('chat_btn_text', 'my_applied_job_page', 'Chat'),('chat_btn_text', 'single_job', 'Chat'),('chat_text', 'recruiter_header', 'Chats');

CREATE TABLE `jp_chat_message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_from` varchar(500),
  `user_to` varchar(500),
  `msg` text,
  `deliver` int,
  `date` datetime,
  PRIMARY KEY (id),
  INDEX (id)
)CHARACTER SET utf8 COLLATE utf8_unicode_ci;


/************** 30 April 2020 End ****************/