modules/feedburner/feedburner.install

<?php
// $Id$

/**
 * Implementation of hook_install().
 */
function feedburner_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE IF NOT EXISTS {feedburner_feeds} (
        fid int unsigned NOT NULL default '0',
        local_uri varchar(128) NOT NULL default '',
        fb_uri varchar(100) NOT NULL default '',
        verified int NOT NULL default '0',
        details longtext,
        PRIMARY KEY (fid, uri)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
    case 'pgsql':
      break;
  }
}

/**
 * Implementation of hook_update_x().
 *
 * Adds the FeedBurner table and converts the currently redirecting feeds to
 * use the table since I only used a variable array in the first few versions.
 */
function feedburner_update_1() {
  $items = array();
  $items[] = update_sql("CREATE TABLE IF NOT EXISTS {feedburner_feeds} (
        fid int unsigned NOT NULL default '0',
        local_uri varchar(128) NOT NULL default '',
        fb_uri varchar(100) NOT NULL default '',
        verified int NOT NULL default '0',
        details longtext,
        PRIMARY KEY (fid, uri)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  $feeds = variable_get('feedburner_feeds', array());
  foreach ($feeds as $local_uri => $fb_uri) {
    $items[] = update_sql("INSERT INTO {feedburner_feeds} (local_uri, fb_uri) VALUES ('". $local_uri ."', '". $fb_uri ."')");
  }
  variable_del('feedburner_feeds');
  return $items;
}

/**
 * Implementation of hook_uninstall().
 * Removes tables and variables used by this module.
 */
function feedburner_uninstall() {
  // Delete all the feedburner variables
  $variables = db_query("SELECT name FROM variable WHERE name LIKE 'feedburner%'");
  while ($variable = db_result($variables)) {
    variable_del($variable);
  }
  // Alternative method, but not as kosher
  //db_query("DELETE FROM {variable} WHERE name LIKE 'feedburner%'");
  //cache_clear_all('variables', 'cache');

  // Remove feedburner table (can't use IF EXISTS since only latest PostgreSQL supports it
  db_query("DROP TABLE {feedburner_feeds}");
}
1	<?php
2	// $Id$
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function feedburner_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE IF NOT EXISTS {feedburner_feeds} (
12	fid int unsigned NOT NULL default '0',
13	local_uri varchar(128) NOT NULL default '',
14	fb_uri varchar(100) NOT NULL default '',
15	verified int NOT NULL default '0',
16	details longtext,
17	PRIMARY KEY (fid, uri)
18	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
19	case 'pgsql':
20	break;
21	}
22	}
23
24	/**
25	* Implementation of hook_update_x().
26	*
27	* Adds the FeedBurner table and converts the currently redirecting feeds to
28	* use the table since I only used a variable array in the first few versions.
29	*/
30	function feedburner_update_1() {
31	$items = array();
32	$items[] = update_sql("CREATE TABLE IF NOT EXISTS {feedburner_feeds} (
33	fid int unsigned NOT NULL default '0',
34	local_uri varchar(128) NOT NULL default '',
35	fb_uri varchar(100) NOT NULL default '',
36	verified int NOT NULL default '0',
37	details longtext,
38	PRIMARY KEY (fid, uri)
39	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
40	$feeds = variable_get('feedburner_feeds', array());
41	foreach ($feeds as $local_uri => $fb_uri) {
42	$items[] = update_sql("INSERT INTO {feedburner_feeds} (local_uri, fb_uri) VALUES ('". $local_uri ."', '". $fb_uri ."')");
43	}
44	variable_del('feedburner_feeds');
45	return $items;
46	}
47
48	/**
49	* Implementation of hook_uninstall().
50	* Removes tables and variables used by this module.
51	*/
52	function feedburner_uninstall() {
53	// Delete all the feedburner variables
54	$variables = db_query("SELECT name FROM variable WHERE name LIKE 'feedburner%'");
55	while ($variable = db_result($variables)) {
56	variable_del($variable);
57	}
58	// Alternative method, but not as kosher
59	//db_query("DELETE FROM {variable} WHERE name LIKE 'feedburner%'");
60	//cache_clear_all('variables', 'cache');
61
62	// Remove feedburner table (can't use IF EXISTS since only latest PostgreSQL supports it
63	db_query("DROP TABLE {feedburner_feeds}");
64	}