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 4yr ago