CREATE TABLE IF NOT EXISTS `module_tecass_os` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `entry_date` TIMESTAMP NULL,
  `delivery_forecast` TIMESTAMP NULL,
  `description` TEXT NULL,
  `status` INT NULL,
  `sys_invoices_id` INT NULL,
  `crm_accounts_id` INT NULL,
  `sys_items_id` INT NULL,
  `created_at` TIMESTAMP NULL,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` TIMESTAMP NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_module_tecass_os_sys_invoices_idx` (`sys_invoices_id` ASC),
  INDEX `fk_module_tecass_os_crm_accounts1_idx` (`crm_accounts_id` ASC),
  INDEX `fk_module_tecass_os_sys_items1_idx` (`sys_items_id` ASC),
  CONSTRAINT `fk_module_tecass_os_sys_invoices`
    FOREIGN KEY (`sys_invoices_id`)
    REFERENCES `sys_invoices` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_module_tecass_os_crm_accounts1`
    FOREIGN KEY (`crm_accounts_id`)
    REFERENCES `crm_accounts` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_module_tecass_os_sys_items1`
    FOREIGN KEY (`sys_items_id`)
    REFERENCES `sys_items` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE = MyISAM;

ALTER TABLE module_tecass_os
    ADD COLUMN delivery_note TEXT NULL,
    ADD COLUMN delivered TIMESTAMP NULL,
    ADD COLUMN delivered_by INT NULL
    AFTER deleted_at;