From 224d5b587b6d2fe80be02b71a15b5da3c27e9b9a Mon Sep 17 00:00:00 2001 From: idfx Date: Mon, 24 Sep 2001 11:48:54 +0000 Subject: [PATCH] media-upload --- dbscripts/create_pg.sql | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql index 7a21eabd..86bd6874 100755 --- 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, -- 2.11.0