view SQL/sqlite/2013052500.sql @ 4:1ab920879b88

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

CREATE TABLE cache_shared (
  cache_key varchar(255) NOT NULL,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  data text NOT NULL
);

CREATE INDEX ix_cache_shared_cache_key ON cache_shared(cache_key);
CREATE INDEX ix_cache_shared_created ON cache_shared(created);