 -- http://www.phpmyadmin.net
 --
 -- Host: 127.0.0.1
--- Generation Time: Feb 16, 2017 at 05:23 PM
+-- Generation Time: Feb 18, 2017 at 11:44 PM
 -- Server version: 5.6.25
 -- PHP Version: 5.6.11
 

(194, 23, '200', 0, 0, 'BUSINESS INSPECTION FEE', 1, '2017-02-16 15:21:30', '2017-02-16 15:21:30'),
(195, 23, '350', 0, 0, 'BUSINESS PLATE & STICKER', 1, '2017-02-16 15:21:30', '2017-02-16 15:21:30'),
(196, 23, '1200', 0, 0, 'SANITARY PERMIT FEE', 1, '2017-02-16 15:21:30', '2017-02-16 15:21:30'),
(197, 23, '15000', 0, 0, 'HEALTH CARD FEE', 1, '2017-02-16 15:21:30', '2017-02-16 15:21:30');

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


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

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `itemId` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`itemId`, `name`, `createdAt`, `updatedAt`) VALUES
(1, 'DTI/SEC/CDA Permit', '2017-02-18 06:33:54', '2017-02-18 13:08:51'),
(2, 'Barangay Clearance', '2017-02-18 06:33:54', '2017-02-18 06:33:54'),
(3, 'Fire Safety Insurance Certificate', '2017-02-18 06:33:54', '2017-02-18 13:09:01'),
(4, 'Zoning Clearance', '2017-02-18 06:33:54', '2017-02-18 06:33:54'),
(5, 'Engineering Clearance', '2017-02-18 06:33:54', '2017-02-18 06:33:54'),
(6, 'Sanitary Permit', '2017-02-18 06:33:54', '2017-02-18 06:33:54'),
(7, 'Environmental Clearance', '2017-02-18 06:33:54', '2017-02-18 06:33:54');

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

--
-- Table structure for table `lessors`
--

