-- DROP TABLE trexdb.dbo.companies_import GO

CREATE TABLE trexdb.dbo.companies_import (
	id bigint IDENTITY(1,1) NOT NULL,
  filler_1 varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  filler_2 varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  filler_3 varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  filler_4 varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  filler_5 varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	business_name varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  tax_number varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  vat_number varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  street_name varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  house_number varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  district varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  city varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  zip_code varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  region varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  istat_code varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  telephone_number varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  fax_number varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  CONSTRAINT PK__companies_import PRIMARY KEY (id)
  )  GO