· 6 years ago · Jun 21, 2019, 01:16 PM
1CREATE TABLE IF NOT EXISTS listings (id BIGINT NOT NULl, seller_name VARCHAR, seller_rating VARCHAR, item_memory VARCHAR, item_hard_drive VARCHAR, item_description VARCHAR, item_cpu VARCHAR,item_brand VARCHAR, bidhistory_highest_bid_amount VARCHAR, bidhistory_quantity INTEGER, general_payments_accepted VARCHAR, general_shipping_info VARCHAR,general_buyer_protection VARCHAR, general_type VARCHAR,highestbidder_name VARCHAR, highestbidder_rating VARCHAR, auction_location VARCHAR, auction_time_left INTEGER,auction_number_items INTEGER, auction_total_bids INTEGER,auction_start_price VARCHAR, auction_current_price VARCHAR,auction_bid_increment VARCHAR, auction_notes VARCHAR, auction_started_at UNSIGNED_DATE, auction_ending_at UNSIGNED_DATE, CONSTRAINT pk PRIMARY KEY(id));