NAVIGATION
[[Database]]
Database
DB tables:
| TABLE | TYPE | DESCRIPTION |
|---|---|---|
| phpwcms_address | —- | ———– |
| phpwcms_ads_campaign | Module | ———– |
| phpwcms_ads_formats | Module | ———– |
| phpwcms_ads_place | Module | ———– |
| phpwcms_ads_tracking | Module | ———– |
| phpwcms_article | —- | Article indexes like article id, user, title, alias, … |
| phpwcms_articlecat | —- | Site structure: category- id, name, alias, …. |
| phpwcms_articlecontent | —- | Article content |
| phpwcms_bad_behavior | —- | ———– |
| phpwcms_bid | not in use | ———– |
| phpwcms_cache | not in use | ———– |
| phpwcms_calendar | Module | ———– |
| phpwcms_categories | not in use | ———– |
| phpwcms_chat | not in use | ———– |
| phpwcms_content | function/CP | NEWS content |
| phpwcms_country | —- | ———– |
| phpwcms_crossreference | not in use | ———– |
| phpwcms_file | —- | File center: Pointer to images and files in /filearchive/* |
| phpwcms_filecat | not in use | ———– |
| phpwcms_filekey | not in use | ———– |
| phpwcms_fonts | —- | ———– |
| phpwcms_fonts_colors | —- | ———– |
| phpwcms_fonts_styles | —- | ———– |
| phpwcms_formresult | —- | ———– |
| phpwcms_formtracking | —- | ———– |
| phpwcms_glossary | Module | ———– |
| phpwcms_guestbook | —- | ———– |
| phpwcms_imgcache | —- | File center: Pointer to new calculated images and files in /content/images/* |
| phpwcms_keyword | —- | ———– |
| phpwcms_language | —- | ———– |
| phpwcms_log | —- | ———– |
| phpwcms_map | —- | ———– |
| phpwcms_message | —- | ———– |
| phpwcms_newsletter | —- | ———– |
| phpwcms_newsletterqueue | —- | ———– |
| phpwcms_pagelayout | —- | Main layout data |
| phpwcms_profession | —- | ———– |
| phpwcms_shop_orders | —- | ———– |
| phpwcms_shop_products | —- | ———– |
| phpwcms_subscription | —- | ———– |
| phpwcms_sysvalue | —- | ———– |
| phpwcms_template | —- | ———– |
| phpwcms_user | —- | ———– |
| phpwcms_userdetail | —- | ———– |
| phpwcms_usergroup | not in use | ———– |
| phpwcms_userlog | —- | ———– |
Indexes: ------------------------------------------------------------------- Keyname Type Cardinality Action Field ------------------------------------------------------------------- PRIMARY PRIMARY 0 [Edit] [Drop] f_id f_granted INDEX None [Edit] [Drop] f_granted f_name INDEX None [Edit] [Drop] f_name f_shortinfo INDEX None [Edit] [Drop] f_shortinfo ------------------------------------------------------------------- In some casers f_granted exists two times. (That isn´t right) Please have a look in any table for double indexes.
Short link overview
