CREATE TABLE `dsdrugs` (
  `ID_LNK` int(11) NOT NULL AUTO_INCREMENT,
  `VPPID` bigint(18) NOT NULL,
  `Product` varchar(255) NOT NULL,
  `Form` varchar(255) NOT NULL,
  `Strength` varchar(255) NOT NULL,
  `Pack_Size` varchar(255) NOT NULL,
  `Brand` varchar(255) NOT NULL,
  `Distributer` varchar(255) NOT NULL,
  `On_Contract` tinyint(1) NOT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`ID_LNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1