· 4 years ago · Mar 03, 2021, 12:02 PM
1-- MySQL dump 10.13 Distrib 8.0.18, for Win64 (x86_64)
2--
3-- Host: ecommerce.c3n1guwmv7qu.us-east-2.rds.amazonaws.com Database: ecommerce
4-- ------------------------------------------------------
5-- Server version 8.0.17
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
18SET @@SESSION.SQL_LOG_BIN= 0;
19
20--
21-- GTID state at the beginning of the backup
22--
23
24SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';
25
26--
27-- Table structure for table `utenti`
28--
29
30DROP TABLE IF EXISTS `utenti`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!50503 SET character_set_client = utf8mb4 */;
33CREATE TABLE `utenti` (
34 `tipo_cliente` varchar(10) DEFAULT NULL,
35 `nome` varchar(20) DEFAULT NULL,
36 `cognome` varchar(20) DEFAULT NULL,
37 `email` varchar(50) NOT NULL,
38 `telefono` varchar(10) DEFAULT NULL,
39 `passwd` varchar(100) DEFAULT NULL,
40 `data_` varchar(20) DEFAULT NULL,
41 `userID` int(11) NOT NULL AUTO_INCREMENT,
42 PRIMARY KEY (`userID`)
43) ENGINE=InnoDB AUTO_INCREMENT=93257 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `utenti`
48--
49
50LOCK TABLES `utenti` WRITE;
51/*!40000 ALTER TABLE `utenti` DISABLE KEYS */;
52INSERT INTO `utenti` VALUES ('Privato','Veronica ','La versa','Veronica.laversa@gmail.com','3387812663','cfb21c4be1ad8f2c9305897143e6c120','05/12/2020, 13:21:40',5243),('Privato','Engineer','efficient','shaylaouellette90@gmail.com','1961689349','ce83529423ce083ea5b1fabc2f4ccce2','20/02/2021, 16:34:20',9350),('Privato','Asia','Bisogno','asiabisogno2000@icloud.com','3929754064','6adfd13b9688a1cf0f7f490567cc9e72','21/11/2020, 10:13:16',10679),('Privato','Mariachiara','Liccardi','mery_liccardi@libero.it',NULL,'c6f03a5c5c3e7c43c5784e19185c7207','5/11/2020, 23:24:00',12899),('Privato','lavender','auxiliary','zeke0815070@yahoo.com','1079640484','9bb522545e44cbe2ab6ca24d9b6f658b','18/02/2021, 19:38:54',15256),('Privato','Valentina','Critelli','saracigli.97@gmail.com','3299718207','f8cc211ef8d7e193dd07ddba844f3c8d','06/11/2020, 16:03:41',21738),('Privato','emanuela','cappi','cemanuela69@gmail.com','3472621429','5621a180ae52dce4483c860a64a2ff9e','21/11/2020, 10:26:59',22299),('Privato','Francesca','Demurtas','francesca.demurtas84@gmail.com','3334973563','37a1561fb33a81af0f9ae1062a5f5709','04/12/2020, 15:30:58',22685),('Privato','Eleonora','Zona','eleonora.zona26@gmail.com','3473662989','e1f8eb09e022008f3d73d7211044b574','13/11/2020, 14:41:06',26949),('Privato','Eritrea','bluetooth','Finn.White@gmail.com','1799313934','b934a8491de6806bc377262f3150044e','24/01/2021, 15:41:19',28989),('Cliente','Enrica','Dallari','kikkadallari@gmail.com','335434305','d65f2804b4884f4f62ce4f3ecb9a59d6','3/11/2020, 21:00:00',32323),('Privato','incentivize','interfaces','info@shishabucks.com','1380441361','b76d38872a464e487dd2ed1bccbcb057','26/01/2021, 15:14:03',33046),('Cliente','Patrizia','Corrado','patrizia.corrado@gmail.com',NULL,NULL,'4/11/2020, 23:00:00',36241),('Cliente','JESSICA','TELANI','jetela96@gmail.com',NULL,NULL,'4/11/2020, 22:44:00',41000),('Cliente','Barbara','Luraghi','cen.esteticobarbara@gmail.com',NULL,NULL,'4/11/2020, 22:25:00',41195),('Cliente','LAURA','SARACI','laurasaraci@hotmail.com',NULL,NULL,'4/11/2020, 22:45:00',44854),('Cliente','Chiara','Cataldi','chiara.cataldi123@gmail.com',NULL,NULL,'4/11/2020, 22:57:00',47180),('Cliente','Alessandra','Fabrizio','ale19_83@yahoo.it',NULL,NULL,'4/11/2020, 22:12:00',54658),('Privato','Iuliana','Jepu','iuliana.jepu91@gmail.com','3468441735','31d9f513cdd15c8502f6ccdae07ca57d','14/11/2020, 17:30:31',54715),('Privato','Nicole','Beccaletto','Nicolemax@live.it','3451268770','69670b7c210d3e4af3a8bf9273f4664d','13/11/2020, 09:11:02',57119),('Privato','bandwidth','extranet','evelyn_fer@yahoo.com','1441365029','36ce418899544852104ae59a3625c146','28/01/2021, 19:50:22',63350),('Privato','Veronica ','Cuoghi ','veronica.cuoghi@gmail.com','3927007246','509c07c8ce80afb3bdcf6649ad4260bc','26/01/2021, 15:20:10',63774),('Privato','Rustic','transmitting','edwardmaguire@yahoo.com','1011207682','1ca412cb9d53962c4284d342ac918297','17/02/2021, 09:28:31',67887),('Privato','bandwidth','Austria','klbeckley@aol.com','1535378617','f1c437aad7c6f5a7d155649c65e1ae89','27/01/2021, 19:27:21',69194),('Privato','Shirt','Money Market Account','leo.l@ciktel.com','1354513196','7a1ceb397cdaf3837a0e3b569961f4ca','11/02/2021, 18:08:18',71875),('Cliente','LINDA','BRONTI','lillibronti77@gmail.com',NULL,'9e6361ad9cd49b4f6e8efa35aba9ad50','4/11/2020, 22:47:00',71999),('Privato','Landing','CSS','ljohnston40@gmail.com','1282299814','ab98b4406bb7e2ac6f90170286250b51','23/02/2021, 19:11:46',74533),('Privato','Annamaria ','Fichele ','anna.fichele@libero.it','3407855833','4b7f3ae6f1b5bfc2cee79f22ba0d936a','05/12/2020, 14:29:51',77470),('Privato','Caterina ','Dello iacono','katy287@hotmail.it','3888150845','712ad1a92292e04a4ca95fc3898372a2','23/02/2021, 19:52:16',80710),('Privato','Natalila','Di Giuliano','natalinadigiuliano@Yahoo.it','3392378638','07fcd70d07dd3c2df1b8e738e8fddad3','06/11/2020, 15:33:05',82881),('Cliente','Monica','Serighelli','harmonialainate@gmail.com',NULL,NULL,'4/11/2020, 22:48:00',87208),('Privato','Vanna ','Frassineti','vannantonio@libero.it','3471374431','3fad04cc37d6cb6749f0af40fab9a7a8','25/02/2021, 19:23:13',90650);
53/*!40000 ALTER TABLE `utenti` ENABLE KEYS */;
54UNLOCK TABLES;
55SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
56/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
57
58/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
59/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
60/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
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 */;
64/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
65
66-- Dump completed on 2021-03-03 12:55:07
67