--
-- Host: localhost    Database: mysql
-- ------------------------------------------------------


--
-- Table structure for table `columns_priv`
--

CREATE TABLE `columns_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';

--
-- Dumping data for table `columns_priv`
--


--
-- Table structure for table `db`
--

CREATE TABLE `db` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`Db`,`User`),
  KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';

--
-- Dumping data for table `db`
--

INSERT INTO `db` VALUES ('localhost','phpmyadmin','phpmyadmin','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `execute_at` datetime DEFAULT NULL,
  `interval_value` int(11) DEFAULT NULL,
  `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_executed` datetime DEFAULT NULL,
  `starts` datetime DEFAULT NULL,
  `ends` datetime DEFAULT NULL,
  `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
  `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `originator` int(10) unsigned NOT NULL,
  `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';

--
-- Dumping data for table `event`
--


--
-- Table structure for table `func`
--

CREATE TABLE `func` (
  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ret` tinyint(1) NOT NULL DEFAULT '0',
  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';

--
-- Dumping data for table `func`
--


--
-- Table structure for table `help_category`
--

CREATE TABLE `help_category` (
  `help_category_id` smallint(5) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `parent_category_id` smallint(5) unsigned DEFAULT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories';

--
-- Dumping data for table `help_category`
--

INSERT INTO `help_category` VALUES (1,'Geographic',0,''),(2,'Polygon properties',35,''),(3,'Numeric Functions',39,''),(4,'WKT',35,''),(5,'Plugins',36,''),(6,'Control flow functions',39,''),(7,'MBR',35,''),(8,'Transactions',36,''),(9,'Help Metadata',36,''),(10,'Account Management',36,''),(11,'Point properties',35,''),(12,'Encryption Functions',39,''),(13,'LineString properties',35,''),(14,'Miscellaneous Functions',39,''),(15,'Logical operators',39,''),(16,'Functions and Modifiers for Use with GROUP BY',36,''),(17,'Information Functions',39,''),(18,'Storage Engines',36,''),(19,'Bit Functions',39,''),(20,'Comparison operators',39,''),(21,'Table Maintenance',36,''),(22,'User-Defined Functions',36,''),(23,'Data Types',36,''),(24,'Compound Statements',36,''),(25,'Geometry constructors',35,''),(26,'GeometryCollection properties',1,''),(27,'Administration',36,''),(28,'Data Manipulation',36,''),(29,'Utility',36,''),(30,'Language Structure',36,''),(31,'Geometry relations',35,''),(32,'Date and Time Functions',39,''),(33,'WKB',35,''),(34,'Procedures',36,''),(35,'Geographic Features',36,''),(36,'Contents',0,''),(37,'Geometry properties',35,''),(38,'String Functions',39,''),(39,'Functions',36,''),(40,'Data Definition',36,'');

--
-- Table structure for table `help_keyword`
--

CREATE TABLE `help_keyword` (
  `help_keyword_id` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  PRIMARY KEY (`help_keyword_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords';

--
-- Dumping data for table `help_keyword`
--



--
-- Table structure for table `help_relation`
--

CREATE TABLE `help_relation` (
  `help_topic_id` int(10) unsigned NOT NULL,
  `help_keyword_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation';

--
-- Dumping data for table `help_relation`
--

INSERT INTO `help_relation` VALUES (1,0),(356,0),(476,1),(450,2),(4,3),(5,4),(90,5),(90,6),(407,6),(98,7),(185,8),(431,9),(436,10),(146,11),(18,12),(107,12),(135,12),(346,12),(381,13),(123,14),(170,14),(425,14),(377,15),(83,16),(27,17),(105,18),(199,19),(37,20),(346,21),(471,21),(377,22),(32,23),(36,24),(238,24),(436,24),(37,25),(356,25),(471,26),(503,27),(41,28),(377,29),(361,30),(50,31),(471,31),(475,31),(1,32),(90,32),(407,32),(475,32),(176,33),(471,33),(53,34),(107,34),(1,35),(57,35),(194,35),(193,36),(199,36),(250,36),(210,37),(466,37),(356,38),(199,39),(194,40),(471,41),(450,42),(40,43),(230,43),(270,43),(90,44),(407,44),(377,45),(84,46),(105,46),(356,46),(475,46),(90,47),(407,47),(3,48),(105,48),(305,48),(356,48),(92,49),(130,50),(146,51),(436,51),(463,51),(100,52),(188,52),(422,53),(466,53),(402,54),(471,54),(29,55),(59,55),(86,55),(283,56),(346,56),(107,57),(314,57),(377,58),(110,59),(24,60),(89,60),(114,61),(174,61),(375,62),(462,62),(124,63),(125,64),(90,65),(126,65),(407,65),(499,65),(133,66),(230,66),(263,66),(377,66),(210,67),(466,67),(471,67),(90,68),(194,68),(210,68),(407,68),(471,68),(185,69),(185,70),(315,71),(199,72),(286,73),(199,74),(250,74),(466,75),(59,76),(86,76),(143,77),(144,78),(50,79),(123,79),(346,79),(356,79),(425,79),(458,79),(148,80),(1,81),(29,82),(471,83),(209,84),(180,85),(314,85),(346,85),(356,85),(421,85),(329,86),(346,86),(98,87),(180,88),(422,89),(98,90),(346,91),(422,91),(176,92),(177,93),(194,94),(416,94),(466,94),(481,94),(181,95),(131,96),(422,96),(187,97),(190,98),(50,99),(84,99),(356,99),(361,99),(466,99),(1,100),(50,100),(87,100),(253,101),(199,102),(250,102),(203,103),(213,104),(413,105),(466,106),(471,106),(475,106),(476,106),(102,107),(151,107),(305,107),(375,108),(462,108),(160,109),(346,109),(458,110),(375,111),(462,111),(230,112),(378,112),(471,113),(396,114),(240,115),(356,116),(422,117),(199,118),(245,119),(146,120),(250,121),(256,122),(422,123),(471,123),(356,124),(3,125),(37,125),(50,125),(84,125),(105,125),(131,125),(422,125),(199,126),(194,127),(155,128),(186,128),(212,128),(310,128),(346,128),(273,129),(280,130),(467,131),(426,132),(256,133),(469,133),(1,134),(7,135),(346,135),(259,136),(431,136),(49,137),(194,137),(226,137),(231,137),(356,137),(428,138),(287,139),(185,140),(293,141),(298,142),(476,143),(386,144),(131,145),(155,145),(212,145),(259,145),(332,145),(346,145),(356,145),(422,145),(431,145),(471,145),(375,146),(462,146),(65,147),(111,147),(116,147),(215,147),(277,147),(279,147),(321,147),(346,147),(402,147),(418,147),(466,147),(469,147),(471,147),(473,147),(31,148),(277,148),(471,148),(475,148),(185,149),(293,150),(311,151),(466,152),(89,153),(185,154),(356,155),(317,156),(421,157),(320,158),(247,159),(146,160),(151,161),(326,161),(17,162),(22,162),(49,162),(65,162),(78,162),(90,162),(98,162),(155,162),(194,162),(210,162),(211,162),(279,162),(303,162),(310,162),(346,162),(358,162),(394,162),(457,162),(471,162),(476,162),(256,163),(346,164),(454,164),(466,165),(379,166),(471,167),(108,168),(337,169),(418,170),(343,171),(259,172),(270,173),(39,174),(199,174),(250,174),(306,174),(356,174),(471,175),(326,176),(471,177),(29,178),(59,178),(86,178),(233,178),(327,178),(343,178),(436,178),(499,178),(377,179),(315,180),(107,181),(354,182),(359,183),(78,184),(131,184),(199,184),(362,185),(185,186),(182,187),(458,188),(377,189),(466,190),(25,191),(346,191),(375,192),(185,193),(377,194),(346,195),(379,195),(292,196),(346,196),(420,196),(382,197),(384,198),(387,199),(466,200),(199,201),(356,202),(89,203),(151,203),(176,203),(401,204),(131,205),(422,205),(54,206),(324,206),(404,207),(403,208),(199,209),(146,210),(450,210),(408,211),(24,212),(1,213),(471,214),(65,215),(159,215),(199,215),(212,215),(226,215),(234,215),(374,215),(407,215),(442,215),(466,215),(481,215),(1,216),(423,217),(346,218),(348,218),(422,219),(471,220),(426,221),(230,222),(468,222),(212,223),(418,223),(90,224),(377,224),(212,225),(199,226),(471,226),(475,226),(283,227),(450,228),(90,229),(129,230),(10,231),(346,231),(31,232),(277,232),(475,232),(450,233),(58,234),(85,235),(206,235),(369,235),(459,235),(85,236),(90,236),(155,236),(206,236),(313,236),(194,237),(481,237),(189,238),(326,239),(471,240),(146,241),(324,241),(436,241),(9,242),(29,242),(31,242),(90,242),(155,242),(186,242),(277,242),(301,242),(483,242),(131,243),(270,244),(78,245),(222,245),(330,245),(476,245),(314,246),(471,247),(356,248),(3,249),(105,249),(489,249),(37,250),(436,250),(155,251),(186,251),(212,251),(310,251),(346,251),(476,251),(85,252),(369,252),(475,252),(486,253),(485,254),(469,255),(422,256),(259,257),(494,258),(212,259),(471,259),(500,260),(504,261),(199,262),(375,263),(462,263),(209,264),(471,264),(201,265),(3,266),(131,266),(422,266),(233,267),(90,268),(90,269),(407,269),(21,270),(346,270),(422,270),(466,270),(471,270),(230,271),(89,272),(356,272),(98,273),(230,273),(503,273),(3,274),(105,274),(244,274),(375,274),(462,274),(178,275),(109,276),(9,277),(31,277),(35,277),(88,277),(186,277),(231,277),(238,277),(264,277),(277,277),(301,277),(330,277),(406,277),(416,277),(417,277),(466,277),(481,277),(356,278),(185,279),(199,280),(418,281),(466,281),(471,281),(21,282),(295,282),(346,282),(454,282),(471,282),(50,283),(78,283),(84,283),(131,283),(199,283),(356,283),(361,283),(422,283),(466,283),(471,283),(471,284),(475,284),(377,285),(212,286),(422,286),(471,286),(476,286),(466,287),(471,287),(98,288),(315,288),(356,289),(47,290),(185,291),(375,292),(462,292),(375,293),(462,293),(58,294),(199,295),(50,296),(84,296),(107,296),(375,297),(462,297),(90,298),(301,298),(358,298),(407,298),(1,299),(84,299),(105,299),(131,299),(356,299),(422,299),(466,299),(199,300),(68,301),(50,302),(418,302),(469,302),(230,303),(88,304),(210,304),(466,304),(386,305),(92,306),(1,307),(185,308),(466,308),(185,309),(270,309),(463,309),(79,310),(375,311),(462,311),(259,312),(471,313),(194,314),(377,315),(97,316),(17,317),(189,317),(303,317),(328,317),(346,317),(356,317),(417,317),(442,317),(491,317),(89,318),(103,319),(286,320),(105,321),(195,321),(302,321),(489,321),(71,322),(329,322),(434,322),(476,323),(108,324),(9,325),(31,325),(90,325),(155,325),(186,325),(277,325),(301,325),(346,326),(366,326),(146,327),(436,327),(463,327),(3,328),(105,328),(155,328),(200,328),(212,328),(244,328),(466,328),(471,328),(466,329),(116,330),(326,330),(469,330),(473,330),(116,331),(466,331),(375,332),(462,332),(39,333),(120,333),(151,333),(265,333),(420,334),(221,335),(3,336),(84,336),(105,336),(130,336),(131,336),(146,336),(155,336),(182,336),(212,336),(332,336),(346,336),(356,336),(375,336),(422,336),(462,336),(466,336),(471,336),(475,336),(480,336),(497,336),(199,337),(60,338),(138,338),(215,338),(223,338),(328,338),(335,338),(346,338),(366,338),(1,339),(425,340),(471,341),(54,342),(458,343),(256,344),(59,345),(86,345),(54,346),(324,346),(238,347),(199,348),(314,349),(37,350),(107,350),(436,350),(450,350),(377,351),(471,352),(35,353),(70,353),(98,353),(211,353),(234,353),(303,353),(335,353),(346,353),(394,353),(406,353),(417,353),(253,354),(65,355),(194,355),(466,355),(481,355),(466,356),(471,356),(471,357),(168,358),(178,359),(183,360),(31,361),(159,361),(457,361),(450,362),(198,363),(375,364),(462,364),(201,365),(24,366),(129,366),(168,366),(209,366),(230,366),(315,366),(503,366),(98,367),(156,367),(230,367),(346,368),(145,369),(346,369),(146,370),(436,370),(146,371),(436,371),(180,372),(200,372),(314,372),(421,372),(225,373),(305,374),(422,374),(356,375),(155,376),(212,376),(471,376),(468,377),(455,378),(130,379),(138,379),(182,379),(348,379),(450,379),(59,380),(86,380),(241,381),(1,382),(37,382),(356,382),(247,383),(192,384),(346,384),(1,385),(375,386),(462,386),(221,387),(89,388),(199,388),(210,388),(466,388),(471,388),(261,389),(466,390),(90,391),(407,391),(466,391),(292,392),(278,393),(98,394),(1,395),(65,395),(88,395),(102,395),(210,395),(305,395),(309,395),(346,395),(466,395),(471,395),(90,396),(407,396),(185,397),(466,398),(273,399),(88,400),(210,400),(466,400),(314,401),(24,402),(129,402),(168,402),(209,402),(315,402),(503,402),(199,403),(185,404),(185,405),(300,406),(185,407),(194,408),(346,408),(366,408),(416,408),(466,408),(471,408),(481,408),(471,409),(356,410),(306,411),(471,412),(256,413),(356,413),(361,413),(230,414),(316,414),(376,414),(89,415),(209,416),(70,417),(491,417),(325,418),(49,419),(194,419),(226,419),(231,419),(194,420),(235,421),(199,422),(90,423),(334,424),(436,425),(40,426),(270,426),(346,426),(471,427),(147,428),(466,429),(469,429),(340,430),(338,431),(3,432),(105,432),(321,433),(466,433),(7,434),(10,434),(17,434),(21,434),(25,434),(34,434),(40,434),(60,434),(70,434),(71,434),(83,434),(123,434),(135,434),(138,434),(145,434),(160,434),(170,434),(192,434),(193,434),(215,434),(223,434),(279,434),(283,434),(295,434),(309,434),(310,434),(328,434),(329,434),(332,434),(335,434),(346,434),(348,434),(358,434),(366,434),(394,434),(425,434),(454,434),(490,434),(491,434),(495,434),(123,435),(349,435),(147,436),(352,436),(377,437),(3,438),(105,438),(256,438),(302,438),(356,438),(160,439),(346,439),(476,440),(24,441),(112,441),(185,442),(131,443),(422,443),(119,444),(391,444),(374,445),(476,445),(199,446),(146,447),(436,447),(199,448),(89,449),(123,449),(356,449),(425,449),(356,450),(396,451),(87,452),(199,452),(398,453),(185,454),(9,455),(374,455),(476,455),(124,456),(185,457),(377,458),(377,459),(466,460),(144,461),(210,462),(466,462),(471,462),(111,463),(222,463),(407,463),(466,463),(413,464),(476,465),(1,466),(356,466),(428,467),(78,468),(199,468),(476,468),(480,468),(356,469),(107,470),(277,471),(497,472),(71,473),(346,473),(433,474),(356,475),(450,476),(437,477),(471,478),(146,479),(327,479),(436,479),(436,480),(490,481),(439,482),(418,483),(199,484),(377,485),(446,486),(109,487),(451,488),(455,489),(456,490),(462,491),(34,492),(463,493),(466,494),(107,495),(309,496),(346,496),(466,496),(467,497),(50,498),(84,498),(107,498),(123,498),(356,498),(425,498),(65,499),(105,499),(466,499),(471,499),(475,499),(233,500),(375,501),(462,501),(466,502),(473,502),(466,503),(471,503),(244,504),(471,504),(471,505),(475,505),(194,506),(481,506),(130,507),(138,507),(348,507),(450,507),(39,508),(54,508),(90,508),(145,508),(223,508),(324,508),(407,508),(356,509),(361,509),(90,510),(407,510),(466,510),(422,511),(0,512),(96,512),(289,512),(306,512),(356,512),(361,512),(385,512),(434,512),(37,513),(116,513),(131,513),(326,513),(422,513),(469,513),(473,513),(499,514),(199,515),(185,516),(199,517),(37,518),(135,518),(295,518),(346,518),(498,519),(28,520),(22,521),(264,521),(346,521),(105,522),(356,522),(346,523),(495,523),(210,524),(466,525),(107,526),(466,526),(471,526),(194,527),(481,527),(40,528),(60,528),(185,528),(265,528),(270,528),(471,529);

--
-- Table structure for table `help_topic`
--

CREATE TABLE `help_topic` (
  `help_topic_id` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `help_category_id` smallint(5) unsigned NOT NULL,
  `description` text NOT NULL,
  `example` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_topic_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics';

--
-- Dumping data for table `help_topic`
--



--
-- Table structure for table `host`
--

CREATE TABLE `host` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`Db`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges;  Merged with database privileges';

--
-- Dumping data for table `host`
--


--
-- Table structure for table `ndb_binlog_index`
--

CREATE TABLE `ndb_binlog_index` (
  `Position` bigint(20) unsigned NOT NULL,
  `File` varchar(255) NOT NULL,
  `epoch` bigint(20) unsigned NOT NULL,
  `inserts` bigint(20) unsigned NOT NULL,
  `updates` bigint(20) unsigned NOT NULL,
  `deletes` bigint(20) unsigned NOT NULL,
  `schemaops` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`epoch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ndb_binlog_index`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--


--
-- Table structure for table `proc`
--

CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';

--
-- Dumping data for table `proc`
--


--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'','2015-09-10 11:03:57'),('websrv','root','','',1,'','2015-09-10 11:03:57');

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--


--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT '0',
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin DEFAULT '',
  `authentication_string` text COLLATE utf8_bin,
  PRIMARY KEY (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','root','*F0D4E4D50F56CF28816118AE3706ECED0A07DA37','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('websrv','root','*F0D4E4D50F56CF28816118AE3706ECED0A07DA37','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('127.0.0.1','root','*F0D4E4D50F56CF28816118AE3706ECED0A07DA37','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('::1','root','*F0D4E4D50F56CF28816118AE3706ECED0A07DA37','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('localhost','debian-sys-maint','*F2AEF2DBA18B44F1DE121A2D1DB07F268A2865E4','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL),('localhost','phpmyadmin','*F0D4E4D50F56CF28816118AE3706ECED0A07DA37','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',NULL);

--
-- Dumping events for database 'mysql'
--

--
-- Dumping routines for database 'mysql'
--

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `thread_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `query_time` time NOT NULL,
  `lock_time` time NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';


