· 4 years ago · Mar 05, 2021, 09:42 PM
1DROP TABLE IF EXISTS `categorie`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!50503 SET character_set_client = utf8mb4 */;
4CREATE TABLE `categorie` (
5 `nome` varchar(30) DEFAULT NULL,
6 `id` int NOT NULL AUTO_INCREMENT,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
9/*!40101 SET character_set_client = @saved_cs_client */;
10
11--
12-- Dumping data for table `categorie`
13--
14
15LOCK TABLES `categorie` WRITE;
16/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
17INSERT INTO `categorie` VALUES ('Monouso',17),('Parruchieri',18),('Estetica',20),('Peggy sage',21),('Profumeria',22),('Cura della persona',23);
18/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
19UNLOCK TABLES;