ie5xFEUs

1SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
2SET @@SESSION.SQL_LOG_BIN= 0;
3
4--
5-- GTID state at the beginning of the backup 
6--
7
8SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';
9
10--
11-- Table structure for table `categorie`
12--
13
14DROP TABLE IF EXISTS `categorie`;
15/*!40101 SET @saved_cs_client     = @@character_set_client */;
16/*!50503 SET character_set_client = utf8mb4 */;
17CREATE TABLE `categorie` (
18  `nome` varchar(30) DEFAULT NULL,
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
22/*!40101 SET character_set_client = @saved_cs_client */;
23
24--
25-- Dumping data for table `categorie`
26--
27
28LOCK TABLES `categorie` WRITE;
29/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
30INSERT INTO `categorie` VALUES ('Monouso',17),('Parruchieri',18),('Estetica',20),('Peggy sage',21),('Profumeria',22),('Cura della persona',23),('Super offerte -50%',24),('Uomo',25);
31/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
32UNLOCK TABLES;
33
34--
35-- Table structure for table `dati_aziendali`
36--
37
38DROP TABLE IF EXISTS `dati_aziendali`;
39/*!40101 SET @saved_cs_client     = @@character_set_client */;
40/*!50503 SET character_set_client = utf8mb4 */;
41CREATE TABLE `dati_aziendali` (
42  `nome_azienda` varchar(30) DEFAULT NULL,
43  `p_iva` varchar(11) DEFAULT NULL,
44  `cod_fiscale` varchar(16) DEFAULT NULL,
45  `userID` int(11) NOT NULL,
46  PRIMARY KEY (`userID`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `dati_aziendali`
52--
53
54LOCK TABLES `dati_aziendali` WRITE;
55/*!40000 ALTER TABLE `dati_aziendali` DISABLE KEYS */;
56INSERT INTO `dati_aziendali` VALUES ('VAIASINNI FILIPPO PROFUMERIA','02361650365','vsnfpp69l27a070x',33537);
57/*!40000 ALTER TABLE `dati_aziendali` ENABLE KEYS */;
58UNLOCK TABLES;
59
60--
61-- Table structure for table `indirizzi_fatturazione`
62--
63
64DROP TABLE IF EXISTS `indirizzi_fatturazione`;
65/*!40101 SET @saved_cs_client     = @@character_set_client */;
66/*!50503 SET character_set_client = utf8mb4 */;
67CREATE TABLE `indirizzi_fatturazione` (
68  `via_numero_civico` varchar(50) DEFAULT NULL,
69  `cap` varchar(5) DEFAULT NULL,
70  `città` varchar(20) DEFAULT NULL,
71  `userID` int(11) NOT NULL,
72  PRIMARY KEY (`userID`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
74/*!40101 SET character_set_client = @saved_cs_client */;
75
76--
77-- Dumping data for table `indirizzi_fatturazione`
78--
79
80LOCK TABLES `indirizzi_fatturazione` WRITE;
81/*!40000 ALTER TABLE `indirizzi_fatturazione` DISABLE KEYS */;
82INSERT INTO `indirizzi_fatturazione` VALUES ('VIA S. ANTONIO 12 /F','41043','FORMIGINE',5243),('CROSS-PLATFORM','West ','SLEEK METAL HAT',9350),('CARLO COLLODI 1','41042','FIORANO ',10679),('GRANITE','white','INTELLIGENT',15256),('VIA STRADELLA N.6 ','41043','FORMIGINE ',21738),('VIA TEVERE,42','41042','FIORANO MODENESE',22299),('VIA ENZO NOBILI 7','41043','FORMIGINE',22685),('VIA FONDO VAL TIEPIDO 7','41053','GORZANO',26949),('SWAZILAND','Cotto','SUPPLY-CHAINS',28989),('Via Abetone sup. 169/3','41053','Maranello',32323),('COM','synth','DELAWARE',33046),('VIA MODENA 86','41014','CASTELVETRO DI MODEN',36480),('VIA TEVERE 42','41042','FIORANO MODENESE',52761),('SARDEGNA  6','41053','MARANELLO ',54715),('GANDHI 5','38123','TRENTO',57119),('SHIRT','China','GROVE',63350),('VIA MALMUSI 62/D','41042','FIORANO MODENESE ',63774),('LICENSED GRANITE GLOVES','progr','HAPTIC',67887),('MONEY MARKET ACCOUNT','Custo','LEGACY',69194),('REGIONAL','users','RANCH',71875),('VIA AOSTA 60','42013','CASALGRANDE',72240),('FACILITATE','Credi','SALMON',74533),('VIA NIRANO 1 TRONCO N 30','41042','FIORANO MODENESE ',76569),('VIA MEKONG 4 ','41042','FIORANO MODENESE ',77470),('GRAZIOSI 39','41053','MARANELLO',80710),('STATALE 26','41042','FIORANO MODENESE',82881),('VIA TEVERE 52 ','41042','FIORANO MODENESE ',90650);
83/*!40000 ALTER TABLE `indirizzi_fatturazione` ENABLE KEYS */;
84UNLOCK TABLES;
85
86--
87-- Table structure for table `indirizzi_spedizione`
88--
89
90DROP TABLE IF EXISTS `indirizzi_spedizione`;
91/*!40101 SET @saved_cs_client     = @@character_set_client */;
92/*!50503 SET character_set_client = utf8mb4 */;
93CREATE TABLE `indirizzi_spedizione` (
94  `via_numero_civico` varchar(50) DEFAULT NULL,
95  `cap` varchar(5) DEFAULT NULL,
96  `città` varchar(20) DEFAULT NULL,
97  `userID` int(11) NOT NULL,
98  PRIMARY KEY (`userID`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
100/*!40101 SET character_set_client = @saved_cs_client */;
101
102--
103-- Dumping data for table `indirizzi_spedizione`
104--
105
106LOCK TABLES `indirizzi_spedizione` WRITE;
107/*!40000 ALTER TABLE `indirizzi_spedizione` DISABLE KEYS */;
108/*!40000 ALTER TABLE `indirizzi_spedizione` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `ordini`
113--
114
115DROP TABLE IF EXISTS `ordini`;
116/*!40101 SET @saved_cs_client     = @@character_set_client */;
117/*!50503 SET character_set_client = utf8mb4 */;
118CREATE TABLE `ordini` (
119  `id` varchar(15) NOT NULL,
120  `userID` int(11) DEFAULT NULL,
121  `_data` varchar(20) DEFAULT NULL,
122  `mod_spedizione` varchar(20) DEFAULT NULL,
123  `mod_pagamento` varchar(20) DEFAULT NULL,
124  `stato_pagamento` varchar(20) DEFAULT NULL,
125  `totale` float DEFAULT NULL,
126  PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `ordini`
132--
133
134LOCK TABLES `ordini` WRITE;
135/*!40000 ALTER TABLE `ordini` DISABLE KEYS */;
136INSERT INTO `ordini` VALUES ('DFL_VQ886KIFZT',36480,'16/03/2021, 12:11:06','ritiro','paga_in_negozio','Pagato',47);
137/*!40000 ALTER TABLE `ordini` ENABLE KEYS */;
138UNLOCK TABLES;
139
140--
141-- Table structure for table `ordini_prodotti`
142--
143
144DROP TABLE IF EXISTS `ordini_prodotti`;
145/*!40101 SET @saved_cs_client     = @@character_set_client */;
146/*!50503 SET character_set_client = utf8mb4 */;
147CREATE TABLE `ordini_prodotti` (
148  `ordine_id` varchar(15) DEFAULT NULL,
149  `prod_id` varchar(20) DEFAULT NULL,
150  `qty` int(11) DEFAULT NULL
151) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
152/*!40101 SET character_set_client = @saved_cs_client */;
153
154--
155-- Dumping data for table `ordini_prodotti`
156--
157
158LOCK TABLES `ordini_prodotti` WRITE;
159/*!40000 ALTER TABLE `ordini_prodotti` DISABLE KEYS */;
160INSERT INTO `ordini_prodotti` VALUES ('DFL_VQ886KIFZT','DEV4046',1),('DFL_VQ886KIFZT','BaseTop',2),('DFL_VQ886KIFZT','901761',1),('DFL_VQ886KIFZT','5008',1);
161/*!40000 ALTER TABLE `ordini_prodotti` ENABLE KEYS */;
162UNLOCK TABLES;
163
164--
165-- Table structure for table `prodotti`
166--
167
168DROP TABLE IF EXISTS `prodotti`;
169/*!40101 SET @saved_cs_client     = @@character_set_client */;
170/*!50503 SET character_set_client = utf8mb4 */;
171CREATE TABLE `prodotti` (
172  `prod_id` varchar(20) NOT NULL,
173  `prod_nome` varchar(100) DEFAULT NULL,
174  `prod_marca` varchar(20) DEFAULT NULL,
175  `prod_desc` text,
176  `prod_pezzi` int(11) DEFAULT NULL,
177  `prod_prezzo` float DEFAULT NULL,
178  `prod_prezzoscontato` float DEFAULT NULL,
179  `prod_tag` varchar(20) DEFAULT NULL,
180  `prod_categoria` varchar(50) DEFAULT NULL,
181  `prod_img` varchar(50) DEFAULT NULL,
182  `prod_qtmagazzino` int(11) DEFAULT NULL,
183  PRIMARY KEY (`prod_id`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
185/*!40101 SET character_set_client = @saved_cs_client */;