EVOLUTION-NINJA

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `med`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL,
  `field_names` int(11) NOT NULL,
  `fields` varchar(200) NOT NULL,
  `category_name` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `org_id`, `field_names`, `fields`, `category_name`, `created_at`) VALUES
(7, 1, 1, 'Guidelines', 'COVID and Anaesthesia', '2022-07-14 10:19:27'),
(8, 1, 1, 'Guidelines', 'Anticoagulation and Anaesthesia', '2022-07-14 10:39:27'),
(9, 1, 1, 'Guidelines', 'Diabetes', '2022-07-14 10:45:19'),
(11, 1, 25, 'Basic Sciences', 'Physics', '2022-07-14 17:34:44'),
(12, 1, 22, 'Infographics', 'Pharmacology', '2022-07-15 17:50:29'),
(13, 1, 0, 'Select', 'Regional Anaesthesia', '2022-07-15 17:50:51'),
(14, 1, 0, 'Select', 'Physics', '2022-07-15 17:51:07'),
(15, 1, 22, 'Infographics', 'Regional Anaesthesia', '2022-07-15 17:51:35'),
(16, 1, 22, 'Infographics', 'Physics Basics', '2022-07-15 17:52:02'),
(19, 1, 2, 'Treatment Algorithms', 'Respiratory', '2022-07-16 07:20:52'),
(20, 1, 2, 'Treatment Algorithms', 'Cardiac', '2022-07-16 07:21:11'),
(21, 1, 2, 'Treatment Algorithms', 'General Anaesthesia', '2022-07-16 07:21:59'),
(22, 1, 2, 'Treatment Algorithms', 'Regional Anaesthesia', '2022-07-16 07:22:14'),
(23, 1, 26, 'Fast Facts Series', 'General Anaesthesia', '2022-07-17 11:09:55'),
(24, 1, 26, 'Fast Facts Series', 'Regional Anaesthesia', '2022-07-17 11:10:10'),
(25, 1, 26, 'Fast Facts Series', 'Intensive Care', '2022-07-17 11:10:21'),
(26, 1, 26, 'Fast Facts Series', 'Pain Medicine', '2022-07-17 11:10:46'),
(27, 1, 26, 'Fast Facts Series', 'Basic Sciences', '2022-07-17 11:11:03'),
(28, 1, 26, 'Fast Facts Series', 'History of Anaesthesia', '2022-07-17 11:11:18'),
(30, 1, 0, 'Select', 'Central Nervous System', '2022-07-27 06:49:09'),
(31, 1, 22, 'Infographics', 'Pain ', '2022-07-27 07:03:14'),
(32, 1, 22, 'Infographics', 'Anticoagulation and Anaesthesia', '2022-07-27 07:37:30'),
(33, 1, 22, 'Infographics', 'Monitoring and equipment', '2022-07-27 07:56:45'),
(34, 1, 22, 'Infographics', 'Airway', '2022-07-28 10:11:33'),
(35, 1, 22, 'Infographics', 'Anaesthesia Generic Content', '2022-07-28 10:14:54'),
(36, 1, 3, 'e-Books', 'Loss of Resistance nerve blocks by Dr Shiv Kumar Singh', '2022-09-20 11:15:59'),
(38, 1, 26, 'Fast Facts Series', 'Miscellaneous', '2022-10-06 04:32:45'),
(39, 1, 26, 'Fast Facts Series', 'Joint arthroplasty protocol', '2022-10-06 04:39:55'),
(40, 1, 28, 'TACON 2022 Workshop pre-reading materials', 'POCUS workshop', '2022-11-07 05:13:49'),
(41, 1, 28, 'TACON 2022 Workshop pre-reading materials', 'VICE workshop', '2022-11-11 19:10:42'),
(43, 1, 29, 'Dr Tuhin\'s Regional Anaesthesia \"Block Onn\" series', 'Trunk and Abdomen', '2022-11-18 19:41:28'),
(44, 1, 29, 'Dr Tuhin\'s Regional Anaesthesia \"Block Onn\" series', 'Lower Limb', '2022-11-18 19:54:14'),
(45, 1, 29, 'Dr Tuhin\'s Regional Anaesthesia \"Block Onn\" series', 'Upper Limb', '2022-11-18 19:54:24'),
(46, 1, 29, 'Dr Tuhin\'s Regional Anaesthesia \"Block Onn\" series', 'Head and Neck', '2022-11-18 19:54:33'),
(47, 1, 29, 'Dr Tuhin\'s Regional Anaesthesia \"Block Onn\" series', 'Miscellaneous', '2022-11-18 19:54:45'),
(48, 1, 1, 'Guidelines', 'Cardiovascular Anaesthesia', '2022-11-27 16:50:36'),
(49, 1, 3, 'e-Books', 'Freelancers Handbook', '2022-12-05 13:30:28'),
(50, 1, 1, 'prep', 'prep1', '2022-12-20 15:01:00'),
(51, 1, 1, 'prep', 'prep1', '2022-12-20 15:01:19'),
(52, 1, 3, 'e-Books', 'FARA PNS and US guided Regional Anaesthesia by Dr Shiv Kumar Singh', '2022-12-30 07:15:27'),
(53, 1, 31, 'EDAIC', 'EDAIC II', '2023-03-30 10:41:39'),
(54, 1, 32, 'Mumbai RADS workshop videos', 'Airway management', '2023-04-16 19:14:04'),
(55, 1, 32, 'Mumbai RADS workshop videos', 'Nerve Block for Masses', '2023-04-16 19:14:35'),
(56, 1, 22, 'Infographics', 'RA-Pajunk - Block Guru', '2023-04-26 08:56:14'),
(57, 1, 33, 'MCQ', 'MCQ-Pharma', '2023-07-26 12:16:32'),
(58, 1, 33, 'MCQ', 'MCQ-Physics', '2023-07-26 12:16:48'),
(59, 1, 33, 'MCQ', 'MCQ-Physio', '2023-07-26 12:17:13'),
(60, 1, 34, 'Dr Gurusanthiya\'s PG teaching Notes', 'Cardiovascular Anaesthesia Notes', '2023-08-30 11:45:44'),
(61, 1, 35, 'Pre-reading materials for conferences and workshops', 'Cardiac Symposium I', '2023-09-09 06:47:18'),
(62, 1, 36, 'balu', 'last', '2023-11-03 15:41:20');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
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 */;

EVOLUTION-NINJA

Edit File: categories.sql