function hotel_install() {
  $path = ABSPATH . 'wp-config.php';
  require_once ($path);

  global $wpdb;
  $charset_collate = $wpdb->get_charset_collate();
  $my_table = $wpdb->prefix . "booking";

  $sql_create_table = "CREATE TABLE $my_table (
    `id` int(11) NOT NULL auto_increment,
    `title` varchar(100) NOT NULL,
    `f_name` varchar(200) NOT NULL,
    `l_name` varchar(200) NOT NULL,
    `add` varchar(500) NOT NULL,
    `city` varchar(200) NOT NULL,
    `state` varchar(200) NOT NULL,
    `postal_code` int(11) NOT NULL,
    `country` varchar(200) NOT NULL,
    `phone` int(11) NOT NULL,
    `email` varchar(400) NOT NULL,
    `payment_by` int(11) NOT NULL,
    `additional_res` varchar(400) NOT NULL,
    `check_in` date NOT NULL,
    `check_out` date NOT NULL,
    `total_nights` int(11) NOT NULL,
    `total_rooms` int(11) NOT NULL,
    `numofadult` int(11) NOT NULL,
    `numofchild` int(11) NOT NULL,
    `room_num` int(11) NOT NULL,
    `room_id` int(11) NOT NULL,
    `paid_amount` int(11) NOT NULL
  ) $charset_collate; ";
  require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
  dbDelta( $sql_create_table );
}