Symbolic table names

You specify table names using variables of the following syntax:

db.table.name.<symbolic_table_name> = <internal_table_name>

where:

  • <symbolic_table_name> is the symbolic name for the table, that is, the name you normally use to refer to that table.
  • <internal_name> is the name the LikeMinds server uses for that table.

For example, the symbolic mapping for the Lps_User_Data table is as follows:

db.table.name.user_data = lps_user_data

If your table names differ from the tables supplied with the LikeMinds server, you can change them. You can find sample mappings for the LikeMinds server tables by querying the db.table parameters in lpsconfig . By default, these settings are as follows:

db.table.name.genre_data = lps_Genre_data
db.table.name.item_data = lps_Item_data
db.table.name.item_genre = lps_Item_genre
db.table.name.trx_type = lps_trx_type
db.table.name.user_data = lps_User_data
db.table.name.user_mentor = lps_User_mentor
db.table.name.user_rating = lps_User_rating
db.table.name.user_selector = lps_User_selector
db.table.name.user_transaction = lps_user_trx
db.table.name.visit_list = lps_visit_list

The Lps_User_Rating, Lps_User_Mentor, and Lps_User_Trx tables are not included in this list because their mappings are defined in rating, mentor, and transaction sets.

Parent topic: Mapping symbolic database table and field names


Home |