   `category_id` int(20) NOT NULL AUTO_INCREMENT,
   `name` varchar(50) NOT NULL,
   PRIMARY KEY (`category_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
 
 --
 -- Dumping data for table `category`
 --
 
 INSERT INTO `category` (`category_id`, `name`) VALUES
-(1, 'Web Development'),
-(2, 'Animation');
+(1, '.NET'),
+(2, 'C++'),
+(3, 'CSS & HTML'),
+(4, 'Joomla & Drupal'),
+(5, 'Databases'),
+(6, 'Java'),
+(7, 'JavaScript'),
+(8, 'PSD to HTML'),
+(9, 'WordPress'),
+(10, 'Flash'),
+(11, 'iOS, Android & Mobile'),
+(12, 'PHP'),
+(13, 'Software Testing'),
+(14, 'Technology'),
+(15, 'Other');
 
 -- --------------------------------------------------------
 

--

CREATE TABLE IF NOT EXISTS `offer_category` (
  `offer_id` int(15) NOT NULL,
  `category_id` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--

-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `offer_id`, `user_id`, `order_no`, `details`, `status`, `accept_order`) VALUES
(1, 1, 1, '', 'Hi, I will sing a rap.', 'Incomplete', 0),
(2, 2, 2, '', 'Hi, I will dance for you.', 'Incomplete', 0),
(3, 4, 2, '', 'I will Finish your maths homework.', '50% done', 0),
(5, 3, 1, '', 'hi i will do something for you', 'pending', 0),
(6, 3, 1, '', 'hi i will do something for you', 'pending', 0),
(7, 3, 1, '', '', 'pending', 0),
(8, 3, 1, '', '', 'pending', 0),
(9, 3, 1, '', '', 'pending', 0);

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

--
-- Table structure for table `rating`
--

CREATE TABLE IF NOT EXISTS `rating` (
  `order_id` int(15) NOT NULL,
  `rating` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` (`order_id`, `rating`) VALUES
(2, 'Unhappy'),
(1, 'Happy');

