From: mh Date: Tue, 2 Apr 2002 23:40:47 +0000 (+0000) Subject: reverse change from 2 minutes ago. X-Git-Tag: prexmlproducerconfig~145 X-Git-Url: http://erislabs.net/gitweb/?p=mir.git;a=commitdiff_plain;h=52db109f0c07ae5afa4e2c4c82406229e1353dd6 reverse change from 2 minutes ago. --- diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql index 160c7f21..4ca9fd6c 100755 --- a/dbscripts/populate_mediatyp.sql +++ b/dbscripts/populate_mediatyp.sql @@ -15,9 +15,9 @@ UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type'; INSERT INTO "media_type" VALUES (4,'mp3','audio/mp3','Mp3','Audio',NULL); INSERT INTO "media_type" VALUES (13,'mp3','audio/x-mp3','Mp3','Audio',NULL); INSERT INTO "media_type" VALUES (14,'mp3','audio/x-mpeg','Mp3','Audio',NULL); -INSERT INTO "media_type" VALUES (10,'ram','audio/vnd.rn-realaudio','RealAudio','Audio',NULL); -INSERT INTO "media_type" VALUES (12,'ram','audio/x-pn-realaudio','RealAudio','Audio',NULL); -INSERT INTO "media_type" VALUES (11,'ram','video/vnd.rn-realvideo','RealVideo','Video',NULL); +INSERT INTO "media_type" VALUES (10,'ra','audio/vnd.rn-realaudio','RealAudio','Audio',NULL); +INSERT INTO "media_type" VALUES (12,'ra','audio/x-pn-realaudio','RealAudio','Audio',NULL); +INSERT INTO "media_type" VALUES (11,'rm','video/vnd.rn-realvideo','RealVideo','Video',NULL); INSERT INTO "media_type" VALUES (8,'mov','video/quicktime','Video','Video',NULL); INSERT INTO "media_type" VALUES (7,'mpg','video/mpeg','Video','Video',NULL); INSERT INTO "media_type" VALUES (9,'avi','video/x-msvideo','Video','Video',NULL); @@ -26,7 +26,7 @@ INSERT INTO "media_type" VALUES (15,'png','image/*','Images','Images',NULL); INSERT INTO "media_type" VALUES (3,'jpg','- deprecated -','Images','Images',NULL); INSERT INTO "media_type" VALUES (5,'jpg','- deprecated -','Images','Images',NULL); INSERT INTO "media_type" VALUES (16,'asf','video/x-ms-asf','Video','Video',NULL); -INSERT INTO "media_type" VALUES (17,'ram','application/vnd.rn-realmedia','RealVideo','Video',NULL); +INSERT INTO "media_type" VALUES (17,'rm','application/vnd.rn-realmedia','RealVideo','Video',NULL); INSERT INTO "media_type" VALUES (18,'mp3','audio/mpeg','Mp3','Audio',NULL); -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';