control-tables.sh

Creates and manages various tables in the MySQL database for the CruiseAppy application, supporting both single-table and all-table creation.

Usage

./control-tables.sh <tablename>

Use "all" to create all tables.

Description

Sets the script path and sources the functions.sh file.
Logs the start of the table creation process.
Creates the specified table or all tables in the database, including:
ff_traveltek_basket_cruise
ca_prefetch
ff_traveltek_basket_items
cabin_select_itinerary
search_destinations
search_destinations_temp
search_cruiseline_lookup
search_itinerary_count
search_itinerary_disembark
search_itinerary
search_ship_lookup
search_new
ff_traveltek_ratecodes
searches
ff_traveltek_cabingrades_temp
ff_traveltek_cabingrades
ff_traveltek_itinerary
ff_traveltek_tms
ff_traveltek_destinations
ff_traveltek_packages
ff_traveltek_package_itinerary
ff_traveltek_package_flights
ff_traveltek_package_base_price
ff_traveltek_cruiselines
ff_traveltek_ship_cabins
ff_traveltek_ship_content
ff_traveltek_ship_decks
ff_traveltek_ship_details
ff_traveltek_ship_images
ff_traveltek_ships
ff_traveltek_prices
ff_traveltek_cruises
ff_traveltek_cruiseline_lookup
ff_traveltek_ports
ff_traveltek_cruiseline_content
ff_image_sizes
ff_traveltek_package_cabins
ff_traveltek_itinerary_image
ff_traveltek_package_hotel_rooms
ff_traveltek_package_transfers
ff_traveltek_basket_searches_cruise
ff_traveltek_basket_searches
ff_traveltek_airports
ff_traveltek_airports_iata
Logs the creation of each table.

Dependencies

functions.sh: Utility functions.
mysql: MySQL commands.

Notes

Ensure all required environment variables and plugins are set before running.
Intended for use by developers or system administrators familiar with WordPress and server scripting.

For further details, refer to the comments in the script or contact the development team.

« Previous Next »