CREATE TABLE `offer`(
    `_ID` INT NOT NULL,
    `_IDoffers` INT NOT NULL,
    `available` VARCHAR(255) NOT NULL,
    `barcode` VARCHAR(255) NULL,
    `categoryId` INT NULL,
    `currencyId` INT NULL,
    `delivery` INT NULL,
    `description` TEXT NULL,
    `id` INT NOT NULL,
    `manufacturer_warranty` VARCHAR(255) NULL,
    `model` VARCHAR(255) NULL,
    `modified_time` INT NULL,
    `name` VARCHAR(255) NULL,
    `offer` VARCHAR(255) NULL,
    `oldprice` VARCHAR(255) NULL,
    `param` VARCHAR(255) NULL,
    `pickup` INT NULL,
    `picture` INT NULL,
    `price` INT NULL,
    `rec` INT NULL,
    `sales_notes` INT NULL,
    `store` INT NULL,
    `url` INT NULL,
    `vendor` INT NULL,
    `vendorCode` INT NULL
) ENGINE = InnoDB;