 (2, 'administrator', 'admin', 'admin@yahoo.com', 'b8618d99ef3d99481cb52a92be7668656b740d93', 'admin'),
 (3, 'myapos', 'myapos', 'myapos@yahoo.com', '0108b53d87f812f3b05b52cd20db4ad5a8bbf927', 'elaiourgeio'),
 (6, 'myros', 'myros', 'myapos@yahoo.com', 'f88a5652d93d6c1c21b9e4ad4ea54bccdfc23df0', 'elaiourgeio'),
-(8, 'myros1', 'myros1', 'myapos@yahoo.com', '31e93c4f5d3ad50b505b945d7756d8337b42390c', 'elaiourgeio');
-
---
--- Indexes for dumped tables
---
-
---
--- Indexes for table `countries`
---
-ALTER TABLE `countries`
- ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `demands`
+(8, 'myros1', 'myros1', 'myapos@yahoo.com', '31e93c4f5d3ad50b505b945d7756d8337b42390c', 'elaiourgeio'),
+(9, 'testfinal', 'testfinal', 'testfinal@gmail.com', 'e256134fb8a9115a4a6c41d291ae712114e96215', 'elaiourgeio');
+
+--
+-- Περιορισμοί για άχρηστους πίνακες
+--
+
+--
+-- Περιορισμοί για πίνακα `demands`
 --
 ALTER TABLE `demands`
- ADD PRIMARY KEY (`id`), ADD KEY `country_id` (`country_id`), ADD KEY `demand_id` (`product_id`);
-
---
--- Indexes for table `demos`
---
-ALTER TABLE `demos`
- ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `factories`
+  ADD CONSTRAINT `country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `demand_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Περιορισμοί για πίνακα `factories`
 --
 ALTER TABLE `factories`
- ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);
-
---
--- Indexes for table `merges`
---
-ALTER TABLE `merges`
- ADD PRIMARY KEY (`M_Id`);
-
---
--- Indexes for table `offers`
+  ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Περιορισμοί για πίνακα `offers`
 --
 ALTER TABLE `offers`
- ADD PRIMARY KEY (`id`), ADD KEY `factory_id` (`factory_id`,`product_id`), ADD KEY `product_id` (`product_id`);
-
---
--- Indexes for table `posts`
---
-ALTER TABLE `posts`
- ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `products`
---
-ALTER TABLE `products`
- ADD PRIMARY KEY (`id`);
-
---
--- Indexes for table `properties`
+  ADD CONSTRAINT `factory_id` FOREIGN KEY (`factory_id`) REFERENCES `factories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Περιορισμοί για πίνακα `properties`
 --
 ALTER TABLE `properties`
- ADD PRIMARY KEY (`id`), ADD KEY `product_id` (`product_id`), ADD KEY `offer_id` (`offer_id`);
-
---
--- Indexes for table `temp`
---
-ALTER TABLE `temp`
- ADD PRIMARY KEY (`M_Id`);
-
---
--- Indexes for table `users`
---
-ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
-
---
--- AUTO_INCREMENT for dumped tables
---
-
---
--- AUTO_INCREMENT for table `countries`
---
-ALTER TABLE `countries`
-MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
---
--- AUTO_INCREMENT for table `demands`
---
-ALTER TABLE `demands`
-MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
---
--- AUTO_INCREMENT for table `demos`
---
-ALTER TABLE `demos`
-MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
---
--- AUTO_INCREMENT for table `factories`
---
-ALTER TABLE `factories`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
---
--- AUTO_INCREMENT for table `merges`
---
-ALTER TABLE `merges`
-MODIFY `M_Id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
---
--- AUTO_INCREMENT for table `offers`
---
-ALTER TABLE `offers`
-MODIFY `id` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=164;
---
--- AUTO_INCREMENT for table `posts`
---
-ALTER TABLE `posts`
-MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
---
--- AUTO_INCREMENT for table `products`
---
-ALTER TABLE `products`
-MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
---
--- AUTO_INCREMENT for table `properties`
---
-ALTER TABLE `properties`
-MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=119;
---
--- AUTO_INCREMENT for table `temp`
---
-ALTER TABLE `temp`
-MODIFY `M_Id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
---
--- AUTO_INCREMENT for table `users`
---
-ALTER TABLE `users`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
---
--- Constraints for dumped tables
---
-
---
--- Constraints for table `demands`
---
-ALTER TABLE `demands`
-ADD CONSTRAINT `country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-ADD CONSTRAINT `demand_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Constraints for table `factories`
---
-ALTER TABLE `factories`
-ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Constraints for table `offers`
---
-ALTER TABLE `offers`
-ADD CONSTRAINT `factory_id` FOREIGN KEY (`factory_id`) REFERENCES `factories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-ADD CONSTRAINT `product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-
---
--- Constraints for table `properties`
---
-ALTER TABLE `properties`
-ADD CONSTRAINT `offer_id` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-ADD CONSTRAINT `properties_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
+  ADD CONSTRAINT `offer_id` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `properties_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

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

--
-- Table structure for table `factories`
--

CREATE TABLE IF NOT EXISTS `factories` (
`id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `factories`
--

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

/*!40101 SET NAMES utf8 */;

--
-- Βάση: `cakephp`
--
CREATE DATABASE IF NOT EXISTS `cakephp` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `cakephp`;

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

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

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `euzone` varchar(20) NOT NULL,
  `currency` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

INSERT INTO `countries` (`id`, `name`, `euzone`, `currency`) VALUES
(1, 'Brazil', 'NO', 'dollars'),
(4, 'France', 'YES', 'eu'),
(8, 'Greece', 'YES', 'eu');

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

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

CREATE TABLE IF NOT EXISTS `demands` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `country_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL,
  `quantity` int(30) NOT NULL,
  `price` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  KEY `demand_id` (`product_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

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

INSERT INTO `demands` (`id`, `country_id`, `product_id`, `quantity`, `price`) VALUES
(1, 4, 1, 12, 12),
(5, 4, 7, 1000, 3),
(7, 1, 3, 500, 4),
(9, 1, 7, 501, 2.3);

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

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

CREATE TABLE IF NOT EXISTS `demos` (
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `demos` (`id`, `title`, `body`, `created`, `modified`, `user_id`) VALUES
