-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 04, 2025 at 10:34 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.2.12

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `purefaithdb`
--

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

--
-- Table structure for table `cb_faithtb`
--

CREATE TABLE `cb_faithtb` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `cb_faith` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL,
  `cur_day` varchar(255) NOT NULL,
  `cur_month` varchar(255) NOT NULL,
  `cur_year` varchar(255) NOT NULL,
  `cur_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cb_faithtb`
--

INSERT INTO `cb_faithtb` (`id`, `user_id`, `cb_faith`, `cur_city`, `ipuser`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES
(1, 'CB1', 'Christianity', '', '', '', '', '', '00:00:00'),
(2, 'CB1', 'Islam', '', '', '', '', '', '19:50:50');

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

--
-- Table structure for table `cb_publisher`
--

CREATE TABLE `cb_publisher` (
  `id` int(11) NOT NULL,
  `userId` varchar(255) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `cur_country` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL,
  `join_date` date NOT NULL,
  `join_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cb_publisher`
--

INSERT INTO `cb_publisher` (`id`, `userId`, `religion`, `cur_country`, `cur_city`, `ipuser`, `join_date`, `join_time`) VALUES
(4, 'CB1', 'christianity', '', '', '127.0.0.1', '2025-10-02', '21:48:27');

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

--
-- Table structure for table `cb_videotb`
--

CREATE TABLE `cb_videotb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `video_name` varchar(255) NOT NULL,
  `video_description` text NOT NULL,
  `video_url` text NOT NULL,
  `thumb_url` varchar(255) NOT NULL,
  `studioId` varchar(255) NOT NULL,
  `faith_id` varchar(255) NOT NULL,
  `cb_action` varchar(255) NOT NULL,
  `cur_country` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL,
  `cur_time` time NOT NULL,
  `curr_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cb_videotb`
--

INSERT INTO `cb_videotb` (`id`, `my_id`, `video_name`, `video_description`, `video_url`, `thumb_url`, `studioId`, `faith_id`, `cb_action`, `cur_country`, `cur_city`, `ipuser`, `cur_time`, `curr_date`) VALUES
(10, 'CB1', 'Am not your enemy', 'top', '68b32d120e4bd-Not Your Enemy by Bobi Wine. Nubian Li.King Saha.mp4', '68b32d120e955.jpg', '19901002', '1', 'Trending', '', '', '', '00:00:00', '0000-00-00'),
(11, 'CB1', 'Aroma music', 'Music of aroma', '68b32e7e49409-AROMA MUSIC & AN-KNOWN DICEY - MPEKE (Official Music Video).mp4', '68b32e7e4978d.jpg', '', '2', '', '', '', '', '00:00:00', '0000-00-00'),
(12, 'CB1', 'Katonda wange', 'The great God of mine', '68b99f5404388-Gwe Katonda Lyrics - Stream Of Life CHoir Ft Pastor W Bugembe.mp4', '68b99f5404755.jpg', '', '1', 'Trending', '', '', '', '00:00:00', '0000-00-00'),
(13, 'CB1', 'The moment you it coming just move out', 'True and yet hot', '68baf4020382f-68b2d49caffd2-sinking ship.mp4', '68baf40203e82.jpg', '', '2', '', '', '', '', '00:00:00', '0000-00-00'),
(14, 'CB1', 'Ready by Gloria', 'Best hit', '68bb02756833f-Gloria Bugie, Vyroota - Ready (Official Music Video).mp4', '68bb027568733.jpg', '', '2', 'Featured', '', '', '', '00:00:00', '0000-00-00'),
(15, 'CB1', 'Party By Omega', 'Hit one', '68bb028de5c34-PARTY - OMEGA 256 X B2C.mp4', '68bb028de5f95.jpg', '', '2', 'Trending', '', '', '', '00:00:00', '0000-00-00'),
(16, 'CB1', 'Wanula Pwace', 'Best hit of the year', '68d6aaaa45312-Wanula peace 1.mp4', '68d6aaaa484a4.jpg', '', '1', '', '', '', '', '00:00:00', '0000-00-00'),
(17, 'CB1', 'Wanula Pwace pt2', 'Massive hit', '68d6ab82e29c7-Wanula peace 2.mp4', '68d6ab82e2f1d.jpg', '', '1', '', '', '', '', '00:00:00', '0000-00-00'),
(18, 'CB1', 'Past the pastor', 'Move forward', '68dd70c8dadb1-Pastor Joel.mp4', '68dd70c8db1d9.jpg', '', '1', '', '', '', '', '00:00:00', '0000-00-00'),
(19, 'CB1', 'Pastor Joel', 'Move to God', '68dd747f0075d-Pastor Joel 2.mp4', '68dd747f00bfa.jpg', '', '1', '', '', '', '', '00:00:00', '0000-00-00'),
(20, 'CB1', 'Joel 3', 'God for me', '68dd76909c9e8-Pastor 3.mp4', '68dd76909ce6f.jpg', '', '1', '', '', '', '', '00:00:00', '0000-00-00');

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

--
-- Table structure for table `clip_commenttb`
--

CREATE TABLE `clip_commenttb` (
  `id` int(11) NOT NULL,
  `videoId` varchar(255) NOT NULL,
  `userId` varchar(255) NOT NULL,
  `clip_comment` text NOT NULL,
  `airtime_amount_coin` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clip_commenttb`
--

INSERT INTO `clip_commenttb` (`id`, `videoId`, `userId`, `clip_comment`, `airtime_amount_coin`) VALUES
(1, 'CB1', '10', 'my first comment', '10000'),
(2, 'CB1', '10', 'Best video of the year 2025', '0'),
(3, 'CB1', '11', 'The goal of the day', '0'),
(4, '10', '0', 'top ten', ''),
(5, '10', '0', 'top ten', ''),
(6, '10', '0', 'top ten', ''),
(7, '11', '0', 'you you', ''),
(8, '11', '0', 'you you', ''),
(9, '11', '0', 'you you', ''),
(10, '10', '0', 'xc', ''),
(11, '11', '0', 'fdgdfgfd dfgd', ''),
(12, '15', '0', 'You and me', ''),
(13, '15', 'CB1', 'You can do it', ''),
(14, '15', 'CB1', 'Sorry babi', ''),
(15, '15', 'CB1', 'Sorry babi 2', ''),
(16, '15', 'CB1', 'The name of the lord should be parised ', ''),
(17, '12', 'CB1', 'So try here not there', ''),
(18, '12', 'CB1', 'Today is ma day', ''),
(19, '12', 'CB1', 'Good news but a lot', ''),
(20, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the ', ''),
(21, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the', ''),
(22, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the', ''),
(23, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the', ''),
(24, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the', ''),
(25, '12', 'CB1', 'I want to know how you become my friend to see, that for sure and name is the my for sure is the name of the lord of the lords for today for today and now fore the', ''),
(26, '12', 'CB1', 'Am good for now ', ''),
(27, '12', 'CB1', '', ''),
(28, '12', 'CB1', 'But if i write in one all will be good', ''),
(29, '12', 'CB1', 'Just trying to express myself', ''),
(30, '12', 'CB1', 'no op', ''),
(31, '12', 'CB1', 'gain and again', ''),
(32, '10', 'CB1', 'system yenaa mufu', ''),
(33, '14', 'CB84', 'Trying to comment', '');

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

--
-- Table structure for table `clip_studiotb`
--

CREATE TABLE `clip_studiotb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `studioName` varchar(255) NOT NULL,
  `studio_id` varchar(255) NOT NULL,
  `cur_country` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clip_studiotb`
--

INSERT INTO `clip_studiotb` (`id`, `my_id`, `studioName`, `studio_id`, `cur_country`, `cur_city`, `ipuser`) VALUES
(2, 'CB1', 'De Beat', '19901002', '', '', '127.0.0.1'),
(3, 'CB2', 'Mood Heat', '19901003', '', '', '');

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

--
-- Table structure for table `clip_videoviewtb`
--

CREATE TABLE `clip_videoviewtb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `videoId` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL,
  `cur_country` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `cur_date` date NOT NULL,
  `cur_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clip_videoviewtb`
--

INSERT INTO `clip_videoviewtb` (`id`, `my_id`, `videoId`, `ipuser`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES
(2, 'CB1', '10', '127.0.0.1', '', '', '2025-07-07', '21:42:48'),
(3, 'CB1', '10', '', '', '', '0000-00-00', '00:00:00');

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

--
-- Table structure for table `daily_wisdomtb`
--

CREATE TABLE `daily_wisdomtb` (
  `id` int(11) NOT NULL,
  `my_id` varchar(255) NOT NULL,
  `wisdom_text` text NOT NULL,
  `source_reference` varchar(255) NOT NULL,
  `faith_id` int(11) NOT NULL,
  `publish_date` date NOT NULL,
  `created_at` datetime NOT NULL,
  `cur_country` varchar(255) NOT NULL,
  `cur_city` varchar(255) NOT NULL,
  `ipuser` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `daily_wisdomtb`
--

INSERT INTO `daily_wisdomtb` (`id`, `my_id`, `wisdom_text`, `source_reference`, `faith_id`, `publish_date`, `created_at`, `cur_country`, `cur_city`, `ipuser`) VALUES
(13, 'CB1', 'The one who is a refuge for themself is difficult to find. Such a one truly sees. — Buddha', 'Dhammapada 170', 12, '2025-09-30', '2025-09-30 20:20:43', '', '', ''),
(14, 'CB1', 'Love your enemies, bless them that curse you, do good to them that hate you.', 'Matthew 5:44', 1, '2025-09-30', '2025-09-30 19:21:39', '', '', ''),
(16, 'CB1', 'We go home mwami wange The one who is a refuge for themself is difficult to find. Such a one truly sees. — Buddha. The one who is a refuge for themself is difficult to find. Such a one truly sees. — Buddha. The one who is a refuge for themself is difficult to find. Such a one truly sees. — Buddha', '', 1, '2025-10-03', '2025-10-03 15:48:11', '', '', '');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cb_faithtb`
--
ALTER TABLE `cb_faithtb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cb_publisher`
--
ALTER TABLE `cb_publisher`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cb_videotb`
--
ALTER TABLE `cb_videotb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `clip_commenttb`
--
ALTER TABLE `clip_commenttb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `clip_studiotb`
--
ALTER TABLE `clip_studiotb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `clip_videoviewtb`
--
ALTER TABLE `clip_videoviewtb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `daily_wisdomtb`
--
ALTER TABLE `daily_wisdomtb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;