API tools faq
paste
Guest User

Untitled

a guest
Nov 5th, 2018
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.25 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.4
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Client : pdb25.awardspace.net
  6. -- Généré le : Mar 06 Novembre 2018 à 03:45
  7. -- Version du serveur : 5.7.20-log
  8. -- Version de PHP : 5.5.38
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Base de données : `2702975_lixep0`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Structure de la table `items`
  27. --
  28.  
  29. CREATE TABLE `items` (
  30. `keyid` int(11) NOT NULL,
  31. `name` text NOT NULL,
  32. `id` text NOT NULL,
  33. `batchid` text,
  34. `owner` int(11) NOT NULL,
  35. `type` text NOT NULL,
  36. `price` decimal(15,0) DEFAULT '0',
  37. `date` date DEFAULT NULL,
  38. `visits` int(11) NOT NULL,
  39. `resolution` smallint(6) NOT NULL,
  40. `noise` smallint(4) NOT NULL,
  41. `blur` smallint(4) NOT NULL,
  42. `opacity` smallint(4) NOT NULL,
  43. `frequency` smallint(4) NOT NULL DEFAULT '1',
  44. `tremolo` float NOT NULL,
  45. `soundFiligrane` int(11) NOT NULL,
  46. `whiteNoise` int(11) NOT NULL,
  47. `hiddenTextRatio` int(11) NOT NULL
  48. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  49.  
  50. --
  51. -- Contenu de la table `items`
  52. --
  53.  
  54. INSERT INTO `items` (`keyid`, `name`, `id`, `batchid`, `owner`, `type`, `price`, `date`, `visits`, `resolution`, `noise`, `blur`, `opacity`, `frequency`, `tremolo`, `soundFiligrane`, `whiteNoise`, `hiddenTextRatio`) VALUES
  55. (843, 'pic3', '74977b114ab85f84773fc8254d16ae39.png', 'pjhny', 43, 'image', 15, '2018-11-02', 6, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  56. (842, 'main', 'a465c83786091a55a6299fed8adcf3b0.png', 'pjhny', 43, 'image', 15, '2018-11-02', 6, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  57. (841, 'main', '9b18c0d5462c216a98a017223f5f234d.png', 'hilNw', 43, 'image', 25, '2018-11-02', 2, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  58. (839, 'pic3', '2d4927f856dfdb076d6b0c0bddf19cff.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  59. (840, 'pic2', 'cc89b8576dd8ae54264d49a181bae085.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  60. (838, 'main', '7e02ee12098daaea9ee008dc82735904.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  61. (836, 'pic4', '30880f67b4b009867bbe4a5adcd9a353.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  62. (834, 'main', 'ed26b795211e293730d67cc5785af531.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  63. (837, 'pic3', 'ec60b7aff0c2da63c842755aad60a9cf.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  64. (872, 'vic-cocasse', '9d639bcf25bf84b20dca9ee2a0ce8a67.jpg', 'zs7JZ', 43, 'image', 25, '2018-11-03', 1, 100, 0, 0, 50, 1, 0, 0, 0, 0),
  65. (835, 'pic2', 'acff8ac0cd55ef95a80c2bfddadc54c0.png', 'TXngO', 43, 'image', 25, '2018-11-02', 7, 100, 30, 0, 0, 1, 0, 0, 0, 0),
  66. (883, 'pic2', 'f010d04e470420d0f5605b63752ba2b5.png', 'oQARR', 40, 'image', 56, '2018-11-06', 8, 11, 0, 0, 0, 1, 0, 0, 0, 0),
  67. (882, 'pic2', 'ff71704076d671f74a060d8daa36d8db.png', 'EaDOu', 40, 'image', 25, '2018-11-04', 5, 100, 0, 0, 50, 5, 0, 0, 0, 0),
  68. (862, 'DSC07504', '29d926936c0ed41b0fc371f456fcd80c.jpg', 'S4Ac9', 43, 'image', 30, '2018-11-03', 5, 100, 70, 0, 0, 1, 0, 0, 0, 0),
  69. (863, 'DSC07503', 'b402440a741b8fb6fa33b49d2f396710.jpg', 'S4Ac9', 43, 'image', 30, '2018-11-03', 5, 19, 0, 0, 0, 1, 0, 0, 0, 0),
  70. (849, 'pic2', '0ef97de4c0cea7485b17fb9965c3f497.png', 'S4Ac9', 43, 'image', 0, '2018-11-03', 5, 0, 0, 0, 0, 1, 0, 0, 0, 0),
  71. (871, 'tom4', 'a6671a45bb18c22464b90b269bf86d27.jpg', 'c79dk', 43, 'image', 5, '2018-11-03', 1, 65, 0, 0, 0, 1, 0, 0, 0, 0),
  72. (844, 'pic2', '96f1946634e742620cf8e4e4d7689edf.png', 'pjhny', 43, 'image', 15, '2018-11-02', 6, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  73. (845, 'main', '936d2023982a9e662dd94fa24c83888f.png', 'MEfUd', 43, 'image', 26, '2018-11-02', 1, 100, 50, 0, 0, 1, 0, 0, 0, 0),
  74. (848, 'main', '7a66a649f39631b4a42a2bcdbca29ac8.png', 'S4Ac9', 43, 'image', 0, '2018-11-03', 5, 0, 0, 0, 0, 1, 0, 0, 0, 0),
  75. (868, 'Fastest marathon with two runners handcuffed together (male)', 'dbd510b6085b9ce6cfb0c30a59ba2c01.jpg', 'c79dk', 43, 'image', 178, '2018-11-03', 1, 43, 0, 0, 0, 1, 0, 0, 0, 0),
  76. (869, 'tom2', '45da545d72a35cc428e59d0e5c7412e4.jpg', 'c79dk', 43, 'image', 33, '2018-11-03', 1, 18, 0, 0, 0, 1, 0, 0, 0, 0),
  77. (870, 'tom3', '672c7136e15e1a91dc13e7f44364785f.jpg', 'c79dk', 43, 'image', 32, '2018-11-03', 1, 48, 50, 0, 0, 1, 0, 0, 0, 0),
  78. (881, 'coverphoto', '7e142c7a94e76f5c11908f1edce63991.png', 'gPFhP', 40, 'image', 25, '2018-11-04', 8, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  79. (885, '45147742_2037543622933497_3879602099725533184_n', 'd7a43b1871f3ec07e579ff1214181888.jpg', NULL, 43, 'image', 0, NULL, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0),
  80. (884, '45147742_2037543622933497_3879602099725533184_n', 'f4413f53d27261b26ec0b2b7c8def23f.jpg', 'oQARR', 43, 'image', 25, '2018-11-05', 12, 61, 30, 4, 0, 1, 0, 0, 0, 0),
  81. (879, 'fblogo', '42ef5891bbdba99490b7a7e4e5c43ac9.png', 'gPFhP', 40, 'image', 25, '2018-11-04', 8, 100, 0, 5, 0, 1, 0, 0, 0, 0),
  82. (880, 'favicon', '0118114c86ccd8dfef9ba0872ddd5bfb.png', 'gPFhP', 40, 'image', 25, '2018-11-04', 8, 100, 0, 5, 0, 1, 0, 0, 0, 0);
  83.  
  84. -- --------------------------------------------------------
  85.  
  86. --
  87. -- Structure de la table `log`
  88. --
  89.  
  90. CREATE TABLE `log` (
  91. `keyid` int(11) NOT NULL,
  92. `userid` int(11) NOT NULL,
  93. `action` text NOT NULL,
  94. `ip_addr` text NOT NULL,
  95. `browser` text NOT NULL,
  96. `platform` text NOT NULL,
  97. `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  98. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  99.  
  100. --
  101. -- Contenu de la table `log`
  102. --
  103.  
  104. INSERT INTO `log` (`keyid`, `userid`, `action`, `ip_addr`, `browser`, `platform`, `time`) VALUES
  105. (6, 40, 'password changed', '70.31.237.26', 'Chrome', 'Win10', '2018-10-02 23:33:22'),
  106. (4, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-02 23:33:22'),
  107. (5, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-02 23:33:22'),
  108. (7, 40, 'password changed', '70.31.237.26', 'Chrome', 'Win10', '2018-10-02 23:33:32'),
  109. (8, 40, 'login', '132.203.214.23', 'Firefox', 'Win10', '2018-10-03 01:42:23'),
  110. (9, 60, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-03 15:42:41'),
  111. (10, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-03 15:53:47'),
  112. (11, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-03 17:43:18'),
  113. (12, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-04 16:27:06'),
  114. (13, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-04 16:42:19'),
  115. (14, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-04 17:00:37'),
  116. (15, 60, 'login', '173.231.113.82', 'Chrome', 'Linux', '2018-10-04 17:13:50'),
  117. (16, 60, 'login', '173.231.113.82', 'Chrome', 'macOS', '2018-10-04 17:14:17'),
  118. (17, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-04 19:36:28'),
  119. (18, 61, 'register', '208.111.67.49', 'Chrome', 'Win10', '2018-10-06 03:42:40'),
  120. (19, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-07 18:05:38'),
  121. (20, 62, 'register', '213.159.38.90', 'Opera', 'Win7', '2018-10-08 03:17:11'),
  122. (21, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-08 16:24:53'),
  123. (22, 43, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-09 18:03:54'),
  124. (23, 43, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-09 18:14:54'),
  125. (24, 43, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-09 19:22:41'),
  126. (25, 43, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-09 20:08:15'),
  127. (26, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-09 20:09:01'),
  128. (27, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-09 20:34:06'),
  129. (28, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-10 01:53:45'),
  130. (29, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-10 01:54:34'),
  131. (30, 43, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-10 02:14:40'),
  132. (31, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-10 02:15:01'),
  133. (32, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-10 05:30:06'),
  134. (33, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-10 09:09:55'),
  135. (34, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-10 13:14:02'),
  136. (35, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-10 14:05:30'),
  137. (36, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-10 14:05:31'),
  138. (37, 43, 'login', '198.52.38.4', 'Chrome', 'Win10', '2018-10-10 20:11:47'),
  139. (38, 40, 'login', '207.189.30.216', 'Chrome', 'Win10', '2018-10-11 01:23:59'),
  140. (39, 40, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-11 02:56:22'),
  141. (40, 40, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-12 19:05:59'),
  142. (41, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-12 19:40:23'),
  143. (42, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-12 20:57:20'),
  144. (43, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-12 23:04:32'),
  145. (44, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-12 23:05:18'),
  146. (45, 40, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-12 23:30:51'),
  147. (46, 43, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-12 23:32:11'),
  148. (47, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-12 23:39:57'),
  149. (48, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-13 04:31:02'),
  150. (49, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-13 05:25:31'),
  151. (50, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-13 06:10:22'),
  152. (51, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-13 06:35:22'),
  153. (52, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-13 14:07:31'),
  154. (53, 40, 'login', '70.31.237.26', 'Chrome', 'Linux', '2018-10-14 13:55:13'),
  155. (54, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-14 14:06:08'),
  156. (55, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-14 16:58:24'),
  157. (56, 40, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-14 17:25:57'),
  158. (57, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-14 17:39:39'),
  159. (58, 40, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-14 17:40:10'),
  160. (59, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-15 00:34:52'),
  161. (60, 40, 'login', '70.31.237.26', 'Chrome', 'Win10', '2018-10-15 04:28:26'),
  162. (61, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-15 13:41:17'),
  163. (62, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-15 17:31:32'),
  164. (63, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-15 17:55:30'),
  165. (64, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-15 17:55:55'),
  166. (65, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-15 19:39:01'),
  167. (66, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-16 04:26:24'),
  168. (67, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-16 15:05:43'),
  169. (68, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 20:59:56'),
  170. (69, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 21:02:47'),
  171. (70, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 21:17:35'),
  172. (71, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 21:26:20'),
  173. (72, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 23:01:01'),
  174. (73, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 23:17:24'),
  175. (74, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 23:17:27'),
  176. (75, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-16 23:53:43'),
  177. (76, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-17 08:07:28'),
  178. (77, 40, 'login', '70.31.238.8', 'Chrome', 'Win10', '2018-10-17 09:02:47'),
  179. (78, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-10-17 19:07:57'),
  180. (79, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-18 03:05:34'),
  181. (80, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-18 04:22:33'),
  182. (81, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-19 01:16:08'),
  183. (82, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-19 01:20:03'),
  184. (83, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-19 01:25:27'),
  185. (84, 43, 'login', '174.92.246.120', 'Chrome', 'Win10', '2018-10-19 05:56:31'),
  186. (85, 63, 'register', '24.114.111.232', 'Safari', 'iOS', '2018-10-20 05:05:53'),
  187. (86, 40, 'login', '64.229.103.98', 'Chrome', 'Win10', '2018-10-22 08:53:57'),
  188. (87, 43, 'login', '174.92.199.110', 'Chrome', 'Win10', '2018-10-22 14:52:45'),
  189. (88, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-23 03:17:44'),
  190. (89, 43, 'login', '174.92.199.110', 'Chrome', 'Win10', '2018-10-23 11:16:06'),
  191. (90, 43, 'login', '174.92.199.110', 'Chrome', 'Win10', '2018-10-24 08:08:33'),
  192. (91, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-24 12:16:59'),
  193. (92, 40, 'login', '207.189.31.175', 'Firefox', 'Win10', '2018-10-24 16:23:14'),
  194. (93, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-25 03:15:42'),
  195. (94, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-25 17:12:57'),
  196. (95, 40, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-25 17:25:02'),
  197. (96, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-25 20:04:14'),
  198. (97, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-26 01:50:55'),
  199. (98, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-26 12:17:56'),
  200. (99, 40, 'login', '132.203.211.201', 'Firefox', 'Win10', '2018-10-26 18:30:26'),
  201. (100, 40, 'login', '132.203.211.201', 'Chrome', 'Win10', '2018-10-26 18:54:16'),
  202. (101, 43, 'login', '132.203.211.233', 'Firefox', 'Win10', '2018-10-26 20:51:25'),
  203. (102, 43, 'login', '132.203.211.233', 'Chrome', 'Win10', '2018-10-26 21:31:54'),
  204. (103, 40, 'login', '132.203.211.201', 'Chrome', 'Win10', '2018-10-27 00:36:12'),
  205. (104, 40, 'login', '207.189.31.175', 'Chrome', 'Win10', '2018-10-27 02:55:28'),
  206. (105, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-10-27 03:08:32'),
  207. (106, 40, 'login', '45.61.8.194', 'Chrome', 'Win10', '2018-10-27 18:59:17'),
  208. (107, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-28 08:43:53'),
  209. (108, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-28 15:15:37'),
  210. (109, 64, 'register', '45.62.220.148', 'Chrome', 'macOS', '2018-10-28 18:36:23'),
  211. (110, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-10-28 19:06:05'),
  212. (111, 40, 'login', '207.189.30.171', 'Firefox', 'Win10', '2018-10-28 21:52:25'),
  213. (112, 40, 'login', '207.189.30.171', 'Firefox', 'Win10', '2018-10-28 21:52:26'),
  214. (113, 40, 'login', '207.189.30.171', 'Chrome', 'Win10', '2018-10-29 15:34:39'),
  215. (114, 40, 'login', '207.189.30.171', 'Chrome', 'Win10', '2018-10-29 19:26:51'),
  216. (115, 40, 'login', '207.189.30.171', 'Chrome', 'Win10', '2018-10-29 19:37:50'),
  217. (116, 40, 'login', '207.189.30.171', 'Chrome', 'Win10', '2018-10-29 19:37:50'),
  218. (117, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-10-29 20:10:01'),
  219. (118, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-30 15:09:42'),
  220. (119, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-31 04:33:10'),
  221. (120, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-31 04:33:22'),
  222. (121, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-10-31 15:04:01'),
  223. (122, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-10-31 22:01:25'),
  224. (123, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-01 17:03:43'),
  225. (124, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-01 20:42:12'),
  226. (125, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-01 23:27:14'),
  227. (126, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-02 12:27:41'),
  228. (127, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 12:50:02'),
  229. (128, 40, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 16:07:22'),
  230. (129, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 16:09:00'),
  231. (130, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 16:40:31'),
  232. (131, 40, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 16:40:45'),
  233. (132, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-02 16:41:44'),
  234. (133, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-02 19:47:23'),
  235. (134, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-02 22:10:49'),
  236. (135, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-02 22:51:02'),
  237. (136, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-03 01:22:37'),
  238. (137, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-03 15:06:29'),
  239. (138, 43, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-03 16:39:52'),
  240. (139, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-03 16:40:07'),
  241. (140, 43, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-03 20:46:07'),
  242. (141, 40, 'login', '50.100.119.212', 'Chrome', 'Win10', '2018-11-03 23:34:36'),
  243. (142, 40, 'login', '174.92.38.186', 'Chrome', 'Win10', '2018-11-03 23:50:57'),
  244. (143, 43, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-05 19:15:26'),
  245. (144, 40, 'login', '205.237.78.11', 'Chrome', 'Win10', '2018-11-06 00:12:10');
  246.  
  247. -- --------------------------------------------------------
  248.  
  249. --
  250. -- Structure de la table `newsletter`
  251. --
  252.  
  253. CREATE TABLE `newsletter` (
  254. `keyid` int(11) NOT NULL,
  255. `email` text NOT NULL,
  256. `usertype` text NOT NULL,
  257. `subscribe_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  258. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  259.  
  260. --
  261. -- Contenu de la table `newsletter`
  262. --
  263.  
  264. INSERT INTO `newsletter` (`keyid`, `email`, `usertype`, `subscribe_time`) VALUES
  265. (1, 'vxc@xn--gsdffsd-eya.dsf', 'buyer', '2018-09-29 16:25:40'),
  266. (2, 'gf@fgs.fds', 'freelancer', '2018-09-29 16:25:59'),
  267. (3, 'dfs@sf.sdf', 'buyer', '2018-09-29 16:28:24'),
  268. (4, 'hello1@fea.das', 'freelancer', '2018-09-29 16:28:52'),
  269. (5, 'hello1@fea.das', 'freelancer', '2018-09-29 16:29:20'),
  270. (6, 'asdda@dasdas.dsa', 'buyer', '2018-10-09 20:19:27'),
  271. (7, 'tshitshi17@live.fr', 'buyer', '2018-10-20 05:05:09'),
  272. (8, 'rosie.bahrani@gmail.com', 'freelancer', '2018-10-28 18:34:42');
  273.  
  274. -- --------------------------------------------------------
  275.  
  276. --
  277. -- Structure de la table `transactions`
  278. --
  279.  
  280. CREATE TABLE `transactions` (
  281. `keyid` int(11) NOT NULL,
  282. `fromid` int(11) NOT NULL,
  283. `toid` int(11) NOT NULL,
  284. `id` text NOT NULL,
  285. `name` text NOT NULL,
  286. `amount` decimal(10,2) NOT NULL,
  287. `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  288. `paypal_paymentid` text NOT NULL,
  289. `paypal_payerid` text NOT NULL,
  290. `approved` int(1) NOT NULL
  291. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  292.  
  293. --
  294. -- Contenu de la table `transactions`
  295. --
  296.  
  297. INSERT INTO `transactions` (`keyid`, `fromid`, `toid`, `id`, `name`, `amount`, `date`, `paypal_paymentid`, `paypal_payerid`, `approved`) VALUES
  298. (285, 43, 40, 'ee889084979594e622dc70ff575fe765.jpg', '39589228_10160664254490117_1686956247837835264_o', 54.00, '2018-11-03 16:53:26', 'PAY-58H29433K5947353HLPO5FBQ', '9P4TWWVEVSW7W', 1),
  299. (284, 43, 40, '2466f10dda3f7efb4633eb9cefc18cb5.jpg', '39807987_2131075210296085_3231551788855328768_n', 54.00, '2018-11-02 00:00:00', 'PAY-58H29433K5947353HLPO5FBQ', '9P4TWWVEVSW7W', 1),
  300. (283, 43, 40, '45a5956354d3d29c9a823aba7de06207.svg', 'PrevU-SMALL', 45.00, '2017-09-15 16:53:26', 'PAY-58H29433K5947353HLPO5FBQ', '9P4TWWVEVSW7W', 1);
  301.  
  302. -- --------------------------------------------------------
  303.  
  304. --
  305. -- Structure de la table `users`
  306. --
  307.  
  308. CREATE TABLE `users` (
  309. `userid` int(11) NOT NULL,
  310. `email` varchar(50) NOT NULL,
  311. `fname` varchar(50) NOT NULL,
  312. `lname` varchar(50) NOT NULL,
  313. `password` varchar(60) NOT NULL,
  314. `has_avatar` int(1) NOT NULL,
  315. `balance` decimal(10,2) NOT NULL,
  316. `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  317. `failed_attempts` int(11) NOT NULL,
  318. `mail_confirm_code` varchar(64) NOT NULL,
  319. `active` int(1) NOT NULL,
  320. `mail_confirmed` int(1) NOT NULL,
  321. `chatid` varchar(64) NOT NULL,
  322. `gender` int(1) NOT NULL,
  323. `is_saving_items` int(1) NOT NULL
  324. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  325.  
  326. --
  327. -- Contenu de la table `users`
  328. --
  329.  
  330. INSERT INTO `users` (`userid`, `email`, `fname`, `lname`, `password`, `has_avatar`, `balance`, `reg_date`, `failed_attempts`, `mail_confirm_code`, `active`, `mail_confirmed`, `chatid`, `gender`, `is_saving_items`) VALUES
  331. (40, 'freud.fortier.chouinard@gmail.com', 'Freud', 'Fort-Chouin', '$2y$10$sayqMDkixgXM5b.gBFHT7OS7miXUcll8RHf9x1xXaB5VH1vQEl9ju', 0, 312.32, '2018-04-30 14:20:49', 0, 'ad161fd0d033941f0950a7f8de543534e608a7c8ab20bc9f917ba03c64e1c8ca', 0, 1, '978d4cf7a7239a17c44b1a2cc0df4b4b05e116158102ce0ca3089ddc45b18fc7', 2, 1),
  332. (58, '1@1.1', 'sfdfsdf', 'dfsfsdfsd', '$2y$10$JUqbx4KV4AbU3h5aNgFyHesxw6mwS1byyjgYiBkie1bScgDTDRxe.', 0, 0.00, '2018-09-29 08:37:15', 0, '6bf1fce2b30c5f76452139bc32f05e2923f66965fdbfd3e8be23192f45f6abd2', 0, 0, '2e16d444174e34d16274085f007a8ac7e75a40a5f064076fe73385571ec84421', 0, 0),
  333. (59, 'sdffd@fsddfs.fds', 'dfsfds', 'dfssgd', '$2y$10$NCf2YGbof60SBdM7DMr1DOUsXQo22fk1W3ChQEq2I3T2kTaY85Dg2', 0, 0.00, '2018-09-29 08:59:51', 0, '2843f1a1a1c41808a76c2ae4a8e41cc181cda3bdb59ae4e387bb8197a4000034', 0, 0, '28cdd6351ab84b377d7119273d1585ad8db6be189fe7dff2438976b6ed0e3149', 0, 0),
  334. (60, 'john.doe456@test.com', 'John', 'Doe', '$2y$10$Dsg8y.wSAEqdRskAXvfkj.x/vE4MjcRik5/HVC97V8X9avrbAg5UG', 0, 190.00, '2018-09-29 16:31:10', 0, 'c4c35c4132a65a5be8f2f5441da360de4b13e2afa157ae8ded4f9bfbfac2263b', 0, 0, 'b34cd0215dc92041719dc4cbd81b13be1f19d155722f04fb4b72c15013c3538f', 0, 0),
  335. (61, 'l-pdupuis@hotmail.com', 'Louis-Philippe', 'Dupuis', '$2y$10$HEbZdEMbarOjhFTKuprbn.ZgaYsKO0VAvaVAroO8Yd0RXqC7ct8Tq', 0, 15.00, '2018-10-06 03:42:40', 0, '2726da20f574cdc1698481612a21d83a8d38cc3c5aced3fa8f78d97a8f27f2cd', 0, 0, '77d0a043fb3e8ef410aa81bd2d5ee95207196358c113a3e754efb13c5e528bb4', 0, 0),
  336. (43, 'yannpelletier3@gmail.com', 'Yann', 'Pelletier', '$2y$12$3hWxqyUrfzFABPLMreNzy.9w3cpOh2hJSp8ILj36LZo5YoHJOrz32', 1, 300.00, '2018-05-09 18:59:53', 0, '246f449b428027f9d29c95aa1e43fb6fdda1f1543f130384212935ec3814e53a', 0, 1, 'd1a1567cbd9dddaaec95bcfebe9faa680165a2fb84c289543e77808216d3b10f', 0, 1),
  337. (62, 'filipkwak@op.pl', 'WilliesPrevy', 'WilliesPrevy', '$2y$10$8PjhOUEJyeaMe8tXjyZHLOZWaUnK33PhMdQWlsrvWvWICmAvP5ANS', 0, 0.00, '2018-10-08 03:17:11', 0, '13d3931d8f07e0dce175f086871d4832d2b3963c96045e285defa5a9784cacf6', 0, 0, '57508a4bfd5b460ff9c19345ab7be65e1073b2b7332b9e05776ef38af4b4c275', 0, 0),
  338. (63, 'tshitshi17@live.fr', 'Jean-Claude', 'Tshibangu', '$2y$10$WyBLe/XNV1EOnp5isru60uk/IoAOdS3SFyL/etJsdHKrqiRjhB2da', 0, 0.00, '2018-10-20 05:05:52', 0, '8cfe98a243be58f7a519bec782c25c939d7e30dfd4a0eb5f04f2246c90c73c89', 0, 0, '9b7613a906df50ba5f7de2db48fc9a655c9eca73500baade8f81ef8a3b96b5bd', 0, 0),
  339. (64, 'rosie.bahrani@gmail.com', 'Rosie', 'Bahrani', '$2y$10$Gs4adFr.LHW5ZKs6Og/6Y.kDpD2ukwjoMVS2s82TD4fU4uwXxLTOm', 0, 0.00, '2018-10-28 18:36:23', 0, '00bd690257b4c35f0b2bb1aeaacded6b4843a9ca62dfa9ab12d1e28c815e0f89', 0, 0, 'e4a3a5beadefac005adc405be37a6f7e9096192719f3bd50385fe93385acdafd', 0, 0),
  340. (57, 'karolane_mb@hotmail.com', 'Monsieur', 'Walid', '$2a$04$FFHxzzQCJti.xpdhXoPJMOd8.nvoOPFcK7ntdE8T7PpsCDvymjwHK', 0, 0.00, '2018-09-12 03:21:47', 2, 'cfffdb1ec5ff6c50bfc6a35af5fdd79fef3c4877fe305a5885a5d87ee1f04c53', 0, 1, '4a28e7f42d1491d008892806b06278220186f01840aafdb19eddf4576f4aec69', 0, 0);
  341.  
  342. --
  343. -- Index pour les tables exportées
  344. --
  345.  
  346. --
  347. -- Index pour la table `items`
  348. --
  349. ALTER TABLE `items`
  350. ADD PRIMARY KEY (`keyid`);
  351.  
  352. --
  353. -- Index pour la table `log`
  354. --
  355. ALTER TABLE `log`
  356. ADD PRIMARY KEY (`keyid`);
  357.  
  358. --
  359. -- Index pour la table `newsletter`
  360. --
  361. ALTER TABLE `newsletter`
  362. ADD PRIMARY KEY (`keyid`);
  363.  
  364. --
  365. -- Index pour la table `transactions`
  366. --
  367. ALTER TABLE `transactions`
  368. ADD PRIMARY KEY (`keyid`);
  369.  
  370. --
  371. -- Index pour la table `users`
  372. --
  373. ALTER TABLE `users`
  374. ADD PRIMARY KEY (`userid`);
  375.  
  376. --
  377. -- AUTO_INCREMENT pour les tables exportées
  378. --
  379.  
  380. --
  381. -- AUTO_INCREMENT pour la table `items`
  382. --
  383. ALTER TABLE `items`
  384. MODIFY `keyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=886;
  385. --
  386. -- AUTO_INCREMENT pour la table `log`
  387. --
  388. ALTER TABLE `log`
  389. MODIFY `keyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;
  390. --
  391. -- AUTO_INCREMENT pour la table `newsletter`
  392. --
  393. ALTER TABLE `newsletter`
  394. MODIFY `keyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  395. --
  396. -- AUTO_INCREMENT pour la table `transactions`
  397. --
  398. ALTER TABLE `transactions`
  399. MODIFY `keyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;
  400. --
  401. -- AUTO_INCREMENT pour la table `users`
  402. --
  403. ALTER TABLE `users`
  404. MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
  405. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  406. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  407. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Add Comment
Please, Sign In to add comment
Public Pastes
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!