 CREATE TABLE IF NOT EXISTS `items` (
   `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `item_rate` decimal(10,2) NOT NULL,
-  `item_pic` blob NOT NULL,
+  `item_pic` blob,
   `item_stats` char(10) COLLATE utf8_unicode_ci NOT NULL,
-  `item_qty` int(11) NOT NULL,
+  `item_qty` decimal(10,2) NOT NULL,
   `item_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
-  `item_cash_bond` int(11) NOT NULL,
-  `item_rental_mode` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
-  `item_penalty` int(11) NOT NULL,
+  `item_cash_bond` decimal(10,2) NOT NULL,
+  `item_rental_mode` int(5) NOT NULL,
+  `item_penalty` decimal(10,2) NOT NULL,
   `shop_id` int(10) unsigned NOT NULL,
   `subscriber_id` int(10) unsigned NOT NULL,
   PRIMARY KEY (`item_id`),
   KEY `items_shop_id_foreign` (`shop_id`),
   KEY `items_subscriber_id_foreign` (`subscriber_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
+
+--
+-- Dumping data for table `items`
+--
+
+INSERT INTO `items` (`item_id`, `item_rate`, `item_pic`, `item_stats`, `item_qty`, `item_desc`, `item_cash_bond`, `item_rental_mode`, `item_penalty`, `shop_id`, `subscriber_id`) VALUES
+(4, '100.00', NULL, 'active', '5.00', 'Cilpon S23', '500.00', 1, '0.00', 1, 1),
+(11, '200.00', NULL, 'active', '100.00', 'Mouse', '50.00', 2, '500.00', 1, 1),
+(12, '50.00', NULL, 'active', '100.00', 'Casing', '30.00', 3, '250.00', 2, 1);
 
 -- --------------------------------------------------------
 

  `lessee_phoneno` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NULL,
  PRIMARY KEY (`lessee_id`),
  UNIQUE KEY `lessees_lessee_email_unique` (`lessee_email`),
  UNIQUE KEY `lessees_username_unique` (`username`)

  PRIMARY KEY (`subscriber_id`),
  UNIQUE KEY `subscribers_subscriber_email_unique` (`subscriber_email`),
  UNIQUE KEY `subscribers_username_unique` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`subscriber_id`, `subscriber_fname`, `subscriber_midint`, `subscriber_lname`, `subscriber_telno`, `subscriber_email`, `subscriber_paypal_account`, `subscriber_status`, `subscriber_type`, `username`, `password`) VALUES
(1, 'The lessor', NULL, 'Lessors', '132132138756213', 'lessor@lessor.com', NULL, 'pending', '', 'lessor', '92Y75rQnlMR96t7M+9cgnsJEDXFNWlYw1UR+kyvHGuZlBZHa4rGSV3TeWRlScKyajyN/CHL48OOfFnLnozcBIw==');

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

