123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207 |
- <?php
- /**
- * @file
- * The Flag lists module install file.
- */
- /**
- * Implementation of hook_install().
- */
- function flag_lists_schema() {
- $schema = array();
- $schema['flag_lists_flags'] = array(
- 'fields' => array(
- 'fid' => array(
- 'type' => 'serial',
- 'size' => 'small',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'pfid' => array(
- 'type' => 'int',
- 'size' => 'small',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'uid' => array(
- 'type' => 'int',
- 'size' => 'small',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'entity_type' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'name' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => FALSE,
- 'default' => '',
- ),
- 'title' => array(
- 'type' => 'varchar',
- 'length' => '255',
- 'not null' => FALSE,
- 'default' => '',
- ),
- 'options' => array(
- 'type' => 'text',
- 'not null' => FALSE,
- ),
- ),
- 'primary key' => array('fid'),
- 'unique keys' => array(
- 'name' => array('name'),
- ),
- );
- $schema['flag_lists_content'] = array(
- 'fields' => array(
- 'fcid' => array(
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'fid' => array(
- 'type' => 'int',
- 'size' => 'small',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'entity_type' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'entity_id' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'uid' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'sid' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'timestamp' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- 'disp-size' => 11,
- )
- ),
- 'primary key' => array('fcid'),
- 'unique keys' => array(
- 'fid_entity_id_uid_sid' => array('fid', 'entity_id', 'uid', 'sid'),
- ),
- 'indexes' => array(
- 'entity_type_entity_id' => array('entity_type', 'entity_id'),
- 'entity_type_uid_sid' => array('entity_type', 'uid', 'sid'),
- ),
- );
- $schema['flag_lists_counts'] = array(
- 'fields' => array(
- 'fid' => array(
- 'type' => 'int',
- 'size' => 'small',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'entity_type' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'entity_id' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- 'disp-width' => '10',
- ),
- 'count' => array(
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- 'disp-width' => '10',
- )
- ),
- 'primary key' => array('fid', 'entity_id'),
- 'indexes' => array(
- 'fid_entity_type' => array('fid', 'entity_type'),
- 'entity_type_entity_id' => array('entity_type', 'entity_id'),
- 'count' => array('count'),
- ),
- );
- $schema['flag_lists_types'] = array(
- 'fields' => array(
- 'name' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'type' => 'varchar',
- 'length' => '32',
- 'not null' => FALSE,
- 'default' => '')
- ),
- 'primary key' => array('name', 'type'),
- 'indexes' => array(
- 'name' => array('name'),
- ),
- );
- return $schema;
- }
- /**
- * Implements hook_install().
- */
- function flag_lists_install() {
- // Set up our default template.
- db_insert('flag_lists_types')
- ->fields(array(
- 'name' => 'fl_template',
- ))
- ->execute();
- }
- /**
- * Implements hook_uninstall().
- */
- function flag_lists_uninstall() {
- // Remove our template flags.
- $query = db_select('flag_lists_types', 'fl');
- $query->leftJoin('flag', 'f', 'fl.name = f.name');
- $query->addField('fl', 'fid', 'fid');
- $query->distinct();
- $fids = $query->execute();
- foreach ($fids as $fid) {
- db_delete('flag')->condition('fid', $fid->fid);
- db_delete('flag_content')->condition('fid', $fid->fid);
- db_delete('flag_types')->condition('fid', $fid->fid);
- db_delete('flag_counts')->condition('fid', $fid->fid);
- }
- db_delete('variable')->condition('name', 'flag_lists%', 'LIKE');
- drupal_set_message(t('Flag lists has been uninstalled.'));
- }
|