createProstgresTable.sql

CREATE SEQUENCE item_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE TABLE item (id INT NOT NULL, external_id VARCHAR(255) NOT NULL, category_name VARCHAR(255) NOT NULL, sku VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, short_description TEXT DEFAULT NULL, price NUMERIC(10, 4) DEFAULT NULL, link VARCHAR(255) NOT NULL, image VARCHAR(255) NOT NULL, brand VARCHAR(255) DEFAULT NULL, rating INT NOT NULL, caffeine_type VARCHAR(20) DEFAULT NULL, count INT DEFAULT NULL, flavored BOOLEAN DEFAULT NULL, seasonal BOOLEAN DEFAULT NULL, in_stock BOOLEAN NOT NULL, facebook BOOLEAN NOT NULL, is_kcup BOOLEAN NOT NULL, PRIMARY KEY(id));
CREATE UNIQUE INDEX UNIQ_1F1B251E9F75D7B0 ON item (external_id);