CREATE TABLE IF NOT EXISTS `location` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `external_id` VARCHAR(20) NOT NULL,
  `name` VARCHAR(200) NULL,
  `address_1` VARCHAR(100) NULL,
  `address_2` VARCHAR(100) NULL,
  `city` VARCHAR(50) NULL,
  `state_code` VARCHAR(2) NULL,
  `postal_code` NVARCHAR(10) NULL,
  `is_deleted` VARCHAR(45) NULL DEFAULT 0,
  `group_id` INT NOT NULL,
  `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`));
