b2evolution b2evolution

  • Sign in
  • Sign up
  • About
  • Downloads
  • Hosting
  • Docs
  • Support
  • Sign in
  • Sign up
  • Manuals Home
  • Latest Updates
 
  1. b2evolution CMS User Manual
  2. Developer Reference
  3. Technical Reference
  4. Database Model / EER Diagram

Database Model / EER Diagram

Database Model / EER Diagram

Starting with b2evolution 6.10.5 a database model including an EER Diagram is included in the source tree under /_db/b2evo_schema.mwb.

This file can be opened with MySQL Workbench (Free software).

  • This is useful for developers who want to understand how b2evolution stores its data before contributing to the project and/or writing plugins.
  • This may be useful when setting up automated backups or replication systems.
  • This is not useful for regular users.
Created by fplanque • Last edit by fplanque on 2019-05-03 10:51 • •

4 comments

Comment from: wrc

I have b2evo 6.19.7 stable on php 7.2.17. It is giving me an error "schema is not up to date"
I suspect the file you reference here will solve the problem but I have been unable to find the file/files to use. Can you help me? I also have workbence installed.

2019-05-03 @ 00:05

Comment from: fplanque

No, this is not related. Please make a support request in the forums with a full screenshot of your error message.

2019-05-03 @ 10:49

Comment from: wrc

I just realized that I made a typo with regards to the b2evo version. I was actually referring to b2evo 6.10.7.

wrc

2019-12-16 @ 03:36

Comment from: fplanque

In the evo_items__item table.

2019-12-15 @ 02:51

Search the Manual

Content Hierarchy

  • b2evolution CMS User Manual
  • User's Guide
  • Installation / Upgrade
  • Front-office Reference
  • Back-office Reference
  • Developer Reference
    • Website Skins/Themes
    • Email Skins/Themes
    • b2evolution Files
    • Website Integration
    • Plugins
    • Debugging
    • Technical Reference
      • Plugin API for item settings
      • URL Parameters
      • Roadmap & Unified Process
      • Charset Handling
      • Date Format
      • Technical Documentation
      • Image Sizes
      • Database Diagram
      • Username Autocomplete
      • Helper CSS Classes
      • Responsive images
    • Hacks
    • Credits
    • Development
    • How to... (Customize)
    • Scheduled Tasks Reference
  • Operations Reference
  • Advanced Topics
  • Glossary
  • Archives
CMS with Bootstrap

This online manual is powered by b2evolution CMS – A complete engine for your website.

About b2evolution

  • What is it?
  • Features
  • Getting Started
  • Screenshots
  • Online demo
  • Testimonials
  • Design philosophy
  • Free & open source
  • Terms of service

Downloads

  • Latest releases
  • Skins
  • Plugins
  • Language packs

About us

  • About us
  • Contact

Webhosting Guide

  • Web hosting blog
  • Best web hosting
  • Cheap web hosting
  • Green web hosting
  • Hosting with SSH
  • VPS hosting
  • Dedicated servers
  • Reseller hosting
  • Int'l: UK / France

Docs & Support

  • Online manual
  • Forums
  • Hire a pro !

Other

  • Adsense
  • Press room
  • Privacy policy

Stay in touch

  • GitHub
  • Twitter
  • Facebook
  • LinkedIn
  • News blog
  • RSS feed
  • Atom feed

Founded & Maintained by François Planque