From be3737bfc04aeb80726553f446422be0db72bae5 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Mon, 8 Dec 2003 22:50:56 +0000 Subject: [PATCH] Creation of needed DB structures (prefix_backup_courses and prefix_backup_log) to store info about scheduled backups. NOTE: PostreSQL and Oracle not tested !! --- backup/db/mysql.php | 26 ++++++++++++++++- backup/db/mysql.sql | 31 ++++++++++++++++++++ backup/db/oci8po.sql | 63 ++++++++++++++++++++++++++++++++++++++++- backup/db/postgres7.sql | 25 ++++++++++++++++ backup/version.php | 2 +- 5 files changed, 144 insertions(+), 3 deletions(-) diff --git a/backup/db/mysql.php b/backup/db/mysql.php index 7ccef2de67..d5c74a1184 100644 --- a/backup/db/mysql.php +++ b/backup/db/mysql.php @@ -77,7 +77,31 @@ function backup_upgrade($oldversion=0) { `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) - ) TYPE=MyISAM COMMENT='To store backup configuration variables'"); + ) TYPE=MyISAM COMMENT='To store backup configuration variables'"); + } + + if ($oldversion < 2003120800 and $result) { + $result = execute_sql("CREATE TABLE `{$CFG->prefix}backup_courses` ( + `id` int(10) unsigned NOT NULL auto_increment, + `courseid` int(10) unsigned NOT NULL default '0', + `laststarttime` int(10) unsigned NOT NULL default '0', + `lastendtime` int(10) unsigned NOT NULL default '0', + `laststatus` varchar(1) NOT NULL default '0', + `nextstarttime` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `courseid` (`courseid`) + ) TYPE=MyISAM COMMENT='To store every course backup status'"); + + if ($result) { + $result = execute_sql("CREATE TABLE `{$CFG->prefix}backup_log` ( + `id` int(10) unsigned NOT NULL auto_increment, + `courseid` int(10) unsigned NOT NULL default '0', + `time` int(10) unsigned NOT NULL default '0', + `laststarttime` int(10) unsigned NOT NULL default '0', + `info` varchar(255) NOT NULL default '', + PRIMARY KEY (`id`) + ) TYPE=MyISAM COMMENT='To store every course backup log info'"); + } } //Finally, return result diff --git a/backup/db/mysql.sql b/backup/db/mysql.sql index 96f35adbf2..f0631ebb31 100644 --- a/backup/db/mysql.sql +++ b/backup/db/mysql.sql @@ -38,3 +38,34 @@ CREATE TABLE `prefix_backup_config` ( UNIQUE KEY `name` (`name`) ) TYPE=MyISAM COMMENT='To store backup configuration variables'; # -------------------------------------------------------- + +# +# Table structure for table `prefix_backup_courses` +# + +CREATE TABLE `prefix_backup_courses` ( + `id` int(10) unsigned NOT NULL auto_increment, + `courseid` int(10) unsigned NOT NULL default '0', + `laststarttime` int(10) unsigned NOT NULL default '0', + `lastendtime` int(10) unsigned NOT NULL default '0', + `laststatus` varchar(1) NOT NULL default '0', + `nextstarttime` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`id`), + UNIQUE KEY `courseid` (`courseid`) +) TYPE=MyISAM COMMENT='To store every course backup status'; + +# -------------------------------------------------------- + +# +# Table structure for table `prefix_backup_log` +# + +CREATE TABLE `prefix_backup_log` ( + `id` int(10) unsigned NOT NULL auto_increment, + `courseid` int(10) unsigned NOT NULL default '0', + `time` int(10) unsigned NOT NULL default '0', + `laststarttime` int(10) unsigned NOT NULL default '0', + `info` varchar(255) NOT NULL default '', + PRIMARY KEY (`id`) +) TYPE=MyISAM COMMENT='To store every course backup log info'; +# -------------------------------------------------------- diff --git a/backup/db/oci8po.sql b/backup/db/oci8po.sql index b0f74ffbfb..c2759b986c 100755 --- a/backup/db/oci8po.sql +++ b/backup/db/oci8po.sql @@ -41,7 +41,7 @@ COMMENT on table prefix_backup_ids is 'To store and convert ids in backup/restor rem -------------------------------------------------------- rem -rem Table structure for table prefix_backup_ids +rem Table structure for table prefix_backup_config rem drop TABLE prefix_backup_config; @@ -66,4 +66,65 @@ create or replace trigger p_backup_config_trig begin select p_backup_config_seq.nextval into :new_row.id from dual; end; + +rem -------------------------------------------------------- +rem +rem Table structure for table prefix_backup_courses +rem + +drop TABLE prefix_backup_courses; + +CREATE TABLE prefix_backup_courses ( + id number(10) default '0' NOT NULL, + courseid number(10) default '0' NOT NULL, + laststarttime number(10) default '0' NOT NULL, + lastendtime number(10) default '0' NOT NULL, + laststatus varchar2(1) default '0' NOT NULL, + nextstarttime number(10) default '0' NOT NULL, + constraint pk_bacu primary key (id), + constraint uk_bacu_courseid unique (courseid) +); + +COMMENT on table prefix_backup_courses is 'To store every course backup status'; + +drop sequence p_backup_courses_seq; +create sequence p_backup_courses_seq; + +create or replace trigger p_backup_courses_trig + before insert on prefix_backup_courses + referencing new as new_row + for each row + begin + select p_backup_courses_seq.nextval into :new_row.id from dual; + end; + +rem -------------------------------------------------------- +rem +rem Table structure for table prefix_backup_log +rem + +drop TABLE prefix_backup_log; + +CREATE TABLE prefix_backup_log ( + id number(10) default '0' NOT NULL, + courseid number(10) default '0' NOT NULL, + time number(10) default '0' NOT NULL, + laststarttime number(10) default '0' NOT NULL, + info varchar2(255) default '0' NOT NULL, + constraint pk_balo primary key (id) +); + +COMMENT on table prefix_backup_log is 'To store every course backup log info'; + +drop sequence p_backup_log_seq; +create sequence p_backup_log_seq; + +create or replace trigger p_backup_log_trig + before insert on prefix_backup_log + referencing new as new_row + for each row + begin + select p_backup_log_seq.nextval into :new_row.id from dual; + end; + / diff --git a/backup/db/postgres7.sql b/backup/db/postgres7.sql index 1c29773683..9f71f04f15 100644 --- a/backup/db/postgres7.sql +++ b/backup/db/postgres7.sql @@ -40,3 +40,28 @@ CREATE TABLE prefix_backup_config ( name varchar(255) UNIQUE NOT NULL default '', value varchar(255) NOT NULL default '' ); + +# +# Table structure for table prefix_backup_courses +# + +CREATE TABLE prefix_backup_courses ( + id SERIAL PRIMARY KEY, + courseid int8 UNIQUE NOT NULL default '0', + laststarttime int8 NOT NULL default '0', + lastendtime int8 NOT NULL default '0', + laststatus varchar(1) NOT NULL default '0', + nextstarttime int8 NOT NULL default '0' +); + +# +# Table structure for table prefix_backup_log +# + +CREATE TABLE prefix_backup_log + id SERIAL PRIMARY KEY, + courseid int8 NOT NULL default '0', + time int8 NOT NULL default '0', + laststarttime int8 NOT NULL default '0', + info varchar(255) NOT NULL default '' +); diff --git a/backup/version.php b/backup/version.php index e94d4faa49..80615e95ba 100644 --- a/backup/version.php +++ b/backup/version.php @@ -5,6 +5,6 @@ // database (backup_version) to determine whether upgrades should // be performed (see db/backup_*.php) -$backup_version = 2003113000; // The current version is a date (YYYYMMDDXX) +$backup_version = 2003120800; // The current version is a date (YYYYMMDDXX) $backup_release = "1.2 development"; // User-friendly version number -- 2.39.5