From 98d245839bdacc3190353c448ce84687a80e67ab Mon Sep 17 00:00:00 2001
From: idfx <idfx>
Date: Mon, 24 Sep 2001 11:38:33 +0000
Subject: [PATCH] media-upload

---
 dbscripts/create_pg.sql | 62 +++++++++++++++++++++++--------------------------
 1 file changed, 29 insertions(+), 33 deletions(-)

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 3c771b5b..7a21eabd 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -100,6 +100,7 @@ CREATE TABLE "media_folder" (
 CREATE TABLE "media_type" (
 	"id" smallint NOT NULL,
 	"name" character varying(80) NOT NULL,
+	"mime_type" character varying(40) NOT NULL,
 	"classname" character varying(80) NOT NULL,
 	"tablename" character varying(80) NOT NULL,
 	"dcname" character varying(20)
@@ -398,62 +399,57 @@ CREATE TABLE "messages" (
 --
 -- TOC Entry ID 32 (OID 29446)
 --
--- Name: videos Type: TABLE Owner: postgres
+-- Name: uploaded_media Type: TABLE Owner: postgres
 --
 
-CREATE TABLE "videos" (
-	"video_data" oid,
-	"to_video_type" smallint DEFAULT '0' NOT NULL
-)
-INHERITS ("media");
+CREATE TABLE "uploaded_media" (
+ 
+) INHERITS ("media");
 
 --
--- TOC Entry ID 11 (OID 29781)
+-- TOC Entry ID 33 (OID 30026)
 --
--- Name: links_imc_id_seq Type: SEQUENCE Owner: postgres
+-- Name: comment_status Type: TABLE Owner: postgres
 --
 
-CREATE SEQUENCE "links_imc_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
+CREATE TABLE "comment_status" (
+	"id" smallint NOT NULL,
+	"name" character varying(40) NOT NULL
+);
 
 --
--- TOC Entry ID 33 (OID 29987)
+-- TOC Entry ID 34 (OID 30064)
 --
--- Name: links_imc Type: TABLE Owner: postgres
+-- Name: content_x_media Type: TABLE Owner: postgres
 --
 
-CREATE TABLE "links_imc" (
-	"id" integer DEFAULT nextval('links_imc_id_seq'::text) NOT NULL,
-	"parent_id" integer DEFAULT '0',
-	"title" character varying(80) NOT NULL,
-	"description" text,
-	"filename" character varying(20) NOT NULL,
-	"main_url" character varying(255),
-	"archiv_url" character varying(255),
-	"sortpriority" integer,
-	"to_language" integer,
-	Constraint "links_imc_pkey" Primary Key ("id")
+CREATE TABLE "content_x_media" (
+	"content_id" integer,
+	"media_id" integer
 );
 
 --
--- TOC Entry ID 34 (OID 30026)
+-- TOC Entry ID 11 (OID 32812)
 --
--- Name: comment_status Type: TABLE Owner: postgres
+-- Name: links_imcs_id_seq Type: SEQUENCE Owner: postgres
 --
 
-CREATE TABLE "comment_status" (
-	"id" smallint NOT NULL,
-	"name" character varying(40) NOT NULL
-);
+CREATE SEQUENCE "links_imcs_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
 
 --
--- TOC Entry ID 35 (OID 30064)
+-- TOC Entry ID 35 (OID 32831)
 --
--- Name: content_x_media Type: TABLE Owner: postgres
+-- Name: links_imcs Type: TABLE Owner: postgres
 --
 
-CREATE TABLE "content_x_media" (
-	"content_id" integer,
-	"media_id" integer
+CREATE TABLE "links_imcs" (
+	"id" integer DEFAULT nextval('links_imcs_id_seq'::text) NOT NULL,
+	"to_parent_id" integer,
+	"title" character varying(80) NOT NULL,
+	"url" character varying(255) NOT NULL,
+	"sortpriority" integer DEFAULT '1',
+	"to_language" integer DEFAULT '0' NOT NULL,
+	Constraint "links_imcs_pkey" Primary Key ("id")
 );
 
 --
-- 
2.11.0