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

-- Dumping data for table `orders`
--

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

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

--
-- 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');


  `description` text NOT NULL,
  `picture` text NOT NULL,
  `date` datetime NOT NULL,
  `instruction` text,
  PRIMARY KEY (`offer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

--
-- Dumping data for table `offering`
--

INSERT INTO `offering` (`offer_id`, `user_id`, `title`, `description`, `picture`, `date`, `instruction`) VALUES
(1, 1, 'I will make a wordpress website', 'I will make a wordpress website according to your needs. Will also do custom styling   as you need.\r\n\r\nPro dev for 5years.', '../images/wordpress.jpg', '2014-03-28 04:33:26', 'Give your colors schemes and info. about the website you want to be made.'),
(2, 1, 'I will do your PHP homework', 'Need help with your homework!! Contact me and will help you create your PHP files.', '../images/php.jpg', '2014-03-25 08:22:28', 'Need info. about what the functions are supposed to do'),
(34, 3, 'I will make a 5 pae web app ', 'I will make a web app that is. max 5 pages. It will have basic fiunctionality. mainly for prototyping', '../images/download (1).jpg', '2014-03-28 13:01:50', 'Give me what your site wants'),
(35, 3, 'I will fix worpdress issues', 'I will fix any [plugin or customise your installation', '../images/wp-banner.jpg', '2014-03-28 13:03:30', 'Give me site domain and control panel also tell me what theme to use'),
(36, 2, 'I will test your website', 'I will do the testing', '../images/bug.jpg', '2014-03-28 15:16:07', 'I want site'),
(38, 2, 'I will make a HTML template ', 'I will do it in simple color scheme', '../images/land.jpg', '2014-03-28 15:23:00', 'Need design');

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

