COMMIT;

--
-- Table structure for table `wooquote_preventivo`
--

CREATE TABLE `wooquote_preventivo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `description__value` longtext DEFAULT NULL,
  `description__format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `created` int(11) DEFAULT NULL,
  `changed` int(11) DEFAULT NULL,
  `prezzo_definitivo` decimal(10,2) DEFAULT NULL,
  `field_firma_cliente` longtext DEFAULT NULL,
  `field_firmato_il` varchar(20) DEFAULT NULL COMMENT 'The date value.',
  `stato_pagamento` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `iva_ridotta_cliente_persona_fisica` tinyint(4) DEFAULT NULL,
  `iva_ridotta_data_fine_costruzione` varchar(20) DEFAULT NULL COMMENT 'The date value.',
  `iva_ridotta_costo_materiali` decimal(10,2) DEFAULT NULL,
  `iva_aliquota_suggerita` decimal(5,2) DEFAULT NULL,
  `iva_aliquota_motivo_suggerimento` varchar(255) DEFAULT NULL,
  `iva_aliquota_applicata` varchar(255) DEFAULT NULL,
  `iva_aliquota_origine` varchar(255) DEFAULT NULL,
  `iva_aliquota_nota_override` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wooquote_preventivo_field__uuid__value` (`uuid`),
  KEY `wooquote_preventivo_field__description__format` (`description__format`),
  KEY `wooquote_preventivo_field__uid__target_id` (`uid`),
  KEY `wooquote_preventivo__7c59dff664` (`field_firmato_il`),
  KEY `wooquote_preventivo__83b3102885` (`stato_pagamento`(191)),
  KEY `wooquote_preventivo_field__area__value` (`area`(191)),
  KEY `wooquote_preventivo__8065d17fcb` (`iva_ridotta_data_fine_costruzione`),
  KEY `wooquote_preventivo__06dbb56c3d` (`iva_aliquota_applicata`(191)),
  KEY `wooquote_preventivo__0ff5acf662` (`iva_aliquota_origine`(191))
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for wooquote_preventivo entities.';

--
-- Dumping data for table `wooquote_preventivo`
--

INSERT INTO `wooquote_preventivo` VALUES
(1,'8b622253-4266-4bef-9609-056aaf07f9f6','Test',1,'<p>Preventivo test</p>','basic_html',1,1775313575,1775322578,380.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'cc6b1a4c-8ef6-4bbe-a2a8-b7d70b066e7c',NULL,1,NULL,NULL,1,1775323813,1783012083,0.00,NULL,NULL,'piano_firmato',NULL,NULL,NULL,NULL,21.00,'El destinatario no es una persona física de uso privado.','21','automatico',NULL),
(4,'bdd76f8d-77c5-4522-8da0-f9ad0921b644',NULL,1,NULL,NULL,1,1776594148,1782890164,0.00,NULL,NULL,'piano_proposto',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(5,'92949550-4860-4ccf-a327-8497f19b3bd1',NULL,1,NULL,NULL,2,1776856979,1776857285,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(8,'1496e51c-1a83-4dd1-84c7-c3fe1ef55a94',NULL,1,NULL,NULL,1,1780065255,1780082161,250.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(9,'e6681f7d-91bd-42d7-97f0-5d8a7c789878',NULL,1,NULL,NULL,1,1780142866,1780143032,170.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(10,'d8723b08-c9d8-49c3-95c1-63ef979c1ba5',NULL,1,NULL,NULL,2,1782663000,1782664089,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(11,'a1a03b09-2622-45e7-95ef-1f69533f4290',NULL,1,NULL,NULL,2,1782665080,1782842768,75.00,NULL,NULL,'piano_firmato',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(12,'4e4bc0fc-167c-4e2c-b0a6-230a7e5019e7',NULL,1,NULL,NULL,2,1782721723,1782800694,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,'768fbdd0-7184-4e22-ac27-449961892f0d',NULL,1,NULL,NULL,3,1783021644,1783022143,0.00,NULL,NULL,'pagato','edilizia',1,'1974-07-02',0.00,10.00,'Requisitos cumplidos: uso privado, inmueble con más de 2 años, materiales dentro del 40%.','21','manuale',NULL);
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_cliente`
--

CREATE TABLE `wooquote_preventivo__field_cliente` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_cliente_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_cliente.';

--
-- Dumping data for table `wooquote_preventivo__field_cliente`
--

INSERT INTO `wooquote_preventivo__field_cliente` VALUES
('wooquote_preventivo',0,1,1,'und',0,'Pippo'),
('wooquote_preventivo',0,2,2,'und',0,'Pluto'),
('wooquote_preventivo',0,4,4,'und',0,'bruno'),
('wooquote_preventivo',0,5,5,'und',0,'Carl Denutte peñoncillo'),
('wooquote_preventivo',0,8,8,'und',0,'Test mobile'),
('wooquote_preventivo',0,9,9,'und',0,'Gabriele '),
('wooquote_preventivo',0,10,10,'und',0,'Carl Denutte peñoncillo'),
('wooquote_preventivo',0,11,11,'und',0,'Test'),
('wooquote_preventivo',0,12,12,'und',0,'Antonia calle nieves 19 Torrox '),
('wooquote_preventivo',0,13,13,'und',0,'Almini');
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_data`
--

CREATE TABLE `wooquote_preventivo__field_data` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_data_value` varchar(20) NOT NULL COMMENT 'The date value.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_data_value` (`field_data_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_data.';

--
-- Dumping data for table `wooquote_preventivo__field_data`
--

INSERT INTO `wooquote_preventivo__field_data` VALUES
('wooquote_preventivo',0,1,1,'und',0,'2026-04-04'),
('wooquote_preventivo',0,2,2,'und',0,'2026-04-04'),
('wooquote_preventivo',0,4,4,'und',0,'2026-04-19'),
('wooquote_preventivo',0,5,5,'und',0,'2026-04-22'),
('wooquote_preventivo',0,8,8,'und',0,'2026-05-29'),
('wooquote_preventivo',0,9,9,'und',0,'2026-05-30'),
('wooquote_preventivo',0,10,10,'und',0,'2026-06-28'),
('wooquote_preventivo',0,11,11,'und',0,'2026-06-28'),
('wooquote_preventivo',0,12,12,'und',0,'2026-06-29'),
('wooquote_preventivo',0,13,13,'und',0,'2026-07-02');
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_note`
--

CREATE TABLE `wooquote_preventivo__field_note` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_note_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_note.';

--
-- Dumping data for table `wooquote_preventivo__field_note`
--

INSERT INTO `wooquote_preventivo__field_note` VALUES
('wooquote_preventivo',0,4,4,'und',0,'reforma quarto naño'),
('wooquote_preventivo',0,5,5,'und',0,'Trabajo para instalar nuevas tubería de agua fecales 125 mm con alquilar máquina perforadora corona diamante 132 mm para pared hormigón 400 mm.\r\nVarios materiales de tuberías PVC 125 con elementos de unión \r\nMano de obra con desplazamiento incluido '),
('wooquote_preventivo',0,8,8,'und',0,'Loren ipsum'),
('wooquote_preventivo',0,9,9,'und',0,'Inodoro'),
('wooquote_preventivo',0,10,10,'und',0,'Presupuesto cambio plato ducha '),
('wooquote_preventivo',0,11,11,'und',0,'Test'),
('wooquote_preventivo',0,12,12,'und',0,'Nueva instalación tubería a vista.');
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_numero`
--

CREATE TABLE `wooquote_preventivo__field_numero` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_numero_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_numero.';

--
-- Dumping data for table `wooquote_preventivo__field_numero`
--

INSERT INTO `wooquote_preventivo__field_numero` VALUES
('wooquote_preventivo',0,1,1,'und',0,'1'),
('wooquote_preventivo',0,2,2,'und',0,'PRE-2026-0001'),
('wooquote_preventivo',0,4,4,'und',0,'PRE-2026-0003'),
('wooquote_preventivo',0,5,5,'und',0,'PRE-2026-0004'),
('wooquote_preventivo',0,8,8,'und',0,'PRE-2026-0007'),
('wooquote_preventivo',0,9,9,'und',0,'PRE-2026-0008'),
('wooquote_preventivo',0,10,10,'und',0,'PRE-2026-0009'),
('wooquote_preventivo',0,11,11,'und',0,'PRE-2026-0010'),
('wooquote_preventivo',0,12,12,'und',0,'PRE-2026-0011'),
('wooquote_preventivo',0,13,13,'und',0,'PRE-2026-0012');
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_scadenza`
--

CREATE TABLE `wooquote_preventivo__field_scadenza` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_scadenza_value` varchar(20) NOT NULL COMMENT 'The date value.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_scadenza_value` (`field_scadenza_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_scadenza.';

--
-- Dumping data for table `wooquote_preventivo__field_scadenza`
--

INSERT INTO `wooquote_preventivo__field_scadenza` VALUES
('wooquote_preventivo',0,1,1,'und',0,'2026-06-04'),
('wooquote_preventivo',0,2,2,'und',0,'2026-06-03'),
('wooquote_preventivo',0,4,4,'und',0,'2026-06-18'),
('wooquote_preventivo',0,5,5,'und',0,'2026-06-21'),
('wooquote_preventivo',0,8,8,'und',0,'2026-07-28'),
('wooquote_preventivo',0,9,9,'und',0,'2026-07-29'),
('wooquote_preventivo',0,10,10,'und',0,'2026-08-27'),
('wooquote_preventivo',0,11,11,'und',0,'2026-08-27'),
('wooquote_preventivo',0,12,12,'und',0,'2026-08-28'),
('wooquote_preventivo',0,13,13,'und',0,'2026-08-31');
COMMIT;

--
-- Table structure for table `wooquote_preventivo__field_stato`
--

CREATE TABLE `wooquote_preventivo__field_stato` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_stato_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_stato_value` (`field_stato_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_preventivo field field_stato.';

--
-- Dumping data for table `wooquote_preventivo__field_stato`
--

INSERT INTO `wooquote_preventivo__field_stato` VALUES
('wooquote_preventivo',0,1,1,'und',0,'bozza'),
('wooquote_preventivo',0,2,2,'und',0,'accettato'),
('wooquote_preventivo',0,4,4,'und',0,'accettato'),
('wooquote_preventivo',0,5,5,'und',0,'bozza'),
('wooquote_preventivo',0,8,8,'und',0,'accettato'),
('wooquote_preventivo',0,9,9,'und',0,'accettato'),
('wooquote_preventivo',0,10,10,'und',0,'accettato'),
('wooquote_preventivo',0,11,11,'und',0,'accettato'),
('wooquote_preventivo',0,12,12,'und',0,'accettato'),
('wooquote_preventivo',0,13,13,'und',0,'accettato');
COMMIT;

--
-- Table structure for table `wooquote_riga`
--

CREATE TABLE `wooquote_riga` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `description__value` longtext DEFAULT NULL,
  `description__format` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
  `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `created` int(11) DEFAULT NULL,
  `changed` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `prezzo_base` decimal(10,4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wooquote_riga_field__uuid__value` (`uuid`),
  KEY `wooquote_riga_field__description__format` (`description__format`),
  KEY `wooquote_riga_field__uid__target_id` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for wooquote_riga entities.';

--
-- Dumping data for table `wooquote_riga`
--

INSERT INTO `wooquote_riga` VALUES
(1,'0060085e-a208-4449-a455-3d0bd175559c','Grifo',1,NULL,NULL,1,1775315244,1775315468,NULL,NULL),
(3,'821f4fc1-aa27-4841-9e0b-c0be253a2271','Mano d\'opera — 6 ore',1,NULL,NULL,1,1775317589,1775321844,-97,40.5000),
(4,'e1168a14-fb35-4874-9d52-e9a1ed946cf7','Mecanismo Descarga D2D Double Pulsador',1,NULL,NULL,1,1775319430,1775321844,-98,21.5200),
(5,'154779f5-3653-45e6-871b-5292810de7de','Grifo Lavadora L86 1/2 - 3/4 ARCO',1,NULL,NULL,1,1775321794,1775321844,-100,6.5300),
(6,'39b38832-1f8e-4e55-97be-7f0271884363','Asiento Roca Victoria',1,NULL,NULL,1,1775321815,1775321844,-99,27.1900),
(7,'1fb55f2c-1ac2-4e6f-9c6e-83a15ec05d3c','rubinetto x',1,NULL,NULL,1,1775670968,1775670968,0,25.0000),
(8,'1bfce95b-0124-49aa-a721-d68b17f949d2','Manguito Inodoro MAXI',1,NULL,NULL,1,1776594172,1776594208,0,11.7600),
(9,'2fc5255c-eda6-421e-836b-ac556a987dda','Mano de obra — 4 horas',1,NULL,NULL,1,1776594230,1776594230,1000,45.0000),
(10,'d4fe1759-9164-47e6-a7d4-cfed7105eb50','prova2',1,NULL,NULL,1,1776594393,1776595703,0,35.2000),
(11,'ca83bc9d-492c-4246-b91c-374a8af9cf0f','Grifo Roca Victoria Fregadero',1,NULL,NULL,2,1776702521,1776702521,0,52.0300),
(12,'0e2a7d81-f993-4a08-bf4d-183a12c007b7','Mano de obra — 2 horas',1,NULL,NULL,2,1776702534,1776702534,1000,45.0000),
(13,'59cb6871-25f4-4269-9802-567f2839e094','hasfgc sasjjgc jgcjscg',1,NULL,NULL,2,1777126808,1777126808,0,350.0000),
(14,'12271313-554c-4711-a2a0-255444cc1022','gfjsdc jjhgsdc jhgsac',1,NULL,NULL,2,1777126891,1777126891,0,400.0000),
(15,'306a9286-d546-471c-a5fa-8ac960f8b554','Mano de obra — 4 horas',1,NULL,NULL,2,1777127083,1777127083,1000,45.0000),
(16,'e4394e98-e53b-4f17-ac32-2cbcecc7a1fa','Trabajo para instalar nuevas tubería de agua fecales 125 mm con alquilar máquina perforadora corona diamante 132 mm para pared hormigón 400 mm.\r\nVarios materiales de tuberías PVC 125 con elementos de unión \r\nMano de obra con desplazamiento incluido',1,NULL,NULL,2,1777127358,1777127930,0,500.0000),
(17,'380a227a-e780-426c-af1c-9e718aaa2c84','Grifo Genebre Fregadero Mural 11cm K8',1,NULL,NULL,1,1780065420,1780065420,0,46.3700),
(18,'49d325e1-b172-46bd-919a-35dc9e9a8727','Manita',1,NULL,NULL,1,1780065516,1780065516,0,25.0000),
(19,'16225c76-f13a-4207-9393-d9d9d306de6d','Montaje plato ducha y mampara',1,NULL,NULL,1,1780065565,1780065565,0,70.0000),
(20,'8c06ea19-9518-448e-8e66-42ebad302105','Mano de obra — 2 horas',1,NULL,NULL,1,1780065588,1780065588,1000,45.0000),
(21,'c5d704ca-6b0d-4913-9761-82cbc2c8d841','Manguito Inodoro Roca Dual',1,NULL,NULL,1,1780142885,1780142885,0,12.2500),
(22,'79426935-16a4-42d7-934b-7aa71c933bfe','Manguito Inodoro Roca Dual',1,NULL,NULL,1,1780142888,1780142888,0,12.2500),
(23,'01aa954d-fdfe-4eab-b46d-b5088b3c0b20','Mano de obra — 2 horas',1,NULL,NULL,1,1780142907,1780142907,1000,45.0000),
(24,'60b8df95-e6a7-4f21-9494-77d8f82cb1d7','Instalación',1,NULL,NULL,1,1780142930,1780142930,0,50.0000),
(25,'37f9c9a0-2bc5-43dd-ac74-1fee209004c9','Plato Ducha Roca Italia 90x90 Blanco',1,NULL,NULL,2,1782663032,1782663827,0,89.4500),
(26,'6c66b42f-a9ee-444b-9819-0dca55be3f6e','Desmontaje plato viejo',1,NULL,NULL,2,1782663066,1782663066,0,50.0000),
(27,'2cc2c458-669c-4bab-854a-a6bd798c6146','Mano de obra — 4 horas',1,NULL,NULL,2,1782663127,1782663191,1000,55.0000),
(28,'73381917-2db9-4d03-b87e-fa3586336df9','Manguito Flexible Dual 1 1/2 - 1 1/4 Tecnoagua',1,NULL,NULL,2,1782663533,1782663553,0,15.0000),
(29,'c3b0441b-32f5-426b-a860-5c4028fa4e52','Manguito Flexible Dual 1 1/2 - 1 1/4 Tecnoagua',1,NULL,NULL,1,1782665439,1782665439,0,11.3100),
(30,'efc83542-d4f0-4bd0-8a87-44818b62fba9','Posa en obra de nueva tubería multicapa 16 mm a vista en la planta baja de la vivienda conectando grifo de fregadero monomando agua fría ( grifo incluido) , lavabo del baño, y cisterna con llave de escuadra y latiguillo (llave y latiguillo incluido).\r\n…',1,NULL,NULL,2,1782722726,1782722726,0,1380.0000),
(31,'66bd337c-167c-438a-9cc2-aefcfc0ec36c','Junta Manguito Excentrico WC',1,NULL,NULL,2,1782744316,1782744352,0,12.8100),
(32,'bb3c1658-d87f-48a2-be33-746fc2657f4e','Mano de obra — 1 horas',1,NULL,NULL,2,1782744332,1782744332,1000,55.0000),
(33,'e0885103-d40c-4099-a6db-68dac44e2ec5','Borada',1,NULL,NULL,3,1783021759,1783021759,0,15.0000),
(34,'c92f5b05-b135-4784-a7f6-94e9eed5339a','Mano de obra — 8 horas',1,NULL,NULL,3,1783021784,1783021784,1000,0.0000);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_descrizione`
--

CREATE TABLE `wooquote_riga__field_descrizione` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_descrizione_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_descrizione.';

--
-- Dumping data for table `wooquote_riga__field_descrizione`
--

INSERT INTO `wooquote_riga__field_descrizione` VALUES
('wooquote_riga',0,3,3,'und',0,'Mano d\'opera'),
('wooquote_riga',0,7,7,'und',0,'rubinetto x'),
('wooquote_riga',0,9,9,'und',0,'Mano de obra'),
('wooquote_riga',0,10,10,'und',0,'prova2'),
('wooquote_riga',0,12,12,'und',0,'Mano de obra'),
('wooquote_riga',0,13,13,'und',0,'hasfgc sasjjgc jgcjscg'),
('wooquote_riga',0,14,14,'und',0,'gfjsdc jjhgsdc jhgsac'),
('wooquote_riga',0,15,15,'und',0,'Mano de obra'),
('wooquote_riga',0,16,16,'und',0,'Trabajo para instalar nuevas tubería de agua fecales 125 mm con alquilar máquina perforadora corona diamante 132 mm para pared hormigón 400 mm.\r\nVarios materiales de tuberías PVC 125 con elementos de unión \r\nMano de obra con desplazamiento incluido'),
('wooquote_riga',0,17,17,'und',0,'Grifo Genebre Fregadero Mural 11cm K8'),
('wooquote_riga',0,18,18,'und',0,'Manita'),
('wooquote_riga',0,19,19,'und',0,'Montaje plato ducha y mampara'),
('wooquote_riga',0,20,20,'und',0,'Mano de obra'),
('wooquote_riga',0,21,21,'und',0,'Manguito Inodoro Roca Dual'),
('wooquote_riga',0,22,22,'und',0,'Manguito Inodoro Roca Dual'),
('wooquote_riga',0,23,23,'und',0,'Mano de obra'),
('wooquote_riga',0,24,24,'und',0,'Instalación'),
('wooquote_riga',0,25,25,'und',0,'Plato Ducha Roca Italia 90x90 Blanco'),
('wooquote_riga',0,26,26,'und',0,'Desmontaje plato viejo'),
('wooquote_riga',0,27,27,'und',0,'Mano de obra '),
('wooquote_riga',0,28,28,'und',0,'Manguito Flexible Dual 1 1/2 - 1 1/4 Tecnoagua'),
('wooquote_riga',0,29,29,'und',0,'Manguito Flexible Dual 1 1/2 - 1 1/4 Tecnoagua'),
('wooquote_riga',0,30,30,'und',0,'Posa en obra de nueva tubería multicapa 16 mm a vista en la planta baja de la vivienda conectando grifo de fregadero monomando agua fría ( grifo incluido) , lavabo del baño, y cisterna con llave de escuadra y latiguillo (llave y latiguillo incluido).\r\n…'),
('wooquote_riga',0,31,31,'und',0,'Junta Manguito Excentrico WC'),
('wooquote_riga',0,32,32,'und',0,'Mano de obra'),
('wooquote_riga',0,33,33,'und',0,'Borada'),
('wooquote_riga',0,34,34,'und',0,'Mano de obra');
COMMIT;

--
-- Table structure for table `wooquote_riga__field_iva`
--

CREATE TABLE `wooquote_riga__field_iva` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_iva_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_iva_value` (`field_iva_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_iva.';

--
-- Dumping data for table `wooquote_riga__field_iva`
--

INSERT INTO `wooquote_riga__field_iva` VALUES
('wooquote_riga',0,1,1,'und',0,'21'),
('wooquote_riga',0,3,3,'und',0,'10'),
('wooquote_riga',0,4,4,'und',0,'21'),
('wooquote_riga',0,5,5,'und',0,'21'),
('wooquote_riga',0,6,6,'und',0,'21'),
('wooquote_riga',0,7,7,'und',0,'21'),
('wooquote_riga',0,8,8,'und',0,'21'),
('wooquote_riga',0,9,9,'und',0,'10'),
('wooquote_riga',0,10,10,'und',0,'21'),
('wooquote_riga',0,11,11,'und',0,'21'),
('wooquote_riga',0,12,12,'und',0,'10'),
('wooquote_riga',0,13,13,'und',0,'21'),
('wooquote_riga',0,14,14,'und',0,'0'),
('wooquote_riga',0,15,15,'und',0,'10'),
('wooquote_riga',0,16,16,'und',0,'0'),
('wooquote_riga',0,17,17,'und',0,'21'),
('wooquote_riga',0,18,18,'und',0,'21'),
('wooquote_riga',0,19,19,'und',0,'0'),
('wooquote_riga',0,20,20,'und',0,'10'),
('wooquote_riga',0,21,21,'und',0,'21'),
('wooquote_riga',0,22,22,'und',0,'21'),
('wooquote_riga',0,23,23,'und',0,'10'),
('wooquote_riga',0,24,24,'und',0,'0'),
('wooquote_riga',0,25,25,'und',0,'21'),
('wooquote_riga',0,26,26,'und',0,'0'),
('wooquote_riga',0,27,27,'und',0,'10'),
('wooquote_riga',0,28,28,'und',0,'21'),
('wooquote_riga',0,29,29,'und',0,'21'),
('wooquote_riga',0,30,30,'und',0,'21'),
('wooquote_riga',0,31,31,'und',0,'21'),
('wooquote_riga',0,32,32,'und',0,'10'),
('wooquote_riga',0,33,33,'und',0,'21'),
('wooquote_riga',0,34,34,'und',0,'10');
COMMIT;

--
-- Table structure for table `wooquote_riga__field_note`
--

CREATE TABLE `wooquote_riga__field_note` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_note_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_note.';

--
-- Dumping data for table `wooquote_riga__field_note`
--

INSERT INTO `wooquote_riga__field_note` VALUES
('wooquote_riga',0,13,13,'und',0,'hasfgc sasjjgc jgcjscg'),
('wooquote_riga',0,14,14,'und',0,'gfjsdc jjhgsdc jhgsac'),
('wooquote_riga',0,16,16,'und',0,'Trabajo para instalar nuevas tubería de agua fecales 125 mm con alquilar máquina perforadora corona diamante 132 mm para pared hormigón 400 mm.\r\nVarios materiales de tuberías PVC 125 con elementos de unión \r\nMano de obra con desplazamiento incluido'),
('wooquote_riga',0,19,19,'und',0,'Montaje plato ducha y mampara'),
('wooquote_riga',0,24,24,'und',0,'Instalación'),
('wooquote_riga',0,26,26,'und',0,'Desmontaje plato viejo'),
('wooquote_riga',0,30,30,'und',0,'Posa en obra de nueva tubería multicapa 16 mm a vista en la planta baja de la vivienda conectando grifo de fregadero monomando agua fría ( grifo incluido) , lavabo del baño, y cisterna con llave de escuadra y latiguillo (llave y latiguillo incluido).\r\nA continuación la tubería sigue hasta fuera en la fachada pasando por el respiradero superior de aire y bajando hasta el contador de agua intentando de poner más tramos empotrado en la fachada, (picado y tapado con cemento capafina blanca todo incluido) \r\nConexión con lla de paso a tubería en el registro del contador (llave incluida)\r\nMaterial necesario para trabajo \r\nMano de obra con desplazamiento incluido');
COMMIT;

--
-- Table structure for table `wooquote_riga__field_preventivo`
--

CREATE TABLE `wooquote_riga__field_preventivo` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_preventivo_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_preventivo_target_id` (`field_preventivo_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_preventivo.';

--
-- Dumping data for table `wooquote_riga__field_preventivo`
--

INSERT INTO `wooquote_riga__field_preventivo` VALUES
('wooquote_riga',0,3,3,'und',0,1),
('wooquote_riga',0,4,4,'und',0,1),
('wooquote_riga',0,5,5,'und',0,1),
('wooquote_riga',0,6,6,'und',0,1),
('wooquote_riga',0,7,7,'und',0,2),
('wooquote_riga',0,8,8,'und',0,4),
('wooquote_riga',0,9,9,'und',0,4),
('wooquote_riga',0,10,10,'und',0,4),
('wooquote_riga',0,11,11,'und',0,3),
('wooquote_riga',0,12,12,'und',0,3),
('wooquote_riga',0,13,13,'und',0,5),
('wooquote_riga',0,14,14,'und',0,5),
('wooquote_riga',0,15,15,'und',0,5),
('wooquote_riga',0,16,16,'und',0,7),
('wooquote_riga',0,17,17,'und',0,8),
('wooquote_riga',0,18,18,'und',0,8),
('wooquote_riga',0,19,19,'und',0,8),
('wooquote_riga',0,20,20,'und',0,8),
('wooquote_riga',0,21,21,'und',0,9),
('wooquote_riga',0,22,22,'und',0,9),
('wooquote_riga',0,23,23,'und',0,9),
('wooquote_riga',0,24,24,'und',0,9),
('wooquote_riga',0,25,25,'und',0,10),
('wooquote_riga',0,26,26,'und',0,10),
('wooquote_riga',0,27,27,'und',0,10),
('wooquote_riga',0,28,28,'und',0,10),
('wooquote_riga',0,29,29,'und',0,8),
('wooquote_riga',0,30,30,'und',0,12),
('wooquote_riga',0,31,31,'und',0,11),
('wooquote_riga',0,32,32,'und',0,11),
('wooquote_riga',0,33,33,'und',0,13),
('wooquote_riga',0,34,34,'und',0,13);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_prezzo_unitario`
--

CREATE TABLE `wooquote_riga__field_prezzo_unitario` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_prezzo_unitario_value` decimal(10,2) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_prezzo_unitario.';

--
-- Dumping data for table `wooquote_riga__field_prezzo_unitario`
--

INSERT INTO `wooquote_riga__field_prezzo_unitario` VALUES
('wooquote_riga',0,3,3,'und',0,40.50),
('wooquote_riga',0,4,4,'und',0,21.52),
('wooquote_riga',0,5,5,'und',0,6.53),
('wooquote_riga',0,6,6,'und',0,27.19),
('wooquote_riga',0,7,7,'und',0,25.00),
('wooquote_riga',0,8,8,'und',0,11.76),
('wooquote_riga',0,9,9,'und',0,45.00),
('wooquote_riga',0,10,10,'und',0,35.20),
('wooquote_riga',0,11,11,'und',0,52.03),
('wooquote_riga',0,12,12,'und',0,45.00),
('wooquote_riga',0,13,13,'und',0,350.00),
('wooquote_riga',0,14,14,'und',0,400.00),
('wooquote_riga',0,15,15,'und',0,45.00),
('wooquote_riga',0,16,16,'und',0,500.00),
('wooquote_riga',0,17,17,'und',0,46.37),
('wooquote_riga',0,18,18,'und',0,25.00),
('wooquote_riga',0,19,19,'und',0,70.00),
('wooquote_riga',0,20,20,'und',0,45.00),
('wooquote_riga',0,21,21,'und',0,12.25),
('wooquote_riga',0,22,22,'und',0,12.25),
('wooquote_riga',0,23,23,'und',0,45.00),
('wooquote_riga',0,24,24,'und',0,50.00),
('wooquote_riga',0,25,25,'und',0,89.45),
('wooquote_riga',0,26,26,'und',0,50.00),
('wooquote_riga',0,27,27,'und',0,55.00),
('wooquote_riga',0,28,28,'und',0,15.00),
('wooquote_riga',0,29,29,'und',0,11.31),
('wooquote_riga',0,30,30,'und',0,1380.00),
('wooquote_riga',0,31,31,'und',0,12.81),
('wooquote_riga',0,32,32,'und',0,55.00),
('wooquote_riga',0,33,33,'und',0,15.00),
('wooquote_riga',0,34,34,'und',0,45.00);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_prodotto`
--

CREATE TABLE `wooquote_riga__field_prodotto` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_prodotto_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_prodotto_target_id` (`field_prodotto_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_prodotto.';

--
-- Dumping data for table `wooquote_riga__field_prodotto`
--

INSERT INTO `wooquote_riga__field_prodotto` VALUES
('wooquote_riga',0,4,4,'und',0,5),
('wooquote_riga',0,5,5,'und',0,69),
('wooquote_riga',0,6,6,'und',0,73),
('wooquote_riga',0,7,7,'und',0,93),
('wooquote_riga',0,8,8,'und',0,65),
('wooquote_riga',0,10,10,'und',0,95),
('wooquote_riga',0,11,11,'und',0,66),
('wooquote_riga',0,17,17,'und',0,86),
('wooquote_riga',0,18,18,'und',0,96),
('wooquote_riga',0,21,21,'und',0,85),
('wooquote_riga',0,22,22,'und',0,85),
('wooquote_riga',0,25,25,'und',0,80),
('wooquote_riga',0,28,28,'und',0,81),
('wooquote_riga',0,29,29,'und',0,81),
('wooquote_riga',0,31,31,'und',0,97),
('wooquote_riga',0,33,33,'und',0,98);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_quantita`
--

CREATE TABLE `wooquote_riga__field_quantita` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_quantita_value` decimal(10,2) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_quantita.';

--
-- Dumping data for table `wooquote_riga__field_quantita`
--

INSERT INTO `wooquote_riga__field_quantita` VALUES
('wooquote_riga',0,1,1,'und',0,1.00),
('wooquote_riga',0,3,3,'und',0,6.00),
('wooquote_riga',0,4,4,'und',0,2.00),
('wooquote_riga',0,5,5,'und',0,1.00),
('wooquote_riga',0,6,6,'und',0,2.00),
('wooquote_riga',0,7,7,'und',0,1.00),
('wooquote_riga',0,8,8,'und',0,1.00),
('wooquote_riga',0,9,9,'und',0,4.00),
('wooquote_riga',0,10,10,'und',0,1.00),
('wooquote_riga',0,11,11,'und',0,1.00),
('wooquote_riga',0,12,12,'und',0,2.00),
('wooquote_riga',0,13,13,'und',0,1.00),
('wooquote_riga',0,14,14,'und',0,1.00),
('wooquote_riga',0,15,15,'und',0,4.00),
('wooquote_riga',0,16,16,'und',0,1.00),
('wooquote_riga',0,17,17,'und',0,1.00),
('wooquote_riga',0,18,18,'und',0,1.00),
('wooquote_riga',0,19,19,'und',0,1.00),
('wooquote_riga',0,20,20,'und',0,2.00),
('wooquote_riga',0,21,21,'und',0,1.00),
('wooquote_riga',0,22,22,'und',0,1.00),
('wooquote_riga',0,23,23,'und',0,2.00),
('wooquote_riga',0,24,24,'und',0,1.00),
('wooquote_riga',0,25,25,'und',0,1.00),
('wooquote_riga',0,26,26,'und',0,1.00),
('wooquote_riga',0,27,27,'und',0,4.00),
('wooquote_riga',0,28,28,'und',0,1.00),
('wooquote_riga',0,29,29,'und',0,1.00),
('wooquote_riga',0,30,30,'und',0,1.00),
('wooquote_riga',0,31,31,'und',0,1.00),
('wooquote_riga',0,32,32,'und',0,1.00),
('wooquote_riga',0,33,33,'und',0,1.00),
('wooquote_riga',0,34,34,'und',0,8.00);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_sconto`
--

CREATE TABLE `wooquote_riga__field_sconto` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_sconto_value` decimal(10,2) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_sconto.';

--
-- Dumping data for table `wooquote_riga__field_sconto`
--

INSERT INTO `wooquote_riga__field_sconto` VALUES
('wooquote_riga',0,1,1,'und',0,5.00),
('wooquote_riga',0,3,3,'und',0,0.00),
('wooquote_riga',0,4,4,'und',0,11.00),
('wooquote_riga',0,5,5,'und',0,0.00),
('wooquote_riga',0,6,6,'und',0,0.00),
('wooquote_riga',0,7,7,'und',0,0.00),
('wooquote_riga',0,8,8,'und',0,10.00),
('wooquote_riga',0,9,9,'und',0,0.00),
('wooquote_riga',0,10,10,'und',0,0.00),
('wooquote_riga',0,11,11,'und',0,0.00),
('wooquote_riga',0,12,12,'und',0,0.00),
('wooquote_riga',0,13,13,'und',0,0.00),
('wooquote_riga',0,14,14,'und',0,0.00),
('wooquote_riga',0,15,15,'und',0,0.00),
('wooquote_riga',0,16,16,'und',0,10.00),
('wooquote_riga',0,17,17,'und',0,0.00),
('wooquote_riga',0,18,18,'und',0,0.00),
('wooquote_riga',0,19,19,'und',0,0.00),
('wooquote_riga',0,20,20,'und',0,0.00),
('wooquote_riga',0,21,21,'und',0,0.00),
('wooquote_riga',0,22,22,'und',0,0.00),
('wooquote_riga',0,23,23,'und',0,0.00),
('wooquote_riga',0,24,24,'und',0,0.00),
('wooquote_riga',0,25,25,'und',0,0.00),
('wooquote_riga',0,26,26,'und',0,0.00),
('wooquote_riga',0,27,27,'und',0,0.00),
('wooquote_riga',0,28,28,'und',0,0.00),
('wooquote_riga',0,29,29,'und',0,0.00),
('wooquote_riga',0,30,30,'und',0,0.00),
('wooquote_riga',0,31,31,'und',0,0.00),
('wooquote_riga',0,32,32,'und',0,0.00),
('wooquote_riga',0,33,33,'und',0,0.00),
('wooquote_riga',0,34,34,'und',0,0.00);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_tipo_riga`
--

CREATE TABLE `wooquote_riga__field_tipo_riga` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_tipo_riga_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_tipo_riga_value` (`field_tipo_riga_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_tipo_riga.';

--
-- Dumping data for table `wooquote_riga__field_tipo_riga`
--

INSERT INTO `wooquote_riga__field_tipo_riga` VALUES
('wooquote_riga',0,1,1,'und',0,'materiale'),
('wooquote_riga',0,3,3,'und',0,'manodopera'),
('wooquote_riga',0,4,4,'und',0,'materiale'),
('wooquote_riga',0,5,5,'und',0,'materiale'),
('wooquote_riga',0,6,6,'und',0,'materiale'),
('wooquote_riga',0,7,7,'und',0,'materiale'),
('wooquote_riga',0,8,8,'und',0,'materiale'),
('wooquote_riga',0,9,9,'und',0,'manodopera'),
('wooquote_riga',0,10,10,'und',0,'materiale'),
('wooquote_riga',0,11,11,'und',0,'materiale'),
('wooquote_riga',0,12,12,'und',0,'manodopera'),
('wooquote_riga',0,13,13,'und',0,'adhoc'),
('wooquote_riga',0,14,14,'und',0,'adhoc'),
('wooquote_riga',0,15,15,'und',0,'manodopera'),
('wooquote_riga',0,16,16,'und',0,'adhoc'),
('wooquote_riga',0,17,17,'und',0,'materiale'),
('wooquote_riga',0,18,18,'und',0,'materiale'),
('wooquote_riga',0,19,19,'und',0,'adhoc'),
('wooquote_riga',0,20,20,'und',0,'manodopera'),
('wooquote_riga',0,21,21,'und',0,'materiale'),
('wooquote_riga',0,22,22,'und',0,'materiale'),
('wooquote_riga',0,23,23,'und',0,'manodopera'),
('wooquote_riga',0,24,24,'und',0,'adhoc'),
('wooquote_riga',0,25,25,'und',0,'materiale'),
('wooquote_riga',0,26,26,'und',0,'adhoc'),
('wooquote_riga',0,27,27,'und',0,'manodopera'),
('wooquote_riga',0,28,28,'und',0,'materiale'),
('wooquote_riga',0,29,29,'und',0,'materiale'),
('wooquote_riga',0,30,30,'und',0,'adhoc'),
('wooquote_riga',0,31,31,'und',0,'materiale'),
('wooquote_riga',0,32,32,'und',0,'manodopera'),
('wooquote_riga',0,33,33,'und',0,'materiale'),
('wooquote_riga',0,34,34,'und',0,'manodopera');
COMMIT;

--
-- Table structure for table `wooquote_riga__field_totale_riga`
--

CREATE TABLE `wooquote_riga__field_totale_riga` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_totale_riga_value` decimal(10,2) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_totale_riga.';

--
-- Dumping data for table `wooquote_riga__field_totale_riga`
--

INSERT INTO `wooquote_riga__field_totale_riga` VALUES
('wooquote_riga',0,1,1,'und',0,0.00),
('wooquote_riga',0,3,3,'und',0,243.00),
('wooquote_riga',0,4,4,'und',0,38.31),
('wooquote_riga',0,5,5,'und',0,6.53),
('wooquote_riga',0,6,6,'und',0,54.38),
('wooquote_riga',0,7,7,'und',0,25.00),
('wooquote_riga',0,8,8,'und',0,10.58),
('wooquote_riga',0,9,9,'und',0,180.00),
('wooquote_riga',0,10,10,'und',0,35.20),
('wooquote_riga',0,11,11,'und',0,52.03),
('wooquote_riga',0,12,12,'und',0,90.00),
('wooquote_riga',0,13,13,'und',0,350.00),
('wooquote_riga',0,14,14,'und',0,400.00),
('wooquote_riga',0,15,15,'und',0,180.00),
('wooquote_riga',0,16,16,'und',0,450.00),
('wooquote_riga',0,17,17,'und',0,46.37),
('wooquote_riga',0,18,18,'und',0,25.00),
('wooquote_riga',0,19,19,'und',0,70.00),
('wooquote_riga',0,20,20,'und',0,90.00),
('wooquote_riga',0,21,21,'und',0,12.25),
('wooquote_riga',0,22,22,'und',0,12.25),
('wooquote_riga',0,23,23,'und',0,90.00),
('wooquote_riga',0,24,24,'und',0,50.00),
('wooquote_riga',0,25,25,'und',0,89.45),
('wooquote_riga',0,26,26,'und',0,50.00),
('wooquote_riga',0,27,27,'und',0,220.00),
('wooquote_riga',0,28,28,'und',0,15.00),
('wooquote_riga',0,29,29,'und',0,11.31),
('wooquote_riga',0,30,30,'und',0,1380.00),
('wooquote_riga',0,31,31,'und',0,12.81),
('wooquote_riga',0,32,32,'und',0,55.00),
('wooquote_riga',0,33,33,'und',0,15.00),
('wooquote_riga',0,34,34,'und',0,360.00);
COMMIT;

--
-- Table structure for table `wooquote_riga__field_unita_di_misura`
--

CREATE TABLE `wooquote_riga__field_unita_di_misura` (
  `bundle` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to, which for an unversioned entity type is the same as the entity id',
  `langcode` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_unita_di_misura_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_unita_di_misura_value` (`field_unita_di_misura_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Data storage for wooquote_riga field field_unita_di_misura.';

--
-- Dumping data for table `wooquote_riga__field_unita_di_misura`
--

INSERT INTO `wooquote_riga__field_unita_di_misura` VALUES
('wooquote_riga',0,1,1,'und',0,'pezzo'),
('wooquote_riga',0,3,3,'und',0,'h'),
('wooquote_riga',0,9,9,'und',0,'h'),
('wooquote_riga',0,12,12,'und',0,'h'),
('wooquote_riga',0,15,15,'und',0,'h'),
('wooquote_riga',0,20,20,'und',0,'h'),
('wooquote_riga',0,23,23,'und',0,'h'),
('wooquote_riga',0,27,27,'und',0,'h'),
('wooquote_riga',0,32,32,'und',0,'h'),
('wooquote_riga',0,34,34,'und',0,'h');
COMMIT;

--
-- Table structure for table `wooquote_token`
--

CREATE TABLE `wooquote_token` (
  `token` varchar(64) NOT NULL,
  `preventivo_id` int(10) unsigned NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `expires` int(10) unsigned NOT NULL,
  `used` tinyint(4) NOT NULL DEFAULT 0,
  `ip_firma` varchar(45) DEFAULT '',
  PRIMARY KEY (`token`),
  KEY `preventivo_id` (`preventivo_id`),
  KEY `expires` (`expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Token temporanei per la firma pubblica dei preventivi.';

--
-- Dumping data for table `wooquote_token`
--

INSERT INTO `wooquote_token` VALUES
('5b5ffeee62fb54694f901cba66cc522738f93cb4b917c47c0839c928e2a5af5d',2,1783012037,1783184837,1,'79.116.219.72'),
('75b0cd6362f381b6439bf4d19145ae82df2245643d05e0ebef074da3caed6d1f',13,1783021917,1783194717,1,'79.116.219.72');
COMMIT;

--
-- Table structure for table `woourgenza_urgenza`
--

CREATE TABLE `woourgenza_urgenza` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `field_categoria` int(10) unsigned DEFAULT NULL COMMENT 'The ID of the target entity.',
  `field_data_urgenza` varchar(20) DEFAULT NULL COMMENT 'The date value.',
  `field_indirizzo__langcode` varchar(32) DEFAULT NULL,
  `field_indirizzo__country_code` varchar(2) DEFAULT NULL,
  `field_indirizzo__administrative_area` varchar(255) DEFAULT NULL,
  `field_indirizzo__locality` varchar(255) DEFAULT NULL,
  `field_indirizzo__dependent_locality` varchar(255) DEFAULT NULL,
  `field_indirizzo__postal_code` varchar(255) DEFAULT NULL,
  `field_indirizzo__sorting_code` varchar(255) DEFAULT NULL,
  `field_indirizzo__address_line1` varchar(255) DEFAULT NULL,
  `field_indirizzo__address_line2` varchar(255) DEFAULT NULL,
  `field_indirizzo__address_line3` varchar(255) DEFAULT NULL,
  `field_indirizzo__organization` varchar(255) DEFAULT NULL,
  `field_indirizzo__given_name` varchar(255) DEFAULT NULL,
  `field_indirizzo__additional_name` varchar(255) DEFAULT NULL,
  `field_indirizzo__family_name` varchar(255) DEFAULT NULL,
  `field_distanza` int(11) DEFAULT NULL,
  `uid` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  `created` int(11) DEFAULT NULL,
  `changed` int(11) DEFAULT NULL,
  `field_servizio` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `woourgenza_urgenza_field__uuid__value` (`uuid`),
  KEY `woourgenza_urgenza__ad3b989b1d` (`field_categoria`),
  KEY `woourgenza_urgenza__0e9e3bbfe1` (`field_data_urgenza`),
  KEY `woourgenza_urgenza_field__uid__target_id` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='The base table for woourgenza_urgenza entities.';

--
-- Dumping data for table `woourgenza_urgenza`
--

INSERT INTO `woourgenza_urgenza` VALUES
(7,'6c6ce68c-feff-4f6e-b66f-e3a1b5ba7ece',NULL,1,49,'2026-06-28','es','ES','MA','Torrox ',NULL,'29700',NULL,'Calle Uno, 2','','',NULL,NULL,NULL,NULL,35,2,1782662380,1782662687,'Test'),
(8,'4ddd1203-8295-4b2d-b7dd-55741d387f76',NULL,1,49,'2026-06-18','es','ES','MA','Rincón De La Victoria ',NULL,'29700',NULL,'Calle Yup','','',NULL,NULL,NULL,NULL,80,2,1782662764,1782662764,'47378'),
(9,'303a9daa-46e7-4e54-b261-9047402d0507','546798 – 2026-06-29',1,49,'2026-06-29','es','ES','MA','Torremolinos',NULL,'',NULL,'Calle Europa','','',NULL,NULL,NULL,NULL,74,2,1782732186,1782732186,'546798');
COMMIT;


