function brilliant_gallery_schema in Brilliant Gallery 6.4

Same name and namespace in other branches

1. 6 brilliant_gallery.install \brilliant_gallery_schema()
2. 6.2 brilliant_gallery.install \brilliant_gallery_schema()
3. 6.3 brilliant_gallery.install \brilliant_gallery_schema()
4. 7.2 brilliant_gallery.install \brilliant_gallery_schema()
5. 7 brilliant_gallery.install \brilliant_gallery_schema()

Implementation of hook_schema().

File

./brilliant_gallery.install, line 8

Code

function brilliant_gallery_schema() {
  $schema['brilliant_gallery_checklist'] = array(
    'description' => t('Table tracing which Brilliant Gallery images are hidden or visible.'),
    'fields' => array(
      'nid' => array(
        'description' => t('Unused now.'),
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'user' => array(
        'description' => t('User ID.'),
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'qid' => array(
        'description' => t('Image.'),
        'type' => 'text',
        'not null' => TRUE,
      ),
      'state' => array(
        'description' => t('Visible or invisible.'),
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    //'primary key' => array('nid', 'user', 'Array'),
    'primary key' => array(
      'nid',
      'user',
      array(
        'qid',
        255,
      ),
    ),
  );

  /*
   $schema['brilliant_gallery_checklist'] = array(
   'description' => t('Table tracing which Brilliant Gallery images are hidden or visible.'),
   'fields' => array(
   'nid' => array(
   'description' => t('Unused now.'),
   'type' => 'int',
   'unsigned' => TRUE,
   'not null' => TRUE,
   'size' => 'normal',
   'default' => 0,
   ),
   'user' => array(
   'description' => t('User ID.'),
   'type' => 'int',
   'unsigned' => TRUE,
   'not null' => TRUE,
   'size' => 'normal',
   'default' => 0,
   ),
   'qid' => array(
   'description' => t('Image.'),
   'type' => 'text',
   #'unsigned' => FALSE,
   'not null' => TRUE,
   'size' => 'normal',
   #'default' => '',    # brilliant_gallery_checklist.qid is type text and may not have a default value
   ),
   'state' => array(
   'description' => t('Visible or invisible.'),
   'type' => 'int',
   'unsigned' => TRUE,
   'not null' => TRUE,
   'size' => 'normal',
   'default' => 0,
   ),
   ),
   'primary key' => array('nid','user',array('qid',255)),
   );
  */
  $schema['brilliant_gallery_image_arrays'] = array(
    'description' => t('Binds image property array with its hash that is present in the cached file name and in the URL.'),
    'fields' => array(
      'hash' => array(
        'description' => t('Hash of the serialized array.'),
        'type' => 'varchar',
        'length' => '32',
        'not null' => TRUE,
      ),
      'array' => array(
        'description' => t('Array of image parametres.'),
        'type' => 'text',
        'not null' => TRUE,
      ),
      'datetime' => array(
        'description' => t('Date and time of last value refresh.'),
        'type' => 'datetime',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'hash',
    ),
    'indexes' => array(
      'datetime' => array(
        'datetime',
      ),
    ),
  );
  return $schema;
}