CREATE TABLE `dsshortages` (
  `ID_LNK` int(11) NOT NULL AUTO_INCREMENT,
  `Drug_ID_LNK` int(11) NOT NULL,
  `Expected_Delivery_Date` varchar(100) NOT NULL,
  `Recorded_By_ID_LNK` int(11) NOT NULL,
  `Recorded_Date` varchar(100) NOT NULL,
  `ULM_Availability` varchar(255) DEFAULT NULL,
  `GeneralSupplierCommunication` tinyint(1) NOT NULL,
  `Closed_Date` varchar(255) DEFAULT NULL,
  `Closed_By_ID_LNK` int(11) NOT NULL DEFAULT '0',
  `Archived` int(11) NOT NULL DEFAULT '0',
  `Deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID_LNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1