modules/fast_gallery/fast_gallery.install

<?php
// $Id: devel.install,v 1.39 2009/10/14 01:15:50 davereid Exp $

function fast_gallery_uninstall() {
  variable_del('fg_storage_engine');
}

function fast_gallery_schema() {
  $schema['fast_gallery'] = array(
    'description' => 'The base table; matching between files and hierarchy',
    'fields' => array(
      'fid' => array(
        'description' => 'Foreign key fid of {files}',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'foid' => array(
        'description' => 'Foreign key foid of {fast_gallery_hierarchy}',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'foreign keys' => array(
      'fid' => array('file' => 'fid'),
      'foid' => array('fast_gallery_hierarchy' => 'foid'),
    ),
  );
  
  $schema['fast_gallery_hierarchy'] = array(
    'description' => 'store the hierarchy of folders',
    'fields' => array(
      'foid' => array(
        'description' => 'Primary identifier for folders',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'folder' => array(
        'description' => 'Folder URI',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'pid' => array(
        'description' => 'Parent folder',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array('foid'),
  );
  
  return $schema;
}
1	<?php
2	// $Id: devel.install,v 1.39 2009/10/14 01:15:50 davereid Exp $
3
4	function fast_gallery_uninstall() {
5	variable_del('fg_storage_engine');
6	}
7
8	function fast_gallery_schema() {
9	$schema['fast_gallery'] = array(
10	'description' => 'The base table; matching between files and hierarchy',
11	'fields' => array(
12	'fid' => array(
13	'description' => 'Foreign key fid of {files}',
14	'type' => 'int',
15	'unsigned' => TRUE,
16	'not null' => TRUE,
17	'default' => 0,
18	),
19	'foid' => array(
20	'description' => 'Foreign key foid of {fast_gallery_hierarchy}',
21	'type' => 'int',
22	'unsigned' => TRUE,
23	'not null' => TRUE,
24	'default' => 0,
25	),
26	),
27	'foreign keys' => array(
28	'fid' => array('file' => 'fid'),
29	'foid' => array('fast_gallery_hierarchy' => 'foid'),
30	),
31	);
32
33	$schema['fast_gallery_hierarchy'] = array(
34	'description' => 'store the hierarchy of folders',
35	'fields' => array(
36	'foid' => array(
37	'description' => 'Primary identifier for folders',
38	'type' => 'serial',
39	'unsigned' => TRUE,
40	'not null' => TRUE,
41	),
42	'folder' => array(
43	'description' => 'Folder URI',
44	'type' => 'varchar',
45	'length' => 255,
46	'not null' => TRUE,
47	'default' => '',
48	),
49	'pid' => array(
50	'description' => 'Parent folder',
51	'type' => 'int',
52	'unsigned' => TRUE,
53	'not null' => TRUE,
54	'default' => 0,
55	),
56	),
57	'primary key' => array('foid'),
58	);
59
60	return $schema;
61	}