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




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

--
-- Table structure for table `blog`
--

CREATE TABLE IF NOT EXISTS `blog` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `blogcategory` varchar(50) NOT NULL,
  `blogtitle` varchar(200) NOT NULL,
  `blogimage` varchar(50) NOT NULL,
  `blogcontent` varchar(1000) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `blogcategory`, `blogtitle`, `blogimage`, `blogcontent`, `date`, `status`) VALUES
(6, '4', 'This is for test', '17122017115415abc.png', '<h3>asdhcasldjhadskjhcna</h3>', '2017-12-30 07:04:45', '1'),
(10, '6', 'This is test', '301220170917571.jpg', '<p>This is only for test of pagination..</p>', '2017-12-30 08:17:57', '1');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE IF NOT EXISTS `blog_category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_category` varchar(255) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`cat_id`, `blog_category`) VALUES
(4, 'SEO'),
(5, 'SMO'),
(6, 'Web Development');

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

--
-- Table structure for table `clientsec`
--

CREATE TABLE IF NOT EXISTS `clientsec` (
  `img_id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(50) NOT NULL,
  PRIMARY KEY (`img_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `clientsec`
--

INSERT INTO `clientsec` (`img_id`, `image`) VALUES
(8, '26122017074148banner-2713339_960_720.jpg'),
(9, '26122017074215banner.jpg'),
(10, '26122017122009lg.png'),
(11, '26122017122020mitsubishi.jpg'),
(12, '26122017122028og-heavy-duty.png'),
(13, '26122017122036Origin-Corporation.jpg'),
(14, '26122017122043panasonic.png');

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

--
-- Table structure for table `client_project`
--

CREATE TABLE IF NOT EXISTS `client_project` (
  `pro_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_name` varchar(255) NOT NULL,
  `subs_date` varchar(20) NOT NULL,
  `bill_cycle_date` varchar(20) NOT NULL,
  `total_amount` float NOT NULL,
  `paid_amount` float NOT NULL,
  `project_cat` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pro_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `client_project`
--

INSERT INTO `client_project` (`pro_id`, `package_name`, `subs_date`, `bill_cycle_date`, `total_amount`, `paid_amount`, `project_cat`, `user_id`, `status`) VALUES
(1, 'premium Plan', '16/12/2017', '16/01/2018', 500, 200, 1, 4, 1),
(2, 'Demo', '', '', 0, 0, 2, 4, 1),
(3, 'Basic', '24-12-2017', '01-02-1970', 299, 299, 1, 4, 1),
(4, 'Basic', '26-12-2017', '26-01-2018', 299, 299, 1, 5, 1),
(5, 'Basic', '26-12-2017', '26-01-2018', 299, 299, 1, 4, 1);

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

--
-- Table structure for table `comment`
--

CREATE TABLE IF NOT EXISTS `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `comment` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`id`, `blog_id`, `name`, `email`, `comment`, `date`, `status`) VALUES
(1, 6, 'atul', 'atul@gmail.com', 'rh digi soft is a seo expert company', '2017-12-30 06:59:16', 1),
(3, 6, 'Ankur Mishra', 'ankur.infoniti@gmail.com', 'This is test only', '2017-12-30 08:16:13', 1);

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

--
-- Table structure for table `invoice`
--

CREATE TABLE IF NOT EXISTS `invoice` (
  `invoiceid` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `project_amount` float NOT NULL,
  `cycle_date` varchar(20) NOT NULL,
  `due_date` varchar(20) NOT NULL,
  `tax` float NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `date` varchar(20) NOT NULL,
  PRIMARY KEY (`invoiceid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`invoiceid`, `project_id`, `project_amount`, `cycle_date`, `due_date`, `tax`, `file_name`, `date`) VALUES
(3, 1, 500, '16/01/2018', '16/02/2018', 90, '', '');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE IF NOT EXISTS `portfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `p_categary` varchar(50) NOT NULL,
  `p_title` varchar(50) NOT NULL,
  `p_image` varchar(50) NOT NULL,
  `p_about` varchar(300) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `p_categary`, `p_title`, `p_image`, `p_about`, `date`, `status`) VALUES
(11, 'seo', 'alarm clock application updated', 'item8.png', '<p>important for us. Save that&nbsp; advkjadlvkadjfdslkd</p>', '2017-12-31 07:50:24', 1),
(12, 'web', 'The Furniture Emporium', 'item1.png', '<p>in only one type of technology. <a href="https://rhdigisoft.com/">We wan</a></p>', '2017-12-31 07:09:01', 1);

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

--
-- Table structure for table `project_category`
--

CREATE TABLE IF NOT EXISTS `project_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pro_cat_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `project_category`
--

INSERT INTO `project_category` (`id`, `pro_cat_name`) VALUES
(1, 'SEO'),
(2, 'SMO'),
(3, 'Web Development');

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

--
-- Table structure for table `project_report`
--

CREATE TABLE IF NOT EXISTS `project_report` (
  `rept_id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) NOT NULL,
  `project_id` int(11) NOT NULL,
  `date` varchar(20) NOT NULL,
  PRIMARY KEY (`rept_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `project_report`
--

INSERT INTO `project_report` (`rept_id`, `file_name`, `project_id`, `date`) VALUES
(3, '16122017124859Admin Panel Documentation.docx', 1, '16-12-2017'),
(4, '24122017114453Admin Panel Documentation.docx', 1, '24-12-2017'),
(5, '24122017120201furniture.csv', 1, '24/12/2017');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE IF NOT EXISTS `ticket` (
  `id` int(10) NOT NULL,
  `tickettitle` varchar(50) NOT NULL,
  `subject` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `reply` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`id`, `tickettitle`, `subject`, `user_id`, `project_id`, `reply`, `date`, `status`) VALUES
(0, 'sylabuss', '', 0, 0, '', '2018-01-01 14:10:50', 1),
(3, 'general', 'only for test', 4, 1, '', '2017-12-30 14:41:01', 1),
(4, 'today is hollyday', 'summer vacation', 4, 2, '', '2017-12-30 14:41:01', 1),
(5, 'Problem in Paypal', 'This is a problem in paypal. Paypal is not working at least.', 4, 1, 'Please verify your data', '2017-12-30 14:41:01', 1),
(6, 'This is another', 'Only for test nothing else is.', 4, 3, '<p>This is test only reply. I want to update</p>', '2017-12-31 06:31:39', 1),
(7, 'Invoice Issue', 'I have an issue in Invoice. Please check it.', 4, 3, '<p>I have inform u that it is checked.</p>', '2017-12-31 06:38:32', 1);

