--
-- Structure de la table `entiteintegre`
--

CREATE TABLE IF NOT EXISTS `entiteintegre` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`latitude` varchar(20) NOT NULL,
`longitude` varchar(20) NOT NULL,
`nom` varchar(200) NOT NULL,
`types` varchar(200) NOT NULL,
`adresse` varchar(200) NOT NULL,
`telephone` varchar(50) NOT NULL,
`site` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `entiteintegre` (`id`, `date`, `latitude`, `longitude`, `nom`, `types`, `adresse`, `telephone`, `site`) VALUES
('26', '2014-06-28 13:15:53', '32.77624', '-96.80926', 'Hyatt Regency Dallas', 'lodging, establishment', '300 Reunion Blvd  Dallas États-Unis', '+1 214-651-1234', 'http://dallasregency.hyatt.com/en/hotel/home.html?src=agn_tig_hr_lk_googleplus_dfwrd'),
('27', '2014-06-28 13:21:17', '32.78059', '-96.79955', 'Dallas Fish Market', 'restaurant, food, establishment', '1501 Main St, Dallas, TX, United States    ', '+1 214-744-3474', 'http://www.dallasfishmarket.com/');

--
-- Structure de la table `entite`
--

CREATE TABLE IF NOT EXISTS `entite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idEntiteIntegre` int(11) DEFAULT NULL,
`idEntiteFournisseur` varchar(500) NOT NULL,
`idFournisseur` int(11) NOT NULL,
`date` datetime NOT NULL,
`latitude` varchar(20) NOT NULL,
`longitude` varchar(20) NOT NULL,
`nom` varchar(200) NOT NULL,
`adresse` varchar(200) NOT NULL,
`telephone` varchar(50) NOT NULL,
`site` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `entite` (`id`, `idEntiteIntegre`, `idEntiteFournisseur`, `idFournisseur`, `date`, `latitude`, `longitude`, `nom`, `adresse`, `telephone`, `site`) VALUES
('124', '', '6489228', '1', '2014-06-28 13:03:33', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('125', '', '6489228', '1', '2014-06-28 13:04:14', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('126', '', '6489228', '1', '2014-06-28 13:05:07', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('127', '', '6489228', '1', '2014-06-28 13:05:49', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('128', '', '6489228', '1', '2014-06-28 13:06:02', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('129', '', '6489228', '1', '2014-06-28 13:06:29', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('130', '', '7289090', '1', '2014-06-28 13:06:52', '32.78059', '-96.79955', 'Dallas Fish Market', '    United States', '', ''),
('131', '26', '6489228', '1', '2014-06-28 13:12:24', '32.7751', '-96.8096', 'Hyatt Regency Dallas', '    United States', '', ''),
('132', '26', 'ac48f105dfb2bee3fca7228600f06607569e8bf7', '2', '2014-06-28 13:13:25', '32.775927', '-96.809374', 'Hyatt Regency Dallas', 'Reunion Tower, Dallas, TX, United States    ', '+1 214-651-1234', 'http://dallasregency.hyatt.com/en/hotel/home.html?src=agn_tig_hr_lk_googleplus_dfwrd'),
('133', '26', '8409vg4m-10fc988b22e24156b606ce1f8a38d5a0', '3', '2014-06-28 13:14:13', '32.77624', '-96.80926', 'Hyatt Regency-Dallas', '300 Reunion Blvd  Dallas États-Unis', '', ''),
('134', '27', '7289090', '1', '2014-06-28 13:17:32', '32.78059', '-96.79955', 'Dallas Fish Market', '    United States', '', ''),
('135', '27', '8409vg4m-1056dc140dd94587a24feef82a5d7b07', '3', '2014-06-28 13:18:35', '32.78064', '-96.79926', 'Dallas Fish Market', '1501 Main St  Dallas États-Unis', '', ''),
('136', '27', '8409vg4m-38195fe4a9644a16a9c309edd5e5a1ea', '3', '2014-06-28 13:18:55', '32.780727', '-96.79949', 'Chop House Burger', ' 1501 Main Street  Dallas États-Unis', '', ''),
('137', '27', '8c1cd5d744be044ff066e4e1e63af2884a909170', '2', '2014-06-28 13:20:02', '32.780903', '-96.799375', 'Dallas Fish Market', '1501 Main St, Dallas, TX, United States    ', '+1 214-744-3474', 'http://www.dallasfishmarket.com/'),
('138', '27', 'e5349a1ae13a50d46efe58cb3b3ed81b63b10ba2', '2', '2014-06-28 13:20:23', '32.954773', '-96.835129', 'Chamberlain''s Fish Market Grill', '4525 Belt Line Rd, Addison, TX, United States    ', '+1 972-503-3474', 'http://www.chamberlainsseafood.com/');

--
-- Structure de la table `correspondance`
--

CREATE TABLE IF NOT EXISTS `correspondance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idEntiteSource` int(11) NOT NULL,
`idEntiteCible` int(11) NOT NULL,
`idPertinence` int(11) NOT NULL,
`idDifferenceAttributOutil` int(11) NOT NULL,
`idDifferenceAttributExpert` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `correspondance` (`id`, `idEntiteSource`, `idEntiteCible`, `idPertinence`, `idDifferenceAttributOutil`, `idDifferenceAttributExpert`) VALUES
('67', '131', '132', '1', '133', '134'),
('68', '131', '133', '1', '135', '136'),
('69', '134', '135', '1', '137', '138'),
('70', '134', '136', '2', '139', '140'),
('71', '134', '137', '1', '141', '142'),
('72', '134', '138', '2', '143', '144');

--
-- Structure de la table `difference_attribut`
--

CREATE TABLE IF NOT EXISTS `difference_attribut` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coordonnees` tinyint(1) NOT NULL,
`type` tinyint(1) NOT NULL,
`nom` tinyint(1) NOT NULL,
`adresse` tinyint(1) NOT NULL,
`telephone` tinyint(1) NOT NULL,
`site` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `difference_attribut` (`id`, `coordonnees`, `type`, `nom`, `adresse`, `telephone`, `site`) VALUES
('133', '1', '0', '0', '1', '1', '1'),
('134', '1', '0', '0', '0', '0', '0'),
('135', '1', '0', '0', '1', '0', '0'),
('136', '0', '0', '0', '0', '0', '0'),
('137', '0', '0', '0', '1', '0', '0'),
('138', '0', '0', '0', '0', '0', '0'),
('139', '0', '0', '1', '1', '0', '0'),
('140', '0', '0', '1', '1', '0', '0'),
('141', '1', '0', '0', '1', '1', '1'),
('142', '1', '0', '0', '0', '0', '0'),
('143', '1', '0', '0', '1', '1', '1'),
('144', '1', '0', '0', '1', '1', '1');

--
-- Structure de la table `fournisseur`
--

CREATE TABLE IF NOT EXISTS `fournisseur` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nom` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `fournisseur` (`id`, `nom`) VALUES
('1', 'Geonames'),
('2', 'Google'),
('3', 'Here');

--
-- Structure de la table `pertinence`
--

CREATE TABLE IF NOT EXISTS `pertinence` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`etat` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `pertinence` (`id`, `etat`) VALUES
('1', 'correct'),
('2', 'incorrect'),
('3', 'non traité');