-- http://www.phpmyadmin.net
--




--
-- Database: `wirez_base_2`
--

--
-- Dumping data for table `causes`
--



--
-- Dumping data for table `conversations`
--

INSERT INTO `conversations` (`idConversation`, `idUser`, `idRecipient`, `timestamp`, `subject`) VALUES
(1, 1, 2, 1429274555, 'con título'),
(2, 2, 1, 1429415017, 'tesoro');

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`idFile`, `md5`, `name`, `timestamp`, `size`, `idUser`, `downloadCode`, `fileType`) VALUES
(1, '16c7fe60d3d53265932b', 'avatar_def.png', 1429460638, 285545, 2, '78ee3c14d6b7b715a0d7e1faaeae73b0', 'image/png; charset=binary'),
(2, '9a795521bae56a587ec1', 'avatar_def.jpg', 1429460656, 36979, 2, '784fbdb8ba7814a56c61ec9755ddbc5c', 'image/jpeg; charset=binar'),
(3, 'b8e5d2886c640596ac15', 'avatar_def.png', 1429460813, 66019, 2, '60e46963dddaee9b29d81297d3ce3e26', 'image/png; charset=binary'),
(4, '534eb7c34116b1946738', 'avatar_def.png', 1429460939, 22505, 2, 'ff3f7928a26c6c98260faefd4285f75b', 'image/png; charset=binary'),
(5, 'afc0f1c7ce4020e90409', 'avatar_def.png', 1429461014, 18722, 2, 'beb85e15ce0d2c3ccb5a67bf46f52693', 'image/png; charset=binary'),
(6, 'c38ce7d5385bce99cf82', 'avatar_def.png', 1429461067, 18722, 2, '54b7d4514212bb6ee7d248c6db19538f', 'image/png; charset=binary'),
(7, 'dc1cfd68bbec0012e063', 'avatar_def.jpg', 1429461108, 36979, 2, '178b61fe478f8dc0017d9a94e8a2e450', 'image/jpeg; charset=binar'),
(8, 'f9dac65839a2b7fb1d01', 'avatar_def.png', 1429461156, 285545, 2, '9d33c4d7bb3f24ac4674d07288434b2e', 'image/png; charset=binary'),
(9, '2aa5cea44628fc1934d4', 'avatar_def.png', 1429461165, 24411, 2, '42f4f663ef74ebc70a9f830a9966303c', 'image/png; charset=binary'),
(10, 'f44339dba051018a9548', 'avatar_def.png', 1429461191, 5087, 2, '739c575ccb3f343817b5419da83144aa', 'image/png; charset=binary'),
(11, 'b7ce63f83b2eae44ba0a', 'personalBackground.png', 1429461796, 92549, 2, 'c4a0a830b9327305f86960dad854dacb', 'image/png; charset=binary'),
(12, '273c3159a9efe7ca7850', 'personalBackground.png', 1429466301, 285545, 2, '19c69d049c5cadb8ad23f6f7aeebbae5', 'image/png; charset=binary'),
(13, '9143ab56264bb2915eb6', 'personalBackground.jpg', 1429466340, 43777, 2, '694399e0b390c17f3ffa7620c15c605f', 'image/jpeg; charset=binar'),
(14, '096d9b34cafad52ccd14', 'personalBackground.jpg', 1429466387, 146842, 2, '07e34748f8b15bd226ece2ac41a15d69', 'image/jpeg; charset=binar');


--
-- Dumping data for table `msgs`
--

INSERT INTO `msgs` (`idMsg`, `timestamp`, `ip`, `idSender`, `idRecipient`, `text`, `channel`, `attachments`, `idConversation`) VALUES
(1, 1429227759, '192.168.43.164', 1, 2, 'va uno nuevo', 0, 0, 0),
(2, 1429227772, '192.168.43.164', 2, 1, 'nicer dicer!', 0, 0, 0),
(3, 1429233896, '192.168.43.164', 1, 2, 'y el ultimo', 0, 0, 0),
(4, 1429234012, '192.168.43.164', 1, 2, 'id', 0, 0, 0),
(5, 1429274092, '192.168.43.164', 1, 2, 'aeoahu', 0, 0, 0),
(6, 1429274093, '192.168.43.164', 1, 2, 'aeou', 0, 0, 0),
(7, 1429274093, '192.168.43.164', 1, 2, 'oeu', 0, 0, 0),
(8, 1429274093, '192.168.43.164', 1, 2, 'u', 0, 0, 0),
(9, 1429274094, '192.168.43.164', 1, 2, 'au', 0, 0, 0),
(10, 1429274094, '192.168.43.164', 1, 2, 'u', 0, 0, 0),
(11, 1429274094, '192.168.43.164', 1, 2, 'eu', 0, 0, 0),
(12, 1429274095, '192.168.43.164', 1, 2, 'ue', 0, 0, 0),
(13, 1429274095, '192.168.43.164', 1, 2, 'eu', 0, 0, 0),
(14, 1429274095, '192.168.43.164', 1, 2, 'u', 0, 0, 0),
(15, 1429274095, '192.168.43.164', 1, 2, 'eu', 0, 0, 0),
(16, 1429274096, '192.168.43.164', 1, 2, '', 0, 0, 0),
(17, 1429274096, '192.168.43.164', 1, 2, 'u', 0, 0, 0),
(18, 1429274096, '192.168.43.164', 1, 2, 'ao', 0, 0, 0),
(19, 1429274097, '192.168.43.164', 1, 2, 'aouaoeu', 0, 0, 0),
(20, 1429274218, '192.168.43.164', 1, 2, 'b', 0, 0, 0),
(21, 1429274219, '192.168.43.164', 1, 2, 'c', 0, 0, 0),
(22, 1429274220, '192.168.43.164', 1, 2, 'd', 0, 0, 0),
(23, 1429274223, '192.168.43.164', 1, 2, 'a si, comprendo', 0, 0, 0),
(24, 1429274226, '192.168.43.164', 1, 2, 'bien bien bien', 0, 0, 0),
(25, 1429274555, '192.168.43.164', 1, 2, 'este debería tener titulo', 0, 0, 1),
(26, 1429275906, '192.168.43.164', 1, 2, 'uno', 0, 0, 1),
(27, 1429275907, '192.168.43.164', 1, 2, 'dos', 0, 0, 1),
(28, 1429275908, '192.168.43.164', 1, 2, 'tres', 0, 0, 1),
(29, 1429414895, '192.168.43.164', 2, 0, 'nthunaho', 0, 0, 1),
(30, 1429414914, '192.168.43.164', 2, 1, 'nthunaho', 0, 0, 1),
(31, 1429414926, '192.168.43.164', 2, 1, 'nanu nanu', 0, 0, 1),
(32, 1429415017, '192.168.43.164', 2, 1, 'del mar', 0, 0, 2),
(33, 1429415302, '192.168.43.164', 2, 1, 'aeua', 0, 0, 2),
(34, 1429415337, '192.168.43.164', 2, 1, 'nthnth', 0, 0, 2),
(35, 1429415351, '192.168.43.164', 2, 1, 'nhstnh', 0, 0, 2),
(36, 1429415368, '192.168.43.164', 2, 1, 'sth', 0, 0, 2),
(37, 1429415368, '192.168.43.164', 2, 1, '', 0, 0, 2),
(38, 1429415372, '192.168.43.164', 2, 1, 'tttt', 0, 0, 2),
(39, 1429415435, '192.168.43.164', 2, 1, 'snnn\\', 0, 0, 2),
(40, 1429415509, '192.168.43.164', 2, 1, 'aonuth', 0, 0, 2),
(41, 1429415516, '192.168.43.164', 2, 1, 'aoeu', 0, 0, 2),
(42, 1429415532, '192.168.43.164', 2, 1, 'uaeou', 0, 0, 2),
(43, 1429415560, '192.168.43.164', 2, 1, 'naeohu', 0, 0, 2),
(44, 1429415563, '192.168.43.164', 2, 1, 'uno', 0, 0, 2),
(45, 1429415576, '192.168.43.164', 2, 1, 'mas', 0, 0, 2),
(46, 1429416009, '192.168.43.164', 2, 1, 'tons', 0, 0, 2),
(47, 1429416013, '192.168.43.164', 2, 1, 'que bien :)', 0, 0, 2),
(48, 1429416019, '192.168.43.164', 2, 1, 'vea bb', 0, 0, 2),
(49, 1429420265, '192.168.43.164', 2, 1, 'hola ?', 0, 0, 2),
(50, 1429420268, '192.168.43.164', 2, 1, 'tnahseosutah', 0, 0, 2),
(51, 1429420269, '192.168.43.164', 2, 1, 'aoeu', 0, 0, 2),
(52, 1429420269, '192.168.43.164', 2, 1, 'oaeu', 0, 0, 2),
(53, 1429420269, '192.168.43.164', 2, 1, 'oaeu', 0, 0, 2),
(54, 1429420270, '192.168.43.164', 2, 1, 'uaou', 0, 0, 2),
(55, 1429420270, '192.168.43.164', 2, 1, 'u', 0, 0, 2),
(56, 1429420270, '192.168.43.164', 2, 1, 'ae', 0, 0, 2),
(57, 1429420379, '192.168.43.164', 2, 1, 'nicer dicer!', 0, 0, 2),
(58, 1429448743, '192.168.43.164', 2, 1, 'aeonuh', 0, 0, 2),
(59, 1429456372, '192.168.43.164', 2, 1, 'funciona?', 0, 0, 2),
(60, 1429456377, '192.168.43.164', 2, 1, 'si señor!!!', 0, 0, 2),
(61, 1429536336, '192.168.43.164', 2, 1, 'hello', 0, 0, 2);

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`idSession`, `idUser`, `sessionKey`, `ip`, `lastAccess`) VALUES
(1, 2, 'bd118a3314ddb6b4efb916684b737eb5', '192.168.43.164', 1429398089),
(2, 2, '44c1b581e167c80d3581968d68f0ad04', '192.168.43.164', 1429398178),
(3, 2, 'a3be861ade89a7132109eb67e25bd2a0', '192.168.43.164', 1429398530),
(4, 2, '66cec0b9006d14d48dcfd26ce3ed0931', '192.168.43.164', 1429407765),
(6, 1, '2096452650acc4ae155e8f8eb05c8788', '192.168.43.164', 1429496305),
(7, 1, '5983f135954035fcbcb365ff8afd2a71', '192.168.43.164', 1429496317),
(8, 1, '4fa4817b41adb8622eca0f797ef44f6b', '192.168.43.164', 1429496370),
(9, 2, '6fea012409abc6a31a9aedacee8bb303', '192.168.43.164', 1429496728),
(10, 2, '97d67025a13884a4dbfe8cdb771b17e5', '192.168.43.164', 1429533968),
(11, 2, '552607ffd8221a644ee77d3c1c07ad3d', '192.168.43.164', 1429533973),
(12, 2, 'f294baa184b5e36b974b6260ba03006a', '192.168.43.164', 1429536336),
(13, 1, '36215e1a6808ab5e17e8e750f561f462', '192.168.43.164', 1429541722),
(14, 2, 'fd61d2235438d8a62630fb9945b90d84', '192.168.43.164', 1429541955),
(15, 2, '28d4923daf33cb6c5d4635988cec874e', '192.168.43.164', 1429541972),
(16, 2, '05bf790471b1298926a0d17bdbfdb840', '192.168.43.164', 1429545215),
(17, 2, '597737776a93555a20c9b839ef08ac49', '192.168.43.164', 1429649295),
(19, 8, '643c0ce7e3014b2669c5536d3c6bbf4c', '192.168.43.164', 1429650962),
(20, 9, 'fa112ed8f04d165d09adee10a758641f', '192.168.43.164', 1429651495),
(21, 10, 'e203404684b82aab4e22948a0343f5a8', '192.168.43.164', 1429651569),
(22, 11, 'ad60173b95e866a16860a93fdff3a42d', '192.168.43.164', 1429651699),
(23, 12, '493ab9400739a8c865655efb73798a91', '192.168.43.164', 1429652561),
(24, 13, 'ade79791cb1c18a76813f7b7a3c2853f', '192.168.43.164', 1429652641),
(25, 14, 'e1e7c723d1144f5bbf1b12b7f9bf4e4f', '192.168.43.164', 1429652664),
(26, 15, 'f73d0064cc90e036fa9d03e7536818ac', '192.168.43.164', 1429652716),
(27, 16, 'e484739def903a8557a64f192de9922c', '192.168.43.164', 1429652754),
(28, 17, '442945b23f626a1165e5e807115216bd', '192.168.43.164', 1429652885),
(33, 2, 'd4cc59d153ac8ca5091db99bef31908e', '192.168.43.164', 1429749298),
(34, 2, '1f14c1e815fa9464d229b55559ef238f', '192.168.43.164', 1429749346),
(35, 2, '7bf3394cabad41b7f1bcfdf7737c1745', '192.168.43.164', 1429749466),
(36, 2, '1a367574633dd18957737bcb38f5cec9', '192.168.43.164', 1429753112),
(37, 2, 'de456dea9590279ec7b94d79ee923a47', '192.168.43.164', 1429797593),
(38, 19, 'cbb5d74098893ff03613e4fcf16a4ed2', '192.168.43.164', 1429804246),
(39, 20, '2c77a65ac8a86fa533dbe67b16a0d5ee', '192.168.43.164', 1429804287),
(40, 21, '7353ffd2ddd6f3abc0626c2fe940b743', '192.168.43.164', 1429804328),
(41, 22, '27ad5273b206b6d15fb844faa3caf121', '192.168.43.164', 1429804380),
(42, 23, '11ebb6c176e6e966bd040cbced34dac3', '192.168.43.164', 1429804443),
(43, 24, '5e8da7438464ca0067b19880d3166162', '192.168.43.164', 1429804656),
(44, 25, 'bd00eb9f1b958e95a1e4fbea8af8d13d', '192.168.43.164', 1429804718),
(45, 26, '2dc668b76fbced742c6d1adeb914dece', '192.168.43.164', 1429804782),
(46, 33, 'a6fea227362300a6e83721f3ee748ce5', '192.168.43.164', 1429807057),
(47, 34, '78ae6b7d2ea9825cbd0b910dae3f89d8', '192.168.43.164', 1429807112),
(48, 27, '117a2b1e767143136fbe5e278d68e148', '192.168.43.164', 1429807439),
(49, 35, '8d09406d8e55d1a5a1010ac90fcd5126', '192.168.43.164', 1429807727),
(50, 35, '26a2b0bd78078e60a8c58aca51d762cc', '192.168.43.164', 1429807756),
(51, 2, '57114557989a2c8212d7f4a3d95e4dd3', '192.168.43.164', 1429809929),
(52, 2, 'a3d34e887a5ed7939a74188b1176b71f', '192.168.43.164', 1429811433),
(53, 2, '506163bf9da171574ffad01806678a8a', '192.168.43.164', 1429811689),
(54, 2, '3a63e5bccac4c538d302b683d3fbcd0c', '192.168.43.164', 1429812211),
(55, 2, '87c58b8bafe0ca966fa6dac9045cbb59', '192.168.43.164', 1429812346),
(56, 2, '2f5607af38913c9134bacdcb0be1a507', '192.168.43.164', 1429812415),
(57, 2, '4c9f7953d9e1911c0f7fa836cde795bc', '192.168.43.164', 1429812514),
(58, 2, '7d5e456ad357c13922a6a4a1a5d6bd9d', '192.168.43.164', 1429813864);

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`idUser`, `fullName`, `userName`, `email`, `about`, `country`, `status`, `timestamp`, `lastAccess`, `pwd`, `avatar`, `settings`) VALUES
(1, 'root', 'root', 'a', 'I am me', 'crc', '1', 1429235768, 1429541722, '202cb962ac59075b964b07152d234b70', '', ''),
(2, 'Psychocat', 'psychocat', 'psychocat@psychocat.com', 'Main admin', 'crc', '1', 1429235788, 1429812543, '827ccb0eea8a706c4c34a16891f84e7b', '10', ''),
(3, 'tercero', 'tercero', 'c', 'I am me', 'crc', '1', 1429235803, 1429235805, '202cb962ac59075b964b07152d234b70', '', ''),
(4, 'theChicken', 'theChicken', 'd', 'I am me', 'crc', '1', 1429235823, 1429235825, '202cb962ac59075b964b07152d234b70', '', ''),
(5, 'mas', 'mas', 'e', 'I am me', 'crc', '1', 1429235831, 1429235832, '202cb962ac59075b964b07152d234b70', '', ''),
(6, 'ymas', 'ymas', 'f', 'I am me', 'crc', '1', 1429235839, 1429235840, '202cb962ac59075b964b07152d234b70', '', ''),
(7, 'sobad', 'sobad', 'sobad@me.com', 'I am me', 'crc', '1', 1429235881, 1429812346, '202cb962ac59075b964b07152d234b70', '', ''),
(8, 'tnhs', 'asnotheus', 'nth', '', '', '1', 1429650962, 1429650962, 'f53654c738a5b01e4eeee5102b8c9a1f', '0', ''),
(9, 'tnhs', 'asnoo9otheus', 'nthe', '', '', '1', 1429651495, 1429651495, 'f53654c738a5b01e4eeee5102b8c9a1f', '0', ''),
(10, 'tnhs', 'asnoo9otheous', 'ntheo', '', '', '1', 1429651569, 1429651569, 'f53654c738a5b01e4eeee5102b8c9a1f', '0', ''),
(11, 'tnhs', 'aseous', 'nthOeo', '', '', '1', 1429651699, 1429651699, 'f53654c738a5b01e4eeee5102b8c9a1f', '0', ''),
(12, 'tnhss', '1oaseous', '1nthOeo', '', '', '1', 1429652561, 1429652561, 'f53654c738a5b01e4eeee5102b8c9a1f', '0', ''),
(13, 'newName', 'nuew', 'aehu@nohu.com', '', '', '1', 1429652641, 1429652641, '202cb962ac59075b964b07152d234b70', '0', ''),
(14, 'delmar', 'tesoro', 'aaehu@nohu.com', '', '', '1', 1429652664, 1429652664, '202cb962ac59075b964b07152d234b70', '0', ''),
(15, 'snaothu', 'my name', 'nsathu@nothu.', '', '', '1', 1429652716, 1429652716, '202cb962ac59075b964b07152d234b70', '0', ''),
(16, 'saoehu', 'tttttt', 'aothu@nothu.com', '', '', '1', 1429652754, 1429652754, '202cb962ac59075b964b07152d234b70', '0', ''),
(17, 'tres', 'unodos', 'cuatro@nothu.com', '', '', '1', 1429652885, 1429652885, '202cb962ac59075b964b07152d234b70', '0', ''),
(18, 'nuevo12', 'nuevo2', 'saoneh@nothu.oc', '', '', '1', 1429653077, 1429653168, '202cb962ac59075b964b07152d234b70', '0', ''),
(19, 'stnh', 'snaeotu', 'atnhou@nouh.co', '', 'crc', '1', 1429804246, 1429804246, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(20, 'uno mas', 'uno', 'ono@ont.oc', '', 'crc', '1', 1429804287, 1429804287, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(21, 'dos mas', 'dos', 'odos@not.com', '', 'crc', '1', 1429804328, 1429804328, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(22, 'tres m', 'tres', 'tres@mio.tom', '', 'crc', '1', 1429804380, 1429804380, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(23, 'cuarto n', 'cuarto', 'cuatro@me.com', '', 'crc', '1', 1429804443, 1429804443, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(24, 'cinco n', 'cinco', 'cinco@me.com', '', 'crc', '1', 1429804656, 1429804656, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(25, 'seis m', 'seis', 'seis@me.com', '', 'crc', '1', 1429804718, 1429804719, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(26, 'siete n', 'siete', 'siete@me.com', '', 'crc', '1', 1429804782, 1429804782, 'd41d8cd98f00b204e9800998ecf8427e', '0', ''),
(27, 'ocho m', 'ocho', 'ocho@me.com', '', 'crc', '1', 1429806243, 1429806243, '202cb962ac59075b964b07152d234b70', '0', ''),
(28, 'ochoo m', 'ochoo', 'ochoo@me.com', '', 'crc', '1', 1429806364, 1429806364, '202cb962ac59075b964b07152d234b70', '0', ''),
(29, 'ocho8o m', 'ocho8o', 'ocho8o@me.com', '', 'crc', '1', 1429806516, 1429806516, '202cb962ac59075b964b07152d234b70', '0', ''),
(30, 'ocho8o m', '8ocho8o', '8ocho8o@me.com', '', 'crc', '1', 1429806549, 1429806549, '202cb962ac59075b964b07152d234b70', '0', ''),
(31, 'ocho8o m', 'unnuevo8o', 'unnuevo@me.com', '', 'crc', '1', 1429806673, 1429806673, '202cb962ac59075b964b07152d234b70', '0', ''),
(32, 'ocho8o m', 'aaa', 'aaa@me.com', '', 'crc', '1', 1429806974, 1429806974, '202cb962ac59075b964b07152d234b70', '0', ''),
(33, 'ocho8o m', 'aaa1', 'aaa1@me.com', '', 'crc', '1', 1429807057, 1429807057, '202cb962ac59075b964b07152d234b70', '0', ''),
(34, 'zzz n', 'zzz', 'zzz@notho.com', '', 'crc', '1', 1429807112, 1429807112, '81dc9bdb52d04dc20036dbd8313ed055', '0', ''),
(35, 'ppp n', 'ppp', 'ppp@me.com', '', 'crc', '1', 1429807727, 1429807727, '827ccb0eea8a706c4c34a16891f84e7b', '0', '');

