API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 18th, 2020
548
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 30.08 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 5.0.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Creato il: Feb 18, 2020 alle 11:21
  7. -- Versione del server: 10.4.11-MariaDB
  8. -- Versione PHP: 7.4.1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `agency`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Struttura della tabella `donations`
  29. --
  30.  
  31. CREATE TABLE `donations` (
  32.   `id` int(11) NOT NULL,
  33.   `userId` int(11) NOT NULL,
  34.   `listId` int(11) NOT NULL,
  35.   `amount` float NOT NULL,
  36.   `paymentMethod` varchar(128) NOT NULL,
  37.   `date` datetime NOT NULL DEFAULT current_timestamp()
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  39.  
  40. --
  41. -- Dump dei dati per la tabella `donations`
  42. --
  43.  
  44. INSERT INTO `donations` (`id`, `userId`, `listId`, `amount`, `paymentMethod`, `date`) VALUES
  45. (1, 11, 1, 123.45, 'Bank transfer', '2020-02-09 07:16:24'),
  46. (2, 11, 2, 15, 'Credit Card', '2020-02-10 07:06:30'),
  47. (3, 1, 1, 30, 'Pay Pal', '2020-02-10 10:01:41');
  48.  
  49. -- --------------------------------------------------------
  50.  
  51. --
  52. -- Struttura della tabella `email_verify_codes`
  53. --
  54.  
  55. CREATE TABLE `email_verify_codes` (
  56.   `id` int(11) NOT NULL,
  57.   `userId` int(11) NOT NULL,
  58.   `email` varchar(128) NOT NULL,
  59.   `code` varchar(32) NOT NULL,
  60.   `used` tinyint(1) NOT NULL DEFAULT 0
  61. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  62.  
  63. --
  64. -- Dump dei dati per la tabella `email_verify_codes`
  65. --
  66.  
  67. INSERT INTO `email_verify_codes` (`id`, `userId`, `email`, `code`, `used`) VALUES
  68. (1, 4, 'cyprian17a@gmail.com', 'tx06kkncz1vyh77uxvz97if49ejcdd9o', 0),
  69. (2, 5, 'bolech123@interia.pl', 'gvu2k1tjaqv131zvkpiwv1yn2vffi1i2', 0),
  70. (4, 7, 'cyprian.s.wojtas@gmail.com', '2nzedai3zsll5xvpjpdhdies8r18dwor', 0),
  71. (5, 8, 'cyprian.s.wojtas@gmail.com', 'a7ecbh4q18rjjq94hgi7laqj4j71qgzl', 0),
  72. (6, 9, 'cyprian.s.wojtas@gmail.com', 'msn7fuwqlj9bbsodmnca916iyjzjuxh2', 0),
  73. (7, 10, 'cyprian.s.wojtas@gmail.com', 'z1h9pyjd8n0vtatasxa1c59s66zk8ckj', 0),
  74. (8, 11, 'cyprian.s.wojtas@gmail.com', '61k5zvgxzmzshl1k46v3tc1s215oton8', 0),
  75. (9, 12, 'bolech123@interia.pl', 'y1ue3dzqctnlt7yrbyh8y2g5vfvdic0o', 0),
  76. (10, 13, 'jakis@adres-email.com', '4lrglyvqqqds5r5d2sv9ha27yxfubscw', 0),
  77. (11, 14, 'jakis@adres-email.pl', 'jzg1zo0mhdpondgy7nr3qqy8ebhn8p6m', 0),
  78. (12, 15, 'jakis2@adres-email.pl', 'vwn8nh0uek2gefv7z5ijhji932kzf8l2', 0),
  79. (13, 16, 'kowalski@adres-email.pl', 'k0tzx8pzuel41fx6hs09k20fug4bkh4o', 0);
  80.  
  81. -- --------------------------------------------------------
  82.  
  83. --
  84. -- Struttura della tabella `links`
  85. --
  86.  
  87. CREATE TABLE `links` (
  88.   `id` int(11) NOT NULL,
  89.   `listId` int(11) NOT NULL,
  90.   `url` varchar(32) NOT NULL,
  91.   `maxUses` int(11) NOT NULL
  92. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  93.  
  94. -- --------------------------------------------------------
  95.  
  96. --
  97. -- Struttura della tabella `lists`
  98. --
  99.  
  100. CREATE TABLE `lists` (
  101.   `id` int(11) NOT NULL,
  102.   `name` varchar(128) NOT NULL,
  103.   `description` text NOT NULL,
  104.   `userId` int(11) NOT NULL,
  105.   `goal` float NOT NULL,
  106.   `date` datetime NOT NULL DEFAULT current_timestamp()
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  108.  
  109. --
  110. -- Dump dei dati per la tabella `lists`
  111. --
  112.  
  113. INSERT INTO `lists` (`id`, `name`, `description`, `userId`, `goal`, `date`) VALUES
  114. (1, 'Schronisko dla psów', 'Zbieramy fundusze na schonisko dla miejscowych psów z Zatora. Bardzo potrzebują naszej pomocy. W obecnej sytuacji nawet po służbie muszą spać w samochodzie. Bardzo liczą na Waszą pomoc.', 14, 10000, '2020-01-29 14:06:18'),
  115. (2, 'Pomoc dla uchodźców z Polszy', 'Uchodźcy z Polszy przebywających we Włoszech potrzebują pomocy pieniężnej na przeżycie w tych ciężkich warunkach kolejnych dwóch tygodni. Liczy się każda pomoc.', 11, 500, '2020-02-07 14:12:58'),
  116. (3, 'Halo, halo, to jest test', 'Grosza daj liście mojej', 1, 0.01, '2020-02-11 12:58:12'),
  117. (4, 'Mój stary', 'Stary potrzebuje na wódę', 12, 666.66, '2020-02-18 11:21:27');
  118.  
  119. -- --------------------------------------------------------
  120.  
  121. --
  122. -- Struttura della tabella `list_members`
  123. --
  124.  
  125. CREATE TABLE `list_members` (
  126.   `id` int(11) NOT NULL,
  127.   `listId` int(11) NOT NULL,
  128.   `userId` int(11) NOT NULL,
  129.   `linkId` int(11) NOT NULL
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  131.  
  132. --
  133. -- Dump dei dati per la tabella `list_members`
  134. --
  135.  
  136. INSERT INTO `list_members` (`id`, `listId`, `userId`, `linkId`) VALUES
  137. (1, 1, 1, 1),
  138. (2, 1, 11, 1),
  139. (3, 2, 11, 1);
  140.  
  141. -- --------------------------------------------------------
  142.  
  143. --
  144. -- Struttura della tabella `notifications`
  145. --
  146.  
  147. CREATE TABLE `notifications` (
  148.   `id` int(11) NOT NULL,
  149.   `userId` int(11) NOT NULL,
  150.   `notification` varchar(1024) NOT NULL,
  151.   `date` int(11) NOT NULL DEFAULT current_timestamp(),
  152.   `readed` tinyint(1) NOT NULL DEFAULT 0
  153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  154.  
  155. -- --------------------------------------------------------
  156.  
  157. --
  158. -- Struttura della tabella `password_reset_codes`
  159. --
  160.  
  161. CREATE TABLE `password_reset_codes` (
  162.   `id` int(11) NOT NULL,
  163.   `userId` int(11) NOT NULL,
  164.   `code` varchar(128) NOT NULL,
  165.   `date` datetime NOT NULL DEFAULT current_timestamp()
  166. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  167.  
  168. --
  169. -- Dump dei dati per la tabella `password_reset_codes`
  170. --
  171.  
  172. INSERT INTO `password_reset_codes` (`id`, `userId`, `code`, `date`) VALUES
  173. (5, 11, 'pbkdf2:sha256:150000$NFhvB8nx$b5f44774f3cbc03ce88fa395df0614baff63b7074667bcffcf74948128cd5c8b', '2020-02-07 06:09:03'),
  174. (7, 11, 'pbkdf2:sha256:150000$JHwZGPFf$68ec08a7dd3e850550b9dcb91e80cb0f96eb9bc39fc84461e28ce38ec641873d', '2020-02-07 09:07:57'),
  175. (8, 11, 'pbkdf2:sha256:150000$0pprU9z2$bc7fad669c0e9480d7e26fbcfd06e969bf36d005a8f4dc25ecb5639361c3a030', '2020-02-07 11:09:29'),
  176. (9, 11, 'pbkdf2:sha256:150000$hEojjoCp$96bca7019e193ef222e404bfe47de8467bc1a3431a42399cb9a9b8fc6fc5c52a', '2020-02-07 11:18:12'),
  177. (10, 11, 'pbkdf2:sha256:150000$yAsQoW3R$108d5b5e14610f2079b298d770eca3c9ca12cdd8a2d322f0bb744b5a4bb77992', '2020-02-07 11:40:06'),
  178. (12, 12, 'pbkdf2:sha256:150000$urNTckkg$52db718e56fab8ff802086d686c0c5c0505ca602c4c0726a041c5579d054529d', '2020-02-07 14:23:31'),
  179. (13, 11, 'pbkdf2:sha256:150000$8oF0vImd$0c2793e34cb66b28898adaa930c570619afefca1a2bb0c43b3cdb4a50fc0d1d0', '2020-02-07 14:26:26'),
  180. (15, 14, 'pbkdf2:sha256:150000$99EtDvhj$343e9fb6b945a98f1d3c6b41d44e4a4228cacaa10f5fdfce325c2d94a3e7f8f9', '2020-02-17 10:54:31'),
  181. (16, 11, 'pbkdf2:sha256:150000$egNrmnxE$34f90870e172bc72aefebb3c96a9ba449faf9be7f6984a0fc551e4e03773ec61', '2020-02-17 10:56:18'),
  182. (17, 13, 'pbkdf2:sha256:150000$oLGfkscO$4a53fa11f2bbcdff80dff0909e600d2490da092097679fba5f677225648a220e', '2020-02-17 10:58:18'),
  183. (18, 1, 'pbkdf2:sha256:150000$aJQzx7HR$72e7ba76a328cd43471c9c55ae257b60f8cb9cf6ef4c099725d7755302711d22', '2020-02-17 11:00:40'),
  184. (19, 15, 'pbkdf2:sha256:150000$phH37puC$0156060069e96bc5e2fd32408ed063de99a918cd0c0568d6e4324f21a9e1bf10', '2020-02-17 11:01:16');
  185.  
  186. -- --------------------------------------------------------
  187.  
  188. --
  189. -- Struttura della tabella `sessions`
  190. --
  191.  
  192. CREATE TABLE `sessions` (
  193.   `id` int(11) NOT NULL,
  194.   `userId` int(11) NOT NULL,
  195.   `sessionKey` varchar(128) NOT NULL,
  196.   `ip` varchar(42) NOT NULL,
  197.   `device` varchar(128) NOT NULL,
  198.   `active` tinyint(1) NOT NULL DEFAULT 1,
  199.   `date` datetime NOT NULL DEFAULT current_timestamp()
  200. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  201.  
  202. --
  203. -- Dump dei dati per la tabella `sessions`
  204. --
  205.  
  206. INSERT INTO `sessions` (`id`, `userId`, `sessionKey`, `ip`, `device`, `active`, `date`) VALUES
  207. (1, 1, 'pbkdf2:sha256:150000$UZZJgsIc$1524c3f529785f5a14', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  208. (2, 2, 'pbkdf2:sha256:150000$FLSBZbN2$d3de25bb33b52c19f0', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  209. (3, 2, 'pbkdf2:sha256:150000$W233bWsm$95898c205890e7bf34', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  210. (4, 2, 'pbkdf2:sha256:150000$U8SLI4f0$6dff3d21a3d7caf0823a3424b655bf41fa4f55f8f14648ede8abda9474d0a313', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  211. (5, 2, 'pbkdf2:sha256:150000$cPGEAjrV$cc7b8ff753af926826dd2dafa2f6693b703bfadd44aa5e0d72913406279a0d98', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  212. (6, 2, 'pbkdf2:sha256:150000$OldSDu2b$7415b9b253afde9b1bf78c169e2e09943c0de7fca95574d7b225324aa3bd963d', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  213. (7, 2, 'pbkdf2:sha256:150000$OuZRQ104$238c8213a4a18f67da1233009fba3dc7d0093c73de995571f00ce98fd935358c', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  214. (8, 2, 'pbkdf2:sha256:150000$a98HPZ8J$8246c721a8009818ea8391f48d1ca64bf8a5fdb5ef8ae6867c9310d6b651f573', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  215. (9, 2, 'pbkdf2:sha256:150000$5RKz8AOZ$27b0da903c2a2b89707fe3ef0f3cdf97a672f15181e5fef45ccc6f8db38d6704', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  216. (10, 2, 'pbkdf2:sha256:150000$l3TH77Dp$ab7d7f461806b4795bd86a4948d35fffceb29753c30416b8ebcf72a53a532a80', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  217. (11, 2, 'pbkdf2:sha256:150000$NsWuHzO1$a5ce68f7b64d0e08244faa7e3c6f3b39198e6c240f4b4228742b4e40c2776c1c', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  218. (12, 2, 'pbkdf2:sha256:150000$0JuaOjEp$5b299962c76a303bcd7530c473722f0d02df16e39fa5052389636c47adf8f3df', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  219. (13, 2, 'pbkdf2:sha256:150000$20ujQaoH$f2b8b33abd7b9a6d9a27a67d0f7dae23f92ae98a1a63f2f3da0f1bc3490e9b9c', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  220. (14, 2, 'pbkdf2:sha256:150000$5yHunx32$c65acb2031ac8505280a911bc637527798c6595e2cbd20e0afdd2e74a3a03111', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  221. (15, 1, 'pbkdf2:sha256:150000$CWr0Ukpm$5e63968c7418b868d644189c674d4ca27c53f6f7303526e43cd01c4ffdcc6793', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  222. (16, 1, 'pbkdf2:sha256:150000$LhpoAdDl$500cdbb82a819ca3ffc18f3136190b2240f21c191b30f5b4c3030129568c2d8b', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  223. (17, 2, 'pbkdf2:sha256:150000$QmSSZKmh$20350001dc9db2f6bf36a45ab90e0f2e888c9c45996f80afcc37cba35ef6714e', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  224. (18, 4, 'pbkdf2:sha256:150000$5DHxhDLH$c915243df94d20e74a3963fee012046bd8fab78b1795e18f83065cecfc29b640', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  225. (19, 5, 'pbkdf2:sha256:150000$loCBcxN8$1047361fa1dd34e76d0c3aabd97660dc8ecee36a4ae282bc50cc46ffc87675ff', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  226. (20, 6, 'pbkdf2:sha256:150000$Tf5EcCCi$9624224d9ae0112b1a838ff3842a7402c7b3d5a9205f654b9001cc4daeadf1c9', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  227. (21, 7, 'pbkdf2:sha256:150000$KyQzY80r$93c24f10b6a65461a26e1ebf08c2aa4326eabe17f7ab28f976e145683d2b1a28', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  228. (22, 8, 'pbkdf2:sha256:150000$oTJEGh9o$eb7db8cf7dc6f7f0fc5edd5f3c0c018919c0677d4d4f59fde9cb6cebd4088c72', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  229. (23, 9, 'pbkdf2:sha256:150000$q92BKelW$fc30b84c8db03d2d8fb23b1083c40f96aac799321b73eeb8e8af8a60543ea26e', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  230. (24, 9, 'pbkdf2:sha256:150000$dLMslAO5$fc594d062371ec9a804645995feeae6c1bd6b3e29ba7f18dd9e089e61a446d3b', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  231. (25, 10, 'pbkdf2:sha256:150000$WgeWt9We$c3f0aba8425fee291d6dc855231f540d651396be5006206b6bfbe111c740ec18', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  232. (26, 10, 'pbkdf2:sha256:150000$t5BtjgGW$e8ec1f37c560fcd9073dd93ddb2742b6a660862ca6a412bb9cff5c13468d632e', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  233. (27, 10, 'pbkdf2:sha256:150000$Og3wCWTq$84ce2bf8a0c706be2be81b3b6e23ac6c71abc3d56099d53ce4131d8213ecd282', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  234. (28, 11, 'pbkdf2:sha256:150000$OGWC3t2I$1dbbdc24e9f0ecadf57f419cc6a14cb2a924308167e4be5a798ac920930646ca', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  235. (29, 11, 'pbkdf2:sha256:150000$gi0yrR6w$5288cdeea8bb1f51f9ce4a85e7a0eed085b1e2972f964da0fde4d0f2c063217b', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  236. (30, 11, 'pbkdf2:sha256:150000$Oth8fmMM$2c8d96f036d43ca9609d9538012bc5a434dd86f5fcbb77d556c6b6dfce69a5c4', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  237. (31, 11, 'pbkdf2:sha256:150000$UKApPkHp$4568f071acad6fd8c7783efba3b04c3c32d3c4b5d5baf99d63de7ab1c0b2a46e', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  238. (32, 11, 'pbkdf2:sha256:150000$3S9vC9ke$6dcfd96181e0547146999fb5634a514ffb452a4e65f521c1e31d0fdab11a56f0', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  239. (33, 11, 'pbkdf2:sha256:150000$RuCtlwbE$bf902f7e31f3a0b12013b2fb84b8e5f3e2ae6897f1b5f0559d7cda6d5c34e285', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  240. (34, 11, 'pbkdf2:sha256:150000$ra0x5Arh$bd5d69df6bcbec2d926f1ae824b17ac17c020ec74cb76e4128e904a8f97fc061', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  241. (35, 11, 'pbkdf2:sha256:150000$inbV4trr$9c61be702edac1134ad848a6d7708476d5d07c8b4a96043d9cc9ad7dbce1c5cd', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  242. (36, 11, 'pbkdf2:sha256:150000$VFpc1TE5$b1a9a76f0acef5db3432b28ee08cc5c9a345cc8cf33b52efe62d3fa21e08bc02', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  243. (37, 11, 'pbkdf2:sha256:150000$CwMOuTrQ$80f1a54ed50cebf87aa3362a20ea291b4ac8f7e464547bc444fb73f49ea6a229', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  244. (38, 11, 'pbkdf2:sha256:150000$JqkcfXMt$ac7deb9f503eddb79905acf53f4d83b1c38d2eee09d8c56ab02a7e32c1dc20f6', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  245. (39, 11, 'pbkdf2:sha256:150000$RmmdAWbb$a465cc21c7fcf701a264e9ba84c71aeb438df318bf843b068e7e0e128d4db443', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  246. (40, 11, 'pbkdf2:sha256:150000$NbFLyQCY$c85f6ea7050e8f6d066b6d5b024f50f52a504a7f68b45accc63e8957a3877026', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  247. (41, 11, 'pbkdf2:sha256:150000$XZbbvKQo$fab5db3a1fa4c219b7598ec4dfa0acc153ee080febc48184502f3b2215fbc459', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  248. (42, 11, 'pbkdf2:sha256:150000$Y16NvupA$40a37a4c13bcefe443fd3b0379f54f2cc343d01a050bdf0da170d60b7a499f70', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  249. (43, 11, 'pbkdf2:sha256:150000$JONgTynK$7912bf55c1861f122eac057a68037e1faeb6d3dad4d14361ba207f7f16b5d009', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0', 1, '2020-02-10 11:30:48'),
  250. (44, 12, 'pbkdf2:sha256:150000$v7UKQc7b$05f837143c3e9edf3e7e3c867baf45056111dab4aa5cb94c47535d0d6a55b28a', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-10 11:27:51'),
  251. (45, 1, 'pbkdf2:sha256:150000$SUBQMpPj$fbc6fd53a8be4e6e072f60c33272438729795fb13b2b73f8195849a8af45a087', '127.0.0.1', 'insomnia/7.0.6', 1, '2020-02-18 11:02:28'),
  252. (46, 11, 'pbkdf2:sha256:150000$sEYHVApt$3083f2923397a397abc46e6f030faa2d1757f2a7dd0bfc7924c63ec685d040b9', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 12:33:59'),
  253. (47, 11, 'pbkdf2:sha256:150000$jxJpSAwb$d93454b3d62f6fdf628c23b76a014b892cb1c3a42a5894002f38b857476c7deb', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 12:46:58'),
  254. (48, 11, 'pbkdf2:sha256:150000$SGr16THQ$9357e8ea49b22b5fb7e2a0b8cfc9aaa4621bb036d16e5e8453372ef47dcfa703', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 13:01:07'),
  255. (49, 11, 'pbkdf2:sha256:150000$4p0a9URX$9c0e02dff6ae0d857b9833bea7488880f1e92863cc48a81475278f35fcb78c92', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 13:15:09'),
  256. (50, 11, 'pbkdf2:sha256:150000$m6UXvl5O$68eb85ffd834d14e2a4d462ef94788dd1fd2181e507e77626e763db5cc794a29', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 14:03:35'),
  257. (51, 11, 'pbkdf2:sha256:150000$CKbjD0WR$7656254f945047123b0a072d4d9c9b668375286493951eb67514156236386fc0', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 14:21:08'),
  258. (52, 11, 'pbkdf2:sha256:150000$QwNWV1US$8b186270b02edf50d032e70cfa110af59f017591e99a9f1d3c5548b0d187c6b6', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 14:24:35'),
  259. (53, 11, 'pbkdf2:sha256:150000$m8unsi3E$8cc1ca6c3cca478c99f7ad9ab24bd838249cb3fb05d0b29388e54e122cdf5ed1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 14:40:03'),
  260. (54, 11, 'pbkdf2:sha256:150000$nzeUwXcD$a58c00706960726bb9fb4f27aa3d6cf0fb2c668cacc860a5804c048e06467679', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 14:52:23'),
  261. (55, 11, 'pbkdf2:sha256:150000$CZuabZBx$fb0ba0be2671d3dca231a73a007b7232213c41fea3778b60fe2ab508f8533016', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:19:46'),
  262. (56, 1, 'pbkdf2:sha256:150000$teccu88H$4e3492f373a5d4f7ccf646736852796114b5f9c302b35157c4d9e08c3b1fd43f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:36:05'),
  263. (57, 11, 'pbkdf2:sha256:150000$NDSjXfdf$d2fec5a75142e8beee676abb2b922ec1237ddfb69f332caa1a63b0cef81cd7c8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:38:35'),
  264. (58, 11, 'pbkdf2:sha256:150000$17y8jyBq$51315c3f5e3ae0f3ab21361e00106df0bd7d4bc70a246521959e59f5e0508b4c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:38:49'),
  265. (59, 11, 'pbkdf2:sha256:150000$P3R6b9YR$73f73d1c1dd20cea63649139767736c4d9127fb50903bcdbc04ff3a72aa35ef8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:42:25'),
  266. (60, 11, 'pbkdf2:sha256:150000$crXe9HNf$f23a0d57aca6664e5a82a472e0a4a040f875d22406e4bae1467703a1ad132183', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:46:50'),
  267. (61, 11, 'pbkdf2:sha256:150000$f5bDc5Iw$17d1d8cba19f55485196fecf95bb6dd1c0bfcf2c08a75557711ba42b9b84e906', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 15:51:25'),
  268. (62, 11, 'pbkdf2:sha256:150000$vm8ShR0s$5b69ea03ddc209609091dd386ae2909daf725a012965288df5f43c8f38f808f8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 16:00:02'),
  269. (63, 11, 'pbkdf2:sha256:150000$opvYB4Gf$a0df817c210764f449ff4b1ca6cab730332287b3706ae61574e27dc894e94435', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 16:05:13'),
  270. (64, 11, 'pbkdf2:sha256:150000$EtR4xWYT$828517e57022a5cbdf491b318388c36a5f60aef982c10adc3ed8b8d41f679def', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-13 16:05:59'),
  271. (65, 11, 'pbkdf2:sha256:150000$9O1yjNkx$db95ab649ff34e071e2c34b3d524648743354b8244d3372a2033470eba9ca8b1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 11:52:19'),
  272. (66, 13, 'pbkdf2:sha256:150000$APMqbq42$da9e5d31664fc4976fb4b2e69d11943d255744222e1ff253af31355643612109', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 12:17:02'),
  273. (67, 14, 'pbkdf2:sha256:150000$J16Sk8pK$330ed3764435352e7b8a87c858570953572644b9c9ba5d4efe8f918f7a50b767', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 12:21:00'),
  274. (68, 11, 'pbkdf2:sha256:150000$48WasI4g$1dafd662f8988e38e16bd299811101c633ad1749403c9829f1dea53db0845aea', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 12:21:14'),
  275. (69, 15, 'pbkdf2:sha256:150000$fY9RLmF1$ed72a12fe744735a58ac8f12ed7b3838000b5985667709714f93070bbb5fa34f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 12:35:48'),
  276. (70, 15, 'pbkdf2:sha256:150000$2FU7DurJ$9d92c995dc82ac87acc7623d1a0e38037226c9dbdd3dc25c6033e0b38c6d6121', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 12:36:15'),
  277. (71, 11, 'pbkdf2:sha256:150000$6GSVmoiq$b8b2ceb1da163c36cc99512e1ff07036b06e87f6066493f22f72346d71292bbc', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 14:24:22'),
  278. (72, 16, 'pbkdf2:sha256:150000$gOSvc9ic$5c10d685abc87f9b02db0182db47dcc0d15518121116c447ce23ba9a24281353', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-14 15:34:08'),
  279. (73, 1, 'pbkdf2:sha256:150000$tRy4exzr$3bd9d6a567a028a5157daaa5f7849266bdbf29d7294dbc7ea105430b4c293cec', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 09:59:45'),
  280. (74, 1, 'pbkdf2:sha256:150000$rkqxHjAz$98445daf971ee1175ee7cdc07a49d5444f008a6f74547a8e336930703226a503', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36', 1, '2020-02-14 15:41:32'),
  281. (75, 11, 'pbkdf2:sha256:150000$YihSyRlz$d410946ad1a6cdb9a5dd74f19df5c0de757774b807788393972b809a144c952f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 10:00:33'),
  282. (76, 1, 'pbkdf2:sha256:150000$AXj5pCVh$121841e2a188dc9a2263e42b68bdcc88ad40318ac56c140f6bd740ecf52ba7ba', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 10:01:18'),
  283. (77, 1, 'pbkdf2:sha256:150000$L5cluv4z$7a2e7f1bdc537bb579ea8e962f02e750c0d5db91aa167f1f4c0fc87dc51f9a83', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 10:05:41'),
  284. (78, 1, 'pbkdf2:sha256:150000$gpdqsAmj$d6fb9da974edd4ddb2b604d4ec54f48c6b7f45f46204d7910e9a40cf2f2c7fe1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 12:23:07'),
  285. (79, 16, 'pbkdf2:sha256:150000$nHHL2F9n$d9dd1d8224dcfa85137d7f2d3873d19b96ee30fda1a5548655ed91613072ec7f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 12:57:26'),
  286. (80, 1, 'pbkdf2:sha256:150000$nMcrEpaw$c887ad9bdcf94b337d8ae4fc4243e12ddcb279c3a1e38c33dd44d91e728811dd', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 12:59:58'),
  287. (81, 11, 'pbkdf2:sha256:150000$DDk3aEqm$ad527227c65bbbe417a4c4e89c8f8610d1ab384c17506e0d2317257e23ad9258', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 13:04:52'),
  288. (82, 11, 'pbkdf2:sha256:150000$9uZJ1sKo$c904dbaa187197befacec2cf4156ca44f4a0a3b7f6318aca8bc8d71b38ad4e6c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 13:05:20'),
  289. (83, 1, 'pbkdf2:sha256:150000$qiELOcZq$898663904422af32c51acf1b0a33ebf275851ba3308e90860fe1abe07f67788f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 13:15:33'),
  290. (84, 14, 'pbkdf2:sha256:150000$YjQhab46$7be9a83e0c7d4d692ee69a491364814317ffb762d3ac60d2ed8ba9e241ebf0bd', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 13:55:25'),
  291. (85, 1, 'pbkdf2:sha256:150000$3cexMyDP$2d7575b9d5ac52851ca4547188094d7349669bd16ae71763724bf1c2e425c19b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:22:28'),
  292. (86, 1, 'pbkdf2:sha256:150000$xK24OFNw$3bc6d475e2161b879452e5ab92d66aa7c5b70ff39668f78c0a0cc062e4f0ea5a', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:28:40'),
  293. (87, 13, 'pbkdf2:sha256:150000$rN7ft7hp$3b460d9ea2878f9063da7713aef0aaf336498d884a6cee245668481cca02d8ba', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:29:54'),
  294. (88, 1, 'pbkdf2:sha256:150000$cPc28qp1$354b2d2586e5c8002a3e0689a25250f2c70781724d6d841989fd664b081df58c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:51:40'),
  295. (89, 1, 'pbkdf2:sha256:150000$jo0QraJI$1fa8c4ab3a607be53c44d3a1693f739586d5a9ab23b4417db33a90575f32548e', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:54:07'),
  296. (90, 11, 'pbkdf2:sha256:150000$7eylZIyI$a6883401e7503376fc0bd412101af6e9e021e896b6f708348fecee4544c2d9a4', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 14:54:25'),
  297. (91, 1, 'pbkdf2:sha256:150000$o1fnRMpv$f0aab378dbde30c0d6c28bab191766095147ab05611ae25d2715de0533ebb924', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 15:58:16'),
  298. (92, 13, 'pbkdf2:sha256:150000$fjuLXSYr$f0ce746d4c43c075b1d81d9714f8a8d5b18a6ef4050f32295333911350c7bace', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-17 16:02:23'),
  299. (93, 1, 'pbkdf2:sha256:150000$TSicaY8R$1abed203264290962ad8d0eb041c2709f8ae8d4581c118ed397ded3b6ddbef62', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0', 1, '2020-02-18 11:17:20');
  300.  
  301. -- --------------------------------------------------------
  302.  
  303. --
  304. -- Struttura della tabella `users`
  305. --
  306.  
  307. CREATE TABLE `users` (
  308.   `id` int(11) NOT NULL,
  309.   `login` varchar(64) NOT NULL,
  310.   `name` varchar(64) NOT NULL,
  311.   `password` varchar(128) NOT NULL,
  312.   `email` varchar(128) NOT NULL,
  313.   `admin` tinyint(1) NOT NULL DEFAULT 0,
  314.   `emailVerified` tinyint(1) NOT NULL DEFAULT 0
  315. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  316.  
  317. --
  318. -- Dump dei dati per la tabella `users`
  319. --
  320.  
  321. INSERT INTO `users` (`id`, `login`, `name`, `password`, `email`, `admin`, `emailVerified`) VALUES
  322. (1, 'admin', 'Admin', 'pbkdf2:sha256:150000$s2d3MtOv$41097b62c8a229b2aca6a22750de49ed2d00d676f46a206ea52f56df08e9fc5f', 'moj@adres-email.pl', 1, 1),
  323. (11, 'cyprian', 'Cyprian Wojtas', 'pbkdf2:sha256:150000$HYgxKEs0$2f33f311242f0657a65803a00b3d81e8c89fd55b6d0d7f11d33477417a3e1cbb', 'cyprian.s.wojtas@adres-email.pl', 0, 1),
  324. (12, 'gabol', 'Gabriel Bolech', 'pbkdf2:sha256:150000$ZrKEkN2d$002492e52984302cf528acbf4607d0aba26f28777f97c2065a3bfed186ab39f5', 'bolech123@interia.pl', 0, 0),
  325. (13, 'nowak', 'Jan Nowak', 'pbkdf2:sha256:150000$uGpodJLF$d0aa801b82b1a018c3b92d3bf8c78a6b2b55f08e432d7076f65424a8c8b4151f', 'jakis@adres-email.com', 0, 0),
  326. (14, 'jnowak', 'Jan Nowak', 'pbkdf2:sha256:150000$C5MtErpZ$cde8903c065d34c939f1f4b22bfd22e80df86d4406eadb948ff279d8fb1e12c6', 'jakis@adres-email.pl', 0, 0),
  327. (15, 'nowak2', 'Jan Nowak', 'pbkdf2:sha256:150000$q2b2azQk$a2bd9ff5bbc85de5ffd0f8c8784887c88aafab3482ce7bc5ca99e844f3d87b15', 'jakis2@adres-email.pl', 0, 0),
  328. (16, 'kowal', 'Jan Kowalski', 'pbkdf2:sha256:150000$vV3lkRpm$bc302cc756d4099feac806c9964ddadfeee9c7a49a34ebf6b8b37a7bbc370451', 'kowalski@adres-email.pl', 0, 0);
  329.  
  330. --
  331. -- Indici per le tabelle scaricate
  332. --
  333.  
  334. --
  335. -- Indici per le tabelle `donations`
  336. --
  337. ALTER TABLE `donations`
  338.   ADD PRIMARY KEY (`id`),
  339.   ADD KEY `userId` (`userId`),
  340.   ADD KEY `listId` (`listId`);
  341.  
  342. --
  343. -- Indici per le tabelle `email_verify_codes`
  344. --
  345. ALTER TABLE `email_verify_codes`
  346.   ADD PRIMARY KEY (`id`),
  347.   ADD KEY `userId` (`userId`),
  348.   ADD KEY `code` (`code`);
  349.  
  350. --
  351. -- Indici per le tabelle `links`
  352. --
  353. ALTER TABLE `links`
  354.   ADD PRIMARY KEY (`id`),
  355.   ADD KEY `listId` (`listId`),
  356.   ADD KEY `url` (`url`);
  357.  
  358. --
  359. -- Indici per le tabelle `lists`
  360. --
  361. ALTER TABLE `lists`
  362.   ADD PRIMARY KEY (`id`),
  363.   ADD KEY `userId` (`userId`);
  364.  
  365. --
  366. -- Indici per le tabelle `list_members`
  367. --
  368. ALTER TABLE `list_members`
  369.   ADD PRIMARY KEY (`id`),
  370.   ADD KEY `linkId` (`linkId`),
  371.   ADD KEY `listId` (`listId`);
  372.  
  373. --
  374. -- Indici per le tabelle `notifications`
  375. --
  376. ALTER TABLE `notifications`
  377.   ADD PRIMARY KEY (`id`),
  378.   ADD KEY `userId` (`userId`);
  379.  
  380. --
  381. -- Indici per le tabelle `password_reset_codes`
  382. --
  383. ALTER TABLE `password_reset_codes`
  384.   ADD PRIMARY KEY (`id`),
  385.   ADD KEY `userId` (`userId`),
  386.   ADD KEY `date` (`date`);
  387.  
  388. --
  389. -- Indici per le tabelle `sessions`
  390. --
  391. ALTER TABLE `sessions`
  392.   ADD PRIMARY KEY (`id`);
  393.  
  394. --
  395. -- Indici per le tabelle `users`
  396. --
  397. ALTER TABLE `users`
  398.   ADD PRIMARY KEY (`id`),
  399.   ADD KEY `login` (`login`);
  400.  
  401. --
  402. -- AUTO_INCREMENT per le tabelle scaricate
  403. --
  404.  
  405. --
  406. -- AUTO_INCREMENT per la tabella `donations`
  407. --
  408. ALTER TABLE `donations`
  409.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  410.  
  411. --
  412. -- AUTO_INCREMENT per la tabella `email_verify_codes`
  413. --
  414. ALTER TABLE `email_verify_codes`
  415.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  416.  
  417. --
  418. -- AUTO_INCREMENT per la tabella `links`
  419. --
  420. ALTER TABLE `links`
  421.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  422.  
  423. --
  424. -- AUTO_INCREMENT per la tabella `lists`
  425. --
  426. ALTER TABLE `lists`
  427.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  428.  
  429. --
  430. -- AUTO_INCREMENT per la tabella `list_members`
  431. --
  432. ALTER TABLE `list_members`
  433.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  434.  
  435. --
  436. -- AUTO_INCREMENT per la tabella `notifications`
  437. --
  438. ALTER TABLE `notifications`
  439.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  440.  
  441. --
  442. -- AUTO_INCREMENT per la tabella `password_reset_codes`
  443. --
  444. ALTER TABLE `password_reset_codes`
  445.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  446.  
  447. --
  448. -- AUTO_INCREMENT per la tabella `sessions`
  449. --
  450. ALTER TABLE `sessions`
  451.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;
  452.  
  453. --
  454. -- AUTO_INCREMENT per la tabella `users`
  455. --
  456. ALTER TABLE `users`
  457.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  458. COMMIT;
  459.  
  460. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  461. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  462. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!