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

START TRANSACTION;



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

--
-- Table structure for table `appointment`
--

CREATE TABLE `appointment` (
  `id` int(11) NOT NULL,
  `appointmentid` varchar(30) NOT NULL,
  `userid` int(11) NOT NULL DEFAULT '0',
  `providerid` int(11) NOT NULL,
  `fromdate` varchar(30) NOT NULL DEFAULT '',
  `amount` int(11) NOT NULL DEFAULT '0',
  `adminamount` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `appointment`
--

INSERT INTO `appointment` (`id`, `appointmentid`, `userid`, `providerid`, `fromdate`, `amount`, `adminamount`, `status`, `created_at`, `updated_at`) VALUES
(1, '1594490453', 31, 34, '1594490453', 200, 20, 0, '2020-07-11 18:01:34', '2020-07-11 18:02:03');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `image` varchar(255) NOT NULL DEFAULT '',
  `desc` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`, `status`, `created_at`, `updated_at`, `image`, `desc`) VALUES
(21, 'Heart specialist', 1, '2020-07-08 17:09:20', '2020-07-08 17:09:20', 'f6fa2af9-515f-44bf-9e44-5895021da922.png', 'heart specialist'),
(22, 'Brain specialist', 1, '2020-07-08 17:10:01', '2020-07-08 17:10:01', 'cb9678c0-02e8-4169-b1ee-179bc7d01bf3.png', 'brain specialist'),
(23, 'Eyes specialist', 1, '2020-07-08 17:10:40', '2020-07-08 17:10:40', 'ef85ae0a-ba5e-4666-8b7b-adc1bd0a0057.png', 'Eyes specialist'),
(24, 'Cancer specialist', 1, '2020-07-08 17:12:13', '2020-07-08 17:14:23', '7c87b4c6-849a-4ca4-bed3-1258aaa0e57a.png', 'cancer specialist');

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

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `message` varchar(255) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` (`id`, `userid`, `name`, `email`, `message`, `status`, `created_at`, `updated_at`) VALUES
(1, 4, 'rahul', 'rahulwalia@cqlsys.com', 'testing Content', 0, '2020-04-16 10:22:24', '2020-04-16 10:22:24'),
(2, 4, 'rahul', 'rahulwalia@cqlsys.com', 'testing Content', 0, '2020-04-16 10:22:28', '2020-04-16 10:22:28');

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(11) NOT NULL,
  `questions` text NOT NULL,
  `answers` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `questions`, `answers`, `status`, `createdAt`, `updatedAt`) VALUES
(1, 'Regularly update each page?', 'It\'s important that every FAQ page you have is always accurate. As your organization faces product launches and updates, your FAQ pages should reflect these changes as well. This means your team needs to consistently review each page and revise it after launching new features.', 1, '2020-02-20 07:01:33', '2020-02-20 07:25:52'),
(2, 'Organize questions by category?', 'What can also be tedious is listing all the questions in a random order. This is especially frustrating for customers who have several related questions regarding a single topic. Thus, it\'s helpful if you divide up questions into overarching topics, such as products, security, and billing.', 1, '2020-02-20 07:01:33', '2020-02-20 09:24:06'),
(3, 'Link top questions?', 'It\'s good to have categories laid out on the landing page of your FAQ section. However, there are likely some questions that are more popular than others. To save customers even more time, these top questions should have their own section and a link to their answer at the top of your FAQ page. ', 1, '2020-02-20 07:01:33', '2020-02-20 09:24:29');

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

--
-- Table structure for table `notifcations`
--

CREATE TABLE `notifcations` (
  `id` int(11) NOT NULL,
  `senderId` int(11) NOT NULL,
  `recieverId` int(11) NOT NULL,
  `notiType` int(11) NOT NULL,
  `message` varchar(200) NOT NULL DEFAULT '',
  `data` text NOT NULL,
  `isRead` int(11) NOT NULL DEFAULT '0' COMMENT '0=unread,1read',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `id` int(11) NOT NULL,
  `terms_content` text NOT NULL,
  `privacyPolicy` text NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` (`id`, `terms_content`, `privacyPolicy`, `status`, `created_at`, `updatedAt`) VALUES
(1, '<h2>Terms and Conditions</h2>\r\n', '<h2>Privacy Policy</h2>\r\n', '1', '2019-11-14 11:30:54', '2020-07-08 15:56:33');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `jobId` varchar(30) NOT NULL,
  `userid` int(11) NOT NULL,
  `providerid` int(11) NOT NULL,
  `totalprice` varchar(20) NOT NULL,
  `adminComission` varchar(20) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `jobId`, `userid`, `providerid`, `totalprice`, `adminComission`, `status`, `created_at`, `updated_at`) VALUES
(1, '1594490453', 31, 34, '200', '20', 1, '2020-04-17 04:24:57', '2020-04-17 04:24:57');

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

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

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

--
-- AUTO_INCREMENT for table `notifcations`
--
ALTER TABLE `notifcations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

