modules/view_scheduler/views_scheduler.install

<?php
// $Id: views_scheduler.install,v 1.8 2006/09/10 20:40:50 flk Exp $

function views_scheduler_install() {
  drupal_set_message('Installing views scheduler.....');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {view_schedules} (
        vschedule_id int(10) NOT NULL auto_increment,
        view varchar(60) NOT NULL default '0',
        node int(2) NOT NULL default '0',
        PRIMARY KEY  (vschedule_id),
        KEY view (view)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      db_query("CREATE TABLE {view_schedules_actions_registry} (
        vsid int(10) unsigned NOT NULL default '0',
        aid varchar(40) default NULL,
        weight int(10) NOT NULL default '0',
        KEY vsid (vsid),
        KEY aid (aid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      db_query("CREATE TABLE {schedules} (
        schedule_id int(10) NOT NULL auto_increment,
        schedule_title varchar(100) NOT NULL default '',
        type varchar(20) NOT NULL default '',
        publication_id int(10) NOT NULL default '0',
        start int(11) NOT NULL default '0',
        first int(11) NOT NULL default '0',
        next int(11) NOT NULL default '0',
        last int(11) NOT NULL default '0',
        every int(3) NOT NULL default '0',
        frequency varchar(6) NOT NULL default '',
        relative varchar(6) NOT NULL default '',
        relative_date varchar(25) NOT NULL default '',
        timeout int(4) NOT NULL default '0',
        PRIMARY KEY  (schedule_id)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      db_query("CREATE TABLE {schedules_sent} (
        publication_id int(10) NOT NULL default '0',
        type varchar(20) NOT NULL default '',
        uid int(10) NOT NULL default '0',
        pub_time int(11) NOT NULL default '0',
        sent int(11) NOT NULL default '0'
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      $success = TRUE;
      break;
       
  }
  //if all the tables were installed give confirmation, otherwise display error.
  if ($success) {
    drupal_set_message(t('View Scheduler module installed tables successfully.'));
  }
  else {
    drupal_set_message(t('The installation of View Scheduler module was unsuccessful.'), 'error');
  }
}
1	<?php
2	// $Id: views_scheduler.install,v 1.8 2006/09/10 20:40:50 flk Exp $
3
4	function views_scheduler_install() {
5	drupal_set_message('Installing views scheduler.....');
6	switch ($GLOBALS['db_type']) {
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE {view_schedules} (
10	vschedule_id int(10) NOT NULL auto_increment,
11	view varchar(60) NOT NULL default '0',
12	node int(2) NOT NULL default '0',
13	PRIMARY KEY (vschedule_id),
14	KEY view (view)
15	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
16
17	db_query("CREATE TABLE {view_schedules_actions_registry} (
18	vsid int(10) unsigned NOT NULL default '0',
19	aid varchar(40) default NULL,
20	weight int(10) NOT NULL default '0',
21	KEY vsid (vsid),
22	KEY aid (aid)
23	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
24
25	db_query("CREATE TABLE {schedules} (
26	schedule_id int(10) NOT NULL auto_increment,
27	schedule_title varchar(100) NOT NULL default '',
28	type varchar(20) NOT NULL default '',
29	publication_id int(10) NOT NULL default '0',
30	start int(11) NOT NULL default '0',
31	first int(11) NOT NULL default '0',
32	next int(11) NOT NULL default '0',
33	last int(11) NOT NULL default '0',
34	every int(3) NOT NULL default '0',
35	frequency varchar(6) NOT NULL default '',
36	relative varchar(6) NOT NULL default '',
37	relative_date varchar(25) NOT NULL default '',
38	timeout int(4) NOT NULL default '0',
39	PRIMARY KEY (schedule_id)
40	) /!40100 DEFAULT CHARACTER SET utf8 /;");
41
42	db_query("CREATE TABLE {schedules_sent} (
43	publication_id int(10) NOT NULL default '0',
44	type varchar(20) NOT NULL default '',
45	uid int(10) NOT NULL default '0',
46	pub_time int(11) NOT NULL default '0',
47	sent int(11) NOT NULL default '0'
48	) /!40100 DEFAULT CHARACTER SET utf8 /;");
49
50	$success = TRUE;
51	break;
52
53	}
54	//if all the tables were installed give confirmation, otherwise display error.
55	if ($success) {
56	drupal_set_message(t('View Scheduler module installed tables successfully.'));
57	}
58	else {
59	drupal_set_message(t('The installation of View Scheduler module was unsuccessful.'), 'error');
60	}
61	}