E-Books for you

If we are
using the database, it is important to extend it in the correct way. More information
on extending the database with components is available in Chapter 4.
Table Prefix
All database tables have a prefix, normally jos_, which helps in using a single
database for multiple Joomla! installations. When we write SQL queries, to
accommodate the variable table prefix, we use a symbolic prefix that is substituted
with the actual prefix at run time. Normally the symbolic prefix is #__, but we can
specify an alternative prefix if we want to.
Schema Conventions
When we create tables for our extensions, we must follow some standard
conventions. The most important of these is the name of the table. All tables must
use the table prefix and should start with name of the extension. If the table is
storing a specific entity, add the plural of the entity name to the end of the table
name separated by an underscore. For example, an items table for the extension 'My
Extension' would be called #__myExtension_items.


Pages:
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69