hook_schema is not creating database table

Question

The following function is contained in process_login.install as part of a custom module called process_login. The module works if I manually created the database table, but naturally I would like the table created automatically on install.

The function itself does not generate a schema error on installing the module. But neither does it create the database table process_login_register in the Drupal 7 MySQL database.

There are no other errors I can see, or problems reported by Site Report.

I have removed it completely and reinstalled numerous times. I have searched the web extensively, and consulted two books I have on Drupal development. I can't see anything wrong with this function (listed below).

NOTE: I have also tried defining 'id' as serial but get the same result (i.e. no table created).

I have run out of ideas. Does anybody know why this function isn't working?

function process_login_schema(){
  $schema['process_login_register'] = array(
        'description' => 'Register a specific computer with the system.',
        'fields' => array(
                'id' => array(
                    'description' => 'Primary identifier.',
                    'type' => 'int',
                    'unsigned' => TRUE,
                    'size' => 'normal',
                    'not null' => TRUE,
                    'default' => 0,
                ),
                'ip' => array(
                        'description' => "The user's IP address at registration.",
                        'type' => 'varchar',
                        'length' => 32,
                        'not null' => TRUE,
                        'default' => '',
                ),
                'user_agent' => array(
                        'description' => "The user's browser user agent string at registration.",
                        'type' => 'varchar',
                        'length' => 255,
                        'not null' => TRUE,
                        'default' => '',
                ),
        ),
        'primary key' => array('id'),
  );
  return $schema;
}

Answer 1

Use drush dre -y [module] which disables, uninstalls and then re-enables the module. The -y flag makes it even faster, avoiding you have to press y and enter three times.

Answer 2

Only if you uninstall a module, and subsequently re-install it, the database tables it uses and declares with hook_schema() are re-created.

To uninstall a module, you need to:

• Uncheck the checkbox shown for the module

  

• Click on Save configuration

  

• Click on the :Uninstall_ tab

• Click on the check box to the left of the module name

• Click on the Uninstall button

  

• On the next page, confirm you want to uninstall that module by clicking on the Uninstall button

  

As alternative, if you have installed Drush, you can use the following commands.

drush pm-disable $module
drush pm-install $module
drush en $module

Replace $module with the short name of the module, between apices, and without the .module extension.

What you have done is disabling the module, and then re-enabling it. Even if you deleted the directory containing the module, for Drupal what you have done is just disabling, and then re-enabling it.