/[drupal]/contributions/modules/schedule/schedule.install
ViewVC logotype

Diff of /contributions/modules/schedule/schedule.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.1.2.2, Mon Jan 8 16:43:07 2007 UTC revision 1.1.2.3, Fri Mar 9 22:45:32 2007 UTC
# Line 15  function schedule_install() { Line 15  function schedule_install() {
15    switch ($GLOBALS['db_type']) {    switch ($GLOBALS['db_type']) {
16      case 'mysqli':      case 'mysqli':
17      case 'mysql':      case 'mysql':
18        $query1 = db_query("CREATE TABLE IF NOT EXISTS {schedules} (        $query1 = db_query("CREATE TABLE IF NOT EXISTS {schedule} (
19                        schedule_id int(10) NOT NULL auto_increment,                        schedule_id int(10) NOT NULL auto_increment,
20                        schedule_title varchar(100) NOT NULL,                        schedule_title varchar(100) NOT NULL,
21                        type varchar(20) NOT NULL,                        type varchar(20) NOT NULL,
# Line 32  function schedule_install() { Line 32  function schedule_install() {
32                        PRIMARY KEY  (schedule_id)                        PRIMARY KEY  (schedule_id)
33                          ) /*!40100 DEFAULT CHARACTER SET utf8 */;");                          ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
34    
35        $query2 = db_query("CREATE TABLE IF NOT EXISTS {schedules_action} (        $query2 = db_query("CREATE TABLE IF NOT EXISTS {schedule_action} (
36                          action_id INT( 10 ) NOT NULL AUTO_INCREMENT ,                          action_id INT( 10 ) NOT NULL AUTO_INCREMENT ,
37                          type varchar(20) NOT NULL,                          type varchar(20) NOT NULL,
38                          publication_id INT( 10 ) NOT NULL ,                          publication_id INT( 10 ) NOT NULL ,
# Line 66  function schedule_update_1() { Line 66  function schedule_update_1() {
66    return;    return;
67  }  }
68    
69    function schedule_update_2() {
70    
71      $ret = array();
72    
73      if ($GLOBALS['db_type'] == 'mysql' || $GLOBALS['db_type'] == 'mysqli') {
74        $ret[] = update_sql("ALTER TABLE {schedules} RENAME TO {schedule}");
75        $ret[] = update_sql("ALTER TABLE {schedules_action} RENAME TO {schedule_action}");
76      }
77    
78      return $ret;
79    }
80    
81    
82    
83  ?>  ?>
Legend:
Removed from v.1.1.2.2  
changed lines
  Added in v.1.1.2.3
  ViewVC Help
Powered by ViewVC 1.1.2