From 401a81dddf43e286c6c6e540601bb47d26d637e2 Mon Sep 17 00:00:00 2001 From: les_kopari Date: Wed, 24 Sep 2003 02:06:34 +0000 Subject: [PATCH] Added columns indent, visible to create, inserts. --- lib/db/oci8po.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/lib/db/oci8po.sql b/lib/db/oci8po.sql index b6546fe6e3..8baeecd5c4 100755 --- a/lib/db/oci8po.sql +++ b/lib/db/oci8po.sql @@ -185,6 +185,7 @@ CREATE TABLE prefix_course_modules ( added number(10) default '0' not null, deleted number(1) default '0' not null, score number(4) default '0' not null, + indent number(5) default '0' not null, visible number(1) default '1' not null ); @@ -203,10 +204,10 @@ create or replace trigger p_course_modules_trig . / -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); +insert into prefix_course_modules (course,module,instance,section,added,deleted,score,indent,visible) values (1,1,1,1,1,1,1,1,1); +insert into prefix_course_modules (course,module,instance,section,added,deleted,score,indent,visible) values (2,2,2,2,2,2,2,2,2); +insert into prefix_course_modules (course,module,instance,section,added,deleted,score,indent,visible) values (3,3,3,3,3,3,3,3,3); +insert into prefix_course_modules (course,module,instance,section,added,deleted,score,indent,visible) values (4,4,4,4,4,4,4,4,4); select * from prefix_course_modules; -- 2.39.5