From 15e933ad116084caebff14d18ef87d1c68e959fa Mon Sep 17 00:00:00 2001 From: john Date: Wed, 17 Oct 2001 19:04:53 +0000 Subject: [PATCH] added two types for real audio and video --- dbscripts/populate_mediatyp.sql | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql index 196987b5..74210e3f 100755 --- a/dbscripts/populate_mediatyp.sql +++ b/dbscripts/populate_mediatyp.sql @@ -20,6 +20,13 @@ INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcnam INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (7,'mpg','video/mpeg','Video','UploadedMedia',NULL); INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (8,'mov','video/quicktime','Video','UploadedMedia',NULL); INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (9,'avi','video/x-msvideo','Video','UploadedMedia',NULL); + + + +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (10,'ra','audio/vnd.rn-realaudio','RealAudio','UploadedMedia',NULL); +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (11,'rm','video/vnd.rn-realvideo','RealVideo','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