Fix PostgreSQL updater to produce 1.19 schema
[lhc/web/wiklou.git] / maintenance / postgres / archives / patch-msg_resource.sql
1 CREATE TABLE msg_resource (
2 mr_resource TEXT NOT NULL,
3 mr_lang TEXT NOT NULL,
4 mr_blob TEXT NOT NULL,
5 mr_timestamp TIMESTAMPTZ NOT NULL
6 );
7
8 CREATE UNIQUE INDEX mr_resource_lang ON msg_resource (mr_resource, mr_lang);