-
+ 2FC6A536EC6C147D53EE7A9EC50E947E4FB9F479BB108F23DF3329ED83C3479A622EE618E41E721CB2FA8EFAC189D142743AB5CE3C3F4A6E90B851BD3DC9DCEA
logotron/nsalog_schem.sql
(0 . 0)(1 . 29)
 728 drop table if exists loglines;
 729 create table loglines (
 730   ser       serial,
 731   idx       integer not null,
 732   t         timestamp,
 733   chan      text not null,
 734   era       integer not null,
 735   speaker   text not null,
 736   self      boolean,
 737   payload   text not null,
 738   backlinks integer[],
 739   PRIMARY KEY(idx, chan),
 740   UNIQUE(idx, chan)
 741 );
 742 
 743 
 744 create index logline_idx_i     on loglines(idx);
 745 create index logline_t_i       on loglines(t);
 746 create index logline_chan_i    on loglines(chan);
 747 create index logline_era_i     on loglines(era);
 748 create index logline_speaker_i on loglines(speaker);
 749 create index logline_payload_i on loglines(payload);
 750 
 751 CREATE EXTENSION pg_trgm;
 752 
 753 -- drop index payload_search_idx;
 754 
 755 create index concurrently payload_search_idx
 756 ON loglines USING gin (payload gin_trgm_ops);