Postgres support is coming!
Up until recently the only people have been using Media Manager have all been operating Movable Type on top of MySQL. But then I got a request to support Postgres. So thanks to SQL::Translator I will soon be supporting postgres in the next release of Media Manager.
Props to Mark for helping with this!
If you can't wait, add the following file (call it postgres.dump) to Media Manager's schemas directory:
--
-- Table: mt_mediamanager
--
CREATE TABLE "mt_mediamanager" (
"mediamanager_id" serial NOT NULL,
"mediamanager_blog_id" smallint NOT NULL,
"mediamanager_entry_id" integer,
"mediamanager_catalog" character varying(50) NOT NULL,
"mediamanager_isbn" text NOT NULL,
"mediamanager_status" character varying(50) NOT NULL,
"mediamanager_title" character varying(150),
"mediamanager_finished_on" timestamp,
"mediamanager_created_on" timestamp NOT NULL,
"mediamanager_created_by" text,
"mediamanager_modified_on" timestamp NOT NULL,
"mediamanager_modified_by" text,
PRIMARY KEY ("mediamanager_id")
);
CREATE INDEX "mediamanager_blog_id" on mt_mediamanager ("mediamanager_blog_id");
CREATE INDEX "mediamanager_created_on" on mt_mediamanager ("mediamanager_created_on");
CREATE INDEX "mediamanager_catalog" on mt_mediamanager ("mediamanager_catalog");
--
-- Table: mt_mediamanager_reviews
--
CREATE TABLE "mt_mediamanager_reviews" (
"mediamanager_reviews_id" serial NOT NULL,
"mediamanager_reviews_entry_id" integer DEFAULT '0' NOT NULL,
"mediamanager_reviews_rating" smallint,
"mediamanager_reviews_layout" character varying(20),
"mediamanager_reviews_image_drop_shadow" character varying(10) DEFAULT 'None',
"mediamanager_reviews_image_rotation" smallint,
"mediamanager_reviews_image_blur" smallint,
"mediamanager_reviews_image_size" character varying(20),
"mediamanager_reviews_image_url" character varying(150),
"mediamanager_reviews_show_buynow" smallint DEFAULT '0',
"mediamanager_reviews_show_price" smallint DEFAULT '0',
"mediamanager_reviews_show_rating" smallint DEFAULT '0',
PRIMARY KEY ("mediamanager_reviews_id")
);
CREATE INDEX "mediamanager_rating" on mt_mediamanager_reviews ("mediamanager_reviews_rating");
