Unable to add properties about estatezilla HOT 4 OPEN

CREATE TABLE `properties` (
  `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT
,  `user_id` integer  DEFAULT NULL
,  `property_type_id` integer  DEFAULT NULL
,  `listing_type` text  NOT NULL DEFAULT 'sale'
,  `listing_status` text  DEFAULT NULL
,  `property_condition` text  NOT NULL DEFAULT 'not_specified'
,  `property_size` decimal(11,2) DEFAULT NULL
,  `num_bedrooms` integer DEFAULT NULL
,  `num_bathrooms` integer DEFAULT NULL
,  `num_floors` integer DEFAULT NULL
,  `num_receptions` integer DEFAULT NULL
,  `has_garden` integer DEFAULT NULL
,  `has_parking` integer DEFAULT NULL
,  `is_investment_property` integer DEFAULT NULL
,  `new_home` integer DEFAULT NULL
,  `photos` text COLLATE BINARY
,  `floor_plans` text COLLATE BINARY
,  `documents` text COLLATE BINARY
,  `virtual_tours` text COLLATE BINARY
,  `displayable_address` varchar(255)
,  `street_no` varchar(255) DEFAULT NULL
,  `street_name` varchar(255) DEFAULT NULL
,  `city` varchar(255) DEFAULT NULL
,  `region` varchar(255) DEFAULT NULL
,  `postcode` varchar(255) DEFAULT NULL
,  `country` char(2) DEFAULT NULL
,  `lat` decimal(18,12) DEFAULT NULL
,  `lng` decimal(18,12) DEFAULT NULL
,  `price` decimal(11,2) DEFAULT NULL
,  `reduced_price` decimal(11,2) DEFAULT NULL
,  `negotiable_price` integer DEFAULT NULL
,  `poa` integer DEFAULT NULL
,  `price_period` varchar(255) DEFAULT NULL
,  `price_type` varchar(255) DEFAULT NULL
,  `is_featured` integer NOT NULL DEFAULT '0'
,  `expires_at` datetime DEFAULT '0000-00-00 00:00:00'
,  `published_at` datetime DEFAULT '0000-00-00 00:00:00'
,  `origin` varchar(255) DEFAULT NULL
,  `visible` integer DEFAULT '0'
,  `terms_agree` integer NOT NULL DEFAULT '0'
,  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
,  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
,  `deleted_at` timestamp NULL DEFAULT NULL
);