X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fpopulate_mediatyp.sql;h=abd152ef56313388ceeb744c0344b3af7e5f89e5;hb=740a6ee2966eb223f1a149d8f638f99a65c7ec26;hp=d7724a78f42b6cef24d6126b4f6731d2e43ba187;hpb=986ca960959af906d6b639d13ae50353b6c74dc5;p=mir.git diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql index d7724a78..abd152ef 100755 --- a/dbscripts/populate_mediatyp.sql +++ b/dbscripts/populate_mediatyp.sql @@ -2,7 +2,7 @@ -- Selected TOC Entries: -- -- --- Data for TOC Entry ID 2 (OID 54758) +-- Data for TOC Entry ID 2 (OID 88609) -- -- Name: media_type Type: TABLE DATA Owner: postgres -- @@ -12,16 +12,15 @@ -- 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 Generic 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); +INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (5,'jpg','image/jpeg','ImagesJpeg','Images',NULL); -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type'; -- --- TOC Entry ID 1 (OID 54706) +-- TOC Entry ID 1 (OID 88557) -- -- Name: media_type_id_seq Type: SEQUENCE SET Owner: --