version-012.sql 230 Bytes
Newer Older
1 2 3 4 5 6 7
--
-- Add the internaldate column as a time_t value so we can sort on it.
--

ALTER TABLE MessageTable ADD COLUMN internaldate_time_t INTEGER;

CREATE INDEX MessageTableInternalDateTimeTIndex ON MessageTable(internaldate_time_t);