media-upload

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 7a21eab..86bd687 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -75,6 +75,14 @@ CREATE SEQUENCE "breaking_id_seq" start 1 increment 1 maxvalue 2147483647 minval
 CREATE SEQUENCE "messages_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
 
 --
+-- TOC Entry ID 10 (OID 28866)
+--
+-- Name: media_type_id_seq Type: SEQUENCE Owner: postgres
+--
+
+CREATE SEQUENCE "media_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
+
+--
 -- TOC Entry ID 12 (OID 28885)
 --
 -- Name: media_folder Type: TABLE Owner: postgres
@@ -98,7 +106,7 @@ CREATE TABLE "media_folder" (
 --
 
 CREATE TABLE "media_type" (
-       "id" smallint NOT NULL,
+       "id" integer DEFAULT nextval('media_type_id_seq'::text) NOT NULL,
        "name" character varying(80) NOT NULL,
        "mime_type" character varying(40) NOT NULL,
        "classname" character varying(80) NOT NULL,