modules/fooaggregator/fooaggregator.install

<?php // -*-php-*-
/* $Id: fooaggregator.install,v 1.4 2007/07/14 15:17:14 msameer Exp $ */

/**
 * Implementation of hook_install().
 */
function fooaggregator_install() {
  switch ($GLOBALS['db_type']) {
  case 'mysql':
  case 'mysqli':
    db_query("CREATE TABLE {fooaggregator_item} (
              nid int(11) default NULL,
              fid int(11) default NULL,
              guid varchar(255) default NULL,
              link varchar(255) default NULL,
              author varchar(255) default NULL,
              KEY nid (nid),
              KEY fid (fid, guid)
              ) /*!40100 DEFAULT CHARACTER SET UTF8 */");

    db_query("CREATE TABLE {fooaggregator_feed} (
              nid int(10) unsigned NOT NULL auto_increment,
              url varchar(255) default NULL,
              link varchar(255) default NULL,
              etag varchar(255) default NULL,
              refresh int(10) unsigned NOT NULL,
              checked int(10) unsigned NOT NULL,
              updated int(10) unsigned NOT NULL,
              modified int(10) unsigned NOT NULL,
              image_url text,
              image_title text,
              image_link text,
              visible tinyint(4) NOT NULL default '1',
              PRIMARY KEY  (nid)
              ) /*!40100 DEFAULT CHARACTER SET UTF8 */");

    break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function fooaggregator_uninstall() {
  db_query('DROP TABLE {fooaggregator_item}');
  db_query('DROP TABLE {fooaggregator_feed}');

  variable_del('fooaggregator_per_page');
  variable_del('fooaggregator_uid');
  variable_del('fooaggregator_per_cron');
  variable_del('fooaggregator_filter');
}
1	<?php // --php--
2	/* $Id: fooaggregator.install,v 1.4 2007/07/14 15:17:14 msameer Exp $ */
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function fooaggregator_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {fooaggregator_item} (
12	nid int(11) default NULL,
13	fid int(11) default NULL,
14	guid varchar(255) default NULL,
15	link varchar(255) default NULL,
16	author varchar(255) default NULL,
17	KEY nid (nid),
18	KEY fid (fid, guid)
19	) /!40100 DEFAULT CHARACTER SET UTF8 /");
20
21	db_query("CREATE TABLE {fooaggregator_feed} (
22	nid int(10) unsigned NOT NULL auto_increment,
23	url varchar(255) default NULL,
24	link varchar(255) default NULL,
25	etag varchar(255) default NULL,
26	refresh int(10) unsigned NOT NULL,
27	checked int(10) unsigned NOT NULL,
28	updated int(10) unsigned NOT NULL,
29	modified int(10) unsigned NOT NULL,
30	image_url text,
31	image_title text,
32	image_link text,
33	visible tinyint(4) NOT NULL default '1',
34	PRIMARY KEY (nid)
35	) /!40100 DEFAULT CHARACTER SET UTF8 /");
36
37	break;
38	}
39	}
40
41	/**
42	* Implementation of hook_uninstall().
43	*/
44	function fooaggregator_uninstall() {
45	db_query('DROP TABLE {fooaggregator_item}');
46	db_query('DROP TABLE {fooaggregator_feed}');
47
48	variable_del('fooaggregator_per_page');
49	variable_del('fooaggregator_uid');
50	variable_del('fooaggregator_per_cron');
51	variable_del('fooaggregator_filter');
52	}