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

START TRANSACTION;



--
-- Database: `master_admin`
--

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

--
-- Table structure for table `admin_login`
--

CREATE TABLE `admin_login` (
  `id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_type` varchar(255) NOT NULL DEFAULT 'user',
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin_login`
--

INSERT INTO `admin_login` (`id`, `name`, `password`, `user_type`, `status`) VALUES
(1, 'admin', 'admin@123', 'admin', '1');

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

--
-- Table structure for table `master`
--

CREATE TABLE `master` (
  `id` int(11) NOT NULL,
  `tags` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `files` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master`
--

INSERT INTO `master` (`id`, `tags`, `description`, `files`, `status`) VALUES
(1, 'tag', 'Veniam quae dolorib', '11328ban.jpeg', '1'),
(2, 'tag', 'Est debitis magni vo', '30898file_example_MP3_700KB.mp3', '1'),
(3, 'tag', 'Rerum enim nesciunt', '689503SampleVideo_1280x720_1mb.mp4', '1');

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

--
-- Table structure for table `new_log`
--

CREATE TABLE `new_log` (
  `id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_type` varchar(255) NOT NULL DEFAULT 'user',
  `status` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `new_log`
--

INSERT INTO `new_log` (`id`, `name`, `password`, `user_type`, `status`) VALUES
(1, 'Admin', '$2y$10$x3zYptFWPOf07iHCJwMgJe5iKInBgWoCSZx14JXcZFTZ8I7gyLLda', 'admin', '1');

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_login`
--
ALTER TABLE `admin_login`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `new_log`
--
ALTER TABLE `new_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

