User-agent: *
Disallow: /admin/
Disallow: /banners/
Disallow: /docs/
Disallow: /gallery/
Disallow: /images/
Disallow: /includes/
Disallow: /languages/
Disallow: /photos/
Disallow: /templates/



CREATE TABLE `pmr_types2` (
  `name` varchar(50) default NULL,
  `id` int(5) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `pmr_types2`
--

INSERT INTO `pmr_types2` VALUES('For Sale', 1);
INSERT INTO `pmr_types2` VALUES('For Rent / Lease', 2);
INSERT INTO `pmr_types2` VALUES('Rent to Own', 3);
INSERT INTO `pmr_types2` VALUES('Room to Let', 4);
INSERT INTO `pmr_types2` VALUES('Timeshare', 6);
INSERT INTO `pmr_types2` VALUES('Services', 7);
INSERT INTO `pmr_types2` VALUES('Other', 8);





CREATE TABLE `pmr_chapters` (
  `id` int(11) NOT NULL auto_increment,
  `chapter_name` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

--
-- Dumping data for table `pmr_chapters`
--

INSERT INTO `pmr_chapters` VALUES('', 'Caloocan');
INSERT INTO `pmr_chapters` VALUES('', 'CBD (Central Business District)');
INSERT INTO `pmr_chapters` VALUES('', 'Greenhills');
INSERT INTO `pmr_chapters` VALUES('', 'LAMP (Las Piñas, Alabang, Muntinlupa, Parañaque)');
INSERT INTO `pmr_chapters` VALUES('', 'Makati');
INSERT INTO `pmr_chapters` VALUES('', 'Mandaluyong');
INSERT INTO `pmr_chapters` VALUES('', 'Manila');
INSERT INTO `pmr_chapters` VALUES('', 'Marikina River City');
INSERT INTO `pmr_chapters` VALUES('', 'Ortigas Center');
INSERT INTO `pmr_chapters` VALUES('', 'Quezon City');
INSERT INTO `pmr_chapters` VALUES('', 'Rizal Chapter');
INSERT INTO `pmr_chapters` VALUES('', 'Cavite');
INSERT INTO `pmr_chapters` VALUES('', 'Cebu');
INSERT INTO `pmr_chapters` VALUES('', 'Laguna');
INSERT INTO `pmr_chapters` VALUES('', 'Metro Baguio');
INSERT INTO `pmr_chapters` VALUES('', 'La Union');
INSERT INTO `pmr_chapters` VALUES('', 'Naga');
INSERT INTO `pmr_chapters` VALUES('', 'Negros');
INSERT INTO `pmr_chapters` VALUES('', 'Pampanga');
INSERT INTO `pmr_chapters` VALUES('', 'Tarlac');
INSERT INTO `pmr_chapters` VALUES('', 'Laoag');
INSERT INTO `pmr_chapters` VALUES('', 'Others');


CREATE TABLE `pmr_specialization` (
  `spec_id` int(11) NOT NULL auto_increment,
  `spec_name` varchar(100) default NULL,
  PRIMARY KEY  (`spec_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

--
-- Dumping data for table `pmr_specialization`
--

INSERT INTO `pmr_specialization` VALUES('', 'Brokerage');
INSERT INTO `pmr_specialization` VALUES('', 'Special Projects');
INSERT INTO `pmr_specialization` VALUES('', 'Bank Foreclosed');
INSERT INTO `pmr_specialization` VALUES('', 'Project Selling');
INSERT INTO `pmr_specialization` VALUES('', 'Joint Venture');
INSERT INTO `pmr_specialization` VALUES('', 'Others');