pwolanin/test/outline.install

<?php
// $Id: outline.install,v 1.1 2007/01/16 03:04:41 pwolanin Exp $

/**
 * Implementation of hook_install().
 */
function outline_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {outline_hierarchy} (
        nid int unsigned NOT NULL default '0',
        outid int unsigned NOT NULL default '0',
        parent int unsigned NOT NULL default '0',
        weight smallint NOT NULL default '0',
        child_type varchar(32) NOT NULL default '',
        toc_depth smallint unsigned NOT NULL default '1',
        PRIMARY KEY (nid),
        KEY outid (outid),
        KEY parent (parent),
        KEY child_node_type (child_type(4))
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {outline_hierarchy} (
        nid int_unsigned NOT NULL default '0',
        outid int_unsigned NOT NULL default '0',
        parent int_unsigned NOT NULL default '0',
        weight smallint NOT NULL default '0',
        child_type varchar(32) NOT NULL default '',
        toc_depth smallint_unsigned NOT NULL default '1',
        PRIMARY KEY (nid)
      ");
      db_query("CREATE INDEX {outline_hierarchy}_outid_idx ON {outline} (outid)");
      db_query("CREATE INDEX {outline_hierarchy}_parent_idx ON {outline} (parent)");
      db_query("CREATE INDEX {outline_hierarchy}_child_type_idx ON {outline} (substr (child_type, 1, 4))");
      break;
  }

  // Insert default user-defined node type into the database.
  $type = array(
    'type' => 'book',
    'name' => t('Book page'),
    'module' => 'node',
    'description' => t('A simple type like page for use as the default type in outlines.'),
    'custom' => TRUE,
    'modified' => TRUE,
    'locked' => TRUE,
  );

  $type = (object) _node_type_set_defaults($type);
  node_type_save($type);
  variable_set('node_options_book', array('status', 'revision'));
  
  cache_clear_all();
  system_modules();
  menu_rebuild();
  node_types_rebuild();
}


/**
 * Implementation of hook_uninstall().
 */
function outline_uninstall() {
  db_query('DROP TABLE {outline_hierarchy}');
}
1	<?php
2	// $Id: outline.install,v 1.1 2007/01/16 03:04:41 pwolanin Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function outline_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {outline_hierarchy} (
12	nid int unsigned NOT NULL default '0',
13	outid int unsigned NOT NULL default '0',
14	parent int unsigned NOT NULL default '0',
15	weight smallint NOT NULL default '0',
16	child_type varchar(32) NOT NULL default '',
17	toc_depth smallint unsigned NOT NULL default '1',
18	PRIMARY KEY (nid),
19	KEY outid (outid),
20	KEY parent (parent),
21	KEY child_node_type (child_type(4))
22	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
23	break;
24	case 'pgsql':
25	db_query("CREATE TABLE {outline_hierarchy} (
26	nid int_unsigned NOT NULL default '0',
27	outid int_unsigned NOT NULL default '0',
28	parent int_unsigned NOT NULL default '0',
29	weight smallint NOT NULL default '0',
30	child_type varchar(32) NOT NULL default '',
31	toc_depth smallint_unsigned NOT NULL default '1',
32	PRIMARY KEY (nid)
33	");
34	db_query("CREATE INDEX {outline_hierarchy}_outid_idx ON {outline} (outid)");
35	db_query("CREATE INDEX {outline_hierarchy}_parent_idx ON {outline} (parent)");
36	db_query("CREATE INDEX {outline_hierarchy}_child_type_idx ON {outline} (substr (child_type, 1, 4))");
37	break;
38	}
39
40	// Insert default user-defined node type into the database.
41	$type = array(
42	'type' => 'book',
43	'name' => t('Book page'),
44	'module' => 'node',
45	'description' => t('A simple type like page for use as the default type in outlines.'),
46	'custom' => TRUE,
47	'modified' => TRUE,
48	'locked' => TRUE,
49	);
50
51	$type = (object) _node_type_set_defaults($type);
52	node_type_save($type);
53	variable_set('node_options_book', array('status', 'revision'));
54
55	cache_clear_all();
56	system_modules();
57	menu_rebuild();
58	node_types_rebuild();
59	}
60
61
62	/**
63	* Implementation of hook_uninstall().
64	*/
65	function outline_uninstall() {
66	db_query('DROP TABLE {outline_hierarchy}');
67	}