CREATE TABLE `def_bureau` (
`BureauCode` char(50) NOT NULL,
`Package` char(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT NULL,
`Bureau` char(255) DEFAULT NULL,
`Url` char(255) DEFAULT NULL,
`Active` char(255) DEFAULT NULL,
`Virtual` char(255) DEFAULT 'N',
`Subscribercode` char(255) DEFAULT NULL,
`SecurityCode` char(255) DEFAULT NULL,
`Enquirercontactname` char(255) DEFAULT NULL,
`Enquirercontactphone` char(255) DEFAULT NULL,
`Documentcode` char(255) DEFAULT NULL,
PRIMARY KEY (`BureauCode`, `Package`),
KEY `Active` (`Active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};