 --
 -- Database: `resourcecheckout`
 --
-CREATE DATABASE `resourcecheckout` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-USE `resourcecheckout`;
 
 -- --------------------------------------------------------
 

(2, 1, 1, '0000-00-00', 'second comment'),
(3, 1, 1, '2012-05-03', 'Comments yaya'),
(4, 1, 1, '2012-05-03', 'There are damages on this laptop. Bad ones.'),
(5, 1, 1, '2012-05-03', 'Commenting on stuff...'),
(6, 1, 1, '2012-05-03', 'kafdlsfj');

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


  `resource_identifier` varchar(50) NOT NULL,
  `resource_blocktype` enum('Half','Full') NOT NULL,
  PRIMARY KEY (`resource_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` (`resource_id`, `resource_type`, `resource_details`, `resource_identifier`, `resource_blocktype`) VALUES
(1, '1', '25 Computers', 'Room 234', 'Half'),
(4, '3', 'Fifty Pieces', 'Package 2', 'Full');

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

