   `product_id` int(10) NOT NULL,
   `quantity` int(10) NOT NULL,
   `price` float NOT NULL,
-`id` int(20) NOT NULL
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=164 ;
-
---
--- Dumping data for table `offers`
+  `id` int(20) NOT NULL AUTO_INCREMENT,
+  PRIMARY KEY (`id`),
+  KEY `factory_id` (`factory_id`,`product_id`),
+  KEY `product_id` (`product_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=167 ;
+
+--
+-- Άδειασμα δεδομένων του πίνακα `offers`
 --
 
 INSERT INTO `offers` (`factory_id`, `product_id`, `quantity`, `price`, `id`) VALUES
-(1, 3, 200, 3, 4),
 (8, 3, 656, 5, 8),
 (1, 7, 200, 5, 23),
 (8, 3, 800, 1, 24),
-(1, 3, 500, 1, 29),
 (1, 3, 150, 45, 30),
 (1, 3, 500, 8, 31),
-(15, 1, 200, 300, 90),
 (1, 3, 200, 546, 105),
-(15, 1, 200, 3, 133),
+(15, 7, 200, 3, 133),
 (1, 3, 200, 3, 140),
 (15, 1, 200, 3, 150),
-(15, 3, 500, 5, 162);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `posts`
+(15, 3, 500, 5, 162),
+(1, 7, 200, 2.8, 164),
+(15, 1, 3, 7, 166);
+
+-- --------------------------------------------------------
+
+--
+-- Δομή πίνακα για τον πίνακα `posts`
 --
 
 CREATE TABLE IF NOT EXISTS `posts` (
-`id` int(10) unsigned NOT NULL,
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `title` varchar(50) DEFAULT NULL,
   `body` text,
   `created` datetime DEFAULT NULL,
   `modified` datetime DEFAULT NULL,
-  `user_id` int(11) DEFAULT NULL
+  `user_id` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
 
 --
--- Dumping data for table `posts`
+-- Άδειασμα δεδομένων του πίνακα `posts`
 --
 
 INSERT INTO `posts` (`id`, `title`, `body`, `created`, `modified`, `user_id`) VALUES

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

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
`id` int(10) NOT NULL,
  `name` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `created`, `modified`) VALUES

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

--
-- Δομή πίνακα για τον πίνακα `factories`
--

CREATE TABLE IF NOT EXISTS `factories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `county` varchar(11) NOT NULL,
  `region` varchar(11) NOT NULL,
  `tax` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `type` varchar(30) NOT NULL,
  `telephone` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Άδειασμα δεδομένων του πίνακα `factories`
--

INSERT INTO `factories` (`id`, `user_id`, `county`, `region`, `tax`, `name`, `type`, `telephone`) VALUES
