modules/volunteer_timeslots/volunteer_timeslots.install

<?php
// $Id: volunteer_timeslots.install,v 1.4 2007/07/13 00:51:37 pwolanin Exp $

/**
 * Implementation of hook_install().
 */
function volunteer_timeslots_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {volunteer_timeslots} (
        vid int unsigned NOT NULL default '0',
        nid int unsigned NOT NULL default '0',
        timeslot_length int NOT NULL default '1',
        num_volunteers int NOT NULL default '1',
        timeslots_organizers varchar(255) NOT NULL default '',
        timeslot_data longtext NOT NULL,
        PRIMARY KEY (nid, vid),
        KEY vid (vid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {volunteer_timeslots} (
        vid integer NOT NULL default '0',
        nid integer NOT NULL default '0',
        timeslot_length integer NOT NULL default '1',
        num_volunteers integer NOT NULL default '1',
        timeslots_organizers varchar(255) NOT NULL default '',
        timeslot_data text NOT NULL,
        PRIMARY KEY (nid, vid),
        UNIQUE (vid)
      )");
      break;
  }
  variable_set('event_nodeapi_volunteer_timeslots', 'all');
  variable_set('node_options_volunteer_timeslots', array('status', 'revision'));
}

function volunteer_timeslots_uninstall() {
  db_query("DELETE FROM {node_type} WHERE module = 'volunteer_timeslots'");
  db_query("DROP TABLE {volunteer_timeslots}");
  variable_del('event_nodeapi_volunteer_timeslots');
  variable_del('node_options_volunteer_timeslots');
  variable_del('volunteer_timeslots_profile_fields');
  variable_del('volunteer_timeslots_remind_time');
  variable_del('volunteer_timeslots_author_manages');
  variable_del('volunteer_timeslots_organizer_updates');
} 
1	<?php
2	// $Id: volunteer_timeslots.install,v 1.4 2007/07/13 00:51:37 pwolanin Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function volunteer_timeslots_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {volunteer_timeslots} (
12	vid int unsigned NOT NULL default '0',
13	nid int unsigned NOT NULL default '0',
14	timeslot_length int NOT NULL default '1',
15	num_volunteers int NOT NULL default '1',
16	timeslots_organizers varchar(255) NOT NULL default '',
17	timeslot_data longtext NOT NULL,
18	PRIMARY KEY (nid, vid),
19	KEY vid (vid)
20	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
21	break;
22	case 'pgsql':
23	db_query("CREATE TABLE {volunteer_timeslots} (
24	vid integer NOT NULL default '0',
25	nid integer NOT NULL default '0',
26	timeslot_length integer NOT NULL default '1',
27	num_volunteers integer NOT NULL default '1',
28	timeslots_organizers varchar(255) NOT NULL default '',
29	timeslot_data text NOT NULL,
30	PRIMARY KEY (nid, vid),
31	UNIQUE (vid)
32	)");
33	break;
34	}
35	variable_set('event_nodeapi_volunteer_timeslots', 'all');
36	variable_set('node_options_volunteer_timeslots', array('status', 'revision'));
37	}
38
39	function volunteer_timeslots_uninstall() {
40	db_query("DELETE FROM {node_type} WHERE module = 'volunteer_timeslots'");
41	db_query("DROP TABLE {volunteer_timeslots}");
42	variable_del('event_nodeapi_volunteer_timeslots');
43	variable_del('node_options_volunteer_timeslots');
44	variable_del('volunteer_timeslots_profile_fields');
45	variable_del('volunteer_timeslots_remind_time');
46	variable_del('volunteer_timeslots_author_manages');
47	variable_del('volunteer_timeslots_organizer_updates');
48	}