hhawdfawd.sql

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Versione server:              5.7.44-log - MySQL Community Server (GPL)
-- S.O. server:                  Win64
-- HeidiSQL Versione:            12.7.0.6850
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dump della struttura del database grauv8
CREATE DATABASE IF NOT EXISTS `grauv8` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `grauv8`;

-- Dump della struttura di tabella grauv8.bannedplayers
CREATE TABLE IF NOT EXISTS `bannedplayers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `steamid` varchar(50) DEFAULT NULL,
  `discord` varchar(50) DEFAULT NULL,
  `license` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `fivem` varchar(50) DEFAULT 'Invalid',
  `reason` varchar(100) NOT NULL,
  `executioner` varchar(100) DEFAULT 'uNKNown',
  `date` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `discord` (`discord`),
  KEY `license` (`license`),
  KEY `ip` (`ip`),
  KEY `steamid` (`steamid`) USING BTREE,
  KEY `fivem` (`fivem`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.bannedplayers: ~0 rows (circa)
DELETE FROM `bannedplayers`;

-- Dump della struttura di tabella grauv8.houses
CREATE TABLE IF NOT EXISTS `houses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(50) DEFAULT NULL,
  `shell` varchar(50) DEFAULT NULL,
  `price` varchar(50) DEFAULT NULL,
  `coords` longtext,
  `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `keys` longtext,
  `markers` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.houses: ~4 rows (circa)
DELETE FROM `houses`;
INSERT INTO `houses` (`id`, `owner`, `shell`, `price`, `coords`, `created_by`, `keys`, `markers`) VALUES
	(1, 'char1:1100001120b1015', 'newfurnished_shell', '1', '{"x":102.01631927490235,"y":-1402.7215576171876,"z":29.23078155517578}', 'No idea how heartless I am.', NULL, NULL),
	(2, 'char1:110000104272811', 'modernhotel_shell', '1', '{"x":-358.47283935546877,"y":-612.8619995117188,"z":37.55765151977539}', 'RayJackson', NULL, NULL),
	(3, 'char1:110000104272811', 'brambishell', '1', '{"x":-357.95111083984377,"y":-622.178466796875,"z":37.55770874023437}', 'RayJackson', NULL, NULL),
	(4, 'char1:110000104272811', 'newfurnished_shell', '1', '{"x":-358.9942321777344,"y":-618.3529052734375,"z":37.55772399902344}', 'RayJackson', NULL, NULL);

-- Dump della struttura di tabella grauv8.k5_documents
CREATE TABLE IF NOT EXISTS `k5_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `ownerId` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isCopy` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2969 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.k5_documents: ~0 rows (circa)
DELETE FROM `k5_documents`;

-- Dump della struttura di tabella grauv8.k5_document_templates
CREATE TABLE IF NOT EXISTS `k5_document_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `job` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.k5_document_templates: ~38 rows (circa)
DELETE FROM `k5_document_templates`;
INSERT INTO `k5_document_templates` (`id`, `data`, `job`) VALUES
	(1, '{"documentDescription":"Documento rilascio porto d\'armi","documentName":"Porto d\'Armi","fields":[{"name":"Nome","value":""},{"name":"Cognome","value":""},{"name":"Data di Nascita","value":""},{"name":"Data Rilascio","value":""},{"name":"Data Scadenza","value":""}],"id":1,"infoName":"Oggetto","infoTemplate":"Descrizione","minGrade":"2"}', 'clinicaprivata'),
	(2, '{"documentDescription":"Visita Medica","documentName":"Referto visita medica generica","fields":[{"name":"Nome","value":""},{"name":"Cognome","value":""},{"name":"Data di Nascita","value":""},{"name":"Data Rilascio","value":""},{"name":"Data Scadenza","value":""}],"id":2,"infoName":"Oggetto: Referto ","infoTemplate":"Descrizione","minGrade":"3"}', 'clinicaprivata'),
	(3, '{"minGrade":"3","documentName":"referto chirurgico","documentDescription":"Referto Operatorio","fields":[{"name":"Nome Paziente","value":""},{"name":"Cognome Paziente","value":""},{"name":"Nome e Cognome Chirurgo","value":""},{"name":"Nome e Cognome Assistente","value":""},{"name":"Nome e Cognome Assistente","value":""},{"name":"Nome e Cognome Anestesista","value":""}],"infoName":"Referto chirurgico","infoTemplate":"Data intervento \\nDescrizione"}', 'clinicaprivata'),
	(4, '{"minGrade":"3","documentName":"Visita medica specialistica","documentDescription":"Referto Visita Specialistica","fields":[{"name":"Nome Paziente","value":""},{"name":"Cognome Paziente","value":""},{"name":"Data di rilascio","value":""},{"name":"Scadenza","value":""}],"infoName":"Referto visita specialistica","infoTemplate":"Descrizione"}', 'clinicaprivata'),
	(5, '{"documentDescription":"Porto d\'armi","documentName":"PORTO D\'ARMI","fields":[{"name":"Nome Cognome","value":""},{"name":"Data Di Nascita","value":""},{"name":"Rilascio Pda","value":""},{"name":"Scadenza Pda","value":""}],"id":5,"infoName":"Rilascio porto d\'arma","infoTemplate":"Si attesta che il cittadino risulta IDONEO AL POSSESSO DEL PORTO D\'ARMI, in seguito al completamento della prassi burocratica prevista.","minGrade":"5"}', 'police'),
	(6, '{"documentDescription":"CONTRATTO DI COLLABORAZIONE AZIENDA","documentName":"SLM 001 - CONTRATTO DI COLLABORAZIONE AZIENDA","fields":[{"name":"NOME AZIENDA, CIVICO, N° CELLULARE","value":""},{"name":"DATA","value":""}],"id":6,"infoName":"Re: Contratto di Collaborazione Legale","infoTemplate":"Oggetto della Collaborazione:\\nIl presente contratto stabilisce i termini e le condizioni della collaborazione legale tra STUDIO LEGALE MARTINEZ e [Nome dell\'Azienda Cliente].\\n\\nServizi Legali:\\nSTUDIO LEGALE MARTINEZ fornirà all\'Azienda Cliente i seguenti servizi legali:\\n\\nConsulenza Legale Generale:\\nFornitura di consulenza legale su questioni generali aziendali.\\nRisposta a domande legali quotidiane in materia contrattuale, occupazionale, e di normative commerciali.\\n\\nRedazione e Revisione Contratti:\\nRedazione e revisione di contratti commerciali, accordi di fornitura, accordi di servizio e altri documenti contrattuali.\\n\\nRisoluzione delle Controversie:\\nAssistenza nella gestione di controversie aziendali, inclusa la mediazione e l\'arbitrato.\\nRappresentanza legale in procedimenti giudiziari, se necessario.\\n\\nDiritto del Lavoro:\\nFornitura di consulenza legale in materia di contratti di lavoro, licenziamenti, e normative sulla sicurezza sul lavoro.\\nRappresentanza in cause legali legate a controversie del lavoro.\\n\\nProprietà Intellettuale:\\nConsulenza sulla protezione dei marchi, brevetti e diritti d\'autore.\\nAzioni legali per la difesa dei diritti di proprietà intellettuale dell\'azienda.\\n\\nCompliance Regolamentare:\\nMonitoraggio e assicurazione della conformità alle normative e regolamenti settoriali.\\nFormazione del personale sull\'importanza della conformità legale.\\n\\nDifesa Penale Aziendale:\\nAssistenza legale in caso di indagini penali o azioni penali contro l\'azienda.\\nRappresentanza legale durante le fasi di inchiesta e processo.\\n\\nDurata della Collaborazione:\\nLa collaborazione avrà inizio il xx/01/2024 e terminerà il xx/02/2024, salvo proroga o rescissione anticipata come previsto nei termini di questo contratto.\\n\\nCompensazione:\\nIn considerazione dei servizi legali forniti, l\'Azienda Cliente pagherà a STUDIO LEGALE MARTINEZ una compensazione di 50.000 $ / settimana entro n°1  giorno dalla data di emissione della fattura (lunedì sera).\\n\\nObblighi dell\'Azienda Cliente:\\nFornire a STUDIO LEGALE MARTINEZ tutte le informazioni e la documentazione necessaria per l\'erogazione dei servizi legali.\\nRispettare i tempi di pagamento concordati.\\n\\nObblighi di STUDIO LEGALE MARTINEZ:\\nFornire i servizi legali in modo professionale e competente.\\nMantenere la confidenzialità delle informazioni fornite dall\'Azienda Cliente.\\n\\nRiservatezza:\\nEntrambe le parti concordano di mantenere la riservatezza su tutte le informazioni ricevute durante il corso della collaborazione.\\n\\nTerminazione:\\nCiascuna delle parti può terminare la collaborazione con un preavviso scritto di n° 5 giorni solari in caso di inadempienza significativa da parte dell\'altra parte.\\n\\nLegge Applicabile e Giurisdizione:\\nIl presente contratto sarà disciplinato e interpretato in conformità con le leggi dello stato di Grau city life v7, Los Santos. Qualsiasi controversia derivante da o in relazione a questo contratto sarà sottoposta alla giurisdizione esclusiva dei tribunali di Los Santos.\\n\\nModifiche al Contratto:\\nQualsiasi modifica o modifica al presente contratto dovrà essere effettuata per iscritto e firmata da entrambe le parti.\\n\\nIn fede,\\n[NOME SOCIO PROCACCIATORE AZIENDA] - STUDIO LEGALE MARTINEZ\\nMartinez A. - STUDIO LEGALE MARTINEZ\\n[NOME COGNOME SOCI AZIENDA CLIENTE] - [NOME AZIENDA CLIENTE] \\nMartinez A. — 25/01/2024 14:08","minGrade":"1"}', 'studiolegalemartinez'),
	(7, '{"minGrade":"1","documentName":"SLM 002 - CONTRATTO DI ASSEGNAZIONE INCARICO CON CITTADINO","documentDescription":"CONTRATTO DI ASSEGNAZIONE INCARICO CON CITTADINO","fields":[{"name":"NOME COGNOME, CIVICO, N° CELLULARE","value":""},{"name":"DATA","value":""}],"infoName":"Oggetto: Contratto di Incarico Legale","infoTemplate":"Con la presente, [Il tuo Nome], di seguito denominato \\"il Professionista\\", e [Nome del Cittadino], di seguito denominato \\"il Cliente\\", convengono quanto segue:\\n\\nOggetto dell\'Incarico: Il Cliente incarica il Professionista di fornire servizi legali in relazione a [breve descrizione dell\'oggetto dell\'incarico legale].\\n\\nDurata dell\'Incarico: L\'incarico avrà inizio dalla data della firma del presente contratto e avrà una durata di [specificare la durata dell\'incarico o stabilire che l\'incarico è a tempo indeterminato].\\n\\nRetribuzione: In considerazione dei servizi legali forniti, il Cliente si impegna a corrispondere al Professionista una retribuzione di 20.000 $ per lo scioglimento del caso oppure 50.000 $ per la risoluzione del caso davanti al tribunale.\\n\\nModalità di Pagamento: Il pagamento sarà effettuato a data di emissione fattura dello STUDIO LEGALE MARTINEZ\\n\\nObblighi delle Parti: Il Cliente si impegna a fornire al Professionista tutte le informazioni e la documentazione necessaria per l\'esecuzione dell\'incarico legale. Il Professionista si impegna a svolgere i servizi legali con diligenza e professionalità.\\n\\nRisoluzione dell\'Incarico: Entrambe le parti hanno il diritto di risolvere il presente incarico con preavviso scritto di almeno n° 5 giorni. In caso di risoluzione, il Cliente è tenuto a corrispondere al Professionista la retribuzione proporzionale ai servizi legali già resi.\\n\\nLegge Applicabile: Il presente contratto è regolato e interpretato in conformità alle leggi dello Stato di Grau city life v7, Los Santos.\\n\\nForo Competente: Per qualsiasi controversia derivante dal presente contratto, le parti accettano la giurisdizione esclusiva dei tribunali dello Stato.\\n\\nLe parti dichiarano di aver letto e compreso il presente contratto e di accettarne tutti i termini e le condizioni.\\n\\n[NOME COGNOME AVVOCATO] - Studio Legale Martinez\\n[NOME COGNOME CLIENTE] "}', 'studiolegalemartinez'),
	(8, '{"minGrade":"1","documentName":"SLM 003 - ACCORDO DI RISERVATEZZA","documentDescription":"ACCORDO DI RISERVATEZZA","fields":[{"name":"NOME COGNOME, LUOGO, N° CELLULARE","value":""},{"name":"DATA","value":""}],"infoName":"Oggetto: Accordo di Riservatezza","infoTemplate":"Con la presente, [Il Tuo Nome], di seguito denominato \\"l\'Avvocato\\", e [Nome del Cliente], di seguito denominato \\"il Cliente\\", convengono quanto segue:\\n\\nOggetto dell\'Accordo: In relazione alla consulenza legale fornita dall\'Avvocato al Cliente in merito a [breve descrizione dell\'oggetto della consulenza legale], le parti concordano di mantenere riservate tutte le informazioni e i documenti confidenziali scambiati nel corso di tale consulenza.\\n\\nDefinizione di Informazioni Confidenziali: Per \\"Informazioni Confidenziali\\" si intendono tutte le informazioni, scritte o verbali, comunicate da una parte all\'altra e relative all\'oggetto della consulenza legale. Le Informazioni Confidenziali possono includere, ma non sono limitate a, documenti legali, strategie legali, informazioni finanziarie e qualsiasi altra informazione ritenuta confidenziale da una delle parti.\\n\\nObblighi delle Parti: Le parti si impegnano a:\\nMantenere segrete e riservate le Informazioni Confidenziali.\\nNon divulgare le Informazioni Confidenziali a terzi senza il consenso scritto dell\'altra parte.\\nUtilizzare le Informazioni Confidenziali esclusivamente per lo scopo della consulenza legale fornita.\\n\\nEccezioni: Gli obblighi di riservatezza non si applicano alle informazioni che sono di dominio pubblico o che diventano di dominio pubblico senza alcuna violazione di questo accordo da parte delle parti.\\n\\nDurata dell\'Accordo: L\'accordo di riservatezza rimarrà in vigore per un periodo di n° 2 mesi dalla data di firma del presente accordo.\\n\\nRestituzione delle Informazioni: Alla cessazione della consulenza legale o su richiesta della parte che ha fornito le Informazioni Confidenziali, entrambe le parti restituiranno tutte le copie e i documenti contenenti le Informazioni Confidenziali.\\n\\nLegge Applicabile: Il presente accordo è regolato e interpretato in conformità alle leggi dello Stato di Grau city life v7, Los Santos.\\n\\nForo Competente: Per qualsiasi controversia derivante dal presente accordo, le parti accettano la giurisdizione esclusiva dei tribunali dello Stato.\\n\\nLe parti dichiarano di aver letto e compreso il presente accordo e di accettarne tutti i termini e le condizioni."}', 'studiolegalemartinez'),
	(9, '{"minGrade":"1","documentName":"SLM 004 - ACCORDO PREMATRIMONIALE","documentDescription":"ACCORDO PREMATRIMONIALE","fields":[{"name":"NOME COGNOME ENTRAMBI CONIUGI, NUMERI DI TELEFONO","value":""},{"name":"DATA","value":""}],"infoName":"ACCORDO PREMATRIMONIALE","infoTemplate":"Questo accordo pre-matrimoniale è stipulato in data 26/01/2024, tra [Nome del Primo Coniuge] nata/o il [data di nascita], di seguito denominato \\"Primo Coniuge\\", e [Nome del Secondo Coniuge] nata/o il [data di nascita], di seguito denominato \\"Secondo Coniuge\\".\\n\\nPATRIMONIO PREMATRIMONIALE:\\nCiascun coniuge dichiara di mantenere il proprio patrimonio precedentemente acquisito e di essere l\'unico proprietario di tali beni.\\n\\nBENI CONIUGALI:\\nI beni acquisiti durante il matrimonio saranno considerati beni coniugali e saranno divisi equamente in caso di separazione.\\n\\nSOSTEGNO ECONOMICO:\\nIn caso di separazione, il coniuge meno redditizio avrà diritto a un sostegno economico secondo quanto stabilito dalla legge applicabile al momento della separazione.\\n\\nAFFIDAMENTO DEI FIGLI:\\nIn caso di separazione, le decisioni sull\'affidamento dei figli saranno prese nel miglior interesse dei minori.\\n\\nMODIFICHE ALL\'ACCORDO:\\nL\'Accordo può essere modificato solo per iscritto e con il consenso di entrambi i coniugi a presenza dell\'associato firmatario e testimone del presente accordo.\\n\\nIn fede a quanto sopra, i coniugi firmano il presente Accordo in data 26.01.2024 e incaricano lo studio legale Martinez per le pratiche ad esso collegate.\\n\\n\\n[AVVOCATO] STUDIO LEGALE MARTINEZ\\nGrau city life v7, Los Santos"}', 'studiolegalemartinez'),
	(10, '{"documentDescription":"Procura di Grau City","documentName":"Mandato di cattura","fields":[{"name":"COGNOME","value":""},{"name":"NOME","value":""}],"id":10,"infoName":"Mandato di cattura","infoTemplate":"A seguito della mancata comparizione richiesta dal Capo LSPD nei termini previsti, si richiede la cattura del Sig Seba SINATRA nato il 07/07/2000.\\nL\'incarico è affidato agli Agenti del Dipartimento LSPD di Grau City.\\n\\n\\n\\nGrau City, 06/02/2024","minGrade":"0"}', 'governo'),
	(13, '{"minGrade":"5","documentName":"PERMESSI","documentDescription":"EMANATO DAL MAGISTRATO","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"PERMESSO","infoTemplate":"Con la presente Si autorizza il Generale Aragon a mettere una cavigliera alla sig.na Bonny Grey, per portarla a una gita per buona condotta"}', 'governo'),
	(14, '{"documentDescription":"Procura di Grau City","documentName":"Cerificato pulizia fedina penale","fields":[{"name":"Procura di Grau City","value":""}],"id":14,"infoName":"Certificato pulizia fedina penale","infoTemplate":"La presente certificazione attesta che in data xx.xx.xxxx il Sig. Xxxx XXXXX nato il xx.xx.xxxx ha correttamente pulito la fedina penale.\\nArt. xx Classe X \\n\\nper una somma pecuniaria di xxxxxx$","minGrade":"0"}', 'governo'),
	(15, '{"documentDescription":"MAGISTRATURA","documentName":"AUTORIZZAZIONE RILASCIO DAL CARCERE","fields":[{"name":"COGNOME","value":""},{"name":"NOME","value":""}],"id":15,"infoName":"AUTORIZZAZIONE RILASCIO DAL CARCERE","infoTemplate":"La Magistratura di Grau City, autorizza il rilascio anticipato della detenuta Bonnie Grey, per buona condotta avuta nei 17 anni in carcere e per la sua sicurezza, per gli eventi accaduti in carcere il 05/02/2024.\\nLe clausole sono i seguenti:\\n- obbligo di firma quotidiana per due settimane (ultima firma 19/02/2024), presso il dipartimento di polizia al civico 592, accompagnata dal suo avvocato\\n- La sig, na Grey s\' impegna a matenere la fedina penale pulita (classe B-A)","minGrade":"5"}', 'governo'),
	(16, '{"minGrade":"6","documentName":"AUTORIZZAZIONE TIROCINIO","documentDescription":"MAGISTRATO","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"TIROCINIO IN AVVOCATURA","infoTemplate":"La Magistratura autorizza ________ ad affiancare un avvocato iscritto all\' albo, per un periodo limitato.\\nCon questo documento il tirocinante è autorizzato ad entrare, con la presenza di un avvocato, nelle sedi F.D.O. e Carcere.\\nSi avvisa che l\'esercitazione in solitaria non è autorizzata"}', 'governo'),
	(17, '{"minGrade":"1","documentName":"DOCUMENTO AVVOCATURA","documentDescription":"AVVOCATO D\' UFFICIO","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"DOCUMENTO AVVOCATURA","infoTemplate":"AVVOCATO SCRIVI QUI"}', 'governo'),
	(18, '{"documentDescription":"Sospensione dal Servizio","documentName":"Sospensione dal Servizio","fields":[{"name":"Nome dell\' Agente","value":""},{"name":"Data di Nascita","value":""},{"name":"Grado","value":""}],"id":18,"infoName":"Sospensione dal Servizio","infoTemplate":"Il Sottoscritto CMD. Logan Morrison certifica che in data 07/02/2024 alle ore 01:00 viene effettuata la sospensione dal servizio dalla Centrale L.S.P.D. Civ.592 dell\' AGT II | Bomba Boom nato in data 14/12/2000.\\nLa sopsensione dell\'agente è di giorni cinque + due che vengono aggiunte in Accademia per il reintegro e il ripasso delle procedure secondo il Codice Penale.","minGrade":"11"}', 'police'),
	(19, '{"minGrade":"1","documentName":"DIFFIDA","documentDescription":"DIFFIDA","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"DIFFIDA","infoTemplate":"questo modello è per la diffida di un cittadino"}', 'ciupalawfirm'),
	(20, '{"minGrade":"6","documentName":"CONSENSO COPIA REGISTRAZIONE","documentDescription":"MAGISTRATURA","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"CONSENSO COPIA REGISTRAZIONE","infoTemplate":"La Magistratura acconsente all\' avvocato  _______  a richiedere e prelevare la/le registrazione/i dell\' agente/sede."}', 'governo'),
	(21, '{"minGrade":"1","documentName":"DDG","documentDescription":"Dipartimento di Giustizia","fields":[{"name":"DATA","value":""}],"infoName":"OGGETTO","infoTemplate":"Corpo:"}', 'dipartimentodigiustizia'),
	(22, '{"minGrade":"2","documentName":"AUTORIZZAZIONE GANG UNIT","documentDescription":"Procura di Grau City","fields":[{"name":"GANG UNIT","value":""}],"infoName":"Autorizzazione Gang Unit","infoTemplate":"Con la presente la Procura autorizza gli Agenti appartenenti alla sezione LSPD GANG UNIT a circolare con volto coperto durante il servizio operativo. Resta obbligo per gli Agenti la rivelazione della propria matricola su richiesta di qualunque cittadino."}', 'governo'),
	(23, '{"minGrade":"6","documentName":"CERTIFICATO DI MATRIMONIO","documentDescription":"MAGISTRATURA","fields":[{"name":"PROTOCOLLO N.","value":""},{"name":"DATA","value":""}],"infoName":"CERTIFICATO DI MATRIMONIO","infoTemplate":"REGISTRO DEGLI ATTI DI MATRIMONIO DELL\' ANNO (data)\\n\\nLUI: (cognome) (nome) (data di nascita)\\nLEI: (cognome) (nome) (data di nascita)\\nhanno contratto matrimonio nella Città di Grau City in (data)"}', 'governo'),
	(24, '{"minGrade":"6","documentName":"AUTORIZZAZIONE","documentDescription":"MAGISTRATURA","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"AUTORIZZAZIONE","infoTemplate":"La Magistratura, dopo le valutazioni dal Capo del L.S.P.D. e dalla Procura, libera la sig. na Grey dal vincolo richiesto nel suo rilascio.\\nLa sig. na Grey riprederà la sua quotidianità in città. "}', 'governo'),
	(25, '{"minGrade":"10","documentName":"Licenziamento Dipartimentale","documentDescription":"Licenziamento","fields":[{"name":"Nome e Cognome ","value":""},{"name":"Data di Nascita","value":""}],"infoName":"Licenziamento Dipartimentale","infoTemplate":"."}', 'police'),
	(26, '{"minGrade":"4","documentName":"MANDATO DI PERQUISIZIONE ","documentDescription":"REDATTO DALLA PROCURA","fields":[{"name":"ESTENSORE","value":""},{"name":"PROC. BORSELLINO","value":""}],"infoName":"MANDATO DI PERQUISIZIONE GANG VAGOS","infoTemplate":"Dopo diverse indagini e i fascicoli depositati presso la Procura di Grau City, verificata l\'intera documentazione, si rilascia mandato di perquisizione di beni mobili, immobili e persone presenti ai civici 146-139-147-132-138, per la data del 11.03.2024 da effettuare entro il 13.03.2024.  "}', 'governo'),
	(27, '{"minGrade":null,"documentName":"CERTIFICATO DI PROPRIETA\'","documentDescription":"PROPRIETA N","fields":[{"name":"NOME E COGNOME","value":""},{"name":"CASA N","value":""}],"infoName":"CERTIFICATO DI PROPRIETA\'","infoTemplate":"NELLA PRESENTE SI ATTESTA CHE IL SIG/RA E PROPRIETARIO DELL\'APPARTAMENTO SOPRA CITATO"}', 'police'),
	(28, '{"minGrade":"4","documentName":"PERMESSO PARK","documentDescription":"PERMESSO PARCK","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"PERMESSO PARK ","infoTemplate":"Con la presente Si autorizza ............ ad usare qualsiasi suolo pubblico e non ( esempio: maciapiede ed strada ) in caso di emergenza o non ( ovvio che non deva esserne abusato ) per parcheggiare,sostare il proprio veicolo o veicolo di proprieta del governo. \\n\\n\\nFirmato\\n"}', 'governo'),
	(29, '{"documentDescription":"ACCESSO AGLI ATTI","documentName":"ACCESSO AGLI ATTI","fields":[{"name":"antonio la rue","value":""},{"name":"22.09.95","value":""}],"id":29,"infoName":"ACCESSO AGLI ATTI","infoTemplate":"richiesta di accesso agli atti: a seguito di quanto testimoniato dal cliente\\ncon la presente richiediamo la registrazione delle telecamere dell\'interrogatorio del suddetto La Rue , avvenuto intorno alle ore 23.00","minGrade":"0"}', 'ciupalawfirm'),
	(30, '{"minGrade":"1","documentName":"MANDATO DI PERQUISIZIONE","documentDescription":"Ufficio della Procura di Grau City","fields":[{"name":"Grau City","value":""},{"name":"Data:","value":""},{"name":"Procuratore Patrick O\'Brian","value":""}],"infoName":"MANDATO DI PERQUISIZIONE","infoTemplate":"A seguito delle informazione ottenute durante le indagini del Reparto investigativo del Dipartimento LSPD la Procura emette il seguente MANDATO DI PERQUISIZIONE nei confronti di beni mobili, immobili e persone presenti al civico 433 di Grau City.\\n\\nQuesto mandato ha validità di 72 ore dall\'emissione."}', 'governo'),
	(31, '{"minGrade":"","documentName":"MANDATO DI COMPARIZIONE","documentDescription":"MANDATO DI COMPARIZIONE","fields":[{"name":"PROCURA DI GRAU CITY","value":""}],"infoName":"MANDATO DI COMPARIZIONE","infoTemplate":"Si convoca il Sig. xxxx nato il xxxx, a comparire presso il distretto dell\'LSPD di Grau City entro il xxxxx, al fine di delucidare gli agenti. In caso di mancata presentazione il seguente mandato si traformerà in mandato di cattura. "}', 'governo'),
	(32, '{"documentDescription":"Richiesta","documentName":"Richiesta","fields":[{"name":"Nome e Cognome Avvocato:","value":""},{"name":"Nome e Cognome Assistito:","value":""}],"id":32,"infoName":"Richiesta posta dallo studio legale Ferrari","infoTemplate":"Richiesta posta dallo studio legale Ferrari","minGrade":"1"}', 'studiolegaleferrari'),
	(33, '{"minGrade":"5","documentName":"DIVORZIO","documentDescription":"DIVORZIO","fields":[{"name":"NOME/COGNOME","value":""},{"name":"NOME/COGNOME","value":""}],"infoName":"DIVORZIO","infoTemplate":"In questa Sede, si ufficializza il divorzio in accordo delle parti del Sig..... e la Sig. ra ..."}', 'governo'),
	(34, '{"minGrade":"6","documentName":"ORDINE DI LIBERAZIONE ANTICIPATA","documentDescription":"MAGISTRATURA","fields":[{"name":"NOME/COGNOME","value":""}],"infoName":"ORDINE DI LIBERAZIONE ANTICIPATA","infoTemplate":"In riferimento al caso del signor Nick Jhonson, detenuto presso il carcere di Grau City, emano un ordine di liberazione anticipata per buona condotta. La sua condotta durante il periodo di detenzione è stata esemplare, dimostrando impegno e volontà di reinserirsi positivamente nella società.\\n"}', 'governo'),
	(35, '{"minGrade":null,"documentName":"ACCORDO CONCILIAZIONE","documentDescription":"ACCORDO 0101","fields":[{"name":"ANTONIO LA RUE","value":""},{"name":"AVV. GOLIATH OTELLO","value":""}],"infoName":"RIEPILOGO ACCORDO","infoTemplate":"IN DATA 05/05/24 A SEGUITO DI PATTEGGIAMENTO RICEVO LA CIFRA DI 2500000 A TITOLO DI RISARCIMENTO DANNI PER IL SOGNORE LA RUE ANTONIO. TALE CIFRA E\' ACCETTATA A TITOLO DI CONCORDATO E CI IMPEGNAMO A NON PROSEGUIRE ULTERIORMENTE CON LE PROCEDURE MA A RITIRARE LA DENUNCIA .\\nRESTA QUESTA POSIZIONE A CONDIZIONE DEL RISPETTO DI TUTTE LE PARTI DELL\'ACCORDO COMPRESO \\nDEGRADAZIONE A CADETTO E RIAVVIO DEL PERCORSO DI STUDI PER L EX AGENTE \\"SEBA\\"\\nRICHIAMO FORMALE ALL\'AGENTE \\"MIRIA\\"\\nRICHIAMO FORMALE ALL\'AGENTE \\"DODDO\\"\\nGLI ALTRI AGENTI RISULTANO GIA\' DIMISSIONARI O LICENZIATI E IN CASO DI REINTEGRO SARANNO RICHIAMATI FORMALMENTE\\nSE QUANTO ESPOSTO NON FOSSE RISPETTATO IN PIENO, CI RISERVIAMO DI RIPRENDERE LE PROCEDURE LEGALI \\nLADDOVE QUEST"}', 'ciupalawfirm'),
	(36, '{"minGrade":"5","documentName":"AUTORIZZAZIONE EVENTI","documentDescription":"MAGISTRATURA","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"AUTORIZZAZIONE EVENTI","infoTemplate":"Autorizzazione allo Svolgimento della Corsa Automobilistica \\"Car Race\\"\\n\\n\\n\\nAlla cortese attenzione del Sig. Jesse Carter,\\n\\nCon la presente, si autorizza lo svolgimento della corsa automobilistica denominata \\"Car Race\\" organizzata dal Sig. Jesse Carter. L\'evento si terrà lunedì 3 giugno dalle ore 21:00 fino al termine dell\'evento presso l\'aeroporto situato al civico 93, con spostamento per premiazione e festa nel locale Haute.\\n\\n\\nL\'autorizzazione è concessa a condizione che siano rispettate tutte le normative vigenti in materia di sicurezza e ordine pubblico, nonché le specifiche disposizioni emesse dalle autorità competenti.\\n\\nSi richiede inoltre di garantire che:\\n\\n1. Vengano adottate tutte le misure necessarie per la sicurezza dei partecipanti e del pubblico.\\n2. Venga predisposto un adeguato servizio di assistenza sanitaria sul posto.\\n3. Venga rispettato il regolamento della struttura aeroportuale e le indicazioni del personale addetto.\\n4. Venga effettuata una pulizia completa dell\'area utilizzata al termine dell\'evento.\\n\\nRingraziando per la collaborazione, si augura il massimo successo per la manifestazione.\\n\\nSi consegna copia di questa autorizzazione agli Enti competenti in materia di Sicurezza Pubblica e Sanità.\\n\\n\\n\\n\\nCordiali saluti,\\n"}', 'governo'),
	(38, '{"minGrade":"13","documentName":"CONTRATTO","documentDescription":"Contratto con FDO","fields":[{"name":"Nome:","value":""},{"name":"Cognome: ","value":""},{"name":"Ente con cui si stipula il contratto: ","value":""},{"name":"Data di scadenza: ","value":""}],"infoName":"CONTRATTO CON FDO","infoTemplate":"Questo contratto serve ad attestare un accordo preso tra due FDO, o tra FDO e altre aziende "}', 'police'),
	(39, '{"minGrade":"6","documentName":"MANDATO DI LATITANZA","documentDescription":"MANDATO EMANATO DALLA MAGISTRATURA","fields":[{"name":"MAGISTRATO","value":""}],"infoName":"MANDATO DI LATITANZA","infoTemplate":"EMESSO DAL TRIBUNALE DI GRAU CITY\\n\\nNOMI DEI RICERCATI:\\n\\nPurzo Kabobo\\nData di nascita: 25/12/1990\\n\\nOmegus Proiettile\\nData di nascita: 13/07/1995\\n\\nYoussef Paperella\\nData di nascita: 12/11/2000\\n\\nJames III West\\nData di nascita: 01/01/2000\\n\\nAmiri Secs\\nData di nascita: 11/02/2000\\n\\nLlorenzino Aimers\\nData di nascita: 01/01/2000\\n\\nKayron Santiago\\nData di nascita: 11/10/1990\\n\\nMOTIVO: A seguito della mancata presenza nel processo a loro carico, la sentenza emessa dal Tribunale di Grau City in data 11/07/2024, i suddetti soggetti sono stati condannati alla pena dell’ergastolo.\\n\\n\\n\\n\\n.\\n\\n"}', 'governo'),
	(40, '{"minGrade":"14","documentName":"ERGASTOLO DIRETTO AFFARI INTERNI","documentDescription":"ERGASTOLO","fields":[{"name":"NOME","value":""},{"name":"COGNOME","value":""}],"infoName":"ERGASTOLO DIRETTO AFFARI INTERNI","infoTemplate":"si procede all\'ergastolo ostativo"}', 'police'),
	(41, '{"minGrade":"6","documentName":"MANDATO DI PERQUISIZIONE","documentDescription":"MAGISTRATURA","fields":[{"name":"MAGISTRATO","value":""}],"infoName":"MANDATO","infoTemplate":"Con la richiesta della Procura, la Magistratura autorizza il bliz ai blackbunta al civico 126 e dintorni per l\'arresto di Massimino House a seguito della fuga dal convoglio e il rapimento di 2 agenti.\\n\\nQUESTO DOMCUMENTO HA VALIDITA\' 72 ORE"}', 'governo');

-- Dump della struttura di tabella grauv8.multicharacter_slots
CREATE TABLE IF NOT EXISTS `multicharacter_slots` (
  `identifier` varchar(50) NOT NULL,
  `slots` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.multicharacter_slots: ~0 rows (circa)
DELETE FROM `multicharacter_slots`;

-- Dump della struttura di tabella grauv8.outfits
CREATE TABLE IF NOT EXISTS `outfits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext NOT NULL,
  `components` longtext NOT NULL,
  `props` longtext NOT NULL,
  `identifier` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.outfits: ~18 rows (circa)
DELETE FROM `outfits`;
INSERT INTO `outfits` (`id`, `name`, `components`, `props`, `identifier`) VALUES
	(1, 'tes', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":0,"texture":0},{"component_id":3,"drawable":5,"texture":0},{"component_id":4,"drawable":0,"texture":0},{"component_id":5,"drawable":0,"texture":0},{"component_id":6,"drawable":67,"texture":0},{"component_id":7,"drawable":0,"texture":0},{"component_id":8,"drawable":15,"texture":0},{"component_id":9,"drawable":0,"texture":0},{"component_id":10,"drawable":0,"texture":0},{"component_id":11,"drawable":0,"texture":0}]', '[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}]', 'char1:1100001120b1015'),
	(2, 'testtttt', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":0,"texture":0},{"component_id":3,"drawable":5,"texture":0},{"component_id":4,"drawable":1,"texture":0},{"component_id":5,"drawable":0,"texture":0},{"component_id":6,"drawable":65,"texture":0},{"component_id":7,"drawable":0,"texture":0},{"component_id":8,"drawable":11,"texture":0},{"component_id":9,"drawable":0,"texture":0},{"component_id":10,"drawable":0,"texture":0},{"component_id":11,"drawable":561,"texture":0}]', '[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}]', 'char1:1100001120b1015'),
	(4, 'police2', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":73},{"component_id":3,"texture":0,"drawable":17},{"component_id":4,"texture":0,"drawable":209},{"component_id":5,"texture":0,"drawable":0},{"component_id":6,"texture":0,"drawable":21},{"component_id":7,"texture":0,"drawable":0},{"component_id":8,"texture":0,"drawable":213},{"component_id":9,"texture":0,"drawable":0},{"component_id":10,"texture":0,"drawable":213},{"component_id":11,"texture":0,"drawable":556}]', '[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":7,"texture":0,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}]', 'char1:110000104272811'),
	(5, 'camicia', '[{"drawable":0,"texture":0,"component_id":0},{"drawable":0,"texture":0,"component_id":1},{"drawable":73,"texture":0,"component_id":2},{"drawable":17,"texture":0,"component_id":3},{"drawable":209,"texture":0,"component_id":4},{"drawable":134,"texture":0,"component_id":5},{"drawable":21,"texture":0,"component_id":6},{"drawable":0,"texture":0,"component_id":7},{"drawable":231,"texture":10,"component_id":8},{"drawable":0,"texture":0,"component_id":9},{"drawable":0,"texture":0,"component_id":10},{"drawable":348,"texture":15,"component_id":11}]', '[{"prop_id":0,"drawable":-1,"texture":-1},{"prop_id":1,"drawable":7,"texture":0},{"prop_id":2,"drawable":-1,"texture":-1},{"prop_id":6,"drawable":-1,"texture":-1},{"prop_id":7,"drawable":-1,"texture":-1}]', 'char1:110000104272811'),
	(6, '123', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":130},{"component_id":3,"texture":0,"drawable":23},{"component_id":4,"texture":0,"drawable":228},{"component_id":5,"texture":0,"drawable":134},{"component_id":6,"texture":0,"drawable":21},{"component_id":7,"texture":0,"drawable":0},{"component_id":8,"texture":10,"drawable":231},{"component_id":9,"texture":0,"drawable":73},{"component_id":10,"texture":0,"drawable":0},{"component_id":11,"texture":1,"drawable":238}]', '[{"prop_id":0,"texture":-1,"drawable":-1},{"prop_id":1,"texture":0,"drawable":7},{"prop_id":2,"texture":-1,"drawable":-1},{"prop_id":6,"texture":-1,"drawable":-1},{"prop_id":7,"texture":-1,"drawable":-1}]', 'char1:110000104272811'),
	(9, 'divisa corretta', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":130},{"component_id":3,"texture":0,"drawable":20},{"component_id":4,"texture":0,"drawable":211},{"component_id":5,"texture":0,"drawable":0},{"component_id":6,"texture":0,"drawable":25},{"component_id":7,"texture":0,"drawable":214},{"component_id":8,"texture":0,"drawable":224},{"component_id":9,"texture":0,"drawable":78},{"component_id":10,"texture":2,"drawable":209},{"component_id":11,"texture":8,"drawable":565}]', '[{"texture":-1,"prop_id":0,"drawable":-1},{"texture":0,"prop_id":1,"drawable":7},{"texture":-1,"prop_id":2,"drawable":-1},{"texture":-1,"prop_id":6,"drawable":-1},{"texture":-1,"prop_id":7,"drawable":-1}]', 'char1:110000104272811'),
	(10, 'camicia', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":130},{"component_id":3,"texture":0,"drawable":17},{"component_id":4,"texture":0,"drawable":209},{"component_id":5,"texture":0,"drawable":134},{"component_id":6,"texture":0,"drawable":21},{"component_id":7,"texture":1,"drawable":215},{"component_id":8,"texture":0,"drawable":233},{"component_id":9,"texture":0,"drawable":0},{"component_id":10,"texture":0,"drawable":0},{"component_id":11,"texture":15,"drawable":348}]', '[{"texture":-1,"prop_id":0,"drawable":-1},{"texture":0,"prop_id":1,"drawable":7},{"texture":-1,"prop_id":2,"drawable":-1},{"texture":-1,"prop_id":6,"drawable":-1},{"texture":-1,"prop_id":7,"drawable":-1}]', 'char1:110000104272811'),
	(15, 'divisa lspd', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":10},{"component_id":3,"texture":0,"drawable":2},{"component_id":4,"texture":0,"drawable":222},{"component_id":5,"texture":0,"drawable":0},{"component_id":6,"texture":0,"drawable":25},{"component_id":7,"texture":0,"drawable":182},{"component_id":8,"texture":0,"drawable":272},{"component_id":9,"texture":0,"drawable":66},{"component_id":10,"texture":0,"drawable":272},{"component_id":11,"texture":0,"drawable":589}]', '[{"texture":-1,"prop_id":0,"drawable":-1},{"texture":-1,"prop_id":1,"drawable":-1},{"texture":-1,"prop_id":2,"drawable":-1},{"texture":-1,"prop_id":6,"drawable":-1},{"texture":-1,"prop_id":7,"drawable":-1}]', 'char1:'),
	(18, 'noose oerpativo', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":10},{"component_id":3,"texture":0,"drawable":14},{"component_id":4,"texture":0,"drawable":220},{"component_id":5,"texture":0,"drawable":0},{"component_id":6,"texture":0,"drawable":25},{"component_id":7,"texture":0,"drawable":178},{"component_id":8,"texture":0,"drawable":262},{"component_id":9,"texture":0,"drawable":69},{"component_id":10,"texture":0,"drawable":272},{"component_id":11,"texture":1,"drawable":597}]', '[{"texture":0,"prop_id":0,"drawable":220},{"texture":0,"prop_id":1,"drawable":42},{"texture":-1,"prop_id":2,"drawable":-1},{"texture":-1,"prop_id":6,"drawable":-1},{"texture":-1,"prop_id":7,"drawable":-1}]', 'char1:'),
	(19, 'm', '[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":10},{"component_id":3,"texture":0,"drawable":4},{"component_id":4,"texture":0,"drawable":255},{"component_id":5,"texture":0,"drawable":0},{"component_id":6,"texture":0,"drawable":6},{"component_id":7,"texture":0,"drawable":0},{"component_id":8,"texture":0,"drawable":14},{"component_id":9,"texture":0,"drawable":0},{"component_id":10,"texture":0,"drawable":0},{"component_id":11,"texture":2,"drawable":632}]', '[{"texture":-1,"prop_id":0,"drawable":-1},{"texture":-1,"prop_id":1,"drawable":-1},{"texture":-1,"prop_id":2,"drawable":-1},{"texture":-1,"prop_id":6,"drawable":-1},{"texture":-1,"prop_id":7,"drawable":-1}]', 'char1:'),
	(20, 'BICYCLE_PATROL', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":21,"texture":0},{"component_id":3,"drawable":19,"texture":0},{"component_id":4,"drawable":262,"texture":5},{"component_id":5,"drawable":0,"texture":0},{"component_id":6,"drawable":25,"texture":0},{"component_id":7,"drawable":214,"texture":0},{"component_id":8,"drawable":224,"texture":0},{"component_id":9,"drawable":0,"texture":0},{"component_id":10,"drawable":0,"texture":0},{"component_id":11,"drawable":555,"texture":2}]', '[{"prop_id":0,"drawable":223,"texture":0},{"prop_id":1,"drawable":25,"texture":1},{"prop_id":2,"drawable":-1,"texture":-1},{"prop_id":6,"drawable":-1,"texture":-1},{"prop_id":7,"drawable":-1,"texture":-1}]', 'char1:110000147dcc2ac'),
	(21, 'DIVISA_LSPD', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":21,"texture":0},{"component_id":3,"drawable":20,"texture":0},{"component_id":4,"drawable":208,"texture":0},{"component_id":5,"drawable":0,"texture":0},{"component_id":6,"drawable":25,"texture":0},{"component_id":7,"drawable":214,"texture":0},{"component_id":8,"drawable":224,"texture":0},{"component_id":9,"drawable":71,"texture":0},{"component_id":10,"drawable":208,"texture":3},{"component_id":11,"drawable":554,"texture":8}]', '[{"prop_id":0,"drawable":-1,"texture":-1},{"prop_id":1,"drawable":17,"texture":0},{"prop_id":2,"drawable":-1,"texture":-1},{"prop_id":6,"drawable":-1,"texture":-1},{"prop_id":7,"drawable":-1,"texture":-1}]', 'char1:110000147dcc2ac'),
	(22, 'CAMICIA_BLU', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":21,"texture":0},{"component_id":3,"drawable":20,"texture":0},{"component_id":4,"drawable":187,"texture":0},{"component_id":5,"drawable":134,"texture":10},{"component_id":6,"drawable":10,"texture":0},{"component_id":7,"drawable":0,"texture":0},{"component_id":8,"drawable":233,"texture":0},{"component_id":9,"drawable":65,"texture":0},{"component_id":10,"drawable":0,"texture":0},{"component_id":11,"drawable":348,"texture":2}]', '[{"texture":-1,"drawable":-1,"prop_id":0},{"texture":0,"drawable":17,"prop_id":1},{"texture":0,"drawable":5,"prop_id":2},{"texture":-1,"drawable":-1,"prop_id":6},{"texture":-1,"drawable":-1,"prop_id":7}]', 'char1:110000147dcc2ac'),
	(23, 'NOOSE_OPERATIVA', '[{"component_id":0,"drawable":0,"texture":0},{"component_id":1,"drawable":0,"texture":0},{"component_id":2,"drawable":21,"texture":0},{"component_id":3,"drawable":19,"texture":0},{"component_id":4,"drawable":215,"texture":0},{"component_id":5,"drawable":142,"texture":0},{"component_id":6,"drawable":25,"texture":0},{"component_id":7,"drawable":243,"texture":0},{"component_id":8,"drawable":15,"texture":0},{"component_id":9,"drawable":72,"texture":0},{"component_id":10,"drawable":0,"texture":0},{"component_id":11,"drawable":557,"texture":0}]', '[{"texture":0,"drawable":221,"prop_id":0},{"texture":0,"drawable":55,"prop_id":1},{"texture":-1,"drawable":-1,"prop_id":2},{"texture":-1,"drawable":-1,"prop_id":6},{"texture":-1,"drawable":-1,"prop_id":7}]', 'char1:110000147dcc2ac'),
	(24, 'mio', '[{"drawable":0,"texture":0,"component_id":0},{"drawable":0,"texture":0,"component_id":1},{"drawable":4,"texture":0,"component_id":2},{"drawable":11,"texture":0,"component_id":3},{"drawable":14,"texture":0,"component_id":4},{"drawable":0,"texture":0,"component_id":5},{"drawable":113,"texture":0,"component_id":6},{"drawable":126,"texture":0,"component_id":7},{"drawable":14,"texture":0,"component_id":8},{"drawable":0,"texture":0,"component_id":9},{"drawable":0,"texture":0,"component_id":10},{"drawable":651,"texture":0,"component_id":11}]', '[{"drawable":-1,"prop_id":0,"texture":-1},{"drawable":-1,"prop_id":1,"texture":-1},{"drawable":-1,"prop_id":2,"texture":-1},{"drawable":-1,"prop_id":6,"texture":-1},{"drawable":-1,"prop_id":7,"texture":-1}]', 'char1:'),
	(25, 'aaa', '[{"texture":0,"drawable":0,"component_id":0},{"texture":0,"drawable":0,"component_id":1},{"texture":0,"drawable":42,"component_id":2},{"texture":0,"drawable":12,"component_id":3},{"texture":0,"drawable":15,"component_id":4},{"texture":0,"drawable":0,"component_id":5},{"texture":0,"drawable":161,"component_id":6},{"texture":0,"drawable":126,"component_id":7},{"texture":0,"drawable":14,"component_id":8},{"texture":0,"drawable":0,"component_id":9},{"texture":0,"drawable":0,"component_id":10},{"texture":6,"drawable":437,"component_id":11}]', '[{"drawable":-1,"prop_id":0,"texture":-1},{"drawable":-1,"prop_id":1,"texture":-1},{"drawable":-1,"prop_id":2,"texture":-1},{"drawable":-1,"prop_id":6,"texture":-1},{"drawable":-1,"prop_id":7,"texture":-1}]', 'char1:'),
	(26, 'aaa', '[{"texture":0,"drawable":0,"component_id":0},{"texture":0,"drawable":0,"component_id":1},{"texture":0,"drawable":42,"component_id":2},{"texture":0,"drawable":12,"component_id":3},{"texture":0,"drawable":15,"component_id":4},{"texture":0,"drawable":0,"component_id":5},{"texture":0,"drawable":199,"component_id":6},{"texture":0,"drawable":126,"component_id":7},{"texture":0,"drawable":14,"component_id":8},{"texture":0,"drawable":0,"component_id":9},{"texture":0,"drawable":0,"component_id":10},{"texture":0,"drawable":415,"component_id":11}]', '[{"prop_id":0,"texture":-1,"drawable":-1},{"prop_id":1,"texture":-1,"drawable":-1},{"prop_id":2,"texture":-1,"drawable":-1},{"prop_id":6,"texture":-1,"drawable":-1},{"prop_id":7,"texture":-1,"drawable":-1}]', 'char1:'),
	(27, 'qqq', '[{"drawable":0,"component_id":0,"texture":0},{"drawable":0,"component_id":1,"texture":0},{"drawable":42,"component_id":2,"texture":0},{"drawable":15,"component_id":3,"texture":0},{"drawable":251,"component_id":4,"texture":0},{"drawable":0,"component_id":5,"texture":0},{"drawable":1,"component_id":6,"texture":0},{"drawable":126,"component_id":7,"texture":0},{"drawable":14,"component_id":8,"texture":0},{"drawable":0,"component_id":9,"texture":0},{"drawable":0,"component_id":10,"texture":0},{"drawable":629,"component_id":11,"texture":1}]', '[{"prop_id":0,"texture":-1,"drawable":-1},{"prop_id":1,"texture":-1,"drawable":-1},{"prop_id":2,"texture":-1,"drawable":-1},{"prop_id":6,"texture":-1,"drawable":-1},{"prop_id":7,"texture":-1,"drawable":-1}]', 'char1:');

-- Dump della struttura di tabella grauv8.owned_vehicles
CREATE TABLE IF NOT EXISTS `owned_vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(50) NOT NULL DEFAULT '0',
  `plate` varchar(50) DEFAULT NULL,
  `vehicle` longtext,
  `modello` varchar(50) DEFAULT NULL,
  `glovebox` longtext,
  `trunk` longtext,
  `state` int(11) DEFAULT '1',
  `garage` varchar(50) DEFAULT 'Garage_A',
  `pound` int(11) DEFAULT '0',
  `type` varchar(50) DEFAULT 'car',
  `job` varchar(50) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.owned_vehicles: ~1 rows (circa)
DELETE FROM `owned_vehicles`;
INSERT INTO `owned_vehicles` (`id`, `owner`, `plate`, `vehicle`, `modello`, `glovebox`, `trunk`, `state`, `garage`, `pound`, `type`, `job`) VALUES
	(5, 'char1:1100001120b1015', 'AALF4962', '{"modFrontWheels":-1,"plate":"AALF4962","modSmokeEnabled":false,"fuelLevel":65,"modRoof":-1,"modArchCover":-1,"neonColor":[255,0,255],"paintType":[0,0],"modTransmission":-1,"modHood":-1,"modWindows":-1,"dshcolor":0,"modDoorSpeaker":-1,"wheels":0,"plateIndex":0,"modFrame":-1,"modTrimA":-1,"modSpeakers":-1,"modAPlate":-1,"modSpoilers":-1,"modTank":-1,"modGrille":-1,"modStruts":-1,"modEngineBlock":-1,"modDashboard":-1,"wheelColor":156,"neonEnabled":[false,false,false,false],"modHydrolic":-1,"modEngine":-1,"modBackWheels":-1,"ColorType":[0,0],"tyreSmokeColor":[255,255,255],"modRearBumper":-1,"xenonColor":255,"modFender":-1,"bodyHealth":992,"color2":0,"modBrakes":-1,"modShifterLeavers":-1,"modHorns":-1,"modAirFilter":-1,"color3":[8,8,8],"modDial":-1,"modArmor":-1,"modTrunk":-1,"modLivery":-1,"modTrimB":-1,"dirtLevel":0,"modLivery2":-1,"extras":[],"modSeats":-1,"modExhaust":-1,"modRightFender":-1,"modFrontBumper":-1,"model":272929391,"modSuspension":-1,"color1":0,"modOrnaments":-1,"pearlescentColor":1,"modWheelVariat":false,"modTurbo":false,"modPlateHolder":-1,"modVanityPlate":-1,"color4":[8,8,8],"windowTint":-1,"modTyresBurst":1,"modSteeringWheel":-1,"engineHealth":1000,"intcolor":0,"modAerials":-1,"modSideSkirt":-1,"modXenon":false}', 'tempesta', NULL, NULL, 1, 'Garage_A', 0, 'car', '0');

-- Dump della struttura di tabella grauv8.ox_doorlock
CREATE TABLE IF NOT EXISTS `ox_doorlock` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.ox_doorlock: ~31 rows (circa)
DELETE FROM `ox_doorlock`;
INSERT INTO `ox_doorlock` (`id`, `name`, `data`) VALUES
	(1, 'LSPD_GARAGE', '{"auto":true,"lockSound":"metal-locker","unlockSound":"metal-locker","coords":{"x":-417.36602783203127,"y":-334.4985656738281,"z":34.34477996826172},"doors":[{"model":-143534454,"heading":263,"coords":{"x":-417.66668701171877,"y":-336.6378479003906,"z":34.34477996826172}},{"model":-143534454,"heading":262,"coords":{"x":-417.06536865234377,"y":-332.3592834472656,"z":34.34477996826172}}],"state":1,"maxDistance":8,"groups":{"police":0}}'),
	(2, 'LSPD_PORTE GARAGE 1', '{"heading":80,"doors":[{"coords":{"x":-380.1793518066406,"y":-379.9333801269531,"z":25.22296905517578},"heading":170,"model":2136045912},{"coords":{"x":-382.7832946777344,"y":-379.4742431640625,"z":25.22296905517578},"heading":350,"model":2136045912}],"maxDistance":2,"coords":{"x":-381.4813232421875,"y":-379.70379638671877,"z":25.22296905517578},"model":2136045912,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(3, 'LSPD_PORTE GARAGE 2', '{"heading":80,"doors":false,"maxDistance":2,"coords":{"x":-391.9684753417969,"y":-373.0829772949219,"z":25.22527885437011},"model":2136045912,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(4, 'LSPD_PORTE GARAGE 3', '{"model":2136045912,"groups":{"police":0},"doors":false,"coords":{"x":-389.0109558105469,"y":-356.3533935546875,"z":25.22406768798828},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":80}'),
	(5, 'LSPD_PORTA CELLE', '{"heading":350,"doors":false,"maxDistance":2,"coords":{"x":-387.5570068359375,"y":-411.4516906738281,"z":25.23625755310058},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(6, 'LSPD_CELLA 1', '{"heading":125,"doors":false,"maxDistance":2,"coords":{"x":-380.8143310546875,"y":-413.7320251464844,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(7, 'LSPD_CELLA 2', '{"heading":80,"doors":false,"maxDistance":2,"coords":{"x":-379.2548522949219,"y":-417.3041076660156,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(8, 'LSPD_CELLA 3', '{"heading":35,"doors":false,"maxDistance":2,"coords":{"x":-380.9226989746094,"y":-421.01934814453127,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(9, 'LSPD_CELLA 4', '{"heading":305,"doors":false,"maxDistance":2,"coords":{"x":-395.271240234375,"y":-419.58001708984377,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(10, 'LSPD_CELLA 5', '{"heading":260,"doors":false,"maxDistance":2,"coords":{"x":-396.7779846191406,"y":-416.0242614746094,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(11, 'LSPD_CELLA 6', '{"heading":215,"doors":false,"maxDistance":2,"coords":{"x":-395.1109313964844,"y":-412.3939514160156,"z":25.23634910583496},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(12, 'LSPD_INGRESSO CONTENIMENTO ', '{"heading":350,"doors":false,"maxDistance":2,"coords":{"x":-389.3796691894531,"y":-421.78863525390627,"z":25.23625755310058},"model":1176241902,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(13, 'LSPD_CONTENIMENTO 1', '{"heading":80,"doors":false,"maxDistance":2,"coords":{"x":-387.4139404296875,"y":-428.748779296875,"z":25.23319816589355},"model":1401135549,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(14, 'LSPD_CONTENIMENTO 2', '{"heading":350,"doors":false,"maxDistance":2,"coords":{"x":-390.3044128417969,"y":-433.05023193359377,"z":25.23319816589355},"model":1401135549,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(15, 'LSPD_CONTENIMENTO 3', '{"heading":260,"doors":false,"maxDistance":2,"coords":{"x":-393.0013122558594,"y":-429.2707214355469,"z":25.23319816589355},"model":1401135549,"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(16, 'LSPD_GARAGE 10-71', '{"doors":[{"coords":{"x":-365.2415771484375,"y":-277.67034912109377,"z":25.24388885498047},"heading":170,"model":-543497392},{"coords":{"x":-362.6805725097656,"y":-278.1219177246094,"z":25.24388885498047},"heading":350,"model":-543497392}],"maxDistance":2,"coords":{"x":-363.9610595703125,"y":-277.8961181640625,"z":25.24388885498047},"lockSound":"metal-locker","state":1,"groups":{"police":0},"unlockSound":"metal-locker"}'),
	(18, 'LSPD_INGRESSO LATO SX', '{"doors":[{"coords":{"x":-399.0218505859375,"y":-317.6592712402344,"z":34.2428970336914},"heading":324,"model":-1603028996},{"coords":{"x":-401.1949462890625,"y":-316.0804443359375,"z":34.2428970336914},"heading":144,"model":-1603028996}],"auto":true,"coords":{"x":-400.1083984375,"y":-316.869873046875,"z":34.2428970336914},"lockSound":"metal-locker","state":1,"unlockSound":"metal-locker","groups":{"police":0},"maxDistance":2}'),
	(19, 'LSPD_INGRESSO LATO DX', '{"doors":[{"coords":{"x":-394.10467529296877,"y":-363.2585754394531,"z":31.39771842956543},"heading":353,"model":-1603028996},{"coords":{"x":-396.77410888671877,"y":-362.9122619628906,"z":31.39771842956543},"heading":172,"model":-1603028996}],"auto":true,"coords":{"x":-395.43939208984377,"y":-363.0854187011719,"z":31.39771842956543},"lockSound":"metal-locker","state":1,"unlockSound":"metal-locker","groups":{"police":0},"maxDistance":2}'),
	(20, 'LSPD_INGRESSO MAIN', '{"unlockSound":"metal-locker","auto":true,"lockSound":"metal-locker","groups":{"police":0},"coords":{"x":-366.728271484375,"y":-355.33428955078127,"z":30.66341781616211},"state":1,"doors":[{"heading":73,"model":-1603028996,"coords":{"x":-366.33624267578127,"y":-354.0560607910156,"z":30.66341781616211}},{"heading":253,"model":-1603028996,"coords":{"x":-367.12030029296877,"y":-356.61248779296877,"z":30.66341781616211}}],"maxDistance":2}'),
	(22, 'LSPD_HELIPAD', '{"unlockSound":"metal-locker","lockSound":"metal-locker","groups":{"police":0},"coords":{"x":-405.469970703125,"y":-348.27874755859377,"z":71.34397888183594},"state":1,"doors":[{"heading":127,"model":2136045912,"coords":{"x":-404.6711120605469,"y":-349.3388977050781,"z":71.34397888183594}},{"heading":307,"model":2136045912,"coords":{"x":-406.26885986328127,"y":-347.2186279296875,"z":71.34397888183594}}],"maxDistance":2}'),
	(23, 'NOOSE_INGRESSO ', '{"unlockSound":"metal-locker","lockSound":"metal-locker","groups":{"policenoose":0},"coords":{"x":-332.2796630859375,"y":-378.21832275390627,"z":20.37302017211914},"state":1,"doors":[{"heading":170,"model":-2023754432,"coords":{"x":-331.0,"y":-378.4418640136719,"z":20.37302017211914}},{"heading":350,"model":-2023754432,"coords":{"x":-333.5593566894531,"y":-377.9947509765625,"z":20.37302017211914}}],"maxDistance":2}'),
	(25, 'NOOSE_INTERROGATORIO', '{"unlockSound":"metal-locker","lockSound":"metal-locker","groups":{"policenoose":0},"coords":{"x":-363.7430725097656,"y":-399.0619812011719,"z":20.37185668945312},"state":1,"model":-2023754432,"maxDistance":2,"doors":false,"heading":80}'),
	(26, 'NOOSE_INGRESSO LSPD', '{"unlockSound":"metal-locker","lockSound":"metal-locker","groups":{"policenoose":0},"coords":{"x":-370.953125,"y":-383.84478759765627,"z":25.24140739440918},"state":1,"doors":[{"heading":80,"model":-543497392,"coords":{"x":-370.7271423339844,"y":-382.5630798339844,"z":25.24140739440918}},{"heading":260,"model":-543497392,"coords":{"x":-371.17913818359377,"y":-385.12646484375,"z":25.24140739440918}}],"maxDistance":2}'),
	(27, 'LSPD_INTERROGATORIO 1', '{"model":2136045912,"groups":{"police":0},"doors":false,"coords":{"x":-394.81634521484377,"y":-400.914794921875,"z":25.24434852600097},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":170}'),
	(28, 'LSPD_INTERROGATORIO 2', '{"model":2136045912,"groups":{"police":0},"doors":false,"coords":{"x":-399.2298889160156,"y":-394.7256164550781,"z":25.25592803955078},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":350}'),
	(29, 'LSPD_INTERROGATORIO 3', '{"model":2136045912,"groups":{"police":0},"doors":false,"coords":{"x":-403.239501953125,"y":-399.4295654296875,"z":25.24434852600097},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":170}'),
	(30, 'LSPD_UFFICIO CAPO', '{"model":-1821777087,"groups":{"axel":0},"doors":false,"coords":{"x":-388.4878234863281,"y":-356.1365661621094,"z":48.6878547668457},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":195}'),
	(31, 'LSPD_SORVEGLIANZA', '{"model":-1821777087,"groups":{"policesorveglianza":0},"doors":false,"coords":{"x":-378.1661682128906,"y":-348.43035888671877,"z":48.6878547668457},"state":1,"maxDistance":2,"unlockSound":"metal-locker","lockSound":"metal-locker","heading":70}'),
	(32, 'AXEL_CASA 1', '{"maxDistance":8,"auto":true,"coords":{"x":1351.2730712890626,"y":-751.9868774414063,"z":67.75472259521485},"unlockSound":"metal-locker","lockSound":"metal-locker","heading":164,"doors":false,"model":1430853635,"groups":{"axel":0},"state":1}'),
	(33, 'AXEL_CASA 2', '{"maxDistance":2,"coords":{"x":1339.359619140625,"y":-758.5618896484375,"z":67.88103485107422},"unlockSound":"metal-locker","lockSound":"metal-locker","heading":164,"doors":false,"model":-1887936818,"groups":{"axel":0},"state":1}'),
	(34, 'AXEL_CASA 3', '{"maxDistance":2,"coords":{"x":1348.81396484375,"y":-766.3851318359375,"z":71.56996154785156},"unlockSound":"metal-locker","lockSound":"metal-locker","doors":[{"model":-1994228531,"heading":164,"coords":{"x":1347.7584228515626,"y":-766.0784912109375,"z":71.56887817382813}},{"model":-754478954,"heading":164,"coords":{"x":1349.86962890625,"y":-766.6918334960938,"z":71.57103729248047}}],"state":1,"groups":{"axel":0}}');

-- Dump della struttura di tabella grauv8.ox_inventory
CREATE TABLE IF NOT EXISTS `ox_inventory` (
  `owner` varchar(60) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `data` longtext,
  `lastupdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `owner` (`owner`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.ox_inventory: ~15 rows (circa)
DELETE FROM `ox_inventory`;
INSERT INTO `ox_inventory` (`owner`, `name`, `data`, `lastupdated`) VALUES
	('barcone_1_3', 'barcone_1_3', '[{"slot":1,"count":693,"name":"trapanopercussione"},{"slot":2,"count":725,"name":"blowpipe"},{"slot":3,"count":632,"name":"piedediporco"},{"slot":4,"count":695,"name":"lockpick"},{"slot":5,"count":660,"name":"tablet"}]', '2024-08-25 11:35:00'),
	('barcone_1_2', 'barcone_1_2', '[{"slot":1,"count":662,"name":"trapanopercussione"},{"slot":2,"count":670,"name":"lockpick"},{"slot":3,"count":690,"name":"tablet"},{"slot":4,"count":711,"name":"blowpipe"},{"slot":5,"count":672,"name":"piedediporco"}]', '2024-08-25 11:35:00'),
	('barcone_3_3', 'barcone_3_3', '[{"slot":1,"count":684,"name":"blowpipe"},{"slot":2,"count":703,"name":"piedediporco"},{"slot":3,"count":631,"name":"trapanopercussione"},{"slot":4,"count":696,"name":"lockpick"},{"slot":5,"count":691,"name":"tablet"}]', '2024-08-25 11:35:00'),
	('barcone_1_1', 'barcone_1_1', '[{"slot":1,"count":702,"name":"trapanopercussione"},{"slot":2,"count":704,"name":"piedediporco"},{"slot":3,"count":664,"name":"tablet"},{"slot":4,"count":680,"name":"lockpick"},{"slot":5,"count":655,"name":"blowpipe"}]', '2024-08-25 11:35:00'),
	('barcone_3_5', 'barcone_3_5', '[{"slot":1,"count":659,"name":"blowpipe"},{"slot":2,"count":671,"name":"piedediporco"},{"slot":3,"count":672,"name":"lockpick"},{"slot":4,"count":695,"name":"trapanopercussione"},{"slot":5,"count":708,"name":"tablet"}]', '2024-08-25 11:35:00'),
	('barcone_3_4', 'barcone_3_4', '[{"slot":1,"count":658,"name":"blowpipe"},{"slot":2,"count":676,"name":"piedediporco"},{"slot":3,"count":696,"name":"trapanopercussione"},{"slot":4,"count":680,"name":"tablet"},{"slot":5,"count":695,"name":"lockpick"}]', '2024-08-25 11:35:00'),
	('barcone_1_4', 'barcone_1_4', '[{"slot":1,"count":686,"name":"trapanopercussione"},{"slot":2,"count":679,"name":"piedediporco"},{"slot":3,"count":660,"name":"lockpick"},{"slot":4,"count":686,"name":"blowpipe"},{"slot":5,"count":694,"name":"tablet"}]', '2024-08-25 11:35:00'),
	('barcone_3_1', 'barcone_3_1', '[{"slot":1,"count":669,"name":"piedediporco"},{"slot":2,"count":730,"name":"tablet"},{"slot":3,"count":666,"name":"lockpick"},{"slot":4,"count":715,"name":"trapanopercussione"},{"slot":5,"count":625,"name":"blowpipe"}]', '2024-08-25 11:35:00'),
	('barcone_2_4', 'barcone_2_4', '[{"slot":1,"count":696,"name":"tablet"},{"slot":2,"count":681,"name":"lockpick"},{"slot":3,"count":643,"name":"trapanopercussione"},{"slot":4,"count":703,"name":"piedediporco"},{"slot":5,"count":682,"name":"blowpipe"}]', '2024-08-25 11:35:00'),
	('barcone_3_2', 'barcone_3_2', '[{"slot":1,"count":680,"name":"trapanopercussione"},{"slot":2,"count":655,"name":"blowpipe"},{"slot":3,"count":646,"name":"piedediporco"},{"slot":4,"count":679,"name":"lockpick"},{"slot":5,"count":745,"name":"tablet"}]', '2024-08-25 11:35:00'),
	('barcone_2_5', 'barcone_2_5', '[{"slot":1,"count":708,"name":"tablet"},{"slot":2,"count":721,"name":"trapanopercussione"},{"slot":3,"count":664,"name":"piedediporco"},{"slot":4,"count":637,"name":"lockpick"},{"slot":5,"count":675,"name":"blowpipe"}]', '2024-08-25 11:35:00'),
	('barcone_2_3', 'barcone_2_3', '[{"slot":1,"count":683,"name":"piedediporco"},{"slot":2,"count":660,"name":"blowpipe"},{"slot":3,"count":652,"name":"trapanopercussione"},{"slot":4,"count":691,"name":"tablet"},{"slot":5,"count":719,"name":"lockpick"}]', '2024-08-25 11:35:00'),
	('barcone_1_5', 'barcone_1_5', '[{"slot":1,"count":668,"name":"lockpick"},{"slot":2,"count":677,"name":"tablet"},{"slot":3,"count":679,"name":"piedediporco"},{"slot":4,"count":703,"name":"blowpipe"},{"slot":5,"count":678,"name":"trapanopercussione"}]', '2024-08-25 11:35:00'),
	('barcone_2_1', 'barcone_2_1', '[{"slot":1,"count":659,"name":"tablet"},{"slot":2,"count":661,"name":"trapanopercussione"},{"slot":3,"count":673,"name":"blowpipe"},{"slot":4,"count":707,"name":"piedediporco"},{"slot":5,"count":705,"name":"lockpick"}]', '2024-08-25 11:35:00'),
	('barcone_2_2', 'barcone_2_2', '[{"slot":1,"count":676,"name":"trapanopercussione"},{"slot":2,"count":672,"name":"lockpick"},{"slot":3,"count":699,"name":"tablet"},{"slot":4,"count":714,"name":"blowpipe"},{"slot":5,"count":644,"name":"piedediporco"}]', '2024-08-25 11:35:00');

-- Dump della struttura di tabella grauv8.phone_backups
CREATE TABLE IF NOT EXISTS `phone_backups` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_backups_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_backups: ~4 rows (circa)
DELETE FROM `phone_backups`;
INSERT INTO `phone_backups` (`id`, `phone_number`) VALUES
	('char1:110000104272811', '2052025037'),
	('char1:', '2052379014'),
	('char1:1100001120b1015', '2058402773'),
	('char1:110000147dcc2ac', '2059178797');

-- Dump della struttura di tabella grauv8.phone_clock_alarms
CREATE TABLE IF NOT EXISTS `phone_clock_alarms` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hours` int(2) NOT NULL DEFAULT '0',
  `minutes` int(2) NOT NULL DEFAULT '0',
  `label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_clock_alarms_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_clock_alarms: ~0 rows (circa)
DELETE FROM `phone_clock_alarms`;

-- Dump della struttura di tabella grauv8.phone_crypto
CREATE TABLE IF NOT EXISTS `phone_crypto` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coin` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `invested` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`coin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_crypto: ~0 rows (circa)
DELETE FROM `phone_crypto`;

-- Dump della struttura di tabella grauv8.phone_darkchat_accounts
CREATE TABLE IF NOT EXISTS `phone_darkchat_accounts` (
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_darkchat_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_darkchat_accounts: ~0 rows (circa)
DELETE FROM `phone_darkchat_accounts`;

-- Dump della struttura di tabella grauv8.phone_darkchat_channels
CREATE TABLE IF NOT EXISTS `phone_darkchat_channels` (
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_darkchat_channels: ~0 rows (circa)
DELETE FROM `phone_darkchat_channels`;

-- Dump della struttura di tabella grauv8.phone_darkchat_members
CREATE TABLE IF NOT EXISTS `phone_darkchat_members` (
  `channel_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`channel_name`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_darkchat_members_ibfk_1` FOREIGN KEY (`channel_name`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_members_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_darkchat_members: ~0 rows (circa)
DELETE FROM `phone_darkchat_members`;

-- Dump della struttura di tabella grauv8.phone_darkchat_messages
CREATE TABLE IF NOT EXISTS `phone_darkchat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `channel` (`channel`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_darkchat_messages_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `phone_darkchat_channels` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_darkchat_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_darkchat_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_darkchat_messages: ~0 rows (circa)
DELETE FROM `phone_darkchat_messages`;

-- Dump della struttura di tabella grauv8.phone_instagram_accounts
CREATE TABLE IF NOT EXISTS `phone_instagram_accounts` (
  `display_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_image` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_count` int(11) NOT NULL DEFAULT '0',
  `story_count` int(11) NOT NULL DEFAULT '0',
  `follower_count` int(11) NOT NULL DEFAULT '0',
  `following_count` int(11) NOT NULL DEFAULT '0',
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `private` tinyint(1) DEFAULT '0',
  `verified` tinyint(1) DEFAULT '0',
  `date_joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_instagram_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_accounts: ~3 rows (circa)
DELETE FROM `phone_instagram_accounts`;
INSERT INTO `phone_instagram_accounts` (`display_name`, `username`, `password`, `profile_image`, `bio`, `post_count`, `story_count`, `follower_count`, `following_count`, `phone_number`, `private`, `verified`, `date_joined`) VALUES
	('Hazard', 'haz', '$2a$11$TY/RfV672pnq56aA0Ryl9uVLjQWwqJAOGikUlu63VVctu7wo4wafe', NULL, NULL, 0, 0, 0, 0, '2058402773', 0, 0, '2024-08-06 09:32:58'),
	('Hazard4k', 'hazard', '$2a$11$E9hInahL6da2meXnZZQeI.4G/4.fff1hV1auFjktxUYzRuH7wOWp2', NULL, NULL, 0, 0, 0, 0, '2051793091', 0, 0, '2024-08-06 08:30:50'),
	('Ray', 'jackson', '$2a$11$jvQrKRtcTzlOljhzXVxOFuH9.LygEBb.fv5rAqnU9nVsBaR1Kr2Tu', NULL, NULL, 0, 0, 0, 0, '2052025037', 0, 0, '2024-08-06 09:33:09');

-- Dump della struttura di tabella grauv8.phone_instagram_comments
CREATE TABLE IF NOT EXISTS `phone_instagram_comments` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `like_count` int(11) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `phone_instagram_posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_comments: ~0 rows (circa)
DELETE FROM `phone_instagram_comments`;

-- Dump della struttura di tabella grauv8.phone_instagram_follows
CREATE TABLE IF NOT EXISTS `phone_instagram_follows` (
  `followed` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `follower` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_instagram_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_follows: ~0 rows (circa)
DELETE FROM `phone_instagram_follows`;

-- Dump della struttura di tabella grauv8.phone_instagram_follow_requests
CREATE TABLE IF NOT EXISTS `phone_instagram_follow_requests` (
  `requester` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `requestee` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_instagram_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_follow_requests: ~0 rows (circa)
DELETE FROM `phone_instagram_follow_requests`;

-- Dump della struttura di tabella grauv8.phone_instagram_likes
CREATE TABLE IF NOT EXISTS `phone_instagram_likes` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_comment` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_likes: ~0 rows (circa)
DELETE FROM `phone_instagram_likes`;

-- Dump della struttura di tabella grauv8.phone_instagram_messages
CREATE TABLE IF NOT EXISTS `phone_instagram_messages` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_instagram_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_messages: ~0 rows (circa)
DELETE FROM `phone_instagram_messages`;

-- Dump della struttura di tabella grauv8.phone_instagram_notifications
CREATE TABLE IF NOT EXISTS `phone_instagram_notifications` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_instagram_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_instagram_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_notifications: ~0 rows (circa)
DELETE FROM `phone_instagram_notifications`;

-- Dump della struttura di tabella grauv8.phone_instagram_posts
CREATE TABLE IF NOT EXISTS `phone_instagram_posts` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `media` text COLLATE utf8mb4_unicode_ci,
  `caption` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `location` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `like_count` int(11) NOT NULL DEFAULT '0',
  `comment_count` int(11) NOT NULL DEFAULT '0',
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_posts_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_posts: ~0 rows (circa)
DELETE FROM `phone_instagram_posts`;

-- Dump della struttura di tabella grauv8.phone_instagram_stories
CREATE TABLE IF NOT EXISTS `phone_instagram_stories` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_instagram_stories_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_stories: ~0 rows (circa)
DELETE FROM `phone_instagram_stories`;

-- Dump della struttura di tabella grauv8.phone_instagram_stories_views
CREATE TABLE IF NOT EXISTS `phone_instagram_stories_views` (
  `story_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `viewer` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`story_id`,`viewer`),
  KEY `viewer` (`viewer`),
  CONSTRAINT `phone_instagram_stories_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `phone_instagram_stories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_instagram_stories_views_ibfk_2` FOREIGN KEY (`viewer`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_instagram_stories_views: ~0 rows (circa)
DELETE FROM `phone_instagram_stories_views`;

-- Dump della struttura di tabella grauv8.phone_last_phone
CREATE TABLE IF NOT EXISTS `phone_last_phone` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_last_phone_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_last_phone: ~4 rows (circa)
DELETE FROM `phone_last_phone`;
INSERT INTO `phone_last_phone` (`id`, `phone_number`) VALUES
	('char1:110000104272811', '2052025037'),
	('char1:', '2052379014'),
	('char1:1100001120b1015', '2058402773'),
	('char1:110000147dcc2ac', '2059178797');

-- Dump della struttura di tabella grauv8.phone_logged_in_accounts
CREATE TABLE IF NOT EXISTS `phone_logged_in_accounts` (
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`phone_number`,`app`,`username`),
  CONSTRAINT `phone_logged_in_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_logged_in_accounts: ~4 rows (circa)
DELETE FROM `phone_logged_in_accounts`;
INSERT INTO `phone_logged_in_accounts` (`phone_number`, `app`, `username`, `active`) VALUES
	('2051793091', 'Instagram', 'hazard', 1),
	('2052025037', 'Instagram', 'jackson', 1),
	('2058402773', 'Instagram', 'haz', 1),
	('2059178797', 'TikTok', 'hazard4k', 1);

-- Dump della struttura di tabella grauv8.phone_mail_accounts
CREATE TABLE IF NOT EXISTS `phone_mail_accounts` (
  `address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_mail_accounts: ~0 rows (circa)
DELETE FROM `phone_mail_accounts`;

-- Dump della struttura di tabella grauv8.phone_mail_deleted
CREATE TABLE IF NOT EXISTS `phone_mail_deleted` (
  `message_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`message_id`,`address`),
  KEY `address` (`address`),
  CONSTRAINT `phone_mail_deleted_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `phone_mail_messages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_mail_deleted_ibfk_2` FOREIGN KEY (`address`) REFERENCES `phone_mail_accounts` (`address`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_mail_deleted: ~0 rows (circa)
DELETE FROM `phone_mail_deleted`;

-- Dump della struttura di tabella grauv8.phone_mail_messages
CREATE TABLE IF NOT EXISTS `phone_mail_messages` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachments` longtext COLLATE utf8mb4_unicode_ci,
  `actions` longtext COLLATE utf8mb4_unicode_ci,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_mail_messages: ~0 rows (circa)
DELETE FROM `phone_mail_messages`;

-- Dump della struttura di tabella grauv8.phone_maps_locations
CREATE TABLE IF NOT EXISTS `phone_maps_locations` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `x_pos` float NOT NULL,
  `y_pos` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_maps_locations_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_maps_locations: ~0 rows (circa)
DELETE FROM `phone_maps_locations`;

-- Dump della struttura di tabella grauv8.phone_marketplace_posts
CREATE TABLE IF NOT EXISTS `phone_marketplace_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `price` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_marketplace_posts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_marketplace_posts: ~0 rows (circa)
DELETE FROM `phone_marketplace_posts`;

-- Dump della struttura di tabella grauv8.phone_message_channels
CREATE TABLE IF NOT EXISTS `phone_message_channels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_group` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_message` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `last_message_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_message_channels: ~2 rows (circa)
DELETE FROM `phone_message_channels`;
INSERT INTO `phone_message_channels` (`id`, `is_group`, `name`, `last_message`, `last_message_timestamp`) VALUES
	(1, 0, NULL, '<!CALL-NO-ANSWER!>', '2024-08-06 09:30:46'),
	(2, 0, NULL, '<!CALL-NO-ANSWER!>', '2024-08-06 12:59:26');

-- Dump della struttura di tabella grauv8.phone_message_members
CREATE TABLE IF NOT EXISTS `phone_message_members` (
  `channel_id` int(11) NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_owner` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `unread` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`channel_id`,`phone_number`),
  CONSTRAINT `phone_message_members_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_message_members: ~4 rows (circa)
DELETE FROM `phone_message_members`;
INSERT INTO `phone_message_members` (`channel_id`, `phone_number`, `is_owner`, `deleted`, `unread`) VALUES
	(1, '2052025037', 0, 0, 0),
	(1, '2058402773', 0, 0, 0),
	(2, '2052025037', 0, 0, 1),
	(2, '2059178797', 0, 0, 6);

-- Dump della struttura di tabella grauv8.phone_message_messages
CREATE TABLE IF NOT EXISTS `phone_message_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) NOT NULL,
  `sender` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_message_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_message_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_message_messages: ~9 rows (circa)
DELETE FROM `phone_message_messages`;
INSERT INTO `phone_message_messages` (`id`, `channel_id`, `sender`, `content`, `attachments`, `timestamp`) VALUES
	(1, 1, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 09:30:46'),
	(2, 1, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 12:33:05'),
	(3, 2, '2059178797', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 12:59:25'),
	(4, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:04:07'),
	(5, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:05:21'),
	(6, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:05:32'),
	(7, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:05:35'),
	(8, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:05:38'),
	(9, 2, '2052025037', '<!CALL-NO-ANSWER!>', NULL, '2024-08-06 13:05:48');

-- Dump della struttura di tabella grauv8.phone_music_playlists
CREATE TABLE IF NOT EXISTS `phone_music_playlists` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_playlists_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_music_playlists: ~0 rows (circa)
DELETE FROM `phone_music_playlists`;

-- Dump della struttura di tabella grauv8.phone_music_saved_playlists
CREATE TABLE IF NOT EXISTS `phone_music_saved_playlists` (
  `playlist_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`playlist_id`,`phone_number`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_music_saved_playlists_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE,
  CONSTRAINT `phone_music_saved_playlists_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_music_saved_playlists: ~0 rows (circa)
DELETE FROM `phone_music_saved_playlists`;

-- Dump della struttura di tabella grauv8.phone_music_songs
CREATE TABLE IF NOT EXISTS `phone_music_songs` (
  `song_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `playlist_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`song_id`,`playlist_id`),
  KEY `playlist_id` (`playlist_id`),
  CONSTRAINT `phone_music_songs_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_music_songs: ~0 rows (circa)
DELETE FROM `phone_music_songs`;

-- Dump della struttura di tabella grauv8.phone_notes
CREATE TABLE IF NOT EXISTS `phone_notes` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notes_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_notes: ~0 rows (circa)
DELETE FROM `phone_notes`;

-- Dump della struttura di tabella grauv8.phone_notifications
CREATE TABLE IF NOT EXISTS `phone_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `show_avatar` tinyint(1) DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_notifications_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_notifications: ~0 rows (circa)
DELETE FROM `phone_notifications`;

-- Dump della struttura di tabella grauv8.phone_phones
CREATE TABLE IF NOT EXISTS `phone_phones` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `face_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` longtext COLLATE utf8mb4_unicode_ci,
  `is_setup` tinyint(1) DEFAULT '0',
  `assigned` tinyint(1) DEFAULT '0',
  `battery` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_phones: ~5 rows (circa)
DELETE FROM `phone_phones`;
INSERT INTO `phone_phones` (`id`, `owner_id`, `phone_number`, `name`, `pin`, `face_id`, `settings`, `is_setup`, `assigned`, `battery`) VALUES
	('3msN3', 'char1:110000147dcc2ac', '2059178797', 'Axel\'s Phone', '2108', 'char1:110000147dcc2ac', '{"streamerMode":false,"sound":{"silent":false,"texttone":"default","volume":0.5,"ringtone":"default"},"display":{"theme":"dark","brightness":1,"automatic":false,"size":0.6},"time":{"twelveHourClock":false},"weather":{"celcius":false},"wallpaper":{"background":"cloud8","blur":false},"doNotDisturb":false,"version":"2.0.0","latestVersion":"2.0.1","lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"phone":{"showCallerId":true},"airplaneMode":true,"notifications":[],"name":"Axel\'s Phone","apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Home","Maps","Notes","Calculator","VoiceMemo"]],"security":{"faceId":true,"pinCode":true},"storage":{"used":8576331,"total":128000000},"locale":"it"}', 1, 1, 100),
	('6P18Z', 'char1:110000104272811', '2052025037', 'Comand. Jackson', NULL, NULL, '{"wallpaper":{"blur":false,"background":"cloud8"},"phone":{"showCallerId":true},"airplaneMode":false,"locale":"it","weather":{"celcius":true},"notifications":[],"sound":{"volume":0.5,"texttone":"default","ringtone":"default","silent":false},"version":"2.0.0","doNotDisturb":false,"streamerMode":false,"time":{"twelveHourClock":false},"display":{"theme":"dark","brightness":1,"automatic":false,"size":0.7},"lockscreen":{"layout":1,"color":"gradient","fontStyle":1},"name":"Comand. Jackson","latestVersion":"2.0.1","security":{"pinCode":false,"faceId":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Home","Maps","Notes","Calculator","VoiceMemo","Instagram"]],"storage":{"used":8576727.37,"total":128000000}}', 1, 1, 100),
	('A4582', 'char1:1100001120b1015', '2058402773', 'Testtt\'s Phone', '1111', NULL, '{"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Home","Maps","Notes","Calculator","VoiceMemo","Instagram"]],"latestVersion":"2.0.0","display":{"size":0.7,"brightness":1,"automatic":false,"theme":"dark"},"lockscreen":{"layout":1,"color":"gradient","fontStyle":1},"sound":{"silent":false,"ringtone":"default","texttone":"default","volume":0.5},"streamerMode":false,"weather":{"celcius":false},"wallpaper":{"blur":false,"background":"cloud8"},"storage":{"used":8576331,"total":128000000},"security":{"faceId":false,"pinCode":true},"locale":"en","name":"Testtt\'s Phone","doNotDisturb":false,"version":"2.0.0","airplaneMode":false,"time":{"twelveHourClock":false},"notifications":[],"phone":{"showCallerId":true}}', 1, 1, 100),
	('h5t2j', 'char1:1100001120b1015', '2051793091', 'Testtt\'s Phone', '1111', NULL, '{"display":{"size":0.7,"theme":"dark","brightness":1,"automatic":false},"locale":"en","wallpaper":{"blur":false,"background":"cloud8"},"time":{"twelveHourClock":false},"lockscreen":{"fontStyle":1,"color":"gradient","layout":1},"storage":{"total":128000000,"used":8576331},"airplaneMode":false,"weather":{"celcius":false},"doNotDisturb":false,"notifications":[],"phone":{"showCallerId":true},"name":"Testtt\'s Phone","streamerMode":false,"latestVersion":"2.0.0","security":{"pinCode":true,"faceId":false},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Home","Maps","Notes","Calculator","VoiceMemo","Instagram"]],"sound":{"texttone":"default","silent":false,"volume":0.5,"ringtone":"default"},"version":"2.0.0"}', 1, 1, 100),
	('Nf269', 'char1:', '2052379014', 'Mary\'s Phone', NULL, NULL, '{"storage":{"total":128000000,"used":8576331},"streamerMode":false,"security":{"pinCode":false,"faceId":false},"lockscreen":{"color":"gradient","layout":1,"fontStyle":1},"doNotDisturb":false,"phone":{"showCallerId":true},"apps":[["Phone","Messages","Camera","Photos"],["Settings","AppStore","Clock","Mail","Weather","Wallet","Home","Maps","Notes","Calculator","VoiceMemo"]],"notifications":[],"airplaneMode":false,"wallpaper":{"background":"cloud8","blur":false},"display":{"theme":"light","automatic":false,"brightness":1,"size":0.7},"version":"2.0.0","locale":"it","time":{"twelveHourClock":false},"sound":{"ringtone":"default","texttone":"default","volume":0.5,"silent":false},"latestVersion":"2.0.1","weather":{"celcius":false},"name":"Mary\'s Phone"}', 1, 1, 100);

-- Dump della struttura di tabella grauv8.phone_phone_blocked_numbers
CREATE TABLE IF NOT EXISTS `phone_phone_blocked_numbers` (
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blocked_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`phone_number`,`blocked_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_phone_blocked_numbers: ~0 rows (circa)
DELETE FROM `phone_phone_blocked_numbers`;

-- Dump della struttura di tabella grauv8.phone_phone_calls
CREATE TABLE IF NOT EXISTS `phone_phone_calls` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caller` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `callee` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int(11) NOT NULL DEFAULT '0',
  `answered` tinyint(1) DEFAULT '0',
  `hide_caller_id` tinyint(1) DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_phone_calls: ~21 rows (circa)
DELETE FROM `phone_phone_calls`;
INSERT INTO `phone_phone_calls` (`id`, `caller`, `callee`, `duration`, `answered`, `hide_caller_id`, `timestamp`) VALUES
	('1AM7J', '2052025037', '2059178797', 0, 0, 0, '2024-08-06 13:05:48'),
	('1pT6W', '2059178797', '2052025037', 3, 1, 0, '2024-08-06 13:05:54'),
	('22l18', '2052025037', '2059178797', 0, 0, 0, '2024-08-06 13:05:21'),
	('4ef5S', '2052025037', '2059178797', 20, 0, 0, '2024-08-06 13:04:07'),
	('526ZS', '2052025037', '2059178797', 0, 0, 0, '2024-08-06 13:05:32'),
	('75234', '2052025037', '2058402773', 11, 1, 0, '2024-08-06 09:30:21'),
	('755jm', '2059178797', '2052025037', 4, 0, 0, '2024-08-06 13:03:12'),
	('83X4S', '2059178797', '2052025037', 20, 0, 0, '2024-08-06 12:59:25'),
	('8dWz4', '2052025037', '2058402773', 0, 0, 0, '2024-08-06 09:30:46'),
	('Exy22', '2058402773', '2052025037', 30, 1, 0, '2024-08-06 09:26:04'),
	('gaJ7z', '2052025037', '2058402773', 0, 0, 0, '2024-08-06 12:33:05'),
	('gb4X8', '2059178797', '2052025037', 28, 1, 0, '2024-08-06 13:06:36'),
	('L7F56', '2058402773', '2052025037', 10, 1, 0, '2024-08-06 09:27:05'),
	('L9Qkt', '2052025037', '2059178797', 0, 0, 0, '2024-08-06 13:05:35'),
	('oTHA8', '2058402773', '2052025037', 8, 1, 0, '2024-08-06 09:29:55'),
	('rR3Bh', '2052025037', '2059178797', 0, 0, 0, '2024-08-06 13:05:38'),
	('sW3VO', '2058402773', '2052025037', 46, 1, 0, '2024-08-06 09:24:44'),
	('U1Na8', '2058402773', '2052025037', 26, 1, 0, '2024-08-06 09:25:24'),
	('Uy6b2', '2052025037', '205874568', 0, 0, 0, '2024-08-06 09:29:45'),
	('vg4W5', '2058402773', '2052025037', 24, 1, 0, '2024-08-06 09:29:31'),
	('w6117', '2052025037', '2058402773', 26, 1, 0, '2024-08-06 09:28:49');

-- Dump della struttura di tabella grauv8.phone_phone_contacts
CREATE TABLE IF NOT EXISTS `phone_phone_contacts` (
  `contact_phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `lastname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `profile_image` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favourite` tinyint(1) DEFAULT '0',
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`contact_phone_number`,`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_phone_contacts: ~4 rows (circa)
DELETE FROM `phone_phone_contacts`;
INSERT INTO `phone_phone_contacts` (`contact_phone_number`, `firstname`, `lastname`, `profile_image`, `email`, `address`, `favourite`, `phone_number`) VALUES
	('2052025037', 'ray', '', NULL, NULL, NULL, 0, '2058402773'),
	('2052025037', 'CMD - Jackson', '', NULL, NULL, NULL, 0, '2059178797'),
	('2058402773', 'Hazard', '', NULL, NULL, NULL, 0, '2052025037'),
	('2059178797', 'Axel', '', NULL, NULL, NULL, 0, '2052025037');

-- Dump della struttura di tabella grauv8.phone_phone_voicemail
CREATE TABLE IF NOT EXISTS `phone_phone_voicemail` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caller` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `callee` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int(11) NOT NULL,
  `hide_caller_id` tinyint(1) DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_phone_voicemail: ~2 rows (circa)
DELETE FROM `phone_phone_voicemail`;
INSERT INTO `phone_phone_voicemail` (`id`, `caller`, `callee`, `url`, `duration`, `hide_caller_id`, `timestamp`) VALUES
	('388B9', '2059178797', '2052025037', 'http://5.181.31.42:30120/lb-upload/uploads/455d123e-1ade-4549-9ded-4239eea39cdc.weba', 4697, 0, '2024-08-06 12:59:51'),
	('8xx2v', '2052025037', '2058402773', 'http://5.181.31.42:30120/lb-upload/uploads/dd8f314a-7b1e-4b69-bf1e-42d6abae9a65.weba', 4154, 0, '2024-08-06 12:33:30');

-- Dump della struttura di tabella grauv8.phone_photos
CREATE TABLE IF NOT EXISTS `phone_photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_video` tinyint(1) DEFAULT '0',
  `size` float NOT NULL DEFAULT '0',
  `metadata` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_favourite` tinyint(1) DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photos_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_photos: ~1 rows (circa)
DELETE FROM `phone_photos`;
INSERT INTO `phone_photos` (`id`, `phone_number`, `link`, `is_video`, `size`, `metadata`, `is_favourite`, `timestamp`) VALUES
	(10, '2052025037', 'http://5.181.31.42:30120/lb-upload/uploads/7d78cadd-b7e1-490d-a34e-717528bd403f.webp', 0, 69.03, NULL, 0, '2024-08-06 12:32:34');

-- Dump della struttura di tabella grauv8.phone_photo_albums
CREATE TABLE IF NOT EXISTS `phone_photo_albums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_photo_albums_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_photo_albums: ~0 rows (circa)
DELETE FROM `phone_photo_albums`;

-- Dump della struttura di tabella grauv8.phone_photo_album_photos
CREATE TABLE IF NOT EXISTS `phone_photo_album_photos` (
  `album_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  PRIMARY KEY (`album_id`,`photo_id`),
  KEY `photo_id` (`photo_id`),
  CONSTRAINT `phone_photo_album_photos_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `phone_photo_albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_photo_album_photos_ibfk_2` FOREIGN KEY (`photo_id`) REFERENCES `phone_photos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_photo_album_photos: ~0 rows (circa)
DELETE FROM `phone_photo_album_photos`;

-- Dump della struttura di tabella grauv8.phone_services_channels
CREATE TABLE IF NOT EXISTS `phone_services_channels` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_services_channels: ~0 rows (circa)
DELETE FROM `phone_services_channels`;

-- Dump della struttura di tabella grauv8.phone_services_messages
CREATE TABLE IF NOT EXISTS `phone_services_messages` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `x_pos` int(11) DEFAULT NULL,
  `y_pos` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_services_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_services_channels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_services_messages: ~0 rows (circa)
DELETE FROM `phone_services_messages`;

-- Dump della struttura di tabella grauv8.phone_tiktok_accounts
CREATE TABLE IF NOT EXISTS `phone_tiktok_accounts` (
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verified` tinyint(1) DEFAULT '0',
  `follower_count` int(11) NOT NULL DEFAULT '0',
  `following_count` int(11) NOT NULL DEFAULT '0',
  `like_count` int(11) NOT NULL DEFAULT '0',
  `video_count` int(11) NOT NULL DEFAULT '0',
  `twitter` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `show_likes` tinyint(1) DEFAULT '1',
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_tiktok_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_accounts: ~1 rows (circa)
DELETE FROM `phone_tiktok_accounts`;
INSERT INTO `phone_tiktok_accounts` (`name`, `bio`, `avatar`, `username`, `password`, `verified`, `follower_count`, `following_count`, `like_count`, `video_count`, `twitter`, `instagram`, `show_likes`, `phone_number`, `date_joined`) VALUES
	('Hazard', NULL, NULL, 'hazard4k', '$2a$11$LAPmLVUFIWGU5aaMKX3QEuKXctr0CgJnFALnP8fsXZBfR2oX8C6nS', 0, 0, 0, 0, 0, NULL, NULL, 1, '2059178797', '2024-08-12 14:59:35');

-- Dump della struttura di tabella grauv8.phone_tiktok_channels
CREATE TABLE IF NOT EXISTS `phone_tiktok_channels` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_message` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_1` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_2` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `member_1` (`member_1`,`member_2`),
  KEY `member_2` (`member_2`),
  CONSTRAINT `phone_tiktok_channels_ibfk_1` FOREIGN KEY (`member_1`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_channels_ibfk_2` FOREIGN KEY (`member_2`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_channels: ~0 rows (circa)
DELETE FROM `phone_tiktok_channels`;

-- Dump della struttura di tabella grauv8.phone_tiktok_comments
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply_to` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(550) COLLATE utf8mb4_unicode_ci NOT NULL,
  `likes` int(11) NOT NULL DEFAULT '0',
  `replies` int(11) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `video_id` (`video_id`),
  KEY `username` (`username`),
  KEY `reply_to` (`reply_to`),
  CONSTRAINT `phone_tiktok_comments_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_ibfk_3` FOREIGN KEY (`reply_to`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_comments: ~0 rows (circa)
DELETE FROM `phone_tiktok_comments`;

-- Dump della struttura di tabella grauv8.phone_tiktok_comments_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments_likes` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`,`comment_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_comments_likes_ibfk_2` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_comments_likes: ~0 rows (circa)
DELETE FROM `phone_tiktok_comments_likes`;

-- Dump della struttura di tabella grauv8.phone_tiktok_follows
CREATE TABLE IF NOT EXISTS `phone_tiktok_follows` (
  `followed` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `follower` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_tiktok_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_follows: ~0 rows (circa)
DELETE FROM `phone_tiktok_follows`;

-- Dump della struttura di tabella grauv8.phone_tiktok_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_likes` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_likes_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_likes: ~0 rows (circa)
DELETE FROM `phone_tiktok_likes`;

-- Dump della struttura di tabella grauv8.phone_tiktok_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_messages` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`),
  KEY `sender` (`sender`),
  CONSTRAINT `phone_tiktok_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_messages: ~0 rows (circa)
DELETE FROM `phone_tiktok_messages`;

-- Dump della struttura di tabella grauv8.phone_tiktok_notifications
CREATE TABLE IF NOT EXISTS `phone_tiktok_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  KEY `video_id` (`video_id`),
  KEY `comment_id` (`comment_id`),
  CONSTRAINT `phone_tiktok_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_3` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_notifications_ibfk_4` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_notifications: ~0 rows (circa)
DELETE FROM `phone_tiktok_notifications`;

-- Dump della struttura di tabella grauv8.phone_tiktok_pinned_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_pinned_videos` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_pinned_videos_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_pinned_videos: ~0 rows (circa)
DELETE FROM `phone_tiktok_pinned_videos`;

-- Dump della struttura di tabella grauv8.phone_tiktok_saves
CREATE TABLE IF NOT EXISTS `phone_tiktok_saves` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_saves_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_saves_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_saves: ~0 rows (circa)
DELETE FROM `phone_tiktok_saves`;

-- Dump della struttura di tabella grauv8.phone_tiktok_unread_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_unread_messages` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `channel_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`,`channel_id`),
  KEY `channel_id` (`channel_id`),
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_unread_messages_ibfk_2` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_unread_messages: ~0 rows (circa)
DELETE FROM `phone_tiktok_unread_messages`;

-- Dump della struttura di tabella grauv8.phone_tiktok_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_videos` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `src` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caption` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` longtext COLLATE utf8mb4_unicode_ci,
  `music` text COLLATE utf8mb4_unicode_ci,
  `likes` int(11) NOT NULL DEFAULT '0',
  `comments` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `saves` int(11) NOT NULL DEFAULT '0',
  `pinned_comment` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_tiktok_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_videos: ~0 rows (circa)
DELETE FROM `phone_tiktok_videos`;

-- Dump della struttura di tabella grauv8.phone_tiktok_views
CREATE TABLE IF NOT EXISTS `phone_tiktok_views` (
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`username`,`video_id`),
  KEY `video_id` (`video_id`),
  CONSTRAINT `phone_tiktok_views_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tiktok_views_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tiktok_views: ~0 rows (circa)
DELETE FROM `phone_tiktok_views`;

-- Dump della struttura di tabella grauv8.phone_tinder_accounts
CREATE TABLE IF NOT EXISTS `phone_tinder_accounts` (
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photos` text COLLATE utf8mb4_unicode_ci,
  `bio` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date NOT NULL,
  `is_male` tinyint(1) NOT NULL,
  `interested_men` tinyint(1) NOT NULL,
  `interested_women` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`phone_number`),
  CONSTRAINT `phone_tinder_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tinder_accounts: ~0 rows (circa)
DELETE FROM `phone_tinder_accounts`;

-- Dump della struttura di tabella grauv8.phone_tinder_matches
CREATE TABLE IF NOT EXISTS `phone_tinder_matches` (
  `phone_number_1` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number_2` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `latest_message` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latest_message_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`phone_number_1`,`phone_number_2`),
  KEY `phone_number_2` (`phone_number_2`),
  CONSTRAINT `phone_tinder_matches_ibfk_1` FOREIGN KEY (`phone_number_1`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_matches_ibfk_2` FOREIGN KEY (`phone_number_2`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tinder_matches: ~0 rows (circa)
DELETE FROM `phone_tinder_matches`;

-- Dump della struttura di tabella grauv8.phone_tinder_messages
CREATE TABLE IF NOT EXISTS `phone_tinder_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_tinder_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tinder_messages: ~0 rows (circa)
DELETE FROM `phone_tinder_messages`;

-- Dump della struttura di tabella grauv8.phone_tinder_swipes
CREATE TABLE IF NOT EXISTS `phone_tinder_swipes` (
  `swiper` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `swipee` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `liked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`swiper`,`swipee`),
  KEY `swipee` (`swipee`),
  CONSTRAINT `phone_tinder_swipes_ibfk_1` FOREIGN KEY (`swiper`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_tinder_swipes_ibfk_2` FOREIGN KEY (`swipee`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_tinder_swipes: ~0 rows (circa)
DELETE FROM `phone_tinder_swipes`;

-- Dump della struttura di tabella grauv8.phone_twitter_accounts
CREATE TABLE IF NOT EXISTS `phone_twitter_accounts` (
  `display_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bio` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_image` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_header` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinned_tweet` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified` tinyint(1) DEFAULT '0',
  `follower_count` int(11) NOT NULL DEFAULT '0',
  `following_count` int(11) NOT NULL DEFAULT '0',
  `private` tinyint(1) DEFAULT '0',
  `date_joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_twitter_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_accounts: ~0 rows (circa)
DELETE FROM `phone_twitter_accounts`;

-- Dump della struttura di tabella grauv8.phone_twitter_follows
CREATE TABLE IF NOT EXISTS `phone_twitter_follows` (
  `followed` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `follower` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifications` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`followed`,`follower`),
  KEY `follower` (`follower`),
  CONSTRAINT `phone_twitter_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_follows: ~0 rows (circa)
DELETE FROM `phone_twitter_follows`;

-- Dump della struttura di tabella grauv8.phone_twitter_follow_requests
CREATE TABLE IF NOT EXISTS `phone_twitter_follow_requests` (
  `requester` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `requestee` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`requester`,`requestee`),
  KEY `requestee` (`requestee`),
  CONSTRAINT `phone_twitter_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_follow_requests: ~0 rows (circa)
DELETE FROM `phone_twitter_follow_requests`;

-- Dump della struttura di tabella grauv8.phone_twitter_hashtags
CREATE TABLE IF NOT EXISTS `phone_twitter_hashtags` (
  `hashtag` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL DEFAULT '0',
  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`hashtag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_hashtags: ~0 rows (circa)
DELETE FROM `phone_twitter_hashtags`;

-- Dump della struttura di tabella grauv8.phone_twitter_likes
CREATE TABLE IF NOT EXISTS `phone_twitter_likes` (
  `tweet_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_likes: ~0 rows (circa)
DELETE FROM `phone_twitter_likes`;

-- Dump della struttura di tabella grauv8.phone_twitter_messages
CREATE TABLE IF NOT EXISTS `phone_twitter_messages` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sender` (`sender`),
  KEY `recipient` (`recipient`),
  CONSTRAINT `phone_twitter_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_messages: ~0 rows (circa)
DELETE FROM `phone_twitter_messages`;

-- Dump della struttura di tabella grauv8.phone_twitter_notifications
CREATE TABLE IF NOT EXISTS `phone_twitter_notifications` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tweet_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `from` (`from`),
  CONSTRAINT `phone_twitter_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `phone_twitter_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_notifications: ~0 rows (circa)
DELETE FROM `phone_twitter_notifications`;

-- Dump della struttura di tabella grauv8.phone_twitter_promoted
CREATE TABLE IF NOT EXISTS `phone_twitter_promoted` (
  `tweet_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `promotions` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tweet_id`),
  CONSTRAINT `phone_twitter_promoted_ibfk_1` FOREIGN KEY (`tweet_id`) REFERENCES `phone_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_promoted: ~0 rows (circa)
DELETE FROM `phone_twitter_promoted`;

-- Dump della struttura di tabella grauv8.phone_twitter_retweets
CREATE TABLE IF NOT EXISTS `phone_twitter_retweets` (
  `tweet_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tweet_id`,`username`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_retweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_retweets: ~0 rows (circa)
DELETE FROM `phone_twitter_retweets`;

-- Dump della struttura di tabella grauv8.phone_twitter_tweets
CREATE TABLE IF NOT EXISTS `phone_twitter_tweets` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(280) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text COLLATE utf8mb4_unicode_ci,
  `reply_to` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `like_count` int(11) DEFAULT '0',
  `reply_count` int(11) DEFAULT '0',
  `retweet_count` int(11) DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  CONSTRAINT `phone_twitter_tweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_twitter_tweets: ~0 rows (circa)
DELETE FROM `phone_twitter_tweets`;

-- Dump della struttura di tabella grauv8.phone_voice_memos_recordings
CREATE TABLE IF NOT EXISTS `phone_voice_memos_recordings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_length` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_voice_memos_recordings_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_voice_memos_recordings: ~1 rows (circa)
DELETE FROM `phone_voice_memos_recordings`;
INSERT INTO `phone_voice_memos_recordings` (`id`, `phone_number`, `file_name`, `file_url`, `file_length`, `created_at`) VALUES
	(2, '2052025037', 'New Recording', 'http://5.181.31.42:30120/lb-upload/uploads/e11b2ce7-25f1-44ac-becf-77e98274e291.weba', 3, '2024-08-06 12:50:36');

-- Dump della struttura di tabella grauv8.phone_wallet_transactions
CREATE TABLE IF NOT EXISTS `phone_wallet_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL,
  `company` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `phone_number` (`phone_number`),
  CONSTRAINT `phone_wallet_transactions_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_wallet_transactions: ~0 rows (circa)
DELETE FROM `phone_wallet_transactions`;

-- Dump della struttura di tabella grauv8.phone_yellow_pages_posts
CREATE TABLE IF NOT EXISTS `phone_yellow_pages_posts` (
  `id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dump dei dati della tabella grauv8.phone_yellow_pages_posts: ~0 rows (circa)
DELETE FROM `phone_yellow_pages_posts`;

-- Dump della struttura di tabella grauv8.player_skills
CREATE TABLE IF NOT EXISTS `player_skills` (
  `identifier` varchar(50) NOT NULL,
  `skills` longtext,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.player_skills: ~10 rows (circa)
DELETE FROM `player_skills`;
INSERT INTO `player_skills` (`identifier`, `skills`) VALUES
	('char1:110000104272811', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:1100001120b1015', '{"Pesi":0,"Pedal":0.01,"Pushup":0,"Addominali":0}'),
	('char1:1100001366a3140', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:11000013e0a5287', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:11000013f57b4b2', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:110000141c19f22', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:11000014447f545', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:110000147dcc2ac', '{"Pedal":0,"Pesi":0,"Addominali":0,"Pushup":0}'),
	('char1:110000148e93ed5', '{"Pesi":0,"Pedal":0,"Pushup":0,"Addominali":0}'),
	('char1:', '{"Addominali":0,"Pesi":0,"Pushup":0,"Pedal":0}');

-- Dump della struttura di tabella grauv8.scenes
CREATE TABLE IF NOT EXISTS `scenes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `text` mediumtext COLLATE utf8mb4_bin,
  `color` mediumtext COLLATE utf8mb4_bin,
  `viewdistance` int(11) DEFAULT NULL,
  `expiration` int(11) DEFAULT NULL,
  `coords` mediumtext COLLATE utf8mb4_bin,
  `date_creation` datetime DEFAULT NULL,
  `date_deletion` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- Dump dei dati della tabella grauv8.scenes: ~1 rows (circa)
DELETE FROM `scenes`;
INSERT INTO `scenes` (`id`, `creator`, `text`, `color`, `viewdistance`, `expiration`, `coords`, `date_creation`, `date_deletion`) VALUES
	(4, 'char1:1100001120b1015', 'testtt', '#3d2be0', 7, 24, '{"x":242.6498260498047,"y":-787.112060546875,"z":30.37630462646484}', '2024-08-07 16:18:09', '2024-08-08 16:18:09');

-- Dump della struttura di tabella grauv8.society
CREATE TABLE IF NOT EXISTS `society` (
  `job` varchar(50) NOT NULL,
  `balance` varchar(50) NOT NULL DEFAULT '100000',
  PRIMARY KEY (`job`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.society: ~18 rows (circa)
DELETE FROM `society`;
INSERT INTO `society` (`job`, `balance`) VALUES
	('alamoisland', '100000'),
	('axel', '100000'),
	('brevettolspd', '100000'),
	('concessionario', '100000'),
	('dissequestro', '100000'),
	('ems', '100000'),
	('offpolice', '100000'),
	('paradisebeachclub', '100000'),
	('police', '100000'),
	('policeantigang', '100000'),
	('policecid', '100000'),
	('policenoose', '100000'),
	('policeru', '100000'),
	('policesorveglianza', '100000'),
	('policespeed', '100000'),
	('scientifica', '100000'),
	('soosywoosy', '100000'),
	('tropicalheights', '100000');

-- Dump della struttura di tabella grauv8.transitions
CREATE TABLE IF NOT EXISTS `transitions` (
  `owner` varchar(50) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `subreason` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.transitions: ~0 rows (circa)
DELETE FROM `transitions`;

-- Dump della struttura di tabella grauv8.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(50) NOT NULL DEFAULT '0',
  `accounts` longtext,
  `group` varchar(50) DEFAULT 'user',
  `inventory` longtext,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `dateofbirth` varchar(50) DEFAULT NULL,
  `height` varchar(50) DEFAULT NULL,
  `armor` varchar(50) DEFAULT '0',
  `position` varchar(50) NOT NULL DEFAULT '{"x":-269.4,"y":-955.3,"z":31.2,"heading":205.8}',
  `gameban` int(11) DEFAULT '0',
  `jail` varchar(50) DEFAULT '0',
  `is_equip` int(11) DEFAULT '1',
  `is_dead` int(11) DEFAULT '0',
  `xp` longtext,
  `newjobs` longtext,
  `metabolism` longtext,
  `skin` longtext,
  `tattoos` longtext,
  `notes` longtext,
  `tags` longtext,
  `sex` int(11) DEFAULT NULL,
  `profileImg` varchar(255) DEFAULT 'http://5.181.31.153:63104/base_pg.jpg',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.users: ~10 rows (circa)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `identifier`, `accounts`, `group`, `inventory`, `firstname`, `lastname`, `dateofbirth`, `height`, `armor`, `position`, `gameban`, `jail`, `is_equip`, `is_dead`, `xp`, `newjobs`, `metabolism`, `skin`, `tattoos`, `notes`, `tags`, `sex`, `profileImg`) VALUES
	(1, 'char1:1100001120b1015', '{"money":488976,"black_money":0,"bank":500000.0}', 'owner', '[{"slot":1,"count":1,"name":"WEAPON_PISTOL","metadata":{"durability":85.5000000000002,"ammo":7,"serial":"580364OCQ785349","registered":"Testtt Testtt","components":[]}},{"slot":2,"count":1,"name":"WEAPON_SMG","metadata":{"durability":100,"ammo":30,"serial":"280446LMB800865","registered":"Testtt Testtt","components":[]}},{"slot":3,"count":1,"name":"maschera","metadata":{"MaskId":89,"Texture":0,"description":"Numero: 89"}},{"count":18,"name":"ammo-9","slot":4},{"slot":5,"count":1,"name":"WEAPON_FLASHLIGHT","metadata":{"durability":99.8,"components":[]}},{"count":488976,"name":"money","slot":6},{"slot":7,"count":1,"name":"maschera","metadata":{"MaskId":235,"Texture":0,"description":"Numero: 235"}},{"slot":8,"count":1,"name":"WEAPON_GLOCK","metadata":{"durability":100,"ammo":0,"serial":"686321SVG589106","registered":"Testtt Testtt","components":[]}},{"slot":9,"count":1,"name":"bossolo","metadata":{"weapon":"SMG","name":"Testtt Testtt","seriale":"280446LMB800865"}},{"slot":11,"count":1,"name":"phone","metadata":{"lbPhoneNumber":"2058402773","lbPhoneName":"Testtt\'s Phone","lbFormattedNumber":"(205) 840-2773"}},{"slot":12,"count":1,"name":"documento","metadata":{"id":1,"description":"Mario Rossi","surname":"Rossi","url":"http://5.181.31.153:63104/23-8-2024-1917eaf0e24.jpg","name":"Mario","date":"01-01-2000"}},{"slot":13,"count":1,"name":"documento","metadata":{"id":1,"description":"Mario Rossi","surname":"Rossi","url":"http://5.181.31.153:63104/23-8-2024-1917eaf7911.jpg","name":"Mario","date":"01-01-2000"}},{"slot":15,"count":1,"name":"bossolo","metadata":{"weapon":"Pistol","name":"Testtt Testtt","seriale":"580364OCQ785349"}}]', 'Testtt', 'Testtt', '2000-12-12', '0', '0', '{"x":177.0,"y":-879.0,"z":11.0}', 0, '0', 1, 0, 'null', '[{"group":"dissequestro","grade":1},{"group":"police","grade":14},{"group":"concessionario","grade":2}]', '{"thirst":{"StatusName":"thirst","Value":97.34000000000003},"drogato":{"StatusName":"drogato","Value":0},"socialita":{"StatusName":"socialita","Value":59.03999999999997},"hunger":{"StatusName":"hunger","Value":97.34000000000003},"stress":{"StatusName":"stress","Value":0.0},"drunk":{"StatusName":"drunk","Value":0}}', '{"faceFeatures":{"cheeksBoneWidth":0,"chinBoneSize":0,"lipsThickness":0,"nosePeakLowering":0,"nosePeakSize":0,"noseWidth":0,"nosePeakHigh":0,"eyesOpening":0,"chinHole":0,"cheeksWidth":0,"chinBoneLenght":0,"noseBoneHigh":0,"neckThickness":0,"jawBoneBackSize":0,"chinBoneLowering":0,"cheeksBoneHigh":0,"eyeBrownHigh":0,"eyeBrownForward":0,"noseBoneTwist":0,"jawBoneWidth":0},"hair":{"style":81,"color":0,"highlight":0},"headBlend":{"skinMix":0,"shapeMix":0,"shapeSecond":0,"shapeFirst":0,"skinFirst":0,"skinSecond":0},"headOverlays":{"lipstick":{"style":0,"color":0,"opacity":0},"moleAndFreckles":{"style":0,"color":0,"opacity":0},"bodyBlemishes":{"style":0,"color":0,"opacity":0},"ageing":{"style":0,"color":0,"opacity":0},"makeUp":{"style":0,"color":0,"opacity":0},"complexion":{"style":0,"color":0,"opacity":0},"eyebrows":{"style":0,"color":0,"opacity":0},"blush":{"style":0,"color":0,"opacity":0},"blemishes":{"style":0,"color":0,"opacity":0},"beard":{"style":0,"color":0,"opacity":0},"sunDamage":{"style":0,"color":0,"opacity":0},"chestHair":{"style":0,"color":0,"opacity":0}},"model":"mp_m_freemode_01","eyeColor":0,"props":[{"texture":-1,"drawable":-1,"prop_id":2},{"texture":-1,"drawable":-1,"prop_id":6},{"texture":-1,"drawable":-1,"prop_id":7},{"texture":0,"drawable":1,"prop_id":0},{"texture":0,"drawable":2,"prop_id":1}],"components":[{"texture":0,"drawable":0,"component_id":0},{"texture":0,"drawable":0,"component_id":1},{"texture":0,"drawable":81,"component_id":2},{"texture":0,"drawable":15,"component_id":3},{"texture":0,"drawable":13,"component_id":4},{"texture":0,"drawable":0,"component_id":5},{"texture":0,"drawable":67,"component_id":6},{"texture":0,"drawable":0,"component_id":7},{"texture":0,"drawable":13,"component_id":8},{"texture":0,"drawable":0,"component_id":9},{"texture":0,"drawable":0,"component_id":10},{"texture":0,"drawable":14,"component_id":11}]}', '[{"nameHash":794584236,"collection":"new_overlays","Count":1},{"nameHash":-1918879472,"collection":"new_overlays","Count":1},{"nameHash":849060462,"collection":"new_overlays","Count":1},{"nameHash":-2096705185,"collection":"new_overlays","Count":1},{"nameHash":1827841365,"collection":"grau_overlays","Count":1}]', NULL, '[{"icon":"address-book","color":"#353D5B","label":"Criminale"}]', NULL, 'http://5.181.31.153:63104/23-8-2024-1917eaf7911.jpg'),
	(2, 'char1:110000104272811', '{"bank":25005.0,"black_money":0,"money":2000}', 'owner', '[{"count":1,"slot":1,"name":"phone","metadata":{"lbPhoneName":"Comand. Jackson","lbPhoneNumber":"2052025037","lbFormattedNumber":"(205) 202-5037"}},{"count":1,"slot":2,"name":"documento","metadata":{"name":"Ray","url":"https://media.discordapp.net/attachments/1072593076985540748/1270342027095052328/screenshot.jpg?ex=66b359b5&is=66b20835&hm=c39bf6e7155ef52d962172977ef780166e4d1555c079f0885321907ebc10ed63&","id":1,"date":"24-04-1989","description":"Ray Jackson","surname":"Jackson"}},{"count":1,"slot":3,"name":"badge","metadata":{"tipo":"police","name":"Ray Jackson","url":"https://media.discordapp.net/attachments/1072593076985540748/1270341768923316234/screenshot.jpg?ex=66b35977&is=66b207f7&hm=69cff14f8691b2700c55f45f7a0982004015005f0e250f773e28187ca5281155&","description":"Ray Jackson - Los Santos Police Department","joblabel":"LSPD - Comandante"}},{"slot":4,"name":"radio","count":1},{"count":1,"slot":5,"name":"documento","metadata":{"name":"Hazard ","url":"https://media.discordapp.net/attachments/1072593076985540748/1270363795226755092/screenshot.jpg?ex=66b36dfb&is=66b21c7b&hm=cc2f6ecc468bd73fd362d1c87ed53f19397847deb43db8a858eeedeb38681ce0&","id":1,"date":"01-01-2000","description":"Hazard  Negfr","surname":"Negfr"}},{"slot":6,"name":"trapanopercussione","count":6},{"slot":7,"name":"piedediporco","count":6},{"slot":8,"name":"money","count":2000}]', 'Ray', 'Jackson', '1989-04-24', '0', '0', '{"x":-224.0,"y":-715.0,"z":145.0}', 0, '0', 1, 0, 'null', '[{"grade":1,"group":"concessionario"},{"grade":14,"group":"police"}]', '{"drunk":{"Value":0,"StatusName":"drunk"},"stress":{"Value":0,"StatusName":"stress"},"thirst":{"Value":100,"StatusName":"thirst"},"hunger":{"Value":100,"StatusName":"hunger"},"drogato":{"Value":0,"StatusName":"drogato"}}', '{"eyeColor":27,"faceFeatures":{"cheeksBoneHigh":0,"jawBoneBackSize":-0.4,"jawBoneWidth":0.2,"noseWidth":-1,"cheeksBoneWidth":0,"chinBoneLowering":0.7,"chinHole":0,"lipsThickness":0.3,"nosePeakSize":0.2,"nosePeakHigh":0,"neckThickness":0,"chinBoneLenght":0,"cheeksWidth":1,"eyeBrownHigh":1,"noseBoneHigh":0.5,"eyeBrownForward":0,"noseBoneTwist":0,"eyesOpening":0.5,"nosePeakLowering":0,"chinBoneSize":0},"hair":{"color":0,"style":130,"highlight":0},"props":[{"drawable":-1,"prop_id":0,"texture":-1},{"drawable":7,"prop_id":1,"texture":0},{"drawable":-1,"prop_id":2,"texture":-1},{"drawable":-1,"prop_id":6,"texture":-1},{"drawable":-1,"prop_id":7,"texture":-1}],"model":"mp_m_freemode_01","components":[{"drawable":0,"component_id":0,"texture":0},{"drawable":0,"component_id":1,"texture":0},{"drawable":130,"component_id":2,"texture":0},{"drawable":214,"component_id":7,"texture":0},{"drawable":0,"component_id":9,"texture":0},{"drawable":238,"component_id":11,"texture":1},{"drawable":274,"component_id":4,"texture":0},{"drawable":111,"component_id":6,"texture":0},{"drawable":0,"component_id":10,"texture":0},{"drawable":153,"component_id":5,"texture":1},{"drawable":233,"component_id":8,"texture":0},{"drawable":21,"component_id":3,"texture":0}],"headOverlays":{"sunDamage":{"color":0,"style":0,"opacity":0},"moleAndFreckles":{"color":0,"style":0,"opacity":0},"lipstick":{"color":62,"style":0,"opacity":0},"ageing":{"color":0,"style":0,"opacity":0.3},"makeUp":{"color":56,"style":1,"opacity":0.3},"beard":{"color":0,"style":8,"opacity":1},"complexion":{"color":0,"style":0,"opacity":0},"chestHair":{"color":0,"style":0,"opacity":0},"bodyBlemishes":{"color":0,"style":0,"opacity":0},"blemishes":{"color":0,"style":0,"opacity":0},"eyebrows":{"color":0,"style":23,"opacity":1},"blush":{"color":56,"style":21,"opacity":1}},"headBlend":{"skinMix":0.3,"skinFirst":25,"shapeFirst":0,"skinSecond":0,"shapeSecond":0,"shapeMix":0.5}}', NULL, 't awfa ggh aw fwa f', '[{"label":"Criminale","icon":"address-book","color":"#353D5B"}]', NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(3, 'char1:', '{"bank":25000,"black_money":0,"money":5000}', 'owner', '[{"metadata":{"lbPhoneNumber":"2052379014","lbFormattedNumber":"(205) 237-9014","lbPhoneName":"Mary\'s Phone"},"count":1,"slot":1,"name":"phone"},{"metadata":{"durability":96.40000000000016,"registered":"Mary Meyer","components":[],"ammo":9,"serial":"263973NEO504722"},"count":1,"slot":2,"name":"WEAPON_PISTOL"},{"count":5000,"slot":3,"name":"money"},{"metadata":{"MaskId":245,"Texture":0,"description":"Numero: 245"},"count":1,"slot":4,"name":"maschera"},{"count":1,"slot":5,"name":"radio"},{"count":1,"slot":6,"name":"bodycam"},{"count":260,"slot":7,"name":"ammo-9"},{"metadata":{"durability":100,"registered":"Mary Meyer","components":[],"ammo":0,"serial":"683612LWL422769"},"count":1,"slot":8,"name":"WEAPON_PISTOL"}]', 'Mary', 'Meyer', '1988-08-18', '0', '0', '{"x":-1516.0,"y":-3281.0,"z":13.0}', 0, '0', 1, 0, 'null', '[{"grade":10,"group":"police"}]', '{"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"},"hunger":{"Value":100,"StatusName":"hunger"},"drogato":{"Value":0,"StatusName":"drogato"},"stress":{"Value":0,"StatusName":"stress"}}', '{"eyeColor":0,"faceFeatures":{"eyeBrownForward":0,"neckThickness":0,"jawBoneBackSize":0,"nosePeakHigh":0,"jawBoneWidth":0,"noseBoneHigh":0,"chinBoneLowering":0,"noseBoneTwist":0,"cheeksBoneHigh":0,"nosePeakLowering":0,"eyesOpening":0,"noseWidth":0,"cheeksWidth":0,"eyeBrownHigh":0,"cheeksBoneWidth":0,"chinHole":0,"lipsThickness":0,"chinBoneLenght":0,"nosePeakSize":0,"chinBoneSize":0},"model":"mp_f_freemode_01","props":[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}],"headBlend":{"skinSecond":24,"shapeFirst":21,"shapeSecond":21,"skinMix":0.5,"skinFirst":20,"shapeMix":0.5},"headOverlays":{"beard":{"color":0,"style":0,"opacity":0},"makeUp":{"color":35,"style":0,"opacity":1},"blemishes":{"color":0,"style":0,"opacity":0},"lipstick":{"color":17,"style":1,"opacity":0.3},"bodyBlemishes":{"color":0,"style":0,"opacity":0},"moleAndFreckles":{"color":0,"style":0,"opacity":0},"ageing":{"color":0,"style":0,"opacity":0},"complexion":{"color":0,"style":0,"opacity":0},"sunDamage":{"color":0,"style":0,"opacity":0},"chestHair":{"color":0,"style":0,"opacity":0},"eyebrows":{"color":7,"style":5,"opacity":0.6},"blush":{"color":3,"style":0,"opacity":0}},"hair":{"color":29,"highlight":29,"style":42},"components":[{"drawable":0,"texture":0,"component_id":0},{"drawable":0,"texture":0,"component_id":1},{"drawable":42,"texture":0,"component_id":2},{"drawable":0,"texture":0,"component_id":5},{"drawable":126,"texture":0,"component_id":7},{"drawable":14,"texture":0,"component_id":8},{"drawable":0,"texture":0,"component_id":9},{"drawable":0,"texture":0,"component_id":10},{"drawable":15,"texture":0,"component_id":3},{"drawable":74,"texture":0,"component_id":11},{"drawable":23,"texture":2,"component_id":6},{"drawable":155,"texture":0,"component_id":4}]}', NULL, NULL, '[]', NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(4, 'char1:110000141c19f22', '{"money":0,"bank":25000,"black_money":0}', 'admin', '[{"name":"WEAPON_PISTOL","metadata":{"serial":"859530XUO964171","ammo":12,"components":[],"durability":99.8,"registered":"Test Test"},"slot":1,"count":1},{"name":"ammo-9","slot":2,"count":986},{"name":"WEAPON_HEAVYPISTOL","metadata":{"serial":"585774ELT450333","ammo":0,"components":[],"durability":100,"registered":"Test Test"},"slot":3,"count":1}]', 'Test', 'Test', '1995-02-12', '0', '100', '{"x":322.0,"y":180.0,"z":104.0}', 0, '0', 1, 0, 'null', '[]', '{"drogato":{"Value":0,"StatusName":"drogato"},"stress":{"Value":0,"StatusName":"stress"},"hunger":{"Value":100,"StatusName":"hunger"},"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"}}', '{"components":[{"component_id":0,"texture":0,"drawable":0},{"component_id":1,"texture":0,"drawable":0},{"component_id":2,"texture":0,"drawable":0},{"component_id":5,"texture":0,"drawable":0},{"component_id":7,"texture":0,"drawable":0},{"component_id":8,"texture":0,"drawable":15},{"component_id":9,"texture":0,"drawable":0},{"component_id":10,"texture":0,"drawable":0},{"component_id":3,"texture":0,"drawable":15},{"component_id":11,"texture":0,"drawable":15},{"component_id":4,"texture":0,"drawable":18},{"component_id":6,"texture":0,"drawable":5}],"faceFeatures":{"jawBoneWidth":0,"chinBoneLenght":0,"cheeksBoneWidth":0,"noseBoneHigh":0,"jawBoneBackSize":0,"cheeksBoneHigh":0,"nosePeakLowering":0,"cheeksWidth":0,"chinHole":0,"nosePeakSize":0,"noseWidth":0,"chinBoneSize":0,"eyeBrownForward":0,"nosePeakHigh":0,"lipsThickness":0,"eyesOpening":0,"neckThickness":0,"eyeBrownHigh":0,"noseBoneTwist":0,"chinBoneLowering":0},"headOverlays":{"lipstick":{"color":0,"style":0,"opacity":0},"blush":{"color":0,"style":0,"opacity":0},"bodyBlemishes":{"color":0,"style":0,"opacity":0},"blemishes":{"color":0,"style":0,"opacity":0},"makeUp":{"color":0,"style":0,"opacity":0},"sunDamage":{"color":0,"style":0,"opacity":0},"complexion":{"color":0,"style":0,"opacity":0},"moleAndFreckles":{"color":0,"style":0,"opacity":0},"eyebrows":{"color":0,"style":0,"opacity":0},"beard":{"color":0,"style":0,"opacity":0},"chestHair":{"color":0,"style":0,"opacity":0},"ageing":{"color":0,"style":0,"opacity":0}},"model":"mp_m_freemode_01","hair":{"color":0,"style":0,"highlight":0},"headBlend":{"skinSecond":0,"skinMix":0,"skinFirst":0,"shapeFirst":0,"shapeSecond":0,"shapeMix":0},"props":[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}],"eyeColor":0}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(5, 'char1:1100001366a3140', '{"black_money":0,"bank":25000,"money":0}', 'owner', '[]', 'Asdasd', 'Asdasd', '2004-01-20', '0', '0', '{"x":311.0,"y":173.0,"z":104.0}', 0, '0', 1, 0, 'null', '[]', '{"stress":{"Value":0,"StatusName":"stress"},"hunger":{"Value":100,"StatusName":"hunger"},"drogato":{"Value":0,"StatusName":"drogato"},"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"}}', '{"props":[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}],"headOverlays":{"blemishes":{"color":0,"style":0,"opacity":0},"moleAndFreckles":{"color":0,"style":0,"opacity":0},"blush":{"color":0,"style":0,"opacity":0},"ageing":{"color":0,"style":0,"opacity":0},"lipstick":{"color":0,"style":0,"opacity":0},"bodyBlemishes":{"color":0,"style":0,"opacity":0},"makeUp":{"color":0,"style":0,"opacity":0},"chestHair":{"color":0,"style":0,"opacity":0},"complexion":{"color":0,"style":0,"opacity":0},"sunDamage":{"color":0,"style":0,"opacity":0},"eyebrows":{"color":0,"style":0,"opacity":0},"beard":{"color":0,"style":0,"opacity":0}},"headBlend":{"shapeMix":0,"skinFirst":0,"shapeSecond":0,"shapeFirst":0,"skinMix":0,"skinSecond":0},"eyeColor":0,"hair":{"color":0,"style":0,"highlight":0},"faceFeatures":{"lipsThickness":0,"eyeBrownHigh":0,"chinBoneSize":0,"noseBoneTwist":0,"jawBoneWidth":0,"chinBoneLowering":0,"neckThickness":0,"jawBoneBackSize":0,"nosePeakLowering":0,"chinHole":0,"cheeksWidth":0,"eyesOpening":0,"chinBoneLenght":0,"nosePeakSize":0,"cheeksBoneHigh":0,"eyeBrownForward":0,"noseWidth":0,"noseBoneHigh":0,"cheeksBoneWidth":0,"nosePeakHigh":0},"components":[{"drawable":0,"component_id":0,"texture":0},{"drawable":0,"component_id":1,"texture":0},{"drawable":0,"component_id":2,"texture":0},{"drawable":1,"component_id":3,"texture":0},{"drawable":0,"component_id":4,"texture":0},{"drawable":0,"component_id":5,"texture":0},{"drawable":64,"component_id":6,"texture":0},{"drawable":0,"component_id":7,"texture":0},{"drawable":15,"component_id":8,"texture":0},{"drawable":0,"component_id":9,"texture":0},{"drawable":0,"component_id":10,"texture":0},{"drawable":0,"component_id":11,"texture":0}],"model":"mp_m_freemode_01"}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(6, 'char1:11000013e0a5287', '{"black_money":0,"bank":25000,"money":0}', 'admin', '[]', 'Negro', 'Negro', '1998-08-15', '0', '0', '{"x":319.0,"y":176.0,"z":104.0}', 0, '0', 1, 0, 'null', '[]', '{"stress":{"Value":0,"StatusName":"stress"},"hunger":{"Value":100,"StatusName":"hunger"},"drogato":{"Value":0,"StatusName":"drogato"},"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"}}', '{"props":[{"drawable":-1,"texture":-1,"prop_id":0},{"drawable":-1,"texture":-1,"prop_id":1},{"drawable":-1,"texture":-1,"prop_id":2},{"drawable":-1,"texture":-1,"prop_id":6},{"drawable":-1,"texture":-1,"prop_id":7}],"headOverlays":{"blemishes":{"opacity":0,"style":0,"color":0},"moleAndFreckles":{"opacity":0,"style":0,"color":0},"blush":{"opacity":0,"style":0,"color":0},"lipstick":{"opacity":0,"style":0,"color":0},"beard":{"opacity":0,"style":0,"color":0},"bodyBlemishes":{"opacity":0,"style":0,"color":0},"makeUp":{"opacity":0,"style":0,"color":0},"ageing":{"opacity":0,"style":0,"color":0},"complexion":{"opacity":0,"style":0,"color":0},"sunDamage":{"opacity":0,"style":0,"color":0},"eyebrows":{"opacity":0,"style":0,"color":0},"chestHair":{"opacity":0,"style":0,"color":0}},"headBlend":{"skinFirst":0,"shapeMix":0,"skinSecond":0,"shapeFirst":0,"skinMix":0,"shapeSecond":0},"eyeColor":0,"hair":{"highlight":0,"style":0,"color":0},"faceFeatures":{"lipsThickness":0,"eyeBrownHigh":0,"chinBoneSize":0,"noseBoneTwist":0,"jawBoneWidth":0,"chinBoneLowering":0,"neckThickness":0,"jawBoneBackSize":0,"nosePeakLowering":0,"chinHole":0,"cheeksWidth":0,"eyesOpening":0,"chinBoneLenght":0,"nosePeakSize":0,"cheeksBoneHigh":0,"eyeBrownForward":0,"noseWidth":0,"noseBoneHigh":0,"cheeksBoneWidth":0,"nosePeakHigh":0},"components":[{"drawable":0,"component_id":0,"texture":0},{"drawable":0,"component_id":1,"texture":0},{"drawable":0,"component_id":2,"texture":0},{"drawable":0,"component_id":5,"texture":0},{"drawable":0,"component_id":7,"texture":0},{"drawable":0,"component_id":9,"texture":0},{"drawable":0,"component_id":10,"texture":0},{"drawable":14,"component_id":4,"texture":0},{"drawable":15,"component_id":8,"texture":0},{"drawable":15,"component_id":11,"texture":0},{"drawable":15,"component_id":3,"texture":0},{"drawable":34,"component_id":6,"texture":0}],"model":"mp_m_freemode_01"}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(7, 'char1:110000147dcc2ac', '{"money":6000,"bank":25010.0,"black_money":1864}', 'owner', '[{"name":"WEAPON_GLOCK","metadata":{"serial":"895813JFV338541","ammo":17,"components":[],"durability":26.70000000000058,"registered":"Axel Martinez"},"slot":1,"count":1},{"name":"WEAPON_M4","metadata":{"serial":"699817XYN477876","ammo":30,"components":[],"durability":99.05,"registered":"Axel Martinez"},"slot":2,"count":1},{"name":"phone","metadata":{"lbPhoneName":"Axel\'s Phone","lbFormattedNumber":"(205) 917-8797","lbPhoneNumber":"2059178797"},"slot":3,"count":1},{"name":"maschera","metadata":{"MaskId":244,"description":"Numero: 244","Texture":0},"slot":4,"count":1},{"name":"sigaro","slot":5,"count":15},{"name":"gps","slot":6,"count":1},{"name":"vetrino","metadata":{"playerName":"Axel Martinez"},"slot":7,"count":1},{"name":"black_money","slot":8,"count":1864},{"name":"money","slot":9,"count":6000},{"name":"ammo-9","slot":10,"count":17},{"name":"bodycam","slot":11,"count":1},{"name":"radio","slot":12,"count":2},{"name":"badge","metadata":{"name":"Axel Martinez","description":"Axel Martinez - Los Santos Police Department","tipo":"police","joblabel":"LSPD - Capo Polizia","url":"https://media.discordapp.net/attachments/1072593076985540748/1272573611793977436/screenshot.jpg?ex=66bb7808&is=66ba2688&hm=18ccd261bd28023bfe1689d7c93d79e150d0f9821b515e376627cff72d31b4b4&"},"slot":13,"count":1},{"name":"ammo-rifle2","slot":14,"count":451},{"name":"piedediporco","slot":15,"count":10},{"name":"badge","metadata":{"name":"Axel Martinez","description":"Axel Martinez - Los Santos Police Department","tipo":"police","joblabel":"LSPD - Capo Polizia","url":"https://media.discordapp.net/attachments/1072593076985540748/1272674493663416401/screenshot.jpg?ex=66bbd5fc&is=66ba847c&hm=81aa3825367248db503f8d01c3d573fead54842d0fba59a438609b604be4f5ae&"},"slot":16,"count":1}]', 'Axel', 'Martinez', '1992-09-21', '0', '100', '{"x":-2720.0,"y":1504.0,"z":110.0}', 0, '0', 1, 0, 'null', '[{"group":"scientifica","grade":1},{"group":"offpolice","grade":1},{"group":"policenoose","grade":2},{"group":"axel","grade":1},{"group":"policesorveglianza","grade":1},{"group":"police","grade":14}]', '{"drogato":{"Value":0,"StatusName":"drogato"},"stress":{"Value":0,"StatusName":"stress"},"hunger":{"Value":100,"StatusName":"hunger"},"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"}}', '{"components":[{"drawable":0,"texture":0,"component_id":0},{"drawable":0,"texture":0,"component_id":1},{"drawable":21,"texture":0,"component_id":2},{"drawable":0,"texture":0,"component_id":5},{"drawable":25,"texture":0,"component_id":6},{"drawable":232,"texture":0,"component_id":4},{"drawable":553,"texture":0,"component_id":11},{"drawable":20,"texture":0,"component_id":3},{"drawable":65,"texture":0,"component_id":9},{"drawable":210,"texture":0,"component_id":7},{"drawable":208,"texture":3,"component_id":10},{"drawable":220,"texture":1,"component_id":8}],"hair":{"highlight":29,"color":29,"style":21},"eyeColor":3,"headBlend":{"skinMix":0.4,"shapeFirst":0,"skinFirst":5,"shapeSecond":0,"shapeMix":0,"skinSecond":23},"faceFeatures":{"cheeksBoneWidth":0,"eyesOpening":0,"noseWidth":0,"cheeksWidth":0,"chinBoneLowering":0,"cheeksBoneHigh":0,"jawBoneWidth":0,"nosePeakHigh":0,"neckThickness":0,"chinBoneLenght":0,"eyeBrownHigh":0,"eyeBrownForward":0,"jawBoneBackSize":0,"chinBoneSize":0,"nosePeakSize":0,"noseBoneTwist":0,"chinHole":0,"nosePeakLowering":0,"lipsThickness":0,"noseBoneHigh":0},"headOverlays":{"beard":{"color":29,"opacity":1,"style":2},"eyebrows":{"color":29,"opacity":1,"style":4},"blush":{"color":0,"opacity":0,"style":0},"moleAndFreckles":{"color":0,"opacity":0,"style":0},"lipstick":{"color":0,"opacity":0,"style":0},"complexion":{"color":0,"opacity":0,"style":0},"makeUp":{"color":0,"opacity":0,"style":0},"ageing":{"color":0,"opacity":0,"style":0},"blemishes":{"color":0,"opacity":0,"style":0},"bodyBlemishes":{"color":0,"opacity":0,"style":0},"sunDamage":{"color":0,"opacity":0,"style":0},"chestHair":{"color":0,"opacity":0,"style":0}},"props":[{"drawable":17,"prop_id":1,"texture":0},{"drawable":-1,"prop_id":2,"texture":-1},{"drawable":-1,"prop_id":6,"texture":-1},{"drawable":-1,"prop_id":7,"texture":-1},{"drawable":-1,"prop_id":0,"texture":0}],"model":"mp_m_freemode_01"}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(8, 'char1:110000148e93ed5', '{"money":0,"bank":25000,"black_money":0}', 'owner', '[]', 'Stoo', 'Cazzoo', '1111-01-01', '0', '99', '{"x":243.0,"y":4019.0,"z":50.0}', 0, '0', 1, 0, 'null', '[]', '{"thirst":{"Value":100,"StatusName":"thirst"},"socialita":{"Value":0,"StatusName":"socialita"},"drunk":{"Value":0,"StatusName":"drunk"},"stress":{"Value":0,"StatusName":"stress"},"drogato":{"Value":0,"StatusName":"drogato"},"hunger":{"Value":100,"StatusName":"hunger"}}', '{"hair":{"color":0,"highlight":0,"style":0},"headOverlays":{"complexion":{"color":0,"opacity":0,"style":0},"moleAndFreckles":{"color":0,"opacity":0,"style":0},"beard":{"color":0,"opacity":0,"style":0},"blemishes":{"color":0,"opacity":0,"style":0},"eyebrows":{"color":0,"opacity":0,"style":0},"blush":{"color":0,"opacity":0,"style":0},"bodyBlemishes":{"color":0,"opacity":0,"style":0},"lipstick":{"color":0,"opacity":0,"style":0},"makeUp":{"color":0,"opacity":0,"style":0},"chestHair":{"color":0,"opacity":0,"style":0},"sunDamage":{"color":0,"opacity":0,"style":0},"ageing":{"color":0,"opacity":0,"style":0}},"model":"mp_f_freemode_01","components":[{"texture":0,"drawable":0,"component_id":0},{"texture":0,"drawable":0,"component_id":1},{"texture":0,"drawable":0,"component_id":2},{"texture":0,"drawable":0,"component_id":3},{"texture":0,"drawable":0,"component_id":4},{"texture":0,"drawable":0,"component_id":5},{"texture":0,"drawable":0,"component_id":6},{"texture":0,"drawable":0,"component_id":7},{"texture":0,"drawable":0,"component_id":8},{"texture":0,"drawable":0,"component_id":9},{"texture":0,"drawable":0,"component_id":10},{"texture":0,"drawable":0,"component_id":11}],"props":[{"texture":-1,"drawable":-1,"prop_id":0},{"texture":-1,"drawable":-1,"prop_id":1},{"texture":-1,"drawable":-1,"prop_id":2},{"texture":-1,"drawable":-1,"prop_id":6},{"texture":-1,"drawable":-1,"prop_id":7}],"headBlend":{"skinMix":0,"skinSecond":0,"shapeFirst":0,"skinFirst":0,"shapeMix":0,"shapeSecond":0},"faceFeatures":{"noseWidth":0,"eyeBrownForward":0,"lipsThickness":0,"cheeksWidth":0,"chinBoneLowering":0,"nosePeakSize":0,"cheeksBoneWidth":0,"chinBoneLenght":0,"noseBoneHigh":0,"noseBoneTwist":0,"nosePeakLowering":0,"nosePeakHigh":0,"cheeksBoneHigh":0,"neckThickness":0,"jawBoneBackSize":0,"chinBoneSize":0,"chinHole":0,"eyeBrownHigh":0,"eyesOpening":0,"jawBoneWidth":0},"eyeColor":0}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(9, 'char1:11000013f57b4b2', '{"money":0,"bank":25000,"black_money":0}', 'owner', '[{"name":"WEAPON_PISTOL","metadata":{"serial":"207460LCH362003","ammo":0,"components":[],"durability":80.50000000000071,"registered":"Mary Meyer"},"slot":1,"count":1}]', 'Nicola', 'Ross', '1992-06-05', '0', '0', '{"x":-1473.0,"y":-2615.0,"z":14.0}', 0, '0', 1, 0, 'null', '[{"group":"police","grade":1}]', '{"drogato":{"Value":0,"StatusName":"drogato"},"stress":{"Value":0,"StatusName":"stress"},"hunger":{"Value":100,"StatusName":"hunger"},"drunk":{"Value":0,"StatusName":"drunk"},"thirst":{"Value":100,"StatusName":"thirst"}}', '{"eyeColor":0,"components":[{"drawable":0,"component_id":0,"texture":0},{"drawable":0,"component_id":1,"texture":0},{"drawable":0,"component_id":2,"texture":0},{"drawable":1,"component_id":3,"texture":0},{"drawable":0,"component_id":4,"texture":0},{"drawable":0,"component_id":5,"texture":0},{"drawable":64,"component_id":6,"texture":0},{"drawable":0,"component_id":7,"texture":0},{"drawable":15,"component_id":8,"texture":0},{"drawable":0,"component_id":9,"texture":0},{"drawable":0,"component_id":10,"texture":0},{"drawable":0,"component_id":11,"texture":0}],"faceFeatures":{"cheeksBoneHigh":0,"jawBoneBackSize":0,"jawBoneWidth":0,"noseWidth":0,"cheeksBoneWidth":0,"noseBoneHigh":0,"noseBoneTwist":0,"chinHole":0,"nosePeakSize":0,"chinBoneLowering":0,"lipsThickness":0,"eyeBrownHigh":0,"chinBoneSize":0,"nosePeakLowering":0,"nosePeakHigh":0,"eyeBrownForward":0,"neckThickness":0,"eyesOpening":0,"cheeksWidth":0,"chinBoneLenght":0},"props":[{"prop_id":0,"drawable":-1,"texture":-1},{"prop_id":1,"drawable":-1,"texture":-1},{"prop_id":2,"drawable":-1,"texture":-1},{"prop_id":6,"drawable":-1,"texture":-1},{"prop_id":7,"drawable":-1,"texture":-1}],"model":"mp_m_freemode_01","headBlend":{"skinMix":0,"skinFirst":0,"shapeFirst":0,"skinSecond":0,"shapeSecond":0,"shapeMix":0},"headOverlays":{"sunDamage":{"color":0,"style":0,"opacity":0},"moleAndFreckles":{"color":0,"style":0,"opacity":0},"lipstick":{"color":0,"style":0,"opacity":0},"bodyBlemishes":{"color":0,"style":0,"opacity":0},"makeUp":{"color":0,"style":0,"opacity":0},"beard":{"color":0,"style":0,"opacity":0},"eyebrows":{"color":0,"style":0,"opacity":0},"chestHair":{"color":0,"style":0,"opacity":0},"blemishes":{"color":0,"style":0,"opacity":0},"complexion":{"color":0,"style":0,"opacity":0},"blush":{"color":0,"style":0,"opacity":0},"ageing":{"color":0,"style":0,"opacity":0}},"hair":{"color":0,"highlight":0,"style":0}}', NULL, NULL, NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg'),
	(10, 'char1:11000014447f545', '{"bank":25000,"black_money":0,"money":0}', 'user', '[]', 'Carlo', 'Macno', '2012-12-12', '0', '0', '{"x":-1522.0,"y":-3285.0,"z":14.0}', 0, '0', 1, 0, 'null', '[]', '{"drunk":{"Value":0,"StatusName":"drunk"},"stress":{"Value":0,"StatusName":"stress"},"thirst":{"Value":100,"StatusName":"thirst"},"hunger":{"Value":100,"StatusName":"hunger"},"drogato":{"Value":0,"StatusName":"drogato"}}', '{"model":"mp_m_freemode_01","hair":{"style":0,"highlight":0,"color":0},"faceFeatures":{"nosePeakLowering":0,"chinBoneLenght":0,"neckThickness":0,"nosePeakSize":0,"cheeksBoneWidth":0,"noseBoneTwist":0,"jawBoneBackSize":0,"noseWidth":0,"chinBoneLowering":0,"noseBoneHigh":0,"chinHole":0,"chinBoneSize":0,"eyeBrownForward":0,"eyeBrownHigh":0,"lipsThickness":0,"jawBoneWidth":0,"eyesOpening":0,"cheeksWidth":0,"cheeksBoneHigh":0,"nosePeakHigh":0},"headOverlays":{"eyebrows":{"opacity":0,"style":0,"color":0},"beard":{"opacity":0,"style":0,"color":0},"chestHair":{"opacity":0,"style":0,"color":0},"blush":{"opacity":0,"style":0,"color":0},"moleAndFreckles":{"opacity":0,"style":0,"color":0},"makeUp":{"opacity":0,"style":0,"color":0},"bodyBlemishes":{"opacity":0,"style":0,"color":0},"lipstick":{"opacity":0,"style":0,"color":0},"blemishes":{"opacity":0,"style":0,"color":0},"complexion":{"opacity":0,"style":0,"color":0},"sunDamage":{"opacity":0,"style":0,"color":0},"ageing":{"opacity":0,"style":0,"color":0}},"eyeColor":0,"components":[{"texture":0,"drawable":0,"component_id":0},{"texture":0,"drawable":0,"component_id":1},{"texture":0,"drawable":0,"component_id":2},{"texture":0,"drawable":1,"component_id":3},{"texture":0,"drawable":0,"component_id":4},{"texture":0,"drawable":0,"component_id":5},{"texture":0,"drawable":64,"component_id":6},{"texture":0,"drawable":0,"component_id":7},{"texture":0,"drawable":15,"component_id":8},{"texture":0,"drawable":0,"component_id":9},{"texture":0,"drawable":0,"component_id":10},{"texture":0,"drawable":0,"component_id":11}],"headBlend":{"shapeSecond":5,"skinFirst":3,"shapeMix":0,"skinSecond":0,"shapeFirst":4,"skinMix":0},"props":[{"texture":-1,"drawable":-1,"prop_id":0},{"texture":-1,"drawable":-1,"prop_id":1},{"texture":-1,"drawable":-1,"prop_id":2},{"texture":-1,"drawable":-1,"prop_id":6},{"texture":-1,"drawable":-1,"prop_id":7}]}', NULL, 'Suca palle 22 ciao gbo gogo', NULL, NULL, 'http://5.181.31.153:63104/base_pg.jpg');

-- Dump della struttura di tabella grauv8.whitelist
CREATE TABLE IF NOT EXISTS `whitelist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- Dump dei dati della tabella grauv8.whitelist: ~10 rows (circa)
DELETE FROM `whitelist`;
INSERT INTO `whitelist` (`id`, `identifier`) VALUES
	(1, 'steam:1100001120b1015'),
	(2, 'steam:110000104272811'),
	(3, 'steam:'),
	(4, 'steam:110000141c19f22'),
	(5, 'steam:11000013e0a5287'),
	(6, 'steam:1100001366a3140'),
	(7, 'steam:110000147dcc2ac'),
	(8, 'steam:110000148e93ed5'),
	(9, 'steam:11000013f57b4b2'),
	(10, 'steam:11000014447f545');

-- Dump della struttura di trigger grauv8.phone_instagram_decrement_comment_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_decrement_comment_count
AFTER DELETE ON phone_instagram_comments
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_posts
    SET comment_count = comment_count - 1
    WHERE id = OLD.post_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_decrement_like_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_decrement_like_count
AFTER DELETE ON phone_instagram_likes
FOR EACH ROW
BEGIN
    IF OLD.is_comment = 0 THEN
        UPDATE phone_instagram_posts
        SET like_count = like_count - 1
        WHERE id = OLD.id;
    ELSE
        UPDATE phone_instagram_comments
        SET like_count = like_count - 1
        WHERE id = OLD.id;
    END IF;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_decrement_post_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_decrement_post_count
AFTER DELETE ON phone_instagram_posts
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET post_count = post_count - 1
    WHERE username = OLD.username;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_decrement_story_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_decrement_story_count
AFTER DELETE ON phone_instagram_stories
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET story_count = story_count - 1
    WHERE username = OLD.username;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_increment_comment_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_increment_comment_count
AFTER INSERT ON phone_instagram_comments
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_posts
    SET comment_count = comment_count + 1
    WHERE id = NEW.post_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_increment_like_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_increment_like_count
AFTER INSERT ON phone_instagram_likes
FOR EACH ROW
BEGIN
    IF NEW.is_comment = 0 THEN
        UPDATE phone_instagram_posts
        SET like_count = like_count + 1
        WHERE id = NEW.id;
    ELSE
        UPDATE phone_instagram_comments
        SET like_count = like_count + 1
        WHERE id = NEW.id;
    END IF;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_increment_post_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_increment_post_count
AFTER INSERT ON phone_instagram_posts
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET post_count = post_count + 1
    WHERE username = NEW.username;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_increment_story_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_increment_story_count
AFTER INSERT ON phone_instagram_stories
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET story_count = story_count + 1
    WHERE username = NEW.username;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_update_counts_after_follow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_update_counts_after_follow
AFTER INSERT ON phone_instagram_follows
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET follower_count = follower_count + 1
    WHERE username = NEW.followed;

    UPDATE phone_instagram_accounts
    SET following_count = following_count + 1
    WHERE username = NEW.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_instagram_update_counts_after_unfollow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_instagram_update_counts_after_unfollow
AFTER DELETE ON phone_instagram_follows
FOR EACH ROW
BEGIN
    UPDATE phone_instagram_accounts
    SET follower_count = follower_count - 1
    WHERE username = OLD.followed;

    UPDATE phone_instagram_accounts
    SET following_count = following_count - 1
    WHERE username = OLD.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_decrement_account_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_decrement_account_likes
AFTER DELETE ON phone_tiktok_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_accounts
    JOIN phone_tiktok_videos ON phone_tiktok_videos.username = phone_tiktok_accounts.username
    SET phone_tiktok_accounts.like_count = phone_tiktok_accounts.like_count - 1
    WHERE phone_tiktok_videos.id = OLD.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_decrement_comment_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_decrement_comment_likes
AFTER DELETE ON phone_tiktok_comments_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_comments
    SET likes = likes - 1
    WHERE id = OLD.comment_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_decrement_video_comments
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_decrement_video_comments
BEFORE DELETE ON phone_tiktok_comments
FOR EACH ROW
BEGIN
    DECLARE v_replies_count INT;

    -- Count the replies for the comment
    SELECT COUNT(*) INTO v_replies_count
    FROM phone_tiktok_comments
    WHERE reply_to = OLD.id;

    -- Update the video's comments count
    UPDATE phone_tiktok_videos
    SET comments = comments - (1 + v_replies_count)
    WHERE id = OLD.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_decrement_video_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_decrement_video_likes
AFTER DELETE ON phone_tiktok_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET likes = likes - 1
    WHERE id = OLD.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_decrement_video_saves
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_decrement_video_saves
AFTER DELETE ON phone_tiktok_saves
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET saves = saves - 1
    WHERE id = OLD.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_account_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_account_likes
AFTER INSERT ON phone_tiktok_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_accounts
    JOIN phone_tiktok_videos ON phone_tiktok_videos.username = phone_tiktok_accounts.username
    SET phone_tiktok_accounts.like_count = phone_tiktok_accounts.like_count + 1
    WHERE phone_tiktok_videos.id = NEW.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_comment_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_comment_likes
AFTER INSERT ON phone_tiktok_comments_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_comments
    SET likes = likes + 1
    WHERE id = NEW.comment_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_video_comments
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_video_comments
AFTER INSERT ON phone_tiktok_comments
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET comments = comments + 1
    WHERE id = NEW.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_video_count
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_video_count
AFTER INSERT ON phone_tiktok_videos
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_accounts
    SET video_count = video_count + 1
    WHERE username = NEW.username;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_video_likes
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_video_likes
AFTER INSERT ON phone_tiktok_likes
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET likes = likes + 1
    WHERE id = NEW.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_video_saves
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_video_saves
AFTER INSERT ON phone_tiktok_saves
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET saves = saves + 1
    WHERE id = NEW.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_increment_video_views
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_increment_video_views
AFTER INSERT ON phone_tiktok_views
FOR EACH ROW
BEGIN
    UPDATE phone_tiktok_videos
    SET views = views + 1
    WHERE id = NEW.video_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_update_counts_after_follow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_update_counts_after_follow
AFTER INSERT ON phone_tiktok_follows
FOR EACH ROW
BEGIN
    -- Increment the follower_count for the followed user
    UPDATE phone_tiktok_accounts
    SET follower_count = follower_count + 1
    WHERE username = NEW.followed;

    -- Increment the following_count for the follower user
    UPDATE phone_tiktok_accounts
    SET following_count = following_count + 1
    WHERE username = NEW.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_update_counts_after_unfollow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_update_counts_after_unfollow
AFTER DELETE ON phone_tiktok_follows
FOR EACH ROW
BEGIN
    -- Decrement the follower_count for the followed user
    UPDATE phone_tiktok_accounts
    SET follower_count = follower_count - 1
    WHERE username = OLD.followed;

    -- Decrement the following_count for the follower user
    UPDATE phone_tiktok_accounts
    SET following_count = following_count - 1
    WHERE username = OLD.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_tiktok_update_last_message
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_tiktok_update_last_message
AFTER INSERT ON phone_tiktok_messages
FOR EACH ROW
BEGIN
    DECLARE modified_content TEXT CHARACTER SET utf8mb4;

    IF NEW.content LIKE '<!SHARED-VIDEO-URL%' THEN
        SET modified_content = 'Shared a video';
    ELSEIF LENGTH(NEW.content) > 50 THEN
        SET modified_content = CONCAT(SUBSTR(NEW.content, 1, 17), '...');
    ELSE
        SET modified_content = NEW.content;
    END IF;

    UPDATE phone_tiktok_channels
    SET last_message = modified_content
    WHERE id = NEW.channel_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_counts_after_follow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_counts_after_follow
AFTER INSERT ON phone_twitter_follows
FOR EACH ROW
BEGIN
    -- Increment the follower_count for the followed user
    UPDATE phone_twitter_accounts
    SET follower_count = follower_count + 1
    WHERE username = NEW.followed;

    -- Increment the following_count for the follower user
    UPDATE phone_twitter_accounts
    SET following_count = following_count + 1
    WHERE username = NEW.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_counts_after_unfollow
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_counts_after_unfollow
AFTER DELETE ON phone_twitter_follows
FOR EACH ROW
BEGIN
    -- Decrement the follower_count for the followed user
    UPDATE phone_twitter_accounts
    SET follower_count = follower_count - 1
    WHERE username = OLD.followed;

    -- Decrement the following_count for the follower user
    UPDATE phone_twitter_accounts
    SET following_count = following_count - 1
    WHERE username = OLD.follower;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_like_count_after_like
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_like_count_after_like
AFTER INSERT ON phone_twitter_likes
FOR EACH ROW
BEGIN
    UPDATE phone_twitter_tweets
    SET like_count = like_count + 1
    WHERE id = NEW.tweet_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_like_count_after_unlike
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_like_count_after_unlike
AFTER DELETE ON phone_twitter_likes
FOR EACH ROW
BEGIN
    UPDATE phone_twitter_tweets
    SET like_count = like_count - 1
    WHERE id = OLD.tweet_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_retweet_count_after_retweet
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_retweet_count_after_retweet
AFTER INSERT ON phone_twitter_retweets
FOR EACH ROW
BEGIN
    UPDATE phone_twitter_tweets
    SET retweet_count = retweet_count + 1
    WHERE id = NEW.tweet_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Dump della struttura di trigger grauv8.phone_twitter_update_retweet_count_after_unretweet
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER phone_twitter_update_retweet_count_after_unretweet
AFTER DELETE ON phone_twitter_retweets
FOR EACH ROW
BEGIN
    UPDATE phone_twitter_tweets
    SET retweet_count = retweet_count - 1
    WHERE id = OLD.tweet_id;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;