modules/stage/stage.install

<?php
// $Id: stage.install,v 1.1 2008/07/01 12:58:58 daryl Exp $
/**
 * Implementation of hook_install()
 */
function stage_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':

      db_query('CREATE TABLE `stage_queue` (
          `nid` int(10) NOT NULL,
          `vid` int(10) NOT NULL,
          `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
          `sid` int(11) default NULL
        ) ENGINE=MyISAM DEFAULT CHARSET=latin1');

      db_query('CREATE TABLE `stage_deployment` (
          `sid` int(10) unsigned default NULL,
          `name` varchar(255) default NULL,
          `uid` int(11) default NULL,
          `time_pushed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
        ) ENGINE=MyISAM DEFAULT CHARSET=latin1');
      db_query('INSERT INTO stage_deployment (sid) VALUES(1)');
  }
}

1	<?php
2	// $Id: stage.install,v 1.1 2008/07/01 12:58:58 daryl Exp $
3	/**
4	* Implementation of hook_install()
5	*/
6	function stage_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'mysqli':
9	case 'mysql':
10
11	db_query('CREATE TABLE `stage_queue` (
12	`nid` int(10) NOT NULL,
13	`vid` int(10) NOT NULL,
14	`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
15	`sid` int(11) default NULL
16	) ENGINE=MyISAM DEFAULT CHARSET=latin1');
17
18	db_query('CREATE TABLE `stage_deployment` (
19	`sid` int(10) unsigned default NULL,
20	`name` varchar(255) default NULL,
21	`uid` int(11) default NULL,
22	`time_pushed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
23	) ENGINE=MyISAM DEFAULT CHARSET=latin1');
24	db_query('INSERT INTO stage_deployment (sid) VALUES(1)');
25	}
26	}
27