CREATE TABLE IF NOT EXISTS `clic` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_keyword` int(10) unsigned NOT NULL,
  `id_company` int(10) unsigned NOT NULL,
  `date_clic` datetime NOT NULL,
  `number` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;

INSERT INTO `clic` (`id`, `id_keyword`, `id_company`, `date_clic`, `number`) VALUES
(1, 1, 1, '2008-01-01 15:00:00', 100),
(2, 1, 1, '2008-01-01 15:00:00', 100),
(3, 2, 1, '2008-01-01 15:00:00', 100),
(4, 3, 1, '2008-01-01 15:00:00', 100),
(5, 3, 2, '2008-01-01 15:00:00', 100),
(6, 4, 2, '2008-01-01 15:00:00', 100),
(7, 3, 2, '2008-01-01 15:00:00', 100),
(8, 3, 1, '2008-01-01 15:00:00', 100),
(9, 4, 4, '2008-01-01 15:00:00', 100);

CREATE TABLE IF NOT EXISTS `company` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

INSERT INTO `company` (`id`, `name`) VALUES
(1, 'Microsoft'),
(2, 'Yahoo'),
(3, 'Ebay'),
(4, 'Google');

CREATE TABLE IF NOT EXISTS `keyword` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

INSERT INTO `keyword` (`id`, `name`) VALUES
(1, 'Sport'),
(2, 'Toy'),
(3, 'Ebook'),
(4, 'Game');

CREATE TABLE IF NOT EXISTS `visualisation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_keyword` int(10) unsigned NOT NULL,
  `id_company` int(10) unsigned NOT NULL,
  `date_view` datetime NOT NULL,
  `number` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;

INSERT INTO `visualisation` (`id`, `id_keyword`, `id_company`, `date_view`, `number`) VALUES
(1, 1, 1, '2008-01-01 15:00:00', 100),
(2, 1, 1, '2008-01-01 17:00:00', 100),
(3, 1, 1, '2008-01-01 18:00:00', 100),
(4, 2, 1, '2008-01-01 18:00:00', 100),
(5, 2, 1, '2008-01-01 19:00:00', 100),
(6, 1, 2, '2008-01-01 15:00:00', 100),
(7, 2, 3, '2008-01-01 15:00:00', 100),
(8, 1, 3, '2008-01-01 15:00:00', 100),
(9, 3, 4, '2008-01-01 15:00:00', 100),
(10, 2, 4, '2008-01-01 15:00:00', 100);