summaryrefslogtreecommitdiff
path: root/extensions/TimedMediaHandler/TimedMediaHandler.sql
diff options
context:
space:
mode:
Diffstat (limited to 'extensions/TimedMediaHandler/TimedMediaHandler.sql')
-rw-r--r--extensions/TimedMediaHandler/TimedMediaHandler.sql19
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);