--
-- Host: localhost    Database: ppg.org.ua
-- ------------------------------------------------------


--
-- Table structure for table `upload`
--

CREATE TABLE `upload` (
  `user_id` varchar(30) CHARACTER SET utf8 NOT NULL,
  `file` varchar(100) CHARACTER SET utf8 NOT NULL,
  `up_date` date NOT NULL DEFAULT '0000-00-00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `upload`
--

INSERT INTO `upload` VALUES ('adm','largemale4.jpg','2010-09-08'),('flash','bomb.jpeg','2010-09-12'),('flash','bomb_1.jpeg','2010-09-12'),('adm','muzhskie-strizhki-2010_55974.jpg','2010-09-08'),('gagarin','x_c9df3179.jpg','2010-09-08'),('gagarin','ðÁÞÅËÏ.doc','2010-09-08'),('flash','cisco.gif','2010-09-08'),('flash','blins.jpg','2010-09-08'),('dmandryka','bcm.jpg','2010-09-08'),('flash','iriny2.jpg','2010-09-12'),('flash','6a00d8341ca35253ef00e54f39437f8834-800wi.jpg','2010-09-15'),('flash','x_f3d5784e.jpg','2010-09-19'),('flash','0006.jpg','2010-09-20'),('flash','favicon.ico','2010-11-17'),('flash','IMG_6540.jpg','2010-09-26'),('flash','18062010400.jpg','2010-09-28'),('flash','logo_2.jpg','2010-11-17'),('flash','x_b575eb18.jpg','2010-10-03'),('ppg111','beer.avi','2010-11-16'),('','resume.doc','2010-11-17'),('flash','favicon.ico','2010-11-17'),('flash','26082010428.jpg','2010-11-18'),('flash','31072010424.jpg','2010-11-18'),('flash','14082010426.jpg','2010-11-18'),('flash','18112010439.jpg','2010-11-19'),('Gamilton','11.jpg','2010-11-22'),('flash','rc.JPG','2010-11-24'),('flash','ufo.JPG','2010-11-24'),('flash','screen.jpg','2010-11-27');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(30) NOT NULL,
  `user_password` varchar(32) NOT NULL,
  `user_hash` varchar(32) NOT NULL,
  `user_ip` int(10) DEFAULT NULL,
  `last_login` date NOT NULL,
  `admin_group` int(1) NOT NULL DEFAULT '0',
  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `surname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `birthday` date NOT NULL,
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;

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

INSERT INTO `users` VALUES (1,'flash','62e39aeb5a17cabc307110dc5dfa6666','8a036cc15905b38b9ff488ee6971fff7',2147483647,'2016-09-11',1,'Dmytriy','Mandryka','1984-03-13','mandryka.d@gmail.com'),(6,'admin','0d8c9b90d53031ef93e5c64034d0c51d','3d11e8ab8e776fc61958afb4f3263842',779528895,'0000-00-00',0,'','','0000-00-00',''),(55,'dmandryka','62e39aeb5a17cabc307110dc5dfa6666','090cebfd8d8733702a304f2760c66d37',2147483647,'2014-06-04',0,'ôÅÓÔÏ×ÁÑ','ÚÁÐÉÓØ','0000-00-00','mandryka.d@gmail.com'),(53,'ppg','203eb915a191ab075a07c53f13cf89d0','5802a8a023b0af21010b46a5e5fa6f58',1587120262,'2014-09-26',1,'','','0000-00-00',''),(9,'gagarin','4420a55ab69ae28f0bcac8056871c77d','8e3d33ba768055c086dfba302251ebf1',1440738667,'0000-00-00',0,'','','0000-00-00',''),(54,'BlackCat','ed7c004666019214d1f25cc0e85ff997','2e045459f073484b8982a15cca2bd83f',2147483647,'0000-00-00',0,'','','0000-00-00',''),(14,'mari','03b11139074e14c508660389e70db71b','0281024033f18ad2e0ee3c847468b1b7',1440738667,'0000-00-00',0,'','','0000-00-00',''),(15,'Gamilton','cc984738682e338cd04fe537a55a644b','ea1b6a6c4a2207c3652b8665ba81c3a9',1568620670,'2013-07-25',0,'','îÅ ÓËÁÖÕ','1986-04-02',''),(56,'master','e7ec023708aa90141dc527b2fa646d0c','',NULL,'0000-00-00',0,'','','0000-00-00',''),(52,'maxn','3049a1f0f1c808cdaa4fbed0e01649b1','8105da76a0832ae633aa762281aae482',1315952388,'0000-00-00',0,'','','0000-00-00',''),(48,'amandrika','805fb0867d69709a510fecdf0b43903d','176476594a9115270307097386c8ab5c',1503832489,'0000-00-00',0,'','','0000-00-00',''),(59,'spookydp','be8e48811d25c9a5c84498edf7f9a902','c2666178d3153f6bdd58d8642c6c0de2',NULL,'0000-00-00',0,'','','0000-00-00',''),(60,'sensor','b32e6cc352849f564e00f95ce7a81814','f32776c4b472340e69608ad912a718e5',1540830342,'0000-00-00',0,'','','0000-00-00',''),(80,'Caramba','276d6fdad2bda894cc3d99dc4cd12f78','',NULL,'0000-00-00',0,'','','0000-00-00','');


