cyberfox / jbidwatcher

The official home of JBidwatcher's source code, an eBay auction sniping, bidding & monitoring software application.

This URL has Read+Write access

jbidwatcher / db / 020.sql
100644 14 lines (11 sloc) 0.457 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14

CREATE TABLE time_queue (
  id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
  destination varchar(255) default NULL,
  payload varchar(255) default NULL,
  fire_at timestamp default NULL,
  repeat_interval integer default NULL,
  repeat_count integer default NULL,
  PRIMARY KEY  (id)
)
 
CREATE INDEX IDX_TQ_Destination ON time_queue(destination, payload)
 
CREATE INDEX IDX_TQ_FireAt ON time_queue(fire_at)