TheDJ has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/343833 )
Change subject: Add support for postgres to TMH
......................................................................
Add support for postgres to TMH
SQL provided By 0xAFFF
Change-Id: I025625f55467a11a018b8d2a0fe89ef385144a7c
---
M TimedMediaHandler.hooks.php
A TimedMediaHandler.postgres.sql
2 files changed, 17 insertions(+), 1 deletion(-)
git pull
ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/TimedMediaHandler
refs/changes/33/343833/1
diff --git a/TimedMediaHandler.hooks.php b/TimedMediaHandler.hooks.php
index 1a1d46e..73f66be 100644
--- a/TimedMediaHandler.hooks.php
+++ b/TimedMediaHandler.hooks.php
@@ -769,7 +769,7 @@
"$base/archives/transcode_name_key.sql", true ]
);
break;
case 'postgres':
- // TODO
+ $updater->addExtensionTable( 'transcode',
"$base/TimedMediaHandler.postgres.sql" );
break;
}
return true;
diff --git a/TimedMediaHandler.postgres.sql b/TimedMediaHandler.postgres.sql
new file mode 100644
index 0000000..671682b
--- /dev/null
+++ b/TimedMediaHandler.postgres.sql
@@ -0,0 +1,16 @@
+CREATE TABLE /*_*/transcode (
+ transcode_id SERIAL NOT NULL,
+ 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);
--
To view, visit https://gerrit.wikimedia.org/r/343833
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I025625f55467a11a018b8d2a0fe89ef385144a7c
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/TimedMediaHandler
Gerrit-Branch: master
Gerrit-Owner: TheDJ <hartman.w...@gmail.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
