Mercurial > hg > rc2

view SQL/postgres/2008092100.sql @ 4:1ab920879b88

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
do date sort if sorting on dates, to get sub-threads in date order. See also thunderbird-labels.php:407 et seq.
author Charlie Root
date Thu, 18 Jan 2018 07:47:04 -0500
parents 4681f974d28b
children
line wrap: on
line source

-- Updates from version 0.2-beta

ALTER TABLE cache DROP session_id;

CREATE INDEX session_changed_idx ON session (changed);
CREATE INDEX cache_created_idx ON "cache" (created);

ALTER TABLE users ALTER "language" DROP NOT NULL;
ALTER TABLE users ALTER "language" DROP DEFAULT;

ALTER TABLE identities ALTER del TYPE smallint;
ALTER TABLE identities ALTER standard TYPE smallint;
ALTER TABLE contacts ALTER del TYPE smallint;
ALTER TABLE messages ALTER del TYPE smallint;