blob: 720254d0eaf9ad2f8691cdac7e8e9cd315bc4a64 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
ALTER TABLE tags_vn ADD COLUMN date timestamptz NOT NULL DEFAULT NOW();
-- this index is essential, quite often sorted on
CREATE INDEX tags_vn_date ON tags_vn (date);
-- VNDBUtil::normalize() has been modified, so update search cache
UPDATE vn SET c_search = NULL;
|