modules/subscribe/subscribe.install

<?php
  // $Id: subscribe.install,v 1.2 2006/05/04 03:21:24 jvandyk Exp $

  function subscribe_install() {
    drupal_set_message(t('Beginning installation of subscribe module.'));
    switch ($GLOBALS['db_type']) {
      case 'mysql':
      case 'mysqli':
        db_query("CREATE TABLE {subscribe_node} (
          nid int(10) unsigned NOT NULL default '0',
          sid int(10) unsigned NOT NULL default '0',
          remote_nid int(10) unsigned NOT NULL default '0',
          remote_uid int(10) unsigned NOT NULL default '0',
          remote_author varchar(255) NOT NULL default '',
          KEY nid (nid,sid,remote_uid)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");

        db_query("CREATE TABLE {subscribe_subscriptions} (
           sid int(10) unsigned NOT NULL default '0',
           rsid int(10) unsigned NOT NULL default '0',
           name varchar(255) NOT NULL default '',
           base_url varchar(255) NOT NULL default '',
           url varchar(255) NOT NULL default '',
           channel_id varchar(255) NOT NULL default '',
           domain varchar(255) NOT NULL default '',
           username varchar(60) NOT NULL default '',
           pass varchar(32) NOT NULL default '',
           token varchar(32) NOT NULL default '',
           method varchar(16) NOT NULL default '',
           last_update int(11) NOT NULL default '0',
           PRIMARY KEY  (sid),
           KEY domain (domain,token)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");

        db_query("CREATE TABLE {subscribe_vocab_map} (
          sid int(10) unsigned NOT NULL default '0',
          remote_vid int(10) unsigned NOT NULL default '0',
          local_vid int(10) unsigned NOT NULL default '0',
          KEY remote_vid (remote_vid,local_vid)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");

        $success = TRUE;
        break;
      default:
        drupal_set_message(t('Unsupported database.'));
        break;
    }

    if ($success) {
      drupal_set_message(t('The subscribe module installed tables successfully.'));
    }
    else {
      drupal_set_message(t('The installation of the subscribe module was unsuccessful.'), 'error');
    }
  }

  function subscribe_update_1() {
    return _system_update_utf8(array('subscribe_node', 'subscribe_subscriptions', 'subscribe_vocab_map'));
  }
1	<?php
2	// $Id: subscribe.install,v 1.2 2006/05/04 03:21:24 jvandyk Exp $
3
4	function subscribe_install() {
5	drupal_set_message(t('Beginning installation of subscribe module.'));
6	switch ($GLOBALS['db_type']) {
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE {subscribe_node} (
10	nid int(10) unsigned NOT NULL default '0',
11	sid int(10) unsigned NOT NULL default '0',
12	remote_nid int(10) unsigned NOT NULL default '0',
13	remote_uid int(10) unsigned NOT NULL default '0',
14	remote_author varchar(255) NOT NULL default '',
15	KEY nid (nid,sid,remote_uid)
16	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
17
18	db_query("CREATE TABLE {subscribe_subscriptions} (
19	sid int(10) unsigned NOT NULL default '0',
20	rsid int(10) unsigned NOT NULL default '0',
21	name varchar(255) NOT NULL default '',
22	base_url varchar(255) NOT NULL default '',
23	url varchar(255) NOT NULL default '',
24	channel_id varchar(255) NOT NULL default '',
25	domain varchar(255) NOT NULL default '',
26	username varchar(60) NOT NULL default '',
27	pass varchar(32) NOT NULL default '',
28	token varchar(32) NOT NULL default '',
29	method varchar(16) NOT NULL default '',
30	last_update int(11) NOT NULL default '0',
31	PRIMARY KEY (sid),
32	KEY domain (domain,token)
33	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
34
35	db_query("CREATE TABLE {subscribe_vocab_map} (
36	sid int(10) unsigned NOT NULL default '0',
37	remote_vid int(10) unsigned NOT NULL default '0',
38	local_vid int(10) unsigned NOT NULL default '0',
39	KEY remote_vid (remote_vid,local_vid)
40	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
41
42	$success = TRUE;
43	break;
44	default:
45	drupal_set_message(t('Unsupported database.'));
46	break;
47	}
48
49	if ($success) {
50	drupal_set_message(t('The subscribe module installed tables successfully.'));
51	}
52	else {
53	drupal_set_message(t('The installation of the subscribe module was unsuccessful.'), 'error');
54	}
55	}
56
57	function subscribe_update_1() {
58	return _system_update_utf8(array('subscribe_node', 'subscribe_subscriptions', 'subscribe_vocab_map'));
59	}