modules/node_blaster/node_blaster.install

<?php
// for node_blaster.module  by : dksdev01
// compatible with drupal core -- 4.7
function node_blaster_install() {
/*
 db_query("DROP TABLE IF EXISTS `node_blaster`;");  // only when database changes done
 db_query("DROP TABLE IF EXISTS `node_blaster_node`;");
 db_query("DROP TABLE IF EXISTS `node_blaster_subscriber`;"); */
   
db_query("CREATE TABLE {node_blaster} (
  `vid` int(10) unsigned NOT NULL,
  `nid` int(10) unsigned NOT NULL,
  `mail_theme` varchar(255) NOT NULL,
  `redirect_url` varchar(255) NOT NULL,
  `public_url` varchar(255) NOT NULL,
  PRIMARY KEY  (`vid`)
) TYPE=MyISAM;");

db_query("CREATE TABLE {node_blaster_node} (
  `aid` int(10) unsigned NOT NULL,
  `nid` int(10) unsigned NOT NULL,
  `series` int(10) NOT NULL,
  `day_sent` int(10) NOT NULL,
  PRIMARY KEY  (`aid`,`nid`)
) TYPE=MyISAM;");  	


db_query("CREATE TABLE {node_blaster_subscriber} (
  `sid` int(99) unsigned NOT NULL auto_increment,
  `aid` int(99) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM;");

  $success = TRUE; 
  if ($success) {
    drupal_set_message(t('Node blaster table created. Installation completed successfully.'));
  }
}

function node_blaster_update_1() { 
	return _system_update_utf8(array( 'node_blaster_node', 'node_blaster' ));
}
?>
1	<?php
2	// for node_blaster.module by : dksdev01
3	// compatible with drupal core -- 4.7
4	function node_blaster_install() {
5	/*
6	db_query("DROP TABLE IF EXISTS `node_blaster`;"); // only when database changes done
7	db_query("DROP TABLE IF EXISTS `node_blaster_node`;");
8	db_query("DROP TABLE IF EXISTS `node_blaster_subscriber`;"); */
9
10	db_query("CREATE TABLE {node_blaster} (
11	`vid` int(10) unsigned NOT NULL,
12	`nid` int(10) unsigned NOT NULL,
13	`mail_theme` varchar(255) NOT NULL,
14	`redirect_url` varchar(255) NOT NULL,
15	`public_url` varchar(255) NOT NULL,
16	PRIMARY KEY (`vid`)
17	) TYPE=MyISAM;");
18
19	db_query("CREATE TABLE {node_blaster_node} (
20	`aid` int(10) unsigned NOT NULL,
21	`nid` int(10) unsigned NOT NULL,
22	`series` int(10) NOT NULL,
23	`day_sent` int(10) NOT NULL,
24	PRIMARY KEY (`aid`,`nid`)
25	) TYPE=MyISAM;");
26
27
28	db_query("CREATE TABLE {node_blaster_subscriber} (
29	`sid` int(99) unsigned NOT NULL auto_increment,
30	`aid` int(99) NOT NULL,
31	`name` varchar(255) NOT NULL,
32	`email` varchar(255) NOT NULL,
33	`date` int(11) NOT NULL,
34	PRIMARY KEY (`sid`)
35	) TYPE=MyISAM;");
36
37	$success = TRUE;
38	if ($success) {
39	drupal_set_message(t('Node blaster table created. Installation completed successfully.'));
40	}
41	}
42
43	function node_blaster_update_1() {
44	return _system_update_utf8(array( 'node_blaster_node', 'node_blaster' ));
45	}
46	?>