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

START TRANSACTION;





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

--
-- Table structure for table `item_category`
--

CREATE TABLE `item_category` (
  `c_id` int(11) NOT NULL,
  `c_name` varchar(50) NOT NULL,
  `c_date` date NOT NULL,
  `c_status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_db`
--

CREATE TABLE `item_db` (
  `item_Id` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `regular_price` int(11) NOT NULL,
  `main_category` int(11) NOT NULL,
  `item_description` longtext NOT NULL,
  `item_thumbnail` varchar(100) DEFAULT NULL,
  `item_preview` varchar(100) DEFAULT NULL,
  `item_mainfile` varchar(100) DEFAULT NULL,
  `item_filesize` varchar(50) DEFAULT NULL,
  `item_docufile` varchar(100) DEFAULT NULL,
  `item_tags` text,
  `item_demo_link` varchar(255) DEFAULT NULL,
  `item_youtube_link` varchar(255) DEFAULT NULL,
  `item_youtube_id` varchar(100) DEFAULT NULL,
  `item_sale` int(11) NOT NULL DEFAULT '0',
  `item_loved_by` int(11) NOT NULL DEFAULT '0',
  `item_viewed` int(11) NOT NULL DEFAULT '0',
  `item_status` tinyint(1) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `updated_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_loved`
--

CREATE TABLE `item_loved` (
  `love_id` int(11) NOT NULL,
  `love_uid` int(11) NOT NULL,
  `love_item_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_admin_pages`
--

CREATE TABLE `ot_admin_pages` (
  `page_id` int(11) NOT NULL,
  `page_name` varchar(25) NOT NULL,
  `page_slug` varchar(25) NOT NULL,
  `page_text` text NOT NULL,
  `page_status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_payments`
--

CREATE TABLE `ot_payments` (
  `payment_id` int(11) NOT NULL,
  `p_user_id` int(11) NOT NULL,
  `p_item_id` int(11) NOT NULL,
  `p_total_amt` decimal(18,2) NOT NULL,
  `payment_method` varchar(55) DEFAULT NULL,
  `txn_id` varchar(255) NOT NULL,
  `payment_status` varchar(50) NOT NULL,
  `payment_date` date NOT NULL,
  `complete_status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_tags`
--

CREATE TABLE `ot_tags` (
  `tag_id` int(11) NOT NULL,
  `tag_item_id` int(11) NOT NULL,
  `tag_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_user_wallet`
--

CREATE TABLE `ot_user_wallet` (
  `wallet_id` int(11) NOT NULL,
  `wallet_user_id` int(11) NOT NULL,
  `planId` int(11) NOT NULL,
  `planAmt` decimal(18,2) NOT NULL,
  `bonusAmt` decimal(18,2) NOT NULL,
  `wallet_amt` decimal(18,2) NOT NULL,
  `wallet_txn_id` varchar(555) NOT NULL,
  `wallet_method` varchar(55) NOT NULL,
  `wallet_complete_status` tinyint(1) NOT NULL DEFAULT '0',
  `wallet_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ot_wallet_plan`
--

CREATE TABLE `ot_wallet_plan` (
  `plan_id` int(11) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `plan_amt` decimal(18,2) NOT NULL,
  `bonus_amt` decimal(18,2) NOT NULL DEFAULT '0.00',
  `plan_date` date NOT NULL,
  `plan_status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `item_category`
--
ALTER TABLE `item_category`
  ADD PRIMARY KEY (`c_id`);

--
-- Indexes for table `item_db`
--
ALTER TABLE `item_db`
  ADD PRIMARY KEY (`item_Id`);

--
-- Indexes for table `item_loved`
--
ALTER TABLE `item_loved`
  ADD PRIMARY KEY (`love_id`);

--
-- Indexes for table `ot_admin_pages`
--
ALTER TABLE `ot_admin_pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `ot_payments`
--
ALTER TABLE `ot_payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `ot_tags`
--
ALTER TABLE `ot_tags`
  ADD PRIMARY KEY (`tag_id`);

--
-- Indexes for table `ot_user_wallet`
--
ALTER TABLE `ot_user_wallet`
  ADD PRIMARY KEY (`wallet_id`);

--
-- Indexes for table `ot_wallet_plan`
--
ALTER TABLE `ot_wallet_plan`
  ADD PRIMARY KEY (`plan_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `item_category`
--
ALTER TABLE `item_category`
  MODIFY `c_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item_db`
--
ALTER TABLE `item_db`
  MODIFY `item_Id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item_loved`
--
ALTER TABLE `item_loved`
  MODIFY `love_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ot_admin_pages`
--
ALTER TABLE `ot_admin_pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ot_payments`
--
ALTER TABLE `ot_payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ot_tags`
--
ALTER TABLE `ot_tags`
  MODIFY `tag_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ot_user_wallet`
--
ALTER TABLE `ot_user_wallet`
  MODIFY `wallet_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ot_wallet_plan`
--
ALTER TABLE `ot_wallet_plan`
  MODIFY `plan_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

