
spenowr_photography_assignment table
====================================
ALTER TABLE spenowr_photography_assignment ADD no_of_views INT(11) NOT NULL DEFAULT '0' AFTER status;
ALTER TABLE spenowr_photography_assignment ADD no_of_apply_clicks INT(11) NOT NULL DEFAULT '0' AFTER no_of_views;


spenowr_institute_offerings table
=================================
ALTER TABLE spenowr_institute_offerings ADD promo_requested INT(11) NOT NULL DEFAULT '0' AFTER modified_date;
ALTER TABLE spenowr_institute_offerings ADD promoted INT(11) NOT NULL DEFAULT '0' AFTER promo_requested;

spenowr_product table
=====================
ALTER TABLE spenowr_product ADD promo_requested INT(11) NOT NULL DEFAULT '0' AFTER status;
ALTER TABLE spenowr_product ADD promoted INT(11) NOT NULL DEFAULT '0' AFTER promo_requested;

ALTER TABLE `spenowr_product` ADD `template_id` INT(100) NULL DEFAULT NULL AFTER `promoted`;
ALTER TABLE `spenowr_product` CHANGE `template_id` `template_id` VARCHAR(100) NULL DEFAULT NULL;

spenowr_print_product TABLE
===========================
ALTER TABLE spenowr_print_product ADD cart_count INT(11) NOT NULL DEFAULT '0' AFTER status;
ALTER TABLE spenowr_print_product ADD visit_count INT(11) NOT NULL DEFAULT '0' AFTER cart_count;

spenowr_contest TABLE : Data=18-07-2022
===========================
ALTER TABLE `spenowr_contest` ADD `posted_by` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `contest_id`;
ALTER TABLE `spenowr_contest` CHANGE `active_prize` `active_prize` VARCHAR(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

spenowr_institute_gallery Table:
=================================
ALTER TABLE `spenowr_institute_gallery` ADD `nominated` INT(11) NOT NULL DEFAULT '0' AFTER `share_count`;

spenowr_article_master Table:
=============================
ALTER TABLE `spenowr_article_master` ADD `nominated` INT(11) NOT NULL DEFAULT '0' AFTER `link_artist`;

spenowr_quotes_poem TABLE:
=========================
ALTER TABLE `spenowr_quotes_poem` ADD `nominated` INT(11) NOT NULL DEFAULT '0' AFTER `status`;


/* 8th Aug, 2022 - Added to allow specific values for product status */
spenowr_product TABLE:
=========================
ALTER TABLE `spenowr_product` CHANGE `status` `status` INT(11) NOT NULL DEFAULT '1' COMMENT '0=delete, 1=active, 2=pending, 3=disabled';

/* 10th Aug, 2022 - Added to allow specific values for product status */
Spenowr_product_table
=====================
ALTER TABLE `spenowr_product` ADD `bidding_enabled` INT(11) NOT NULL DEFAULT '0' AFTER `template_id`;
ALTER TABLE `spenowr_product` ADD `min_bidding_price` DECIMAL(9,2) NOT NULL DEFAULT '0.00' AFTER `bidding_enabled`;
ALTER TABLE `spenowr_product` ADD `bidding_count` INT(11) NOT NULL DEFAULT '0' AFTER `min_bidding_price`;



17 August 2022 ALter query Statement
===================================
spenowr_quotes_poem table
=========================
ALTER TABLE `spenowr_feed` CHANGE `feed_description` `feed_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `spenowr_feed` CHANGE `feed_title` `feed_title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';


spenowr_quotes_poem table
=========================
ALTER TABLE `spenowr_quotes_poem` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `spenowr_quotes_poem` CHANGE `title` `title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

spenowr_article_master table
============================
ALTER TABLE `spenowr_article_master` CHANGE `article_title` `article_title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `spenowr_article_master` CHANGE `article_description` `article_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

spenowr_article_comments table
==============================
ALTER TABLE `spenowr_article_comments` CHANGE `comment` `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

spenowr_quote_comment table
===========================
ALTER TABLE `spenowr_quote_comment` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

spenowr_gallery_comment table
=============================
ALTER TABLE `spenowr_gallery_comment` CHANGE `gallery_comment` `gallery_comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


spenowr_photography_assignment table date : 16-09-2022
=============================
ALTER TABLE `spenowr_photography_assignment` ADD `project_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `who_posted`;

/* 16 september 2022- Added to spenowr_institute_gallery table */
spenowr_institute_gallery
=========================
ALTER TABLE `spenowr_institute_gallery` CHANGE `photo_title` `photo_title` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_institute_gallery` CHANGE `photo_description` `photo_description` VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

spenowr_feed
=============
ALTER TABLE `spenowr_feed` CHANGE `activity_comment` `activity_comment` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';



spenowr_donate_details table 16/09/2022
=======================================
-- https://www.phpmyadmin.net/
--




--
-- Database: `dev_nov`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_donate_details`
--

CREATE TABLE `spenowr_donate_details` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `email` text NOT NULL,
  `donate_cost` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `payment_link` varchar(255) NOT NULL,
  `tran_message` varchar(255) NOT NULL,
  `donation_status` varchar(55) NOT NULL,
  `payment_status` varchar(55) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spenowr_donate_details`
--


--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_donate_details`
--
ALTER TABLE `spenowr_donate_details`
  ADD PRIMARY KEY (`id`);





spenowr_user_disable table 16/09/2022
=======================================
-- https://www.phpmyadmin.net/
--




--
-- Database: `dev_nov`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_user_disable`
--

CREATE TABLE `spenowr_user_disable` (
  `id` varchar(255) NOT NULL,
  `email_id` varchar(255) NOT NULL,
  `register_member_id` varchar(255) NOT NULL,
  `disable_reason_option` int(11) NOT NULL DEFAULT '0',
  `disable_reason_desc` varchar(255) NOT NULL,
  `contacted_spenowr` int(11) NOT NULL,
  `additional_feedback` text NOT NULL,
  `contact_no` varchar(100) DEFAULT NULL,
  `interested_to_discuss` int(11) NOT NULL DEFAULT '0',
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_user_disable`
--
ALTER TABLE `spenowr_user_disable`
  ADD PRIMARY KEY (`id`);



spenowr_user_project table 17/09/2022
=======================================

-- https://www.phpmyadmin.net/
--




--
-- Database: `spenowr_backend`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_user_project`
--

CREATE TABLE `spenowr_user_project` (
  `project_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `subcategory` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1 = ongoing ,2=one time',
  `slug_url` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL COMMENT '1 =Active,2=Upcoming,3=paused,4=Closed'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_user_project`
--
ALTER TABLE `spenowr_user_project`
  ADD PRIMARY KEY (`project_id`);



spenowr_bidding_history table 17/09/2022
=======================================

-- https://www.phpmyadmin.net/
--




--
-- Database: `spenowr_backend_02_may`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_bidding_history`
--

CREATE TABLE `spenowr_bidding_history` (
  `id` varchar(255) NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `buyer_id` varchar(255) DEFAULT NULL,
  `seller_id` varchar(255) DEFAULT NULL,
  `price` float(9,2) NOT NULL DEFAULT '0.00',
  `message` varchar(255) NOT NULL,
  `quote_type` int(11) NOT NULL DEFAULT '0' COMMENT '0=first_offer, 1=seller_counter_offer, 2=buyer_counter_offer, 3=seller_accept_offer, 4=buyer_accept_offer, 5=seller_rejected_offer, 6=buyer_rejected_offer',
  `created_date` datetime NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_bidding_history`
--
ALTER TABLE `spenowr_bidding_history`
  ADD PRIMARY KEY (`id`);


spenowr_announcement table 17/09/2022
=======================================
CREATE TABLE `spenowr_announcement` (
  `id` varchar(255) NOT NULL,
  `announcement_title` varchar(255) NOT NULL,
  `announcement_image_path` varchar(255) DEFAULT NULL,
  `button_title` varchar(255) DEFAULT NULL,
  `announcement_url` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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




spenowr_block_user_log table 17/09/2022
=======================================




CREATE TABLE `spenowr_block_user_log` (
  `id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `artist_id` varchar(255) NOT NULL,
  `date_followed` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
ALTER TABLE `spenowr_block_user_log`
  ADD PRIMARY KEY (`id`);





spenowr_user_project table 21/09/2022
=======================================
ALTER TABLE `spenowr_user_project` ADD `image_path` VARCHAR(255) NOT NULL DEFAULT '' AFTER `description`;
ALTER TABLE `spenowr_user_project` ADD `reduce_image_path` VARCHAR(255) NOT NULL DEFAULT '' AFTER `image_path`;
ALTER TABLE `spenowr_user_project` ADD `image_path_thumbnail_path` VARCHAR(255) NOT NULL DEFAULT '' AFTER `reduce_image_path`;

spenowr_announcement table 26/09/2022
=======================================

ALTER TABLE `spenowr_announcement` ADD `announcement_order` INT(11) NOT NULL DEFAULT '0' 
AFTER `announcement_url`, ADD `featured_announcement` VARCHAR(11) NULL DEFAULT NULL AFTER `announcement_order`;

spenowr_contest table 26/09/2022
=======================================

ALTER TABLE `spenowr_contest` ADD `vote_enable` INT(1) NOT NULL DEFAULT '0' AFTER `type`;


ALTER TABLE `spenowr_contest` ADD `min_vote_req` INT(11) NOT NULL DEFAULT '0' AFTER `vote_enable`;


spenowr_announcement table 27/09/2022
=======================================

ALTER TABLE `spenowr_announcement` ADD `route` VARCHAR(255) NULL DEFAULT NULL AFTER `featured_announcement`, ADD `payload` TEXT NULL DEFAULT NULL AFTER `route`;


spenowr_registered_members table 23/09/2022
=======================================
ALTER TABLE `spenowr_registered_members` ADD `otp` INT(11) NULL DEFAULT NULL AFTER `mobile`;
ALTER TABLE `spenowr_registered_members` ADD `mobile_verify` INT(10) NULL DEFAULT NULL AFTER `otp`;




spenowr_article_master table 07/10/2022
=======================================

ALTER TABLE `spenowr_article_master` ADD `polly_response_msg` VARCHAR(255) NULL DEFAULT NULL AFTER `nominated`;
spenowr_feed table 07/10/2022
=============================

ALTER TABLE `spenowr_feed` ADD `polly_response_msg` VARCHAR(255) NULL DEFAULT NULL AFTER `heart_count`;

spenowr_quotes_poem table 07/10/2022
====================================
ALTER TABLE `spenowr_quotes_poem` ADD `polly_response_msg` VARCHAR(255) NOT NULL AFTER `nominated`;
ALTER TABLE `spenowr_quotes_poem` ADD `language` VARCHAR(255) NULL DEFAULT NULL AFTER `polly_response_msg`;

spenowr_quotes_poem table 15/10/2022
====================================

ALTER TABLE `spenowr_quotes_poem` CHANGE `polly_response_msg` `polly_response_msg` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

spenowr_feed table 19/10/2022
====================================
ALTER TABLE `spenowr_feed` ADD `language` VARCHAR(255) NULL DEFAULT NULL AFTER `polly_response_msg`;

spenowr_institute_master table 20/10/2022
====================================
ALTER TABLE `spenowr_institute_master` ADD `type` VARCHAR(255) NOT NULL AFTER `badges`;

spenowr_photography_assignment table
====================================
ALTER TABLE `spenowr_photography_assignment` ADD `remote` INT(1) NULL DEFAULT '0' AFTER `no_of_apply_clicks`;

spenowr_institute_master table
====================================
ALTER TABLE `spenowr_institute_master` ADD `cat_type` VARCHAR(255) NULL DEFAULT NULL AFTER `badges`;

ALTER TABLE `spenowr_institute_master` CHANGE `cat_type` `cat_type` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
spenowr_quotes_poem table
====================================
ALTER TABLE `spenowr_quotes_poem` CHANGE `polly_response_msg` `polly_response_msg` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
spenowr_article_master table
==================================
ALTER TABLE `spenowr_article_master` CHANGE `polly_response_msg` `polly_response_msg` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0';
spenowr_feed table 20/10/2022(by Yakub)
====================================

ALTER TABLE `spenowr_feed` CHANGE `tag` `tag` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

spenowr_quotes_poem table 20/10/2022(by Yakub)
====================================
ALTER TABLE `spenowr_quotes_poem` CHANGE `tag` `tag` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

spenowr_institute_master table
====================================
ALTER TABLE `spenowr_institute_master` ADD `user_language` VARCHAR(255) NOT NULL DEFAULT '0' AFTER `cat_type`;



spenowr_ads table 17-12-2022(by Satya)
=======================================
-- https://www.phpmyadmin.net/
--




--
-- Database: `spenowr_backend`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_ads`
--

CREATE TABLE `spenowr_ads` (
  `ads_id` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(500) NOT NULL,
  `applicable` int(10) NOT NULL COMMENT '0=web,1=mobile',
  `shape` int(10) NOT NULL COMMENT '0=banner,1=vertical,2=horizontal,3=square',
  `web_view_code` varchar(500) NOT NULL,
  `mobile_view_code` varchar(500) NOT NULL,
  `type` int(10) NOT NULL COMMENT '0=Google Ad,1=Internal,2=External',
  `image` varchar(255) NOT NULL,
  `reduced_image` varchar(255) NOT NULL,
  `image_thumbnail` varchar(255) NOT NULL,
  `button_text` varchar(255) NOT NULL,
  `button_link` varchar(255) NOT NULL,
  `link_target` int(10) NOT NULL COMMENT '0=Internal,1=External',
  `module` int(10) NOT NULL COMMENT '0=Home Overlay,1= Feed, 2=List Pages, 3=Detail Pages',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(10) NOT NULL COMMENT '1=Active,0=Incative'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spenowr_ads`
--


--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_ads`
--
ALTER TABLE `spenowr_ads`
  ADD PRIMARY KEY (`ads_id`);


spenowr_quotes_poem table  23/12/2022
====================================

ALTER TABLE `spenowr_quotes_poem` ADD `audio_mode` INT(11) NOT NULL DEFAULT '0' AFTER `language`;
ALTER TABLE `spenowr_quotes_poem` ADD `author` VARCHAR(255) NULL DEFAULT NULL AFTER `language`;
ALTER TABLE `spenowr_quotes_poem` ADD `play_audio` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `audio_mode`;


spenowr_ads table  27/12/2022(by Satya)
=======================================
ALTER TABLE `spenowr_ads` CHANGE `image` `image` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_ads` CHANGE `reduced_image` `reduced_image` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_ads` CHANGE `image_thumbnail` `image_thumbnail` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';


spenowr_photography_assignment table  29/12/2022(by Satya)
===========================================================
ALTER TABLE `spenowr_photography_assignment` ADD `image` VARCHAR(255) NOT NULL DEFAULT '' AFTER `slug_url`;
ALTER TABLE `spenowr_photography_assignment` ADD `image_thumbnail` VARCHAR(255) NOT NULL DEFAULT '' AFTER `image`, ADD `reduced_image` VARCHAR(255) NOT NULL DEFAULT '' AFTER `image_thumbnail`;

spenowr_contest table  29/12/2022(by Satya)
===========================================
ALTER TABLE `spenowr_contest` ADD `web_video_url` VARCHAR(255) NULL DEFAULT NULL AFTER `video_url`;


spenowr_article_master table  29/12/2022(by Sasmita)
===========================================

ALTER TABLE `spenowr_article_master` ADD `language` VARCHAR(255) NULL DEFAULT NULL AFTER `nominated`;
ALTER TABLE `spenowr_article_master` ADD `author` VARCHAR(255) NULL DEFAULT NULL AFTER `language`;
ALTER TABLE `spenowr_article_master` ADD `audio_mode` INT(11) NOT NULL DEFAULT '0' AFTER `language`;
ALTER TABLE `spenowr_article_master` ADD `play_audio` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `audio_mode`;

spenowr_ads table  06/01/2023(by Satya)
=======================================
ALTER TABLE `spenowr_ads` ADD `ads_end_date` DATE NOT NULL AFTER `module`;


spenowr_daily_votes table  04/1/2023(by Sasmita)
===========================================

CREATE TABLE `spenowr_daily_votes` ( `id` VARCHAR(255) NULL , `post_id` VARCHAR(255) NOT NULL , `institute_id` VARCHAR(255) NOT NULL , `Date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() , `post_type` VARCHAR(255) NOT NULL ) ENGINE = InnoDB;
ALTER TABLE `spenowr_daily_votes` ADD PRIMARY KEY(`id`);
ALTER TABLE `spenowr_daily_votes` ADD `vote_count` VARCHAR(255) NOT NULL DEFAULT '0' AFTER `post_type`;
ALTER TABLE `spenowr_daily_votes` CHANGE `Date` `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP();

spenowr_post_entities  06/1/2023(by Sasmita)
===========================================
CREATE TABLE `spenowr_post_entities` ( `post_entitie_id` VARCHAR(255) NOT NULL , `post_id` VARCHAR(255) NOT NULL , `user_id` VARCHAR(255) NOT NULL , `tran_id` VARCHAR(255) NOT NULL , `amount` FLOAT(6,2) NOT NULL DEFAULT '0.00' , `payment_link` VARCHAR(555) NOT NULL , `order_status` VARCHAR(55) NOT NULL , `tran_status` VARCHAR(55) NOT NULL , `payment_mode` VARCHAR(55) NOT NULL , `order_currency` VARCHAR(55) NOT NULL , `tran_time` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' , `tran_message` VARCHAR(255) NOT NULL , `status` INT NOT NULL ) ENGINE = InnoDB;

ALTER TABLE `spenowr_post_entities` ADD PRIMARY KEY(`post_entitie_id`);
ALTER TABLE `spenowr_post_entities` ADD `created_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `tran_message`;
ALTER TABLE `spenowr_post_entities` CHANGE `tran_id` `tran_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_post_entities` CHANGE `payment_link` `payment_link` VARCHAR(555) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_post_entities` CHANGE `order_status` `order_status` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_post_entities` CHANGE `tran_status` `tran_status` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_post_entities` CHANGE `payment_mode` `payment_mode` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_post_entities` CHANGE `tran_message` `tran_message` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';

spenowr_ads table  13/01/2023(by Satya)
=======================================
ALTER TABLE `spenowr_article_master` ADD `article_poly_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `article_description`;



spenowr_contest_winners table  19/01/2023(by Sasmita ->Please check that are available in table or not)
=======================================

ALTER TABLE `spenowr_contest_winners` ADD `apply_reward` INT(1) NOT NULL DEFAULT '0' AFTER `status`

ALTER TABLE `spenowr_contest_winners` ADD `active_notification` INT(1) NOT NULL DEFAULT '0' AFTER `status`

ALTER TABLE `spenowr_contest_winners` ADD `add_point` INT(1) NOT NULL DEFAULT '0' AFTER `active_notification`

ALTER TABLE `spenowr_contest_winners` ADD `reward_point` INT(11) NOT NULL DEFAULT '0' AFTER `add_point`;

ALTER TABLE `spenowr_contest_winners` CHANGE `active_notification` `notofication` INT(1) NOT NULL DEFAULT '0';

spenowr_article_master table  30/01/2023(by Satya)
=======================================
ALTER TABLE `spenowr_article_master` ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `polly_response_msg`, ADD `meta_description` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`;



spenowr_partner_member table  25/01/2023(by sasmita)
=======================================

CREATE TABLE `spenowr_partner_member` ( `agent_id` VARCHAR(255) NOT NULL,`first_name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `last_name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `email` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `mobile` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `password` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `country_id` CHAR(5) NULL DEFAULT NULL , `state_id` CHAR(5) NULL DEFAULT NULL , `city_name` VARCHAR(255) NULL DEFAULT NULL , `street_address` VARCHAR(255) NULL DEFAULT NULL , `id_type` INT(10) NOT NULL DEFAULT '0' , `card_id` VARCHAR(255) NULL DEFAULT NULL , `media_path` VARCHAR(255) NOT NULL , `agent_code` VARCHAR(55) NOT NULL , `onboard_date` DATE NOT NULL , `onboard_buddy` VARCHAR(255) NOT NULL , `referal_code` VARCHAR(55) NOT NULL , `leave_date` DATE NOT NULL , `leave_reason` VARCHAR(255) NOT NULL , `agent_level` VARCHAR(55) NOT NULL , `agent_commission` VARCHAR(55) NOT NULL , `status` INT(1) NOT NULL DEFAULT '1' ) ENGINE = InnoDB;
ALTER TABLE `spenowr_partner_member` ADD `otp` VARCHAR(55) NOT NULL DEFAULT '' AFTER `agent_commission`;
ALTER TABLE `spenowr_partner_member` ADD `mobile_verify` INT NOT NULL DEFAULT '0' AFTER `agent_commission`;


ALTER TABLE `spenowr_partner_member` CHANGE `otp` `otp` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;


spenowr_order table  30/01/2023(by sasmita)
======================================= 
ALTER TABLE `spenowr_order` ADD `agent_code` VARCHAR(255) NULL DEFAULT NULL AFTER `order_payment_status`, ADD `agent_commission` VARCHAR(55) NULL DEFAULT NULL AFTER `agent_code`;


spenowr_refer_agent table  30/01/2023(by sasmita)
======================================= 

CREATE TABLE `spenowr_refer_agent` ( `id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `agent_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `referal_code` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `first_name` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `last_name` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `email` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , `mobile` VARCHAR(55) NOT NULL , `referal_status` INT(1) NOT NULL DEFAULT '0' , `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() , `updated_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() , PRIMARY KEY (`id`)) ENGINE = InnoDB;

spenowr_registered_members table  7/02/2023(by sasmita)
======================================= 

ALTER TABLE `spenowr_registered_members` ADD `agent_id_type` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `skip_profile_completion`, ADD `agent_card_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `agent_id_type`, ADD `agent_profile_image` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `agent_card_id`;
ALTER TABLE `spenowr_registered_members` ADD `agent_code` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `agent_profile_image`, ADD `onboard_date` DATE NULL DEFAULT NULL AFTER `agent_code`, ADD `onboard_buddy` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `onboard_date`, ADD `agent_referal_code` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `onboard_buddy`, ADD `agent_leave_date` DATE NULL DEFAULT NULL AFTER `agent_referal_code`, ADD `agent_leave_reason` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `agent_leave_date`, ADD `agent_commission` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `agent_leave_reason`;
ALTER TABLE `spenowr_registered_members` ADD `agent_document_image` VARCHAR(255) NULL DEFAULT NULL AFTER `agent_profile_image`;

spenowr_product table  07/02/2023(by Satya)
=======================================
ALTER TABLE `spenowr_product` ADD `bulk_order` INT(2) NOT NULL DEFAULT '0' AFTER `bidding_count`;

spenowr_corporate_inventory table  07/02/2023(by Satya)
=======================================



CREATE TABLE `spenowr_corporate_inventory` (
  `inventory_id` varchar(255) NOT NULL,
  `inventory_name` varchar(255) NOT NULL,
  `inventory_department` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `employee_email` varchar(555) DEFAULT NULL,
  `created_date` date NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(2) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `spenowr_corporate_inventory`
  ADD PRIMARY KEY (`inventory_id`);

spenowr_inventory_employee table  07/02/2023(by Satya)
=======================================



CREATE TABLE `spenowr_inventory_employee` (
  `emp_id` varchar(255) NOT NULL,
  `inventory_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `emp_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` int(10) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `spenowr_inventory_employee`
  ADD PRIMARY KEY (`emp_id`);


spenowr_inventory_products table  07/02/2023(by Satya)
=======================================


CREATE TABLE `spenowr_inventory_products` (
  `id` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `inventory_id` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `status` int(10) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

spenowr_registered_members table  07/02/2023(by sasmita)
=======================================
  ALTER TABLE `spenowr_registered_members` CHANGE `otp` `otp` VARCHAR(55) NULL DEFAULT NULL;

spenowr_registered_members table  09/02/2023(by sasmita)
=======================================
  ALTER TABLE `spenowr_registered_members` ADD `country_code` VARCHAR(55) NOT NULL DEFAULT '0' AFTER `password`;
  ALTER TABLE `spenowr_registered_members` ADD `latitude` VARCHAR(255) NULL DEFAULT NULL AFTER `street_address`;								
  ALTER TABLE `spenowr_registered_members` ADD `longitude` VARCHAR(255) NULL DEFAULT NULL AFTER `latitude`;


spenowr_inventory_products table  02/03/2023(by Satya)
=======================================
ALTER TABLE `spenowr_inventory_products` ADD `product_type` VARCHAR(255) NOT NULL AFTER `user_id`, ADD `product_info` TEXT NULL DEFAULT NULL AFTER `product_type`;

spenowr_inventory_employee table  02/03/2023(by Satya)
=======================================
ALTER TABLE `spenowr_inventory_employee` ADD `coupon_code` VARCHAR(55) NULL DEFAULT NULL AFTER `email`, ADD `amount` FLOAT(7,2) NULL DEFAULT NULL AFTER `coupon_code`;

spenowr_corporate_inventory table  02/03/2023(by Satya)
=======================================
ALTER TABLE `spenowr_corporate_inventory` ADD `budget_amount` FLOAT(7,2) NULL DEFAULT NULL AFTER `inventory_department`;



spenowr_inventory_employee table  14/03/2023(by Sasmita)
=======================================
ALTER TABLE `spenowr_inventory_employee` ADD `coupon_status` VARCHAR(10) NULL DEFAULT NULL AFTER `coupon_code`;

spenowr_follow_log  table  22/03/2023(by Sasmita)
ALTER TABLE `spenowr_follow_log` ADD `status` INT(11) NULL DEFAULT NULL AFTER `date_followed`;

spenowr_email_campaign table  13/03/2023(by Satya)
=======================================
ALTER TABLE `spenowr_email_campaign` ADD `rid` VARCHAR(255) NULL DEFAULT NULL AFTER `send_to`;


spenowr_series  table  27/04/2023(by Sasmita)
============================================
CREATE TABLE `spenowr_series` ( `series_id` VARCHAR(191) NOT NULL , `series_title` VARCHAR(255) NOT NULL , `series_description` VARCHAR(255) NOT NULL , `status` INT(1) NOT NULL DEFAULT '1' , `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() , `updated_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() , PRIMARY KEY (`series_id`)) ENGINE = InnoDB;
ALTER TABLE `spenowr_series` ADD `series_image` TEXT NOT NULL AFTER `series_description`;
ALTER TABLE `spenowr_series` ADD `avg_rating` FLOAT(3,1) NOT NULL DEFAULT '0.0' AFTER `status`;


spenowr_article_master table
=======================================

ALTER TABLE `spenowr_article_master` ADD `series_id` VARCHAR(255) NOT NULL AFTER `polly_response_msg`;
ALTER TABLE `spenowr_article_master` ADD `text_translate` VARCHAR(255) NULL DEFAULT NULL AFTER `series_id`;

spenowr_quotes_poem table
========================
ALTER TABLE `spenowr_quotes_poem` ADD `text_translate` VARCHAR(255) NOT NULL AFTER `play_audio`;
ALTER TABLE `spenowr_quotes_poem` CHANGE `text_translate` `text_translate` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

spenowr_quotes_poem table 02/05/2023 (by Sasmita)
=====================

ALTER TABLE `spenowr_quotes_poem` CHANGE `text_translate` `text_translate_desc` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE `spenowr_quotes_poem` ADD `text_translate_title` VARCHAR(255) NULL DEFAULT NULL AFTER `play_audio`;

spenowr_series  table  03/05/2023(by Sasmita)
============================================
ALTER TABLE `spenowr_series` CHANGE `series_description` `series_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

spenowr_series  table  08/05/2023(by Sasmita)
============================================ 
ALTER TABLE `spenowr_series` ADD `featured` VARCHAR(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0' AFTER `avg_rating`;


spenowr_quotes_poem  table  08/05/2023(by Sasmita)
============================================ 
ALTER TABLE `spenowr_quotes_poem` CHANGE `text_translate_title` `text_translate_title` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `spenowr_quotes_poem` CHANGE `text_translate_desc` `text_translate_desc` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

spenowr_institute_master  table  30/05/2023(by satya)
============================================ 
ALTER TABLE `spenowr_institute_master` ADD `ai_point` INT(10) NOT NULL DEFAULT '0' AFTER `credit_point`;

spenowr_series  table  19/06/2023(by satya)
============================================ 
ALTER TABLE `spenowr_series` ADD `posted_by` VARCHAR(255) NOT NULL AFTER `series_id`;

spenowr_series  table  07/07/2023(by satya)
============================================ 
-- https://www.phpmyadmin.net/
--




--
-- Database: `spenowr_backend`
--

-- --------------------------------------------------------

--
-- Table structure for table `spenowr_invoice`
--

CREATE TABLE `spenowr_invoice` (
  `invoice_id` varchar(255) NOT NULL,
  `invoice_type` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `status` int(20) NOT NULL DEFAULT '0' COMMENT '1=paid,0=pending'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `spenowr_invoice`
--
ALTER TABLE `spenowr_invoice`
  ADD PRIMARY KEY (`invoice_id`);


spenowr_series  table  13/07/2023(by satya)
============================================ 
ALTER TABLE `spenowr_institute_gallery` ADD `image_type` VARCHAR(255) NOT NULL AFTER `media_type`;

Update the past data of gallery table  13/07/2023(by satya)
============================================ 
UPDATE spenowr_institute_gallery
JOIN spenowr_feed ON spenowr_feed.module_id = spenowr_institute_gallery.media_id
SET spenowr_institute_gallery.image_type = spenowr_feed.image_type;

spenowr_contest_entities  table  17/07/2023(by satya)
============================================ 
ALTER TABLE `spenowr_contest_entities` CHANGE `payment_link` `payment_link` VARCHAR(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
spenowr_donate_details  table  17/07/2023(by satya)
============================================ 
ALTER TABLE `spenowr_donate_details` CHANGE `payment_link` `payment_link` VARCHAR(1000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;


spenowr_registered_members  table  11/10/2023(by satya)
============================================ 
ALTER TABLE `spenowr_registered_members` ADD `influencer_profile` INT(11) NOT NULL DEFAULT '0' AFTER `seller_profile`;

spenowr_institute_master  table  11/10/2023(by satya)
============================================ 
ALTER TABLE `spenowr_institute_master` ADD `pinterest_url` TEXT NULL AFTER `instagram_url`, ADD `pinterest_followers` INT(25) NULL AFTER `pinterest_url`, ADD `tiktok_url` TEXT NULL AFTER `pinterest_followers`, ADD `tiktok_followers` INT(25) NULL AFTER `tiktok_url`, ADD `facebook_followers` INT(25) NULL AFTER `tiktok_followers`, ADD `instagram_followers` INT(25) NULL AFTER `facebook_followers`, ADD `linkedin_followers` INT(25) NULL AFTER `instagram_followers`;
ALTER TABLE `spenowr_institute_master` ADD `total_follwers` INT(25) NULL AFTER `linkedin_followers`;
ALTER TABLE `spenowr_institute_master` ADD `influencer_profile` INT(11) NOT NULL DEFAULT '0' AFTER `percentage_recommended`;
ALTER TABLE `spenowr_institute_master` ADD `social_category` VARCHAR(555) NULL AFTER `influencer_profile`;

spenowr_institute_offerings  table  19/10/2023(by satya)
============================================ 
ALTER TABLE `spenowr_institute_offerings` ADD `social_media_platform` VARCHAR(555) NULL AFTER `promoted`;
ALTER TABLE `spenowr_service_package` ADD `social_media` VARCHAR(555) NULL AFTER `avg_rating`;
ALTER TABLE `spenowr_order_info` ADD `video_url` VARCHAR(555) NULL AFTER `return_reason_status`;

spenowr_order  table  31/10/2023(by satya)
============================================ 
ALTER TABLE `spenowr_order` ADD `paypal_trnx_id` VARCHAR(255) NULL AFTER `invoice_id`;

spenowr_config  table  18/03/2024(by satya)
============================================ 
ALTER TABLE `spenowr_config` ADD `page_type` VARCHAR(255) NULL AFTER `config_value`;

spenowr_product  table  20/03/2024(by satya)
============================================ 
ALTER TABLE `spenowr_product` ADD `map_products` VARCHAR(255) NULL AFTER `bulk_order`;

spenowr_registered_members  table  30/03/2024(by satya)
============================================ 
ALTER TABLE `spenowr_registered_members` CHANGE `email` `email` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;


25/04/2024(by Yakub)
=======================================================
ALTER TABLE `spenowr_order` ADD `pre_order` INT(11) NULL DEFAULT NULL AFTER `modified_date`;
ALTER TABLE `spenowr_order_info` ADD `pre_order` INT(11) NULL DEFAULT NULL AFTER `created_date`;


03/07/2024(by Yakub)
=======================================================
ALTER TABLE `spenowr_photography_assignment` CHANGE `modified_date` `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `spenowr_photography_assignment` CHANGE `project_id` `project_id` INT(11) NOT NULL DEFAULT '0';


17/07/2024(by Satya)
=======================================================
ALTER TABLE `spenowr_addtocart` ADD `variance_enable` VARCHAR(255) NULL AFTER `quantity`;

ALTER TABLE `spenowr_order` ADD `variance_enable` VARCHAR(255) NULL AFTER `pre_order`, ADD `varient_info` VARCHAR(255) NULL AFTER `variance_enable`;

ALTER TABLE `spenowr_sub_order` ADD `variance_enable` VARCHAR(255) NULL AFTER `suborder_status`, ADD `varient_info` VARCHAR(255) NULL AFTER `variance_enable`;
ALTER TABLE `spenowr_order_info` ADD `variance_enable` VARCHAR(255) NULL AFTER `pre_order`, ADD `varient_info` VARCHAR(255) NULL AFTER `variance_enable`;

20-07-2024 (Rudra)
===================
ALTER TABLE `spenowr_article_master` ADD `play_count` INT(25) NULL DEFAULT NULL AFTER `blogs_status`;
ALTER TABLE `spenowr_series` ADD `play_count` INT(25) NULL DEFAULT NULL AFTER `featured`;

22/07/2024(by Satya)
=======================================================
ALTER TABLE `spenowr_article_master` ADD `youtube_url` VARCHAR(255) NULL DEFAULT NULL AFTER `play_count`, ADD `spotify_url` VARCHAR(255) NULL DEFAULT NULL AFTER `youtube_url`;

22-07-2024(by Rudra)
=====================
ALTER TABLE `spenowr_article_master` CHANGE `series_id` `series_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

25-07-2024 (by Rudra)
=======================
ALTER TABLE `spenowr_quote_comment` CHANGE `comment_name` `comment_name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

31-07-2024 (by Satya)
=======================
INSERT INTO `spenowr_config` (`id`, `config_id`, `config_value`, `status`, `last_modified`) VALUES ('3', 'spenowr-explore', '\r\n\r\n[\r\n	{\r\n		\"type\": \"product\",\r\n		\"title\": \"Jewellery\",\r\n		\"image_path\": \"\",\r\n		\"see_more_button\": {\r\n			\"label\": \"Buy Now\",\r\n			\"url\": \"/shop/products/summary-filter/subCategory/handmade-jewelry\",\r\n			\"target\": \"_blank\"\r\n		},\r\n		\"filter\": \"status = 1 AND subcategory_id = \'handmade-jewelry\' ORDER BY quality_rank DESC\",\r\n		\"limit\": 4,\r\n		\"cat\" : \"handmade-jewelry\"\r\n	},\r\n	{\r\n	\"type\": \"series\",\r\n	\"title\": \"Series\",\r\n	\"image_path\": \"assets/images/theme/default/shop-landing-handbag.png\",\r\n	\"see_more_button\": {\r\n		\"label\": \"Play Now\",\r\n		\"url\": \"/short-quotes-poems/audio/podcast-list/summary-filter/feed_type/series\",\r\n		\"target\": \"_blank\"\r\n	},\r\n	\"filter\": \"\",\r\n	\"limit\": 4,\r\n	\"cat\" : \"series\"\r\n	},\r\n	{\r\n		\"type\": \"article\",\r\n		\"title\": \"Article\",\r\n		\"image_path\": \"\",\r\n		\"see_more_button\": {\r\n			\"label\": \"View All\",\r\n			\"url\": \"/article/list?filter=top-featured-articles\",\r\n			\"target\": \"_blank\"\r\n		},\r\n		\"filter\": \"\",\r\n		\"limit\": 4,\r\n		\"cat\" : \"top-featured-articles\"\r\n	}\r\n	\r\n	\r\n	\r\n]', '1', '2024-07-31 12:27:01.000000');
02-08-2024 (by Satya)
=======================
CREATE TABLE `spenowr_schedular_cornjob` (`corn_job_id` VARCHAR(255) NOT NULL , `title` VARCHAR(255) NOT NULL , `schedular_url` VARCHAR(255) NOT NULL , `time` VARCHAR(255) NOT NULL , `status` INT(10) NULL , `created_date` DATETIME NOT NULL , `updated_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`corn_job_id`)) ENGINE = InnoDB;

12-08-2024 (by Satya)
=======================
ALTER TABLE `spenowr_email_campaign` ADD `category` VARCHAR(255) NULL AFTER `type`;

05-09-2024 (by Satya)
=======================
ALTER TABLE `spenowr_institute_offerings` CHANGE `added_by` `added_by` BIGINT(10) NULL, CHANGE `delivery_mode` `delivery_mode` INT(2) NULL COMMENT '1=Online, 2= face to face', CHANGE `ref_url` `ref_url` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
ALTER TABLE `spenowr_institute_offerings` CHANGE `tutor_id` `tutor_id` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `address` `address` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;
18-10-2024 (by Satya)
=======================
ALTER TABLE `spenowr_institute_master` ADD `animate_point` INT(10) NOT NULL DEFAULT '0' AFTER `ai_point`;


17-10-2024 (by Rudra)
=====================
ALTER TABLE `spenowr_institute_gallery` ADD `animation_status` INT(5) NOT NULL DEFAULT '0' COMMENT '0 - no action ,\r\n1 - generating state,\r\n2 - successfully generated' AFTER `nominated`, ADD `animated_video_url` VARCHAR(255) NULL DEFAULT NULL AFTER `animation_status`;
ALTER TABLE `spenowr_institute_gallery` CHANGE `animated_video_url` `animated_video_url` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

18-10-2024 (by Rudra)
=====================
ALTER TABLE `spenowr_institute_gallery` ADD `animation_task_id` VARCHAR(255) NULL DEFAULT NULL AFTER `animation_status`;

05-11-2024 (by Satya)
=====================
ALTER TABLE `spenowr_institute_gallery` ADD `approve_video_url` INT NOT NULL DEFAULT '0' COMMENT '0=not show on feed page\r\n1= approve to show on feed page' AFTER `animated_video_url`;
06-11-2024 (by Rudra)
======================
ALTER TABLE `spenowr_member_messages` ADD `order_id` VARCHAR(255) NULL DEFAULT NULL AFTER `submited_from`;

08-11-2024 (by Satya)
=====================
ALTER TABLE `spenowr_invoice` ADD `payment_mode` VARCHAR(255) NULL AFTER `invoice_type`, ADD `method` VARCHAR(255) NULL AFTER `payment_mode`, ADD `payment_mode_data` VARCHAR(255) NULL AFTER `method`, ADD `currency` VARCHAR(255) NULL AFTER `payment_mode_data`;


11-11-2024 (Rudra)
==================
CREATE TABLE `spenowr_backend`.`spenowr_custom_offer` (`custom_offer_id` VARCHAR(255) NOT NULL , `buyer_id` VARCHAR(255) NULL DEFAULT NULL , `buyer_mail_id` VARCHAR(255) NULL DEFAULT NULL , `product_or_service` VARCHAR(255) NULL DEFAULT NULL , `message` TEXT NULL DEFAULT NULL , `price` FLOAT(9,2) NULL DEFAULT NULL , `currency` INT(5) NULL DEFAULT NULL , `status` INT(5) NOT NULL DEFAULT '1' , `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`custom_offer_id`)) ENGINE = InnoDB;
ALTER TABLE `spenowr_custom_offer` CHANGE `currency` `currency` VARCHAR(255) NULL DEFAULT NULL;

12-11-2024 (Rudra)
==================
ALTER TABLE `spenowr_member_messages` ADD `product_id` VARCHAR(255) NULL DEFAULT NULL AFTER `order_id`;
ALTER TABLE `spenowr_custom_offer` ADD `product_id` VARCHAR(255) NULL DEFAULT NULL AFTER `product_or_service`, ADD `product_name` VARCHAR(255) NULL DEFAULT NULL AFTER `product_id`;
ALTER TABLE `spenowr_custom_offer` CHANGE `status` `status` INT(5) NOT NULL DEFAULT '1' COMMENT '1-active, 2-approved, 3-rejected';

14-11-2024 (Rudra)
==================
ALTER TABLE `spenowr_member_messages` ADD `order_type` VARCHAR(255) NULL DEFAULT NULL AFTER `product_id`;

26-11-2024 (Rudra)
===================
-- Spenowr Biography Questionnaire Table Creation

CREATE TABLE `spenowr_backend`.`spenowr_biography_questionnaire` (`biography_id` VARCHAR(255) NOT NULL , `name` VARCHAR(255) NULL DEFAULT NULL , `date_of_birth` DATE NULL DEFAULT NULL , `native_place` VARCHAR(255) NULL DEFAULT NULL , `profession` VARCHAR(255) NULL DEFAULT NULL , `what_you_studied` VARCHAR(255) NULL DEFAULT NULL , `educational_background` TEXT NULL DEFAULT NULL , `who_introduced_to_art` TEXT NULL DEFAULT NULL , `who_taught_you_art` TEXT NULL DEFAULT NULL , `obstacles_in_life` TEXT NULL DEFAULT NULL , `where_you-see_in_years` TEXT NULL DEFAULT NULL , `themes_of_artwork` TEXT NULL DEFAULT NULL , `uniqueness_of_artwork` TEXT NULL DEFAULT NULL , `how_long_making_artwork` TEXT NULL DEFAULT NULL , `seek_your_inspiration` TEXT NULL DEFAULT NULL , `fav_artwork` TEXT NULL DEFAULT NULL , `unforgettable_response` TEXT NULL DEFAULT NULL , `like_about_your_work` TEXT NULL DEFAULT NULL , `material_used-in_artwork` TEXT NULL DEFAULT NULL , `dislike_about_your_work` TEXT NULL DEFAULT NULL , `awards_contests` TEXT NULL DEFAULT NULL , `message_to_audience` TEXT NULL DEFAULT NULL , `facebook_id` VARCHAR(255) NULL DEFAULT NULL , `instagram_id` VARCHAR(255) NULL DEFAULT NULL , `profile_picture` VARCHAR(255) NULL DEFAULT NULL , `other_artwork_image` VARCHAR(255) NULL DEFAULT NULL , `award_image` VARCHAR(255) NULL DEFAULT NULL , `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`biography_id`)) ENGINE = InnoDB;

ALTER TABLE `spenowr_biography_questionnaire` CHANGE `where_you-see_in_years` `where_you_see_in_years` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;
ALTER TABLE `spenowr_biography_questionnaire` CHANGE `material_used-in_artwork` `material_used_in_artwork` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;



16-12-2024 (by Satya)
=====================
ALTER TABLE `spenowr_institute_gallery` ADD `nft_list_price` VARCHAR(255) NULL AFTER `approve_video_url`, ADD `nft_status` INT(10) NULL AFTER `nft_list_price`;
ALTER TABLE `spenowr_institute_gallery` CHANGE `nft_status` `nft_status` INT(10) NOT NULL DEFAULT '0';
ALTER TABLE `spenowr_institute_gallery` ADD `nft_trns_hash` VARCHAR(255) NULL AFTER `nft_status`;
ALTER TABLE `spenowr_institute_gallery` ADD `nft_slug_url` VARCHAR(255) NULL AFTER `nft_trns_hash`;
ALTER TABLE `spenowr_product` CHANGE `product_sku` `product_sku` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `seller_id` `seller_id` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT '1=Admin OR profile_id', CHANGE `vendor_id` `vendor_id` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `seller_title` `seller_title` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
ALTER TABLE `spenowr_product` ADD `nft_list_price` VARCHAR(255) NULL AFTER `variant_data`, ADD `nft_status` INT(10) NULL AFTER `nft_list_price`;
ALTER TABLE `spenowr_product` CHANGE `nft_status` `nft_status` INT(10) NOT NULL DEFAULT '0';
ALTER TABLE `spenowr_product` ADD `nft_trns_hash` VARCHAR(255) NULL AFTER `nft_status`;
ALTER TABLE `spenowr_product` ADD `nft_slug_url` VARCHAR(255) NULL AFTER `nft_trns_hash`;
ALTER TABLE `spenowr_product` ADD `starton_image_cid` VARCHAR(255) NULL AFTER `nft_trns_hash`;
ALTER TABLE `spenowr_product` ADD `starton_meta_cid` VARCHAR(255) NULL AFTER `starton_image_cid`;
INSERT INTO `spenowr_config` (`id`, `config_id`, `config_value`, `status`, `last_modified`) VALUES ('4', 'ethereum-value', '\r\n{\r\n \"eth_usd_price\": \"3417.04\",\r\n \"eth_inr_price\": \"290870.78\",\r\n \"label\": \"Ethereum\",\r\n \"currency\": \"ETH\",\r\n \"tenthousand\": \"0.03\",\r\n \"list_payment_in_usd\": \"45\",\r\n \"list_payment_in_inr\": \"3833\"\r\n}', '1', '2022-03-18 00:00:00')

07-01-2025 (Rudra)
===================
ALTER TABLE `spenowr_institute_gallery` ADD `artwork_gif` VARCHAR(255) NULL DEFAULT NULL AFTER `secondary_media4_thumbnail`;
ALTER TABLE `spenowr_institute_gallery` ADD `artwork_gif_thumbnail` VARCHAR(255) NULL DEFAULT NULL AFTER `artwork_gif`, ADD `reduced_artwork_gif` VARCHAR(255) NULL DEFAULT NULL AFTER `artwork_gif_thumbnail`;

04-02-2025 (Satya)
===================
ALTER TABLE `spenowr_email_campaign` CHANGE `email_subject` `email_subject` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `email_button_title` `email_button_title` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `email_button_link` `email_button_link` VARCHAR(555) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `push_notification_title` `push_notification_title` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `push_notification_body` `push_notification_body` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `push_notification_link` `push_notification_link` VARCHAR(555) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `test_email` `test_email` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `notification_email` `notification_email` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;

06-02-2025 (Satya)
===================
ALTER TABLE `spenowr_schedular_cornjob` ADD `one_time` INT(10) NULL DEFAULT NULL AFTER `time`;
ALTER TABLE `spenowr_schedular_cornjob` ADD `last_executed_date` DATE NULL AFTER `status`;

12-02-2025 (Satya)
===================
CREATE TABLE `spenowr_polls` (`polls_id` VARCHAR(255) NOT NULL , `question` VARCHAR(255) NOT NULL , `options` JSON NOT NULL , `start_date` DATETIME NOT NULL , `end_date` DATETIME NOT NULL , `initial_weights` JSON NULL , `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`polls_id`(255))) ENGINE = InnoDB;
CREATE TABLE spenowr_poll_votes ( vote_id VARCHAR(255) NOT NULL PRIMARY KEY, polls_id VARCHAR(255) NOT NULL, selected_option VARCHAR(255) NOT NULL, user_id INT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (polls_id) REFERENCES spenowr_polls(polls_id) );
ALTER TABLE `spenowr_polls` CHANGE `options` `options` JSON NOT NULL, CHANGE `initial_weights` `initial_weights` JSON NULL DEFAULT NULL;
ALTER TABLE `spenowr_polls` ADD `module` INT(10) NOT NULL DEFAULT '0' AFTER `initial_weights`;
ALTER TABLE `spenowr_poll_votes` CHANGE `user_id` `user_id` VARCHAR(255) NOT NULL;
ALTER TABLE `spenowr_polls` ADD `unanimous_user` INT(10) NOT NULL DEFAULT '0' AFTER `module`;

17-02-2025 (Satya)
===================
ALTER TABLE `spenowr_registered_members` ADD `team_profile` INT(10) NOT NULL DEFAULT '0' AFTER `influencer_profile`;
ALTER TABLE `spenowr_institute_master` ADD `team_profile` INT(10) NOT NULL DEFAULT '0' AFTER `percentage_recommended`;