modules/feedapi/feedapi.install

<?php
// $Id:

function feedapi_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE if not exists {feedapi} (
        fid int(10) unsigned NOT NULL auto_increment,
        url varchar(255) NOT NULL default '',
        uid int NOT NULL default '0',
        feed_type varchar(50) NOT NULL default '',
        processors_item varchar(255) NOT NULL default '',
        processors_feed varchar(255) NOT NULL default '',
        parsers varchar(255) NOT NULL default '',
        refresh int(10) NOT NULL default '0',
        checked int(10) NOT NULL default '0',
        PRIMARY KEY(fid))");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {feedapi} (
        fid SERIAL,
        url varchar(255) NOT NULL default '',
        uid int NOT NULL default '0',
        feed_type varchar(50) NOT NULL default '',
        processors_item varchar(255) NOT NULL default '',
        processors_feed varchar(255) NOT NULL default '',
        parsers varchar(255) NOT NULL default '',
        refresh integer NOT NULL,
        checked integer NOT NULL,
        PRIMARY KEY(fid))");   
      break;
  }
}

function feedapi_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("DROP TABLE {feedapi}");
      break;
    case 'pgsql':
      break;
  }
}
1	<?php
2	// $Id:
3
4	function feedapi_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	db_query("CREATE TABLE if not exists {feedapi} (
9	fid int(10) unsigned NOT NULL auto_increment,
10	url varchar(255) NOT NULL default '',
11	uid int NOT NULL default '0',
12	feed_type varchar(50) NOT NULL default '',
13	processors_item varchar(255) NOT NULL default '',
14	processors_feed varchar(255) NOT NULL default '',
15	parsers varchar(255) NOT NULL default '',
16	refresh int(10) NOT NULL default '0',
17	checked int(10) NOT NULL default '0',
18	PRIMARY KEY(fid))");
19	break;
20	case 'pgsql':
21	db_query("CREATE TABLE {feedapi} (
22	fid SERIAL,
23	url varchar(255) NOT NULL default '',
24	uid int NOT NULL default '0',
25	feed_type varchar(50) NOT NULL default '',
26	processors_item varchar(255) NOT NULL default '',
27	processors_feed varchar(255) NOT NULL default '',
28	parsers varchar(255) NOT NULL default '',
29	refresh integer NOT NULL,
30	checked integer NOT NULL,
31	PRIMARY KEY(fid))");
32	break;
33	}
34	}
35
36	function feedapi_uninstall() {
37	switch ($GLOBALS['db_type']) {
38	case 'mysqli':
39	case 'mysql':
40	db_query("DROP TABLE {feedapi}");
41	break;
42	case 'pgsql':
43	break;
44	}
45	}