SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `travel_agency` (
  `id` int(11) NOT NULL auto_increment,
  `continent` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `stars_hotel` int(1) NOT NULL,
  `num_days` int(2) NOT NULL,
  `date_start` date NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
INSERT INTO `travel_agency` (`id`, `continent`, `country`, `city`, `stars_hotel`, `num_days`, `date_start`, `price`) VALUES
(1, 'Europe', 'Italy', 'Rome', 4, 12, '2013-02-07', 1000),
(2, 'Europe', 'Italy', 'Venice', 3, 20, '2013-03-01', 2000),
(3, 'Europe', 'Spain', 'Madrid', 5, 7, '2013-03-08', 600),
(4, 'Europe', 'Spain', 'Barcelona', 4, 10, '2013-03-08', 700),
(5, 'Europe', 'Austria', 'Vienna', 3, 14, '2013-07-10', 1000),
(6, 'Europe', 'Germany', 'Berlin', 4, 10, '2013-05-01', 1000),
(7, 'Europe', 'Germany', 'Hamburg', 4, 5, '2013-09-11', 850),
(8, 'Europe', 'France', 'Paris', 2, 5, '2013-04-04', 500),
(9, 'Asia', 'Thailand', 'Bangkok', 3, 14, '2013-02-01', 2000),
(10, 'Asia', 'Thailand', 'Chiang Mai', 3, 20, '2013-03-01', 1500),
(11, 'Asia', 'India', 'Varanasi', 3, 30, '2013-02-15', 1000),
(12, 'Asia', 'India', 'Gaya', 3, 15, '2013-06-01', 1500),
(13, 'Asia', 'Russia', 'Tyumen', 4, 9, '2013-03-09', 1000),
(14, 'Africa', 'Kenya', 'Nairobi', 4, 15, '2013-03-01', 1500),
(15, 'Africa', 'Libya', 'Benghazi', 3, 15, '2013-09-13', 2000),
(16, 'America', 'USA', 'New York', 5, 10, '2013-07-01', 2500),
(17, 'America', 'USA', 'Chicago', 3, 7, '2013-01-17', 1700),
(18, 'America', 'Mexico', 'Mexico City', 3, 10, '2013-01-10', 1200),
(19, 'America', 'Peru', 'Lima', 4, 15, '2013-07-02', 2000),
(20, 'Australia', 'Australia', 'Sydney', 5, 15, '2013-02-01', 3000);
