1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
rem
rem Table structure for table prefix_backup_files
rem
drop table prefix_backup_files;
CREATE TABLE prefix_backup_files (
backup_code number(10) default '0' NOT NULL,
file_type varchar2(10) default '' NOT NULL,
path varchar2(255) default '' NOT NULL,
old_id number(10) default NULL,
new_id number(10) default NULL
);
ALTER TABLE prefix_backup_files
ADD CONSTRAINT pbf_pk
PRIMARY KEY (backup_code,file_type,path);
COMMENT on table prefix_backup_files is 'To store and recode ids to user and course files.';
rem --------------------------------------------------------
rem
rem Table structure for table prefix_backup_ids
rem
drop table prefix_backup_ids;
CREATE TABLE prefix_backup_ids (
backup_code number(12) default '0' NOT NULL,
table_name varchar2(30) default '' NOT NULL,
old_id number(10) default '0' NOT NULL,
new_id number(10) default NULL,
info varchar2(20)
);
ALTER TABLE prefix_backup_ids
ADD CONSTRAINT pbi_pk
PRIMARY KEY (backup_code,table_name,old_id);
COMMENT on table prefix_backup_ids is 'To store and convert ids in backup/restore';
rem --------------------------------------------------------
rem
rem Table structure for table prefix_backup_config
rem
drop TABLE prefix_backup_config;
CREATE TABLE prefix_backup_config (
id number(10) default '0' not null,
name varchar2(255) default '' not null,
value varchar2(255) default '' not null,
constraint pk_baco primary key (id),
constraint uk_baco_name unique (name)
);
COMMENT on table prefix_backup_config is 'To store backup configuration variables';
drop sequence p_backup_config_seq;
create sequence p_backup_config_seq;
create or replace trigger p_backup_config_trig
before insert on prefix_backup_config
referencing new as new_row
for each row
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;
/
|
