-- 
-- Structure for table `cities_tbl`
-- 

DROP TABLE IF EXISTS `cities_tbl`;
CREATE TABLE IF NOT EXISTS `cities_tbl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(11) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- 
-- Data for table `cities_tbl`
-- 

INSERT INTO `cities_tbl` (`id`, `country_id`, `name`) VALUES
  ('1', '1', 'agadir'),
  ('2', '1', 'casablanca'),
  ('3', '1', 'tanger'),
  ('4', '2', 'cairo'),
  ('5', '2', 'alexandria'),
  ('6', '2', 'aswan'),
  ('7', '2', 'mansoura'),
  ('8', '3', 'baghdad'),
  ('9', '3', 'falouja');

-- 
-- Structure for table `countries_tbl`
-- 

DROP TABLE IF EXISTS `countries_tbl`;
CREATE TABLE IF NOT EXISTS `countries_tbl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- 
-- Data for table `countries_tbl`
-- 

INSERT INTO `countries_tbl` (`id`, `name`) VALUES
  ('1', 'morocco'),
  ('2', 'egypte'),
  ('3', 'iraq');

-- 
-- Structure for table `provinces_tbl`
-- 

DROP TABLE IF EXISTS `provinces_tbl`;
CREATE TABLE IF NOT EXISTS `provinces_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_id` int(11) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- 
-- Data for table `provinces_tbl`
-- 

INSERT INTO `provinces_tbl` (`id`, `city_id`, `name`) VALUES
  ('1', '4', 'province A'),
  ('2', '4', 'province B'),
  ('3', '2', 'province 1'),
  ('4', '2', 'province 2');


