-- 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');

--
-- 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`);

--
-- 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;
COMMIT;

