17 lines
592 B
SQL
17 lines
592 B
SQL
/* 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;
|