-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 15, 2023 at 03:31 PM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 7.4.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


-- Add New Columns to exisiting tables:

ALTER TABLE `purchases`
  ADD `transfer_proof_txt` text NOT NULL DEFAULT '' COMMENT '' AFTER `payment_method`,
  ADD `transfer_proof_img` text NOT NULL DEFAULT '' COMMENT '' AFTER `payment_method`,
  MODIFY `status` ENUM('pending','checking','paid','expired') NOT NULL DEFAULT 'pending' COMMENT 'checking means need admin verfiy and expired means not paid and canceled';


ALTER TABLE `subscribes`
  ADD `duration_hour` int(11) NOT NULL DEFAULT 0 COMMENT 'duration month is deprecated in db4' AFTER `duration`,
  ADD `extendable` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'used for free demo subscribes' AFTER `duration`,
  ADD `is_amazing_discount` tinyint(4) NOT NULL DEFAULT 0 COMMENT '' AFTER `price_off`,
  ADD `amazing_discount_deadline`text NOT NULL DEFAULT '' COMMENT '' AFTER `price_off`;


ALTER TABLE `navdrawer_items`
  ADD `bold_text` tinyint(4) NOT NULL DEFAULT 0 COMMENT '' AFTER `text`,
  ADD `icon_color` text NOT NULL DEFAULT '' COMMENT '' AFTER `text`,
  ADD `text_color` text NOT NULL DEFAULT '' COMMENT '' AFTER `text`;


ALTER TABLE `categories`
  ADD `quick_add_to_cart` tinyint(4) NOT NULL DEFAULT 0 COMMENT '' AFTER `show_price`,
  ADD `actionbar_color` text NOT NULL DEFAULT '' COMMENT '' AFTER `arrow_color`,
  ADD `background_color` text NOT NULL DEFAULT '' COMMENT '' AFTER `arrow_color`,
  ADD `background_img` text NOT NULL DEFAULT '' COMMENT '' AFTER `arrow_color`;


ALTER TABLE `coupons`
  ADD `post_limit` int(11) NOT NULL DEFAULT 0 COMMENT '' AFTER `category_limit`;


COMMIT;