CREATE TABLE {{table_schema}}.crm_account (
    `id` int NOT NULL,
    `name` VARCHAR(200),
    `accountUrl` VARCHAR(200),
    `createdTimestamp` DATETIME,
    `updatedTimestamp` DATETIME,
    `contactCount` INT(11),
    `dealCount` INT(11),
    `country` VARCHAR(200),
    `tp_code` VARCHAR(60),
    `sales_office` VARCHAR(200),
    `network` VARCHAR(200),
	`company_type` TEXT,
	`first_contact` INT(11),
    PRIMARY KEY (id)
) ENGINE=MyISAM;