modules/simplefeed/simplefeed.install

<?php
// $Id: simplefeed.install,v 1.9 2007/10/02 17:52:06 m3avrck Exp $

/**
 * Implementation of hook_install().
 */
function simplefeed_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {simplefeed_feed} (
        vid int unsigned NOT NULL,
        nid int unsigned NOT NULL,
        url varchar(255) NOT NULL default '',
        expires int NOT NULL default '0',
        refresh int NOT NULL default '0',
        checked int NOT NULL default '0',
        PRIMARY KEY (vid),
        KEY nid (nid),
        KEY url (url)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {simplefeed_feed} (
        vid int_unsigned NOT NULL,
        nid int_unsigned NOT NULL,
        url varchar(255) NOT NULL default '',
        expires int NOT NULL default '0',
        refresh int NOT NULL default '0',
        checked int NOT NULL default '0',
        PRIMARY KEY (vid)
      )");
      db_query("CREATE INDEX {simplefeed_feed}_nid_idx ON {simplefeed_feed} (nid)");
      db_query("CREATE INDEX {simplefeed_feed}_url_idx ON {simplefeed_feed} (url)");
      break;
  }

  drupal_set_message(t('SimpleFeed successfully installed.'));
}

/**
 * Implementation of hook_uninstall().
 */
function simplefeed_uninstall() {
  db_query('DROP TABLE {simplefeed_feed}');
  node_type_delete('feed');
  variable_del('simplefeed_expires');
  variable_del('simplefeed_refresh');
  variable_del('simplefeed_format');
  variable_del('simplefeed_vocab');
  variable_del('simplefeed_categories');
  variable_del('simplefeed_cron_throttle');
}
1	<?php
2	// $Id: simplefeed.install,v 1.9 2007/10/02 17:52:06 m3avrck Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function simplefeed_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {simplefeed_feed} (
12	vid int unsigned NOT NULL,
13	nid int unsigned NOT NULL,
14	url varchar(255) NOT NULL default '',
15	expires int NOT NULL default '0',
16	refresh int NOT NULL default '0',
17	checked int NOT NULL default '0',
18	PRIMARY KEY (vid),
19	KEY nid (nid),
20	KEY url (url)
21	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
22	break;
23	case 'pgsql':
24	db_query("CREATE TABLE {simplefeed_feed} (
25	vid int_unsigned NOT NULL,
26	nid int_unsigned NOT NULL,
27	url varchar(255) NOT NULL default '',
28	expires int NOT NULL default '0',
29	refresh int NOT NULL default '0',
30	checked int NOT NULL default '0',
31	PRIMARY KEY (vid)
32	)");
33	db_query("CREATE INDEX {simplefeed_feed}_nid_idx ON {simplefeed_feed} (nid)");
34	db_query("CREATE INDEX {simplefeed_feed}_url_idx ON {simplefeed_feed} (url)");
35	break;
36	}
37
38	drupal_set_message(t('SimpleFeed successfully installed.'));
39	}
40
41	/**
42	* Implementation of hook_uninstall().
43	*/
44	function simplefeed_uninstall() {
45	db_query('DROP TABLE {simplefeed_feed}');
46	node_type_delete('feed');
47	variable_del('simplefeed_expires');
48	variable_del('simplefeed_refresh');
49	variable_del('simplefeed_format');
50	variable_del('simplefeed_vocab');
51	variable_del('simplefeed_categories');
52	variable_del('simplefeed_cron_throttle');
53	}