API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 5th, 2017
952
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 30.06 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE `ranks` (
  2.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  3.   `date` DATE NOT NULL,
  4.   `number` BIGINT(20) DEFAULT NULL,
  5.   `rank_type` VARCHAR(255) NOT NULL,
  6.   `max_ranking_positions` BIGINT(20) DEFAULT '100',
  7.   `created_at` datetime NOT NULL,
  8.   `updated_at` datetime NOT NULL,
  9.   PRIMARY KEY (`id`)
  10. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  11.  
  12.  
  13. INSERT INTO `ranks` (`id`, `date`, `number`, `rank_type`, `max_ranking_positions`, `created_at`, `updated_at`) VALUES
  14. (1, '2010-01-24', 1, 'user', 100, '2010-01-24 01:28:33', '2010-01-24 01:28:38');
  15.  
  16. CREATE TABLE `sf_guard_user` (
  17.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  18.   `first_name` VARCHAR(255) DEFAULT NULL,
  19.   `last_name` VARCHAR(255) DEFAULT NULL,
  20.   `email_address` VARCHAR(255) NOT NULL,
  21.   `username` VARCHAR(128) NOT NULL,
  22.   `algorithm` VARCHAR(128) NOT NULL DEFAULT 'sha1',
  23.   `salt` VARCHAR(128) DEFAULT NULL,
  24.   `password` VARCHAR(128) DEFAULT NULL,
  25.   `is_active` tinyint(1) DEFAULT '1',
  26.   `is_super_admin` tinyint(1) DEFAULT '0',
  27.   `last_login` datetime DEFAULT NULL,
  28.   `type` VARCHAR(255) DEFAULT NULL,
  29.   `avatar` VARCHAR(255) DEFAULT NULL,
  30.   `birthdate` DATE DEFAULT NULL,
  31.   `codice_fiscale` VARCHAR(16) DEFAULT NULL,
  32.   `total_score` BIGINT(20) DEFAULT '0',
  33.   `sex` VARCHAR(255) NOT NULL,
  34.   `is_blocked` tinyint(1) DEFAULT '0',
  35.   `access_count` BIGINT(20) DEFAULT '0',
  36.   `all_right_week` BIGINT(20) DEFAULT '0',
  37.   `all_right_month` BIGINT(20) DEFAULT '0',
  38.   `created_at` datetime NOT NULL,
  39.   `updated_at` datetime NOT NULL,
  40.   PRIMARY KEY (`id`),
  41.   UNIQUE KEY `email_address` (`email_address`),
  42.   UNIQUE KEY `username` (`username`),
  43.   KEY `is_active_idx_idx` (`is_active`),
  44.   KEY `sf_guard_user_type_idx` (`type`)
  45. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  46.  
  47. --
  48. -- Dumping data for table `sf_guard_user`
  49. --
  50.  
  51. INSERT INTO `sf_guard_user` (`id`, `first_name`, `last_name`, `email_address`, `username`, `algorithm`, `salt`, `password`, `is_active`, `is_super_admin`, `last_login`, `type`, `avatar`, `birthdate`, `codice_fiscale`, `total_score`, `sex`, `is_blocked`, `access_count`, `all_right_week`, `all_right_month`, `created_at`, `updated_at`) VALUES
  52. (1, '1_first_name', '1_last_name', '1_user@email.it', '1_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 10458, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  53. (2, '2_first_name', '2_last_name', '2_user@email.it', '2_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 645, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  54. (3, '3_first_name', '3_last_name', '3_user@email.it', '3_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 51091, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  55. (4, '4_first_name', '4_last_name', '4_user@email.it', '4_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 90865, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  56. (5, '5_first_name', '5_last_name', '5_user@email.it', '5_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 55128, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  57. (6, '6_first_name', '6_last_name', '6_user@email.it', '6_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 47027, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  58. (7, '7_first_name', '7_last_name', '7_user@email.it', '7_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 57241, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  59. (8, '8_first_name', '8_last_name', '8_user@email.it', '8_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 77395, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  60. (9, '9_first_name', '9_last_name', '9_user@email.it', '9_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 82323, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  61. (10, '10_first_name', '10_last_name', '10_user@email.it', '10_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 46815, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  62. (11, '11_first_name', '11_last_name', '11_user@email.it', '11_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 17419, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  63. (12, '12_first_name', '12_last_name', '12_user@email.it', '12_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 10100, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  64. (13, '13_first_name', '13_last_name', '13_user@email.it', '13_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 1253, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  65. (14, '14_first_name', '14_last_name', '14_user@email.it', '14_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 4159, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  66. (15, '15_first_name', '15_last_name', '15_user@email.it', '15_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 29827, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  67. (16, '16_first_name', '16_last_name', '16_user@email.it', '16_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 76184, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  68. (17, '17_first_name', '17_last_name', '17_user@email.it', '17_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 73850, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  69. (18, '18_first_name', '18_last_name', '18_user@email.it', '18_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 35722, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  70. (19, '19_first_name', '19_last_name', '19_user@email.it', '19_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 10109, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  71. (20, '20_first_name', '20_last_name', '20_user@email.it', '20_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 31589, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  72. (21, '21_first_name', '21_last_name', '21_user@email.it', '21_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 54074, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  73. (22, '22_first_name', '22_last_name', '22_user@email.it', '22_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 80612, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  74. (23, '23_first_name', '23_last_name', '23_user@email.it', '23_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 83196, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  75. (24, '24_first_name', '24_last_name', '24_user@email.it', '24_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 65559, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  76. (25, '25_first_name', '25_last_name', '25_user@email.it', '25_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 16473, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  77. (26, '26_first_name', '26_last_name', '26_user@email.it', '26_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 10896, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  78. (27, '27_first_name', '27_last_name', '27_user@email.it', '27_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 62748, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  79. (28, '28_first_name', '28_last_name', '28_user@email.it', '28_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 73603, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  80. (29, '29_first_name', '29_last_name', '29_user@email.it', '29_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 30226, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  81. (30, '30_first_name', '30_last_name', '30_user@email.it', '30_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 40350, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  82. (31, '31_first_name', '31_last_name', '31_user@email.it', '31_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 76572, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  83. (32, '32_first_name', '32_last_name', '32_user@email.it', '32_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 40585, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  84. (33, '33_first_name', '33_last_name', '33_user@email.it', '33_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 40895, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  85. (34, '34_first_name', '34_last_name', '34_user@email.it', '34_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 27663, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  86. (35, '35_first_name', '35_last_name', '35_user@email.it', '35_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 31450, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  87. (36, '36_first_name', '36_last_name', '36_user@email.it', '36_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 95923, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  88. (37, '37_first_name', '37_last_name', '37_user@email.it', '37_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 74590, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  89. (38, '38_first_name', '38_last_name', '38_user@email.it', '38_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 88591, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  90. (39, '39_first_name', '39_last_name', '39_user@email.it', '39_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 73318, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  91. (40, '40_first_name', '40_last_name', '40_user@email.it', '40_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 56912, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  92. (41, '41_first_name', '41_last_name', '41_user@email.it', '41_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 35406, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  93. (42, '42_first_name', '42_last_name', '42_user@email.it', '42_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 90638, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  94. (43, '43_first_name', '43_last_name', '43_user@email.it', '43_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 66913, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  95. (44, '44_first_name', '44_last_name', '44_user@email.it', '44_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 36560, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  96. (45, '45_first_name', '45_last_name', '45_user@email.it', '45_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 94697, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  97. (46, '46_first_name', '46_last_name', '46_user@email.it', '46_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 96640, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  98. (47, '47_first_name', '47_last_name', '47_user@email.it', '47_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 12743, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  99. (48, '48_first_name', '48_last_name', '48_user@email.it', '48_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 68547, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  100. (49, '49_first_name', '49_last_name', '49_user@email.it', '49_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 32362, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  101. (50, '50_first_name', '50_last_name', '50_user@email.it', '50_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 22752, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  102. (51, '51_first_name', '51_last_name', '51_user@email.it', '51_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 135, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  103. (52, '52_first_name', '52_last_name', '52_user@email.it', '52_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 86337, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  104. (53, '53_first_name', '53_last_name', '53_user@email.it', '53_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 3363, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  105. (54, '54_first_name', '54_last_name', '54_user@email.it', '54_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 83232, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  106. (55, '55_first_name', '55_last_name', '55_user@email.it', '55_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 51895, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  107. (56, '56_first_name', '56_last_name', '56_user@email.it', '56_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 19737, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  108. (57, '57_first_name', '57_last_name', '57_user@email.it', '57_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 94029, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  109. (58, '58_first_name', '58_last_name', '58_user@email.it', '58_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 14642, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  110. (59, '59_first_name', '59_last_name', '59_user@email.it', '59_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 93240, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  111. (60, '60_first_name', '60_last_name', '60_user@email.it', '60_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 24254, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  112. (61, '61_first_name', '61_last_name', '61_user@email.it', '61_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 54892, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  113. (62, '62_first_name', '62_last_name', '62_user@email.it', '62_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 69812, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  114. (63, '63_first_name', '63_last_name', '63_user@email.it', '63_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 64740, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  115. (64, '64_first_name', '64_last_name', '64_user@email.it', '64_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 95688, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  116. (65, '65_first_name', '65_last_name', '65_user@email.it', '65_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 97375, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  117. (66, '66_first_name', '66_last_name', '66_user@email.it', '66_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 96090, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  118. (67, '67_first_name', '67_last_name', '67_user@email.it', '67_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 91610, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  119. (68, '68_first_name', '68_last_name', '68_user@email.it', '68_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 71964, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  120. (69, '69_first_name', '69_last_name', '69_user@email.it', '69_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 84681, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  121. (70, '70_first_name', '70_last_name', '70_user@email.it', '70_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 64928, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  122. (71, '71_first_name', '71_last_name', '71_user@email.it', '71_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 28876, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  123. (72, '72_first_name', '72_last_name', '72_user@email.it', '72_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 20086, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  124. (73, '73_first_name', '73_last_name', '73_user@email.it', '73_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 55565, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  125. (74, '74_first_name', '74_last_name', '74_user@email.it', '74_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 95690, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  126. (75, '75_first_name', '75_last_name', '75_user@email.it', '75_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 56547, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  127. (76, '76_first_name', '76_last_name', '76_user@email.it', '76_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 50262, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  128. (77, '77_first_name', '77_last_name', '77_user@email.it', '77_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 92330, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  129. (78, '78_first_name', '78_last_name', '78_user@email.it', '78_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 69190, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  130. (79, '79_first_name', '79_last_name', '79_user@email.it', '79_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 18808, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  131. (80, '80_first_name', '80_last_name', '80_user@email.it', '80_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 24691, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  132. (81, '81_first_name', '81_last_name', '81_user@email.it', '81_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 91843, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  133. (82, '82_first_name', '82_last_name', '82_user@email.it', '82_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 18843, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  134. (83, '83_first_name', '83_last_name', '83_user@email.it', '83_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 11028, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  135. (84, '84_first_name', '84_last_name', '84_user@email.it', '84_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 95107, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  136. (85, '85_first_name', '85_last_name', '85_user@email.it', '85_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 2075, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  137. (86, '86_first_name', '86_last_name', '86_user@email.it', '86_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 62823, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  138. (87, '87_first_name', '87_last_name', '87_user@email.it', '87_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 14844, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  139. (88, '88_first_name', '88_last_name', '88_user@email.it', '88_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 96004, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  140. (89, '89_first_name', '89_last_name', '89_user@email.it', '89_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 77366, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  141. (90, '90_first_name', '90_last_name', '90_user@email.it', '90_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 8084, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  142. (91, '91_first_name', '91_last_name', '91_user@email.it', '91_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 20258, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  143. (92, '92_first_name', '92_last_name', '92_user@email.it', '92_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 32258, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  144. (93, '93_first_name', '93_last_name', '93_user@email.it', '93_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 77796, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  145. (94, '94_first_name', '94_last_name', '94_user@email.it', '94_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 84898, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  146. (95, '95_first_name', '95_last_name', '95_user@email.it', '95_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 27945, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  147. (96, '96_first_name', '96_last_name', '96_user@email.it', '96_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 75170, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  148. (97, '97_first_name', '97_last_name', '97_user@email.it', '97_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 80988, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  149. (98, '98_first_name', '98_last_name', '98_user@email.it', '98_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 19555, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32'),
  150. (99, '99_first_name', '99_last_name', '99_user@email.it', '99_username', 'sha1', '10f3691c10856ac1dc1b7aa9c54848c0', '7995e2f3bd94b6d37442e43b50b53bf9ea7cf0cd', 1, 0, NULL, '1', 'admin.jpg', '1980-05-10', NULL, 47134, 'f', 0, 0, 0, 0, '2010-01-23 19:25:32', '2010-01-23 19:25:32');
  151.  
  152.  
  153. CREATE TABLE `users_ranks` (
  154.   `rank_id` BIGINT(20) NOT NULL DEFAULT '0',
  155.   `position` BIGINT(20) DEFAULT NULL,
  156.   `user_id` BIGINT(20) NOT NULL DEFAULT '0',
  157.   `total_score` BIGINT(20) DEFAULT NULL,
  158.   `created_at` datetime NOT NULL,
  159.   `updated_at` datetime NOT NULL,
  160.   PRIMARY KEY (`rank_id`,`user_id`),
  161.   KEY `users_ranks_user_id_sf_guard_user_id` (`user_id`)
  162. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  163.  
  164.  
  165. ALTER TABLE `users_ranks`
  166.   ADD CONSTRAINT `users_ranks_rank_id_ranks_id` FOREIGN KEY (`rank_id`) REFERENCES `ranks` (`id`),
  167.   ADD CONSTRAINT `users_ranks_user_id_sf_guard_user_id` FOREIGN KEY (`user_id`) REFERENCES `sf_guard_user` (`id`);
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!