-- http://www.phpmyadmin.net
--




--
-- Database: `parth`
--

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

--
-- Table structure for table `tbl_pharmacy`
--

CREATE TABLE `tbl_pharmacy` (
  `pharma_id` int(11) NOT NULL,
  `pharma_name` varchar(250) NOT NULL,
  `hm_id` int(11) NOT NULL,
  `mm_home_folder` varchar(125) NOT NULL,
  `pharma_contact` varchar(150) NOT NULL,
  `pharma_address1` varchar(250) NOT NULL,
  `pharma_address2` varchar(250) NOT NULL,
  `pharma_area` varchar(150) NOT NULL,
  `pharma_city` varchar(150) NOT NULL,
  `pharma_state` varchar(150) NOT NULL,
  `pharma_pincode` varchar(35) NOT NULL,
  `pharma_del` int(11) NOT NULL DEFAULT '0',
  `pharma_create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pharma_modify_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_pharmacy`
--

INSERT INTO `tbl_pharmacy` (`pharma_id`, `pharma_name`, `hm_id`, `mm_home_folder`, `pharma_contact`, `pharma_address1`, `pharma_address2`, `pharma_area`, `pharma_city`, `pharma_state`, `pharma_pincode`, `pharma_del`, `pharma_create_date`, `pharma_modify_date`) VALUES
(1, 'Ellis Bridge Pharmacy', 1, 'pharmacy', '079-224578', 'Below Karanavati Hospital Building', 'Opposite Town Hall', 'Ellis bridge', 'Ahmedabad', 'Gujarat', '380006', 0, '2018-07-11 18:37:37', '2018-07-18 12:21:35'),
(3, 'Samvedana Pharmacy', 3, 'pharmacy02', '079-333333', '3rd Floor,Satya One Complex', ' Opp. Manav Mandir,Near Helmet Circle', 'Memnagar', 'Ahmedabad', 'Gujarat', '380052', 0, '2018-07-11 18:37:37', '2018-07-18 12:23:32'),
(4, 'Happiness Pharmacy', 3, 'pharmacy03', '079-222222', '3rd Floor,Satya One Complex', ' Opp. Manav Mandir,Near Helmet Circle', 'Memnagar', 'Ahmedabad', 'Gujarat', '380052', 0, '2018-07-11 18:37:37', '2018-07-18 12:23:33');

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

--
-- Table structure for table `tbl_schedule_msg`
--

CREATE TABLE `tbl_schedule_msg` (
  `tsm_id` int(11) NOT NULL,
  `hm_id` int(11) DEFAULT NULL,
  `um_id` int(11) DEFAULT NULL,
  `tsm_schedule_val` text,
  `tsm_treatment_day` text,
  `tsm_auto_day` text,
  `tsm_created_by` int(11) DEFAULT NULL,
  `tsm_modify_by` int(11) DEFAULT NULL,
  `tsm_delete_by` int(11) DEFAULT NULL,
  `tsm_created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tsm_modify_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_schedule_msg`
--

INSERT INTO `tbl_schedule_msg` (`tsm_id`, `hm_id`, `um_id`, `tsm_schedule_val`, `tsm_treatment_day`, `tsm_auto_day`, `tsm_created_by`, `tsm_modify_by`, `tsm_delete_by`, `tsm_created_date`, `tsm_modify_date`) VALUES
(1, 1, 1, 'auto', '5', '1', 1, NULL, NULL, '2018-07-18 14:45:10', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_pharmacy`
--
ALTER TABLE `tbl_pharmacy`
  ADD PRIMARY KEY (`pharma_id`);

--
-- Indexes for table `tbl_schedule_msg`
--
ALTER TABLE `tbl_schedule_msg`
  ADD PRIMARY KEY (`tsm_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_pharmacy`
--
ALTER TABLE `tbl_pharmacy`
  MODIFY `pharma_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_schedule_msg`
--
ALTER TABLE `tbl_schedule_msg`
  MODIFY `tsm_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
