SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]access`
CREATE TABLE `[[dbprefix]]access` (
`id_profile` int(11) unsigned NOT NULL,
`id_tab` int(11) unsigned NOT NULL,
`delete` int(11) NOT NULL,
PRIMARY KEY (`id_profile`,`id_tab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table `[[dbprefix]]access`
INSERT INTO `[[dbprefix]]access` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]accessory`
CREATE TABLE `[[dbprefix]]accessory` (
`id_product_1` int(11) unsigned NOT NULL,
`id_product_2` int(11) unsigned NOT NULL,
KEY `accessory_product` (`id_product_1`,`id_product_2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]address`
CREATE TABLE `[[dbprefix]]address` (
`id_address` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_country` int(11) unsigned NOT NULL,
`id_state` int(11) unsigned DEFAULT NULL,
`id_customer` int(11) unsigned NOT NULL DEFAULT '0',
`id_manufacturer` int(11) unsigned NOT NULL DEFAULT '0',
`id_supplier` int(11) unsigned NOT NULL DEFAULT '0',
`id_warehouse` int(11) unsigned NOT NULL DEFAULT '0',
`alias` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`company` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`firstname` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`address1` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`address2` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`postcode` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`other` text COLLATE utf8mb4_unicode_ci,
`phone` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_mobile` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`vat_number` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dni` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,