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

START TRANSACTION;



--
-- Database: `pitman`
--

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

--
-- Table structure for table `audiomp3`
--

CREATE TABLE `audiomp3` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `created_date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audiomp3`
--

INSERT INTO `audiomp3` (`id`, `name`, `file_name`, `created_date`) VALUES
(1, 'Day 22', 'god50.mp3', '2020-07-08 13:01:44'),
(2, 'Day 23', 'test1.mp3', '2020-07-08 13:01:44');

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

--
-- Table structure for table `audioogg`
--

CREATE TABLE `audioogg` (
  `ogg_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `audioMp3_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audioogg`
--

INSERT INTO `audioogg` (`ogg_id`, `name`, `file_name`, `audioMp3_id`, `created_date`) VALUES
(1, 'test ogg name', 'test.ogg', 1, '2020-07-08 13:02:43'),
(2, 'test1 ogg', 'test1.ogg', 2, '2020-07-08 13:02:43');

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

--
-- Table structure for table `audiotxt`
--

CREATE TABLE `audiotxt` (
  `txt_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `audioMp3_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audiotxt`
--

INSERT INTO `audiotxt` (`txt_id`, `name`, `file_name`, `audioMp3_id`, `created_date`) VALUES
(1, 'test 1', 'test.txt', 1, '2020-07-08 13:03:20'),
(2, 'test 2', 'test1.txt', 2, '2020-07-08 13:03:20');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `course_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `course_name` varchar(255) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`course_id`, `category_id`, `course_name`, `created_date`) VALUES
(1, 1, 'Play This Audio for Grade D (80 WPM)', '2020-07-14 14:59:48'),
(2, 1, 'Play This Audio for Grade C (100 WPM)', '2020-07-14 14:59:48'),
(3, 2, 'SSC Steno Typing 100 WPM', '2020-07-14 15:00:33'),
(4, 2, 'SSC Steno Typing 80 WPM', '2020-07-14 15:00:33');

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

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `cate_id` int(11) NOT NULL,
  `cate_name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL COMMENT '1-active , 0-deactive',
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` (`cate_id`, `cate_name`, `status`, `created_date`) VALUES
(1, 'Online SSC Based Skill Test Grade C and D\r\n', 1, '2020-07-14 14:57:32'),
(2, 'Steno Typing', 1, '2020-07-14 14:57:32');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `number` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL COMMENT '0-admin, 1-user',
  `created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `name`, `username`, `email`, `password`, `number`, `city`, `role`, `created_date`) VALUES
(1, 'Administrator', 'admin', 'test@test.com', 'e6e061838856bf47e1de730719fb2609', '9876543210', '', '0', '2020-07-07 11:44:54'),
(3, 'ajay', '', 'ajay@gmail.com', '123456', '22255', 'test', '1', '2020-07-08 11:30:46'),
(4, 'test namae', '', 'test@test.com', '1212', 'tetst', 'usercity', '1', '2020-07-08 12:10:47'),
(5, 'vijay', 'vijaykkk', 'vijay@gmail.com', '9196ec2fd85c6a591b4956cfb0473ed5', '9362154112', 'test', '1', '2020-07-08 12:27:14'),
(6, 'test', 'testst', 'testststts@fj.com', 'e3251075554389fe91d17a794861d47b', '1234567890', 'sfak', '1', '2020-07-08 13:08:53'),
(7, 'user1', 'teamuser1', 'user@team.com', '827ccb0eea8a706c4c34a16891f84e7b', '8596321470', 'team city', '1', '2020-07-08 13:10:15'),
(8, 'test namae', 'testuser', 'test@test.com', 'a4d2f0d23dcc84ce983ff9157f8b7f88', '5462136513', 'test', '1', '2020-07-08 13:16:32'),
(9, 'test namae', 'testuser', 'test@test.com', '884ce4bb65d328ecb03c598409e2b168', '74123456789', 'dsdgsd', '1', '2020-07-08 13:24:38'),
(10, 'sagar kumar', 'sgg988', 'englishshorthand@gmail.com', '25d55ad283aa400af464c76d713c07ad', '08285604328', 'delhi', '1', '2020-07-08 16:39:35'),
(11, 'sagar kumar', 'sgg988', 'englishshorthand@gmail.com', 'b6975124e8dbd0e38d98964f9842b056', '08285604328', 'delhi', '1', '2020-07-08 16:40:45'),
(12, 'sagar kumar', 'jbkjbjn', 'englishshorthand.com@gmail.com', 'bb782e2641c97768649144dbd07441fa', '08285604328', 'delhi', '1', '2020-07-11 17:06:47'),
(13, 'bm', 'kmpoooo', 'englishshorthand@gmail.com', 'e4fdfcbc59cdbb8e158592dc83c28e4d', '08285604328', 'delhi', '1', '2020-07-12 16:34:48'),
(14, 'test namae', 'admina', 'test1212@gmail.com', 'c4ca4238a0b923820dcc509a6f75849b', '8794165', 'sd', '1', '2020-07-14 14:40:53');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `audioogg`
--
ALTER TABLE `audioogg`
  ADD PRIMARY KEY (`ogg_id`);

--
-- Indexes for table `audiotxt`
--
ALTER TABLE `audiotxt`
  ADD PRIMARY KEY (`txt_id`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `course_category`
--
ALTER TABLE `course_category`
  ADD PRIMARY KEY (`cate_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

