Topic on Extension talk:TimedMediaHandler

Doesn't work with PostgreSQL Backend

2
192.119.205.244 (talkcontribs)

Needed to modify the database table creation as follows:

CREATE TABLE /*_*/transcode (

        transcode_id SERIAL PRIMARY KEY,

        transcode_image_name VARCHAR(255) NOT NULL,

        transcode_key VARCHAR(48) NOT NULL,

        transcode_error TEXT NOT NULL,

        transcode_time_addjob VARCHAR(14) NULL,

        transcode_time_startwork VARCHAR(14) NULL,

        transcode_time_success VARCHAR(14) NULL,

        transcode_time_error VARCHAR(14) NULL,

        transcode_final_bitrate INT NOT NULL

);

192.119.205.244 (talkcontribs)

Should actually be

CREATE TABLE /*_*/transcode (

        transcode_id SERIAL PRIMARY KEY,

        transcode_image_name VARCHAR(255) NOT NULL,

        transcode_key VARCHAR(255) NOT NULL,

        transcode_error TEXT NOT NULL,

        transcode_time_addjob VARCHAR(255) NULL,

        transcode_time_startwork VARCHAR(255) NULL,

        transcode_time_success VARCHAR(255) NULL,

        transcode_time_error VARCHAR(255) NULL,

        transcode_final_bitrate INT NOT NULL

);

Reply to "Doesn't work with PostgreSQL Backend"