Mercurial > hg > rc2

annotate SQL/postgres/2013061000.sql @ 9:0c9c57d9d4dd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
maybe stragglers from 1.3.3, after another mistaken apt-get install of 1.2.3
author Charlie Root
date Fri, 04 Jan 2019 06:38:56 -0500
parents 4681f974d28b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
1 ALTER TABLE "cache" ADD expires timestamp with time zone DEFAULT NULL;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
2 ALTER TABLE "cache_shared" ADD expires timestamp with time zone DEFAULT NULL;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
3 ALTER TABLE "cache_index" ADD expires timestamp with time zone DEFAULT NULL;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
4 ALTER TABLE "cache_thread" ADD expires timestamp with time zone DEFAULT NULL;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
5 ALTER TABLE "cache_messages" ADD expires timestamp with time zone DEFAULT NULL;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
6
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
7 -- initialize expires column with created/changed date + 7days
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
8 UPDATE "cache" SET expires = created + interval '604800 seconds';
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
9 UPDATE "cache_shared" SET expires = created + interval '604800 seconds';
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
10 UPDATE "cache_index" SET expires = changed + interval '604800 seconds';
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
11 UPDATE "cache_thread" SET expires = changed + interval '604800 seconds';
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
12 UPDATE "cache_messages" SET expires = changed + interval '604800 seconds';
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
13
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
14 DROP INDEX cache_created_idx;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
15 DROP INDEX cache_shared_created_idx;
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
16 ALTER TABLE "cache_index" DROP "changed";
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
17 ALTER TABLE "cache_thread" DROP "changed";
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
18 ALTER TABLE "cache_messages" DROP "changed";
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
19
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
20 CREATE INDEX cache_expires_idx ON "cache" (expires);
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
21 CREATE INDEX cache_shared_expires_idx ON "cache_shared" (expires);
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
22 CREATE INDEX cache_index_expires_idx ON "cache_index" (expires);
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
23 CREATE INDEX cache_thread_expires_idx ON "cache_thread" (expires);
4681f974d28b vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
24 CREATE INDEX cache_messages_expires_idx ON "cache_messages" (expires);