jbidwatcher

mrs 1   CREATE TABLE auctions (
mrs 2     id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 3     identifier varchar(255) default NULL,
mrs 4     current_bid decimal(10,2) default NULL,
mrs 5     buy_now decimal(10,2) default NULL,
mrs 6     minimum_bid decimal(10,2) default NULL,
mrs 7     shipping decimal(10,2) default NULL,
mrs 8     insurance decimal(10,2) default NULL,
mrs 9     usd_current decimal(10,2) default NULL,
mrs 10    usd_buy_now decimal(10,2) default NULL,
mrs 11    currency varchar(10) default NULL,
mrs 12    started_at timestamp default NULL,
mrs 13    ending_at timestamp default NULL,
mrs 14    high_bidder varchar(255) default NULL,
mrs 15    high_bidder_email varchar(255) default NULL,
mrs 16    title varchar(255) default NULL,
mrs 17    quantity integer default NULL,
mrs 18    bid_count integer default NULL,
mrs 19    seller_id integer default NULL,
mrs 20    location varchar(255) default NULL,
mrs 21    paypal smallint default NULL,
mrs 22    reserve_met smallint default NULL,
mrs 23    private smallint default NULL,
mrs 24    reserve smallint default NULL,
mrs 25    dutch smallint default NULL,
mrs 26    no_thumbnail smallint default NULL,
mrs 27    has_thumbnail smallint default NULL,
mrs 28    fixed_price smallint default NULL,
mrs 29    optional_insurance smallint default NULL,
mrs 30    outbid smallint default NULL,
mrs 31    PRIMARY KEY  (id)
mrs 32  )
mrs 33  
mrs 34  CREATE INDEX IDX_Auction_EndTime ON auctions(ending_at)
mrs 35  
mrs 36  CREATE INDEX IDX_Auction_Seller ON auctions(seller_id)
mrs 37  
mrs 38  CREATE INDEX IDX_Auction_Identifier ON auctions(identifier)
mrs 39  
mrs 40  CREATE INDEX IDX_Auction_Title ON auctions(title)
mrs 41  
mrs 42  CREATE TABLE categories (
mrs 43    id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 44    name varchar(255) default NULL,
mrs 45    PRIMARY KEY  (id)
mrs 46  )
mrs 47  
mrs 48  CREATE TABLE entries (
mrs 49    id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 50    auction_id integer default NULL,
mrs 51    comment varchar(255) default NULL,
mrs 52    shipping decimal(10,2) default NULL,
mrs 53    last_bid_amount decimal(10,2) default NULL,
mrs 54    last_bid_quantity integer default NULL,
mrs 55    last_bid_at timestamp default NULL,
mrs 56    currency varchar(10),
mrs 57    multisnipe_id integer default NULL,
mrs 58    snipe_id integer default NULL,
mrs 59    category_id integer default NULL,
mrs 60    last_updated_at timestamp default NULL,
mrs 61    ended smallint default NULL,
mrs 62    invalid smallint default NULL,
mrs 63    sticky smallint default NULL,
mrs 64    deleted smallint default NULL,
mrs 65    last_error_page clob,
mrs 66    identifier varchar(255) default NULL,
mrs 67    winning smallint default NULL,
mrs 68    PRIMARY KEY  (id)
mrs 69  )
mrs 70  
mrs 71  CREATE INDEX IDX_Entry_Category ON entries(category_id)
mrs 72  
mrs 73  CREATE INDEX IDX_Entry_Auctions ON entries(auction_id)
mrs 74  
mrs 75  CREATE INDEX IDX_Entry_Identifier ON entries(identifier)
mrs 76  
mrs 77  CREATE TABLE events (
mrs 78    id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 79    entry_id integer default NULL,
mrs 80    repeat_count integer default 0,
mrs 81    created_at timestamp default NULL,
mrs 82    message varchar(255) default NULL,
mrs 83    title varchar(255) default NULL,
mrs 84    PRIMARY KEY  (id)
mrs 85  )
mrs 86  
mrs 87  CREATE INDEX IDX_Events_Entries ON events(entry_id)
mrs 88  
mrs 89  CREATE TABLE multisnipes (
mrs 90    id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 91    identifier varchar(255) default NULL,
mrs 92    default_bid decimal(10,2) default NULL,
mrs 93    default_quantity integer default NULL,
mrs 94    currency varchar(10),
mrs 95    want_count integer default NULL,
mrs 96    won_count integer default NULL,
mrs 97    color varchar(255) default NULL,
mrs 98    name varchar(255) default NULL,
mrs 99    created_at timestamp default NULL,
mrs 100   subtract_shipping smallint default NULL,
mrs 101   PRIMARY KEY  (id)
mrs 102 )
mrs 103 
mrs 104 CREATE INDEX IDX_Multisnipes_identifier ON multisnipes(identifier)
mrs 105 
mrs 106 CREATE TABLE sellers (
mrs 107   id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 108   seller varchar(255) default NULL,
mrs 109   feedback integer default NULL,
mrs 110   feedback_percentage DECIMAL(5,2) default NULL,
mrs 111   comments varchar(255) default NULL,
mrs 112   PRIMARY KEY  (id)
mrs 113 )
mrs 114 
mrs 115 CREATE INDEX IDX_Sellers_Seller ON sellers(seller)
mrs 116 
mrs 117 CREATE TABLE snipes (
mrs 118   id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 119   amount decimal(10,2) default NULL,
mrs 120   currency varchar(10),
mrs 121   quantity integer default NULL,
mrs 122   delta integer default NULL,
mrs 123   user_id integer default NULL,
mrs 124   status varchar(255) default NULL,
mrs 125   PRIMARY KEY  (id)
mrs 126 )
mrs 127 
mrs 128 CREATE TABLE deleted (
mrs 129   id integer NOT NULL generated by default as identity (START WITH 1, INCREMENT BY 1),
mrs 130   identifier varchar(255) default NULL,
mrs 131   created_at timestamp default NULL,
mrs 132   PRIMARY KEY  (id)
mrs 133 )
mrs 134 
mrs 135 CREATE INDEX IDX_Deleted_Identifier ON deleted(identifier)
mrs 136 
mrs 137 CREATE TABLE archived_auctions (
mrs 138   id integer NOT NULL,
mrs 139   identifier varchar(255) default NULL,
mrs 140   current_bid decimal(10,2) default NULL,
mrs 141   buy_now decimal(10,2) default NULL,
mrs 142   minimum_bid decimal(10,2) default NULL,
mrs 143   shipping decimal(10,2) default NULL,
mrs 144   insurance decimal(10,2) default NULL,
mrs 145   usd_current decimal(10,2) default NULL,
mrs 146   usd_buy_now decimal(10,2) default NULL,
mrs 147   currency varchar(10) default NULL,
mrs 148   started_at timestamp default NULL,
mrs 149   ending_at timestamp default NULL,
mrs 150   high_bidder varchar(255) default NULL,
mrs 151   high_bidder_email varchar(255) default NULL,
mrs 152   title varchar(255) default NULL,
mrs 153   quantity integer default NULL,
mrs 154   bid_count integer default NULL,
mrs 155   seller_id integer default NULL,
mrs 156   location varchar(255) default NULL,
mrs 157   paypal smallint default NULL,
mrs 158   reserve_met smallint default NULL,
mrs 159   private smallint default NULL,
mrs 160   reserve smallint default NULL,
mrs 161   dutch smallint default NULL,
mrs 162   no_thumbnail smallint default NULL,
mrs 163   has_thumbnail smallint default NULL,
mrs 164   fixed_price smallint default NULL,
mrs 165   optional_insurance smallint default NULL,
mrs 166   outbid smallint default NULL,
mrs 167   PRIMARY KEY  (id)
mrs 168 )
mrs 169 
mrs 170 CREATE INDEX IDX_Archive_Auction_Identifier ON archived_auctions(identifier)
mrs 171 
mrs 172 CREATE TABLE schema_info (
mrs 173   version integer default NULL
mrs 174 )
mrs 175 
mrs 176 INSERT INTO schema_info (version) VALUES (18)