CiviCRM: Difference between revisions

From makernexuswiki
Jump to navigation Jump to search
(initial values)
(details)
Line 12: Line 12:
Civi and Druple store much of their data in SQL tables.  Civi and Druple have about 200 tables each.  The database management system uses another hundred tables, resulting in a database with about 500 tables.
Civi and Druple store much of their data in SQL tables.  Civi and Druple have about 200 tables each.  The database management system uses another hundred tables, resulting in a database with about 500 tables.


During installation, initial values for Civi are loaded by running the 23713 line SQL script /civicrm/sql/civicrm_data.mysql.
During installation, initial values for Civi are loaded by running the 23713 line SQL script /civicrm/sql/civicrm_data.mysql.  This script loads many things into SQL tables, including lists of countries, lists of options, HTML, javascript, message templates, etc.


The 200 Civi tables represent data for six primary entities:
The 200 Civi tables represent data for six primary entities:

Revision as of 17:56, 13 March 2018

CiviCRM is an open source Customer relationship management (CRM) system.

CiviCRM 4.7.31 is the latest version.

CiviCRM 4.6.36 is the current Long Term Support (LTS) release.

CiviCRM 4.7.29 is the version Maker Nexus is testing.

Maker Nexus is using Drupal 7.56, which should be updated to 7.57, because of security.

Database

Civi and Druple store much of their data in SQL tables. Civi and Druple have about 200 tables each. The database management system uses another hundred tables, resulting in a database with about 500 tables.

During installation, initial values for Civi are loaded by running the 23713 line SQL script /civicrm/sql/civicrm_data.mysql. This script loads many things into SQL tables, including lists of countries, lists of options, HTML, javascript, message templates, etc.

The 200 Civi tables represent data for six primary entities:

  • Contacts and relationships
  • Activities
  • Memberships
  • Contributions
  • Groups and tags
  • Custom data

External links