-- MySQL dump 10.9
--
-- Host: localhost    Database: campsite
-- ------------------------------------------------------
-- Server version	4.1.15-Debian_1ubuntu5-log

/*!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 */;
/*!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 `Aliases`
--

DROP TABLE IF EXISTS `Aliases`;
CREATE TABLE `Aliases` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` char(128) NOT NULL default '',
  `IdPublication` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Aliases`
--


/*!40000 ALTER TABLE `Aliases` DISABLE KEYS */;
LOCK TABLES `Aliases` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Aliases` ENABLE KEYS */;

--
-- Table structure for table `ArticleAttachments`
--

DROP TABLE IF EXISTS `ArticleAttachments`;
CREATE TABLE `ArticleAttachments` (
  `fk_article_number` int(10) unsigned NOT NULL default '0',
  `fk_attachment_id` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `article_attachment_index` (`fk_article_number`,`fk_attachment_id`),
  KEY `fk_article_number` (`fk_article_number`),
  KEY `fk_attachment_id` (`fk_attachment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleAttachments`
--


/*!40000 ALTER TABLE `ArticleAttachments` DISABLE KEYS */;
LOCK TABLES `ArticleAttachments` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleAttachments` ENABLE KEYS */;

--
-- Table structure for table `ArticleComments`
--

DROP TABLE IF EXISTS `ArticleComments`;
CREATE TABLE `ArticleComments` (
  `fk_article_number` int(10) unsigned NOT NULL default '0',
  `fk_language_id` int(10) unsigned NOT NULL default '0',
  `fk_comment_id` int(10) unsigned NOT NULL default '0',
  `is_first` tinyint(1) NOT NULL default '0',
  KEY `fk_comment_id` (`fk_comment_id`),
  KEY `article_index` (`fk_article_number`,`fk_language_id`),
  KEY `first_message_index` (`fk_article_number`,`fk_language_id`,`is_first`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleComments`
--


/*!40000 ALTER TABLE `ArticleComments` DISABLE KEYS */;
LOCK TABLES `ArticleComments` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleComments` ENABLE KEYS */;

--
-- Table structure for table `ArticleImages`
--

DROP TABLE IF EXISTS `ArticleImages`;
CREATE TABLE `ArticleImages` (
  `NrArticle` int(10) unsigned NOT NULL default '0',
  `IdImage` int(10) unsigned NOT NULL default '0',
  `Number` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`NrArticle`,`IdImage`),
  UNIQUE KEY `ArticleImage` (`NrArticle`,`Number`),
  KEY `IdImage` (`IdImage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleImages`
--


/*!40000 ALTER TABLE `ArticleImages` DISABLE KEYS */;
LOCK TABLES `ArticleImages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleImages` ENABLE KEYS */;

--
-- Table structure for table `ArticleIndex`
--

DROP TABLE IF EXISTS `ArticleIndex`;
CREATE TABLE `ArticleIndex` (
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `IdKeyword` int(10) unsigned NOT NULL default '0',
  `NrIssue` int(10) unsigned NOT NULL default '0',
  `NrSection` int(10) unsigned NOT NULL default '0',
  `NrArticle` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`IdPublication`,`IdLanguage`,`IdKeyword`,`NrIssue`,`NrSection`,`NrArticle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleIndex`
--


/*!40000 ALTER TABLE `ArticleIndex` DISABLE KEYS */;
LOCK TABLES `ArticleIndex` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleIndex` ENABLE KEYS */;

--
-- Table structure for table `ArticlePublish`
--

DROP TABLE IF EXISTS `ArticlePublish`;
CREATE TABLE `ArticlePublish` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_article_number` int(10) unsigned NOT NULL default '0',
  `fk_language_id` int(10) unsigned NOT NULL default '0',
  `time_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_action` enum('P','U') default NULL,
  `publish_on_front_page` enum('S','R') default NULL,
  `publish_on_section_page` enum('S','R') default NULL,
  `is_completed` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `article_index` (`fk_article_number`,`fk_language_id`),
  KEY `event_time_index` (`time_action`,`is_completed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticlePublish`
--


/*!40000 ALTER TABLE `ArticlePublish` DISABLE KEYS */;
LOCK TABLES `ArticlePublish` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticlePublish` ENABLE KEYS */;

--
-- Table structure for table `ArticleTopics`
--

DROP TABLE IF EXISTS `ArticleTopics`;
CREATE TABLE `ArticleTopics` (
  `NrArticle` int(10) unsigned NOT NULL default '0',
  `TopicId` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`NrArticle`,`TopicId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleTopics`
--


/*!40000 ALTER TABLE `ArticleTopics` DISABLE KEYS */;
LOCK TABLES `ArticleTopics` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleTopics` ENABLE KEYS */;

--
-- Table structure for table `ArticleTypeMetadata`
--

DROP TABLE IF EXISTS `ArticleTypeMetadata`;
CREATE TABLE `ArticleTypeMetadata` (
  `type_name` varchar(166) NOT NULL default '',
  `field_name` varchar(166) NOT NULL default 'NULL',
  `field_weight` int(11) default NULL,
  `is_hidden` tinyint(1) NOT NULL default '0',
  `comments_enabled` tinyint(1) NOT NULL default '0',
  `fk_phrase_id` int(10) unsigned default NULL,
  `field_type` varchar(255) default NULL,
  `field_type_param` varchar(255) default NULL,
  PRIMARY KEY  (`type_name`,`field_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ArticleTypeMetadata`
--


/*!40000 ALTER TABLE `ArticleTypeMetadata` DISABLE KEYS */;
LOCK TABLES `ArticleTypeMetadata` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ArticleTypeMetadata` ENABLE KEYS */;

--
-- Table structure for table `Articles`
--

DROP TABLE IF EXISTS `Articles`;
CREATE TABLE `Articles` (
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `NrIssue` int(10) unsigned NOT NULL default '0',
  `NrSection` int(10) unsigned NOT NULL default '0',
  `Number` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Name` varchar(140) NOT NULL default '',
  `Type` varchar(70) NOT NULL default '',
  `IdUser` int(10) unsigned NOT NULL default '0',
  `OnFrontPage` enum('N','Y') NOT NULL default 'N',
  `OnSection` enum('N','Y') NOT NULL default 'N',
  `Published` enum('N','S','Y') NOT NULL default 'N',
  `PublishDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `UploadDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Keywords` varchar(255) NOT NULL default '',
  `Public` enum('N','Y') NOT NULL default 'N',
  `IsIndexed` enum('N','Y') NOT NULL default 'N',
  `LockUser` int(10) unsigned NOT NULL default '0',
  `LockTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ShortName` varchar(32) NOT NULL default '',
  `ArticleOrder` int(10) unsigned NOT NULL default '0',
  `comments_enabled` tinyint(1) NOT NULL default '0',
  `comments_locked` tinyint(1) NOT NULL default '0',
  `time_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`IdPublication`,`NrIssue`,`NrSection`,`Number`,`IdLanguage`),
  UNIQUE KEY `IdPublication` (`IdPublication`,`NrIssue`,`NrSection`,`IdLanguage`,`Name`),
  UNIQUE KEY `Number` (`Number`,`IdLanguage`),
  UNIQUE KEY `other_key` (`IdPublication`,`NrIssue`,`NrSection`,`IdLanguage`,`Number`),
  UNIQUE KEY `ShortName` (`IdPublication`,`NrIssue`,`NrSection`,`IdLanguage`,`ShortName`),
  KEY `Type` (`Type`),
  KEY `ArticleOrderIdx` (`ArticleOrder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Articles`
--


/*!40000 ALTER TABLE `Articles` DISABLE KEYS */;
LOCK TABLES `Articles` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Articles` ENABLE KEYS */;

--
-- Table structure for table `Attachments`
--

DROP TABLE IF EXISTS `Attachments`;
CREATE TABLE `Attachments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_language_id` int(10) unsigned default NULL,
  `file_name` varchar(255) default NULL,
  `extension` varchar(50) default NULL,
  `mime_type` varchar(255) default NULL,
  `content_disposition` enum('attachment') default NULL,
  `http_charset` varchar(50) default NULL,
  `size_in_bytes` bigint(20) unsigned default NULL,
  `fk_description_id` int(11) default NULL,
  `fk_user_id` int(10) unsigned default NULL,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `time_created` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Attachments`
--


/*!40000 ALTER TABLE `Attachments` DISABLE KEYS */;
LOCK TABLES `Attachments` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Attachments` ENABLE KEYS */;

--
-- Table structure for table `AutoId`
--

DROP TABLE IF EXISTS `AutoId`;
CREATE TABLE `AutoId` (
  `ArticleId` int(10) unsigned NOT NULL default '0',
  `LogTStamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `TopicId` int(10) unsigned NOT NULL default '0',
  `translation_phrase_id` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AutoId`
--


/*!40000 ALTER TABLE `AutoId` DISABLE KEYS */;
LOCK TABLES `AutoId` WRITE;
INSERT INTO `AutoId` VALUES (0,'0000-00-00 00:00:00',0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `AutoId` ENABLE KEYS */;

--
-- Table structure for table `Classes`
--

DROP TABLE IF EXISTS `Classes`;
CREATE TABLE `Classes` (
  `Id` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Name` varchar(140) NOT NULL default '',
  PRIMARY KEY  (`Id`,`IdLanguage`),
  UNIQUE KEY `IdLanguage` (`IdLanguage`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Classes`
--


/*!40000 ALTER TABLE `Classes` DISABLE KEYS */;
LOCK TABLES `Classes` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Classes` ENABLE KEYS */;

--
-- Table structure for table `Countries`
--

DROP TABLE IF EXISTS `Countries`;
CREATE TABLE `Countries` (
  `Code` char(2) NOT NULL default '',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Name` varchar(140) NOT NULL default '',
  PRIMARY KEY  (`Code`,`IdLanguage`),
  UNIQUE KEY `IdLanguage` (`IdLanguage`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Countries`
--


/*!40000 ALTER TABLE `Countries` DISABLE KEYS */;
LOCK TABLES `Countries` WRITE;
INSERT INTO `Countries` VALUES ('AR',1,'Argentina'),('AG',1,'Antigua and Barbuda'),('AQ',1,'Antarctica'),('AI',1,'Anguilla'),('AO',1,'Angola'),('AD',1,'Andorra'),('AS',1,'American Samoa'),('DZ',1,'Algeria'),('AL',1,'Albania'),('AF',1,'Afghanistan'),('AM',1,'Armenia'),('AW',1,'Aruba'),('AU',1,'Australia'),('AT',1,'Austria'),('AZ',1,'Azerbaijan'),('BS',1,'Bahamas'),('BH',1,'Bahrain'),('BD',1,'Bangladesh'),('BB',1,'Barbados'),('BY',1,'Belarus'),('BE',1,'Belgium'),('BZ',1,'Belize'),('BJ',1,'Benin'),('BM',1,'Bermuda'),('BT',1,'Bhutan'),('BO',1,'Bolivia'),('BA',1,'Bosnia and Herzegovina'),('BW',1,'Botswana'),('BV',1,'Bouvet Island'),('BR',1,'Brazil'),('IO',1,'British Indian Ocean Territory'),('BN',1,'Brunei Darussalam'),('BG',1,'Bulgaria'),('BF',1,'Burkina Faso'),('BI',1,'Burundi'),('KH',1,'Cambodia'),('CM',1,'Cameroon'),('CA',1,'Canada'),('CV',1,'Cape Verde'),('KY',1,'Cayman Islands'),('CF',1,'Central African Republic'),('TD',1,'Chad'),('CL',1,'Chile'),('CN',1,'China'),('CX',1,'Christmas Island'),('CC',1,'Cocos (Keeling) Islands'),('CO',1,'Colombia'),('KM',1,'Comoros'),('CG',1,'Congo'),('CD',1,'Congo, The Democratic Republic Of The'),('CK',1,'Cook Islands'),('CR',1,'Costa Rica'),('CI',1,'CÃ´te d\'Ivoire'),('HR',1,'Croatia'),('CU',1,'Cuba'),('CY',1,'Cyprus'),('CZ',1,'Czech Republic'),('DK',1,'Denmark'),('DJ',1,'Djibouti'),('DM',1,'Dominica'),('DO',1,'Dominican Republic'),('TP',1,'Timor-Leste'),('EC',1,'Ecuador'),('EG',1,'Egypt'),('SV',1,'El Salvador'),('GQ',1,'Equatorial Guinea'),('ER',1,'Eritrea'),('EE',1,'Estonia'),('ET',1,'Ethiopia'),('FK',1,'Falkland Islands (Malvinas)'),('FO',1,'Faroe Islands'),('FJ',1,'Fiji'),('FI',1,'Finland'),('FR',1,'France'),('FX',1,'France, Metropolitan'),('GF',1,'French Guiana'),('PF',1,'French Polynesia'),('TF',1,'French Southern Territories'),('GA',1,'Gabon'),('GM',1,'Gambia'),('GE',1,'Georgia'),('DE',1,'Germany'),('GH',1,'Ghana'),('GI',1,'Gibraltar'),('GR',1,'Greece'),('GL',1,'Greenland'),('GD',1,'Grenada'),('GP',1,'Guadeloupe'),('GU',1,'Guam'),('GT',1,'Guatemala'),('GN',1,'Guinea'),('GW',1,'Guinea-bissau'),('GY',1,'Guyana'),('HT',1,'Haiti'),('HM',1,'Heard Island and Mcdonald Islands'),('VA',1,'Holy See (Vatican City State)'),('HN',1,'Honduras'),('HK',1,'Hong Kong'),('HU',1,'Hungary'),('IS',1,'Iceland'),('IN',1,'India'),('ID',1,'Indonesia'),('IR',1,'Iran, Islamic Republic of'),('IQ',1,'Iraq'),('IE',1,'Ireland'),('IL',1,'Israel'),('IT',1,'Italy'),('JM',1,'Jamaica'),('JP',1,'Japan'),('JO',1,'Jordan'),('KZ',1,'Kazakstan'),('KE',1,'Kenya'),('KI',1,'Kiribati'),('KP',1,'Korea, Democratic Peoples Republic of'),('KR',1,'Korea, Republic of'),('KW',1,'Kuwait'),('KG',1,'Kyrgyzstan'),('LA',1,'Lao People\'s Democratic Republic'),('LV',1,'Latvia'),('LB',1,'Lebanon'),('LS',1,'Lesotho'),('LR',1,'Liberia'),('LY',1,'Libyan Arab Jamahiriya'),('LI',1,'Liechtenstein'),('LT',1,'Lithuania'),('LU',1,'Luxembourg'),('MO',1,'Macau'),('MK',1,'Macedonia, The Former Yugoslav Republic of'),('MG',1,'Madagascar'),('MW',1,'Malawi'),('MY',1,'Malaysia'),('MV',1,'Maldives'),('ML',1,'Mali'),('MT',1,'Malta'),('MH',1,'Marshall Islands'),('MQ',1,'Martinique'),('MR',1,'Mauritania'),('MU',1,'Mauritius'),('YT',1,'Mayotte'),('MX',1,'Mexico'),('FM',1,'Micronesia, Federated States of'),('MD',1,'Moldova, Republic of'),('MC',1,'Monaco'),('MN',1,'Mongolia'),('MS',1,'Montserrat'),('MA',1,'Morocco'),('MZ',1,'Mozambique'),('MM',1,'Myanmar'),('NA',1,'Namibia'),('NR',1,'Nauru'),('NP',1,'Nepal'),('NL',1,'Netherlands'),('AN',1,'Netherlands Antilles'),('NC',1,'New Caledonia'),('NZ',1,'New Zealand'),('NI',1,'Nicaragua'),('NE',1,'Niger'),('NG',1,'Nigeria'),('NU',1,'Niue'),('NF',1,'Norfolk Island'),('MP',1,'Northern Mariana Islands'),('NO',1,'Norway'),('OM',1,'Oman'),('PK',1,'Pakistan'),('PW',1,'Palau'),('PS',1,'Palestinian Territory, Occupied'),('PA',1,'Panama'),('PG',1,'Papua New Guinea'),('PY',1,'Paraguay'),('PE',1,'Peru'),('PH',1,'Philippines'),('PN',1,'Pitcairn'),('PL',1,'Poland'),('PT',1,'Portugal'),('PR',1,'Puerto Rico'),('QA',1,'Qatar'),('RE',1,'RÃ©union'),('RO',1,'Romania'),('RU',1,'Russian Federation'),('RW',1,'Rwanda'),('SH',1,'Saint Helena'),('KN',1,'Saint Kitts and Nevis'),('LC',1,'Saint Lucia'),('PM',1,'Saint Pierre and Miquelon'),('VC',1,'Saint Vincent and The Grenadines'),('WS',1,'Samoa'),('SM',1,'San Marino'),('ST',1,'Sao Tome and Principe'),('SA',1,'Saudi Arabia'),('SN',1,'Senegal'),('SX',1,'Serbia'),('MB',1,'Montenegro'),('SC',1,'Seychelles'),('SL',1,'Sierra Leone'),('SG',1,'Singapore'),('SK',1,'Slovakia'),('SI',1,'Slovenia'),('SB',1,'Solomon Islands'),('SO',1,'Somalia'),('ZA',1,'South Africa'),('GS',1,'South Georgia and The South Sandwich Islands'),('ES',1,'Spain'),('LK',1,'Sri Lanka'),('SD',1,'Sudan'),('SR',1,'Suriname'),('SJ',1,'Svalbard and Jan Mayen'),('SZ',1,'Swaziland'),('SE',1,'Sweden'),('CH',1,'Switzerland'),('SY',1,'Syrian Arab Republic'),('TW',1,'Taiwan, Province Of China'),('TJ',1,'Tajikistan'),('TZ',1,'Tanzania, United Republic of'),('TH',1,'Thailand'),('TG',1,'Togo'),('TK',1,'Tokelau'),('TO',1,'Tonga'),('TT',1,'Trinidad and Tobago'),('TN',1,'Tunisia'),('TR',1,'Turkey'),('TM',1,'Turkmenistan'),('TC',1,'Turks and Caicos Islands'),('TV',1,'Tuvalu'),('UG',1,'Uganda'),('UA',1,'Ukraine'),('AE',1,'United Arab Emirates'),('GB',1,'United Kingdom'),('US',1,'United States'),('UM',1,'United States Minor Outlying Islands'),('UY',1,'Uruguay'),('UZ',1,'Uzbekistan'),('VU',1,'Vanuatu'),('VE',1,'Venezuela'),('VN',1,'Vietnam'),('VG',1,'Virgin Islands, British'),('VI',1,'Virgin Islands, U.S.'),('WF',1,'Wallis And Futuna'),('EH',1,'Western Sahara'),('YE',1,'Yemen'),('ZM',1,'Zambia'),('ZW',1,'Zimbabwe'),('AX',1,'Ã…land Islands');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Countries` ENABLE KEYS */;

--
-- Table structure for table `Dictionary`
--

DROP TABLE IF EXISTS `Dictionary`;
CREATE TABLE `Dictionary` (
  `Id` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Keyword` varchar(140) NOT NULL default '',
  PRIMARY KEY  (`IdLanguage`,`Keyword`),
  UNIQUE KEY `Id` (`Id`,`IdLanguage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Dictionary`
--


/*!40000 ALTER TABLE `Dictionary` DISABLE KEYS */;
LOCK TABLES `Dictionary` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Dictionary` ENABLE KEYS */;

--
-- Table structure for table `Errors`
--

DROP TABLE IF EXISTS `Errors`;
CREATE TABLE `Errors` (
  `Number` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Message` char(255) NOT NULL default '',
  PRIMARY KEY  (`Number`,`IdLanguage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Errors`
--


/*!40000 ALTER TABLE `Errors` DISABLE KEYS */;
LOCK TABLES `Errors` WRITE;
INSERT INTO `Errors` VALUES (4000,1,'Internal error.'),(4001,1,'Username not specified.'),(4002,1,'Invalid username.'),(4003,1,'Password not specified.'),(4004,1,'Invalid password.'),(2000,1,'Internal error'),(2001,1,'Username is not specified. Please fill out login name field.'),(2002,1,'You are not a reader.'),(2003,1,'Publication not specified.'),(2004,1,'There are other subscriptions not payed.'),(2005,1,'Time unit not specified.'),(3000,1,'Internal error.'),(3001,1,'Username already exists.'),(3002,1,'Name is not specified. Please fill out name field.'),(3003,1,'Username is not specified. Please fill out login name field.'),(3004,1,'Password is not specified. Please fill out password field.'),(3005,1,'EMail is not specified. Please fill out EMail field.'),(3006,1,'EMail address already exists. Please try to login with your old account.'),(3007,1,'Invalid user identifier'),(3008,1,'No country specified. Please select a country.'),(3009,1,'Password (again) is not specified. Please fill out password (again) field.'),(3010,1,'Passwords do not match. Please fill out the same password to both password fields.'),(3011,1,'Password is too simple. Please choose a better password (at least 6 characters).'),(5009,1,'The code you entered is not the same with the one shown in the image.'),(5008,1,'Please enter the code shown in the image.'),(5007,1,'EMail field is empty. You must fill in your EMail address.'),(5006,1,'The comment was rejected by the spam filters.'),(5005,1,'You are banned from submitting comments.'),(5004,1,'Comments are not enabled for this publication/article.'),(5003,1,'The article was not selected. You must view an article in order to post comments.'),(5002,1,'The comment content was empty.'),(5001,1,'You must be a registered user in order to submit a comment. Please subscribe or log in if you already have a subscription.'),(5000,1,'There was an internal error when submitting the comment.');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Errors` ENABLE KEYS */;

--
-- Table structure for table `Events`
--

DROP TABLE IF EXISTS `Events`;
CREATE TABLE `Events` (
  `Id` int(10) unsigned NOT NULL default '0',
  `Name` varchar(140) NOT NULL default '',
  `Notify` enum('N','Y') NOT NULL default 'N',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Id`,`IdLanguage`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Events`
--


/*!40000 ALTER TABLE `Events` DISABLE KEYS */;
LOCK TABLES `Events` WRITE;
INSERT INTO `Events` VALUES (1,'Add Publication','N',1),(2,'Delete Publication','N',1),(11,'Add Issue','N',1),(12,'Delete Issue','N',1),(13,'Change Issue Template','N',1),(14,'Change issue status','N',1),(15,'Add Issue Translation','N',1),(21,'Add Section','N',1),(22,'Delete section','N',1),(31,'Add Article','Y',1),(32,'Delete article','N',1),(33,'Change article field','N',1),(34,'Change article properties','N',1),(35,'Change article status','Y',1),(41,'Add Image','Y',1),(42,'Delete image','N',1),(43,'Change image properties','N',1),(51,'Add User','N',1),(52,'Delete User','N',1),(53,'Changes Own Password','N',1),(54,'Change User Password','N',1),(55,'Change User Permissions','N',1),(56,'Change user information','N',1),(61,'Add article type','N',1),(62,'Delete article type','N',1),(71,'Add article type field','N',1),(72,'Delete article type field','N',1),(81,'Add dictionary class','N',1),(82,'Delete dictionary class','N',1),(91,'Add dictionary keyword','N',1),(92,'Delete dictionary keyword','N',1),(101,'Add language','N',1),(102,'Delete language','N',1),(103,'Modify language','N',1),(112,'Delete templates','N',1),(111,'Add templates','N',1),(121,'Add user type','N',1),(122,'Delete user type','N',1),(123,'Change user type','N',1),(3,'Change publication information','N',1),(36,'Change article template','N',1),(57,'Add IP Group','N',1),(58,'Delete IP Group','N',1),(131,'Add country','N',1),(132,'Add country translation','N',1),(133,'Change country name','N',1),(134,'Delete country','N',1),(4,'Add default subscription time','N',1),(5,'Delete default subscription time','N',1),(6,'Change default subscription time','N',1),(113,'Edit template','N',1),(114,'Create template','N',1),(115,'Duplicate template','N',1),(141,'Add topic','N',1),(142,'Delete topic','N',1),(143,'Update topic','N',1),(144,'Add topic to article','N',1),(145,'Delete topic from article','N',1),(151,'Add alias','N',1),(152,'Delete alias','N',1),(153,'Update alias','N',1),(154,'Duplicate section','N',1),(155,'Duplicate article','N',1),(161,'Sync campsite and phorum users','N',1),(171,'Change system preferences','N',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Events` ENABLE KEYS */;

--
-- Table structure for table `FailedLoginAttempts`
--

DROP TABLE IF EXISTS `FailedLoginAttempts`;
CREATE TABLE `FailedLoginAttempts` (
  `ip_address` varchar(40) NOT NULL default '',
  `time_of_attempt` bigint(20) NOT NULL default '0',
  KEY `ip_address` (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `FailedLoginAttempts`
--


/*!40000 ALTER TABLE `FailedLoginAttempts` DISABLE KEYS */;
LOCK TABLES `FailedLoginAttempts` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `FailedLoginAttempts` ENABLE KEYS */;

--
-- Table structure for table `Images`
--

DROP TABLE IF EXISTS `Images`;
CREATE TABLE `Images` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Description` varchar(255) NOT NULL default '',
  `Photographer` varchar(255) NOT NULL default '',
  `Place` varchar(255) NOT NULL default '',
  `Caption` varchar(255) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `ContentType` varchar(64) NOT NULL default '',
  `Location` enum('local','remote') NOT NULL default 'local',
  `URL` varchar(255) NOT NULL default '',
  `ThumbnailFileName` varchar(50) NOT NULL default '',
  `ImageFileName` varchar(50) NOT NULL default '',
  `UploadedByUser` int(11) default NULL,
  `LastModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `TimeCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Images`
--


/*!40000 ALTER TABLE `Images` DISABLE KEYS */;
LOCK TABLES `Images` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Images` ENABLE KEYS */;

--
-- Table structure for table `IssuePublish`
--

DROP TABLE IF EXISTS `IssuePublish`;
CREATE TABLE `IssuePublish` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_publication_id` int(10) unsigned NOT NULL default '0',
  `fk_issue_id` int(10) unsigned NOT NULL default '0',
  `fk_language_id` int(10) unsigned NOT NULL default '0',
  `time_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_action` enum('P','U') NOT NULL default 'P',
  `do_publish_articles` enum('N','Y') NOT NULL default 'Y',
  `is_completed` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `issue_index` (`fk_publication_id`,`fk_issue_id`,`fk_language_id`),
  KEY `action_time_index` (`time_action`,`is_completed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `IssuePublish`
--


/*!40000 ALTER TABLE `IssuePublish` DISABLE KEYS */;
LOCK TABLES `IssuePublish` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `IssuePublish` ENABLE KEYS */;

--
-- Table structure for table `Issues`
--

DROP TABLE IF EXISTS `Issues`;
CREATE TABLE `Issues` (
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `Number` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Name` varchar(140) NOT NULL default '',
  `PublicationDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Published` enum('N','Y') NOT NULL default 'N',
  `IssueTplId` int(10) unsigned default NULL,
  `SectionTplId` int(10) unsigned default NULL,
  `ArticleTplId` int(10) unsigned default NULL,
  `ShortName` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`IdPublication`,`Number`,`IdLanguage`),
  UNIQUE KEY `ShortName` (`IdPublication`,`IdLanguage`,`ShortName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Issues`
--


/*!40000 ALTER TABLE `Issues` DISABLE KEYS */;
LOCK TABLES `Issues` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Issues` ENABLE KEYS */;

--
-- Table structure for table `KeywordClasses`
--

DROP TABLE IF EXISTS `KeywordClasses`;
CREATE TABLE `KeywordClasses` (
  `IdDictionary` int(10) unsigned NOT NULL default '0',
  `IdClasses` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Definition` mediumblob NOT NULL,
  PRIMARY KEY  (`IdDictionary`,`IdClasses`,`IdLanguage`),
  KEY `IdClasses` (`IdClasses`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `KeywordClasses`
--


/*!40000 ALTER TABLE `KeywordClasses` DISABLE KEYS */;
LOCK TABLES `KeywordClasses` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `KeywordClasses` ENABLE KEYS */;

--
-- Table structure for table `KeywordIndex`
--

DROP TABLE IF EXISTS `KeywordIndex`;
CREATE TABLE `KeywordIndex` (
  `Keyword` varchar(70) NOT NULL default '',
  `Id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `KeywordIndex`
--


/*!40000 ALTER TABLE `KeywordIndex` DISABLE KEYS */;
LOCK TABLES `KeywordIndex` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `KeywordIndex` ENABLE KEYS */;

--
-- Table structure for table `Languages`
--

DROP TABLE IF EXISTS `Languages`;
CREATE TABLE `Languages` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(140) NOT NULL default '',
  `CodePage` varchar(140) NOT NULL default '',
  `OrigName` varchar(140) NOT NULL default '',
  `Code` varchar(21) NOT NULL default '',
  `Month1` varchar(140) NOT NULL default '',
  `Month2` varchar(140) NOT NULL default '',
  `Month3` varchar(140) NOT NULL default '',
  `Month4` varchar(140) NOT NULL default '',
  `Month5` varchar(140) NOT NULL default '',
  `Month6` varchar(140) NOT NULL default '',
  `Month7` varchar(140) NOT NULL default '',
  `Month8` varchar(140) NOT NULL default '',
  `Month9` varchar(140) NOT NULL default '',
  `Month10` varchar(140) NOT NULL default '',
  `Month11` varchar(140) NOT NULL default '',
  `Month12` varchar(140) NOT NULL default '',
  `WDay1` varchar(140) NOT NULL default '',
  `WDay2` varchar(140) NOT NULL default '',
  `WDay3` varchar(140) NOT NULL default '',
  `WDay4` varchar(140) NOT NULL default '',
  `WDay5` varchar(140) NOT NULL default '',
  `WDay6` varchar(140) NOT NULL default '',
  `WDay7` varchar(140) NOT NULL default '',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Languages`
--


/*!40000 ALTER TABLE `Languages` DISABLE KEYS */;
LOCK TABLES `Languages` WRITE;
INSERT INTO `Languages` VALUES (1,'English','ISO_8859-1','English','en','January','February','March','April','May','June','July','August','September','October','November','December','Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'),(5,'German','ISO_8859-1','Deutsch','de','Januar','Februar','MÃ¤rz','April','Mai','Juni','Juli','August','September','Oktober','November','Dezember','Sonntag','Montag','Dienstag','Mittwoch','Donnerstag','Freitag','Samstag'),(9,'Portuguese','ISO_8859-1','PortuguÃªs','pt','Janeiro','Fevereiro','MarÃ§o','Abril','Maio','Junho','Julho','Agosto','Setembro','Outubro','Novembro','Dezembro','Domingo','Segunda-feira','TerÃ§a-feira','Quarta-feira','Quinta-feira','Sexta-feira','SÃ¡bado'),(12,'French','ISO_8859-1','FranÃ§ais','fr','Janvier','FÃ©vrier','Mars','Avril','Peut','Juin','Juli','AoÃ»t','Septembre','Octobre','Novembre','DÃ©cembre','Dimanche','Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi'),(13,'Spanish','ISO_8859-1','EspaÃ±ol','es','Enero','Febrero','Marcha','Abril','Puede','Junio','Juli','Agosto','Septiembre','Octubre','Noviembre','Diciembre','Domingo','Lunes','Martes','MiÃ©rcoles','Jueves','Viernes','SÃ¡bado'),(2,'Romanian','ISO_8859-2','RomÃ¢nÄƒ','ro','Ianuarie','Februarie','Martie','Aprilie','Mai','Iunie','Iulie','August','Septembrie','Octombrie','Noiembrie','Decembrie','DuminicÄƒ','Luni','MarÅ£i','Miercuri','Joi','Vineri','SÃ¢mbÄƒtÄƒ'),(7,'Croatian','ISO_8859-2','Hrvatski','hr','SijeÄanj','VeljaÄa','OÅ¾ujak','Travanj','Svibanj','Lipanj','Srpanj','Kolovoz','Rujan','Listopad','Studeni','Prosinac','Nedjelja','Ponedjeljak','Utorak','Srijeda','ÄŒetvrtak','Petak','Subota'),(8,'Czech','ISO_8859-2','ÄŒeskÃ½','cz','Leden','Ãšnor','BÅ™ezen','Duben','KvÄ›ten','ÄŒerven','ÄŒervenec','Srpen','ZÃ¡Å™Ã­','Å˜Ã­jen','Listopad','Prosinec','NedÄ›le','PondÄ›lÃ­','ÃšterÃ½','StÅ™eda','ÄŒtvrtek','PÃ¡tek','Sobota'),(11,'Serbo-Croatian','ISO_8859-2','Srpskohrvatski','sh','januar','februar','mart','april','maj','jun','jul','avgust','septembar','oktobar','novembar','decembar','nedelja','ponedeljak','utorak','sreda','Äetvrtak','petak','subota'),(10,'Serbian (Cyrillic)','ISO_8859-5','Ð¡Ñ€Ð¿ÑÐºÐ¸ (Ð‹Ð¸Ñ€Ð¸Ð»Ð¸Ñ†Ð°)','sr','Ñ˜Ð°Ð½ÑƒÐ°Ñ€','Ñ„ÐµÐ±Ñ€ÑƒÐ°Ñ€','Ð¼Ð°Ñ€Ñ‚','Ð°Ð¿Ñ€Ð¸Ð»','Ð¼Ð°Ñ˜','Ñ˜ÑƒÐ½','Ñ˜ÑƒÐ»','Ð°Ð²Ð³ÑƒÑÑ‚','ÑÐµÐ¿Ñ‚ÐµÐ¼Ð±Ð°Ñ€','Ð¾ÐºÑ‚Ð¾Ð±Ð°Ñ€','Ð½Ð¾Ð²ÐµÐ¼Ð±Ð°Ñ€','Ð´ÐµÑ†ÐµÐ¼Ð±Ð°Ñ€','Ð½ÐµÐ´ÐµÑ™Ð°','Ð¿Ð¾Ð½ÐµÐ´ÐµÑ™Ð°Ðº','ÑƒÑ‚Ð¾Ñ€Ð°Ðº','ÑÑ€ÐµÐ´Ð°','Ñ‡ÐµÑ‚Ð²Ñ€Ñ‚Ð°Ðº','Ð¿ÐµÑ‚Ð°Ðº','ÑÑƒÐ±Ð¾Ñ‚Ð°'),(15,'Russian','ISO_8859-5','Ð ÑƒÑÑÐºÐ¸Ð¹','ru','ÑÐ½Ð²Ð°Ñ€ÑŒ','Ñ„ÐµÐ²Ñ€Ð°Ð»ÑŒ','Ð¼Ð°Ñ€Ñ‚','Ð°Ð¿Ñ€ÐµÐ»ÑŒ','Ð¼Ð°Ð¹','Ð¸ÑŽÐ½ÑŒ','Ð¸ÑŽÐ»ÑŒ','Ð°Ð²Ð³ÑƒÑÑ‚','ÑÐµÐ½Ñ‚ÑÐ±Ñ€ÑŒ','Ð¾ÐºÑ‚ÑÐ±Ñ€ÑŒ','Ð½Ð¾ÑÐ±Ñ€ÑŒ','Ð´ÐµÐºÐ°Ð±Ñ€ÑŒ','Ð²Ð¾ÑÐºÑ€ÐµÑÐµÐ½ÑŒÐµ','Ð¿Ð¾Ð½ÐµÐ´ÐµÐ»ÑŒÐ½Ð¸Ðº','Ð²Ñ‚Ð¾Ñ€Ð½Ð¸Ðº','ÑÑ€ÐµÐ´Ð°','Ñ‡ÐµÑ‚Ð²ÐµÑ€Ð³','Ð¿ÑÑ‚Ð½Ð¸Ñ†Ð°','ÑÑƒÐ±Ð±Ð¾Ñ‚Ð°'),(18,'Swedish','','Svenska','sv','januari','februari','mars','april','maj','juni','juli','augusti','september','oktober','november','december','sÃ¶ndag','mÃ¥ndag','tisdag','onsdag','torsdag','fredag','lÃ¶rdag'),(16,'Chinese','UTF-8','ä¸­æ–‡','zh','ä¸€æœˆ','äºŒæœˆ','ä¸‰æœˆ','å››æœˆ','äº”æœˆ','å…­æœˆ','ä¸ƒæœˆ','å…«æœˆ','ä¹æœˆ','åæœˆ','åä¸€æœˆ','åäºŒæœˆ','æ˜ŸæœŸ','æ˜ŸæœŸ','æ˜ŸæœŸ','æ˜ŸæœŸ','æ˜ŸæœŸ','æ˜ŸæœŸ','æ˜ŸæœŸ'),(17,'Arabic','UTF-8','Ø¹Ø±Ø¨ÙŠ','ar','ÙƒØ§Ù†ÙˆÙ† Ø§Ù„Ø«Ø§Ù†ÙŠ','Ø´Ø¨Ø§Ø·','Ø¢Ø°Ø§Ø±','Ù†ÙŠØ³Ø§Ù†','Ø¢ÙŠØ§Ø±','Ø­Ø²ÙŠØ±Ø§Ù†','ØªÙ…ÙˆØ²','Ø¢Ø¨','Ø£ÙŠÙ„ÙˆÙ„','ØªØ´Ø±ÙŠÙ† Ø£ÙˆÙ„','ØªØ´Ø±ÙŠÙ† Ø§Ù„Ø«Ø§Ù†ÙŠ','ÙƒØ§Ù†ÙˆÙ† Ø£ÙˆÙ„','Ø§Ù„Ø£Ø­Ø¯','Ø§Ù„Ø§Ø«Ù†ÙŠÙ†','Ø§Ù„Ø«Ù„Ø§Ø«Ø§Ø¡','Ø§Ù„Ø£Ø±Ø¨Ø¹Ø§Ø¡','Ø§Ù„Ø®Ù…ÙŠØ³','Ø§Ù„Ø¬Ù…Ø¹Ø©','Ø§Ù„Ø³Ø¨Øª'),(19,'Korean','','í•œêµ­ì–´','kr','1ì›”','2ì›”','3ì›”','4ì›”','5ì›”','6ì›”','7ì›”','8ì›”','9ì›”','10ì›”','11ì›”','12ì›”','ì¼ìš”ì¼','ì›”ìš”ì¼','í™”ìš”ì¼','ìˆ˜ìš”ì¼','ëª©ìš”ì¼','ê¸ˆìš”ì¼','í† ìš”ì¼'),(20,'Dutch','','Nederlands','nl','januari','februari','maart','april','mei','juni','juli','augustus','september','oktober','november','december','zondag','maandag','dinsdag','woensdag','donderdag','vrijdag','zaterdag');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Languages` ENABLE KEYS */;

--
-- Table structure for table `Log`
--

DROP TABLE IF EXISTS `Log`;
CREATE TABLE `Log` (
  `time_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `fk_event_id` int(10) unsigned NOT NULL default '0',
  `fk_user_id` int(10) unsigned default NULL,
  `text` varchar(255) NOT NULL default '',
  KEY `IdEvent` (`fk_event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Log`
--


/*!40000 ALTER TABLE `Log` DISABLE KEYS */;
LOCK TABLES `Log` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Log` ENABLE KEYS */;

--
-- Table structure for table `Publications`
--

DROP TABLE IF EXISTS `Publications`;
CREATE TABLE `Publications` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  `IdDefaultLanguage` int(10) unsigned NOT NULL default '0',
  `TimeUnit` enum('D','W','M','Y') NOT NULL default 'D',
  `UnitCost` float(10,2) unsigned NOT NULL default '0.00',
  `UnitCostAllLang` float(10,2) unsigned NOT NULL default '0.00',
  `Currency` varchar(140) NOT NULL default '',
  `TrialTime` int(10) unsigned NOT NULL default '0',
  `PaidTime` int(10) unsigned NOT NULL default '0',
  `IdDefaultAlias` int(10) unsigned NOT NULL default '0',
  `IdURLType` int(10) unsigned NOT NULL default '1',
  `fk_forum_id` int(11) default NULL,
  `comments_enabled` tinyint(1) NOT NULL default '0',
  `comments_article_default_enabled` tinyint(1) NOT NULL default '0',
  `comments_subscribers_moderated` tinyint(1) NOT NULL default '0',
  `comments_public_moderated` tinyint(1) NOT NULL default '0',
  `comments_captcha_enabled` tinyint(1) NOT NULL default '0',
  `comments_spam_blocking_enabled` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Alias` (`IdDefaultAlias`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Publications`
--


/*!40000 ALTER TABLE `Publications` DISABLE KEYS */;
LOCK TABLES `Publications` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Publications` ENABLE KEYS */;

--
-- Table structure for table `Sections`
--

DROP TABLE IF EXISTS `Sections`;
CREATE TABLE `Sections` (
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `NrIssue` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Number` int(10) unsigned NOT NULL default '0',
  `Name` varchar(255) NOT NULL default '',
  `ShortName` varchar(32) NOT NULL default '',
  `SectionTplId` int(10) unsigned default NULL,
  `ArticleTplId` int(10) unsigned default NULL,
  PRIMARY KEY  (`IdPublication`,`NrIssue`,`IdLanguage`,`Number`),
  UNIQUE KEY `IdPublication` (`IdPublication`,`NrIssue`,`IdLanguage`,`Name`),
  UNIQUE KEY `ShortName` (`IdPublication`,`NrIssue`,`IdLanguage`,`ShortName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Sections`
--


/*!40000 ALTER TABLE `Sections` DISABLE KEYS */;
LOCK TABLES `Sections` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Sections` ENABLE KEYS */;

--
-- Table structure for table `SubsByIP`
--

DROP TABLE IF EXISTS `SubsByIP`;
CREATE TABLE `SubsByIP` (
  `IdUser` int(10) unsigned NOT NULL default '0',
  `StartIP` int(10) unsigned NOT NULL default '0',
  `Addresses` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`IdUser`,`StartIP`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SubsByIP`
--


/*!40000 ALTER TABLE `SubsByIP` DISABLE KEYS */;
LOCK TABLES `SubsByIP` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `SubsByIP` ENABLE KEYS */;

--
-- Table structure for table `SubsDefTime`
--

DROP TABLE IF EXISTS `SubsDefTime`;
CREATE TABLE `SubsDefTime` (
  `CountryCode` char(21) NOT NULL default '',
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `TrialTime` int(10) unsigned NOT NULL default '0',
  `PaidTime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`CountryCode`,`IdPublication`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SubsDefTime`
--


/*!40000 ALTER TABLE `SubsDefTime` DISABLE KEYS */;
LOCK TABLES `SubsDefTime` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `SubsDefTime` ENABLE KEYS */;

--
-- Table structure for table `SubsSections`
--

DROP TABLE IF EXISTS `SubsSections`;
CREATE TABLE `SubsSections` (
  `IdSubscription` int(10) unsigned NOT NULL default '0',
  `SectionNumber` int(10) unsigned NOT NULL default '0',
  `IdLanguage` int(10) NOT NULL default '0',
  `StartDate` date NOT NULL default '0000-00-00',
  `Days` int(10) unsigned NOT NULL default '0',
  `PaidDays` int(10) unsigned NOT NULL default '0',
  `NoticeSent` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`IdSubscription`,`SectionNumber`,`IdLanguage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SubsSections`
--


/*!40000 ALTER TABLE `SubsSections` DISABLE KEYS */;
LOCK TABLES `SubsSections` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `SubsSections` ENABLE KEYS */;

--
-- Table structure for table `Subscriptions`
--

DROP TABLE IF EXISTS `Subscriptions`;
CREATE TABLE `Subscriptions` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `IdUser` int(10) unsigned NOT NULL default '0',
  `IdPublication` int(10) unsigned NOT NULL default '0',
  `Active` enum('Y','N') NOT NULL default 'Y',
  `ToPay` float(10,2) unsigned NOT NULL default '0.00',
  `Currency` varchar(70) NOT NULL default '',
  `Type` enum('T','P') NOT NULL default 'T',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `IdUser` (`IdUser`,`IdPublication`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Subscriptions`
--


/*!40000 ALTER TABLE `Subscriptions` DISABLE KEYS */;
LOCK TABLES `Subscriptions` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Subscriptions` ENABLE KEYS */;

--
-- Table structure for table `TemplateTypes`
--

DROP TABLE IF EXISTS `TemplateTypes`;
CREATE TABLE `TemplateTypes` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` char(20) NOT NULL default '',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TemplateTypes`
--


/*!40000 ALTER TABLE `TemplateTypes` DISABLE KEYS */;
LOCK TABLES `TemplateTypes` WRITE;
INSERT INTO `TemplateTypes` VALUES (1,'default'),(2,'issue'),(3,'section'),(4,'article');
UNLOCK TABLES;
/*!40000 ALTER TABLE `TemplateTypes` ENABLE KEYS */;

--
-- Table structure for table `Templates`
--

DROP TABLE IF EXISTS `Templates`;
CREATE TABLE `Templates` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` char(255) NOT NULL default '',
  `Type` int(10) unsigned NOT NULL default '1',
  `Level` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Templates`
--


/*!40000 ALTER TABLE `Templates` DISABLE KEYS */;
LOCK TABLES `Templates` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Templates` ENABLE KEYS */;

--
-- Table structure for table `TimeUnits`
--

DROP TABLE IF EXISTS `TimeUnits`;
CREATE TABLE `TimeUnits` (
  `Unit` char(1) NOT NULL default '',
  `IdLanguage` int(10) unsigned NOT NULL default '0',
  `Name` varchar(70) NOT NULL default '',
  PRIMARY KEY  (`Unit`,`IdLanguage`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TimeUnits`
--


/*!40000 ALTER TABLE `TimeUnits` DISABLE KEYS */;
LOCK TABLES `TimeUnits` WRITE;
INSERT INTO `TimeUnits` VALUES ('D',1,'days'),('W',1,'weeks'),('M',1,'months'),('Y',1,'years'),('D',18,'dagar'),('W',18,'veckor'),('M',18,'mÃ¥nader'),('Y',18,'Ã¥r');
UNLOCK TABLES;
/*!40000 ALTER TABLE `TimeUnits` ENABLE KEYS */;

--
-- Table structure for table `TopicFields`
--

DROP TABLE IF EXISTS `TopicFields`;
CREATE TABLE `TopicFields` (
  `ArticleType` varchar(166) NOT NULL default '',
  `FieldName` varchar(166) NOT NULL default '',
  `RootTopicId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ArticleType`,`FieldName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TopicFields`
--


/*!40000 ALTER TABLE `TopicFields` DISABLE KEYS */;
LOCK TABLES `TopicFields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `TopicFields` ENABLE KEYS */;

--
-- Table structure for table `Topics`
--

DROP TABLE IF EXISTS `Topics`;
CREATE TABLE `Topics` (
  `Id` int(10) unsigned NOT NULL default '0',
  `LanguageId` int(10) unsigned NOT NULL default '0',
  `Name` varchar(255) NOT NULL default '',
  `ParentId` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Id`,`LanguageId`),
  UNIQUE KEY `Name` (`LanguageId`,`Name`),
  KEY `topic_id` (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Topics`
--


/*!40000 ALTER TABLE `Topics` DISABLE KEYS */;
LOCK TABLES `Topics` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Topics` ENABLE KEYS */;

--
-- Table structure for table `Translations`
--

DROP TABLE IF EXISTS `Translations`;
CREATE TABLE `Translations` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `phrase_id` int(10) unsigned NOT NULL default '0',
  `fk_language_id` int(10) unsigned NOT NULL default '0',
  `translation_text` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `phrase_language_index` (`phrase_id`,`fk_language_id`),
  KEY `phrase_id` (`phrase_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Translations`
--


/*!40000 ALTER TABLE `Translations` DISABLE KEYS */;
LOCK TABLES `Translations` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Translations` ENABLE KEYS */;

--
-- Table structure for table `URLTypes`
--

DROP TABLE IF EXISTS `URLTypes`;
CREATE TABLE `URLTypes` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(15) NOT NULL default '',
  `Description` mediumblob NOT NULL,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `URLTypes`
--


/*!40000 ALTER TABLE `URLTypes` DISABLE KEYS */;
LOCK TABLES `URLTypes` WRITE;
INSERT INTO `URLTypes` VALUES (1,'template path',''),(2,'short names','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `URLTypes` ENABLE KEYS */;

--
-- Table structure for table `UserConfig`
--

DROP TABLE IF EXISTS `UserConfig`;
CREATE TABLE `UserConfig` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_user_id` int(10) unsigned NOT NULL default '0',
  `varname` varchar(100) NOT NULL default '',
  `value` varchar(100) default NULL,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unique_var_name_index` (`fk_user_id`,`varname`),
  KEY `fk_user_id` (`fk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `UserConfig`
--


/*!40000 ALTER TABLE `UserConfig` DISABLE KEYS */;
LOCK TABLES `UserConfig` WRITE;
INSERT INTO `UserConfig` VALUES (1,1,'ManagePub','Y','2005-12-13 15:57:00'),(2,1,'DeletePub','Y','2005-12-13 15:57:00'),(3,1,'ManageIssue','Y','2005-12-13 15:57:00'),(4,1,'DeleteIssue','Y','2005-12-13 15:57:00'),(5,1,'ManageSection','Y','2005-12-13 15:57:00'),(6,1,'DeleteSection','Y','2005-12-13 15:57:00'),(7,1,'AddArticle','Y','2005-12-13 15:57:00'),(8,1,'ChangeArticle','Y','2005-12-13 15:57:00'),(9,1,'DeleteArticle','Y','2005-12-13 15:57:00'),(10,1,'AddImage','Y','2005-12-13 15:57:00'),(11,1,'AddFile','Y','2005-12-13 15:57:00'),(12,1,'ChangeImage','Y','2005-12-13 15:57:00'),(13,1,'ChangeFile','Y','2005-12-13 15:57:00'),(14,1,'DeleteImage','Y','2005-12-13 15:57:00'),(15,1,'DeleteFile','Y','2005-12-13 15:57:00'),(16,1,'ManageTempl','Y','2005-12-13 15:57:00'),(17,1,'DeleteTempl','Y','2005-12-13 15:57:00'),(18,1,'ManageUsers','Y','2005-12-13 15:57:00'),(19,1,'ManageSubscriptions','Y','2005-12-13 15:57:00'),(20,1,'DeleteUsers','Y','2005-12-13 15:57:00'),(21,1,'ManageUserTypes','Y','2005-12-13 15:57:00'),(22,1,'ManageArticleTypes','Y','2005-12-13 15:57:00'),(23,1,'DeleteArticleTypes','Y','2005-12-13 15:57:00'),(24,1,'ManageLanguages','Y','2005-12-13 15:57:00'),(25,1,'DeleteLanguages','Y','2005-12-13 15:57:00'),(26,1,'ManageCountries','Y','2005-12-13 15:57:00'),(27,1,'DeleteCountries','Y','2005-12-13 15:57:00'),(28,1,'MailNotify','N','2005-12-13 15:57:00'),(29,1,'ViewLogs','Y','2005-12-13 15:57:00'),(30,1,'ManageLocalizer','Y','2005-12-13 15:57:00'),(31,1,'ManageIndexer','N','2006-03-06 15:08:55'),(32,1,'Publish','Y','2005-12-13 15:57:00'),(33,1,'ManageTopics','Y','2005-12-13 15:57:00'),(34,1,'EditorImage','Y','2005-12-13 15:57:00'),(35,1,'EditorTextAlignment','Y','2005-12-13 15:57:00'),(36,1,'EditorFontColor','Y','2005-12-13 15:57:00'),(37,1,'EditorFontSize','Y','2005-12-13 15:57:00'),(38,1,'EditorFontFace','Y','2005-12-13 15:57:00'),(39,1,'EditorTable','Y','2005-12-13 15:57:00'),(40,1,'EditorSuperscript','Y','2005-12-13 15:57:00'),(41,1,'EditorSubscript','Y','2005-12-13 15:57:00'),(42,1,'EditorStrikethrough','Y','2005-12-13 15:57:00'),(43,1,'EditorIndent','Y','2005-12-13 15:57:00'),(44,1,'EditorListBullet','Y','2005-12-13 15:57:00'),(45,1,'EditorListNumber','Y','2005-12-13 15:57:00'),(46,1,'EditorHorizontalRule','Y','2005-12-13 15:57:00'),(47,1,'EditorSourceView','Y','2005-12-13 15:57:00'),(48,1,'EditorEnlarge','Y','2005-12-13 15:57:00'),(49,1,'EditorTextDirection','Y','2005-12-13 15:57:00'),(50,1,'EditorLink','Y','2005-12-13 15:57:00'),(51,1,'EditorSubhead','Y','2005-12-13 15:57:00'),(52,1,'EditorBold','Y','2005-12-13 15:57:00'),(53,1,'EditorItalic','Y','2005-12-13 15:57:00'),(54,1,'EditorUnderline','Y','2005-12-13 15:57:00'),(55,1,'EditorUndoRedo','Y','2005-12-13 15:57:00'),(56,1,'EditorCopyCutPaste','Y','2005-12-13 15:57:00'),(57,1,'ManageReaders','Y','2005-12-13 15:57:00'),(58,1,'InitializeTemplateEngine','Y','2005-12-13 15:57:00'),(59,0,'KeywordSeparator',',','2006-03-06 14:33:50'),(60,1,'MoveArticle','Y','2006-03-06 14:33:50'),(61,1,'TranslateArticle','Y','2006-03-06 14:33:50'),(62,1,'AttachImageToArticle','Y','2006-03-06 14:33:50'),(63,1,'ChangeSystemPreferences','Y','2006-03-06 14:33:50'),(64,1,'AttachTopicToArticle','Y','2006-03-06 14:33:50'),(65,1,'EditorFindReplace','Y','2006-03-06 14:33:50'),(66,1,'EditorCharacterMap','Y','2006-03-06 14:33:50'),(67,0,'LoginFailedAttemptsNum','3','2006-06-12 17:01:34'),(68,1,'CommentModerate','Y','2006-06-12 17:01:34'),(69,1,'CommentEnable','Y','2006-06-12 17:01:34'),(70,0,'ExternalSubscriptionManagement','N','2007-01-20 14:56:13'),(71,1,'SyncPhorumUsers','Y','2007-02-09 12:44:18');
UNLOCK TABLES;
/*!40000 ALTER TABLE `UserConfig` ENABLE KEYS */;

--
-- Table structure for table `UserTypes`
--

DROP TABLE IF EXISTS `UserTypes`;
CREATE TABLE `UserTypes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_type_name` varchar(140) NOT NULL default '',
  `varname` varchar(100) NOT NULL default '',
  `value` varchar(100) default NULL,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unique_var_name_index` (`user_type_name`,`varname`),
  KEY `user_type_name` (`user_type_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `UserTypes`
--


/*!40000 ALTER TABLE `UserTypes` DISABLE KEYS */;
LOCK TABLES `UserTypes` WRITE;
INSERT INTO `UserTypes` VALUES (1,'Administrator','ManagePub','Y','2005-12-13 15:57:00'),(2,'Administrator','DeletePub','Y','2005-12-13 15:57:00'),(3,'Administrator','ManageIssue','Y','2005-12-13 15:57:00'),(4,'Administrator','DeleteIssue','Y','2005-12-13 15:57:00'),(5,'Administrator','ManageSection','Y','2005-12-13 15:57:00'),(6,'Administrator','DeleteSection','Y','2005-12-13 15:57:00'),(7,'Administrator','AddArticle','Y','2005-12-13 15:57:00'),(8,'Administrator','ChangeArticle','Y','2005-12-13 15:57:00'),(9,'Administrator','DeleteArticle','Y','2005-12-13 15:57:00'),(10,'Administrator','AddImage','Y','2005-12-13 15:57:00'),(11,'Administrator','AddFile','Y','2005-12-13 15:57:00'),(12,'Administrator','ChangeImage','Y','2005-12-13 15:57:00'),(13,'Administrator','ChangeFile','Y','2005-12-13 15:57:00'),(14,'Administrator','DeleteImage','Y','2005-12-13 15:57:00'),(15,'Administrator','DeleteFile','Y','2005-12-13 15:57:00'),(16,'Administrator','ManageTempl','Y','2005-12-13 15:57:00'),(17,'Administrator','DeleteTempl','Y','2005-12-13 15:57:00'),(18,'Administrator','ManageUsers','Y','2005-12-13 15:57:00'),(19,'Administrator','ManageSubscriptions','Y','2005-12-13 15:57:00'),(20,'Administrator','DeleteUsers','Y','2005-12-13 15:57:00'),(21,'Administrator','ManageUserTypes','Y','2005-12-13 15:57:00'),(22,'Administrator','ManageArticleTypes','Y','2005-12-13 15:57:00'),(23,'Administrator','DeleteArticleTypes','Y','2005-12-13 15:57:00'),(24,'Administrator','ManageLanguages','Y','2005-12-13 15:57:00'),(25,'Administrator','DeleteLanguages','Y','2005-12-13 15:57:00'),(26,'Administrator','ManageCountries','Y','2005-12-13 15:57:00'),(27,'Administrator','DeleteCountries','Y','2005-12-13 15:57:00'),(28,'Administrator','MailNotify','N','2005-12-13 15:57:00'),(29,'Administrator','ViewLogs','Y','2005-12-13 15:57:00'),(30,'Administrator','ManageLocalizer','Y','2005-12-13 15:57:00'),(31,'Administrator','ManageIndexer','N','2006-01-04 00:21:55'),(32,'Administrator','Publish','Y','2005-12-13 15:57:00'),(33,'Administrator','ManageTopics','Y','2005-12-13 15:57:00'),(34,'Administrator','EditorImage','Y','2005-12-13 15:57:00'),(35,'Administrator','EditorTextAlignment','Y','2005-12-13 15:57:00'),(36,'Administrator','EditorFontColor','Y','2005-12-13 15:57:00'),(37,'Administrator','EditorFontSize','Y','2005-12-13 15:57:00'),(38,'Administrator','EditorFontFace','Y','2005-12-13 15:57:00'),(39,'Administrator','EditorTable','Y','2005-12-13 15:57:00'),(40,'Administrator','EditorSuperscript','Y','2005-12-13 15:57:00'),(41,'Administrator','EditorSubscript','Y','2005-12-13 15:57:00'),(42,'Administrator','EditorStrikethrough','Y','2005-12-13 15:57:00'),(43,'Administrator','EditorIndent','Y','2005-12-13 15:57:00'),(44,'Administrator','EditorListBullet','Y','2005-12-13 15:57:00'),(45,'Administrator','EditorListNumber','Y','2005-12-13 15:57:00'),(46,'Administrator','EditorHorizontalRule','Y','2005-12-13 15:57:00'),(47,'Administrator','EditorSourceView','Y','2005-12-13 15:57:00'),(48,'Administrator','EditorEnlarge','Y','2005-12-13 15:57:00'),(49,'Administrator','EditorTextDirection','Y','2005-12-13 15:57:00'),(50,'Administrator','EditorLink','Y','2005-12-13 15:57:00'),(51,'Administrator','EditorSubhead','Y','2005-12-13 15:57:00'),(52,'Administrator','EditorBold','Y','2005-12-13 15:57:00'),(53,'Administrator','EditorItalic','Y','2005-12-13 15:57:00'),(54,'Administrator','EditorUnderline','Y','2005-12-13 15:57:00'),(55,'Administrator','EditorUndoRedo','Y','2005-12-13 15:57:00'),(56,'Administrator','EditorCopyCutPaste','Y','2005-12-13 15:57:00'),(57,'Administrator','ManageReaders','Y','2005-12-13 15:57:00'),(58,'Administrator','InitializeTemplateEngine','Y','2006-01-04 00:21:55'),(59,'Editor','ManagePub','N','2005-12-13 15:57:00'),(60,'Editor','DeletePub','N','2005-12-13 15:57:00'),(61,'Editor','ManageIssue','N','2005-12-13 15:57:00'),(62,'Editor','DeleteIssue','N','2005-12-13 15:57:00'),(63,'Editor','ManageSection','N','2005-12-13 15:57:00'),(64,'Editor','DeleteSection','N','2005-12-13 15:57:00'),(65,'Editor','AddArticle','Y','2005-12-13 15:57:00'),(66,'Editor','ChangeArticle','Y','2005-12-13 15:57:00'),(67,'Editor','DeleteArticle','Y','2005-12-13 15:57:00'),(68,'Editor','AddImage','Y','2005-12-13 15:57:00'),(69,'Editor','AddFile','Y','2005-12-13 15:57:00'),(70,'Editor','ChangeImage','Y','2005-12-13 15:57:00'),(71,'Editor','ChangeFile','Y','2005-12-13 15:57:00'),(72,'Editor','DeleteImage','Y','2005-12-13 15:57:00'),(73,'Editor','DeleteFile','Y','2005-12-13 15:57:00'),(74,'Editor','ManageTempl','N','2005-12-13 15:57:00'),(75,'Editor','DeleteTempl','N','2005-12-13 15:57:00'),(76,'Editor','ManageUsers','N','2005-12-13 15:57:00'),(77,'Editor','ManageSubscriptions','N','2005-12-13 15:57:00'),(78,'Editor','DeleteUsers','N','2005-12-13 15:57:00'),(79,'Editor','ManageUserTypes','N','2005-12-13 15:57:00'),(80,'Editor','ManageArticleTypes','N','2005-12-13 15:57:00'),(81,'Editor','DeleteArticleTypes','N','2005-12-13 15:57:00'),(82,'Editor','ManageLanguages','N','2005-12-13 15:57:00'),(83,'Editor','DeleteLanguages','N','2005-12-13 15:57:00'),(84,'Editor','ManageCountries','N','2005-12-13 15:57:00'),(85,'Editor','DeleteCountries','N','2005-12-13 15:57:00'),(86,'Editor','MailNotify','Y','2005-12-13 15:57:00'),(87,'Editor','ViewLogs','N','2005-12-13 15:57:00'),(88,'Editor','ManageLocalizer','N','2005-12-13 15:57:00'),(89,'Editor','ManageIndexer','N','2005-12-13 15:57:00'),(90,'Editor','Publish','N','2005-12-13 15:57:00'),(91,'Editor','ManageTopics','N','2005-12-13 15:57:00'),(92,'Editor','EditorImage','Y','2005-12-13 15:57:00'),(93,'Editor','EditorTextAlignment','Y','2005-12-13 15:57:00'),(94,'Editor','EditorFontColor','N','2005-12-13 15:57:00'),(95,'Editor','EditorFontSize','N','2005-12-13 15:57:00'),(96,'Editor','EditorFontFace','N','2005-12-13 15:57:00'),(97,'Editor','EditorTable','Y','2005-12-13 15:57:00'),(98,'Editor','EditorSuperscript','N','2006-03-06 15:34:26'),(99,'Editor','EditorSubscript','N','2006-03-06 15:34:26'),(100,'Editor','EditorStrikethrough','N','2005-12-13 15:57:00'),(101,'Editor','EditorIndent','Y','2005-12-13 15:57:00'),(102,'Editor','EditorListBullet','Y','2005-12-13 15:57:00'),(103,'Editor','EditorListNumber','Y','2005-12-13 15:57:00'),(104,'Editor','EditorHorizontalRule','N','2005-12-13 15:57:00'),(105,'Editor','EditorSourceView','N','2005-12-13 15:57:00'),(106,'Editor','EditorEnlarge','Y','2005-12-13 15:57:00'),(107,'Editor','EditorTextDirection','Y','2005-12-13 15:57:00'),(108,'Editor','EditorLink','Y','2005-12-13 15:57:00'),(109,'Editor','EditorSubhead','Y','2005-12-13 15:57:00'),(110,'Editor','EditorBold','Y','2005-12-13 15:57:00'),(111,'Editor','EditorItalic','Y','2005-12-13 15:57:00'),(112,'Editor','EditorUnderline','Y','2005-12-13 15:57:00'),(113,'Editor','EditorUndoRedo','Y','2005-12-13 15:57:00'),(114,'Editor','EditorCopyCutPaste','Y','2005-12-13 15:57:00'),(115,'Editor','ManageReaders','N','2005-12-13 15:57:00'),(116,'Editor','InitializeTemplateEngine','N','2005-12-13 15:57:00'),(117,'Chief Editor','ManagePub','N','2005-12-13 15:57:00'),(118,'Chief Editor','DeletePub','N','2005-12-13 15:57:00'),(119,'Chief Editor','ManageIssue','Y','2005-12-13 15:57:00'),(120,'Chief Editor','DeleteIssue','Y','2005-12-13 15:57:00'),(121,'Chief Editor','ManageSection','Y','2005-12-13 15:57:00'),(122,'Chief Editor','DeleteSection','Y','2005-12-13 15:57:00'),(123,'Chief Editor','AddArticle','Y','2005-12-13 15:57:00'),(124,'Chief Editor','ChangeArticle','Y','2005-12-13 15:57:00'),(125,'Chief Editor','DeleteArticle','Y','2005-12-13 15:57:00'),(126,'Chief Editor','AddImage','Y','2005-12-13 15:57:00'),(127,'Chief Editor','AddFile','Y','2005-12-13 15:57:00'),(128,'Chief Editor','ChangeImage','Y','2005-12-13 15:57:00'),(129,'Chief Editor','ChangeFile','Y','2005-12-13 15:57:00'),(130,'Chief Editor','DeleteImage','Y','2005-12-13 15:57:00'),(131,'Chief Editor','DeleteFile','Y','2005-12-13 15:57:00'),(132,'Chief Editor','ManageTempl','N','2006-03-06 15:35:40'),(133,'Chief Editor','DeleteTempl','N','2006-03-06 15:35:40'),(134,'Chief Editor','ManageUsers','Y','2006-03-06 15:35:40'),(135,'Chief Editor','ManageSubscriptions','N','2005-12-13 15:57:00'),(136,'Chief Editor','DeleteUsers','Y','2006-03-06 15:35:40'),(137,'Chief Editor','ManageUserTypes','N','2005-12-13 15:57:00'),(138,'Chief Editor','ManageArticleTypes','Y','2005-12-13 15:57:00'),(139,'Chief Editor','DeleteArticleTypes','Y','2005-12-13 15:57:00'),(140,'Chief Editor','ManageLanguages','N','2005-12-13 15:57:00'),(141,'Chief Editor','DeleteLanguages','N','2005-12-13 15:57:00'),(142,'Chief Editor','ManageCountries','N','2005-12-13 15:57:00'),(143,'Chief Editor','DeleteCountries','N','2005-12-13 15:57:00'),(144,'Chief Editor','MailNotify','N','2005-12-13 15:57:00'),(145,'Chief Editor','ViewLogs','Y','2005-12-13 15:57:00'),(146,'Chief Editor','ManageLocalizer','Y','2005-12-13 15:57:00'),(147,'Chief Editor','ManageIndexer','N','2005-12-13 15:57:00'),(148,'Chief Editor','Publish','Y','2005-12-13 15:57:00'),(149,'Chief Editor','ManageTopics','Y','2005-12-13 15:57:00'),(150,'Chief Editor','EditorImage','Y','2005-12-13 15:57:00'),(151,'Chief Editor','EditorTextAlignment','N','2005-12-13 15:57:00'),(152,'Chief Editor','EditorFontColor','Y','2005-12-13 15:57:00'),(153,'Chief Editor','EditorFontSize','N','2005-12-13 15:57:00'),(154,'Chief Editor','EditorFontFace','N','2005-12-13 15:57:00'),(155,'Chief Editor','EditorTable','Y','2005-12-13 15:57:00'),(156,'Chief Editor','EditorSuperscript','Y','2005-12-13 15:57:00'),(157,'Chief Editor','EditorSubscript','Y','2005-12-13 15:57:00'),(158,'Chief Editor','EditorStrikethrough','Y','2005-12-13 15:57:00'),(159,'Chief Editor','EditorIndent','Y','2005-12-13 15:57:00'),(160,'Chief Editor','EditorListBullet','Y','2005-12-13 15:57:00'),(161,'Chief Editor','EditorListNumber','Y','2005-12-13 15:57:00'),(162,'Chief Editor','EditorHorizontalRule','N','2005-12-13 15:57:00'),(163,'Chief Editor','EditorSourceView','N','2005-12-13 15:57:00'),(164,'Chief Editor','EditorEnlarge','Y','2005-12-13 15:57:00'),(165,'Chief Editor','EditorTextDirection','Y','2005-12-13 15:57:00'),(166,'Chief Editor','EditorLink','Y','2005-12-13 15:57:00'),(167,'Chief Editor','EditorSubhead','Y','2005-12-13 15:57:00'),(168,'Chief Editor','EditorBold','Y','2005-12-13 15:57:00'),(169,'Chief Editor','EditorItalic','Y','2005-12-13 15:57:00'),(170,'Chief Editor','EditorUnderline','Y','2005-12-13 15:57:00'),(171,'Chief Editor','EditorUndoRedo','Y','2005-12-13 15:57:00'),(172,'Chief Editor','EditorCopyCutPaste','Y','2005-12-13 15:57:00'),(173,'Chief Editor','ManageReaders','Y','2005-12-13 15:57:00'),(174,'Chief Editor','InitializeTemplateEngine','N','2005-12-13 15:57:00'),(175,'Journalist','ManagePub','N','2006-01-03 23:10:30'),(176,'Journalist','DeletePub','N','2006-01-03 23:10:30'),(177,'Journalist','ManageIssue','N','2006-01-03 23:10:30'),(178,'Journalist','DeleteIssue','N','2006-01-03 23:10:30'),(179,'Journalist','ManageSection','N','2006-01-03 23:10:30'),(180,'Journalist','DeleteSection','N','2006-01-03 23:10:30'),(181,'Journalist','AddArticle','Y','2006-01-03 23:10:30'),(182,'Journalist','ChangeArticle','N','2006-01-03 23:10:30'),(183,'Journalist','DeleteArticle','N','2006-01-03 23:10:30'),(184,'Journalist','AddImage','Y','2006-01-03 23:10:30'),(185,'Journalist','ChangeImage','Y','2006-01-03 23:10:30'),(186,'Journalist','DeleteImage','N','2006-01-03 23:10:30'),(187,'Journalist','ManageTempl','N','2006-01-03 23:10:30'),(188,'Journalist','DeleteTempl','N','2006-01-03 23:10:30'),(189,'Journalist','ManageUsers','N','2006-01-03 23:10:30'),(190,'Journalist','ManageReaders','N','2006-01-03 23:10:30'),(191,'Journalist','ManageSubscriptions','N','2006-01-03 23:10:30'),(192,'Journalist','DeleteUsers','N','2006-01-03 23:10:30'),(193,'Journalist','ManageUserTypes','N','2006-01-03 23:10:30'),(194,'Journalist','ManageArticleTypes','N','2006-01-03 23:10:30'),(195,'Journalist','DeleteArticleTypes','N','2006-01-03 23:10:30'),(196,'Journalist','ManageLanguages','N','2006-01-03 23:10:30'),(197,'Journalist','DeleteLanguages','N','2006-01-03 23:10:30'),(198,'Journalist','MailNotify','N','2006-01-03 23:10:30'),(199,'Journalist','ManageCountries','N','2006-01-03 23:10:30'),(200,'Journalist','DeleteCountries','N','2006-01-03 23:10:30'),(201,'Journalist','ViewLogs','N','2006-01-03 23:10:30'),(202,'Journalist','ManageLocalizer','N','2006-01-03 23:10:30'),(203,'Journalist','ManageIndexer','N','2006-01-03 23:10:30'),(204,'Journalist','Publish','N','2006-01-03 23:10:30'),(205,'Journalist','ManageTopics','N','2006-01-03 23:10:30'),(206,'Journalist','EditorBold','Y','2006-01-03 23:10:30'),(207,'Journalist','EditorItalic','Y','2006-01-03 23:10:30'),(208,'Journalist','EditorUnderline','Y','2006-01-03 23:10:30'),(209,'Journalist','EditorUndoRedo','Y','2006-03-06 15:30:35'),(210,'Journalist','EditorCopyCutPaste','Y','2006-01-03 23:10:30'),(211,'Journalist','EditorImage','Y','2006-01-03 23:10:30'),(212,'Journalist','EditorTextAlignment','N','2006-03-06 15:30:35'),(213,'Journalist','EditorFontColor','N','2006-03-06 15:30:35'),(214,'Journalist','EditorFontSize','N','2006-01-03 23:10:30'),(215,'Journalist','EditorFontFace','N','2006-01-03 23:10:30'),(216,'Journalist','EditorTable','N','2006-03-06 15:32:48'),(217,'Journalist','EditorSuperscript','N','2006-01-03 23:10:30'),(218,'Journalist','EditorSubscript','N','2006-01-03 23:10:30'),(219,'Journalist','EditorStrikethrough','N','2006-03-06 15:30:35'),(220,'Journalist','EditorIndent','N','2006-03-06 15:30:35'),(221,'Journalist','EditorListBullet','Y','2006-01-03 23:10:30'),(222,'Journalist','EditorListNumber','Y','2006-01-03 23:10:30'),(223,'Journalist','EditorHorizontalRule','N','2006-01-03 23:10:30'),(224,'Journalist','EditorSourceView','N','2006-01-03 23:10:30'),(225,'Journalist','EditorEnlarge','Y','2006-01-03 23:10:30'),(226,'Journalist','EditorTextDirection','N','2006-03-06 15:30:35'),(227,'Journalist','EditorLink','Y','2006-01-03 23:10:30'),(228,'Journalist','EditorSubhead','Y','2006-01-03 23:10:30'),(229,'Journalist','InitializeTemplateEngine','N','2006-01-03 23:10:30'),(230,'Journalist','AddFile','Y','2006-01-03 23:10:30'),(231,'Journalist','ChangeFile','Y','2006-01-03 23:10:30'),(232,'Journalist','DeleteFile','N','2006-01-03 23:10:30'),(233,'Administrator','MoveArticle','Y','2006-03-06 14:33:50'),(234,'Administrator','TranslateArticle','Y','2006-03-06 14:33:50'),(235,'Administrator','AttachImageToArticle','Y','2006-03-06 14:33:50'),(236,'Administrator','ChangeSystemPreferences','Y','2006-03-06 14:33:50'),(237,'Administrator','AttachTopicToArticle','Y','2006-03-06 14:33:50'),(238,'Administrator','EditorFindReplace','Y','2006-03-06 14:33:50'),(239,'Administrator','EditorCharacterMap','Y','2006-03-06 14:33:50'),(240,'Chief Editor','MoveArticle','Y','2006-03-06 14:33:50'),(241,'Chief Editor','TranslateArticle','Y','2006-03-06 14:33:50'),(242,'Chief Editor','AttachImageToArticle','Y','2006-03-06 14:33:50'),(243,'Chief Editor','ChangeSystemPreferences','N','2006-03-06 14:33:50'),(244,'Chief Editor','AttachTopicToArticle','Y','2006-03-06 14:33:50'),(245,'Chief Editor','EditorFindReplace','Y','2006-03-06 14:33:50'),(246,'Chief Editor','EditorCharacterMap','Y','2006-03-06 14:33:50'),(247,'Editor','MoveArticle','Y','2006-03-06 14:33:50'),(248,'Editor','TranslateArticle','Y','2006-03-06 14:33:50'),(249,'Editor','AttachImageToArticle','Y','2006-03-06 14:33:50'),(250,'Editor','ChangeSystemPreferences','N','2006-03-06 14:33:50'),(251,'Editor','AttachTopicToArticle','Y','2006-03-06 14:33:50'),(252,'Editor','EditorFindReplace','Y','2006-03-06 14:33:50'),(253,'Editor','EditorCharacterMap','Y','2006-03-06 14:33:50'),(254,'Journalist','MoveArticle','N','2006-03-06 14:33:50'),(255,'Journalist','TranslateArticle','Y','2006-03-06 14:33:50'),(256,'Journalist','AttachImageToArticle','Y','2006-03-06 14:33:50'),(257,'Journalist','ChangeSystemPreferences','N','2006-03-06 14:33:50'),(258,'Journalist','AttachTopicToArticle','Y','2006-03-06 14:33:50'),(259,'Journalist','EditorFindReplace','Y','2006-03-06 14:33:50'),(260,'Journalist','EditorCharacterMap','Y','2006-03-06 14:33:50'),(261,'Subscription manager','ManagePub','N','2006-03-06 15:36:24'),(262,'Subscription manager','DeletePub','N','2006-03-06 15:36:24'),(263,'Subscription manager','ManageIssue','N','2006-03-06 15:36:24'),(264,'Subscription manager','DeleteIssue','N','2006-03-06 15:36:24'),(265,'Subscription manager','ManageSection','N','2006-03-06 15:36:24'),(266,'Subscription manager','DeleteSection','N','2006-03-06 15:36:24'),(267,'Subscription manager','AddArticle','N','2006-03-06 15:36:24'),(268,'Subscription manager','ChangeArticle','N','2006-03-06 15:36:24'),(269,'Subscription manager','MoveArticle','N','2006-03-06 15:36:24'),(270,'Subscription manager','TranslateArticle','N','2006-03-06 15:36:24'),(271,'Subscription manager','DeleteArticle','N','2006-03-06 15:36:24'),(272,'Subscription manager','AttachImageToArticle','N','2006-03-06 15:36:24'),(273,'Subscription manager','AttachTopicToArticle','N','2006-03-06 15:36:24'),(274,'Subscription manager','AddImage','N','2006-03-06 15:36:24'),(275,'Subscription manager','ChangeImage','N','2006-03-06 15:36:24'),(276,'Subscription manager','DeleteImage','N','2006-03-06 15:36:24'),(277,'Subscription manager','ManageTempl','N','2006-03-06 15:36:24'),(278,'Subscription manager','DeleteTempl','N','2006-03-06 15:36:24'),(279,'Subscription manager','ManageUsers','N','2006-03-06 15:36:24'),(280,'Subscription manager','ManageReaders','Y','2006-03-06 15:36:24'),(281,'Subscription manager','ManageSubscriptions','Y','2006-03-06 15:36:24'),(282,'Subscription manager','DeleteUsers','N','2006-03-06 15:36:24'),(283,'Subscription manager','ManageUserTypes','N','2006-03-06 15:36:24'),(284,'Subscription manager','ManageArticleTypes','N','2006-03-06 15:36:24'),(285,'Subscription manager','DeleteArticleTypes','N','2006-03-06 15:36:24'),(286,'Subscription manager','ManageLanguages','N','2006-03-06 15:36:24'),(287,'Subscription manager','DeleteLanguages','N','2006-03-06 15:36:24'),(288,'Subscription manager','MailNotify','N','2006-03-06 15:36:24'),(289,'Subscription manager','ManageCountries','N','2006-03-06 15:36:24'),(290,'Subscription manager','DeleteCountries','N','2006-03-06 15:36:24'),(291,'Subscription manager','ViewLogs','N','2006-03-06 15:36:24'),(292,'Subscription manager','ManageLocalizer','N','2006-03-06 15:36:24'),(293,'Subscription manager','ManageIndexer','N','2006-03-06 15:36:24'),(294,'Subscription manager','Publish','N','2006-03-06 15:36:24'),(295,'Subscription manager','ManageTopics','N','2006-03-06 15:36:24'),(296,'Subscription manager','EditorBold','N','2006-03-06 15:36:24'),(297,'Subscription manager','EditorItalic','N','2006-03-06 15:36:24'),(298,'Subscription manager','EditorUnderline','N','2006-03-06 15:36:24'),(299,'Subscription manager','EditorUndoRedo','N','2006-03-06 15:36:24'),(300,'Subscription manager','EditorCopyCutPaste','N','2006-03-06 15:36:24'),(301,'Subscription manager','EditorFindReplace','N','2006-03-06 15:36:24'),(302,'Subscription manager','EditorCharacterMap','N','2006-03-06 15:36:24'),(303,'Subscription manager','EditorImage','N','2006-03-06 15:36:24'),(304,'Subscription manager','EditorTextAlignment','N','2006-03-06 15:36:24'),(305,'Subscription manager','EditorFontColor','N','2006-03-06 15:36:24'),(306,'Subscription manager','EditorFontSize','N','2006-03-06 15:36:24'),(307,'Subscription manager','EditorFontFace','N','2006-03-06 15:36:24'),(308,'Subscription manager','EditorTable','N','2006-03-06 15:36:24'),(309,'Subscription manager','EditorSuperscript','N','2006-03-06 15:36:24'),(310,'Subscription manager','EditorSubscript','N','2006-03-06 15:36:24'),(311,'Subscription manager','EditorStrikethrough','N','2006-03-06 15:36:24'),(312,'Subscription manager','EditorIndent','N','2006-03-06 15:36:24'),(313,'Subscription manager','EditorListBullet','N','2006-03-06 15:36:24'),(314,'Subscription manager','EditorListNumber','N','2006-03-06 15:36:24'),(315,'Subscription manager','EditorHorizontalRule','N','2006-03-06 15:36:24'),(316,'Subscription manager','EditorSourceView','N','2006-03-06 15:36:24'),(317,'Subscription manager','EditorEnlarge','N','2006-03-06 15:36:24'),(318,'Subscription manager','EditorTextDirection','N','2006-03-06 15:36:24'),(319,'Subscription manager','EditorLink','N','2006-03-06 15:36:24'),(320,'Subscription manager','EditorSubhead','N','2006-03-06 15:36:24'),(321,'Subscription manager','InitializeTemplateEngine','N','2006-03-06 15:36:24'),(322,'Subscription manager','ChangeSystemPreferences','N','2006-03-06 15:36:24'),(323,'Subscription manager','AddFile','N','2006-03-06 15:36:24'),(324,'Subscription manager','ChangeFile','N','2006-03-06 15:36:24'),(325,'Subscription manager','DeleteFile','N','2006-03-06 15:36:24'),(326,'Administrator','CommentModerate','Y','2006-06-12 17:01:34'),(327,'Administrator','CommentEnable','Y','2006-06-12 17:01:34'),(328,'Chief Editor','CommentModerate','Y','2006-06-12 17:01:34'),(329,'Chief Editor','CommentEnable','Y','2006-06-12 17:01:34'),(330,'Editor','CommentModerate','N','2006-06-12 17:01:34'),(331,'Editor','CommentEnable','N','2006-06-12 17:01:34'),(332,'Journalist','CommentModerate','N','2006-06-12 17:01:34'),(333,'Journalist','CommentEnable','N','2006-06-12 17:01:34'),(334,'Subscription manager','CommentModerate','N','2006-06-12 17:01:34'),(335,'Subscription manager','CommentEnable','N','2006-06-12 17:01:34');
UNLOCK TABLES;
/*!40000 ALTER TABLE `UserTypes` ENABLE KEYS */;

--
-- Table structure for table `Users`
--

DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `KeyId` int(10) unsigned default NULL,
  `Name` varchar(255) NOT NULL default '',
  `UName` varchar(70) NOT NULL default '',
  `Password` varchar(64) NOT NULL default '',
  `EMail` varchar(255) NOT NULL default '',
  `Reader` enum('Y','N') NOT NULL default 'Y',
  `fk_user_type` varchar(140) default NULL,
  `City` varchar(100) NOT NULL default '',
  `StrAddress` varchar(255) NOT NULL default '',
  `State` varchar(32) NOT NULL default '',
  `CountryCode` varchar(21) default NULL,
  `Phone` varchar(20) NOT NULL default '',
  `Fax` varchar(20) NOT NULL default '',
  `Contact` varchar(64) NOT NULL default '',
  `Phone2` varchar(20) NOT NULL default '',
  `Title` enum('Mr.','Mrs.','Ms.','Dr.') NOT NULL default 'Mr.',
  `Gender` enum('M','F') default NULL,
  `Age` enum('0-17','18-24','25-39','40-49','50-65','65-') NOT NULL default '0-17',
  `PostalCode` varchar(70) NOT NULL default '',
  `Employer` varchar(140) NOT NULL default '',
  `EmployerType` varchar(140) NOT NULL default '',
  `Position` varchar(70) NOT NULL default '',
  `Interests` mediumblob NOT NULL,
  `How` varchar(255) NOT NULL default '',
  `Languages` varchar(100) NOT NULL default '',
  `Improvements` mediumblob NOT NULL,
  `Pref1` enum('N','Y') NOT NULL default 'N',
  `Pref2` enum('N','Y') NOT NULL default 'N',
  `Pref3` enum('N','Y') NOT NULL default 'N',
  `Pref4` enum('N','Y') NOT NULL default 'N',
  `Field1` varchar(150) NOT NULL default '',
  `Field2` varchar(150) NOT NULL default '',
  `Field3` varchar(150) NOT NULL default '',
  `Field4` varchar(150) NOT NULL default '',
  `Field5` varchar(150) NOT NULL default '',
  `Text1` mediumblob NOT NULL,
  `Text2` mediumblob NOT NULL,
  `Text3` mediumblob NOT NULL,
  `time_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `time_created` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `UName` (`UName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Users`
--


/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
LOCK TABLES `Users` WRITE;
INSERT INTO `Users` VALUES (1,NULL,'Administrator','admin','b2d716fb2328a246e8285f47b1500ebcb349c187','','N','Administrator','','','','AD','','','','','Mr.','M','0-17','','','','','','','','','N','N','N','N','','','','','','','','','2006-06-12 17:01:33','0000-00-00 00:00:00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Users` ENABLE KEYS */;

--
-- Table structure for table `phorum_banlists`
--

DROP TABLE IF EXISTS `phorum_banlists`;
CREATE TABLE `phorum_banlists` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `pcre` tinyint(4) NOT NULL default '0',
  `string` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_banlists`
--


/*!40000 ALTER TABLE `phorum_banlists` DISABLE KEYS */;
LOCK TABLES `phorum_banlists` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_banlists` ENABLE KEYS */;

--
-- Table structure for table `phorum_files`
--

DROP TABLE IF EXISTS `phorum_files`;
CREATE TABLE `phorum_files` (
  `file_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `file_data` mediumtext NOT NULL,
  `add_datetime` int(10) unsigned NOT NULL default '0',
  `message_id` int(10) unsigned NOT NULL default '0',
  `link` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`file_id`),
  KEY `add_datetime` (`add_datetime`),
  KEY `message_id_link` (`message_id`,`link`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_files`
--


/*!40000 ALTER TABLE `phorum_files` DISABLE KEYS */;
LOCK TABLES `phorum_files` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_files` ENABLE KEYS */;

--
-- Table structure for table `phorum_forum_group_xref`
--

DROP TABLE IF EXISTS `phorum_forum_group_xref`;
CREATE TABLE `phorum_forum_group_xref` (
  `forum_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  `permission` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`forum_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_forum_group_xref`
--


/*!40000 ALTER TABLE `phorum_forum_group_xref` DISABLE KEYS */;
LOCK TABLES `phorum_forum_group_xref` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_forum_group_xref` ENABLE KEYS */;

--
-- Table structure for table `phorum_forums`
--

DROP TABLE IF EXISTS `phorum_forums`;
CREATE TABLE `phorum_forums` (
  `forum_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `active` smallint(6) NOT NULL default '0',
  `description` text NOT NULL,
  `template` varchar(50) NOT NULL default '',
  `folder_flag` tinyint(1) NOT NULL default '0',
  `parent_id` int(10) unsigned NOT NULL default '0',
  `list_length_flat` int(10) unsigned NOT NULL default '0',
  `list_length_threaded` int(10) unsigned NOT NULL default '0',
  `moderation` int(10) unsigned NOT NULL default '0',
  `threaded_list` tinyint(4) NOT NULL default '0',
  `threaded_read` tinyint(4) NOT NULL default '0',
  `float_to_top` tinyint(4) NOT NULL default '0',
  `check_duplicate` tinyint(4) NOT NULL default '0',
  `allow_attachment_types` varchar(100) NOT NULL default '',
  `max_attachment_size` int(10) unsigned NOT NULL default '0',
  `max_totalattachment_size` int(10) unsigned NOT NULL default '0',
  `max_attachments` int(10) unsigned NOT NULL default '0',
  `pub_perms` int(10) unsigned NOT NULL default '0',
  `reg_perms` int(10) unsigned NOT NULL default '0',
  `display_ip_address` smallint(5) unsigned NOT NULL default '1',
  `allow_email_notify` smallint(5) unsigned NOT NULL default '1',
  `language` varchar(100) NOT NULL default 'english',
  `email_moderators` tinyint(1) NOT NULL default '0',
  `message_count` int(10) unsigned NOT NULL default '0',
  `sticky_count` int(10) unsigned NOT NULL default '0',
  `thread_count` int(10) unsigned NOT NULL default '0',
  `last_post_time` int(10) unsigned NOT NULL default '0',
  `display_order` int(10) unsigned NOT NULL default '0',
  `read_length` int(10) unsigned NOT NULL default '0',
  `vroot` int(10) unsigned NOT NULL default '0',
  `edit_post` tinyint(1) NOT NULL default '1',
  `template_settings` text NOT NULL,
  `count_views` tinyint(1) unsigned NOT NULL default '0',
  `display_fixed` tinyint(1) unsigned NOT NULL default '0',
  `reverse_threading` tinyint(1) NOT NULL default '0',
  `inherit_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`forum_id`),
  KEY `name` (`name`),
  KEY `active` (`active`,`parent_id`),
  KEY `group_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_forums`
--


/*!40000 ALTER TABLE `phorum_forums` DISABLE KEYS */;
LOCK TABLES `phorum_forums` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_forums` ENABLE KEYS */;

--
-- Table structure for table `phorum_groups`
--

DROP TABLE IF EXISTS `phorum_groups`;
CREATE TABLE `phorum_groups` (
  `group_id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '0',
  `open` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_groups`
--


/*!40000 ALTER TABLE `phorum_groups` DISABLE KEYS */;
LOCK TABLES `phorum_groups` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_groups` ENABLE KEYS */;

--
-- Table structure for table `phorum_messages`
--

DROP TABLE IF EXISTS `phorum_messages`;
CREATE TABLE `phorum_messages` (
  `message_id` int(10) unsigned NOT NULL auto_increment,
  `forum_id` int(10) unsigned NOT NULL default '0',
  `thread` int(10) unsigned NOT NULL default '0',
  `parent_id` int(10) unsigned NOT NULL default '0',
  `author` varchar(37) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `email` varchar(100) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '2',
  `msgid` varchar(100) NOT NULL default '',
  `modifystamp` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `thread_count` int(10) unsigned NOT NULL default '0',
  `moderator_post` tinyint(3) unsigned NOT NULL default '0',
  `sort` tinyint(4) NOT NULL default '2',
  `datestamp` int(10) unsigned NOT NULL default '0',
  `meta` mediumtext NOT NULL,
  `viewcount` int(10) unsigned NOT NULL default '0',
  `closed` tinyint(4) NOT NULL default '0',
  `thread_depth` tinyint(3) unsigned NOT NULL default '0',
  `thread_order` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`message_id`),
  KEY `thread_message` (`thread`,`message_id`),
  KEY `thread_forum` (`thread`,`forum_id`),
  KEY `special_threads` (`sort`,`forum_id`),
  KEY `status_forum` (`status`,`forum_id`),
  KEY `list_page_float` (`forum_id`,`parent_id`,`modifystamp`),
  KEY `list_page_flat` (`forum_id`,`parent_id`,`thread`),
  KEY `post_count` (`forum_id`,`status`,`parent_id`),
  KEY `dup_check` (`forum_id`,`author`,`subject`,`datestamp`),
  KEY `forum_max_message` (`forum_id`,`message_id`,`status`,`parent_id`),
  KEY `last_post_time` (`forum_id`,`status`,`modifystamp`),
  KEY `next_prev_thread` (`forum_id`,`status`,`thread`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_messages`
--


/*!40000 ALTER TABLE `phorum_messages` DISABLE KEYS */;
LOCK TABLES `phorum_messages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_messages` ENABLE KEYS */;

--
-- Table structure for table `phorum_pm_buddies`
--

DROP TABLE IF EXISTS `phorum_pm_buddies`;
CREATE TABLE `phorum_pm_buddies` (
  `pm_buddy_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `buddy_user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pm_buddy_id`),
  UNIQUE KEY `userids` (`user_id`,`buddy_user_id`),
  KEY `buddy_user_id` (`buddy_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_pm_buddies`
--


/*!40000 ALTER TABLE `phorum_pm_buddies` DISABLE KEYS */;
LOCK TABLES `phorum_pm_buddies` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_pm_buddies` ENABLE KEYS */;

--
-- Table structure for table `phorum_pm_folders`
--

DROP TABLE IF EXISTS `phorum_pm_folders`;
CREATE TABLE `phorum_pm_folders` (
  `pm_folder_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `foldername` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`pm_folder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_pm_folders`
--


/*!40000 ALTER TABLE `phorum_pm_folders` DISABLE KEYS */;
LOCK TABLES `phorum_pm_folders` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_pm_folders` ENABLE KEYS */;

--
-- Table structure for table `phorum_pm_messages`
--

DROP TABLE IF EXISTS `phorum_pm_messages`;
CREATE TABLE `phorum_pm_messages` (
  `pm_message_id` int(10) unsigned NOT NULL auto_increment,
  `from_user_id` int(10) unsigned NOT NULL default '0',
  `from_username` varchar(50) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  `message` text NOT NULL,
  `datestamp` int(10) unsigned NOT NULL default '0',
  `meta` mediumtext NOT NULL,
  PRIMARY KEY  (`pm_message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_pm_messages`
--


/*!40000 ALTER TABLE `phorum_pm_messages` DISABLE KEYS */;
LOCK TABLES `phorum_pm_messages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_pm_messages` ENABLE KEYS */;

--
-- Table structure for table `phorum_pm_xref`
--

DROP TABLE IF EXISTS `phorum_pm_xref`;
CREATE TABLE `phorum_pm_xref` (
  `pm_xref_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL default '0',
  `pm_folder_id` int(10) unsigned NOT NULL default '0',
  `special_folder` varchar(10) default NULL,
  `pm_message_id` int(10) unsigned NOT NULL default '0',
  `read_flag` tinyint(1) NOT NULL default '0',
  `reply_flag` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pm_xref_id`),
  KEY `xref` (`user_id`,`pm_folder_id`,`pm_message_id`),
  KEY `read_flag` (`read_flag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_pm_xref`
--


/*!40000 ALTER TABLE `phorum_pm_xref` DISABLE KEYS */;
LOCK TABLES `phorum_pm_xref` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_pm_xref` ENABLE KEYS */;

--
-- Table structure for table `phorum_search`
--

DROP TABLE IF EXISTS `phorum_search`;
CREATE TABLE `phorum_search` (
  `message_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `search_text` mediumtext NOT NULL,
  PRIMARY KEY  (`message_id`),
  KEY `forum_id` (`forum_id`),
  FULLTEXT KEY `search_text` (`search_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_search`
--


/*!40000 ALTER TABLE `phorum_search` DISABLE KEYS */;
LOCK TABLES `phorum_search` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_search` ENABLE KEYS */;

--
-- Table structure for table `phorum_settings`
--

DROP TABLE IF EXISTS `phorum_settings`;
CREATE TABLE `phorum_settings` (
  `name` varchar(255) NOT NULL default '',
  `type` enum('V','S') NOT NULL default 'V',
  `data` text NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_settings`
--


/*!40000 ALTER TABLE `phorum_settings` DISABLE KEYS */;
LOCK TABLES `phorum_settings` WRITE;
INSERT INTO `phorum_settings` VALUES ('title','V','Phorum 5'),('cache','V','/tmp'),('session_timeout','V','30'),('short_session_timeout','V','60'),('tight_security','V','0'),('session_path','V','/'),('session_domain','V',''),('admin_session_salt','V','0.62629000 1146135136'),('cache_users','V','0'),('register_email_confirm','V','0'),('default_template','V','default'),('default_language','V','english'),('use_cookies','V','1'),('use_bcc','V','1'),('use_rss','V','1'),('internal_version','V','2006032300'),('PROFILE_FIELDS','S','a:1:{i:0;a:3:{s:4:\"name\";s:9:\"real_name\";s:6:\"length\";i:255;s:13:\"html_disabled\";i:1;}}'),('enable_pm','V','0'),('user_edit_timelimit','V','0'),('enable_new_pm_count','V','1'),('enable_dropdown_userlist','V','1'),('enable_moderator_notifications','V','1'),('show_new_on_index','V','1'),('dns_lookup','V','1'),('tz_offset','V','0'),('user_time_zone','V','1'),('user_template','V','0'),('registration_control','V','1'),('file_uploads','V','0'),('file_types','V',''),('max_file_size','V',''),('file_space_quota','V',''),('file_offsite','V','0'),('system_email_from_name','V',''),('hide_forums','V','1'),('track_user_activity','V','86400'),('html_title','V','Phorum'),('head_tags','V',''),('redirect_after_post','V','list'),('reply_on_read_page','V','1'),('status','V','normal'),('use_new_folder_style','V','1'),('default_forum_options','S','a:24:{s:8:\"forum_id\";i:0;s:10:\"moderation\";i:0;s:16:\"email_moderators\";i:0;s:9:\"pub_perms\";i:1;s:9:\"reg_perms\";i:15;s:13:\"display_fixed\";i:0;s:8:\"template\";s:7:\"default\";s:8:\"language\";s:7:\"english\";s:13:\"threaded_list\";i:0;s:13:\"threaded_read\";i:0;s:17:\"reverse_threading\";i:0;s:12:\"float_to_top\";i:1;s:16:\"list_length_flat\";i:30;s:20:\"list_length_threaded\";i:15;s:11:\"read_length\";i:30;s:18:\"display_ip_address\";i:0;s:18:\"allow_email_notify\";i:0;s:15:\"check_duplicate\";i:1;s:11:\"count_views\";i:2;s:15:\"max_attachments\";i:0;s:22:\"allow_attachment_types\";s:0:\"\";s:19:\"max_attachment_size\";i:0;s:24:\"max_totalattachment_size\";i:0;s:5:\"vroot\";i:0;}'),('hooks','S','a:1:{s:6:\"format\";a:2:{s:4:\"mods\";a:2:{i:0;s:7:\"smileys\";i:1;s:6:\"bbcode\";}s:5:\"funcs\";a:2:{i:0;s:18:\"phorum_mod_smileys\";i:1;s:14:\"phorum_bb_code\";}}}'),('mods','S','a:4:{s:4:\"html\";i:0;s:7:\"replace\";i:0;s:7:\"smileys\";i:1;s:6:\"bbcode\";i:1;}');
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_settings` ENABLE KEYS */;

--
-- Table structure for table `phorum_subscribers`
--

DROP TABLE IF EXISTS `phorum_subscribers`;
CREATE TABLE `phorum_subscribers` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `sub_type` int(10) unsigned NOT NULL default '0',
  `thread` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`forum_id`,`thread`),
  KEY `forum_id` (`forum_id`,`thread`,`sub_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_subscribers`
--


/*!40000 ALTER TABLE `phorum_subscribers` DISABLE KEYS */;
LOCK TABLES `phorum_subscribers` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_subscribers` ENABLE KEYS */;

--
-- Table structure for table `phorum_user_custom_fields`
--

DROP TABLE IF EXISTS `phorum_user_custom_fields`;
CREATE TABLE `phorum_user_custom_fields` (
  `user_id` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `data` text NOT NULL,
  PRIMARY KEY  (`user_id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_user_custom_fields`
--


/*!40000 ALTER TABLE `phorum_user_custom_fields` DISABLE KEYS */;
LOCK TABLES `phorum_user_custom_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_user_custom_fields` ENABLE KEYS */;

--
-- Table structure for table `phorum_user_group_xref`
--

DROP TABLE IF EXISTS `phorum_user_group_xref`;
CREATE TABLE `phorum_user_group_xref` (
  `user_id` int(11) NOT NULL default '0',
  `group_id` int(11) NOT NULL default '0',
  `status` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`user_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_user_group_xref`
--


/*!40000 ALTER TABLE `phorum_user_group_xref` DISABLE KEYS */;
LOCK TABLES `phorum_user_group_xref` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_user_group_xref` ENABLE KEYS */;

--
-- Table structure for table `phorum_user_newflags`
--

DROP TABLE IF EXISTS `phorum_user_newflags`;
CREATE TABLE `phorum_user_newflags` (
  `user_id` int(11) NOT NULL default '0',
  `forum_id` int(11) NOT NULL default '0',
  `message_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`forum_id`,`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_user_newflags`
--


/*!40000 ALTER TABLE `phorum_user_newflags` DISABLE KEYS */;
LOCK TABLES `phorum_user_newflags` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_user_newflags` ENABLE KEYS */;

--
-- Table structure for table `phorum_user_permissions`
--

DROP TABLE IF EXISTS `phorum_user_permissions`;
CREATE TABLE `phorum_user_permissions` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `forum_id` int(10) unsigned NOT NULL default '0',
  `permission` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`forum_id`),
  KEY `forum_id` (`forum_id`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_user_permissions`
--


/*!40000 ALTER TABLE `phorum_user_permissions` DISABLE KEYS */;
LOCK TABLES `phorum_user_permissions` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_user_permissions` ENABLE KEYS */;

--
-- Table structure for table `phorum_users`
--

DROP TABLE IF EXISTS `phorum_users`;
CREATE TABLE `phorum_users` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `fk_campsite_user_id` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `cookie_sessid_lt` varchar(50) NOT NULL default '',
  `sessid_st` varchar(50) NOT NULL default '',
  `sessid_st_timeout` int(10) unsigned NOT NULL default '0',
  `password_temp` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `email_temp` varchar(110) NOT NULL default '',
  `hide_email` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `user_data` text NOT NULL,
  `signature` text NOT NULL,
  `threaded_list` tinyint(4) NOT NULL default '0',
  `posts` int(10) NOT NULL default '0',
  `admin` tinyint(1) NOT NULL default '0',
  `threaded_read` tinyint(4) NOT NULL default '0',
  `date_added` int(10) unsigned NOT NULL default '0',
  `date_last_active` int(10) unsigned NOT NULL default '0',
  `last_active_forum` int(10) unsigned NOT NULL default '0',
  `hide_activity` tinyint(1) NOT NULL default '0',
  `show_signature` tinyint(1) NOT NULL default '0',
  `email_notify` tinyint(1) NOT NULL default '0',
  `pm_email_notify` tinyint(1) NOT NULL default '1',
  `tz_offset` tinyint(2) NOT NULL default '-99',
  `is_dst` tinyint(1) NOT NULL default '0',
  `user_language` varchar(100) NOT NULL default '',
  `user_template` varchar(100) NOT NULL default '',
  `moderator_data` text NOT NULL,
  `moderation_email` tinyint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `fk_campsite_user_id` (`fk_campsite_user_id`),
  UNIQUE KEY `username` (`username`),
  KEY `active` (`active`),
  KEY `userpass` (`username`,`password`),
  KEY `sessid_st` (`sessid_st`),
  KEY `cookie_sessid_lt` (`cookie_sessid_lt`),
  KEY `activity` (`date_last_active`,`hide_activity`,`last_active_forum`),
  KEY `date_added` (`date_added`),
  KEY `email_temp` (`email_temp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phorum_users`
--


/*!40000 ALTER TABLE `phorum_users` DISABLE KEYS */;
LOCK TABLES `phorum_users` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `phorum_users` ENABLE KEYS */;

/*!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 */;

