 /*!40101 SET NAMES utf8 */;
 
 --
--- Database: `cakephp`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `countries`
+-- Βάση: `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,
+  `id` int(10) NOT NULL AUTO_INCREMENT,
   `name` varchar(20) NOT NULL,
   `euzone` varchar(20) NOT NULL,
-  `currency` varchar(20) NOT NULL
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-
---
--- Dumping data for table `countries`
+  `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'),
-(5, 'Greece', 'YES', 'eu');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `demands`
+(8, 'Greece', 'YES', 'eu');
+
+-- --------------------------------------------------------
+
+--
+-- Δομή πίνακα για τον πίνακα `demands`
 --
 
 CREATE TABLE IF NOT EXISTS `demands` (
-`id` int(10) NOT NULL,
+  `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
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-
---
--- Dumping data for table `demands`
+  `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);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `demos`
+(7, 1, 3, 500, 4),
+(9, 1, 7, 501, 2.3);
+
+-- --------------------------------------------------------
+
+--
+-- Δομή πίνακα για τον πίνακα `demos`
 --
 
 CREATE TABLE IF NOT EXISTS `demos` (
-`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=16 ;
 
 --
--- Dumping data for table `demos`
+-- Άδειασμα δεδομένων του πίνακα `demos`
 --
 
 INSERT INTO `demos` (`id`, `title`, `body`, `created`, `modified`, `user_id`) VALUES

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 30, 2014 at 07:35 AM
-- Server version: 5.6.20
-- PHP Version: 5.5.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

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

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

CREATE TABLE IF NOT EXISTS `merges` (
  `M_Id` int(10) NOT NULL AUTO_INCREMENT,
  `demand_id` int(10) DEFAULT NULL,
  `offer_id` int(10) DEFAULT NULL,
  `round_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`M_Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `merges` (`M_Id`, `demand_id`, `offer_id`, `round_id`) VALUES
(1, 1, 150, 1),
(2, 5, 23, 10),
(3, 7, 8, 3),
(4, 9, 23, 13),
(5, 1, 166, 2),
(6, 5, 133, 11),
(7, 7, 24, 4),
(8, 9, 133, 14),
(9, 5, 164, 12),
(10, 7, 30, 5),
(11, 9, 164, 15),
(12, 7, 31, 6),
(13, 7, 105, 7),
(14, 7, 140, 8),
(15, 7, 162, 9);

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

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

CREATE TABLE IF NOT EXISTS `offers` (
