From 760eb8ef60973f387c32c7deae611f26bfa5283e Mon Sep 17 00:00:00 2001 From: mh Date: Tue, 2 Oct 2001 00:53:46 +0000 Subject: [PATCH] fix problem with populate_mediatyp script. --- dbscripts/populate_mediatyp.sql | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql index edb69b51..79a0bb65 100755 --- a/dbscripts/populate_mediatyp.sql +++ b/dbscripts/populate_mediatyp.sql @@ -12,11 +12,9 @@ -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type'; -COPY "media_type" FROM stdin; -2 unknown application/octet-stream -- UploadedMedia \N -3 jpg image/gif ImagesGif Images \N -4 mp3 audio/mp3 Audio UploadedMedia \N -\. +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (2,'unknown','application/octet-stream','--','UploadedMedia',NULL); +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (3,'jpg','image/gif','ImagesGif','Images',NULL); +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (4,'mp3','audio/mp3','Audio','UploadedMedia',NULL); -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type'; -- 2.11.0