schema.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Creato il: Feb 06, 2024 alle 17:16
-- Versione del server: 10.4.28-MariaDB
-- Versione PHP: 8.2.4

DROP DATABASE IF EXISTS artify;

CREATE DATABASE artify;

USE artify;


SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `artify`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `CommentAComment`
--

CREATE TABLE `CommentAComment` (
  `reference_comment_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Struttura della tabella `Comments`
--

CREATE TABLE `Comments` (
  `id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `tp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Struttura della tabella `Follows`
--

CREATE TABLE `Follows` (
  `id1` int(11) NOT NULL,
  `id2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dump dei dati per la tabella `Follows`
--

INSERT INTO `Follows` (`id1`, `id2`) VALUES
(2, 1),
(2, 3),
(3, 1),
(3, 2);

-- --------------------------------------------------------

--
-- Struttura della tabella `Interactions`
--

CREATE TABLE `Interactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `rec_user_id` int(11) DEFAULT NULL,
  `interaction` varchar(10) NOT NULL,
  `tp` timestamp NOT NULL DEFAULT current_timestamp(),
  `seen` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dump dei dati per la tabella `Interactions`
--

INSERT INTO `Interactions` (`id`, `user_id`, `post_id`, `rec_user_id`, `interaction`, `tp`, `seen`) VALUES
(1, 3, NULL, 2, 'follow', '2024-02-06 15:57:25', 1),
(2, 3, NULL, 1, 'follow', '2024-02-06 15:57:35', 1),
(3, 2, NULL, 3, 'follow', '2024-02-06 15:59:12', 0),
(4, 2, NULL, 1, 'follow', '2024-02-06 16:00:07', 1),
(5, 3, NULL, 1, 'follow', '2024-02-06 16:00:55', 1);

-- --------------------------------------------------------

--
-- Struttura della tabella `Messages`
--

CREATE TABLE `Messages` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `tp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dump dei dati per la tabella `Messages`
--

INSERT INTO `Messages` (`id`, `sender_id`, `receiver_id`, `content`, `tp`) VALUES
(1, 3, 2, 'ciao nicckkkkkk', '2024-02-06 16:57:51'),
(2, 3, 2, 'come va?', '2024-02-06 16:57:58'),
(3, 3, 2, 'tutto bene?', '2024-02-06 16:58:24'),
(4, 2, 3, 'tapppost', '2024-02-06 16:59:22'),
(5, 2, 3, 'come sei andato all\'esame di web?', '2024-02-06 16:59:42');

-- --------------------------------------------------------

--
-- Struttura della tabella `Posts`
--

CREATE TABLE `Posts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `image` mediumblob DEFAULT NULL,
  `description` text DEFAULT NULL,
  `tp` timestamp NOT NULL DEFAULT current_timestamp(),
  `n_like` int(11) DEFAULT 0,
  `n_dislike` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Struttura della tabella `Quotes`
--

CREATE TABLE `Quotes` (
  `id` int(11) NOT NULL,
  `content` text DEFAULT NULL,
  `quote_day` datetime DEFAULT curdate(),
  `author` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dump dei dati per la tabella `Quotes`
--

INSERT INTO `Quotes` (`id`, `content`, `quote_day`, `author`) VALUES
(3, 'La vita è per il 10% cosa ti accade e per il 90% come reagisci.', '2024-02-06 17:01:28', 'Charles R. Swindoll'),
(4, 'Ci sono due regole nella vita: 1. Non mollare mai; 2. Non dimenticare mai la regola n° 1.', '2024-02-05 17:01:28', 'Duke Ellington'),
(5, 'Se qualcosa non ti piace, cambiala. Se non puoi cambiarla, cambia il tuo atteggiamento. Non lamentarti.', '2024-02-04 17:04:04', 'Maya Angelou'),
(6, 'Se vuoi qualcosa che non hai mai avuto, devi fare qualcosa che non hai mai fatto.', '2024-02-03 17:04:04', 'Thomas Jefferson');

-- --------------------------------------------------------

--
-- Struttura della tabella `Users`
--

CREATE TABLE `Users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `first_login` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_login` timestamp NOT NULL DEFAULT current_timestamp(),
  `profile_picture` mediumblob DEFAULT NULL,
  `description` text DEFAULT NULL,
  `n_follower` int(11) DEFAULT 0,
  `n_following` int(11) DEFAULT 0,
  `n_post` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dump dei dati per la tabella `Users`
--

INSERT INTO `Users` (`id`, `username`, `mail`, `password`, `first_login`, `last_login`, `profile_picture`, `description`, `n_follower`, `n_following`, `n_post`) VALUES
(1, 'TheDarkRuler', 'TheDarkRuler@gmail.com', '$2y$10$Z4FtiWsywiSEq.JXDOJS4OffdAK8r7V7HmXCLX65X1VAtebcQY9Xu', '2024-02-06 16:00:55', '2024-02-06 15:55:15', 0xffd8ffe000104a46494600010101012c012c0000ffe100564578696600004d4d002a000000080004011a0005000000010000003e011b00050000000100000046012800030000000100020000021300030000000100010000000000000000012c000000010000012c00000001ffed002c50686f746f73686f7020332e30003842494d040400000000000f1c015a00031b25471c01000002000400ffe10c81687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f003c3f787061636b657420626567696e3d27efbbbf272069643d2757354d304d7043656869487a7265537a4e54637a6b633964273f3e0a3c783a786d706d65746120786d6c6e733a783d2761646f62653a6e733a6d6574612f2720783a786d70746b3d27496d6167653a3a45786966546f6f6c2031302e3130273e0a3c7264663a52444620786d6c6e733a7264663d27687474703a2f2f7777772e77332e6f72672f313939392f30322f32322d7264662d73796e7461782d6e7323273e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a746966663d27687474703a2f2f6e732e61646f62652e636f6d2f746966662f312e302f273e0a20203c746966663a5265736f6c7574696f6e556e69743e323c2f746966663a5265736f6c7574696f6e556e69743e0a20203c746966663a585265736f6c7574696f6e3e3330302f313c2f746966663a585265736f6c7574696f6e3e0a20203c746966663a595265736f6c7574696f6e3e3330302f313c2f746966663a595265736f6c7574696f6e3e0a203c2f7264663a4465736372697074696f6e3e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a786d704d4d3d27687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f6d6d2f273e0a20203c786d704d4d3a446f63756d656e7449443e61646f62653a646f6369643a73746f636b3a66613537623635622d613532652d346533392d386238322d6439363863323737363833613c2f786d704d4d3a446f63756d656e7449443e0a20203c786d704d4d3a496e7374616e636549443e786d702e6969643a30636433323536632d343832622d343331312d393535622d3433376236643536366265373c2f786d704d4d3a496e7374616e636549443e0a203c2f7264663a4465736372697074696f6e3e0a3c2f7264663a5244463e0a3c2f783a786d706d6574613e0a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a3c3f787061636b657420656e643d2777273f3effdb0043000503040404030504040405050506070c08070707070f0b0b090c110f1212110f111113161c1713141a1511111821181a1d1d1f1f1f13172224221e241c1e1f1effc0000b080168016801011100ffc4001c0001000300030101000000000000000000000506070203040108ffc4004410010001030201060b040707050100000000010203040511061221314151b1071332366171748191a1d1222342c11415627292a2e12435435282d2f0163353556393ffda0008010100003f00fd9600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e176edbb54f2aedca28a7b6a9da1e0bfaf68b6676b9aae1c4f678d89ee74ff00d51c3fbff7ae37f13bac6bda2de9dadea98733d9e3623bdefb576ddda7956ae515d3db4cef0e6000000000000000000e376e5bb56eab976ba68a298deaaaa9da223d32a9eb3c77a6e2cd56f028ab36e47e289e4db8f7f5fba152d4b8c35dcd998a72a31689fc3629e4fcfa5057ef5dbf5cd77eedcbb54f5d754d53f370073b17aed8ae2bb176e5aaa3ae8aa699f92774de30d770a622aca8caa23f0df8e57cfa56dd1b8ef4dca9a6de7d15615c9fc533cab73efe98f7c2d96ae5bbb6e9b96aba6ba2a8de9aa99de263d12e4000000000000000082e27e26c1d1289b757dfe5cc6f4d9a679e3d354f54333d735cd4758bbcaccbd3e2e277a6cd1cd453eeebf5ca34000125a1eb9a8e8f7795877a7c5ccef559ab9e8abddd5eb8699c31c4d83add116e9fb8cb88deab354f3cfa699eb84e8000000000000002a3c6dc594e9dcac0d3aaa6bccdb6aebe98b5f5abb99a5db95ddb955dbb5d55d75cef55554ef333db32e200000e56ae576ae5376d575515d13bd35533b4c4f6c4b4ae09e2ca751e4e9fa8d54d39911b515f445dfa55deb7800000000000002b3c77c451a462462e2d51fa6dea7ecfff003a7fcdebec65755555554d5555355533bccccef333daf8000000fb4d555354554ccd3544ef1313b4c4b53e04e228d5f127172aa8fd3acd3f6a7ff253fe6f5f6ff559c0000000000001e3d6750b3a5e9b7b36fcfd8b74ef11d754f5447ae58c6a3997f50cebb9993572aeddab95576476447a23a1e700000007a34eccbfa7e75accc6ab9376d55ca8ec9ed89f44f4367d1b50b3aa69b6736c4fd8b94ef31d74cf5c4faa5ec00000000000019bf850d566fea16f4bb557dde3fdbbbb75d731cd1ee8ef5300000000173f05faacd8d42e69776afbbc8fb76b7eaae239e3df1dcd20000000000001d39b916f130ef655d9da8b544d757aa23761f9791732b2aee55e9dee5dae6babd733bba800000001db899173172ad64d99dae5aae2ba7d713bb70c1c8b79787672ad4fd8bb44574faa63777000000000000acf84acbfd1f866e5a89daac8b94daf774cfca195000000000355f06b97391c336ed553bd58f72ab5eee98f94acc00000000000285e16ef7f77e3c76d7727e511df2a08000000002fbe092f7f7863cf6d1723e713dd0bf000000000000cdfc2c4cfeb8c3a7aa31e67f9bfa298000000000b9f82799fd71994f6e3c4fc2afead2000000000000671e166998d570abea9b1547c2afeaa58000000002e9e09a999d5736bea8b14c7c6afe8d1c00000000000517c2d58df1b032623c9aebb733eb8898ee967c000000000d07c1258db1f3f2663caae8b713ea8999ef85e80000000000057fc20e1ce5f0be4f2637aaced7a9ff4cf3fcb7648000000000d6fc1f61ce270be372a36aefef7aaff0054f37ca2160000000000001c6f5ba2edaaed5c8e5515d334d51db13d2c4357c2af4ed4f2306e6fbd9b934c4f6c754fbe3679400000001ead230abd4753c7c1b7d37ab8a667b23ae7dd1bb6fb36e8b56a8b56e3934514c534c76447439000000000000287e14b4899a6d6b1669f276b57f68eafc357e5ef8500000000017ef05ba44c45dd62f53e56f6ac6fd9f8aafcbe2be8000000000000eacbc7b5958b731afd115dabb4cd35d33d712c6b88b4abda36a9730eeef34f956abdbcba3aa7d7d53e94700000002478774abdacea96f0ed6f4d3e55dae23c8a3ae7f28f4b65c4c7b58b8b6f1ac51145ab54c534531d510ed000000000000044715687675cd3e6cd53145fa37aacdcdbc99ec9f44f5b21cec5c8c2cbb98b956a6ddeb73b554cff00ce78f4ba4000001dd838b919b976f1716dcdcbd7276a698ff9cd1e96bdc2ba1d9d0f4f8b34cc577ebdaabd736f2a7b23d11d497000000000000004271570ee36b98dcfb5acaa23eeaf6dfcb3db1dcca754d3f2f4ccbab1736ccdbb91cf1d95476c4f5c3ca00000f5697a7e5ea7974e2e1d99b9727a7b298ed99ea86adc2bc3b8da1e36f1b5dcbae3ef6f6df28ec8ef4d8000000000000003c7abe9785aae2ce3e6d98b94f4d33d15533db13d52ce388783351d3e6abd851566e3473fd98fbca63d34f5fae3e0abcc4c4cc4f34c7348000446f3111d33d0b470f7066a3a84d37b362ac2c69e7fb51f79547a29eaf5cfc1a3691a5e16958b18f85662dd3d354f4d554f6ccf5bda000000000000000022b59e1dd2755deacac5a62ecff8b6fecd7f18e9f7aa3a9783ec8a666ad3b3a8b91d545e8e4cfc639be480cce17d7f166797a6ddae3b6d6d5c7cb9d1977132ecced771722dcfed5aaa3f275726adfc8abe12edb589977a76b58b91727f66d553f924f1385f5eca98e469b7688edbbb511f3e74fe9be0fb22a98ab51cea2dc75d1669e54fc679be4b6e8dc3ba4e95b558b8b4cdd8ff0016e7daafe33d1eed92c00000000000000000003e6d1d90fa000000000000000000006f1d6eaaf271e8f2efdaa7d75c43aa752d3a9e9cfc58f5dea7eae3fad34cff00d8e1ff00fbd3f5728d4b4eaba33f167d57a9fabb68c9c7afc8bf6aaf55712edde3a8000000000000000074e5656362dbf1993916acd1fe6b95c531f34067f1b6858dbc5bbd732aa8eab34737c676841e67843bd3cd87a6d14fa6f5cdfe51f54464f1af105edf93916ac44f55bb51df3ba36febbad5fdfc6ea997313d5176698f96cf15cbf7eecef72fddaff7ab99ef754c44f4c44fb8da3b23e06d1d91f0368ec8f811111d1111ee76dbbf7ed4ef6efdda3f76b98ee7b6c6bbad58dbc56ab99111d53766a8f9ee92c6e35e20b3b72b26d5f88eab96a3be364be1f843bd1cd99a6d157a6cdcdbe53f54e6071b68593b45cbd7316a9eabd4737c63784fe2e563655bf198d916af51db6eb8aa3e4ee0000000000002662237995775ae31d1f4e9aaddbb93977a3f059e7889f4d5d1dea6eabc6face66f4e3d54615b9eab71bd5fc53f9442b9917af645d9bb9176e5eae7a6aaea9aa7e32eb00000007663debd8f762ee3ddb966b8e8aa8aa699f8c2c7a571beb387b53915519b6e3aae46d57f147e712b8e8bc63a3ea334dbb97270ef4fe0bdcd133e8aba3b96389898de27a4000000000041f11f13e9da344dbaeaf1f95b7359b73cf1fbd3f859cebdc4baa6af334debde2ac4f459b53b53efeb9f7a18000000000133a0f126a9a44c5366f78db11d366ecef4fbbae3dcd1b87389f4ed6622dd15788cadb9ecdc9e79fdd9fc49c000000001f2aaa9a699aaa988888de667a940e2de35aaa9af0b46af934f457931d33fb9f5f876a8b55555554d554cd554cef3333bcccbe000000000003ed354d354554ccc5513bc4c4ed312bcf0971ad544d185acd7caa7a28c99e98fdffafc7b5a0535535531553313131bc4c75be80000003e5554534cd554c44446f333d4cc78e38a6bd4ae5781815cd3854ced5d71cd37a7fdbdea980000000000002d9c11c535e9b729c0cfae6ac2aa76a2b9e79b33fedee69d4d515531553313131bc4c75be8000000a0f849e20989ab45c3af6e6fed35c4ff0027d7e1daa1000000000000002fbe0db8826669d1732bdf9bfb35733fc9f4f8762fc0000008ce28d569d1f46bd99cd3736e4daa67aeb9e8fafb98cddaebbb76abb72a9aebaea9aaaaa7a6667a65c400000000000001cad575dab94ddb75cd15d154554d51d3131d12d9785f55a758d1ace67345cdb917698eaae3a7ebef4a000000cd3c28ea337f56b5a7d157dde353caaa3f6eafa46df153c00000000000000170f05da8ce3ead774faeafbbc9a7954c7edd3f58dfe0d2c0000099888999e68861dab654e6ea9959757f8d76aaa3d5bf37cb6794000000000000001ead272a70b54c5cba67fecdda6a9f56fcff002ddb8c4c4c44c73c4800003c7ae5df11a2e6de89da68c7aea8fe196211cd111e800000000000000009e7898f436fd0aef8fd170af4cef35e3d154ff0c3d8000022f8b676e19d47d9abee6300000000000000000d9f84bcd9d37d9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a003fffd9, 'hey there, i am using Artify!', 2, 0, 0),
(2, 'nick', 'nick@gmail.com', '$2y$10$UnJFjWl4R99.F3Y9q683bOO5.lDMi6oJU1cV5RTKdp.OkYCUNuhYy', '2024-02-06 16:00:07', '2024-02-06 15:56:17', 0xffd8ffe000104a46494600010101012c012c0000ffe100564578696600004d4d002a000000080004011a0005000000010000003e011b00050000000100000046012800030000000100020000021300030000000100010000000000000000012c000000010000012c00000001ffed002c50686f746f73686f7020332e30003842494d040400000000000f1c015a00031b25471c01000002000400ffe10c81687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f003c3f787061636b657420626567696e3d27efbbbf272069643d2757354d304d7043656869487a7265537a4e54637a6b633964273f3e0a3c783a786d706d65746120786d6c6e733a783d2761646f62653a6e733a6d6574612f2720783a786d70746b3d27496d6167653a3a45786966546f6f6c2031302e3130273e0a3c7264663a52444620786d6c6e733a7264663d27687474703a2f2f7777772e77332e6f72672f313939392f30322f32322d7264662d73796e7461782d6e7323273e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a746966663d27687474703a2f2f6e732e61646f62652e636f6d2f746966662f312e302f273e0a20203c746966663a5265736f6c7574696f6e556e69743e323c2f746966663a5265736f6c7574696f6e556e69743e0a20203c746966663a585265736f6c7574696f6e3e3330302f313c2f746966663a585265736f6c7574696f6e3e0a20203c746966663a595265736f6c7574696f6e3e3330302f313c2f746966663a595265736f6c7574696f6e3e0a203c2f7264663a4465736372697074696f6e3e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a786d704d4d3d27687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f6d6d2f273e0a20203c786d704d4d3a446f63756d656e7449443e61646f62653a646f6369643a73746f636b3a66613537623635622d613532652d346533392d386238322d6439363863323737363833613c2f786d704d4d3a446f63756d656e7449443e0a20203c786d704d4d3a496e7374616e636549443e786d702e6969643a30636433323536632d343832622d343331312d393535622d3433376236643536366265373c2f786d704d4d3a496e7374616e636549443e0a203c2f7264663a4465736372697074696f6e3e0a3c2f7264663a5244463e0a3c2f783a786d706d6574613e0a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a3c3f787061636b657420656e643d2777273f3effdb0043000503040404030504040405050506070c08070707070f0b0b090c110f1212110f111113161c1713141a1511111821181a1d1d1f1f1f13172224221e241c1e1f1effc0000b080168016801011100ffc4001c0001000300030101000000000000000000000506070203040108ffc4004410010001030201060b040707050100000000010203040511061221314151b1071332366171748191a1d1222342c11415627292a2e12435435282d2f0163353556393ffda0008010100003f00fd9600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e176edbb54f2aedca28a7b6a9da1e0bfaf68b6676b9aae1c4f678d89ee74ff00d51c3fbff7ae37f13bac6bda2de9dadea98733d9e3623bdefb576ddda7956ae515d3db4cef0e6000000000000000000e376e5bb56eab976ba68a298deaaaa9da223d32a9eb3c77a6e2cd56f028ab36e47e289e4db8f7f5fba152d4b8c35dcd998a72a31689fc3629e4fcfa5057ef5dbf5cd77eedcbb54f5d754d53f370073b17aed8ae2bb176e5aaa3ae8aa699f92774de30d770a622aca8caa23f0df8e57cfa56dd1b8ef4dca9a6de7d15615c9fc533cab73efe98f7c2d96ae5bbb6e9b96aba6ba2a8de9aa99de263d12e4000000000000000082e27e26c1d1289b757dfe5cc6f4d9a679e3d354f54333d735cd4758bbcaccbd3e2e277a6cd1cd453eeebf5ca34000125a1eb9a8e8f7795877a7c5ccef559ab9e8abddd5eb8699c31c4d83add116e9fb8cb88deab354f3cfa699eb84e8000000000000002a3c6dc594e9dcac0d3aaa6bccdb6aebe98b5f5abb99a5db95ddb955dbb5d55d75cef55554ef333db32e200000e56ae576ae5376d575515d13bd35533b4c4f6c4b4ae09e2ca751e4e9fa8d54d39911b515f445dfa55deb7800000000000002b3c77c451a462462e2d51fa6dea7ecfff003a7fcdebec65755555554d5555355533bccccef333daf8000000fb4d555354554ccd3544ef1313b4c4b53e04e228d5f127172aa8fd3acd3f6a7ff253fe6f5f6ff559c0000000000001e3d6750b3a5e9b7b36fcfd8b74ef11d754f5447ae58c6a3997f50cebb9993572aeddab95576476447a23a1e700000007a34eccbfa7e75accc6ab9376d55ca8ec9ed89f44f4367d1b50b3aa69b6736c4fd8b94ef31d74cf5c4faa5ec00000000000019bf850d566fea16f4bb557dde3fdbbbb75d731cd1ee8ef5300000000173f05faacd8d42e69776afbbc8fb76b7eaae239e3df1dcd20000000000001d39b916f130ef655d9da8b544d757aa23761f9791732b2aee55e9dee5dae6babd733bba800000001db899173172ad64d99dae5aae2ba7d713bb70c1c8b79787672ad4fd8bb44574faa63777000000000000acf84acbfd1f866e5a89daac8b94daf774cfca195000000000355f06b97391c336ed553bd58f72ab5eee98f94acc00000000000285e16ef7f77e3c76d7727e511df2a08000000002fbe092f7f7863cf6d1723e713dd0bf000000000000cdfc2c4cfeb8c3a7aa31e67f9bfa298000000000b9f82799fd71994f6e3c4fc2afead2000000000000671e166998d570abea9b1547c2afeaa58000000002e9e09a999d5736bea8b14c7c6afe8d1c00000000000517c2d58df1b032623c9aebb733eb8898ee967c000000000d07c1258db1f3f2663caae8b713ea8999ef85e80000000000057fc20e1ce5f0be4f2637aaced7a9ff4cf3fcb7648000000000d6fc1f61ce270be372a36aefef7aaff0054f37ca2160000000000001c6f5ba2edaaed5c8e5515d334d51db13d2c4357c2af4ed4f2306e6fbd9b934c4f6c754fbe3679400000001ead230abd4753c7c1b7d37ab8a667b23ae7dd1bb6fb36e8b56a8b56e3934514c534c76447439000000000000287e14b4899a6d6b1669f276b57f68eafc357e5ef8500000000017ef05ba44c45dd62f53e56f6ac6fd9f8aafcbe2be8000000000000eacbc7b5958b731afd115dabb4cd35d33d712c6b88b4abda36a9730eeef34f956abdbcba3aa7d7d53e94700000002478774abdacea96f0ed6f4d3e55dae23c8a3ae7f28f4b65c4c7b58b8b6f1ac51145ab54c534531d510ed000000000000044715687675cd3e6cd53145fa37aacdcdbc99ec9f44f5b21cec5c8c2cbb98b956a6ddeb73b554cff00ce78f4ba4000001dd838b919b976f1716dcdcbd7276a698ff9cd1e96bdc2ba1d9d0f4f8b34cc577ebdaabd736f2a7b23d11d497000000000000004271570ee36b98dcfb5acaa23eeaf6dfcb3db1dcca754d3f2f4ccbab1736ccdbb91cf1d95476c4f5c3ca00000f5697a7e5ea7974e2e1d99b9727a7b298ed99ea86adc2bc3b8da1e36f1b5dcbae3ef6f6df28ec8ef4d8000000000000003c7abe9785aae2ce3e6d98b94f4d33d15533db13d52ce388783351d3e6abd851566e3473fd98fbca63d34f5fae3e0abcc4c4cc4f34c7348000446f3111d33d0b470f7066a3a84d37b362ac2c69e7fb51f79547a29eaf5cfc1a3691a5e16958b18f85662dd3d354f4d554f6ccf5bda000000000000000022b59e1dd2755deacac5a62ecff8b6fecd7f18e9f7aa3a9783ec8a666ad3b3a8b91d545e8e4cfc639be480cce17d7f166797a6ddae3b6d6d5c7cb9d1977132ecced771722dcfed5aaa3f275726adfc8abe12edb589977a76b58b91727f66d553f924f1385f5eca98e469b7688edbbb511f3e74fe9be0fb22a98ab51cea2dc75d1669e54fc679be4b6e8dc3ba4e95b558b8b4cdd8ff0016e7daafe33d1eed92c00000000000000000003e6d1d90fa000000000000000000006f1d6eaaf271e8f2efdaa7d75c43aa752d3a9e9cfc58f5dea7eae3fad34cff00d8e1ff00fbd3f5728d4b4eaba33f167d57a9fabb68c9c7afc8bf6aaf55712edde3a8000000000000000074e5656362dbf1993916acd1fe6b95c531f34067f1b6858dbc5bbd732aa8eab34737c676841e67843bd3cd87a6d14fa6f5cdfe51f54464f1af105edf93916ac44f55bb51df3ba36febbad5fdfc6ea997313d5176698f96cf15cbf7eecef72fddaff7ab99ef754c44f4c44fb8da3b23e06d1d91f0368ec8f811111d1111ee76dbbf7ed4ef6efdda3f76b98ee7b6c6bbad58dbc56ab99111d53766a8f9ee92c6e35e20b3b72b26d5f88eab96a3be364be1f843bd1cd99a6d157a6cdcdbe53f54e6071b68593b45cbd7316a9eabd4737c63784fe2e563655bf198d916af51db6eb8aa3e4ee0000000000002662237995775ae31d1f4e9aaddbb93977a3f059e7889f4d5d1dea6eabc6face66f4e3d54615b9eab71bd5fc53f9442b9917af645d9bb9176e5eae7a6aaea9aa7e32eb00000007663debd8f762ee3ddb966b8e8aa8aa699f8c2c7a571beb387b53915519b6e3aae46d57f147e712b8e8bc63a3ea334dbb97270ef4fe0bdcd133e8aba3b96389898de27a4000000000041f11f13e9da344dbaeaf1f95b7359b73cf1fbd3f859cebdc4baa6af334debde2ac4f459b53b53efeb9f7a18000000000133a0f126a9a44c5366f78db11d366ecef4fbbae3dcd1b87389f4ed6622dd15788cadb9ecdc9e79fdd9fc49c000000001f2aaa9a699aaa988888de667a940e2de35aaa9af0b46af934f457931d33fb9f5f876a8b55555554d554cd554cef3333bcccbe000000000003ed354d354554ccc5513bc4c4ed312bcf0971ad544d185acd7caa7a28c99e98fdffafc7b5a0535535531553313131bc4c75be80000003e5554534cd554c44446f333d4cc78e38a6bd4ae5781815cd3854ced5d71cd37a7fdbdea980000000000002d9c11c535e9b729c0cfae6ac2aa76a2b9e79b33fedee69d4d515531553313131bc4c75be8000000a0f849e20989ab45c3af6e6fed35c4ff0027d7e1daa1000000000000002fbe0db8826669d1732bdf9bfb35733fc9f4f8762fc0000008ce28d569d1f46bd99cd3736e4daa67aeb9e8fafb98cddaebbb76abb72a9aebaea9aaaaa7a6667a65c400000000000001cad575dab94ddb75cd15d154554d51d3131d12d9785f55a758d1ace67345cdb917698eaae3a7ebef4a000000cd3c28ea337f56b5a7d157dde353caaa3f6eafa46df153c00000000000000170f05da8ce3ead774faeafbbc9a7954c7edd3f58dfe0d2c0000099888999e68861dab654e6ea9959757f8d76aaa3d5bf37cb6794000000000000001ead272a70b54c5cba67fecdda6a9f56fcff002ddb8c4c4c44c73c4800003c7ae5df11a2e6de89da68c7aea8fe196211cd111e800000000000000009e7898f436fd0aef8fd170af4cef35e3d154ff0c3d8000022f8b676e19d47d9abee6300000000000000000d9f84bcd9d37d9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a003fffd9, 'i am NICK! ', 1, 2, 0),
(3, 'ettore', 'ettore@gmail.com', '$2y$10$w9DyodtU5fN2O32d5oUBnuIiUSSBvOZltB9dxszq8igWQKWD4EINK', '2024-02-06 16:00:55', '2024-02-06 15:57:04', 0xffd8ffe000104a46494600010101012c012c0000ffe100564578696600004d4d002a000000080004011a0005000000010000003e011b00050000000100000046012800030000000100020000021300030000000100010000000000000000012c000000010000012c00000001ffed002c50686f746f73686f7020332e30003842494d040400000000000f1c015a00031b25471c01000002000400ffe10c81687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f003c3f787061636b657420626567696e3d27efbbbf272069643d2757354d304d7043656869487a7265537a4e54637a6b633964273f3e0a3c783a786d706d65746120786d6c6e733a783d2761646f62653a6e733a6d6574612f2720783a786d70746b3d27496d6167653a3a45786966546f6f6c2031302e3130273e0a3c7264663a52444620786d6c6e733a7264663d27687474703a2f2f7777772e77332e6f72672f313939392f30322f32322d7264662d73796e7461782d6e7323273e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a746966663d27687474703a2f2f6e732e61646f62652e636f6d2f746966662f312e302f273e0a20203c746966663a5265736f6c7574696f6e556e69743e323c2f746966663a5265736f6c7574696f6e556e69743e0a20203c746966663a585265736f6c7574696f6e3e3330302f313c2f746966663a585265736f6c7574696f6e3e0a20203c746966663a595265736f6c7574696f6e3e3330302f313c2f746966663a595265736f6c7574696f6e3e0a203c2f7264663a4465736372697074696f6e3e0a0a203c7264663a4465736372697074696f6e207264663a61626f75743d27270a2020786d6c6e733a786d704d4d3d27687474703a2f2f6e732e61646f62652e636f6d2f7861702f312e302f6d6d2f273e0a20203c786d704d4d3a446f63756d656e7449443e61646f62653a646f6369643a73746f636b3a66613537623635622d613532652d346533392d386238322d6439363863323737363833613c2f786d704d4d3a446f63756d656e7449443e0a20203c786d704d4d3a496e7374616e636549443e786d702e6969643a30636433323536632d343832622d343331312d393535622d3433376236643536366265373c2f786d704d4d3a496e7374616e636549443e0a203c2f7264663a4465736372697074696f6e3e0a3c2f7264663a5244463e0a3c2f783a786d706d6574613e0a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200a3c3f787061636b657420656e643d2777273f3effdb0043000503040404030504040405050506070c08070707070f0b0b090c110f1212110f111113161c1713141a1511111821181a1d1d1f1f1f13172224221e241c1e1f1effc0000b080168016801011100ffc4001c0001000300030101000000000000000000000506070203040108ffc4004410010001030201060b040707050100000000010203040511061221314151b1071332366171748191a1d1222342c11415627292a2e12435435282d2f0163353556393ffda0008010100003f00fd9600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e176edbb54f2aedca28a7b6a9da1e0bfaf68b6676b9aae1c4f678d89ee74ff00d51c3fbff7ae37f13bac6bda2de9dadea98733d9e3623bdefb576ddda7956ae515d3db4cef0e6000000000000000000e376e5bb56eab976ba68a298deaaaa9da223d32a9eb3c77a6e2cd56f028ab36e47e289e4db8f7f5fba152d4b8c35dcd998a72a31689fc3629e4fcfa5057ef5dbf5cd77eedcbb54f5d754d53f370073b17aed8ae2bb176e5aaa3ae8aa699f92774de30d770a622aca8caa23f0df8e57cfa56dd1b8ef4dca9a6de7d15615c9fc533cab73efe98f7c2d96ae5bbb6e9b96aba6ba2a8de9aa99de263d12e4000000000000000082e27e26c1d1289b757dfe5cc6f4d9a679e3d354f54333d735cd4758bbcaccbd3e2e277a6cd1cd453eeebf5ca34000125a1eb9a8e8f7795877a7c5ccef559ab9e8abddd5eb8699c31c4d83add116e9fb8cb88deab354f3cfa699eb84e8000000000000002a3c6dc594e9dcac0d3aaa6bccdb6aebe98b5f5abb99a5db95ddb955dbb5d55d75cef55554ef333db32e200000e56ae576ae5376d575515d13bd35533b4c4f6c4b4ae09e2ca751e4e9fa8d54d39911b515f445dfa55deb7800000000000002b3c77c451a462462e2d51fa6dea7ecfff003a7fcdebec65755555554d5555355533bccccef333daf8000000fb4d555354554ccd3544ef1313b4c4b53e04e228d5f127172aa8fd3acd3f6a7ff253fe6f5f6ff559c0000000000001e3d6750b3a5e9b7b36fcfd8b74ef11d754f5447ae58c6a3997f50cebb9993572aeddab95576476447a23a1e700000007a34eccbfa7e75accc6ab9376d55ca8ec9ed89f44f4367d1b50b3aa69b6736c4fd8b94ef31d74cf5c4faa5ec00000000000019bf850d566fea16f4bb557dde3fdbbbb75d731cd1ee8ef5300000000173f05faacd8d42e69776afbbc8fb76b7eaae239e3df1dcd20000000000001d39b916f130ef655d9da8b544d757aa23761f9791732b2aee55e9dee5dae6babd733bba800000001db899173172ad64d99dae5aae2ba7d713bb70c1c8b79787672ad4fd8bb44574faa63777000000000000acf84acbfd1f866e5a89daac8b94daf774cfca195000000000355f06b97391c336ed553bd58f72ab5eee98f94acc00000000000285e16ef7f77e3c76d7727e511df2a08000000002fbe092f7f7863cf6d1723e713dd0bf000000000000cdfc2c4cfeb8c3a7aa31e67f9bfa298000000000b9f82799fd71994f6e3c4fc2afead2000000000000671e166998d570abea9b1547c2afeaa58000000002e9e09a999d5736bea8b14c7c6afe8d1c00000000000517c2d58df1b032623c9aebb733eb8898ee967c000000000d07c1258db1f3f2663caae8b713ea8999ef85e80000000000057fc20e1ce5f0be4f2637aaced7a9ff4cf3fcb7648000000000d6fc1f61ce270be372a36aefef7aaff0054f37ca2160000000000001c6f5ba2edaaed5c8e5515d334d51db13d2c4357c2af4ed4f2306e6fbd9b934c4f6c754fbe3679400000001ead230abd4753c7c1b7d37ab8a667b23ae7dd1bb6fb36e8b56a8b56e3934514c534c76447439000000000000287e14b4899a6d6b1669f276b57f68eafc357e5ef8500000000017ef05ba44c45dd62f53e56f6ac6fd9f8aafcbe2be8000000000000eacbc7b5958b731afd115dabb4cd35d33d712c6b88b4abda36a9730eeef34f956abdbcba3aa7d7d53e94700000002478774abdacea96f0ed6f4d3e55dae23c8a3ae7f28f4b65c4c7b58b8b6f1ac51145ab54c534531d510ed000000000000044715687675cd3e6cd53145fa37aacdcdbc99ec9f44f5b21cec5c8c2cbb98b956a6ddeb73b554cff00ce78f4ba4000001dd838b919b976f1716dcdcbd7276a698ff9cd1e96bdc2ba1d9d0f4f8b34cc577ebdaabd736f2a7b23d11d497000000000000004271570ee36b98dcfb5acaa23eeaf6dfcb3db1dcca754d3f2f4ccbab1736ccdbb91cf1d95476c4f5c3ca00000f5697a7e5ea7974e2e1d99b9727a7b298ed99ea86adc2bc3b8da1e36f1b5dcbae3ef6f6df28ec8ef4d8000000000000003c7abe9785aae2ce3e6d98b94f4d33d15533db13d52ce388783351d3e6abd851566e3473fd98fbca63d34f5fae3e0abcc4c4cc4f34c7348000446f3111d33d0b470f7066a3a84d37b362ac2c69e7fb51f79547a29eaf5cfc1a3691a5e16958b18f85662dd3d354f4d554f6ccf5bda000000000000000022b59e1dd2755deacac5a62ecff8b6fecd7f18e9f7aa3a9783ec8a666ad3b3a8b91d545e8e4cfc639be480cce17d7f166797a6ddae3b6d6d5c7cb9d1977132ecced771722dcfed5aaa3f275726adfc8abe12edb589977a76b58b91727f66d553f924f1385f5eca98e469b7688edbbb511f3e74fe9be0fb22a98ab51cea2dc75d1669e54fc679be4b6e8dc3ba4e95b558b8b4cdd8ff0016e7daafe33d1eed92c00000000000000000003e6d1d90fa000000000000000000006f1d6eaaf271e8f2efdaa7d75c43aa752d3a9e9cfc58f5dea7eae3fad34cff00d8e1ff00fbd3f5728d4b4eaba33f167d57a9fabb68c9c7afc8bf6aaf55712edde3a8000000000000000074e5656362dbf1993916acd1fe6b95c531f34067f1b6858dbc5bbd732aa8eab34737c676841e67843bd3cd87a6d14fa6f5cdfe51f54464f1af105edf93916ac44f55bb51df3ba36febbad5fdfc6ea997313d5176698f96cf15cbf7eecef72fddaff7ab99ef754c44f4c44fb8da3b23e06d1d91f0368ec8f811111d1111ee76dbbf7ed4ef6efdda3f76b98ee7b6c6bbad58dbc56ab99111d53766a8f9ee92c6e35e20b3b72b26d5f88eab96a3be364be1f843bd1cd99a6d157a6cdcdbe53f54e6071b68593b45cbd7316a9eabd4737c63784fe2e563655bf198d916af51db6eb8aa3e4ee0000000000002662237995775ae31d1f4e9aaddbb93977a3f059e7889f4d5d1dea6eabc6face66f4e3d54615b9eab71bd5fc53f9442b9917af645d9bb9176e5eae7a6aaea9aa7e32eb00000007663debd8f762ee3ddb966b8e8aa8aa699f8c2c7a571beb387b53915519b6e3aae46d57f147e712b8e8bc63a3ea334dbb97270ef4fe0bdcd133e8aba3b96389898de27a4000000000041f11f13e9da344dbaeaf1f95b7359b73cf1fbd3f859cebdc4baa6af334debde2ac4f459b53b53efeb9f7a18000000000133a0f126a9a44c5366f78db11d366ecef4fbbae3dcd1b87389f4ed6622dd15788cadb9ecdc9e79fdd9fc49c000000001f2aaa9a699aaa988888de667a940e2de35aaa9af0b46af934f457931d33fb9f5f876a8b55555554d554cd554cef3333bcccbe000000000003ed354d354554ccc5513bc4c4ed312bcf0971ad544d185acd7caa7a28c99e98fdffafc7b5a0535535531553313131bc4c75be80000003e5554534cd554c44446f333d4cc78e38a6bd4ae5781815cd3854ced5d71cd37a7fdbdea980000000000002d9c11c535e9b729c0cfae6ac2aa76a2b9e79b33fedee69d4d515531553313131bc4c75be8000000a0f849e20989ab45c3af6e6fed35c4ff0027d7e1daa1000000000000002fbe0db8826669d1732bdf9bfb35733fc9f4f8762fc0000008ce28d569d1f46bd99cd3736e4daa67aeb9e8fafb98cddaebbb76abb72a9aebaea9aaaaa7a6667a65c400000000000001cad575dab94ddb75cd15d154554d51d3131d12d9785f55a758d1ace67345cdb917698eaae3a7ebef4a000000cd3c28ea337f56b5a7d157dde353caaa3f6eafa46df153c00000000000000170f05da8ce3ead774faeafbbc9a7954c7edd3f58dfe0d2c0000099888999e68861dab654e6ea9959757f8d76aaa3d5bf37cb6794000000000000001ead272a70b54c5cba67fecdda6a9f56fcff002ddb8c4c4c44c73c4800003c7ae5df11a2e6de89da68c7aea8fe196211cd111e800000000000000009e7898f436fd0aef8fd170af4cef35e3d154ff0c3d8000022f8b676e19d47d9abee6300000000000000000d9f84bcd9d37d9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a000008be2df36751f66afb98c0000000000000000367e12f3674ef66a3b928000022f8b7cd9d47d9abee6300000000000000000d9f84bcd9d3bd9a8ee4a003fffd9, 'one piece fan', 1, 2, 0);

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `CommentAComment`
--
ALTER TABLE `CommentAComment`
  ADD PRIMARY KEY (`reference_comment_id`,`comment_id`),
  ADD KEY `comment_id` (`comment_id`);

--
-- Indici per le tabelle `Comments`
--
ALTER TABLE `Comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indici per le tabelle `Follows`
--
ALTER TABLE `Follows`
  ADD PRIMARY KEY (`id1`,`id2`),
  ADD KEY `id2` (`id2`);

--
-- Indici per le tabelle `Interactions`
--
ALTER TABLE `Interactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `rec_user_id` (`rec_user_id`);

--
-- Indici per le tabelle `Messages`
--
ALTER TABLE `Messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`);

--
-- Indici per le tabelle `Posts`
--
ALTER TABLE `Posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indici per le tabelle `Quotes`
--
ALTER TABLE `Quotes`
  ADD PRIMARY KEY (`id`);

--
-- Indici per le tabelle `Users`
--
ALTER TABLE `Users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mail` (`mail`);

--
-- AUTO_INCREMENT per le tabelle scaricate
--

--
-- AUTO_INCREMENT per la tabella `Comments`
--
ALTER TABLE `Comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT per la tabella `Interactions`
--
ALTER TABLE `Interactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT per la tabella `Messages`
--
ALTER TABLE `Messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT per la tabella `Posts`
--
ALTER TABLE `Posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT per la tabella `Quotes`
--
ALTER TABLE `Quotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT per la tabella `Users`
--
ALTER TABLE `Users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Limiti per le tabelle scaricate
--

--
-- Limiti per la tabella `CommentAComment`
--
ALTER TABLE `CommentAComment`
  ADD CONSTRAINT `CommentAComment_ibfk_1` FOREIGN KEY (`reference_comment_id`) REFERENCES `Comments` (`id`),
  ADD CONSTRAINT `CommentAComment_ibfk_2` FOREIGN KEY (`comment_id`) REFERENCES `Comments` (`id`);

--
-- Limiti per la tabella `Comments`
--
ALTER TABLE `Comments`
  ADD CONSTRAINT `Comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `Posts` (`id`),
  ADD CONSTRAINT `Comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`);

--
-- Limiti per la tabella `Follows`
--
ALTER TABLE `Follows`
  ADD CONSTRAINT `Follows_ibfk_1` FOREIGN KEY (`id1`) REFERENCES `Users` (`id`),
  ADD CONSTRAINT `Follows_ibfk_2` FOREIGN KEY (`id2`) REFERENCES `Users` (`id`);

--
-- Limiti per la tabella `Interactions`
--
ALTER TABLE `Interactions`
  ADD CONSTRAINT `Interactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`),
  ADD CONSTRAINT `Interactions_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `Posts` (`id`),
  ADD CONSTRAINT `Interactions_ibfk_3` FOREIGN KEY (`rec_user_id`) REFERENCES `Users` (`id`);

--
-- Limiti per la tabella `Messages`
--
ALTER TABLE `Messages`
  ADD CONSTRAINT `Messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `Users` (`id`),
  ADD CONSTRAINT `Messages_ibfk_2` FOREIGN KEY (`receiver_id`) REFERENCES `Users` (`id`);

--
-- Limiti per la tabella `Posts`
--
ALTER TABLE `Posts`
  ADD CONSTRAINT `Posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;