[
    "categories",
    "items",
    "items_events",
    "products_autocomplete",
    "users",
    "users_forget",
    "users_subscriptions"
]
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_owner` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=643 DEFAULT CHARSET=utf8mb4
480
CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_owner` int(11) NOT NULL,
  `id_model` int(11) NOT NULL,
  `id_url` varchar(100) NOT NULL,
  `id_rfid` varchar(100) NOT NULL,
  `id_idn` varchar(100) NOT NULL,
  `id_custom` varchar(100) NOT NULL,
  `id_parent` int(11) NOT NULL,
  `brand` varchar(100) NOT NULL,
  `childitems` text NOT NULL,
  `name` varchar(150) NOT NULL,
  `id_type` int(11) NOT NULL,
  `model_custom` varchar(100) NOT NULL,
  `size` varchar(100) NOT NULL,
  `make_year` year(4) NOT NULL,
  `date_buy` date NOT NULL,
  `date_lifetime` varchar(50) NOT NULL,
  `date_firstuse` date NOT NULL,
  `date_endoflife` date NOT NULL,
  `control_period` int(11) NOT NULL,
  `last_control_date` date NOT NULL,
  `last_control_id_user` int(11) NOT NULL,
  `last_control_id` int(11) NOT NULL,
  `last_control_state` smallint(6) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL,
  `manual_filename` varchar(100) NOT NULL,
  `manual_url` varchar(100) NOT NULL,
  `files` text NOT NULL,
  `next_control_date` date NOT NULL,
  `notification_sent_alert` tinyint(1) NOT NULL,
  `notification_sent_warning` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`,`id_owner`),
  FULLTEXT KEY `id_idn` (`id_idn`),
  FULLTEXT KEY `id_custom` (`id_custom`),
  FULLTEXT KEY `brand` (`brand`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `model_custom` (`model_custom`)
) ENGINE=InnoDB AUTO_INCREMENT=113845 DEFAULT CHARSET=utf8mb4
109273
CREATE TABLE `items_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  `type` smallint(6) NOT NULL,
  `id_item` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `state` smallint(6) NOT NULL,
  `data` text NOT NULL,
  `controler_name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=258024 DEFAULT CHARSET=utf8mb4
256269
CREATE TABLE `products_autocomplete` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brand` varchar(250) NOT NULL,
  `category` int(11) NOT NULL,
  `reference` varchar(250) NOT NULL,
  `name` varchar(250) NOT NULL,
  `control_frequency` int(11) NOT NULL,
  `date_endoflile` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1102 DEFAULT CHARSET=utf8mb4
1099
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_owner` int(11) NOT NULL,
  `login` varchar(100) NOT NULL,
  `password` varchar(250) NOT NULL,
  `secret` varchar(250) NOT NULL,
  `id_root_item` text NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `user_type` varchar(30) NOT NULL,
  `notification_email` int(11) NOT NULL,
  `valid_email` smallint(6) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  `superadmin` tinyint(4) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=6888 DEFAULT CHARSET=utf8mb4
3723
CREATE TABLE `users_forget` (
  `credential` varchar(191) NOT NULL,
  `id_user` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`credential`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
647
CREATE TABLE `users_subscriptions` (
  `id` int(11) NOT NULL,
  `subscription` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `type` varchar(30) NOT NULL,
  `date_subscription_start` date NOT NULL,
  `date_subscription_end` date NOT NULL,
  `date_still_active` date NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
3452