dbscripts/populate_mediatyp.sql

   1 --
   2 -- Selected TOC Entries:
   3 --
   4 --
   5 -- Data for TOC Entry ID 2 (OID 88609)
   6 --
   7 -- Name: media_type Type: TABLE DATA Owner: postgres
   8 --
   9
  10
  11 \connect - postgres
  12 -- Disable triggers
  13 UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type';
  14
  15 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (2,'unknown','application/octet-stream','--','UploadedMedia',NULL);
  16 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (3,'jpg','image/gif','ImagesGif','Images',NULL);
  17 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (4,'mp3','audio/mp3','Audio','UploadedMedia',NULL);
  18 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (5,'jpg','image/jpeg','ImagesJpeg','Images',NULL);
  19 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (6,'pdf','application/pdf','Generic','UploadedMedia',NULL);
  20 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (7,'mpg','video/mpeg','Video','UploadedMedia',NULL);
  21 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (8,'mov','video/quicktime','Video','UploadedMedia',NULL);
  22 INSERT INTO "media_type" ("id","name","mime_type","classname","tablename","dcname") VALUES (9,'avi','video/x-msvideo','Video','UploadedMedia',NULL);
  23 -- Enable triggers
  24
  25 UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';
  26
  27 --
  28 -- TOC Entry ID 1 (OID 88557)
  29 --
  30 -- Name: media_type_id_seq Type: SEQUENCE SET Owner:
  31 --
  32
  33 SELECT setval ('"media_type_id_seq"', 1, 't');
  34