FPY2N6PD

1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Creato il: Dic 17, 2018 alle 12:04
7-- Versione del server: 5.7.21
8-- Versione PHP: 5.6.35
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `ticketing`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Struttura della tabella `ticketing_typologyaction`
29--
30
31DROP TABLE IF EXISTS `ticketing_typologyaction`;
32CREATE TABLE IF NOT EXISTS `ticketing_typologyaction` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `name` int(11) NOT NULL,
35  `typology_action_id` int(11) DEFAULT NULL,
36  `italian_name` varchar(255) NOT NULL,
37  PRIMARY KEY (`id`),
38  KEY `ticketing_typologyaction_typology_action_id_16dae239` (`typology_action_id`)
39) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
40
41--
42-- Dump dei dati per la tabella `ticketing_typologyaction`
43--
44
45INSERT INTO `ticketing_typologyaction` (`id`, `name`, `typology_action_id`, `italian_name`) VALUES
46(1, 1, NULL, 'Messaggio'),
47(2, 2, NULL, 'Questionario'),
48(3, 4, NULL, 'Condizione'),
49(4, 3, NULL, 'Salto'),
50(5, 5, NULL, 'Separa'),
51(6, 6, NULL, 'Unisci'),
52(7, 7, NULL, 'Condizione Logica'),
53(8, 8, NULL, 'Rest'),
54(9, 9, NULL, 'Carica File'),
55(10, 10, NULL, 'Scarica File'),
56(11, 11, NULL, 'Email'),
57(12, -1, NULL, ''),
58(13, -2, NULL, '');
59COMMIT;
60
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;