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

diff --git a/dbscripts/populate_mediatyp.sql b/dbscripts/populate_mediatyp.sql
index 3fd373ac..cc9bc197 100755
--- a/dbscripts/populate_mediatyp.sql
+++ b/dbscripts/populate_mediatyp.sql
@@ -2,28 +2,29 @@
 -- Selected TOC Entries:
 --
 --
--- Data for TOC Entry ID 2 (OID 28909)
+-- Data for TOC Entry ID 2 (OID 46975)
 --
 -- Name: media_type Type: TABLE DATA Owner: postgres
 --
 
 
-\connect - postgres
--- 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
-\.
--- 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)
---
--- Name: media_type_id_seq Type: SEQUENCE SET Owner: 
---
-
-SELECT setval ('"media_type_id_seq"', 1, 't');
+-- \connect - de_indy
 
+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,'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);
+INSERT INTO "media_type" VALUES (6,'pdf','application/pdf','Generic','Other',NULL);
+INSERT INTO "media_type" VALUES (15,'png','image/png','ImagesPng','Images',NULL);
+INSERT INTO "media_type" VALUES (3,'jpg','- deprecated -','Images','Images',NULL);
+INSERT INTO "media_type" VALUES (5,'jpg','image/*','ImagesJpeg','Images',NULL);
+INSERT INTO "media_type" VALUES (16,'asf','video/x-ms-asf','Video','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);
+INSERT INTO "media_type" VALUES (19,'png','image/gif','ImagesPng','Images',NULL);
+INSERT INTO "media_type" VALUES (20,'avi','video/avi','Video','Video',NULL);