diff options
| author | Reedy <reedy@wikimedia.org> | 2019-08-15 14:36:53 +0100 |
|---|---|---|
| committer | Reedy <reedy@wikimedia.org> | 2019-08-20 19:35:57 +0000 |
| commit | c00c34f288c13b5360e30c694d929e4c65e3a3a1 (patch) | |
| tree | efc2f5d5f74c74ee51650a0edc8133bdcebee542 /maintenance/postgres/archives/patch-image_comment_temp-table.sql | |
| parent | 4304174a4c6ccea53377071462a4ac5330bf5c98 (diff) | |
| download | mediawikicore-c00c34f288c13b5360e30c694d929e4c65e3a3a1.tar.gz mediawikicore-c00c34f288c13b5360e30c694d929e4c65e3a3a1.zip | |
Split down patch-comment-table.sql
Bug: T227662
Change-Id: I7617616df57f7468d06e9b52426b6851bfef0e7d
Diffstat (limited to 'maintenance/postgres/archives/patch-image_comment_temp-table.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-image_comment_temp-table.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-image_comment_temp-table.sql b/maintenance/postgres/archives/patch-image_comment_temp-table.sql new file mode 100644 index 000000000000..be7bb825d844 --- /dev/null +++ b/maintenance/postgres/archives/patch-image_comment_temp-table.sql @@ -0,0 +1,6 @@ +CREATE TABLE image_comment_temp ( + imgcomment_name TEXT NOT NULL, + imgcomment_description_id INTEGER NOT NULL, + PRIMARY KEY (imgcomment_name, imgcomment_description_id) +); +CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_name); |