modules/upcomingorg/upcomingorg.install

<?php
function upcomingorg_install() {
  drupal_set_message('Installing the Upcoming.org module');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("
      	CREATE TABLE upcomingorg_category (
        category_id INT UNSIGNED NOT NULL,
        name VARCHAR(250) NOT NULL,
        description TEXT,
        PRIMARY KEY (category_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      db_query("
        CREATE TABLE upcomingorg_event (
        nid int(10) unsigned NOT NULL default '0',
        event_id int(10) unsigned default NULL,
        metro_id int(10) unsigned default NULL,
        venue_nid int(10) unsigned default NULL,
        user_id int(10) unsigned default NULL,
        category_id int(10) unsigned default NULL,
        description text,
        tags text,
        personal tinyint(1) unsigned NOT NULL default '0',
        selfpromotion tinyint(1) unsigned NOT NULL default '0',
        is_imported tinyint(1) unsigned NOT NULL default '0',
        PRIMARY KEY  (nid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      db_query("
        CREATE TABLE upcomingorg_user (
        uid int(10) unsigned NOT NULL default '0',
        upcomingorg_rest_url varchar(200) NOT NULL default '',
        user_id int(10) unsigned NOT NULL default '0',
        upcomingorg_token varchar(50) NOT NULL default '',
        PRIMARY KEY  (uid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      db_query("
        CREATE TABLE upcomingorg_venue (
        nid int(10) unsigned NOT NULL default '0',
        venue_id int(10) unsigned NOT NULL default '0',
        metro_id int(10) unsigned NOT NULL default '0',
        user_id int(10) unsigned NOT NULL default '0',
        description text,
        url varchar(250) default NULL,
        phone varchar(50) default NULL,
        private tinyint(1) unsigned NOT NULL default '0',
        is_imported tinyint(1) unsigned NOT NULL default '0',
        PRIMARY KEY  (nid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      $success = TRUE;
      break;
    case 'pgsql':
      // TODO add postgres code here
    	//$success = TRUE;
      break;
    default:
      break;
  } // End case

  if ($success) {
    drupal_set_message(t('The Upcoming.org module installed tables successfully.'));
  }
  else {
    drupal_set_message(t('The installation of the Upcoming.org module was unsuccessful.'), 'error');
  }
}
1	<?php
2	function upcomingorg_install() {
3	drupal_set_message('Installing the Upcoming.org module');
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	db_query("
8	CREATE TABLE upcomingorg_category (
9	category_id INT UNSIGNED NOT NULL,
10	name VARCHAR(250) NOT NULL,
11	description TEXT,
12	PRIMARY KEY (category_id)
13	) /!40100 DEFAULT CHARACTER SET utf8 /;
14	");
15	db_query("
16	CREATE TABLE upcomingorg_event (
17	nid int(10) unsigned NOT NULL default '0',
18	event_id int(10) unsigned default NULL,
19	metro_id int(10) unsigned default NULL,
20	venue_nid int(10) unsigned default NULL,
21	user_id int(10) unsigned default NULL,
22	category_id int(10) unsigned default NULL,
23	description text,
24	tags text,
25	personal tinyint(1) unsigned NOT NULL default '0',
26	selfpromotion tinyint(1) unsigned NOT NULL default '0',
27	is_imported tinyint(1) unsigned NOT NULL default '0',
28	PRIMARY KEY (nid)
29	) /!40100 DEFAULT CHARACTER SET utf8 /;
30	");
31	db_query("
32	CREATE TABLE upcomingorg_user (
33	uid int(10) unsigned NOT NULL default '0',
34	upcomingorg_rest_url varchar(200) NOT NULL default '',
35	user_id int(10) unsigned NOT NULL default '0',
36	upcomingorg_token varchar(50) NOT NULL default '',
37	PRIMARY KEY (uid)
38	) /!40100 DEFAULT CHARACTER SET utf8 /;
39	");
40	db_query("
41	CREATE TABLE upcomingorg_venue (
42	nid int(10) unsigned NOT NULL default '0',
43	venue_id int(10) unsigned NOT NULL default '0',
44	metro_id int(10) unsigned NOT NULL default '0',
45	user_id int(10) unsigned NOT NULL default '0',
46	description text,
47	url varchar(250) default NULL,
48	phone varchar(50) default NULL,
49	private tinyint(1) unsigned NOT NULL default '0',
50	is_imported tinyint(1) unsigned NOT NULL default '0',
51	PRIMARY KEY (nid)
52	) /!40100 DEFAULT CHARACTER SET utf8 /;
53	");
54	$success = TRUE;
55	break;
56	case 'pgsql':
57	// TODO add postgres code here
58	//$success = TRUE;
59	break;
60	default:
61	break;
62	} // End case
63
64	if ($success) {
65	drupal_set_message(t('The Upcoming.org module installed tables successfully.'));
66	}
67	else {
68	drupal_set_message(t('The installation of the Upcoming.org module was unsuccessful.'), 'error');
69	}
70	}