phpengine/dbschema.sql

-- Adminer 4.6.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP DATABASE IF EXISTS `omlink`;
CREATE DATABASE `omlink` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `omlink`;

DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
  `stazione` varchar(255) NOT NULL,
  `divisione` varchar(10) NOT NULL,
  `magazzino` varchar(10) NOT NULL,
  `tipo_magazzino` varchar(10) NOT NULL,
  `area_magazzino` varchar(10) NOT NULL,
  `ubicazione` varchar(255) NOT NULL,
  `materiale` varchar(255) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  `incc_intr` varchar(10) NOT NULL,
  `cont_std` varchar(10) NOT NULL,
  `tipo_contenitore` varchar(10) NOT NULL,
  `qta_contenitore` varchar(10) NOT NULL,
  `qta_riordino` varchar(10) NOT NULL,
  `sequenza` varchar(10) NOT NULL,
  `dummy01` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`materiale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `distinte`;
CREATE TABLE `distinte` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUtente` int(11) NOT NULL DEFAULT -1,
  `commessa` varchar(255) NOT NULL DEFAULT '',
  `barcode` varchar(255) NOT NULL DEFAULT '',
  `descrizione` varchar(255) NOT NULL DEFAULT '',
  `data_creazione` date NOT NULL DEFAULT current_timestamp(),
  `time_creazione` time NOT NULL DEFAULT current_timestamp(),
  `qta_prelevare` int(11) NOT NULL DEFAULT 0,
  `qta_mancante` int(11) NOT NULL DEFAULT 0,
  `deleted` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `distinte` (`id`, `idUtente`, `commessa`, `barcode`, `descrizione`, `data_creazione`, `time_creazione`, `qta_prelevare`, `qta_mancante`, `deleted`) VALUES
(1,	1,	'180300428900200     ',	'FAA C245-DX    ',	'COMPASSO L245/230 DX.MANIGLIA GRIG.',	'2018-09-17',	'18:18:56',	1,	0,	0),
(2,	1,	'180300428900300     ',	'FAA C245-SX    ',	'COMPASSO L245/230 SX-MANIGLIA GRIG.',	'2018-09-17',	'18:18:56',	1,	0,	0),
(3,	1,	'180300428900100     ',	'F23 1450X650S  ',	'FINESTRA COMPASSO C/SERIGRAFIA GRIG',	'2018-09-17',	'18:18:56',	1,	0,	0),
(4,	1,	'180300428900500     ',	'F23 1450X650S  ',	'FINESTRA COMPASSO C/SERIGRAFIA GRIG',	'2018-09-17',	'18:18:56',	1,	0,	0),
(5,	1,	'180800430200200     ',	'030 M16TSI     ',	'PLAFON.MODUL.16W/12V ARGENTO INTERR',	'2018-09-17',	'18:18:56',	1,	0,	0),
(6,	1,	'180300430200100     ',	'030 PL13S      ',	'LAMPADA COMP.NEON12V/13W ARG.      ',	'2018-09-17',	'18:18:56',	1,	0,	0),
(7,	1,	'180907376100500     ',	'015 G10-Z8     ',	'RACCORDO DIRITTO 10MM/TUBO 8MM X VK',	'2018-09-17',	'18:18:56',	5,	0,	0),
(8,	1,	'180907376100100     ',	'018 2006.998   ',	'AERATORE 22X1 F PER RUBINETTI      ',	'2018-09-17',	'18:18:56',	10,	0,	0),
(9,	1,	'180907376100200     ',	'018 2006.999   ',	'AERATORE 24X1 M PER MONOLEVA CROMO ',	'2018-09-17',	'18:18:56',	10,	0,	0),
(10,	1,	'180907376100100     ',	'030 HA10X10Y   ',	'LAMPADINA ALOG.12V/10W G4 BLIS.10PZ',	'2018-09-17',	'18:18:56',	1,	0,	0),
(11,	1,	'180907376100400     ',	'015 50410.14Y  ',	'TUBO GAS AP 450 CON SECURITY IT-BL.',	'2018-09-17',	'18:18:56',	3,	0,	0),
(12,	1,	'180907382700500     ',	'F48 MAN-P      ',	'MANIGLIA POLYFIX X FIN.F20/23/24/26',	'2018-09-17',	'18:18:56',	1,	0,	0);

DROP TABLE IF EXISTS `label_bindings`;
CREATE TABLE `label_bindings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label_id` varchar(255) NOT NULL,
  `barcode` varchar(255) NOT NULL,
  `descrizione` varchar(255) NOT NULL,
  `template_id` varchar(255) NOT NULL DEFAULT '0',
  `esl_datafields` varchar(5000) NOT NULL COMMENT 'FindBox Articles datafields in JSON format',
  `qr_code` varchar(255) DEFAULT NULL,
  `qta_prelevare` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `label_bindings` (`id`, `label_id`, `barcode`, `descrizione`, `template_id`, `esl_datafields`, `qr_code`, `qta_prelevare`) VALUES
(1,	'0105E104',	'180300428900100',	'180300428900100',	'dimatec2_2',	'{\"Q.ta\":0,\"Commessa\":\"180300428900100\"}',	NULL,	0),
(2,	'011133B5',	'180300428900200',	'180300428900200',	'dimatec2_2',	'{\"Q.ta\":0,\"Commessa\":\"180300428900200\"}',	NULL,	0),
(3,	'0105A8DE',	'180300428900300',	'180300428900300',	'dimatec2_2',	'{\"Q.ta\":0,\"Commessa\":\"180300428900300\"}',	NULL,	0),
(5,	'010423C5',	'180300428900500',	'180300428900500',	'dimatec2_2',	'{\"Q.ta\":0,\"Commessa\":\"180300428900500\"}',	NULL,	0),
(6,	'011282AF',	'180300430200100',	'180300430200100',	'dimatec2_2',	'{\"Q.ta\":0,\"Commessa\":\"180300430200100\"}',	NULL,	0);

DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` int(11) NOT NULL DEFAULT 0,
  `caption` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `link` varchar(255) NOT NULL DEFAULT '#',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `notifications` (`id`, `code`, `caption`, `timestamp`, `link`) VALUES
(1,	12,	'Battery labels low',	'2018-09-12 10:09:09',	'/bind'),
(2,	12,	'Battery labels low',	'2018-09-12 10:09:09',	'/bind'),
(3,	11,	'FindBox server doesn\'t respond',	'2018-09-12 10:09:27',	'/');

DROP TABLE IF EXISTS `queuesystem`;
CREATE TABLE `queuesystem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `servicename` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `command` varchar(5000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `saltedpassword` varchar(255) NOT NULL,
  `roles` varchar(4096) NOT NULL DEFAULT '{}',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `users` (`id`, `username`, `saltedpassword`, `roles`) VALUES
(1,	'operatore1',	'$2y$10$Vd0Uv.h848Xj8HtuqMBO.OvSLp8ycQpSgveHb.bH4tl72iTCgpvay',	'a:1:{i:0;s:10:\"importdata\";}');

-- 2018-09-18 13:19:15