Datenbank

Tabellen der DB:

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 —- ———–
phpwcms_cache not in use ———–
phpwcms_calendar —- ———–
phpwcms_categories not in use ———–
phpwcms_chat not in use ———–
phpwcms_content not in use ———–
phpwcms_country —- ———–
phpwcms_crossreference not in use ———–
phpwcms_file —- ———–
phpwcms_filecat not in use ———–
phpwcms_filekey not in use ———–
phpwcms_fonts —- ———–
phpwcms_fonts_colors —- ———–
phpwcms_fonts_styles —- ———–
phpwcms_formresult —- ———–
phpwcms_formtracking —- ———–
phpwcms_glossary —- ———–
phpwcms_guestbook —- ———–
phpwcms_imgcache —- ———–
phpwcms_keyword —- ———–
phpwcms_language —- ———–
phpwcms_log —- ———–
phpwcms_map —- ———–
phpwcms_message —- ———–
phpwcms_newsletter —- ———–
phpwcms_newsletterqueue —- ———–
phpwcms_pagelayout —- ———–
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.


Kleine Linkübersicht