This is an old revision of the document!


Database

FIXME

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.
english/technics/database.1242428612.txt.gz · Last modified: 2018/06/03 18:07 (external edit)
www.planmatrix.de www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0