phpengine/omlink.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`;

CREATE TABLE `distinte` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUtente` int(11) NOT NULL DEFAULT -1 COMMENT 'Utente che sta movimentando ',
  `order` varchar(255) NOT NULL DEFAULT '' COMMENT 'Numero d''ordine/Commessa',
  `barcode` varchar(255) NOT NULL DEFAULT '' COMMENT 'ESL Label id, lo stesso della tabella label_bindings',
  `description` varchar(255) NOT NULL DEFAULT '',
  `extracode` varchar(255) NOT NULL COMMENT 'Codice cliente',
  `date` date NOT NULL DEFAULT current_timestamp(),
  `time` time NOT NULL DEFAULT current_timestamp(),
  `qta_to_move` int(11) NOT NULL DEFAULT 0 COMMENT 'Quantità da movimentare',
  `qta_moved` int(11) NOT NULL DEFAULT 0 COMMENT 'Qunatità effettiva movimentata',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'stato movimentazione, impostare degli ENUM',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `label_bindings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label_id` varchar(255) NOT NULL,
  `barcode` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


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
(2,	11,	'Errore: Servizio di FindBox non disponibile',	'2018-10-11 16:07:03',	'#');

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;


CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `saltedpassword` varchar(255) NOT NULL COMMENT 'password_hash("username|password", PASS',
  `roles` varchar(4096) NOT NULL DEFAULT '{}' COMMENT 'PHP Serialized Array',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

-- 2018-10-15 15:28:06