X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fpopulate_mediatyp.sql;h=abd152ef56313388ceeb744c0344b3af7e5f89e5;hb=740a6ee2966eb223f1a149d8f638f99a65c7ec26;hp=3fd373ac0a4c6524ce9597e3ea00379e21a37cf3;hpb=c3a2c201d92140363c4ec1f59c6457704330270d;p=mir.git

diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql
index 3fd373ac..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 28909)
+-- Data for TOC Entry ID 2 (OID 88609)
 --
 -- Name: media_type Type: TABLE DATA Owner: postgres
 --
@@ -12,15 +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	gif	image/gif	ImagesGif	Images	\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 28890)
+-- TOC Entry ID 1 (OID 88557)
 --
 -- Name: media_type_id_seq Type: SEQUENCE SET Owner: 
 --