CREATE TABLE `def_go` (
`Shortcode` char(50) NOT NULL,
`go_id` int(11) NOT NULL AUTO_INCREMENT,
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT NULL,
`TimeAdded` datetime DEFAULT current_timestamp(),
`Url` char(255) DEFAULT NULL,
`Company` char(255) DEFAULT NULL,
`Hits` int(11) DEFAULT 0,
`HitsExpires` int(11) DEFAULT 0,
`AltUrl` char(255) DEFAULT NULL,
`TimeHit` datetime DEFAULT NULL,
`TimeExpires` datetime DEFAULT NULL,
PRIMARY KEY (`go_id`),
UNIQUE KEY `uq_shortcode` (`Shortcode`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};