]> git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/75.sql
schema: add ttrss_feeds.order_id
[tt-rss.git] / schema / versions / pgsql / 75.sql
1 begin;
2
3 alter table ttrss_feeds add column order_id integer;
4 update ttrss_feeds set order_id = 0;
5 alter table ttrss_feeds alter column order_id set not null;
6 alter table ttrss_feeds alter column order_id set default 0;
7
8 update ttrss_version set schema_version = 75;
9
10 commit;