diff options
Diffstat (limited to 'extensions/TimedMediaHandler/TimedMediaHandler.sql')
-rw-r--r-- | extensions/TimedMediaHandler/TimedMediaHandler.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/extensions/TimedMediaHandler/TimedMediaHandler.sql b/extensions/TimedMediaHandler/TimedMediaHandler.sql new file mode 100644 index 00000000..7bafe675 --- /dev/null +++ b/extensions/TimedMediaHandler/TimedMediaHandler.sql @@ -0,0 +1,19 @@ +-- TimedMediaHandler.sql +-- 2011-04-05 <mdale@wikimedia.org> +-- +CREATE TABLE /*_*/transcode ( + transcode_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, + transcode_image_name VARCHAR(255) NOT NULL, + transcode_key VARCHAR(48) NOT NULL, + transcode_error longtext 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 +) /*$wgDBTableOptions*/; + +CREATE INDEX /*i*/transcode_time_inx ON /*_*/transcode( transcode_time_addjob ,transcode_time_startwork , transcode_time_success, transcode_time_error ); +CREATE INDEX /*i*/transcode_key_idx ON /*_*/transcode( transcode_key ); + +CREATE UNIQUE INDEX /*i*/transcode_name_key ON /*_*/transcode (transcode_image_name,transcode_key); |