Someone

CREATE TABLE listings (
  listing_id int(11) NOT NULL auto_increment,
  legacy_id varchar(64) NOT NULL default '0',
  category varchar(32) NOT NULL default '',
  entered_by int(11) NOT NULL default '0',
  entered_when datetime NOT NULL default '0000-00-00 00:00:00',
  last_edit_by int(11) NOT NULL default '0',
  last_edit datetime NOT NULL default '0000-00-00 00:00:00',
  cms_status varchar(16) NOT NULL default 'incomplete',
  view_counter int(9) NOT NULL default '0',
  client_id int(11) NOT NULL default '0',
  agent_id int(11) NOT NULL default '0',
  featured varchar(16) NOT NULL default 'no',
  onlyfeature varchar(5) NOT NULL default 'no',
  hide varchar(16) NOT NULL default 'no',
  exclusive varchar(16) NOT NULL default '',
  listed_with varchar(32) NOT NULL default '',
  listing_news varchar(32) NOT NULL default '',
  property_name varchar(64) NOT NULL default '',
  property_name_2 varchar(32) NOT NULL default '',
  price int(11) NOT NULL default '0',
  netprice int(11) NOT NULL default '0',
  rent_price_alts varchar(32) NOT NULL default '',
  island varchar(32) NOT NULL default '',
  location varchar(32) NOT NULL default '',
  district varchar(32) NOT NULL default '',
  description text NOT NULL,
  notes text NOT NULL,
  condition varchar(32) NOT NULL default '',
  list_date date NOT NULL default '0000-00-00',
  verified date NOT NULL default '0000-00-00',
  expiry date NOT NULL default '0000-00-00',
  key_with varchar(32) NOT NULL default '',
  key_number varchar(32) NOT NULL default '',
  commission varchar(32) NOT NULL default '',
  classified_include varchar(32) NOT NULL default '',
  classified_ad_caption varchar(96) NOT NULL default '',
  classified_ad_copy text NOT NULL,
  air_conditioner varchar(32) NOT NULL default '',
  rental_type varchar(32) NOT NULL default '',
  property_type varchar(32) NOT NULL default '',
  building_style varchar(32) NOT NULL default '',
  view_type varchar(32) NOT NULL default '',
  bedrooms int(9) NOT NULL default '0',
  bathrooms decimal(3,1) NOT NULL default '0.0',
  amenities varchar(255) NOT NULL default '',
  school_1 varchar(90) NOT NULL default '',
  school_2 varchar(90) NOT NULL default '',
  school_3 varchar(90) NOT NULL default '',
  pool varchar(32) NOT NULL default '',
  laundry varchar(32) NOT NULL default '',
  gated varchar(32) NOT NULL default '',
  cable varchar(32) NOT NULL default '',
  internet varchar(9) NOT NULL default '',
  storage varchar(32) NOT NULL default '',
  is_enclosed varchar(32) NOT NULL default '',
  elevated varchar(32) NOT NULL default '',
  shutters varchar(32) NOT NULL default '',
  well_quant varchar(32) NOT NULL default '',
  watertank varchar(32) NOT NULL default '',
  fans varchar(32) NOT NULL default '',
  carpet varchar(32) NOT NULL default '',
  gas varchar(32) NOT NULL default '',
  satellite varchar(32) NOT NULL default '',
  furnished varchar(32) NOT NULL default '',
  rent_contact varchar(32) NOT NULL default '',
  rent_rented varchar(32) NOT NULL default '',
  rent_tenant_name varchar(32) NOT NULL default '',
  rent_tenant_PhHo varchar(32) NOT NULL default '',
  rent_tenant_PhWk varchar(32) NOT NULL default '',
  security_deposit varchar(32) NOT NULL default '',
  phone_deposit varchar(32) NOT NULL default '',
  water_deposit varchar(32) NOT NULL default '',
  bec_deposit varchar(32) NOT NULL default '',
  pets varchar(32) NOT NULL default '',
  children varchar(32) NOT NULL default '',
  fenced varchar(32) NOT NULL default '',
  sign varchar(32) NOT NULL default '',
  insurance varchar(32) NOT NULL default '',
  RPTax varchar(32) NOT NULL default '',
  terms varchar(32) NOT NULL default '',
  property_code varchar(32) NOT NULL default '',
  available_when date NOT NULL default '0000-00-00',
  business_class varchar(32) NOT NULL default '',
  business_type varchar(32) NOT NULL default '',
  net_rentable varchar(32) NOT NULL default '',
  sq_ft_rate varchar(32) NOT NULL default '',
  roof_type varchar(32) NOT NULL default '',
  electricity varchar(32) NOT NULL default '',
  stand_by_generator varchar(32) NOT NULL default '',
  parking varchar(32) NOT NULL default '',
  construction varchar(32) NOT NULL default '',
  num_of_elevators varchar(32) NOT NULL default '',
  water varchar(32) NOT NULL default '',
  security varchar(32) NOT NULL default '',
  telcom varchar(32) NOT NULL default '',
  com_status varchar(32) NOT NULL default '',
  total_expenses varchar(32) NOT NULL default '',
  vacancy_rate varchar(32) NOT NULL default '',
  price_sq_ft varchar(32) NOT NULL default '',
  num_of_units varchar(32) NOT NULL default '',
  gross_rentable_area varchar(32) NOT NULL default '',
  gross_building varchar(32) NOT NULL default '',
  zoning varchar(32) NOT NULL default '',
  goi varchar(32) NOT NULL default '',
  noi varchar(32) NOT NULL default '',
  deposit int(9) NOT NULL default '0',
  developed varchar(32) NOT NULL default '',
  lot_size int(11) default NULL,
  living_area varchar(32) NOT NULL default '',
  floors varchar(32) NOT NULL default '',
  floor_level varchar(23) NOT NULL default '',
  maint_fees int(9) NOT NULL default '0',
  lease_term varchar(32) NOT NULL default '',
  year_built int(4) NOT NULL default '0',
  PRIMARY KEY  (listing_id)
) TYPE=MyISAM;