
--
-- Database: `test_mdb`
--
CREATE DATABASE `test_mdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test_mdb`;

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

--
-- Table structure for table `projects`
--
CREATE TABLE IF NOT EXISTS `projects` (
  `project_number` varchar(50) NOT NULL,
  PRIMARY KEY (`project_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`project_number`) VALUES
('aaa'),
('bbb');

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

--
-- Table structure for table `projects_history`
--

CREATE TABLE IF NOT EXISTS `projects_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_number` varchar(50) NOT NULL,
  `history_date` date NOT NULL,
  `country` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `projects_history`
--

INSERT INTO `projects_history` (`id`, `project_number`, `history_date`, `country`) VALUES
(1, 'aaa', '2014-08-09', 'france'),
(2, 'aaa', '2014-09-09', 'singapore');

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

--
-- Table structure for table `region`
--

CREATE TABLE IF NOT EXISTS `region` (
  `region` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`region`, `country`) VALUES
('apac', 'singapore'),
('eame', 'france');

