From c7dbc101c5a3b87768cededc5938b98c4ebfcd4d Mon Sep 17 00:00:00 2001 From: zapata Date: Thu, 3 Oct 2002 21:36:59 +0000 Subject: [PATCH] changed the article types import script to have names that can be used from inside templates / producers.xml --- dbscripts/help_arttype.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/dbscripts/help_arttype.sql b/dbscripts/help_arttype.sql index a58ed98b..02fd99d2 100755 --- a/dbscripts/help_arttype.sql +++ b/dbscripts/help_arttype.sql @@ -1,10 +1,10 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; -- \connect - postgres -INSERT INTO "article_type" VALUES (0,'OpenPosting'); -INSERT INTO "article_type" VALUES (1,'Newswire'); -INSERT INTO "article_type" VALUES (2,'Feature'); -INSERT INTO "article_type" VALUES (3,'Spezial (Topicpage)'); -INSERT INTO "article_type" VALUES (4,'Spezial (Startpage)'); +INSERT INTO "article_type" VALUES (0,'openposting'); +INSERT INTO "article_type" VALUES (1,'newswire'); +INSERT INTO "article_type" VALUES (2,'feature'); +INSERT INTO "article_type" VALUES (3,'topicspecial'); +INSERT INTO "article_type" VALUES (4,'startspecial'); BEGIN TRANSACTION; CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint); INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND C."relname" !~ '^pg_' GROUP BY 1; -- 2.11.0