One Hat Cyber Team

View File Name : hk.sql

-- MySQL dump 10.13  Distrib 5.1.46, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: hk2010
-- ------------------------------------------------------
-- Server version	5.1.46

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `participants`
--

DROP TABLE IF EXISTS `participants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `participants` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `last_name` varchar(50) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `humboldt` enum('Y','N') DEFAULT NULL,
  `degree` enum('S','D','P') DEFAULT NULL,
  `year_birth` varchar(10) DEFAULT NULL,
  `year_degree` varchar(10) DEFAULT NULL,
  `affiliation` varchar(256) DEFAULT NULL,
  `title` varchar(256) DEFAULT NULL,
  `presentation` enum('O','P') DEFAULT NULL,
  `abstract_pdf` varchar(50) DEFAULT NULL,
  `abstract_tex` varchar(50) NOT NULL,
  `country` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `address` varchar(256) DEFAULT NULL,
  `mail` varchar(256) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `hotel` enum('Y','N') DEFAULT NULL,
  `young` enum('Y','N') DEFAULT NULL,
  `date` date NOT NULL,
  `date_arrival` varchar(3) NOT NULL,
  `date_departure` varchar(3) NOT NULL,
  `print` enum('Y','N','B') DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `participants`
--

LOCK TABLES `participants` WRITE;
/*!40000 ALTER TABLE `participants` DISABLE KEYS */;
INSERT INTO `participants` VALUES (100,'Drozd-Koroleva ','Olena  ','N','P','','','T. Shevchenko National University of Kyiv','TBA','O',NULL,'','Ukraine','Kyiv','','','','','N','Y','2010-06-04','','','Y'),(96,'Anulova','Svetlana ','Y','P','','','Institute for Control Science,\r\nRussian Academy of Sciences','TBA','O',NULL,'','Russia','Moscow','','117806, Moscow, Russia','anulovas@ipu.rssi.ru','','N','','2010-06-04','','','Y'),(97,'Boi ','Luciano ','Y','P','','','Ecole des Hautes Etudes \r\nen Sciences Sociales,\r\nCentre de MathÐµmatiques','When Mathematics Meet Life: the interface between topological plasticity and biological complexity','O',NULL,'','France','Paris','','75006, France, Paris, boulevard Raspail, 54','boi@ehess.fr','','N','N','2010-06-04','','','Y'),(98,'Clark ','Timothy  ','N','P','','','Computer-Chemie-Centrum, \r\nFriedrich-Alexander-UniversitÃ¤t ','Molecular-Dynamics Simulations on signal transduction','O',NULL,'','Germany','Erlangen-NÃ¼rnberg','','','','','N','N','2010-06-04','','','Y'),(99,'Donec','Pavel ','Y','P','','','V.N. Karazin Kharkiv National University','TBA','O',NULL,'','Ukraine','Kharkiv','','','donec@ic.kharkov.ua','','N','','2010-06-04','','','Y'),(92,'Tesko','Volodymyr','N','D','1978','2005','Institute of Mathematics, National Academy of Sciences of Ukraine','TBA','P',NULL,'','Ukraine','Kyiv','','01601, Ukraine, Kiev-4, \r\nTereschenkivska 3','tesko@imath.kiev.ua','','N','Y','2010-06-03','','','Y'),(93,'Hryniv','Rostyslav','Y','P','','','Pidstryhach Institute for Applied Problems of Mechanics and Mathematics,\r\nNational Academy of Sciences of Ukraine','TBA','O',NULL,'','Ukraine','Lviv','','79060, Ukraine,Lviv, Naukova Str. 3-b','rhryniv@iapmm.lviv.ua','','','','2010-06-03','','','Y'),(86,'Borisjuk','Nikolai','Y','P','','','Biotechnology Foundation Laboratories,\r\nThomas Jefferson University','TBA','O',NULL,'','USA','Philadelphia','','PA 19107, USA, Philadelphia, 1020 Locust St., room 473 ','mykola.borysyuk@jefferson.edu','','N','','2010-06-01','','','Y'),(88,'Rassamakin','Yuri','Y','P','','','Institute of Archaeology,\r\nNational Academy of Sciencies of Ukraine','TBA','O',NULL,'','Ukraine','Kyiv','','04210, Ukraine, Kyiv-210, pr. Geroiv Stalingrada 12\r\n\r\n','rasyuri@yahoo.com','','N','N','2010-06-01','','','Y'),(87,'Nesenenko','Sergiy','Y','P','','','Universite de Paris VI (Pierre et Marie Curie)','Homogenization of Viscoplastic Models of Monotone Type with Positive Semi-Definite Free Energy','O',NULL,'','France','Paris','','','nesenenko@mathematik.tu-darmstadt.de','','N','','2010-06-01','','','Y'),(102,'Bazyka','Dmitro ','N','P','','','Scientific Center of Radiation Medicine,\r\nAMS of Ukraine','TBA','O',NULL,'','Ukraine','Kyiv','','','bazyka@yahoo.com','','','N','2010-06-04','','','Y'),(89,'Urusov','Mikhail','Y','P','','','University of Ulm,\r\nInstitute of Mathematical Finance','On the Martingale Property of Certain Local Martingales','O','89.pdf','89.tex','Germany','Ulm','','89069, Germany, Ulm, HelmholtzstraÃŸe 18\r\n','mikhail.urusov@uni-ulm.de','','N','Y','2010-06-01','5','8','Y'),(90,'Zhariy','Mariya','N','P','','','Johann Radon Institute for Computational and Applied Mathematics (RICAM),\r\nAustrian Academy of Sciences','TBA','O',NULL,'','Austria','Linz','','Austria, A-4040 Linz, AltenbergerstraÃŸe 69','mariya.zhariy@oeaw.ac.at','','N','Y','2010-06-01','','','Y'),(103,'Krishtal','Oleg  ','N','P','','','Bogomoletz Institute of Physiology','How the pain starts','O',NULL,'','Ukraine','Kyiv','','','krishtal@biph.kiev.ua','','N','N','2010-06-04','','','Y'),(101,'Gaiday','Alexander ','N','P','','','National Technical University of Ukraine \r\n&#039;Kyiv Polytechnic Institute&#039;','Computational and Experimental studies of new cage compounds â€“ potential antiviral drugs','O',NULL,'','Ukraine','Kyiv','','','','','N','Y','2010-06-04','','','Y'),(104,'Kukush','Alexander','N','P','','','T. Shevchenko National University of Kyiv','TBA','O',NULL,'','Ukraine','Kyiv','','','','','N','N','2010-06-04','','','Y'),(105,'Xue-Mei','Li','Y','P','','','University of Warwick','TBA','O',NULL,'','UK','Warwick','','','xuemei@xuemei.org','','','','2010-06-04','','','Y'),(106,'Maistrenko ','Yurii','N','P','','','Institute of Mathematics,\r\nNational Academy of Sciencies of Ukraine,\r\nForschungszentrum Juelich','TBA','O',NULL,'','Ukraine-Germany','Kyiv-Juelich','','','y.maistrenko@fz-juelich.de','','N','N','2010-06-04','','','Y'),(107,'Mansmann','Ulrich','Y','P','','','Institut fÃ¼r medizinische Informationsverarbeitung, Biometrie und Epidemiologie,\r\nLudwig-Maximilians-UniversitÃ¤t','TBA','O',NULL,'','Germany','MÃ¼nchen','','','','','','','2010-06-04','','','Y'),(108,'Komarov','Igor ','Y','P','','','T. Shevchenko National University of Kyiv','Exploring chemical space for the need of medicinal chemistry - theory and practice','O',NULL,'','Ukraine','Kyiv','','','ik214@yahoo.com','','','','2010-06-04','','','Y'),(109,'Kondratyev','Vladimir','Y','P','','','T. Shevchenko National University of Kyiv','TBA','O',NULL,'','Ukraine','Kyiv','','','vkondra@univ.kiev.ua','','N','','2010-06-04','','','Y'),(110,'Kriukova','Galyna','N','S','','','T. Shevchenko National University of Kyiv','TBA','O',NULL,'','Ukraine','Kyiv','','03127, Ukraine, Kyiv, Academician Glushkov prospectus, 2, building 7','galyna.kriukova@gmail.com','','','Y','2010-06-04','','','Y'),(111,'Levandovskiy','Igor','N','P','','','National Technical University of Ukraine \r\n&#039;Kyiv Polytechnic Institute&#039;','TBA','O',NULL,'','Ukraine','Kyiv','','','','','','Y','2010-06-04','','','Y'),(112,'Lushchyk','Ulyana','N','P','','','Clinical hospital â€œFeofaniaâ€, \r\nState Administration of the Presidentâ€™s Affairs of Ukraine','Modern Models of the Living Organismâ€™s Functioning at Normal and Pathological Conditions','O',NULL,'','Ukraine','Kyiv','','','inna_istyna@mail.ru','','','N','2010-06-04','','','Y'),(113,'Novytskyy ','Viktor','N','P','','','Institute of Mathematics,\r\nNational Academy of Sciencies of Ukraine','Ð Mathematical Modeling Process in Applied Hydro- and Hemodynamics','O',NULL,'','Ukraine','Kyiv','','','novyc@imath.kiev.ua','','','','2010-06-04','','','Y'),(114,'Omelchenko','Oleh','Y','P','','','Humboldt-UniversitÃ¤t','TBA','O',NULL,'','Germany','Berlin','','','omelchen@wias-berlin.de','','','','2010-06-04','','','Y'),(115,'Ovsienko','Sergei','Y','P','','','T. Shevchenko National University of Kyiv','TBA','O',NULL,'','Ukraine','Kyiv','','','ovsiyenko.sergiy@gmail.com','','','','2010-06-04','','','Y'),(116,'Ryabucha ','Tatiana ','N','P','','','Institute of Mathematics,\r\nNational Academy of Sciencies of Ukraine','TBA','O',NULL,'','Ukraine','Kyiv','','01601 Ukraine, Kiev-4, Tereschenkivska st. 3','vyrtum@bigmir.net','','','Y','2010-06-04','','','Y'),(117,'Shubina','Tatyana','Y','P','','','Computer-Chemie-Centrum, Friedrich-Alexander-UniversitÃ¤t ','Computational Chemistry - the bridge between math, \r\nchemistry and medicine','O',NULL,'','Germany','Erlangen','','','tatyana.shubina@chemie.uni-erlangen.de','','','','2010-06-04','','','Y'),(118,'Sibgatulin','Dmitry','N','P','','','Institute of Organic Chemistry, \r\nNational Academy of Sciencies of Ukraine','TBA','O',NULL,'','Ukraine','Kyiv','','','','','','Y','2010-06-04','','','Y'),(119,'Skok','Maryna','Y','P','','','Palladin Institute of Biochemistry,\r\nNational Academy of Sciences of Ukraine','Nicotinic Acetylcholine Receptors: Universal Role and Medical Significance','O','119.pdf','119.doc','Ukraine','Kyiv','','01601 Ukraine, Kyiv, Leontovicha str., 9','skok@biochem.kiev.ua','','','','2010-06-04','','','Y'),(120,'Torbin ','Gregory','Y','P','','','Institute of Mathematics,\r\nNational Academy of Sciencies of Ukraine','TBA','O',NULL,'','Ukraine','Kyiv','','','torbin7@googlemail.com','','','','2010-06-04','','','Y'),(121,'van Eldik ','Rudi ','Y','P','','','Friedrich-Alexander-UniversitÃ¤t','Recent advances in the understanding of inorganic/bioinorganic reaction mechanisms','O',NULL,'','Germany','Erlangen-NÃ¼rnberg','','','','','','','2010-06-04','','','Y'),(122,'Zharii ','Oleg','Y','P','','','','TBA','O',NULL,'','Ukraine','Kyiv','','','zharii@incomstrakh.com.ua','','','','2010-06-04','','','Y'),(123,'Goriunov','Andrii','N','S','1984','','Institute of Mathematics,\r\nNational Academy of Sciencies of Ukraine','TBA ','P',NULL,'','Ukraine','Kyiv','','01601 Ukraine, Kiev-4, Tereschenkivska st. 3','goriunov@imath.kiev.ua','','N','Y','2010-06-04','','','N'),(126,'Usatenko','Zoryana','Y','D','','2007','Institute for Condensed Matter Physics','Statistical mechanics of real polymer chains','P','126.pdf','126.tex','Ukraine','Lviv','','79011, Ukraine, Lviv, 1 Svientsitskii str. ','zz_usatenko@ph.icmp.lviv.ua','','Y','','2010-06-06','5','8','Y'),(127,'Odoulov','Sergij','Y','P','','','Institute of Physics\r\nNational Acedemy of sciences','N. N.','P',NULL,'','Ukraine','Kyiv','','46 prospekt Nauky, \r\n03 650 Kyiv\r\nUkraine','odoulov@iop.kiev.ua','525 23 69','N','','2010-06-06','','','Y'),(128,'Dzhagan','Volodymyr','Y','D','','2005','Institute of Semiconductor Physics, National Academy of Sciences of Ukraine','TBA','P',NULL,'','Ukraine','Kyiv','','03028, Ukraine, Kyiv, prospekt Nauky, 45\r\n','dzhagan@isp.kiev.ua','','N','','2010-06-07','','','Y'),(129,'Skok','Maryna','Y','P','','','Palladin Institute of Biochemistry, National Academy of Sciences of Ukraine','Nicotinic Acetylcholine Receptors: Universal Role and Medical Significance','O',NULL,'129.doc','Ukraine','Kyiv','','01601 Ukraine, Kyiv, Leontovicha str., 9','skok@biochem.kiev.ua','','N','','2010-06-08','','','N'),(130,'Skok','Maryna','Y','P','','','Palladin Institute of Biochemistry, National Academy of Sciences of Ukraine','Nicotinic Acetylcholine Receptors: Universal Role and Medical Significance','O',NULL,'130.doc','Ukraine','Kyiv','','01601 Ukraine, Kyiv, Leontovicha str., 9','skok@biochem.kiev.ua','','N','','2010-06-08','','','N'),(132,'Tarkhanov','Nikolai','N','P','','','Institute of Mathematics\r\nUniversity of Potsdam\r\nGermany','Numerical Experiments for the Riemann Hypothesis','O','132.pdf','132.tex','Germany','Potsdam','','Am Neuen Palais 10\r\n14469 Potsdam\r\nGermany','tarkhanov@math.uni-potsdam.de','(0331) 977 1518','Y','N','2010-06-09','5','8','Y'),(133,'Murach','Aleksandr','N','P','','','Institute of Mathematics,\r\nNAS of Ukraine','Hormander spaces on \r\nmanifolds and their applications','O',NULL,'','Ukraine','Kyiv','','Ukraine, 01601,\r\nKyiv-4,\r\nTereshchenkivska Str., 3\r\n\r\n  ','murach@imath.kiev.ua','0462778182, 09533289','N','N','2010-06-09','','','N'),(134,'Murach','Aleksandr','N','P','','','Institute of Mathematics,\r\nNAS of Ukraine','Hormander spaces on \r\nmanifolds and their applications','O',NULL,'','Ukraine','Kyiv','','Ukraine, 01601,\r\nKyiv-4,\r\nTereshchenkivska Str., 3\r\n\r\n  ','murach@imath.kiev.ua','0462778182, 09533289','N','N','2010-06-09','','','N'),(135,'Murach','Aleksandr','N','P','','','Institute of Mathematics,\r\nNAS of Ukraine','Hormander spaces on \r\nmanifolds and their applications','O',NULL,'','Ukraine','Kyiv','','Ukraine, 01601,\r\nKyiv-4,\r\nTereshchenkivska Str., 3\r\n\r\n  ','murach@imath.kiev.ua','0462778182, 09533289','N','N','2010-06-09','','','Y'),(136,'Shramko','Yaroslav','Y','P','','','Kryvyi Rih State Pedagogical University','Truth as a mathematical object','O',NULL,'','Ukraine','Kryvyi Rih','','50086\r\nUkraine\r\nKryvyi Rih\r\nState Pedagogical University','yshramko@ukrpost.ua','','Y','','2010-06-10','5','8','Y'),(137,'Bannikova','Svitlana','N','D','','1988','Kyiv National University of Economics and Trade','Network as a service and mobile Cloud Computing','P',NULL,'','Ukraine','Kyiv','','01015 Kiev,Leipzigskaja Str.2/37, Ap.40.','svit.bannikova@gmail.com','044-2889375','N','N','2010-06-12','','','Y'),(138,'antonjuk','a','Y','S','','','fds','sfd','O',NULL,'','a','a','','a','antonjuk@triolan.ua','','N','','2010-06-14','','','N');
/*!40000 ALTER TABLE `participants` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) DEFAULT NULL,
  `pass` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','hk2010666');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-06-14 11:32:58