MYSQL Database

IMPORTANT NOTE: Developer documentation is provided as a guide for advanced developers wanting to customize their BD website beyond the available default settings. Please keep in mind, although the Brilliant Directories support team is trained to assist with general questions related to default settings, if you need assistance with advanced developer coding, please contact a professional web developer. Here is a link to find knowledgeable developers: https://marketplace.brilliantdirectories.com/search_results

Changing the membership level for an entire group of members via SQL
At times, you may be required to change the membership level of an entire group of members. If this is the case, you'll want to follow these instruction...
How does the Users Meta table work
 The users_meta table is a special kind of table that behaves differently than the rest of the tables. Like all other SQL based tables, it works the same wa...
Member Tables and Relations
In your database, the Member Tables relate to each other in the following way (Not all tables are shown in the image below because of the amount of tables a...
Database Administration
Through the database, you can do many things to your site. From changing membership levels to renaming members and from deleting specific posts to updating ...
Assigning Specific Sub-Level Categories To All Members Via An SQL Command
The primary reason why you may need to apply this SQL command is: 1. If a customer has multiple sub-level categories with the same name, and wants to im...
How categories and subcategories are related to a member's profile in MySQL
Table *list_professions* is the table that contains all the information related the main categories Table *users_data* column *profession_id* this is the ...
How to Access mySQL
Through the database, many things can be done to the site. So in this simple guide, we will cover how to access the database and showcase the most important...
Description of each data table under _directory database
In this article, we will be sharing a short description of each of the data tables under _directory database. 301_redirects All the 301 Redirects ad...