dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge "Title: Make getOtherPage() check canHaveTalkPage()"
[lhc/web/wiklou.git]
/
maintenance
/
postgres
/
tables.sql
diff --git
a/maintenance/postgres/tables.sql
b/maintenance/postgres/tables.sql
index
3516a3b
..
eea9e68
100644
(file)
--- a/
maintenance/postgres/tables.sql
+++ b/
maintenance/postgres/tables.sql
@@
-358,10
+358,10
@@
CREATE INDEX img_sha1 ON image (img_sha1);
CREATE TABLE image_comment_temp (
imgcomment_name TEXT NOT NULL,
CREATE TABLE image_comment_temp (
imgcomment_name TEXT NOT NULL,
- imgcomment_
comment
_id INTEGER NOT NULL,
- PRIMARY KEY (imgcomment_name, imgcomment_
comment
_id)
+ imgcomment_
description
_id INTEGER NOT NULL,
+ PRIMARY KEY (imgcomment_name, imgcomment_
description
_id)
);
);
-CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_
rev
);
+CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_
name
);
CREATE TABLE oldimage (
oi_name TEXT NOT NULL,
CREATE TABLE oldimage (
oi_name TEXT NOT NULL,