Drupal database update

1. Use this script to upgrade an existing Drupal installation. You don't need this script when installing Drupal from scratch.
2. Before doing anything, backup your database. This process will change your database and its values, and some things might get lost.
3. Update your Drupal sources, check the notes below and run the database upgrade script. Don't upgrade your database twice as it may cause problems.

4. Go through the various administration pages to change the existing and new settings to your liking.

Notes:

If you are upgrading to or through CivicSpace 0.8.2 you will need to satisfy the following conditions before being able to upgrade:

• You will need to make sure you are using MySQL 4.0 or later.
• You will need to make sure that the file sites/default/civicrm.settings.php is writable.
• You will need to make sure that the directory files/ is readable and writable.
• You will need to make sure that the directory files/civicrm is readable and writable.
• You will need to make sure that the directory files/civicrm/upload is readable and writable.
• You will need to make sure that the directory files/civicrm/templates_c is readable and writable.

If you upgrade from CivicSpace 0.7.x, you will need to create the users_roles and locales_meta tables manually before upgrading. To create these tables, issue the following SQL commands:

  CREATE TABLE users_roles (
    uid int(10) unsigned NOT NULL default '0',
    rid int(10) unsigned NOT NULL default '0',
    PRIMARY KEY (uid, rid)
  );
  CREATE TABLE locales_meta (
    locale varchar(12) NOT NULL default '',
    name varchar(64) NOT NULL default '',
    enabled int(2) NOT NULL default '0',
    isdefault int(2) NOT NULL default '0',
    plurals int(1) NOT NULL default '0',
    formula varchar(128) NOT NULL default '',
    PRIMARY KEY  (locale)
  );