Chapter 6: Final System Configuration
With all of the information added, the Installation Wizard is ready to write all the information to the mainfile.php and the secure.php file. If the information provided about the database was correct, the result should be similar to Figure 11.
Figure 11: You have another chance to take a look at what you entered If all data is correct, push the [Next] button and the Installation Wizard will attempt to connect to the database server to confirm the MySQL database is active and running and then will try to connect to the database specified.
If the MySQL server is setup correctly, the Installation Wizard will try to access the database, in this case the one called “xoops250final”. If it accessed the database successfully, the required tables for XOOPS.
Figure 12: Database table creation list
Screen 8/14 (Figure 12) presents all of the database tables that support the System Module of a new XOOPS site.
A new XOOPS site creates 32 tables. Following is a list of the tables and a brief description of their function:
Table
Description
xef9_avatar
Holds the identity, path and name of user avatars.
xef9_avatar_user_link
Ties an avatar's id with a user's id, so each user “knows” its avatar.
xef9_banner
Holds all the information about a specific banner.
xef9_bannerclient
Holds all the information about a banner customer.
xef9_bannerfinish
Holds all the information about expired banners, with their click count.
xef9_block_module_link link
Ties a block's id with a module's id, so each block “knows” the module to which it belongs.
xef9_cache_model
holds value for cache model.
xef9_config
Holds XOOPS general configuration variables.
xef9_configcategory
Holds the configuration categories.
xef9_configoption
Holds configuration options.
xef9_group_permission
Holds the details of permissions granted to each group of users.
xef9_groups
Holds the identity of users' groups.
xef9_groups_users_link
Ties a user's id with a group's id, so each group "knows" its users, or each user "knows" to which group it belongs.
xef9_image
Holds all the information about an image stored in the system.
xef9_imagebody
Holds an image, in case you decide to write images in the database.
xef9_imagecategory
Holds the image categories you define in the Image Manager.
xef9_imgset
Holds the identity of an image set.
xef9_imgset_tplset_link
Ties an image set's it with a template set's id, so a template set "knows" what images belong to it.
xef9_imgsetimg
not used.
xef9_modules
Holds all the information about a module.
xef9_newblocks
Holds all the defining attributes of a block.
xef9_online
Holds the information about users online.
xef9_priv_msgs
Holds all the information about a private message.
xef9_ranks
Holds the users ranks defined in the admin area, to qualify user's participation in the site.
xef9_session
Holds the information about a session.
xef9_smiles
Holds the information about the codes used to display smilies.
xef9_tplfile
Holds the metadata of a file that's part of a template set.
xef9_tplset
Holds the information about a template set.
xef9_tplsource
Holds the data (the source code) of a file that's part of a template set.
xef9_users
Holds all the information about a user.
xef9_xoopscomments
Holds all the information about a comment.
xef9_xoopsnotifications
Holds all the information about notifications.
All tables are created blank, ready to be populated.
The list of tables will grow with each module that is added to the site. As noted earlier, the tables listed above are for the System Module only.
Last modified 3yr ago
Copy link