Index: openacs-4/packages/glossary/sql/postgresql/glossary-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/glossary/sql/postgresql/glossary-drop.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/glossary/sql/postgresql/glossary-drop.sql 31 Oct 2001 20:46:59 -0000 1.1 +++ openacs-4/packages/glossary/sql/postgresql/glossary-drop.sql 18 Dec 2001 02:54:09 -0000 1.2 @@ -1,6 +1,7 @@ -- packages/glossary/sql/glossary-drop.sql -- @author Walter McGinnis (walter@arsdigita.com) +-- @author Bart Teeuwisse (bart.teeuwisse@7-sisters.com) -- @creation-date 2000-10-03 -- @cvs-id $ID:$ @@ -15,7 +16,7 @@ select content_folder__unregister_content_type(-100, 'glossary_term', 't'); select content_folder__unregister_content_type(-100, 'glossary', 't'); -drop function glossary__new(integer, varchar, varchar, varchar, integer, integer, varchar, integer, boolean); +drop function glossary__new(integer, varchar, varchar, varchar, integer, integer, varchar, integer, boolean); -- drop all grantings of privleges -- and then drop privileges on glossaries @@ -55,6 +56,8 @@ -- delete all glosary_term objects +drop function glossary_term__new (varchar, varchar, varchar, integer, integer, varchar, integer, varchar); + -- we must clear out our term objects, -- otherwise there will be foreign key constraint problems -- hopedully the 'on delete cascade' in glossary_terms.term_id @@ -99,7 +102,6 @@ select inline_0(); drop function inline_0(); - -- dropping the attributes for glossaries select content_type__drop_type('glossary', 'f', 'f');