/* Postal Deliv */
CREATE TABLE IF NOT EXISTS `PREFIX_postaldeliv` (
    `id_postaldeliv` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `id_carrier` int(10) unsigned NOT NULL,
    `country` text NOT NULL,
    `postcode` text NOT NULL,
    `county` text NOT NULL,
    `range` text NOT NULL,
    `available` tinyint(1) NOT NULL,
    PRIMARY KEY (`id_postaldeliv`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=UTF8;

CREATE TABLE IF NOT EXISTS `PREFIX_postaldeliv_shop` (
    `id_postaldeliv` int(11) unsigned NOT NULL,
    `id_shop` int(11) unsigned NOT NULL
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=UTF8;