summaryrefslogtreecommitdiff
path: root/util/updates/update_2.15.sql
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;