From 99d83573a155d6b0cc0b842cef2999aa9903ac3c Mon Sep 17 00:00:00 2001 From: les_kopari Date: Tue, 30 Sep 2003 04:00:18 +0000 Subject: [PATCH] Test inserts updated for new column. --- mod/glossary/db/oci8po.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/mod/glossary/db/oci8po.sql b/mod/glossary/db/oci8po.sql index e9cb55bb3c..231af02231 100755 --- a/mod/glossary/db/oci8po.sql +++ b/mod/glossary/db/oci8po.sql @@ -80,10 +80,10 @@ create or replace trigger p_glossary_entries_trig . / -insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry) values(1,1,'1','1',1,'1',1,1,1); -insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry) values(2,2,'2','2',2,'2',2,2,2); -insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry) values(3,3,'3','3',3,'3',3,3,3); -insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry) values(4,4,'4','4',4,'4',4,4,4); +insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry,sourceglossaryid) values(1,1,'1','1',1,'1',1,1,1,1); +insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry,sourceglossaryid) values(2,2,'2','2',2,'2',2,2,2,2); +insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry,sourceglossaryid) values(3,3,'3','3',3,'3',3,3,3,3); +insert into prefix_glossary_entries(glossaryid,userid,concept,definition,format,attachment,timecreated,timemodified,teacherentry,sourceglossaryid) values(4,4,'4','4',4,'4',4,4,4,4); col format format 99 select * from prefix_glossary_entries order by 1,2; -- 2.39.5