feedapi/feedapi_item/feedapi_item.install

<?php
// $Id: feedapi_item.install,v 1.6 2007/07/18 16:36:48 aronnovak Exp $

function feedapi_item_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE if not exists {feedapi_node_item} (
        fiid int(10) unsigned NOT NULL auto_increment,
        fid int(10) unsigned NOT NULL,
        nid int(10) unsigned NOT NULL,
        url varchar(255) NOT NULL default '',
        timestamp int unsigned NOT NULL default '0',
        arrived  int unsigned NOT NULL default '0',
        guid varchar(255) NOT NULL default '',
        PRIMARY KEY(fiid, nid))");
      db_query("CREATE TABLE if not exists {feedapi_node_item_settings} (
        fid int(10) unsigned NOT NULL,
        content_type varchar(255) NOT NULL default '',
        uid int NOT NULL default '0',
        date varchar(10) NOT NULL default 'feed',
        PRIMARY KEY(fid));");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {feedapi_node_item} (
        fiid serial,
        fid integer not null,
        nid integer not null,
        url varchar(255) NOT NULL default '',
        timestamp integer not null,
        arrived integer not null,
        guid varchar(255) NOT NULL default '',
        PRIMARY KEY(fiid, nid))");
      db_query("CREATE TABLE if not exists {feedapi_node_item_settings} (
        fid integer not null,
        content_type varchar(255) NOT NULL default '',
        uid int NOT NULL default '0',
        date varchar(10) NOT NULL default 'feed',
        PRIMARY KEY(fid));");
      break;
  }
}

function feedapi_item_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
    case 'pgsql':
      db_query("DROP TABLE {feedapi_node_item}");
      db_query("DROP TABLE {feedapi_node_item_settings}");
      break;
  }
}
1	<?php
2	// $Id: feedapi_item.install,v 1.6 2007/07/18 16:36:48 aronnovak Exp $
3
4	function feedapi_item_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	db_query("CREATE TABLE if not exists {feedapi_node_item} (
9	fiid int(10) unsigned NOT NULL auto_increment,
10	fid int(10) unsigned NOT NULL,
11	nid int(10) unsigned NOT NULL,
12	url varchar(255) NOT NULL default '',
13	timestamp int unsigned NOT NULL default '0',
14	arrived int unsigned NOT NULL default '0',
15	guid varchar(255) NOT NULL default '',
16	PRIMARY KEY(fiid, nid))");
17	db_query("CREATE TABLE if not exists {feedapi_node_item_settings} (
18	fid int(10) unsigned NOT NULL,
19	content_type varchar(255) NOT NULL default '',
20	uid int NOT NULL default '0',
21	date varchar(10) NOT NULL default 'feed',
22	PRIMARY KEY(fid));");
23	break;
24	case 'pgsql':
25	db_query("CREATE TABLE {feedapi_node_item} (
26	fiid serial,
27	fid integer not null,
28	nid integer not null,
29	url varchar(255) NOT NULL default '',
30	timestamp integer not null,
31	arrived integer not null,
32	guid varchar(255) NOT NULL default '',
33	PRIMARY KEY(fiid, nid))");
34	db_query("CREATE TABLE if not exists {feedapi_node_item_settings} (
35	fid integer not null,
36	content_type varchar(255) NOT NULL default '',
37	uid int NOT NULL default '0',
38	date varchar(10) NOT NULL default 'feed',
39	PRIMARY KEY(fid));");
40	break;
41	}
42	}
43
44	function feedapi_item_uninstall() {
45	switch ($GLOBALS['db_type']) {
46	case 'mysqli':
47	case 'mysql':
48	case 'pgsql':
49	db_query("DROP TABLE {feedapi_node_item}");
50	db_query("DROP TABLE {feedapi_node_item_settings}");
51	break;
52	}
53	}