✘✘ GRAYBYTE WORDPRESS FILE MANAGER ✘✘

🇳🇦🇲🇪♯➤ cp240.webserver.pt 🇻♯➤ 4.18.0-553.121.1.lve.el8.x86_64 #1 SMP 🇾♯➤ 2026

𝗛𝗢𝗠𝗘 𝗜𝗗 ♯➤ 62.193.192.154 ♯➤ 𝗔𝗗𝗠𝗜𝗡 𝗜𝗗 216.73.216.227
𝗢𝗣𝗧𝗜𝗢𝗡𝗦 ♯ CRL ♯➤ 𝗢𝗞 ┃ WGT ♯➤ 𝗢𝗞 ┃ SDO ♯➤ 𝗢𝗙𝗙 ┃ PKEX ♯➤ 𝗢𝗙𝗙
𝗗𝗘𝗔𝗖𝗧𝗜𝗩𝗔𝗧𝗘𝗗 ♯➤ 𝗔𝗟𝗟 𝗪𝗢𝗥𝗞𝗜𝗡𝗚....
𝗖𝗨𝗥𝗥𝗘𝗡𝗧 𝗙𝗜𝗟𝗘 : /home/albatroz/cpmove_failed_mysql_dbs.1544892912//albatroz_wcms1.sql
-- MySQL dump 10.13  Distrib 5.5.61, for Linux (x86_64)
--
-- Host: localhost    Database: albatroz_wcms1
-- ------------------------------------------------------
-- Server version	5.5.61-cll

/*!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 utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `phpwcms_address`
--

DROP TABLE IF EXISTS `phpwcms_address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_address` (
  `address_id` int(11) NOT NULL AUTO_INCREMENT,
  `address_key` varchar(255) NOT NULL DEFAULT '',
  `address_email` text NOT NULL,
  `address_name` text NOT NULL,
  `address_verified` int(1) NOT NULL DEFAULT '0',
  `address_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address_subscription` blob NOT NULL,
  `address_iddetail` int(11) NOT NULL DEFAULT '0',
  `address_url1` varchar(255) NOT NULL DEFAULT '',
  `address_url2` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_address`
--

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

--
-- Table structure for table `phpwcms_ads_campaign`
--

DROP TABLE IF EXISTS `phpwcms_ads_campaign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_ads_campaign` (
  `adcampaign_id` int(11) NOT NULL AUTO_INCREMENT,
  `adcampaign_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adcampaign_changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adcampaign_status` int(1) NOT NULL DEFAULT '0',
  `adcampaign_title` varchar(255) NOT NULL DEFAULT '',
  `adcampaign_comment` text NOT NULL,
  `adcampaign_datestart` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adcampaign_dateend` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adcampaign_maxview` int(11) NOT NULL DEFAULT '0',
  `adcampaign_maxclick` int(11) NOT NULL DEFAULT '0',
  `adcampaign_maxviewuser` int(11) NOT NULL DEFAULT '0',
  `adcampaign_curview` int(11) NOT NULL DEFAULT '0',
  `adcampaign_curclick` int(11) NOT NULL DEFAULT '0',
  `adcampaign_curviewuser` int(11) NOT NULL DEFAULT '0',
  `adcampaign_type` int(11) NOT NULL DEFAULT '0',
  `adcampaign_place` int(11) NOT NULL DEFAULT '0',
  `adcampaign_data` mediumtext NOT NULL,
  PRIMARY KEY (`adcampaign_id`),
  KEY `adcampaign_status` (`adcampaign_status`,`adcampaign_datestart`,`adcampaign_dateend`,`adcampaign_type`,`adcampaign_place`),
  KEY `adcampaign_maxview` (`adcampaign_maxview`,`adcampaign_maxclick`,`adcampaign_maxviewuser`),
  KEY `adcampaign_curview` (`adcampaign_curview`,`adcampaign_curclick`,`adcampaign_curviewuser`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_ads_campaign`
--

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

--
-- Table structure for table `phpwcms_ads_formats`
--

DROP TABLE IF EXISTS `phpwcms_ads_formats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_ads_formats` (
  `adformat_id` int(11) NOT NULL AUTO_INCREMENT,
  `adformat_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adformat_changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adformat_status` int(1) NOT NULL DEFAULT '0',
  `adformat_title` varchar(25) NOT NULL DEFAULT '',
  `adformat_width` int(5) NOT NULL DEFAULT '0',
  `adformat_height` int(5) NOT NULL DEFAULT '0',
  `adformat_comment` text NOT NULL,
  PRIMARY KEY (`adformat_id`),
  KEY `adformat_status` (`adformat_status`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_ads_formats`
--

LOCK TABLES `phpwcms_ads_formats` WRITE;
/*!40000 ALTER TABLE `phpwcms_ads_formats` DISABLE KEYS */;
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES (1,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Leaderboard',728,90,''),(2,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Banner',468,60,''),(3,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Small Square',200,200,''),(4,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Square',250,250,''),(5,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Medium Rectangle',300,250,''),(6,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Large Rectangle',336,280,''),(7,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Skyscraper',120,600,''),(8,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Wide Skyscraper',160,600,''),(10,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Half Banner',234,60,''),(11,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Square Button',125,125,''),(12,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Small Rectangle',180,150,''),(13,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Vertical Banner',120,240,''),(14,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Mini Square',120,120,''),(15,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Medium Scyscraper',120,450,''),(16,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Micro Bar',88,31,''),(17,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Vertical Rectangle',240,400,''),(18,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Vertical Button',120,90,''),(19,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Half Mini Square',120,60,''),(20,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Half Page Ad',300,600,''),(21,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Universal Flash Layer',400,400,''),(22,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'PopUp',250,300,''),(23,'2007-03-19 22:30:42','2007-03-19 22:30:42',1,'Target Button',120,150,'');
/*!40000 ALTER TABLE `phpwcms_ads_formats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_ads_place`
--

DROP TABLE IF EXISTS `phpwcms_ads_place`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_ads_place` (
  `adplace_id` int(11) NOT NULL AUTO_INCREMENT,
  `adplace_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adplace_changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adplace_status` int(1) NOT NULL DEFAULT '0',
  `adplace_title` varchar(255) NOT NULL DEFAULT '',
  `adplace_format` int(11) NOT NULL DEFAULT '0',
  `adplace_width` int(11) NOT NULL DEFAULT '0',
  `adplace_height` int(11) NOT NULL DEFAULT '0',
  `adplace_prefix` varchar(255) NOT NULL DEFAULT '',
  `adplace_suffix` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`adplace_id`),
  KEY `adplace_status` (`adplace_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_ads_place`
--

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

--
-- Table structure for table `phpwcms_ads_tracking`
--

DROP TABLE IF EXISTS `phpwcms_ads_tracking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_ads_tracking` (
  `adtracking_id` int(11) NOT NULL AUTO_INCREMENT,
  `adtracking_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `adtracking_campaignid` int(11) NOT NULL DEFAULT '0',
  `adtracking_ip` varchar(30) NOT NULL DEFAULT '',
  `adtracking_cookieid` varchar(50) NOT NULL DEFAULT '',
  `adtracking_countclick` int(11) NOT NULL DEFAULT '0',
  `adtracking_countview` int(11) NOT NULL DEFAULT '0',
  `adtracking_useragent` varchar(255) NOT NULL DEFAULT '',
  `adtracking_ref` text NOT NULL,
  `adtracking_catid` int(11) NOT NULL DEFAULT '0',
  `adtracking_articleid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`adtracking_id`),
  KEY `adtracking_campaignid` (`adtracking_campaignid`,`adtracking_ip`,`adtracking_countclick`,`adtracking_countview`),
  KEY `adtracking_cookieid` (`adtracking_cookieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_ads_tracking`
--

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

--
-- Table structure for table `phpwcms_article`
--

DROP TABLE IF EXISTS `phpwcms_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_article` (
  `article_id` int(11) NOT NULL AUTO_INCREMENT,
  `article_cid` int(11) NOT NULL DEFAULT '0',
  `article_tid` int(11) NOT NULL DEFAULT '0',
  `article_uid` int(11) NOT NULL DEFAULT '0',
  `article_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `article_username` varchar(255) NOT NULL DEFAULT '',
  `article_title` text NOT NULL,
  `article_alias` varchar(255) NOT NULL DEFAULT '',
  `article_keyword` text NOT NULL,
  `article_public` int(1) NOT NULL DEFAULT '0',
  `article_deleted` int(1) NOT NULL DEFAULT '0',
  `article_begin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `article_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `article_aktiv` int(1) NOT NULL DEFAULT '0',
  `article_subtitle` text NOT NULL,
  `article_summary` text NOT NULL,
  `article_redirect` text NOT NULL,
  `article_sort` int(11) NOT NULL DEFAULT '0',
  `article_notitle` int(1) NOT NULL DEFAULT '0',
  `article_hidesummary` int(1) NOT NULL DEFAULT '0',
  `article_image` blob NOT NULL,
  `article_created` varchar(14) NOT NULL DEFAULT '',
  `article_cache` varchar(10) NOT NULL DEFAULT '0',
  `article_nosearch` char(1) NOT NULL DEFAULT '0',
  `article_nositemap` int(1) NOT NULL DEFAULT '0',
  `article_aliasid` int(11) NOT NULL DEFAULT '0',
  `article_headerdata` int(1) NOT NULL DEFAULT '0',
  `article_morelink` int(1) NOT NULL DEFAULT '1',
  `article_pagetitle` varchar(255) NOT NULL DEFAULT '',
  `article_paginate` int(1) NOT NULL DEFAULT '0',
  `article_serialized` blob NOT NULL,
  `article_priorize` int(5) NOT NULL DEFAULT '0',
  `article_norss` int(1) NOT NULL DEFAULT '1',
  `article_archive_status` int(1) NOT NULL DEFAULT '1',
  `article_menutitle` varchar(255) NOT NULL,
  PRIMARY KEY (`article_id`),
  KEY `article_aktiv` (`article_aktiv`),
  KEY `article_public` (`article_public`),
  KEY `article_deleted` (`article_deleted`),
  KEY `article_nosearch` (`article_nosearch`),
  KEY `article_begin` (`article_begin`),
  KEY `article_end` (`article_end`),
  KEY `article_cid` (`article_cid`),
  KEY `article_tstamp` (`article_tstamp`),
  KEY `article_priorize` (`article_priorize`),
  KEY `article_sort` (`article_sort`),
  KEY `article_alias` (`article_alias`),
  KEY `article_archive_status` (`article_archive_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_article`
--

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

--
-- Table structure for table `phpwcms_articlecat`
--

DROP TABLE IF EXISTS `phpwcms_articlecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_articlecat` (
  `acat_id` int(11) NOT NULL AUTO_INCREMENT,
  `acat_name` text NOT NULL,
  `acat_info` text NOT NULL,
  `acat_public` int(1) NOT NULL DEFAULT '0',
  `acat_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `acat_aktiv` int(1) NOT NULL DEFAULT '0',
  `acat_uid` int(11) NOT NULL DEFAULT '0',
  `acat_trash` int(1) NOT NULL DEFAULT '0',
  `acat_struct` int(11) NOT NULL DEFAULT '0',
  `acat_sort` int(11) NOT NULL DEFAULT '0',
  `acat_alias` varchar(250) NOT NULL DEFAULT '',
  `acat_hidden` int(1) NOT NULL DEFAULT '0',
  `acat_template` int(11) NOT NULL DEFAULT '0',
  `acat_ssl` int(1) NOT NULL DEFAULT '0',
  `acat_regonly` int(1) NOT NULL DEFAULT '0',
  `acat_topcount` int(11) NOT NULL DEFAULT '0',
  `acat_redirect` text NOT NULL,
  `acat_order` int(2) NOT NULL DEFAULT '0',
  `acat_cache` varchar(10) NOT NULL DEFAULT '',
  `acat_nosearch` char(1) NOT NULL DEFAULT '',
  `acat_nositemap` int(1) NOT NULL DEFAULT '0',
  `acat_permit` text NOT NULL,
  `acat_maxlist` int(11) NOT NULL DEFAULT '0',
  `acat_cntpart` varchar(255) NOT NULL DEFAULT '',
  `acat_pagetitle` varchar(255) NOT NULL DEFAULT '',
  `acat_paginate` int(1) NOT NULL DEFAULT '0',
  `acat_overwrite` varchar(255) NOT NULL DEFAULT '',
  `acat_archive` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`acat_id`),
  KEY `acat_struct` (`acat_struct`),
  KEY `acat_sort` (`acat_sort`),
  KEY `acat_alias` (`acat_alias`),
  KEY `acat_archive` (`acat_archive`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_articlecat`
--

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

--
-- Table structure for table `phpwcms_articlecontent`
--

DROP TABLE IF EXISTS `phpwcms_articlecontent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_articlecontent` (
  `acontent_id` int(11) NOT NULL AUTO_INCREMENT,
  `acontent_aid` int(11) NOT NULL DEFAULT '0',
  `acontent_uid` int(11) NOT NULL DEFAULT '0',
  `acontent_created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `acontent_tstamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `acontent_title` text NOT NULL,
  `acontent_text` text NOT NULL,
  `acontent_type` int(10) NOT NULL DEFAULT '0',
  `acontent_sorting` int(11) NOT NULL DEFAULT '0',
  `acontent_image` text NOT NULL,
  `acontent_files` text NOT NULL,
  `acontent_visible` int(1) NOT NULL DEFAULT '0',
  `acontent_subtitle` text NOT NULL,
  `acontent_before` varchar(10) NOT NULL DEFAULT '',
  `acontent_after` varchar(10) NOT NULL DEFAULT '',
  `acontent_top` int(1) NOT NULL DEFAULT '0',
  `acontent_redirect` text NOT NULL,
  `acontent_html` text NOT NULL,
  `acontent_trash` int(1) NOT NULL DEFAULT '0',
  `acontent_alink` text NOT NULL,
  `acontent_media` text NOT NULL,
  `acontent_form` mediumtext NOT NULL,
  `acontent_newsletter` mediumtext NOT NULL,
  `acontent_block` varchar(200) NOT NULL DEFAULT '0',
  `acontent_anchor` int(1) NOT NULL DEFAULT '0',
  `acontent_template` varchar(255) NOT NULL DEFAULT '',
  `acontent_spacer` int(1) NOT NULL DEFAULT '0',
  `acontent_tid` int(11) NOT NULL DEFAULT '0',
  `acontent_livedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `acontent_killdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `acontent_module` varchar(255) NOT NULL DEFAULT '',
  `acontent_comment` text NOT NULL,
  `acontent_paginate_page` int(5) NOT NULL DEFAULT '0',
  `acontent_paginate_title` varchar(255) NOT NULL DEFAULT '',
  `acontent_category` varchar(255) NOT NULL,
  `acontent_granted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`acontent_id`),
  KEY `acontent_aid` (`acontent_aid`),
  KEY `acontent_sorting` (`acontent_sorting`),
  KEY `acontent_type` (`acontent_type`),
  KEY `acontent_livedate` (`acontent_livedate`,`acontent_killdate`),
  KEY `acontent_paginate` (`acontent_paginate_page`),
  KEY `acontent_granted` (`acontent_granted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_articlecontent`
--

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

--
-- Table structure for table `phpwcms_bad_behavior`
--

DROP TABLE IF EXISTS `phpwcms_bad_behavior`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_bad_behavior` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `request_method` text NOT NULL,
  `request_uri` text NOT NULL,
  `server_protocol` text NOT NULL,
  `http_headers` text NOT NULL,
  `user_agent` text NOT NULL,
  `request_entity` text NOT NULL,
  `key` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ip` (`ip`(15)),
  KEY `user_agent` (`user_agent`(10))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_bad_behavior`
--

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

--
-- Table structure for table `phpwcms_bid`
--

DROP TABLE IF EXISTS `phpwcms_bid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_bid` (
  `bid_id` int(11) NOT NULL AUTO_INCREMENT,
  `bid_cid` int(11) NOT NULL DEFAULT '0',
  `bid_email` text NOT NULL,
  `bid_hash` varchar(255) NOT NULL DEFAULT '',
  `bid_amount` float NOT NULL DEFAULT '0',
  `bid_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bid_verified` int(1) NOT NULL DEFAULT '0',
  `bid_trashed` int(1) NOT NULL DEFAULT '0',
  `bid_vars` mediumblob NOT NULL,
  PRIMARY KEY (`bid_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_bid`
--

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

--
-- Table structure for table `phpwcms_cache`
--

DROP TABLE IF EXISTS `phpwcms_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_cache` (
  `cache_id` int(11) NOT NULL AUTO_INCREMENT,
  `cache_hash` varchar(50) NOT NULL DEFAULT '',
  `cache_uri` text NOT NULL,
  `cache_cid` int(11) NOT NULL DEFAULT '0',
  `cache_aid` int(11) NOT NULL DEFAULT '0',
  `cache_timeout` varchar(20) NOT NULL DEFAULT '0',
  `cache_isprint` int(1) NOT NULL DEFAULT '0',
  `cache_changed` int(14) DEFAULT NULL,
  `cache_use` int(1) NOT NULL DEFAULT '0',
  `cache_searchable` int(1) NOT NULL DEFAULT '0',
  `cache_page` longtext NOT NULL,
  `cache_stripped` longtext NOT NULL,
  PRIMARY KEY (`cache_id`),
  KEY `cache_hash` (`cache_hash`),
  FULLTEXT KEY `cache_stripped` (`cache_stripped`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_cache`
--

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

--
-- Table structure for table `phpwcms_calendar`
--

DROP TABLE IF EXISTS `phpwcms_calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_calendar` (
  `calendar_id` int(11) NOT NULL AUTO_INCREMENT,
  `calendar_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `calendar_changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `calendar_status` int(1) NOT NULL DEFAULT '0',
  `calendar_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `calendar_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `calendar_allday` int(1) NOT NULL DEFAULT '0',
  `calendar_range` int(1) NOT NULL DEFAULT '0',
  `calendar_range_start` date NOT NULL DEFAULT '0000-00-00',
  `calendar_range_end` date NOT NULL DEFAULT '0000-00-00',
  `calendar_title` varchar(255) NOT NULL DEFAULT '',
  `calendar_where` varchar(255) NOT NULL DEFAULT '',
  `calendar_teaser` text NOT NULL,
  `calendar_text` mediumtext NOT NULL,
  `calendar_tag` varchar(255) NOT NULL DEFAULT '',
  `calendar_object` longtext NOT NULL,
  `calendar_refid` int(11) NOT NULL DEFAULT '0',
  `calendar_lang` varchar(255) NOT NULL,
  PRIMARY KEY (`calendar_id`),
  KEY `calendar_status` (`calendar_status`),
  KEY `calendar_start` (`calendar_start`),
  KEY `calendar_end` (`calendar_end`),
  KEY `calendar_tag` (`calendar_tag`),
  KEY `calendar_refid` (`calendar_refid`),
  KEY `calendar_range` (`calendar_range`),
  KEY `calendar_lang` (`calendar_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_calendar`
--

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

--
-- Table structure for table `phpwcms_categories`
--

DROP TABLE IF EXISTS `phpwcms_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_categories` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_type` varchar(255) NOT NULL DEFAULT '',
  `cat_pid` int(11) NOT NULL DEFAULT '0',
  `cat_status` int(1) NOT NULL DEFAULT '0',
  `cat_createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cat_changedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cat_name` varchar(255) NOT NULL DEFAULT '',
  `cat_info` text NOT NULL,
  PRIMARY KEY (`cat_id`),
  KEY `cat_type` (`cat_type`,`cat_status`),
  KEY `cat_pid` (`cat_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_categories`
--

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

--
-- Table structure for table `phpwcms_chat`
--

DROP TABLE IF EXISTS `phpwcms_chat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_chat` (
  `chat_id` int(11) NOT NULL AUTO_INCREMENT,
  `chat_uid` int(11) NOT NULL DEFAULT '0',
  `chat_name` varchar(30) NOT NULL DEFAULT '',
  `chat_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `chat_text` varchar(255) NOT NULL DEFAULT '',
  `chat_cat` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`chat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_chat`
--

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

--
-- Table structure for table `phpwcms_content`
--

DROP TABLE IF EXISTS `phpwcms_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_content` (
  `cnt_id` int(11) NOT NULL AUTO_INCREMENT,
  `cnt_pid` int(11) NOT NULL DEFAULT '0',
  `cnt_created` int(11) NOT NULL DEFAULT '0',
  `cnt_changed` int(11) NOT NULL DEFAULT '0',
  `cnt_status` int(1) NOT NULL DEFAULT '0',
  `cnt_type` varchar(255) NOT NULL,
  `cnt_module` varchar(255) NOT NULL,
  `cnt_group` int(11) NOT NULL DEFAULT '0',
  `cnt_owner` int(11) NOT NULL DEFAULT '0',
  `cnt_livedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cnt_killdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cnt_archive_status` int(11) NOT NULL DEFAULT '0',
  `cnt_sort` int(11) NOT NULL DEFAULT '0',
  `cnt_prio` int(11) NOT NULL DEFAULT '0',
  `cnt_alias` varchar(255) NOT NULL,
  `cnt_name` varchar(255) NOT NULL DEFAULT '',
  `cnt_title` varchar(255) NOT NULL DEFAULT '',
  `cnt_subtitle` varchar(255) NOT NULL DEFAULT '',
  `cnt_editor` varchar(255) NOT NULL,
  `cnt_place` varchar(255) NOT NULL,
  `cnt_teasertext` text NOT NULL,
  `cnt_text` text NOT NULL,
  `cnt_lang` varchar(10) NOT NULL DEFAULT '',
  `cnt_object` text NOT NULL,
  PRIMARY KEY (`cnt_id`),
  KEY `cnt_livedate` (`cnt_livedate`),
  KEY `cnt_killdate` (`cnt_killdate`),
  KEY `cnt_module` (`cnt_module`),
  KEY `cnt_type` (`cnt_type`),
  KEY `cnt_group` (`cnt_group`),
  KEY `cnt_owner` (`cnt_owner`),
  KEY `cnt_alias` (`cnt_alias`),
  KEY `cnt_pid` (`cnt_pid`),
  KEY `cnt_sort` (`cnt_sort`),
  KEY `cnt_prio` (`cnt_prio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_content`
--

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

--
-- Table structure for table `phpwcms_country`
--

DROP TABLE IF EXISTS `phpwcms_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_country` (
  `country_id` int(4) NOT NULL AUTO_INCREMENT,
  `country_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `country_iso` char(2) NOT NULL DEFAULT '',
  `country_iso3` char(3) NOT NULL DEFAULT '',
  `country_isonum` int(11) NOT NULL DEFAULT '0',
  `country_continent_code` char(2) NOT NULL DEFAULT '',
  `country_name` varchar(100) NOT NULL,
  `country_name_de` varchar(255) NOT NULL,
  `country_continent` varchar(255) NOT NULL DEFAULT '',
  `country_continent_de` varchar(255) NOT NULL DEFAULT '',
  `country_region` varchar(255) NOT NULL DEFAULT '',
  `country_region_de` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`country_id`),
  UNIQUE KEY `country_iso` (`country_iso`),
  UNIQUE KEY `country_name` (`country_name`)
) ENGINE=MyISAM AUTO_INCREMENT=249 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_country`
--

LOCK TABLES `phpwcms_country` WRITE;
/*!40000 ALTER TABLE `phpwcms_country` DISABLE KEYS */;
INSERT INTO `phpwcms_country` (`country_id`, `country_updated`, `country_iso`, `country_iso3`, `country_isonum`, `country_continent_code`, `country_name`, `country_name_de`, `country_continent`, `country_continent_de`, `country_region`, `country_region_de`) VALUES (1,'0000-00-00 00:00:00','AF','AFG',4,'AS','Afghanistan, Islamic Republic of','Afghanistan','Asia','Asien','',''),(2,'0000-00-00 00:00:00','AL','ALB',8,'EU','Albania, Republic of','Albanien','Europe','Europa','',''),(3,'0000-00-00 00:00:00','DZ','DZA',12,'AF','Algeria, People\'s Democratic Republic of','Algerien','Africa','Afrika','',''),(4,'0000-00-00 00:00:00','AS','ASM',16,'OC','American Samoa','Amerikanisch Samoa','Oceania','Ozeanien','',''),(5,'0000-00-00 00:00:00','AD','AND',20,'EU','Andorra, Principality of','Andorra','Europe','Europa','',''),(6,'0000-00-00 00:00:00','AO','AGO',24,'AF','Angola, Republic of','Angola','Africa','Afrika','',''),(7,'0000-00-00 00:00:00','AI','AIA',660,'NA','Anguilla','Anguilla','North America','Nordamerika','',''),(8,'0000-00-00 00:00:00','AQ','ATA',10,'AN','Antarctica (the territory South of 60 deg S)','Antarktis','Antarctica','Antarktis','',''),(9,'0000-00-00 00:00:00','AG','ATG',28,'NA','Antigua and Barbuda','Antigua und Barbuda','North America','Nordamerika','',''),(10,'0000-00-00 00:00:00','AR','ARG',32,'SA','Argentina, Argentine Republic','Argentinien','South America','SÃ¼damerika','',''),(11,'0000-00-00 00:00:00','AM','ARM',51,'AS','Armenia, Republic of','Armenien','Asia','Asien','',''),(12,'0000-00-00 00:00:00','AW','ABW',533,'NA','Aruba','Aruba','North America','Nordamerika','',''),(13,'0000-00-00 00:00:00','AU','AUS',36,'OC','Australia, Commonwealth of','Australien','Oceania','Ozeanien','',''),(14,'0000-00-00 00:00:00','AT','AUT',40,'EU','Austria, Republic of','Ã–sterreich','Europe','Europa','',''),(15,'0000-00-00 00:00:00','AZ','AZE',31,'AS','Azerbaijan, Republic of','Aserbaidschan','Asia','Asien','',''),(16,'0000-00-00 00:00:00','BS','BHS',44,'NA','Bahamas, Commonwealth of the','Bahamas','North America','Nordamerika','',''),(17,'0000-00-00 00:00:00','BH','BHR',48,'AS','Bahrain, Kingdom of','Bahrain','Asia','Asien','',''),(18,'0000-00-00 00:00:00','BD','BGD',50,'AS','Bangladesh, People\'s Republic of','Bangladesch','Asia','Asien','',''),(19,'0000-00-00 00:00:00','BB','BRB',52,'NA','Barbados','Barbados','North America','Nordamerika','',''),(20,'0000-00-00 00:00:00','BY','BLR',112,'EU','Belarus, Republic of','Belarus','Europe','Europa','',''),(21,'0000-00-00 00:00:00','BE','BEL',56,'EU','Belgium, Kingdom of','Belgien','Europe','Europa','',''),(22,'0000-00-00 00:00:00','BZ','BLZ',84,'NA','Belize','Belize','North America','Nordamerika','',''),(23,'0000-00-00 00:00:00','BJ','BEN',204,'AF','Benin, Republic of','Benin','Africa','Afrika','',''),(24,'0000-00-00 00:00:00','BM','BMU',60,'NA','Bermuda','Bermuda','North America','Nordamerika','',''),(25,'0000-00-00 00:00:00','BT','BTN',64,'AS','Bhutan, Kingdom of','Bhutan','Asia','Asien','',''),(26,'0000-00-00 00:00:00','BO','BOL',68,'SA','Bolivia, Republic of','Bolivien','South America','SÃ¼damerika','',''),(27,'0000-00-00 00:00:00','BA','BIH',70,'EU','Bosnia and Herzegovina','Bosnien und Herzegowina','Europe','Europa','',''),(28,'0000-00-00 00:00:00','BW','BWA',72,'AF','Botswana, Republic of','Botsuana','Africa','Afrika','',''),(29,'0000-00-00 00:00:00','BV','BVT',74,'AN','Bouvet Island (Bouvetoya)','Bouvet-Insel','Antarctica','Antarktis','',''),(30,'0000-00-00 00:00:00','BR','BRA',76,'SA','Brazil, Federative Republic of','Brasilien','South America','SÃ¼damerika','',''),(31,'0000-00-00 00:00:00','IO','IOT',86,'AS','British Indian Ocean Territory (Chagos Archipelago)','Britisches Territorium Im Indischen Ozean','Asia','Asien','',''),(32,'0000-00-00 00:00:00','BN','BRN',96,'AS','Brunei Darussalam','Brunei Darussalam','Asia','Asien','',''),(33,'0000-00-00 00:00:00','BG','BGR',100,'EU','Bulgaria, Republic of','Bulgarien','Europe','Europa','',''),(34,'0000-00-00 00:00:00','BF','BFA',854,'AF','Burkina Faso','Burkina Faso','Africa','Afrika','',''),(35,'0000-00-00 00:00:00','BI','BDI',108,'AF','Burundi, Republic of','Burundi','Africa','Afrika','',''),(36,'0000-00-00 00:00:00','KH','KHM',116,'AS','Cambodia, Kingdom of','Kambodscha','Asia','Asien','',''),(37,'0000-00-00 00:00:00','CM','CMR',120,'AF','Cameroon, Republic of','Kamerun','Africa','Afrika','',''),(38,'0000-00-00 00:00:00','CA','CAN',124,'NA','Canada','Kanada','North America','Nordamerika','',''),(39,'0000-00-00 00:00:00','CV','CPV',132,'AF','Cape Verde, Republic of','Kap Verde','Africa','Afrika','',''),(40,'0000-00-00 00:00:00','KY','CYM',136,'NA','Cayman Islands','Kaimaninseln','North America','Nordamerika','',''),(41,'0000-00-00 00:00:00','CF','CAF',140,'AF','Central African Republic','Zentralafrikanische Republik','Africa','Afrika','',''),(42,'0000-00-00 00:00:00','TD','TCD',148,'AF','Chad, Republic of','Tschad','Africa','Afrika','',''),(43,'0000-00-00 00:00:00','CL','CHL',152,'SA','Chile, Republic of','Chile','South America','SÃ¼damerika','',''),(44,'0000-00-00 00:00:00','CN','CHN',156,'AS','China, People\'s Republic of','China','Asia','Asien','',''),(45,'0000-00-00 00:00:00','CX','CXR',162,'AS','Christmas Island','Weihnachtsinsel','Asia','Asien','',''),(46,'0000-00-00 00:00:00','CC','CCK',166,'AS','Cocos (Keeling) Islands','Kokosinseln (Keelingsinseln)','Asia','Asien','',''),(47,'0000-00-00 00:00:00','CO','COL',170,'SA','Colombia, Republic of','Kolumbien','South America','SÃ¼damerika','',''),(48,'0000-00-00 00:00:00','KM','COM',174,'AF','Comoros, Union of the','Komoren','Africa','Afrika','',''),(49,'0000-00-00 00:00:00','CG','COG',178,'AF','Congo, Republic of the','Kongo','Africa','Afrika','',''),(50,'0000-00-00 00:00:00','CD','COD',180,'AF','Congo, Democratic Republic of the','Kongo, Demokratische Republik','Africa','Afrika','',''),(51,'0000-00-00 00:00:00','CK','COK',184,'OC','Cook Islands','Cook-Inseln','Oceania','Ozeanien','',''),(52,'0000-00-00 00:00:00','CR','CRI',188,'NA','Costa Rica, Republic of','Costa Rica','North America','Nordamerika','',''),(53,'0000-00-00 00:00:00','CI','CIV',384,'AF','Cote d\'Ivoire, Republic of','CÃ´te D\'Ivoire','Africa','Afrika','',''),(54,'0000-00-00 00:00:00','HR','HRV',191,'EU','Croatia, Republic of','Kroatien','Europe','Europa','',''),(55,'0000-00-00 00:00:00','CU','CUB',192,'NA','Cuba, Republic of','Kuba','North America','Nordamerika','',''),(56,'0000-00-00 00:00:00','CY','CYP',196,'AS','Cyprus, Republic of','Zypern','Asia','Asien','',''),(57,'0000-00-00 00:00:00','CZ','CZE',203,'EU','Czech Republic','Tschechische Republik','Europe','Europa','',''),(58,'0000-00-00 00:00:00','DK','DNK',208,'EU','Denmark, Kingdom of','DÃ¤nemark','Europe','Europa','',''),(59,'0000-00-00 00:00:00','DJ','DJI',262,'AF','Djibouti, Republic of','Dschibuti','Africa','Afrika','',''),(60,'0000-00-00 00:00:00','DM','DMA',212,'NA','Dominica, Commonwealth of','Dominica','North America','Nordamerika','',''),(61,'0000-00-00 00:00:00','DO','DOM',214,'NA','Dominican Republic','Dominikanische Republik','North America','Nordamerika','',''),(63,'0000-00-00 00:00:00','EC','ECU',218,'SA','Ecuador, Republic of','Ecuador','South America','SÃ¼damerika','',''),(64,'0000-00-00 00:00:00','EG','EGY',818,'AF','Egypt, Arab Republic of','Ã„gypten','Africa','Afrika','',''),(65,'0000-00-00 00:00:00','SV','SLV',222,'NA','El Salvador, Republic of','El Salvador','North America','Nordamerika','',''),(66,'0000-00-00 00:00:00','GQ','GNQ',226,'AF','Equatorial Guinea, Republic of','Ã„quatorialguinea','Africa','Afrika','',''),(67,'0000-00-00 00:00:00','ER','ERI',232,'AF','Eritrea, State of','Eritrea','Africa','Afrika','',''),(68,'0000-00-00 00:00:00','EE','EST',233,'EU','Estonia, Republic of','Estland','Europe','Europa','',''),(69,'0000-00-00 00:00:00','ET','ETH',231,'AF','Ethiopia, Federal Democratic Republic of','Ã„thiopien','Africa','Afrika','',''),(70,'0000-00-00 00:00:00','FK','FLK',238,'SA','Falkland Islands (Malvinas)','Falkland-Inseln (Malvinen)','South America','SÃ¼damerika','',''),(71,'0000-00-00 00:00:00','FO','FRO',234,'EU','Faroe Islands','FÃ¤rÃ¶er','Europe','Europa','',''),(72,'0000-00-00 00:00:00','FJ','FJI',242,'OC','Fiji, Republic of the Fiji Islands','Fidschi','Oceania','Ozeanien','',''),(73,'0000-00-00 00:00:00','FI','FIN',246,'EU','Finland, Republic of','Finnland','Europe','Europa','',''),(74,'0000-00-00 00:00:00','FR','FRA',250,'EU','France, French Republic','Frankreich','Europe','Europa','',''),(75,'0000-00-00 00:00:00','GF','GUF',254,'SA','French Guiana','FranzÃ¶sisch Guayana','South America','SÃ¼damerika','',''),(76,'0000-00-00 00:00:00','PF','PYF',258,'OC','French Polynesia','FranzÃ¶sisch Polynesien','Oceania','Ozeanien','',''),(77,'0000-00-00 00:00:00','TF','ATF',260,'AN','French Southern Territories','FranzÃ¶sische SÃ¼dgebiete','Antarctica','Antarktis','',''),(78,'0000-00-00 00:00:00','GA','GAB',266,'AF','Gabon, Gabonese Republic','Gabun','Africa','Afrika','',''),(79,'0000-00-00 00:00:00','GM','GMB',270,'AF','Gambia, Republic of the','Gambia','Africa','Afrika','',''),(80,'0000-00-00 00:00:00','GE','GEO',268,'AS','Georgia','Georgien','Asia','Asien','',''),(81,'0000-00-00 00:00:00','DE','DEU',276,'EU','Germany, Federal Republic of','Deutschland','Europe','Europa','',''),(82,'0000-00-00 00:00:00','GH','GHA',288,'AF','Ghana, Republic of','Ghana','Africa','Afrika','',''),(83,'0000-00-00 00:00:00','GI','GIB',292,'EU','Gibraltar','Gibraltar','Europe','Europa','',''),(84,'0000-00-00 00:00:00','GR','GRC',300,'EU','Greece, Hellenic Republic','Griechenland','Europe','Europa','',''),(85,'0000-00-00 00:00:00','GL','GRL',304,'NA','Greenland','GrÃ¶nland','North America','Nordamerika','',''),(86,'0000-00-00 00:00:00','GD','GRD',308,'NA','Grenada','Grenada','North America','Nordamerika','',''),(87,'0000-00-00 00:00:00','GP','GLP',312,'NA','Guadeloupe','Guadeloupe','North America','Nordamerika','',''),(88,'0000-00-00 00:00:00','GU','GUM',316,'OC','Guam','Guam','Oceania','Ozeanien','',''),(89,'0000-00-00 00:00:00','GT','GTM',320,'NA','Guatemala, Republic of','Guatemala','North America','Nordamerika','',''),(90,'0000-00-00 00:00:00','GN','GIN',324,'AF','Guinea, Republic of','Guinea','Africa','Afrika','',''),(91,'0000-00-00 00:00:00','GW','GNB',624,'AF','Guinea-Bissau, Republic of','Guinea-Bissau','Africa','Afrika','',''),(92,'0000-00-00 00:00:00','GY','GUY',328,'SA','Guyana, Co-operative Republic of','Guyana','South America','SÃ¼damerika','',''),(93,'0000-00-00 00:00:00','HT','HTI',332,'NA','Haiti, Republic of','Haiti','North America','Nordamerika','',''),(94,'0000-00-00 00:00:00','HM','HMD',334,'AN','Heard Island and McDonald Islands','Heard und McDonald','Antarctica','Antarktis','',''),(95,'0000-00-00 00:00:00','VA','VAT',336,'EU','Holy See (Vatican City State)','Vatikanstadt, Staat (Heiliger Stuhl)','Europe','Europa','',''),(96,'0000-00-00 00:00:00','HN','HND',340,'NA','Honduras, Republic of','Honduras','North America','Nordamerika','',''),(97,'0000-00-00 00:00:00','HK','HKG',344,'AS','Hong Kong, Special Administrative Region of China','Hongkong','Asia','Asien','',''),(98,'0000-00-00 00:00:00','HU','HUN',348,'EU','Hungary, Republic of','Ungarn','Europe','Europa','',''),(99,'0000-00-00 00:00:00','IS','ISL',352,'EU','Iceland, Republic of','Island','Europe','Europa','',''),(100,'0000-00-00 00:00:00','IN','IND',356,'AS','India, Republic of','Indien','Asia','Asien','',''),(101,'0000-00-00 00:00:00','ID','IDN',360,'AS','Indonesia, Republic of','Indonesien','Asia','Asien','',''),(102,'0000-00-00 00:00:00','IR','IRN',364,'AS','Iran, Islamic Republic of','Iran (Islamische Republik)','Asia','Asien','',''),(103,'0000-00-00 00:00:00','IQ','IRQ',368,'AS','Iraq, Republic of','Irak','Asia','Asien','',''),(104,'0000-00-00 00:00:00','IE','IRL',372,'EU','Ireland','Irland','Europe','Europa','',''),(105,'0000-00-00 00:00:00','IL','ISR',376,'AS','Israel, State of','Israel','Asia','Asien','',''),(106,'0000-00-00 00:00:00','IT','ITA',380,'EU','Italy, Italian Republic','Italien','Europe','Europa','',''),(107,'0000-00-00 00:00:00','JM','JAM',388,'NA','Jamaica','Jamaika','North America','Nordamerika','',''),(108,'0000-00-00 00:00:00','JP','JPN',392,'AS','Japan','Japan','Asia','Asien','',''),(109,'0000-00-00 00:00:00','JO','JOR',400,'AS','Jordan, Hashemite Kingdom of','Jordanien','Asia','Asien','',''),(110,'0000-00-00 00:00:00','KZ','KAZ',398,'AS','Kazakhstan, Republic of','Kasachstan','Asia','Asien','',''),(111,'0000-00-00 00:00:00','KE','KEN',404,'AF','Kenya, Republic of','Kenia','Africa','Afrika','',''),(112,'0000-00-00 00:00:00','KI','KIR',296,'OC','Kiribati, Republic of','Kiribati','Oceania','Ozeanien','',''),(113,'0000-00-00 00:00:00','KP','PRK',408,'AS','Korea, Democratic People\'s Republic of','Korea, Demokratische Volksrepublik','Asia','Asien','',''),(114,'0000-00-00 00:00:00','KR','KOR',410,'AS','Korea, Republic of','Korea, Republik','Asia','Asien','',''),(115,'0000-00-00 00:00:00','KW','KWT',414,'AS','Kuwait, State of','Kuwait','Asia','Asien','',''),(116,'0000-00-00 00:00:00','KG','KGZ',417,'AS','Kyrgyz Republic','Kirgisistan','Asia','Asien','',''),(117,'0000-00-00 00:00:00','LA','LAO',418,'AS','Lao People\'s Democratic Republic','Laos, Demokratische Volksrepublik','Asia','Asien','',''),(118,'0000-00-00 00:00:00','LV','LVA',428,'EU','Latvia, Republic of','Lettland','Europe','Europa','',''),(119,'0000-00-00 00:00:00','LB','LBN',422,'AS','Lebanon, Lebanese Republic','Libanon','Asia','Asien','',''),(120,'0000-00-00 00:00:00','LS','LSO',426,'AF','Lesotho, Kingdom of','Lesotho','Africa','Afrika','',''),(121,'0000-00-00 00:00:00','LR','LBR',430,'AF','Liberia, Republic of','Liberia','Africa','Afrika','',''),(122,'0000-00-00 00:00:00','LY','LBY',434,'AF','Libyan Arab Jamahiriya','Libysch-Arabische Dschamahirija','Africa','Afrika','',''),(123,'0000-00-00 00:00:00','LI','LIE',438,'EU','Liechtenstein, Principality of','Liechtenstein','Europe','Europa','',''),(124,'0000-00-00 00:00:00','LT','LTU',440,'EU','Lithuania, Republic of','Litauen','Europe','Europa','',''),(125,'0000-00-00 00:00:00','LU','LUX',442,'EU','Luxembourg, Grand Duchy of','Luxembourg','Europe','Europa','',''),(126,'0000-00-00 00:00:00','MO','MAC',446,'AS','Macao, Special Administrative Region of China','Macau','Asia','Asien','',''),(127,'0000-00-00 00:00:00','MK','MKD',807,'EU','Macedonia, the former Yugoslav Republic of','Mazedonien, Ehemalige Jugoslawische Republik','Europe','Europa','',''),(128,'0000-00-00 00:00:00','MG','MDG',450,'AF','Madagascar, Republic of','Madagaskar','Africa','Afrika','',''),(129,'0000-00-00 00:00:00','MW','MWI',454,'AF','Malawi, Republic of','Malawi','Africa','Afrika','',''),(130,'0000-00-00 00:00:00','MY','MYS',458,'AS','Malaysia','Malaysia','Asia','Asien','',''),(131,'0000-00-00 00:00:00','MV','MDV',462,'AS','Maldives, Republic of','Malediven','Asia','Asien','',''),(132,'0000-00-00 00:00:00','ML','MLI',466,'AF','Mali, Republic of','Mali','Africa','Afrika','',''),(133,'0000-00-00 00:00:00','MT','MLT',470,'EU','Malta, Republic of','Malta','Europe','Europa','',''),(134,'0000-00-00 00:00:00','MH','MHL',584,'OC','Marshall Islands, Republic of the','Marshallinseln','Oceania','Ozeanien','',''),(135,'0000-00-00 00:00:00','MQ','MTQ',474,'NA','Martinique','Martinique','North America','Nordamerika','',''),(136,'0000-00-00 00:00:00','MR','MRT',478,'AF','Mauritania, Islamic Republic of','Mauretanien','Africa','Afrika','',''),(137,'0000-00-00 00:00:00','MU','MUS',480,'AF','Mauritius, Republic of','Mauritius','Africa','Afrika','',''),(138,'0000-00-00 00:00:00','YT','MYT',175,'AF','Mayotte','Mayotte','Africa','Afrika','',''),(139,'0000-00-00 00:00:00','MX','MEX',484,'NA','Mexico, United Mexican States','Mexiko','North America','Nordamerika','',''),(140,'0000-00-00 00:00:00','FM','FSM',583,'OC','Micronesia, Federated States of','Mikronesien, FÃ¶derierte Staaten Von','Oceania','Ozeanien','',''),(141,'0000-00-00 00:00:00','MD','MDA',498,'EU','Moldova, Republic of','Moldau, Republik','Europe','Europa','',''),(142,'0000-00-00 00:00:00','MC','MCO',492,'EU','Monaco, Principality of','Monaco','Europe','Europa','',''),(143,'0000-00-00 00:00:00','MN','MNG',496,'AS','Mongolia','Mongolei','Asia','Asien','',''),(144,'0000-00-00 00:00:00','MS','MSR',500,'NA','Montserrat','Montserrat','North America','Nordamerika','',''),(145,'0000-00-00 00:00:00','MA','MAR',504,'AF','Morocco, Kingdom of','Marokko','Africa','Afrika','',''),(146,'0000-00-00 00:00:00','MZ','MOZ',508,'AF','Mozambique, Republic of','Mosambik','Africa','Afrika','',''),(147,'0000-00-00 00:00:00','MM','MMR',104,'AS','Myanmar, Union of','Myanmar','Asia','Asien','',''),(148,'0000-00-00 00:00:00','NA','NAM',516,'AF','Namibia, Republic of','Namibia','Africa','Afrika','',''),(149,'0000-00-00 00:00:00','NR','NRU',520,'OC','Nauru, Republic of','Nauru','Oceania','Ozeanien','',''),(150,'0000-00-00 00:00:00','NP','NPL',524,'AS','Nepal, State of','Nepal','Asia','Asien','',''),(151,'0000-00-00 00:00:00','NL','NLD',528,'EU','Netherlands, Kingdom of the','Niederlande','Europe','Europa','',''),(152,'0000-00-00 00:00:00','AN','ANT',530,'NA','Netherlands Antilles','NiederlÃ¤ndische Antillen','North America','Nordamerika','',''),(153,'0000-00-00 00:00:00','NC','NCL',540,'OC','New Caledonia','Neukaledonien','Oceania','Ozeanien','',''),(154,'0000-00-00 00:00:00','NZ','NZL',554,'OC','New Zealand','Neuseeland','Oceania','Ozeanien','',''),(155,'0000-00-00 00:00:00','NI','NIC',558,'NA','Nicaragua, Republic of','Nicaragua','North America','Nordamerika','',''),(156,'0000-00-00 00:00:00','NE','NER',562,'AF','Niger, Republic of','Niger','Africa','Afrika','',''),(157,'0000-00-00 00:00:00','NG','NGA',566,'AF','Nigeria, Federal Republic of','Nigeria','Africa','Afrika','',''),(158,'0000-00-00 00:00:00','NU','NIU',570,'OC','Niue','Niue','Oceania','Ozeanien','',''),(159,'0000-00-00 00:00:00','NF','NFK',574,'OC','Norfolk Island','Norfolk-Insel','Oceania','Ozeanien','',''),(160,'0000-00-00 00:00:00','MP','MNP',580,'OC','Northern Mariana Islands, Commonwealth of the','NÃ¶rdliche Marianen','Oceania','Ozeanien','',''),(161,'0000-00-00 00:00:00','NO','NOR',578,'EU','Norway, Kingdom of','Norwegen','Europe','Europa','',''),(162,'0000-00-00 00:00:00','OM','OMN',512,'AS','Oman, Sultanate of','Oman','Asia','Asien','',''),(163,'0000-00-00 00:00:00','PK','PAK',586,'AS','Pakistan, Islamic Republic of','Pakistan','Asia','Asien','',''),(164,'0000-00-00 00:00:00','PW','PLW',585,'OC','Palau, Republic of','Palau','Oceania','Ozeanien','',''),(165,'0000-00-00 00:00:00','PS','PSE',275,'AS','Palestinian Territory, Occupied','PalÃ¤stina','Asia','Asien','',''),(166,'0000-00-00 00:00:00','PA','PAN',591,'NA','Panama, Republic of','Panama','North America','Nordamerika','',''),(167,'0000-00-00 00:00:00','PG','PNG',598,'OC','Papua New Guinea, Independent State of','Papua-Neuguinea','Oceania','Ozeanien','',''),(168,'0000-00-00 00:00:00','PY','PRY',600,'SA','Paraguay, Republic of','Paraguay','South America','SÃ¼damerika','',''),(169,'0000-00-00 00:00:00','PE','PER',604,'SA','Peru, Republic of','Peru','South America','SÃ¼damerika','',''),(170,'0000-00-00 00:00:00','PH','PHL',608,'AS','Philippines, Republic of the','Philippinen','Asia','Asien','',''),(171,'0000-00-00 00:00:00','PN','PCN',612,'OC','Pitcairn Islands','Pitcairn','Oceania','Ozeanien','',''),(172,'0000-00-00 00:00:00','PL','POL',616,'EU','Poland, Republic of','Polen','Europe','Europa','',''),(173,'0000-00-00 00:00:00','PT','PRT',620,'EU','Portugal, Portuguese Republic','Portugal','Europe','Europa','',''),(174,'0000-00-00 00:00:00','PR','PRI',630,'NA','Puerto Rico, Commonwealth of','Puerto Rico','North America','Nordamerika','',''),(175,'0000-00-00 00:00:00','QA','QAT',634,'AS','Qatar, State of','Katar','Asia','Asien','',''),(176,'0000-00-00 00:00:00','RE','REU',638,'AF','Reunion','RÃ©union','Africa','Afrika','',''),(177,'0000-00-00 00:00:00','RO','ROU',642,'EU','Romania','RumÃ¤nien','Europe','Europa','',''),(178,'0000-00-00 00:00:00','RU','RUS',643,'EU','Russian Federation','Russische FÃ¶deration','Europe','Europa','',''),(179,'0000-00-00 00:00:00','RW','RWA',646,'AF','Rwanda, Republic of','Ruanda','Africa','Afrika','',''),(180,'0000-00-00 00:00:00','SH','SHN',654,'AF','Saint Helena','St. Helena','Africa','Afrika','',''),(181,'0000-00-00 00:00:00','KN','KNA',659,'NA','Saint Kitts and Nevis, Federation of','Saint Kitts und Nevis','North America','Nordamerika','',''),(182,'0000-00-00 00:00:00','LC','LCA',662,'NA','Saint Lucia','Santa Lucia','North America','Nordamerika','',''),(183,'0000-00-00 00:00:00','PM','SPM',666,'NA','Saint Pierre and Miquelon','Saint-Pierre und Miquelon','North America','Nordamerika','',''),(184,'0000-00-00 00:00:00','VC','VCT',670,'NA','Saint Vincent and the Grenadines','Saint Vincent und die Grenadinen','North America','Nordamerika','',''),(185,'0000-00-00 00:00:00','WS','WSM',882,'OC','Samoa, Independent State of','Samoa','Oceania','Ozeanien','',''),(186,'0000-00-00 00:00:00','SM','SMR',674,'EU','San Marino, Republic of','San Marino','Europe','Europa','',''),(187,'0000-00-00 00:00:00','ST','STP',678,'AF','Sao Tome and Principe, Democratic Republic of','SÃ£o TomÃ© und PrÃncipe','Africa','Afrika','',''),(188,'0000-00-00 00:00:00','SA','SAU',682,'AS','Saudi Arabia, Kingdom of','Saudi-Arabien','Asia','Asien','',''),(189,'0000-00-00 00:00:00','SN','SEN',686,'AF','Senegal, Republic of','Senegal','Africa','Afrika','',''),(190,'0000-00-00 00:00:00','SC','SYC',690,'AF','Seychelles, Republic of','Seychellen','Africa','Afrika','',''),(191,'0000-00-00 00:00:00','SL','SLE',694,'AF','Sierra Leone, Republic of','Sierra Leone','Africa','Afrika','',''),(192,'0000-00-00 00:00:00','SG','SGP',702,'AS','Singapore, Republic of','Singapur','Asia','Asien','',''),(193,'0000-00-00 00:00:00','SK','SVK',703,'EU','Slovakia (Slovak Republic)','Slowakei (Slowakische Republik)','Europe','Europa','',''),(194,'0000-00-00 00:00:00','SI','SVN',705,'EU','Slovenia, Republic of','Slowenien','Europe','Europa','',''),(195,'0000-00-00 00:00:00','SB','SLB',90,'OC','Solomon Islands','Salomonen','Oceania','Ozeanien','',''),(196,'0000-00-00 00:00:00','SO','SOM',706,'AF','Somalia, Somali Republic','Somalia','Africa','Afrika','',''),(197,'0000-00-00 00:00:00','ZA','ZAF',710,'AF','South Africa, Republic of','SÃ¼dafrika','Africa','Afrika','',''),(198,'0000-00-00 00:00:00','GS','SGS',239,'AN','South Georgia and the South Sandwich Islands','SÃ¼dgeorgien und SÃ¼dliche Sandwichinseln','Antarctica','Antarktis','',''),(199,'0000-00-00 00:00:00','ES','ESP',724,'EU','Spain, Kingdom of','Spanien','Europe','Europa','',''),(200,'0000-00-00 00:00:00','LK','LKA',144,'AS','Sri Lanka, Democratic Socialist Republic of','Sri Lanka','Asia','Asien','',''),(201,'0000-00-00 00:00:00','SD','SDN',736,'AF','Sudan, Republic of','Sudan','Africa','Afrika','',''),(202,'0000-00-00 00:00:00','SR','SUR',740,'AF','Suriname, Republic of','Suriname','Africa','Afrika','',''),(203,'0000-00-00 00:00:00','SJ','SJM',744,'EU','Svalbard & Jan Mayen Islands','Svalbard und Jan Mayen','Europe','Europa','',''),(204,'0000-00-00 00:00:00','SZ','SWZ',748,'AF','Swaziland, Kingdom of','Swasiland','Africa','Afrika','',''),(205,'0000-00-00 00:00:00','SE','SWE',752,'EU','Sweden, Kingdom of','Schweden','Europe','Europa','',''),(206,'0000-00-00 00:00:00','CH','CHE',756,'EU','Switzerland, Swiss Confederation','Schweiz','Europe','Europa','',''),(207,'0000-00-00 00:00:00','SY','SYR',760,'AS','Syrian Arab Republic','Syrien, Arabische Republik','Asia','Asien','',''),(208,'0000-00-00 00:00:00','TW','TWN',158,'AS','Taiwan','Taiwan (China)','Asia','Asien','',''),(209,'0000-00-00 00:00:00','TJ','TJK',762,'AS','Tajikistan, Republic of','Tadschikistan','Asia','Asien','',''),(210,'0000-00-00 00:00:00','TZ','TZA',834,'AF','Tanzania, United Republic of','Tansania, Vereinigte Republik','Africa','Afrika','',''),(211,'0000-00-00 00:00:00','TH','THA',764,'AS','Thailand, Kingdom of','Thailand','Asia','Asien','',''),(212,'0000-00-00 00:00:00','TG','TGO',768,'AF','Togo, Togolese Republic','Togo','Africa','Afrika','',''),(213,'0000-00-00 00:00:00','TK','TKL',772,'OC','Tokelau','Tokelau','Oceania','Ozeanien','',''),(214,'0000-00-00 00:00:00','TO','TON',776,'OC','Tonga, Kingdom of','Tonga','Oceania','Ozeanien','',''),(215,'0000-00-00 00:00:00','TT','TTO',780,'NA','Trinidad and Tobago, Republic of','Trinidad und Tobago','North America','Nordamerika','',''),(216,'0000-00-00 00:00:00','TN','TUN',788,'AF','Tunisia, Tunisian Republic','Tunesien','Africa','Afrika','',''),(217,'0000-00-00 00:00:00','TR','TUR',792,'AS','Turkey, Republic of','TÃ¼rkei','Asia','Asien','',''),(218,'0000-00-00 00:00:00','TM','TKM',795,'AS','Turkmenistan','Turkmenistan','Asia','Asien','',''),(219,'0000-00-00 00:00:00','TC','TCA',796,'NA','Turks and Caicos Islands','Turks- und Caicosinseln','North America','Nordamerika','',''),(220,'0000-00-00 00:00:00','TV','TUV',798,'OC','Tuvalu','Tuvalu','Oceania','Ozeanien','',''),(221,'0000-00-00 00:00:00','UG','UGA',800,'AF','Uganda, Republic of','Uganda','Africa','Afrika','',''),(222,'0000-00-00 00:00:00','UA','UKR',804,'EU','Ukraine','Ukraine','Europe','Europa','',''),(223,'0000-00-00 00:00:00','AE','ARE',784,'AS','United Arab Emirates','Vereinigte Arabische Emirate','Asia','Asien','',''),(224,'0000-00-00 00:00:00','GB','GBR',826,'EU','United Kingdom of Great Britain & Northern Ireland','United Kingdom','Europe','Europa','',''),(225,'0000-00-00 00:00:00','US','USA',840,'NA','United States of America','Vereinigte Staaten','North America','Nordamerika','',''),(226,'0000-00-00 00:00:00','UM','UMI',581,'OC','United States Minor Outlying Islands','Kleinere entlegene Inseln der Vereinigten Staaten','Oceania','Ozeanien','',''),(227,'0000-00-00 00:00:00','UY','URY',858,'SA','Uruguay, Eastern Republic of','Uruguay','South America','SÃ¼damerika','',''),(228,'0000-00-00 00:00:00','UZ','UZB',860,'AS','Uzbekistan, Republic of','Usbekistan','Asia','Asien','',''),(229,'0000-00-00 00:00:00','VU','VUT',548,'OC','Vanuatu, Republic of','Vanuatu','Oceania','Ozeanien','',''),(230,'0000-00-00 00:00:00','VE','VEN',862,'SA','Venezuela, Bolivarian Republic of','Venezuela','South America','SÃ¼damerika','',''),(231,'0000-00-00 00:00:00','VN','VNM',704,'AS','Vietnam, Socialist Republic of','Vietnam','Asia','Asien','',''),(232,'0000-00-00 00:00:00','VG','VGB',92,'NA','British Virgin Islands','Jungferninseln (Britische)','North America','Nordamerika','',''),(233,'0000-00-00 00:00:00','VI','VIR',850,'NA','United States Virgin Islands','Jungferninseln (Amerikanische)','North America','Nordamerika','',''),(234,'0000-00-00 00:00:00','WF','WLF',876,'OC','Wallis and Futuna','Wallis und Futuna','Oceania','Ozeanien','',''),(235,'0000-00-00 00:00:00','EH','ESH',732,'AF','Western Sahara','Westsahara','Africa','Afrika','',''),(236,'0000-00-00 00:00:00','YE','YEM',887,'AS','Yemen','Jemen','Asia','Asien','',''),(237,'0000-00-00 00:00:00','YU','YUG',891,'EU','Yugoslavia','Jugoslawien','Europe','Europa','',''),(238,'0000-00-00 00:00:00','ZM','ZMB',894,'AF','Zambia, Republic of','Sambia','Africa','Afrika','',''),(239,'0000-00-00 00:00:00','ZW','ZWE',716,'AF','Zimbabwe, Republic of','Simbabwe','Africa','Afrika','',''),(240,'0000-00-00 00:00:00','AX','ALA',248,'EU','Ã…land Islands','Ã…land Inseln','Europe','Europa','',''),(241,'0000-00-00 00:00:00','GG','GGY',831,'EU','Guernsey, Bailiwick of','Guernsey, Vogtei','Europe','Europa','',''),(242,'0000-00-00 00:00:00','IM','IMN',833,'EU','Isle of Man','Insel Man','Europe','Europa','',''),(243,'0000-00-00 00:00:00','JE','JEY',832,'EU','Jersey, Bailiwick of','Jersey, Vogtei','Europe','Europa','',''),(244,'0000-00-00 00:00:00','ME','MNE',499,'EU','Montenegro, Republic of','Montenegro','Europe','Europa','',''),(245,'0000-00-00 00:00:00','BL','BLM',652,'NA','Saint Barthelemy','Sankt BartholomÃ¤us','North America','Nordamerika','',''),(246,'0000-00-00 00:00:00','MF','MAF',663,'NA','Saint Martin','Saint-Martin','North America','Nordamerika','',''),(247,'0000-00-00 00:00:00','RS','SRB',688,'EU','Serbia, Republic of','Serbien','Europe','Europa','',''),(248,'0000-00-00 00:00:00','TL','TLS',626,'AS','Timor-Leste, Democratic Republic of','Osttimor (Timor-Leste)','Asia','Asien','','');
/*!40000 ALTER TABLE `phpwcms_country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_crossreference`
--

DROP TABLE IF EXISTS `phpwcms_crossreference`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_crossreference` (
  `cref_id` int(11) NOT NULL AUTO_INCREMENT,
  `cref_type` int(11) NOT NULL DEFAULT '0',
  `cref_module` varchar(255) NOT NULL DEFAULT '',
  `cref_rid` int(11) NOT NULL DEFAULT '0',
  `cref_int` int(11) NOT NULL DEFAULT '0',
  `cref_str` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`cref_id`),
  KEY `cref_type` (`cref_type`,`cref_rid`,`cref_int`,`cref_str`),
  KEY `cref_module` (`cref_module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_crossreference`
--

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

--
-- Table structure for table `phpwcms_file`
--

DROP TABLE IF EXISTS `phpwcms_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_file` (
  `f_id` int(11) NOT NULL AUTO_INCREMENT,
  `f_pid` int(11) NOT NULL DEFAULT '0',
  `f_uid` int(11) NOT NULL DEFAULT '0',
  `f_kid` int(2) NOT NULL DEFAULT '0',
  `f_order` int(11) NOT NULL DEFAULT '0',
  `f_trash` int(1) NOT NULL DEFAULT '0',
  `f_aktiv` int(1) NOT NULL DEFAULT '0',
  `f_public` int(1) NOT NULL DEFAULT '0',
  `f_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `f_name` varchar(255) NOT NULL DEFAULT '',
  `f_cat` varchar(255) NOT NULL,
  `f_created` int(11) NOT NULL DEFAULT '0',
  `f_changed` int(11) NOT NULL DEFAULT '0',
  `f_size` int(15) unsigned NOT NULL,
  `f_type` varchar(200) NOT NULL DEFAULT '',
  `f_ext` varchar(50) NOT NULL DEFAULT '',
  `f_shortinfo` varchar(255) NOT NULL DEFAULT '',
  `f_longinfo` text NOT NULL,
  `f_thumb_list` varchar(255) NOT NULL DEFAULT '',
  `f_thumb_preview` varchar(255) NOT NULL DEFAULT '',
  `f_keywords` varchar(255) NOT NULL DEFAULT '',
  `f_hash` varchar(50) NOT NULL DEFAULT '',
  `f_dlstart` int(11) NOT NULL DEFAULT '0',
  `f_dlfinal` int(11) NOT NULL DEFAULT '0',
  `f_refid` int(11) NOT NULL DEFAULT '0',
  `f_copyright` varchar(255) NOT NULL,
  `f_tags` varchar(255) NOT NULL,
  `f_granted` int(11) NOT NULL DEFAULT '0',
  `f_gallerystatus` int(1) NOT NULL DEFAULT '0',
  `f_vars` blob NOT NULL,
  `f_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`f_id`),
  KEY `f_granted` (`f_granted`),
  KEY `f_sort` (`f_sort`),
  FULLTEXT KEY `f_name` (`f_name`),
  FULLTEXT KEY `f_shortinfo` (`f_shortinfo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_file`
--

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

--
-- Table structure for table `phpwcms_filecat`
--

DROP TABLE IF EXISTS `phpwcms_filecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_filecat` (
  `fcat_id` int(11) NOT NULL AUTO_INCREMENT,
  `fcat_name` varchar(255) NOT NULL DEFAULT '',
  `fcat_aktiv` int(1) NOT NULL DEFAULT '0',
  `fcat_deleted` int(1) NOT NULL DEFAULT '0',
  `fcat_needed` int(1) NOT NULL DEFAULT '0',
  `fcat_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fcat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_filecat`
--

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

--
-- Table structure for table `phpwcms_filekey`
--

DROP TABLE IF EXISTS `phpwcms_filekey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_filekey` (
  `fkey_id` int(11) NOT NULL AUTO_INCREMENT,
  `fkey_cid` int(11) NOT NULL DEFAULT '0',
  `fkey_name` varchar(255) NOT NULL DEFAULT '',
  `fkey_aktiv` int(1) NOT NULL DEFAULT '0',
  `fkey_deleted` int(1) NOT NULL DEFAULT '0',
  `fkey_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fkey_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_filekey`
--

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

--
-- Table structure for table `phpwcms_fonts`
--

DROP TABLE IF EXISTS `phpwcms_fonts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_fonts` (
  `font_id` int(11) NOT NULL AUTO_INCREMENT,
  `font_name` text NOT NULL,
  `font_shortname` text NOT NULL,
  `font_filename` text NOT NULL,
  PRIMARY KEY (`font_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_fonts`
--

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

--
-- Table structure for table `phpwcms_fonts_colors`
--

DROP TABLE IF EXISTS `phpwcms_fonts_colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_fonts_colors` (
  `color_id` int(11) NOT NULL AUTO_INCREMENT,
  `color_name` text NOT NULL,
  `color_value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`color_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_fonts_colors`
--

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

--
-- Table structure for table `phpwcms_fonts_styles`
--

DROP TABLE IF EXISTS `phpwcms_fonts_styles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_fonts_styles` (
  `style_id` int(11) NOT NULL AUTO_INCREMENT,
  `style_name` text NOT NULL,
  `style_info` text NOT NULL,
  PRIMARY KEY (`style_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_fonts_styles`
--

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

--
-- Table structure for table `phpwcms_formresult`
--

DROP TABLE IF EXISTS `phpwcms_formresult`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_formresult` (
  `formresult_id` int(11) NOT NULL AUTO_INCREMENT,
  `formresult_pid` int(11) NOT NULL DEFAULT '0',
  `formresult_createdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `formresult_ip` varchar(50) NOT NULL DEFAULT '',
  `formresult_content` mediumblob NOT NULL,
  PRIMARY KEY (`formresult_id`),
  KEY `formresult_pid` (`formresult_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_formresult`
--

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

--
-- Table structure for table `phpwcms_formtracking`
--

DROP TABLE IF EXISTS `phpwcms_formtracking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_formtracking` (
  `formtracking_id` int(11) NOT NULL AUTO_INCREMENT,
  `formtracking_hash` varchar(50) NOT NULL DEFAULT '',
  `formtracking_ip` varchar(20) NOT NULL DEFAULT '',
  `formtracking_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `formtracking_sentdate` varchar(20) NOT NULL DEFAULT '',
  `formtracking_sent` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`formtracking_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_formtracking`
--

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

--
-- Table structure for table `phpwcms_glossary`
--

DROP TABLE IF EXISTS `phpwcms_glossary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_glossary` (
  `glossary_id` int(11) NOT NULL AUTO_INCREMENT,
  `glossary_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `glossary_changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `glossary_title` text NOT NULL,
  `glossary_tag` varchar(255) NOT NULL DEFAULT '',
  `glossary_keyword` varchar(255) NOT NULL DEFAULT '',
  `glossary_text` mediumtext NOT NULL,
  `glossary_highlight` int(1) NOT NULL DEFAULT '0',
  `glossary_object` mediumtext NOT NULL,
  `glossary_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`glossary_id`),
  KEY `glossary_status` (`glossary_status`),
  KEY `glossary_tag` (`glossary_tag`),
  KEY `glossary_keyword` (`glossary_keyword`),
  KEY `glossary_highlight` (`glossary_highlight`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_glossary`
--

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

--
-- Table structure for table `phpwcms_guestbook`
--

DROP TABLE IF EXISTS `phpwcms_guestbook`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_guestbook` (
  `guestbook_id` int(11) NOT NULL AUTO_INCREMENT,
  `guestbook_cid` int(11) NOT NULL DEFAULT '0',
  `guestbook_msg` text NOT NULL,
  `guestbook_name` text NOT NULL,
  `guestbook_email` text NOT NULL,
  `guestbook_created` int(11) NOT NULL DEFAULT '0',
  `guestbook_trashed` int(1) NOT NULL DEFAULT '0',
  `guestbook_url` text NOT NULL,
  `guestbook_show` int(1) NOT NULL DEFAULT '0',
  `guestbook_ip` varchar(20) NOT NULL DEFAULT '',
  `guestbook_useragent` varchar(255) NOT NULL DEFAULT '',
  `guestbook_image` varchar(255) NOT NULL DEFAULT '',
  `guestbook_imagename` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`guestbook_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_guestbook`
--

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

--
-- Table structure for table `phpwcms_imgcache`
--

DROP TABLE IF EXISTS `phpwcms_imgcache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_imgcache` (
  `imgcache_id` int(11) NOT NULL AUTO_INCREMENT,
  `imgcache_hash` varchar(50) NOT NULL DEFAULT '',
  `imgcache_imgname` varchar(255) NOT NULL DEFAULT '',
  `imgcache_width` int(11) NOT NULL DEFAULT '0',
  `imgcache_height` int(11) NOT NULL DEFAULT '0',
  `imgcache_wh` varchar(255) NOT NULL DEFAULT '',
  `imgcache_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `imgcache_trash` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`imgcache_id`),
  KEY `imgcache_hash` (`imgcache_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_imgcache`
--

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

--
-- Table structure for table `phpwcms_keyword`
--

DROP TABLE IF EXISTS `phpwcms_keyword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_keyword` (
  `keyword_id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword_name` varchar(255) NOT NULL DEFAULT '',
  `keyword_created` varchar(14) NOT NULL DEFAULT '',
  `keyword_trash` int(1) NOT NULL DEFAULT '0',
  `keyword_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `keyword_description` text NOT NULL,
  `keyword_link` varchar(255) NOT NULL DEFAULT '',
  `keyword_sort` int(11) NOT NULL DEFAULT '0',
  `keyword_important` int(1) NOT NULL DEFAULT '0',
  `keyword_abbr` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`keyword_id`),
  KEY `keyword_abbr` (`keyword_abbr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_keyword`
--

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

--
-- Table structure for table `phpwcms_language`
--

DROP TABLE IF EXISTS `phpwcms_language`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_language` (
  `lang_id` varchar(255) NOT NULL DEFAULT '',
  `lang_html` int(1) NOT NULL DEFAULT '1',
  `lang_type` int(1) NOT NULL DEFAULT '0',
  `EN` text NOT NULL,
  `DE` text NOT NULL,
  `BG` text NOT NULL,
  `CA` text NOT NULL,
  `CZ` text NOT NULL,
  `DA` text NOT NULL,
  `EE` text NOT NULL,
  `ES` text NOT NULL,
  `FI` text NOT NULL,
  `FR` text NOT NULL,
  `GR` text NOT NULL,
  `HU` text NOT NULL,
  `IT` text NOT NULL,
  `LT` text NOT NULL,
  `NL` text NOT NULL,
  `NO` text NOT NULL,
  `PL` text NOT NULL,
  `PT` text NOT NULL,
  `RO` text NOT NULL,
  `SE` text NOT NULL,
  `SK` text NOT NULL,
  `VN` text NOT NULL,
  PRIMARY KEY (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_language`
--

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

--
-- Table structure for table `phpwcms_log`
--

DROP TABLE IF EXISTS `phpwcms_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `log_type` varchar(50) NOT NULL DEFAULT '',
  `log_ip` varchar(30) NOT NULL DEFAULT '',
  `log_user_agent` varchar(255) NOT NULL,
  `log_user_id` int(11) NOT NULL DEFAULT '0',
  `log_user_name` varchar(255) NOT NULL,
  `log_referrer_id` int(11) NOT NULL DEFAULT '0',
  `log_referrer_url` text NOT NULL,
  `log_data1` varchar(255) NOT NULL DEFAULT '',
  `log_data2` varchar(255) NOT NULL DEFAULT '',
  `log_data3` varchar(255) NOT NULL DEFAULT '',
  `log_msg` text NOT NULL,
  PRIMARY KEY (`log_id`),
  KEY `log_referrer_id` (`log_referrer_id`),
  KEY `log_type` (`log_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_log`
--

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

--
-- Table structure for table `phpwcms_log_seo`
--

DROP TABLE IF EXISTS `phpwcms_log_seo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_log_seo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `domain` varchar(255) NOT NULL,
  `query` varchar(255) NOT NULL,
  `pos` int(11) NOT NULL,
  `referrer` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_log_seo`
--

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

--
-- Table structure for table `phpwcms_map`
--

DROP TABLE IF EXISTS `phpwcms_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_map` (
  `map_id` int(11) NOT NULL AUTO_INCREMENT,
  `map_cid` int(11) NOT NULL DEFAULT '0',
  `map_x` int(5) NOT NULL DEFAULT '0',
  `map_y` int(5) NOT NULL DEFAULT '0',
  `map_title` text NOT NULL,
  `map_zip` varchar(255) NOT NULL DEFAULT '',
  `map_city` text NOT NULL,
  `map_deleted` int(1) NOT NULL DEFAULT '0',
  `map_entry` text NOT NULL,
  `map_vars` text NOT NULL,
  PRIMARY KEY (`map_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_map`
--

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

--
-- Table structure for table `phpwcms_message`
--

DROP TABLE IF EXISTS `phpwcms_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_message` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_pid` int(11) NOT NULL DEFAULT '0',
  `msg_uid` int(11) NOT NULL DEFAULT '0',
  `msg_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `msg_subject` varchar(150) NOT NULL DEFAULT '',
  `msg_text` blob NOT NULL,
  `msg_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `msg_read` tinyint(1) NOT NULL DEFAULT '0',
  `msg_to` blob NOT NULL,
  `msg_from` int(11) NOT NULL DEFAULT '0',
  `msg_from_del` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_message`
--

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

--
-- Table structure for table `phpwcms_newsletter`
--

DROP TABLE IF EXISTS `phpwcms_newsletter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_newsletter` (
  `newsletter_id` int(11) NOT NULL AUTO_INCREMENT,
  `newsletter_created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `newsletter_lastsending` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `newsletter_subject` text NOT NULL,
  `newsletter_changed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `newsletter_vars` mediumblob NOT NULL,
  `newsletter_trashed` int(1) NOT NULL DEFAULT '0',
  `newsletter_active` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`newsletter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_newsletter`
--

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

--
-- Table structure for table `phpwcms_newsletterqueue`
--

DROP TABLE IF EXISTS `phpwcms_newsletterqueue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_newsletterqueue` (
  `queue_id` int(11) NOT NULL AUTO_INCREMENT,
  `queue_created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `queue_changed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `queue_status` int(11) NOT NULL DEFAULT '0',
  `queue_pid` int(11) NOT NULL DEFAULT '0',
  `queue_rid` int(11) NOT NULL DEFAULT '0',
  `queue_errormsg` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`queue_id`),
  KEY `nlqueue` (`queue_pid`,`queue_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_newsletterqueue`
--

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

--
-- Table structure for table `phpwcms_pagelayout`
--

DROP TABLE IF EXISTS `phpwcms_pagelayout`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_pagelayout` (
  `pagelayout_id` int(11) NOT NULL AUTO_INCREMENT,
  `pagelayout_name` varchar(255) NOT NULL DEFAULT '',
  `pagelayout_default` int(1) NOT NULL DEFAULT '0',
  `pagelayout_var` mediumblob NOT NULL,
  `pagelayout_trash` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pagelayout_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_pagelayout`
--

LOCK TABLES `phpwcms_pagelayout` WRITE;
/*!40000 ALTER TABLE `phpwcms_pagelayout` DISABLE KEYS */;
INSERT INTO `phpwcms_pagelayout` (`pagelayout_id`, `pagelayout_name`, `pagelayout_default`, `pagelayout_var`, `pagelayout_trash`) VALUES (1,'Sample Pagelayout',1,'a:62:{s:2:\"id\";i:1;s:11:\"layout_name\";s:17:\"Sample Pagelayout\";s:14:\"layout_default\";i:1;s:12:\"layout_align\";i:0;s:11:\"layout_type\";i:0;s:17:\"layout_border_top\";s:0:\"\";s:20:\"layout_border_bottom\";s:0:\"\";s:18:\"layout_border_left\";s:0:\"\";s:19:\"layout_border_right\";s:0:\"\";s:15:\"layout_noborder\";i:1;s:12:\"layout_title\";s:9:\"Pagetitle\";s:18:\"layout_title_order\";i:4;s:19:\"layout_title_spacer\";s:3:\" | \";s:14:\"layout_bgcolor\";b:0;s:14:\"layout_bgimage\";s:0:\"\";s:15:\"layout_jsonload\";s:0:\"\";s:16:\"layout_textcolor\";b:0;s:16:\"layout_linkcolor\";b:0;s:13:\"layout_vcolor\";b:0;s:13:\"layout_acolor\";b:0;s:16:\"layout_all_width\";s:0:\"\";s:18:\"layout_all_bgcolor\";b:0;s:18:\"layout_all_bgimage\";s:0:\"\";s:16:\"layout_all_class\";s:0:\"\";s:20:\"layout_content_width\";s:0:\"\";s:22:\"layout_content_bgcolor\";b:0;s:22:\"layout_content_bgimage\";s:0:\"\";s:20:\"layout_content_class\";s:0:\"\";s:17:\"layout_left_width\";s:0:\"\";s:19:\"layout_left_bgcolor\";b:0;s:19:\"layout_left_bgimage\";s:0:\"\";s:17:\"layout_left_class\";s:0:\"\";s:18:\"layout_right_width\";s:0:\"\";s:20:\"layout_right_bgcolor\";b:0;s:20:\"layout_right_bgimage\";s:0:\"\";s:18:\"layout_right_class\";s:0:\"\";s:22:\"layout_leftspace_width\";s:0:\"\";s:24:\"layout_leftspace_bgcolor\";b:0;s:24:\"layout_leftspace_bgimage\";s:0:\"\";s:22:\"layout_leftspace_class\";s:0:\"\";s:23:\"layout_rightspace_width\";s:0:\"\";s:25:\"layout_rightspace_bgcolor\";b:0;s:25:\"layout_rightspace_bgimage\";s:0:\"\";s:23:\"layout_rightspace_class\";s:0:\"\";s:20:\"layout_header_height\";s:0:\"\";s:21:\"layout_header_bgcolor\";b:0;s:21:\"layout_header_bgimage\";s:0:\"\";s:19:\"layout_header_class\";s:0:\"\";s:22:\"layout_topspace_height\";s:0:\"\";s:23:\"layout_topspace_bgcolor\";b:0;s:23:\"layout_topspace_bgimage\";s:0:\"\";s:21:\"layout_topspace_class\";s:0:\"\";s:25:\"layout_bottomspace_height\";s:0:\"\";s:26:\"layout_bottomspace_bgcolor\";b:0;s:26:\"layout_bottomspace_bgimage\";s:0:\"\";s:24:\"layout_bottomspace_class\";s:0:\"\";s:20:\"layout_footer_height\";s:0:\"\";s:21:\"layout_footer_bgcolor\";b:0;s:21:\"layout_footer_bgimage\";s:0:\"\";s:19:\"layout_footer_class\";s:0:\"\";s:13:\"layout_render\";i:2;s:19:\"layout_customblocks\";s:0:\"\";}',0);
/*!40000 ALTER TABLE `phpwcms_pagelayout` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_profession`
--

DROP TABLE IF EXISTS `phpwcms_profession`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_profession` (
  `prof_id` int(4) NOT NULL AUTO_INCREMENT,
  `prof_name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`prof_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_profession`
--

LOCK TABLES `phpwcms_profession` WRITE;
/*!40000 ALTER TABLE `phpwcms_profession` DISABLE KEYS */;
INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (1,'architect'),(2,'geologist'),(3,'designer, graphic'),(4,'designer, web'),(5,'designer, industrial'),(6,'designer, interieur'),(7,'student'),(8,'architect, landscape'),(9,'teacher'),(10,'writer'),(11,'designer, interface'),(12,'designer, screen'),(13,'administrator'),(14,'webmaster'),(15,'geographer'),(16,'artist'),(17,'system operator'),(18,'academic'),(19,'theorist'),(20,'critic'),(21,'journalist'),(22,' n/a');
/*!40000 ALTER TABLE `phpwcms_profession` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_shop_orders`
--

DROP TABLE IF EXISTS `phpwcms_shop_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_shop_orders` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(20) NOT NULL DEFAULT '',
  `order_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `order_name` varchar(255) NOT NULL DEFAULT '',
  `order_firstname` varchar(255) NOT NULL DEFAULT '',
  `order_email` varchar(255) NOT NULL DEFAULT '',
  `order_net` float NOT NULL DEFAULT '0',
  `order_gross` float NOT NULL DEFAULT '0',
  `order_payment` varchar(255) NOT NULL DEFAULT '',
  `order_data` mediumtext NOT NULL,
  `order_status` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`order_id`),
  KEY `order_number` (`order_number`,`order_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_shop_orders`
--

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

--
-- Table structure for table `phpwcms_shop_products`
--

DROP TABLE IF EXISTS `phpwcms_shop_products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_shop_products` (
  `shopprod_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shopprod_createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `shopprod_changedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `shopprod_status` int(1) unsigned NOT NULL DEFAULT '0',
  `shopprod_uid` int(10) unsigned NOT NULL DEFAULT '0',
  `shopprod_ordernumber` varchar(255) NOT NULL DEFAULT '',
  `shopprod_model` varchar(255) NOT NULL DEFAULT '',
  `shopprod_name1` varchar(255) NOT NULL DEFAULT '',
  `shopprod_name2` varchar(255) NOT NULL DEFAULT '',
  `shopprod_tag` varchar(255) NOT NULL DEFAULT '',
  `shopprod_vat` float unsigned NOT NULL DEFAULT '0',
  `shopprod_netgross` int(1) unsigned NOT NULL DEFAULT '0',
  `shopprod_price` float NOT NULL DEFAULT '0',
  `shopprod_maxrebate` float NOT NULL DEFAULT '0',
  `shopprod_description0` text NOT NULL,
  `shopprod_description1` text NOT NULL,
  `shopprod_description2` text NOT NULL,
  `shopprod_description3` text NOT NULL,
  `shopprod_var` mediumtext NOT NULL,
  `shopprod_category` varchar(255) NOT NULL DEFAULT '',
  `shopprod_weight` float NOT NULL DEFAULT '0',
  `shopprod_color` varchar(255) NOT NULL DEFAULT '',
  `shopprod_size` varchar(255) NOT NULL DEFAULT '',
  `shopprod_listall` int(1) unsigned DEFAULT '0',
  `shopprod_special_price` text NOT NULL,
  `shopprod_track_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`shopprod_id`),
  KEY `shopprod_status` (`shopprod_status`),
  KEY `category` (`shopprod_category`),
  KEY `tag` (`shopprod_tag`),
  KEY `all` (`shopprod_listall`),
  KEY `shopprod_track_view` (`shopprod_track_view`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_shop_products`
--

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

--
-- Table structure for table `phpwcms_subscription`
--

DROP TABLE IF EXISTS `phpwcms_subscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_subscription` (
  `subscription_id` int(11) NOT NULL AUTO_INCREMENT,
  `subscription_name` text NOT NULL,
  `subscription_info` blob NOT NULL,
  `subscription_active` int(1) NOT NULL DEFAULT '0',
  `subscription_lang` varchar(100) NOT NULL DEFAULT '',
  `subscription_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`subscription_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_subscription`
--

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

--
-- Table structure for table `phpwcms_sysvalue`
--

DROP TABLE IF EXISTS `phpwcms_sysvalue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_sysvalue` (
  `sysvalue_key` varchar(255) NOT NULL DEFAULT '',
  `sysvalue_group` varchar(255) NOT NULL DEFAULT '',
  `sysvalue_lastchange` int(11) NOT NULL DEFAULT '0',
  `sysvalue_status` int(1) NOT NULL DEFAULT '0',
  `sysvalue_vartype` varchar(100) NOT NULL DEFAULT '',
  `sysvalue_value` text NOT NULL,
  PRIMARY KEY (`sysvalue_key`),
  KEY `sysvalue_group` (`sysvalue_group`),
  KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_sysvalue`
--

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

--
-- Table structure for table `phpwcms_template`
--

DROP TABLE IF EXISTS `phpwcms_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_template` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_type` int(11) NOT NULL DEFAULT '1',
  `template_name` varchar(255) NOT NULL DEFAULT '',
  `template_default` int(1) NOT NULL DEFAULT '0',
  `template_var` mediumblob NOT NULL,
  `template_trash` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_template`
--

LOCK TABLES `phpwcms_template` WRITE;
/*!40000 ALTER TABLE `phpwcms_template` DISABLE KEYS */;
INSERT INTO `phpwcms_template` (`template_id`, `template_type`, `template_name`, `template_default`, `template_var`, `template_trash`) VALUES (1,1,'Sample Template (very basic)',1,'a:14:{s:4:\"name\";s:28:\"Sample Template (very basic)\";s:7:\"default\";i:1;s:6:\"layout\";i:1;s:3:\"css\";a:1:{i:0;s:12:\"frontend.css\";}s:8:\"htmlhead\";s:0:\"\";s:8:\"jsonload\";s:0:\"\";s:10:\"headertext\";s:0:\"\";s:8:\"maintext\";s:677:\"<!-- very basic DIV based template -->\r\n<div style=\"padding:10px;border-bottom:1px solid #CC3300;margin:0 0 12px 0;background-color:#DDDDDD;\">\r\n<h3>My sample header</h3>\r\n</div>\r\n<div style=\"position:relative;top:-12px;float:right;padding:10px;border-bottom:1px solid #CC3300;border-left:1px solid #CC3300;margin:0 0 15px 15px;background-color:#DDDDDD;width:150px;\">\r\n<h6>navigation:</h6>\r\n{NAV_LIST_UL:P,0}\r\n</div>\r\n<p style=\"margin: 0 0 10px 0\">you are here: {BREADCRUMB}</p>\r\n{CONTENT}\r\n\r\n<div style=\"border-top:1px solid #CC3300;margin:15px 0 0 0;text-align:center;padding:7px;\">\r\ncopyright &copy; 2007 <a href=\"http://www.phpwcms.de\" target=\"_blank\">phpwcms.de</a>\r\n</div>\";s:10:\"footertext\";s:0:\"\";s:8:\"lefttext\";s:0:\"\";s:9:\"righttext\";s:0:\"\";s:9:\"errortext\";s:42:\"<h1>404 error page</h1>\r\n<p>No content</p>\";s:10:\"feloginurl\";s:0:\"\";s:2:\"id\";i:1;}',0);
/*!40000 ALTER TABLE `phpwcms_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_user`
--

DROP TABLE IF EXISTS `phpwcms_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_user` (
  `usr_id` int(11) NOT NULL AUTO_INCREMENT,
  `usr_login` varchar(30) NOT NULL DEFAULT '',
  `usr_pass` varchar(255) NOT NULL DEFAULT '',
  `usr_email` varchar(150) NOT NULL DEFAULT '',
  `usr_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `usr_rechte` tinyint(4) NOT NULL DEFAULT '0',
  `usr_admin` tinyint(1) NOT NULL DEFAULT '0',
  `usr_avatar` varchar(50) NOT NULL DEFAULT '',
  `usr_aktiv` int(1) NOT NULL DEFAULT '0',
  `usr_name` varchar(100) NOT NULL DEFAULT '',
  `usr_var_structure` blob NOT NULL,
  `usr_var_publicfile` blob NOT NULL,
  `usr_var_privatefile` blob NOT NULL,
  `usr_lang` varchar(50) NOT NULL DEFAULT '',
  `usr_wysiwyg` int(2) NOT NULL DEFAULT '0',
  `usr_fe` int(1) NOT NULL DEFAULT '0',
  `usr_vars` mediumtext NOT NULL,
  PRIMARY KEY (`usr_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_user`
--

LOCK TABLES `phpwcms_user` WRITE;
/*!40000 ALTER TABLE `phpwcms_user` DISABLE KEYS */;
INSERT INTO `phpwcms_user` (`usr_id`, `usr_login`, `usr_pass`, `usr_email`, `usr_tstamp`, `usr_rechte`, `usr_admin`, `usr_avatar`, `usr_aktiv`, `usr_name`, `usr_var_structure`, `usr_var_publicfile`, `usr_var_privatefile`, `usr_lang`, `usr_wysiwyg`, `usr_fe`, `usr_vars`) VALUES (1,'albatroz','6081ca43f184bf3240dd264737353709','pedro.martins@albatroz-eng.com','2011-11-03 10:28:07',0,1,'',1,'Pedro Martins','','','','en',2,2,'');
/*!40000 ALTER TABLE `phpwcms_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpwcms_userdetail`
--

DROP TABLE IF EXISTS `phpwcms_userdetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_userdetail` (
  `detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `detail_regkey` varchar(255) NOT NULL DEFAULT '',
  `detail_pid` int(11) NOT NULL DEFAULT '0',
  `detail_formid` int(11) NOT NULL DEFAULT '0',
  `detail_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `detail_title` varchar(255) NOT NULL DEFAULT '',
  `detail_salutation` varchar(255) NOT NULL DEFAULT '',
  `detail_firstname` varchar(255) NOT NULL DEFAULT '',
  `detail_lastname` varchar(255) NOT NULL DEFAULT '',
  `detail_company` varchar(255) NOT NULL DEFAULT '',
  `detail_street` varchar(255) NOT NULL DEFAULT '',
  `detail_add` varchar(255) NOT NULL DEFAULT '',
  `detail_city` varchar(255) NOT NULL DEFAULT '',
  `detail_zip` varchar(255) NOT NULL DEFAULT '',
  `detail_region` varchar(255) NOT NULL DEFAULT '',
  `detail_country` varchar(255) NOT NULL DEFAULT '',
  `detail_fon` varchar(255) NOT NULL DEFAULT '',
  `detail_fax` varchar(255) NOT NULL DEFAULT '',
  `detail_mobile` varchar(255) NOT NULL DEFAULT '',
  `detail_signature` varchar(255) NOT NULL DEFAULT '',
  `detail_prof` varchar(255) NOT NULL DEFAULT '',
  `detail_notes` blob NOT NULL,
  `detail_public` int(1) NOT NULL DEFAULT '1',
  `detail_aktiv` int(1) NOT NULL DEFAULT '1',
  `detail_newsletter` int(11) NOT NULL DEFAULT '0',
  `detail_website` varchar(255) NOT NULL DEFAULT '',
  `detail_userimage` varchar(255) NOT NULL DEFAULT '',
  `detail_gender` varchar(255) NOT NULL DEFAULT '',
  `detail_birthday` date NOT NULL DEFAULT '0000-00-00',
  `detail_varchar1` varchar(255) NOT NULL DEFAULT '',
  `detail_varchar2` varchar(255) NOT NULL DEFAULT '',
  `detail_varchar3` varchar(255) NOT NULL DEFAULT '',
  `detail_varchar4` varchar(255) NOT NULL DEFAULT '',
  `detail_varchar5` varchar(255) NOT NULL DEFAULT '',
  `detail_text1` text NOT NULL,
  `detail_text2` text NOT NULL,
  `detail_text3` text NOT NULL,
  `detail_text4` text NOT NULL,
  `detail_text5` text NOT NULL,
  `detail_email` varchar(255) NOT NULL DEFAULT '',
  `detail_login` varchar(255) NOT NULL DEFAULT '',
  `detail_password` varchar(255) NOT NULL DEFAULT '',
  `userdetail_lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `detail_int1` bigint(20) NOT NULL DEFAULT '0',
  `detail_int2` bigint(20) NOT NULL DEFAULT '0',
  `detail_int3` bigint(20) NOT NULL DEFAULT '0',
  `detail_int4` bigint(20) NOT NULL DEFAULT '0',
  `detail_int5` bigint(20) NOT NULL DEFAULT '0',
  `detail_float1` double NOT NULL DEFAULT '0',
  `detail_float2` double NOT NULL DEFAULT '0',
  `detail_float3` double NOT NULL DEFAULT '0',
  `detail_float4` double NOT NULL DEFAULT '0',
  `detail_float5` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`detail_id`),
  KEY `detail_pid` (`detail_pid`),
  KEY `detail_formid` (`detail_formid`),
  KEY `detail_password` (`detail_password`),
  KEY `detail_aktiv` (`detail_aktiv`),
  KEY `detail_regkey` (`detail_regkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_userdetail`
--

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

--
-- Table structure for table `phpwcms_usergroup`
--

DROP TABLE IF EXISTS `phpwcms_usergroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_usergroup` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) NOT NULL DEFAULT '',
  `group_member` mediumtext NOT NULL,
  `group_value` longblob NOT NULL,
  `group_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `group_trash` int(1) NOT NULL DEFAULT '0',
  `group_active` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`group_id`),
  KEY `group_member` (`group_member`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_usergroup`
--

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

--
-- Table structure for table `phpwcms_userlog`
--

DROP TABLE IF EXISTS `phpwcms_userlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phpwcms_userlog` (
  `userlog_id` int(11) NOT NULL AUTO_INCREMENT,
  `logged_user` varchar(30) NOT NULL DEFAULT '',
  `logged_username` varchar(100) NOT NULL DEFAULT '',
  `logged_start` int(11) unsigned NOT NULL DEFAULT '0',
  `logged_change` int(11) unsigned NOT NULL DEFAULT '0',
  `logged_in` int(1) NOT NULL DEFAULT '0',
  `logged_ip` varchar(24) NOT NULL DEFAULT '',
  `logged_section` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userlog_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phpwcms_userlog`
--

LOCK TABLES `phpwcms_userlog` WRITE;
/*!40000 ALTER TABLE `phpwcms_userlog` DISABLE KEYS */;
INSERT INTO `phpwcms_userlog` (`userlog_id`, `logged_user`, `logged_username`, `logged_start`, `logged_change`, `logged_in`, `logged_ip`, `logged_section`) VALUES (2,'albatroz','Pedro Martins',1320316128,1320316145,1,'85.247.173.123',0);
/*!40000 ALTER TABLE `phpwcms_userlog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'albatroz_wcms1'
--

--
-- Dumping routines for database 'albatroz_wcms1'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2018-12-15 14:37:16
[ Back ]
𝗡𝗔𝗠𝗘	𝗦𝗜𝗭𝗘	𝗟𝗔𝗦𝗧 𝗧𝗢𝗨𝗖𝗛	𝗨𝗦𝗘𝗥	𝗦𝗧𝗔𝗧𝗨𝗦
..	--	11 Jun 2026 3.15 AM	albatroz / albatroz	0711
pictures	--	11 Jun 2026 3.15 AM	albatroz / albatroz	0755

albatroz_appCred.create	1.402 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_appCred.sql	1.348 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_carpi.create	1.422 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_carpi.sql	13.77 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_ifarmer.create	1.43 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_ifarmer.sql	633.488 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_mediawiki.create	1.41 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_mediawiki.sql	1.354 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_tiwi1.create	1.395 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_tiwi1.sql	278.145 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_users.create	1.395 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_users.sql	2.21 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wcms1.create	1.395 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wcms1.sql	93.703 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp.create	1.381 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp.sql	222.15 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp21.create	1.418 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp21.sql	15.84 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp283.create	1.422 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp283.sql	2.03 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp543.create	1.422 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp543.sql	206.127 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp552.create	1.393 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wp552.sql	3.66 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wpnew.create	1.395 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
albatroz_wpnew.sql	116.37 MB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
cjfuns.php	126.33 KB	11 Jun 2026 3.09 AM	albatroz / albatroz	0444
dd.php	96.12 KB	11 Jun 2026 3.15 AM	albatroz / albatroz	0444
gg.php	3.746 KB	11 Jun 2026 3.11 AM	albatroz / albatroz	0444
kk.php	6.745 KB	11 Jun 2026 3.10 AM	albatroz / albatroz	0444
openfileslimit	0.006 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0600
roundcube.sql	252.165 KB	15 Dec 2018 2.37 PM	albatroz / albatroz	0644
✘✘ GRAYBYTE WORDPRESS FILE MANAGER @ 2026 CONTACT ME ✘✘