From a1b2bec87378ada0f0ff268c90900a3876082c2b Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 26 Aug 2003 07:09:14 +0000
Subject: [PATCH] Remove half-finished oracle files
---
lib/db/oci8po.sql | 633 -----------------------------------------
mod/quiz/db/oci8po.sql | 548 -----------------------------------
2 files changed, 1181 deletions(-)
delete mode 100755 lib/db/oci8po.sql
delete mode 100755 mod/quiz/db/oci8po.sql
diff --git a/lib/db/oci8po.sql b/lib/db/oci8po.sql
deleted file mode 100755
index 594cef0404..0000000000
--- a/lib/db/oci8po.sql
+++ /dev/null
@@ -1,633 +0,0 @@
-rem DRAFT DRAFT DRAFT DRAFT - untested
-
-set echo on pagesize 60
-
-spool s
-
-rem Conversion:
-rem remove all ` around table names
-rem change int to number
-rem change varchar to varchar2
-rem replace auto_increment with primary key, create sequence and trigger
-rem move not null from before deault to after
-rem delete primary key lines
-rem delete type=MyISAM
-rem turn comment clause into comment statement
-rem delete unique key, replace with column constraint
-
-rem
-rem Table structure for table config
-rem
-
-drop TABLE prefix_config;
-CREATE TABLE prefix_config (
- id number(10) primary key,
- name varchar2(255) default '' not null constraint unq_name unique,
- value varchar2(255) default '' not null
-);
-
-COMMENT on table prefix_config is 'Moodle configuration variables';
-
-drop sequence p_config_seq;
-create sequence p_config_seq;
-
-create or replace trigger p_config_trig
- before insert on prefix_config
- referencing new as new_row
- for each row
- begin
- select p_config_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_config (name,value) values ('Name1','Value1');
-insert into prefix_config (name,value) values ('Name2','Value2');
-insert into prefix_config (name,value) values ('Name3','Value3');
-
-rem testing unique column constraint on name: this should fail
-insert into prefix_config (name,value) values ('Name1','Value4');
-
-
-select id,substr(name,1,20) name,
- substr(value,1,22) value
- from prefix_config order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table course
-rem
-
-drop TABLE prefix_course;
-CREATE TABLE prefix_course (
- id number(10) primary key,
- category number(10) default '0' not null,
- password varchar2(50) default '' not null,
- fullname varchar2(254) default '' not null,
- shortname varchar2(15) default '' not null,
- summary varchar2(254) not null,
- format varchar2(10) default 'weeks' not null
- constraint check_format check (format in ('weeks','social','topics')),
- modinfo varchar2(254) not null,
- newsitems number(5) default '1' not null,
- teacher varchar2(100) default 'Teacher' not null,
- teachers varchar2(100) default 'Teachers' not null,
- student varchar2(100) default 'Student' not null,
- students varchar2(100) default 'Students' not null,
- guest number(2) default '0' not null,
- startdate number(10) default '0' not null,
- numsections number(5) default '1' not null,
- showrecent number(5) default '1' not null,
- marker number(10) default '0' not null,
- timecreated number(10) default '0' not null,
- timemodified number(10) default '0' not null
-);
-
-COMMENT on table prefix_course is 'Moodle prefix course table';
-
-drop sequence p_course_seq;
-create sequence p_course_seq;
-
-create or replace trigger p_course_trig
- before insert on prefix_course
- referencing new as new_row
- for each row
- begin
- select p_course_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_course ( category,password,fullname,shortname,summary,modinfo) values ( 1,'password1','fullname1','shortname1','summary1','modinfo1');
-insert into prefix_course ( category,password,fullname,shortname,summary,format,modinfo) values ( 2,'password2','fullname2','shortname2','summary2','social','modinfo2');
-insert into prefix_course ( category,password,fullname,shortname,summary,format,modinfo) values ( 2,'password2','fullname2','shortname2','summary2','topics','modinfo2');
-
-rem this one should fail due to the constraint on format disallowing 'daily'
-insert into prefix_course ( category,password,fullname,shortname,summary,format,modinfo) values ( 2,'password2','fullname2','shortname2','summary2','daily','modinfo2');
-
-select id,
- category,
- substr(password,1,8) password,
- substr(fullname,1,10) fullname,
- substr(shortname,1,20) shortname,
- substr(summary,1,10) summary,
- format,
- substr(modinfo,1,10) modinfo,
- newsitems,
- substr(teacher,1,10) teacher,
- substr(teachers,1,10) teachers,
- substr(student,1,10) student,
- substr(students,1,10) students,
- guest,
- startdate,
- numsections,
- showrecent,
- marker,
- timecreated,
- timemodified
- from prefix_course order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table course_categories
-rem
-
-drop TABLE prefix_course_categories;
-CREATE TABLE prefix_course_categories (
- id number(10) primary key,
- name varchar2(255) default '' not null
-);
-
-COMMENT on table prefix_course_categories is 'Course categories';
-
-drop sequence p_course_categories_seq;
-create sequence p_course_categories_seq;
-
-create or replace trigger p_course_categories_trig
- before insert on prefix_course_categories
- referencing new as new_row
- for each row
- begin
- select p_course_categories_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_course_categories (name) values ('name1');
-insert into prefix_course_categories (name) values ('name2');
-insert into prefix_course_categories (name) values ('name3');
-insert into prefix_course_categories (name) values ('name4');
-
-select id,substr(name,1,20) name
- from prefix_course_categories
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table course_modules
-rem
-
-drop TABLE prefix_course_modules;
-CREATE TABLE prefix_course_modules (
- id number(10) primary key,
- course number(10) default '0' not null,
- module number(10) default '0' not null,
- instance number(10) default '0' not null,
- section number(10) default '0' not null,
- added number(10) default '0' not null,
- deleted number(1) default '0' not null,
- score number(4) default '0' not null
-);
-
-COMMENT on table prefix_course_modules is 'prefix_course_modules';
-
-drop sequence p_course_modules_seq;
-create sequence p_course_modules_seq;
-
-create or replace trigger p_course_modules_trig
- before insert on prefix_course_modules
- referencing new as new_row
- for each row
- begin
- select p_course_modules_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_course_modules (course,module,instance,section,added,deleted,score) values (1,1,1,1,1,1,1);
-insert into prefix_course_modules (course,module,instance,section,added,deleted,score) values (2,2,2,2,2,2,2);
-insert into prefix_course_modules (course,module,instance,section,added,deleted,score) values (3,3,3,3,3,3,3);
-insert into prefix_course_modules (course,module,instance,section,added,deleted,score) values (4,4,4,4,4,4,4);
-
-select id,course,
- module,
- instance,
- section,
- added,
- deleted,
- score
- from prefix_course_modules
-/
-
-rem --------------------------------------------------------
-rem
-rem Table structure for table course_sections
-rem
-
-drop TABLE prefix_course_sections;
-CREATE TABLE prefix_course_sections (
- id number(10) primary key,
- course number(10) default '0' not null,
- section number(10) default '0' not null,
- summary varchar2(254) NOT NULL,
- sequence varchar2(255) default '' not null
-);
-
-COMMENT on table prefix_course_sections is 'prefix_course_sections';
-
-drop sequence p_course_sections_seq;
-create sequence p_course_sections_seq;
-
-create or replace trigger p_course_sections_trig
- before insert on prefix_course_sections
- referencing new as new_row
- for each row
- begin
- select p_course_sections_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_course_sections (course,section,summary,sequence) values (1,1,1,1);
-insert into prefix_course_sections (course,section,summary,sequence) values (2,2,2,2);
-insert into prefix_course_sections (course,section,summary,sequence) values (3,3,3,3);
-insert into prefix_course_sections (course,section,summary,sequence) values (4,4,4,4);
-
-select id,course,
- section,
- substr(summary,1,20) summary,
- substr(sequence,1,20) sequence
- from prefix_course_sections
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table log
-rem
-
-drop TABLE prefix_log;
-CREATE TABLE prefix_log (
- id number(10) primary key,
- time number(10) default '0' not null,
- userid number(10) default '0' not null,
- ip varchar2(15) default '' not null,
- course number(10) default '0' not null,
- module varchar2(10) default '' not null,
- action varchar2(15) default '' not null,
- url varchar2(100) default '' not null,
- info varchar2(255) default '' not null
-);
-
-COMMENT on table prefix_log is 'Every action is logged as far as possible.';
-
-drop sequence p_log_seq;
-create sequence p_log_seq;
-
-create or replace trigger p_log_trig
- before insert on prefix_log
- referencing new as new_row
- for each row
- begin
- select p_log_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_log (time,userid,ip,course,module,action,url,info) values (1,1,'ip1',1,'module1','action1','url1','info1');
-insert into prefix_log (time,userid,ip,course,module,action,url,info) values (2,2,'ip2',2,'module2','action2','url2','info2');
-insert into prefix_log (time,userid,ip,course,module,action,url,info) values (3,3,'ip3',3,'module3','action3','url3','info3');
-insert into prefix_log (time,userid,ip,course,module,action,url,info) values (4,4,'ip4',4,'module4','action4','url4','info4');
-
-select id,
- time,
- userid,
- substr(ip,1,20) ip,
- course,
- substr(module,1,20) module,
- substr(action,1,20) action,
- substr(url,1,20) url,
- substr(info,1,20) info
- from prefix_log
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table log_display
-rem
-
-drop TABLE prefix_log_display;
-CREATE TABLE prefix_log_display (
- module varchar2(20) default '' not null,
- action varchar2(20) default '' not null,
- mtable varchar2(20) default '' not null,
- field varchar2(40) default '' not null
-) ;
-
-COMMENT on table prefix_log_display is 'For a particular module/action, specifies a moodle table/field.';
-
-insert into prefix_log_display (module,action,mtable,field) values ('module1','action1','mtable1','field1');
-insert into prefix_log_display (module,action,mtable,field) values ('module2','action2','mtable2','field2');
-insert into prefix_log_display (module,action,mtable,field) values ('module3','action3','mtable3','field3');
-insert into prefix_log_display (module,action,mtable,field) values ('module4','action4','mtable4','field4');
-insert into prefix_log_display (module,action,mtable,field) values ('module1','action1','mtable1','field1');
-
-select substr(module,1,20) module,
- substr(action,1,20) action,
- substr(mtable,1,20) mtable,
- substr(field,1,20) field
- from prefix_log_display
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table modules
-rem
-
-drop TABLE prefix_modules;
-CREATE TABLE prefix_modules (
- id number(10) primary key,
- name varchar2(20) default '' not null,
- version number(10) default '0' not null,
- cron number(10) default '0' not null,
- lastcron number(10) default '0' not null,
- search varchar2(255) default '' not null
-);
-
-drop sequence p_modules_seq;
-create sequence p_modules_seq;
-
-create or replace trigger p_modules_trig
- before insert on prefix_modules
- referencing new as new_row
- for each row
- begin
- select p_modules_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_modules (name,version,cron,lastcron,search) values ('name1',1,1,1,'search1');
-insert into prefix_modules (name,version,cron,lastcron,search) values ('name2',2,2,2,'search2');
-insert into prefix_modules (name,version,cron,lastcron,search) values ('name3',3,3,3,'search3');
-insert into prefix_modules (name,version,cron,lastcron,search) values ('name4',4,4,4,'search4');
-
-select substr(name,1,20) name,
- version,
- cron,
- lastcron,
- substr(search,1,20) search
- from prefix_modules
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table user
-rem
-
-drop TABLE prefix_user;
-CREATE TABLE prefix_user (
- id number(10) primary key,
- confirmed number(1) default '0' not null,
- deleted number(1) default '0' not null,
- username varchar2(100) default '' not null constraint unq_username unique,
- password varchar2(32) default '' not null,
- idnumber varchar2(12) default NULL,
- firstname varchar2(20) default '' not null,
- lastname varchar2(20) default '' not null,
- email varchar2(100) default '' not null,
- icq varchar2(15) default NULL,
- phone1 varchar2(20) default NULL,
- phone2 varchar2(20) default NULL,
- institution varchar2(40) default NULL,
- department varchar2(30) default NULL,
- address varchar2(70) default NULL,
- city varchar2(20) default NULL,
- country varchar2(2) default NULL,
- lang varchar2(5) default 'en',
- timezone float default '99' not null,
- firstaccess number(10) default '0' not null,
- lastaccess number(10) default '0' not null,
- lastlogin number(10) default '0' not null,
- currentlogin number(10) default '0' not null,
- lastIP varchar2(15) default NULL,
- secret varchar2(15) default NULL,
- picture number(1) default NULL,
- url varchar2(255) default NULL,
- description varchar2(255),
- mailformat number(1) default '1' not null,
- maildisplay number(2) default '2' not null,
- htmleditor number(1) default '1' not null,
- timemodified number(10) default '0' not null
-) ;
-
-COMMENT on table prefix_user is 'One record for each person';
-
-drop sequence p_user_seq;
-create sequence p_user_seq;
-
-create or replace trigger p_user_trig
- before insert on prefix_user
- referencing new as new_row
- for each row
- begin
- select p_user_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_user ( confirmed, deleted, username, password, idnumber, firstname, lastname, email, icq, phone1, phone2, institution, department, address, city, country, lang, timezone, firstaccess, lastaccess, lastlogin, currentlogin, lastIP, secret, picture, url, description, mailformat, maildisplay, htmleditor, timemodified ) values ( 1, 1, 'username1', 'password1', 'idnumber1', 'firstname1', 'lastname1', 'email1', 'icq1', 'phone11', 'phone21', 'institution1', 'department1', 'address1', 'city1', 'c1', 'lang1', 1, 1, 1, 1, 1, 'lastIP1', 'secret1', 1, 'url1', 'description1', 1, 1, 1, 1);
-insert into prefix_user ( confirmed, deleted, username, password, idnumber, firstname, lastname, email, icq, phone1, phone2, institution, department, address, city, country, lang, timezone, firstaccess, lastaccess, lastlogin, currentlogin, lastIP, secret, picture, url, description, mailformat, maildisplay, htmleditor, timemodified )
-values ( 2, 2, 'username2', 'password2', 'idnumber2', 'firstname2', 'lastname2', 'email2', 'icq2', 'phone12', 'phone22', 'institution2', 'department2', 'address2', 'city2', 'c2', 'lang2', 2, 2, 2, 2, 2, 'lastIP2', 'secret2', 2, 'url2', 'description2', 2, 2, 2, 2);
-insert into prefix_user ( confirmed, deleted, username, password, idnumber, firstname, lastname, email, icq, phone1, phone2, institution, department, address, city, country, lang, timezone, firstaccess, lastaccess, lastlogin, currentlogin, lastIP, secret, picture, url, description, mailformat, maildisplay, htmleditor, timemodified ) values ( 3, 3, 'username3', 'password3', 'idnumber3', 'firstname3', 'lastname3', 'email3', 'icq3', 'phone13', 'phone23', 'institution3', 'department3', 'address3', 'city3', 'c3', 'lang3', 3, 3, 3, 3, 3, 'lastIP3', 'secret3', 3, 'url3', 'description3', 3, 3, 3, 3);
-
-rem test unique constraint on username: this statement should fail
-insert into prefix_user ( confirmed, deleted, username, password, idnumber, firstname, lastname, email, icq, phone1, phone2, institution, department, address, city, country, lang, timezone, firstaccess, lastaccess, lastlogin, currentlogin, lastIP, secret, picture, url, description, mailformat, maildisplay, htmleditor, timemodified ) values ( 4, 4, 'username1', 'password4', 'idnumber4', 'firstname4', 'lastname4', 'email4', 'icq4', 'phone14', 'phone24', 'institution4', 'department4', 'address4', 'city4', 'c4', 'lang4', 4, 4, 4, 4, 4, 'lastIP4', 'secret4', 4, 'url4', 'description4', 4, 4, 4, 4);
-
-select
-substr(id,1,4) id,
-substr(confirmed,1,4) confirmed,
-substr(deleted,1,4) deleted,
-substr(username,1,10) username,
-substr(password,1,8) password,
-substr(idnumber,1,4) idnumber,
-substr(firstname,1,8) firstname,
-substr(lastname,1,8) lastname,
-substr(email,1,8) email,
-substr(icq,1,8) icq,
-substr(phone1,1,8) phone1,
-substr(phone2,1,8) phone2,
-substr(institution,1,8) institution,
-substr(department,1,8) department,
-substr(address,1,8) address,
-substr(city,1,8) city,
-substr(country,1,8) country,
-substr(lang,1,8) lang,
-substr(timezone,1,8) timezone,
-substr(firstaccess,1,8) firstaccess,
-substr(lastaccess,1,8) lastaccess,
-substr(lastlogin,1,8) lastlogin,
-substr(currentlogin,1,8) currentlogin,
-substr(lastIP,1,8) lastIP,
-substr(secret,1,8) secret,
-substr(picture,1,8) picture,
-substr(url,1,10) url,
-substr(description,1,10) description,
-mailformat,
-maildisplay,
-htmleditor,
-substr(timemodified,1,4) timemodified
- from prefix_user
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table user_admins
-rem
-
-drop TABLE prefix_user_admins;
-CREATE TABLE prefix_user_admins (
- id number(10) primary key,
- userid number(10) default '0' not null
-);
-
-COMMENT on table prefix_user_admins is 'One record per administrator user';
-
-drop sequence p_user_admins_seq;
-create sequence p_user_admins_seq;
-
-create or replace trigger p_user_admins_trig
- before insert on prefix_user_admins
- referencing new as new_row
- for each row
- begin
- select p_user_admins_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_user_admins (userid) values (1);
-insert into prefix_user_admins (userid) values (2);
-insert into prefix_user_admins (userid) values (3);
-insert into prefix_user_admins (userid) values (4);
-
-select *
- from prefix_user_admins
-/
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table user_students
-rem
-
-drop TABLE prefix_user_students;
-CREATE TABLE prefix_user_students (
- id number(10) primary key,
- userid number(10) default '0' not null,
- course number(10) default '0' not null,
- timestart number(10) default '0' not null,
- timeend number(10) default '0' not null,
- time number(10) default '0' not null
-);
-
-drop sequence p_user_students_seq;
-create sequence p_user_students_seq;
-
-create or replace trigger p_user_students_trig
- before insert on prefix_user_students
- referencing new as new_row
- for each row
- begin
- select p_user_students_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_user_students (userid,course,timestart,timeend,time) values (1,1,1,1,1);
-insert into prefix_user_students (userid,course,timestart,timeend,time) values (2,2,2,2,2);
-insert into prefix_user_students (userid,course,timestart,timeend,time) values (3,3,3,3,3);
-insert into prefix_user_students (userid,course,timestart,timeend,time) values (4,4,4,4,4);
-
-select *
- from prefix_user_students
-/
-
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table user_teachers
-rem
-
-drop TABLE prefix_user_teachers;
-CREATE TABLE prefix_user_teachers (
- id number(10) primary key,
- userid number(10) default '0' not null,
- course number(10) default '0' not null,
- authority number(10) default '3' not null,
- role varchar2(40) default '' not null
-);
-
-COMMENT on table prefix_user_teachers is 'One record per teacher per course';
-
-drop sequence p_user_teachers_seq;
-create sequence p_user_teachers_seq;
-
-create or replace trigger p_user_teachers_trig
- before insert on prefix_user_teachers
- referencing new as new_row
- for each row
- begin
- select p_user_teachers_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_user_teachers (userid,course,authority,role) values (1,1,1,'role1');
-insert into prefix_user_teachers (userid,course,authority,role) values (2,2,2,'role2');
-insert into prefix_user_teachers (userid,course,authority,role) values (3,3,3,'role3');
-insert into prefix_user_teachers (userid,course,authority,role) values (3,3,3,'role3');
-
-select *
- from prefix_user_teachers
-/
-
-rem
-rem Table structure for table user_admins
-rem
-
-drop TABLE prefix_user_coursecreators;
-CREATE TABLE prefix_user_coursecreators (
- id number(10) primary key,
- userid number(10) default '0' not null
-);
-
-COMMENT on table prefix_user_coursecreators is 'One record per course creator';
-drop sequence p_user_coursecreators_seq;
-create sequence p_user_coursecreators_seq;
-
-create or replace trigger p_user_coursecreators_trig
- before insert on prefix_user_coursecreators
- referencing new as new_row
- for each row
- begin
- select p_user_coursecreators_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_user_coursecreators (userid) values (1);
-insert into prefix_user_coursecreators (userid) values (2);
-insert into prefix_user_coursecreators (userid) values (3);
-insert into prefix_user_coursecreators (userid) values (4);
-
-select *
- from prefix_user_coursecreators
-/
-rem --------------------------------------------------------
-
-INSERT INTO prefix_log_display VALUES ('user', 'view', 'user', 'firstname'||' '||'lastname');
-INSERT INTO prefix_log_display VALUES ('course', 'view', 'course', 'fullname');
-INSERT INTO prefix_log_display VALUES ('course', 'update', 'course', 'fullname');
-INSERT INTO prefix_log_display VALUES ('course', 'enrol', 'course', 'fullname');
-INSERT INTO prefix_log_display VALUES ('course', 'update', 'course', 'fullname');
-
-select substr(module,1,20) module,
- substr(action,1,20) action,
- substr(mtable,1,20) mtable,
- substr(field,1,20) field
- from prefix_log_display
-/
-spool off
diff --git a/mod/quiz/db/oci8po.sql b/mod/quiz/db/oci8po.sql
deleted file mode 100755
index 6c5d83d8b4..0000000000
--- a/mod/quiz/db/oci8po.sql
+++ /dev/null
@@ -1,548 +0,0 @@
-rem
-rem Oracle - draft draft draft untested untested untested
-rem
-
-set echo on pagesize 60
-spool t.lst
-
-rem
-rem Table structure for table quiz
-rem
-
-drop table prefix_quiz;
-CREATE TABLE prefix_quiz (
- id number(10) primary key,
- course number(10) default '0' not null,
- name varchar2(255) default '' not null,
- intro varchar2(255) NOT NULL,
- timeopen number(10) default '0' not null,
- timeclose number(10) default '0' not null,
- attempts number(6) default '0' not null,
- feedback number(4) default '0' not null,
- correctanswers number(4) default '1' not null,
- grademethod number(4) default '1' not null,
- review number(4) default '0' not null,
- questions varchar2(255) NOT NULL,
- sumgrades number(10) default '0' not null,
- grade number(10) default '0' not null,
- timecreated number(10) default '0' not null,
- timemodified number(10) default '0' not null
-);
-
-comment on table prefix_quiz is 'Main information about each quiz';
-
-drop sequence pqs;
-create sequence pqs;
-
-create or replace trigger pqt
- before insert on prefix_quiz
- referencing new as new_row
- for each row
- begin
- select pqs.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_quiz (course,name,intro,questions) values
- (101,'Fundamentals of Testing','Test intro','question 1, question 2');
-
-insert into prefix_quiz (course,name,intro,questions) values
- (102,'Fundamentals of Testing 2','Test intro','question 3, question 4');
-
-insert into prefix_quiz (course,name,intro,questions) values
- (101,'Fundamentals of Testing','Test intro','question 1, question 2');
-
-insert into prefix_quiz (course,name,intro,questions) values
- (102,'Fundamentals of Testing 2','Test intro','question 3, question 4');
-
-select id,course,substr(name,1,20) name,
- substr(intro,1,12) intro,
- substr(questions,1,22) questions
- from prefix_quiz order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_answers
-rem
-
-drop TABLE prefix_quiz_answers;
-CREATE TABLE prefix_quiz_answers (
- id number(10) NOT NULL PRIMARY KEY,
- question number(10) default '0' not null,
- answer varchar(255) default '' not null,
- fraction varchar(10) default '0.0',
- feedback varchar2(255) NOT NULL
-);
-
-COMMENT on table prefix_quiz_answers is 'Answers, with a fractional grade (0-1) and feedback';
-
-drop sequence pqas;
-create sequence pqas;
-
-create or replace trigger pqat
- before insert on prefix_quiz_answers
- referencing new as new_row
- for each row
- begin
- select pqas.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_quiz_answers (question,answer,fraction,feedback) values
- (1,'Answer #1','fraction1','feedback1');
-
-insert into prefix_quiz_answers (question,answer,fraction,feedback) values
- (13,'Answer #13','fraction13','feedback13');
-
-insert into prefix_quiz_answers (question,answer,fraction,feedback) values
- (31,'Answer #31','fraction31','feedback31');
-
-insert into prefix_quiz_answers (question,answer,fraction,feedback) values
- (3,'Answer #3','fraction3','feedback3');
-
-select id,substr(question,1,12),
- substr(answer,1,12),
- substr(fraction,1,12),
- substr(feedback,1,12)
- from prefix_quiz_answers
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_attempts
-rem
-
-drop table prefix_quiz_attempts;
-CREATE TABLE prefix_quiz_attempts (
- id number(10) primary key,
- quiz number(10) default '0' not null,
- userid number(10) default '0' not null,
- attempt number(6) default '0' not null,
- sumgrades varchar(10) default '0.0' not null,
- timestart number(10) default '0' not null,
- timefinish number(10) default '0' not null,
- timemodified number(10) default '0' not null
-);
-
-COMMENT on table prefix_quiz_attempts is 'Stores various attempts on a quiz';
-
-drop sequence pq_attempts_seq;
-create sequence pq_attempts_seq;
-
-create or replace trigger pq_attempts_trig
- before insert on prefix_quiz_attempts
- referencing new as new_row
- for each row
- begin
- select pq_attempts_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-
-insert into prefix_quiz_attempts (
- quiz,userid,attempt,sumgrades,timestart,timefinish,timemodified)
-values (1,1,1,'sumgrades',1400,1405,1404);
-
-select
- id,
- quiz,
- userid,
- attempt,
- substr(sumgrades,1,12) sumgrades,
- timestart,
- timefinish,
- timemodified
- from prefix_quiz_attempts
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_categories
-rem
-
-drop table prefix_quiz_categories;
-CREATE TABLE prefix_quiz_categories (
- id number(10) primary key,
- course number(10) default '0' not null,
- name varchar(255) default '' not null,
- info varchar2(255) not null,
- publish number(4) default '0' not null
-);
-
-COMMENT on table prefix_quiz_categories is 'Categories are for grouping questions';
-
-drop sequence pq_categories_seq;
-create sequence pq_categories_seq;
-
-create or replace trigger pq_categories_trig
- before insert on prefix_quiz_categories
- referencing new as new_row
- for each row
- begin
- select pq_categories_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_categories (course,name,info,publish) values (1,1,1,1);
-insert into prefix_quiz_categories (course,name,info,publish) values (2,2,2,2);
-insert into prefix_quiz_categories (course,name,info,publish) values (3,3,3,3);
-insert into prefix_quiz_categories (course,name,info,publish) values (4,4,4,4);
-
-select id,
- substr(course,1,4) course,
- substr(name,1,4) name,
- substr(info,1,4) info,
- substr(publish,1,4) publish
- from prefix_quiz_categories
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_grades
-rem
-
-drop TABLE prefix_quiz_grades;
-CREATE TABLE prefix_quiz_grades (
- id number(10) NOT NULL ,
- quiz number(10) default '0' not null,
- userid number(10) default '0' not null,
- grade varchar(10) default '0.0' not null,
- timemodified number(10) default '0' not null
-);
-
-COMMENT on table prefix_quiz_grades is 'Final quiz grade (may be best of several attempts)';
-
-drop sequence pq_grades_seq;
-create sequence pq_grades_seq;
-
-create or replace trigger pq_grades_trig
- before insert on prefix_quiz_grades
- referencing new as new_row
- for each row
- begin
- select pq_grades_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_grades (quiz,userid,grade,timemodified) values (1,1,1,1);
-insert into prefix_quiz_grades (quiz,userid,grade,timemodified) values (2,2,2,2);
-insert into prefix_quiz_grades (quiz,userid,grade,timemodified) values (3,3,3,3);
-insert into prefix_quiz_grades (quiz,userid,grade,timemodified) values (4,4,4,4);
-
-select id,
- substr(quiz,1,4) quiz,
- substr(userid,1,4) userid,
- substr(grade,1,4) grade,
- substr(timemodified,1,4) timemodified
- from prefix_quiz_grades
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_multichoice
-rem
-
-drop TABLE prefix_quiz_multichoice;
-CREATE TABLE prefix_quiz_multichoice (
- id number(10) primary key,
- question number(10) default '0' not null,
- layout number(4) default '0' not null,
- answers varchar(255) default '' not null,
- single number(4) default '0' not null
-);
-
-COMMENT on table prefix_quiz_multichoice is 'Options for multiple choice questions';
-
-drop sequence pq_multichoice_seq;
-create sequence pq_multichoice_seq;
-
-create or replace trigger pq_multichoice_trig
- before insert on prefix_quiz_multichoice
- referencing new as new_row
- for each row
- begin
- select pq_multichoice_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_multichoice (question,layout,answers,single) values (1,1,1,1);
-insert into prefix_quiz_multichoice (question,layout,answers,single) values (2,2,2,2);
-insert into prefix_quiz_multichoice (question,layout,answers,single) values (3,3,3,3);
-insert into prefix_quiz_multichoice (question,layout,answers,single) values (4,4,4,4);
-
-select id,
- substr(question,1,4) question,
- substr(layout,1,4) layout,
- substr(answers,1,4) answers,
- substr(single,1,4) single
- from prefix_quiz_multichoice
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_question_grades
-rem
-
-drop TABLE prefix_quiz_question_grades;
-CREATE TABLE prefix_quiz_question_grades (
- id number(10) NOT NULL ,
- quiz number(10) default '0',
- question number(10) default '0',
- grade number(6) default '0'
-);
-
-COMMENT on table prefix_quiz_question_grades is 'The grade for a question in a quiz';
-
-drop sequence pq_question_grades_seq;
-create sequence pq_question_grades_seq;
-
-create or replace trigger pq_question_grades_trig
- before insert on prefix_quiz_question_grades
- referencing new as new_row
- for each row
- begin
- select pq_question_grades_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_question_grades (quiz,question,grade) values (1,1,1);
-insert into prefix_quiz_question_grades (quiz,question,grade) values (2,2,2);
-insert into prefix_quiz_question_grades (quiz,question,grade) values (3,3,3);
-insert into prefix_quiz_question_grades (quiz,question,grade) values (4,4,4);
-
-select id,
- substr(quiz,1,4) quiz,
- substr(question,1,4) question,
- substr(grade,1,4) grade
- from prefix_quiz_question_grades
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_randommatch
-rem
-
-drop TABLE prefix_quiz_randommatch;
-CREATE TABLE prefix_quiz_randommatch (
- id number(10) primary key,
- question number(10) default '0' not null,
- choose INT DEFAULT '4' NOT NULL
-);
-
-COMMENT on table prefix_quiz_randommatch is 'Info about a random matching question';
-
-drop sequence pq_randommatch_seq;
-create sequence pq_randommatch_seq;
-
-create or replace trigger pq_randommatch_trig
- before insert on prefix_quiz_randommatch
- referencing new as new_row
- for each row
- begin
- select pq_randommatch_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_randommatch (question,choose) values (1,1);
-insert into prefix_quiz_randommatch (question,choose) values (2,2);
-insert into prefix_quiz_randommatch (question,choose) values (3,3);
-insert into prefix_quiz_randommatch (question,choose) values (4,4);
-
-select id,
- substr(question,1,4) question,
- substr(choose,1,4) choose
- from prefix_quiz_randommatch
- order by 1,2;
-
-rem
-rem Table structure for table quiz_questions
-rem
-
-drop TABLE prefix_quiz_questions;
-CREATE TABLE prefix_quiz_questions (
- id number(10) primary key,
- category number(10) default '0' not null,
- name varchar(255) default '' not null,
- questiontext varchar2(255) NOT NULL,
- image varchar(255) default '' not null,
- qtype number(6) default '0' not null
-);
-
-COMMENT on table prefix_quiz_questions is 'The quiz questions themselves';
-
-drop sequence pq_questions_seq;
-create sequence pq_questions_seq;
-
-create or replace trigger pq_questions_trig
- before insert on prefix_quiz_questions
- referencing new as new_row
- for each row
- begin
- select pq_questions_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_questions (category,name,questiontext,image,qtype) values (1,'name1','questiontext1','image1',1);
-insert into prefix_quiz_questions (category,name,questiontext,image,qtype) values (2,'name2','questiontext2','image2',2);
-insert into prefix_quiz_questions (category,name,questiontext,image,qtype) values (3,'name3','questiontext3','image3',3);
-insert into prefix_quiz_questions (category,name,questiontext,image,qtype) values (4,'name4','questiontext4','image4',4);
-
-select id,
- substr(category,1,4) category,
- substr(name,1,4) name,
- substr(questiontext,1,4) questiontext,
- substr(image,1,4) image,
- substr(qtype,1,4) qtype
- from prefix_quiz_questions
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_responses
-rem
-
-drop TABLE prefix_quiz_responses;
-CREATE TABLE prefix_quiz_responses (
- id number(10) primary key,
- attempt number(10) default '0' not null,
- question number(10) default '0' not null,
- answer varchar(255) default '' not null,
- grade varchar(10) default '0.0' not null
-);
-
-COMMENT on table prefix_quiz_questions is 'Stores user responses to a quiz, and percentage grades';
-
-drop sequence pq_responses_seq;
-create sequence pq_responses_seq;
-
-create or replace trigger pq_responses_trig
- before insert on prefix_quiz_responses
- referencing new as new_row
- for each row
- begin
- select pq_responses_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_responses (attempt,question,answer,grade)
-values (1,1,'answer1','grade1');
-insert into prefix_quiz_responses (attempt,question,answer,grade)
-values (2,2,'answer2','grade2');
-insert into prefix_quiz_responses (attempt,question,answer,grade)
-values (3,3,'answer3','grade3');
-insert into prefix_quiz_responses (attempt,question,answer,grade)
-values (4,4,'answer4','grade4');
-
-select id,
- substr(attempt,1,4) attempt,
- substr(question,1,14) question,
- substr(answer,1,14) answer,
- substr(grade,1,14) grade
- from prefix_quiz_responses
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_shortanswer
-rem
-
-drop TABLE prefix_quiz_shortanswer;
-CREATE TABLE prefix_quiz_shortanswer (
- id number(10) primary key,
- question number(10) default '0' not null,
- answers varchar(255) default '' not null,
- usecase number(2) default '0' not null
-);
-
-COMMENT on table prefix_quiz_shortanswer is 'Options for short answer questions';
-
-drop sequence pq_shortanswer_seq;
-create sequence pq_shortanswer_seq;
-
-create or replace trigger pq_shortanswer_trig
- before insert on prefix_quiz_shortanswer
- referencing new as new_row
- for each row
- begin
- select pq_shortanswer_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_shortanswer (question,answers,usecase) values (1,'answer1',1);
-insert into prefix_quiz_shortanswer (question,answers,usecase) values (2,'answer2',2);
-insert into prefix_quiz_shortanswer (question,answers,usecase) values (3,'answer3',3);
-insert into prefix_quiz_shortanswer (question,answers,usecase) values (4,'answer4',4);
-
-select id,
- substr(question,1,14) question,
- substr(answers,1,14) answers,
- substr(usecase,1,14) usecase
- from prefix_quiz_shortanswer
- order by 1,2;
-
-rem --------------------------------------------------------
-
-rem
-rem Table structure for table quiz_truefalse
-rem
-
-drop TABLE prefix_quiz_truefalse;
-CREATE TABLE prefix_quiz_truefalse (
- id number(10) primary key,
- question number(10) default '0' not null,
- trueanswer number(10) default '0' not null,
- falseanswer number(10) default '0' not null
-);
-
-COMMENT on table prefix_quiz_truefalse is 'Options for True-False questions';
-
-
-drop sequence pq_truefalse_seq;
-create sequence pq_truefalse_seq;
-
-create or replace trigger pq_truefalse_trig
- before insert on prefix_quiz_truefalse
- referencing new as new_row
- for each row
- begin
- select pq_truefalse_seq.nextval into :new_row.id from dual;
- end;
-.
-/
-insert into prefix_quiz_truefalse (question,trueanswer,falseanswer) values (1,1,1);
-insert into prefix_quiz_truefalse (question,trueanswer,falseanswer) values (2,2,2);
-insert into prefix_quiz_truefalse (question,trueanswer,falseanswer) values (3,3,3);
-insert into prefix_quiz_truefalse (question,trueanswer,falseanswer) values (4,4,4);
-
-select id,
- substr(question,1,14) question,
- substr(trueanswer,1,14) trueanswer,
- substr(falseanswer,1,14) falseanswer
- from prefix_quiz_truefalse
- order by 1,2;
-
-select
- substr(table_name,1,28) table_name,
- substr(comments,1,54) comments
- from all_tab_comments
- where owner = 'SCOTT'
- and table_name like 'PREFIX%'
-/
-
-INSERT INTO prefix_log_display VALUES ('quiz', 'view', 'quiz', 'name');
-INSERT INTO prefix_log_display VALUES ('quiz', 'report', 'quiz', 'name');
-INSERT INTO prefix_log_display VALUES ('quiz', 'attempt', 'quiz', 'name');
-INSERT INTO prefix_log_display VALUES ('quiz', 'submit', 'quiz', 'name');
-
-spool off
--
2.39.5