[Summary view] [Print] [Text view]

   1  -- phpMyAdmin SQL Dump
   2  -- version 2.11.6
   3  -- http://www.phpmyadmin.net
   4  --
   5  -- Host: localhost
   6  -- Erstellungszeit: 18. Juni 2008 um 08:15
   7  -- Server Version: 5.0.51
   8  -- PHP-Version: 5.2.5
   9  
  10  #SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11  
  12  --
  13  -- Datenbank: `dev_phpwcms`
  14  --
  15  
  16  -- --------------------------------------------------------
  17  
  18  --
  19  -- Tabellenstruktur für Tabelle `phpwcms_address`
  20  --
  21  
  22  CREATE TABLE `phpwcms_address` (
  23    `address_id` int(11) NOT NULL auto_increment,
  24    `address_key` varchar(255) NOT NULL default '',
  25    `address_email` text NOT NULL,
  26    `address_name` text NOT NULL,
  27    `address_verified` int(1) NOT NULL default '0',
  28    `address_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  29    `address_subscription` blob NOT NULL,
  30    `address_iddetail` int(11) NOT NULL default '0',
  31    `address_url1` varchar(255) NOT NULL default '',
  32    `address_url2` varchar(255) NOT NULL default '',
  33    PRIMARY KEY  (`address_id`)
  34  ) ENGINE=MyISAM;
  35  
  36  -- --------------------------------------------------------
  37  
  38  --
  39  -- Tabellenstruktur für Tabelle `phpwcms_ads_campaign`
  40  --
  41  
  42  CREATE TABLE `phpwcms_ads_campaign` (
  43    `adcampaign_id` int(11) NOT NULL auto_increment,
  44    `adcampaign_created` datetime NOT NULL default '0000-00-00 00:00:00',
  45    `adcampaign_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  46    `adcampaign_status` int(1) NOT NULL default '0',
  47    `adcampaign_title` varchar(255) NOT NULL default '',
  48    `adcampaign_comment` text NOT NULL,
  49    `adcampaign_datestart` datetime NOT NULL default '0000-00-00 00:00:00',
  50    `adcampaign_dateend` datetime NOT NULL default '0000-00-00 00:00:00',
  51    `adcampaign_maxview` int(11) NOT NULL default '0',
  52    `adcampaign_maxclick` int(11) NOT NULL default '0',
  53    `adcampaign_maxviewuser` int(11) NOT NULL default '0',
  54    `adcampaign_curview` int(11) NOT NULL default '0',
  55    `adcampaign_curclick` int(11) NOT NULL default '0',
  56    `adcampaign_curviewuser` int(11) NOT NULL default '0',
  57    `adcampaign_type` int(11) NOT NULL default '0',
  58    `adcampaign_place` int(11) NOT NULL default '0',
  59    `adcampaign_data` mediumtext NOT NULL,
  60    PRIMARY KEY  (`adcampaign_id`),
  61    KEY `adcampaign_status` (`adcampaign_status`,`adcampaign_datestart`,`adcampaign_dateend`,`adcampaign_type`,`adcampaign_place`),
  62    KEY `adcampaign_maxview` (`adcampaign_maxview`,`adcampaign_maxclick`,`adcampaign_maxviewuser`),
  63    KEY `adcampaign_curview` (`adcampaign_curview`,`adcampaign_curclick`,`adcampaign_curviewuser`)
  64  ) ENGINE=MyISAM;
  65  
  66  -- --------------------------------------------------------
  67  
  68  --
  69  -- Tabellenstruktur für Tabelle `phpwcms_ads_formats`
  70  --
  71  
  72  CREATE TABLE `phpwcms_ads_formats` (
  73    `adformat_id` int(11) NOT NULL auto_increment,
  74    `adformat_created` datetime NOT NULL default '0000-00-00 00:00:00',
  75    `adformat_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  76    `adformat_status` int(1) NOT NULL default '0',
  77    `adformat_title` varchar(25) NOT NULL default '',
  78    `adformat_width` int(5) NOT NULL default '0',
  79    `adformat_height` int(5) NOT NULL default '0',
  80    `adformat_comment` text NOT NULL,
  81    PRIMARY KEY  (`adformat_id`),
  82    KEY `adformat_status` (`adformat_status`)
  83  ) ENGINE=MyISAM;
  84  
  85  -- --------------------------------------------------------
  86  
  87  --
  88  -- Tabellenstruktur für Tabelle `phpwcms_ads_place`
  89  --
  90  
  91  CREATE TABLE `phpwcms_ads_place` (
  92    `adplace_id` int(11) NOT NULL auto_increment,
  93    `adplace_created` datetime NOT NULL default '0000-00-00 00:00:00',
  94    `adplace_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  95    `adplace_status` int(1) NOT NULL default '0',
  96    `adplace_title` varchar(255) NOT NULL default '',
  97    `adplace_format` int(11) NOT NULL default '0',
  98    `adplace_width` int(11) NOT NULL default '0',
  99    `adplace_height` int(11) NOT NULL default '0',
 100    `adplace_prefix` varchar(255) NOT NULL default '',
 101    `adplace_suffix` varchar(255) NOT NULL default '',
 102    PRIMARY KEY  (`adplace_id`),
 103    KEY `adplace_status` (`adplace_status`)
 104  ) ENGINE=MyISAM;
 105  
 106  -- --------------------------------------------------------
 107  
 108  --
 109  -- Tabellenstruktur für Tabelle `phpwcms_ads_tracking`
 110  --
 111  
 112  CREATE TABLE `phpwcms_ads_tracking` (
 113    `adtracking_id` int(11) NOT NULL auto_increment,
 114    `adtracking_created` datetime NOT NULL default '0000-00-00 00:00:00',
 115    `adtracking_campaignid` int(11) NOT NULL default '0',
 116    `adtracking_ip` varchar(30) NOT NULL default '',
 117    `adtracking_cookieid` varchar(50) NOT NULL default '',
 118    `adtracking_countclick` int(11) NOT NULL default '0',
 119    `adtracking_countview` int(11) NOT NULL default '0',
 120    `adtracking_useragent` varchar(255) NOT NULL default '',
 121    `adtracking_ref` text NOT NULL,
 122    `adtracking_catid` int(11) NOT NULL default '0',
 123    `adtracking_articleid` int(11) NOT NULL default '0',
 124    PRIMARY KEY  (`adtracking_id`),
 125    KEY `adtracking_campaignid` (`adtracking_campaignid`,`adtracking_ip`,`adtracking_countclick`,`adtracking_countview`),
 126    KEY `adtracking_cookieid` (`adtracking_cookieid`)
 127  ) ENGINE=MyISAM;
 128  
 129  -- --------------------------------------------------------
 130  
 131  --
 132  -- Tabellenstruktur für Tabelle `phpwcms_article`
 133  --
 134  
 135  CREATE TABLE `phpwcms_article` (
 136    `article_id` int(11) NOT NULL auto_increment,
 137    `article_cid` int(11) NOT NULL default '0',
 138    `article_tid` int(11) NOT NULL default '0',
 139    `article_uid` int(11) NOT NULL default '0',
 140    `article_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 141    `article_username` varchar(255) NOT NULL default '',
 142    `article_title` text NOT NULL,
 143    `article_alias` varchar(255) NOT NULL default '',
 144    `article_keyword` text NOT NULL,
 145    `article_public` int(1) NOT NULL default '0',
 146    `article_deleted` int(1) NOT NULL default '0',
 147    `article_begin` datetime NOT NULL default '0000-00-00 00:00:00',
 148    `article_end` datetime NOT NULL default '0000-00-00 00:00:00',
 149    `article_aktiv` int(1) NOT NULL default '0',
 150    `article_subtitle` text NOT NULL,
 151    `article_summary` text NOT NULL,
 152    `article_redirect` text NOT NULL,
 153    `article_sort` int(11) NOT NULL default '0',
 154    `article_notitle` int(1) NOT NULL default '0',
 155    `article_hidesummary` int(1) NOT NULL default '0',
 156    `article_image` blob NOT NULL,
 157    `article_created` varchar(14) NOT NULL default '',
 158    `article_cache` varchar(10) NOT NULL default '0',
 159    `article_nosearch` char(1) NOT NULL default '0',
 160    `article_nositemap` int(1) NOT NULL default '0',
 161    `article_aliasid` int(11) NOT NULL default '0',
 162    `article_headerdata` int(1) NOT NULL default '0',
 163    `article_morelink` int(1) NOT NULL default '1',
 164    `article_pagetitle` varchar(255) NOT NULL default '',
 165    `article_paginate` int(1) NOT NULL default '0',
 166    `article_serialized` blob NOT NULL,
 167    `article_priorize` int(5) NOT NULL default '0',
 168    `article_norss` int(1) NOT NULL default '1',
 169    `article_archive_status` int(1) NOT NULL default '1',
 170    `article_menutitle` varchar(255) NOT NULL,
 171    PRIMARY KEY  (`article_id`),
 172    KEY `article_aktiv` (`article_aktiv`),
 173    KEY `article_public` (`article_public`),
 174    KEY `article_deleted` (`article_deleted`),
 175    KEY `article_nosearch` (`article_nosearch`),
 176    KEY `article_begin` (`article_begin`),
 177    KEY `article_end` (`article_end`),
 178    KEY `article_cid` (`article_cid`),
 179    KEY `article_tstamp` (`article_tstamp`),
 180    KEY `article_priorize` (`article_priorize`),
 181    KEY `article_sort` (`article_sort`),
 182    KEY `article_alias` (`article_alias`),
 183    KEY `article_archive_status` (`article_archive_status`)
 184  ) ENGINE=MyISAM;
 185  
 186  -- --------------------------------------------------------
 187  
 188  --
 189  -- Tabellenstruktur für Tabelle `phpwcms_articlecat`
 190  --
 191  
 192  CREATE TABLE `phpwcms_articlecat` (
 193    `acat_id` int(11) NOT NULL auto_increment,
 194    `acat_name` text NOT NULL,
 195    `acat_info` text NOT NULL,
 196    `acat_public` int(1) NOT NULL default '0',
 197    `acat_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 198    `acat_aktiv` int(1) NOT NULL default '0',
 199    `acat_uid` int(11) NOT NULL default '0',
 200    `acat_trash` int(1) NOT NULL default '0',
 201    `acat_struct` int(11) NOT NULL default '0',
 202    `acat_sort` int(11) NOT NULL default '0',
 203    `acat_alias` varchar(250) NOT NULL default '',
 204    `acat_hidden` int(1) NOT NULL default '0',
 205    `acat_template` int(11) NOT NULL default '0',
 206    `acat_ssl` int(1) NOT NULL default '0',
 207    `acat_regonly` int(1) NOT NULL default '0',
 208    `acat_topcount` int(11) NOT NULL default '0',
 209    `acat_redirect` text NOT NULL,
 210    `acat_order` int(2) NOT NULL default '0',
 211    `acat_cache` varchar(10) NOT NULL default '',
 212    `acat_nosearch` char(1) NOT NULL default '',
 213    `acat_nositemap` int(1) NOT NULL default '0',
 214    `acat_permit` text NOT NULL,
 215    `acat_maxlist` int(11) NOT NULL default '0',
 216    `acat_cntpart` varchar(255) NOT NULL default '',
 217    `acat_pagetitle` varchar(255) NOT NULL default '',
 218    `acat_paginate` int(1) NOT NULL default '0',
 219    `acat_overwrite` varchar(255) NOT NULL default '',
 220    `acat_archive` int(1) NOT NULL default '0',
 221    PRIMARY KEY  (`acat_id`),
 222    KEY `acat_struct` (`acat_struct`),
 223    KEY `acat_sort` (`acat_sort`),
 224    KEY `acat_alias` (`acat_alias`),
 225    KEY `acat_archive` (`acat_archive`)
 226  ) ENGINE=MyISAM;
 227  
 228  -- --------------------------------------------------------
 229  
 230  --
 231  -- Tabellenstruktur für Tabelle `phpwcms_articlecontent`
 232  --
 233  
 234  CREATE TABLE `phpwcms_articlecontent` (
 235    `acontent_id` int(11) NOT NULL auto_increment,
 236    `acontent_aid` int(11) NOT NULL default '0',
 237    `acontent_uid` int(11) NOT NULL default '0',
 238    `acontent_created` timestamp NOT NULL default '0000-00-00 00:00:00',
 239    `acontent_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 240    `acontent_title` text NOT NULL,
 241    `acontent_text` text NOT NULL,
 242    `acontent_type` int(10) NOT NULL default '0',
 243    `acontent_sorting` int(11) NOT NULL default '0',
 244    `acontent_image` text NOT NULL,
 245    `acontent_files` text NOT NULL,
 246    `acontent_visible` int(1) NOT NULL default '0',
 247    `acontent_subtitle` text NOT NULL,
 248    `acontent_before` varchar(10) NOT NULL default '',
 249    `acontent_after` varchar(10) NOT NULL default '',
 250    `acontent_top` int(1) NOT NULL default '0',
 251    `acontent_redirect` text NOT NULL,
 252    `acontent_html` text NOT NULL,
 253    `acontent_trash` int(1) NOT NULL default '0',
 254    `acontent_alink` text NOT NULL,
 255    `acontent_media` text NOT NULL,
 256    `acontent_form` mediumtext NOT NULL,
 257    `acontent_newsletter` mediumtext NOT NULL,
 258    `acontent_block` varchar(200) NOT NULL default '0',
 259    `acontent_anchor` int(1) NOT NULL default '0',
 260    `acontent_template` varchar(255) NOT NULL default '',
 261    `acontent_spacer` int(1) NOT NULL default '0',
 262    `acontent_tid` int(11) NOT NULL default '0',
 263    `acontent_livedate` datetime NOT NULL default '0000-00-00 00:00:00',
 264    `acontent_killdate` datetime NOT NULL default '0000-00-00 00:00:00',
 265    `acontent_module` varchar(255) NOT NULL default '',
 266    `acontent_comment` text NOT NULL,
 267    `acontent_paginate_page` int(5) NOT NULL default '0',
 268    `acontent_paginate_title` varchar(255) NOT NULL default '',
 269    `acontent_category` varchar(255) NOT NULL,
 270    `acontent_granted` int(11) NOT NULL default '0',
 271    PRIMARY KEY  (`acontent_id`),
 272    KEY `acontent_aid` (`acontent_aid`),
 273    KEY `acontent_sorting` (`acontent_sorting`),
 274    KEY `acontent_type` (`acontent_type`),
 275    KEY `acontent_livedate` (`acontent_livedate`,`acontent_killdate`),
 276    KEY `acontent_paginate` (`acontent_paginate_page`),
 277    KEY `acontent_granted` (`acontent_granted`)
 278  ) ENGINE=MyISAM;
 279  
 280  -- --------------------------------------------------------
 281  
 282  --
 283  -- Tabellenstruktur für Tabelle `phpwcms_bad_behavior`
 284  --
 285  
 286  CREATE TABLE `phpwcms_bad_behavior` (
 287    `id` int(11) NOT NULL auto_increment,
 288    `ip` text NOT NULL,
 289    `date` datetime NOT NULL default '0000-00-00 00:00:00',
 290    `request_method` text NOT NULL,
 291    `request_uri` text NOT NULL,
 292    `server_protocol` text NOT NULL,
 293    `http_headers` text NOT NULL,
 294    `user_agent` text NOT NULL,
 295    `request_entity` text NOT NULL,
 296    `key` text NOT NULL,
 297    PRIMARY KEY  (`id`),
 298    KEY `ip` (`ip`(15)),
 299    KEY `user_agent` (`user_agent`(10))
 300  ) ENGINE=MyISAM;
 301  
 302  -- --------------------------------------------------------
 303  
 304  --
 305  -- Tabellenstruktur für Tabelle `phpwcms_bid`
 306  --
 307  
 308  CREATE TABLE `phpwcms_bid` (
 309    `bid_id` int(11) NOT NULL auto_increment,
 310    `bid_cid` int(11) NOT NULL default '0',
 311    `bid_email` text NOT NULL,
 312    `bid_hash` varchar(255) NOT NULL default '',
 313    `bid_amount` float NOT NULL default '0',
 314    `bid_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 315    `bid_verified` int(1) NOT NULL default '0',
 316    `bid_trashed` int(1) NOT NULL default '0',
 317    `bid_vars` mediumblob NOT NULL,
 318    PRIMARY KEY  (`bid_id`)
 319  ) ENGINE=MyISAM;
 320  
 321  -- --------------------------------------------------------
 322  
 323  --
 324  -- Tabellenstruktur für Tabelle `phpwcms_cache`
 325  --
 326  
 327  CREATE TABLE `phpwcms_cache` (
 328    `cache_id` int(11) NOT NULL auto_increment,
 329    `cache_hash` varchar(50) NOT NULL default '',
 330    `cache_uri` text NOT NULL,
 331    `cache_cid` int(11) NOT NULL default '0',
 332    `cache_aid` int(11) NOT NULL default '0',
 333    `cache_timeout` varchar(20) NOT NULL default '0',
 334    `cache_isprint` int(1) NOT NULL default '0',
 335    `cache_changed` int(14) default NULL,
 336    `cache_use` int(1) NOT NULL default '0',
 337    `cache_searchable` int(1) NOT NULL default '0',
 338    `cache_page` longtext NOT NULL,
 339    `cache_stripped` longtext NOT NULL,
 340    PRIMARY KEY  (`cache_id`),
 341    KEY `cache_hash` (`cache_hash`),
 342    FULLTEXT KEY `cache_stripped` (`cache_stripped`)
 343  ) ENGINE=MyISAM ;
 344  
 345  -- --------------------------------------------------------
 346  
 347  --
 348  -- Tabellenstruktur für Tabelle `phpwcms_calendar`
 349  --
 350  
 351  CREATE TABLE `phpwcms_calendar` (
 352    `calendar_id` int(11) NOT NULL auto_increment,
 353    `calendar_created` datetime NOT NULL default '0000-00-00 00:00:00',
 354    `calendar_changed` datetime NOT NULL default '0000-00-00 00:00:00',
 355    `calendar_status` int(1) NOT NULL default '0',
 356    `calendar_start` datetime NOT NULL default '0000-00-00 00:00:00',
 357    `calendar_end` datetime NOT NULL default '0000-00-00 00:00:00',
 358    `calendar_allday` int(1) NOT NULL default '0',
 359    `calendar_range` int(1) NOT NULL default '0',
 360    `calendar_range_start` date NOT NULL default '0000-00-00',
 361    `calendar_range_end` date NOT NULL default '0000-00-00',
 362    `calendar_title` varchar(255) NOT NULL default '',
 363    `calendar_where` varchar(255) NOT NULL default '',
 364    `calendar_teaser` text NOT NULL,
 365    `calendar_text` mediumtext NOT NULL,
 366    `calendar_tag` varchar(255) NOT NULL default '',
 367    `calendar_object` longtext NOT NULL,
 368    `calendar_refid` varchar(255) NOT NULL default '',
 369    `calendar_lang` varchar(255) NOT NULL default '',
 370    PRIMARY KEY  (`calendar_id`),
 371    KEY `calendar_status` (`calendar_status`),
 372    KEY `calendar_start` (`calendar_start`),
 373    KEY `calendar_end` (`calendar_end`),
 374    KEY `calendar_tag` (`calendar_tag`),
 375    KEY `calendar_refid` (`calendar_refid`),
 376    KEY `calendar_range` (`calendar_range`),
 377    KEY `calendar_lang` (`calendar_lang`)
 378  ) ENGINE=MyISAM;
 379  
 380  -- --------------------------------------------------------
 381  
 382  --
 383  -- Tabellenstruktur für Tabelle `phpwcms_categories`
 384  --
 385  
 386  CREATE TABLE `phpwcms_categories` (
 387    `cat_id` int(10) unsigned NOT NULL auto_increment,
 388    `cat_type` varchar(255) NOT NULL default '',
 389    `cat_pid` int(11) NOT NULL default '0',
 390    `cat_status` int(1) NOT NULL default '0',
 391    `cat_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
 392    `cat_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
 393    `cat_name` varchar(255) NOT NULL default '',
 394    `cat_info` text NOT NULL,
 395    PRIMARY KEY  (`cat_id`),
 396    KEY `cat_type` (`cat_type`,`cat_status`),
 397    KEY `cat_pid` (`cat_pid`)
 398  ) ENGINE=MyISAM;
 399  
 400  -- --------------------------------------------------------
 401  
 402  --
 403  -- Tabellenstruktur für Tabelle `phpwcms_chat`
 404  --
 405  
 406  CREATE TABLE `phpwcms_chat` (
 407    `chat_id` int(11) NOT NULL auto_increment,
 408    `chat_uid` int(11) NOT NULL default '0',
 409    `chat_name` varchar(30) NOT NULL default '',
 410    `chat_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 411    `chat_text` varchar(255) NOT NULL default '',
 412    `chat_cat` int(5) NOT NULL default '0',
 413    PRIMARY KEY  (`chat_id`)
 414  ) ENGINE=MyISAM;
 415  
 416  -- --------------------------------------------------------
 417  
 418  --
 419  -- Tabellenstruktur für Tabelle `phpwcms_content`
 420  --
 421  
 422  CREATE TABLE `phpwcms_content` (
 423    `cnt_id` int(11) NOT NULL auto_increment,
 424    `cnt_pid` int(11) NOT NULL default '0',
 425    `cnt_created` int(11) NOT NULL default '0',
 426    `cnt_changed` int(11) NOT NULL default '0',
 427    `cnt_status` int(1) NOT NULL default '0',
 428    `cnt_type` varchar(255) NOT NULL,
 429    `cnt_module` varchar(255) NOT NULL,
 430    `cnt_group` int(11) NOT NULL default '0',
 431    `cnt_owner` int(11) NOT NULL default '0',
 432    `cnt_livedate` datetime NOT NULL default '0000-00-00 00:00:00',
 433    `cnt_killdate` datetime NOT NULL default '0000-00-00 00:00:00',
 434    `cnt_archive_status` int(11) NOT NULL default '0',
 435    `cnt_sort` int(11) NOT NULL default '0',
 436    `cnt_prio` int(11) NOT NULL default '0',
 437    `cnt_alias` varchar(255) NOT NULL,
 438    `cnt_name` varchar(255) NOT NULL default '',
 439    `cnt_title` varchar(255) NOT NULL default '',
 440    `cnt_subtitle` varchar(255) NOT NULL default '',
 441    `cnt_editor` varchar(255) NOT NULL,
 442    `cnt_place` varchar(255) NOT NULL,
 443    `cnt_teasertext` text NOT NULL,
 444    `cnt_text` text NOT NULL,
 445    `cnt_lang` varchar(10) NOT NULL default '',
 446    `cnt_object` text NOT NULL,
 447    PRIMARY KEY  (`cnt_id`),
 448    KEY `cnt_livedate` (`cnt_livedate`),
 449    KEY `cnt_killdate` (`cnt_killdate`),
 450    KEY `cnt_module` (`cnt_module`),
 451    KEY `cnt_type` (`cnt_type`),
 452    KEY `cnt_group` (`cnt_group`),
 453    KEY `cnt_owner` (`cnt_owner`),
 454    KEY `cnt_alias` (`cnt_alias`),
 455    KEY `cnt_pid` (`cnt_pid`),
 456    KEY `cnt_sort` (`cnt_sort`),
 457    KEY `cnt_prio` (`cnt_prio`)
 458  ) ENGINE=MyISAM;
 459  
 460  -- --------------------------------------------------------
 461  
 462  --
 463  -- Tabellenstruktur für Tabelle `phpwcms_country`
 464  --
 465  
 466  CREATE TABLE `phpwcms_country` (
 467    `country_id` int(4) NOT NULL auto_increment,
 468    `country_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 469    `country_iso` char(2) NOT NULL default '',
 470    `country_iso3` char(3) NOT NULL default '',
 471    `country_isonum` int(11) NOT NULL default '0',
 472    `country_continent_code` char(2) NOT NULL default '',
 473    `country_name` varchar(100) NOT NULL,
 474    `country_name_de` varchar(255) NOT NULL,
 475    `country_continent` varchar(255) NOT NULL default '',
 476    `country_continent_de` varchar(255) NOT NULL default '',
 477    `country_region` varchar(255) NOT NULL default '',
 478    `country_region_de` varchar(255) NOT NULL default '',
 479    PRIMARY KEY  (`country_id`),
 480    UNIQUE KEY `country_iso` (`country_iso`),
 481    UNIQUE KEY `country_name` (`country_name`)
 482  ) ENGINE=MyISAM;
 483  
 484  -- --------------------------------------------------------
 485  
 486  --
 487  -- Tabellenstruktur für Tabelle `phpwcms_crossreference`
 488  --
 489  
 490  CREATE TABLE `phpwcms_crossreference` (
 491    `cref_id` int(11) NOT NULL AUTO_INCREMENT,
 492    `cref_type` int(11) NOT NULL DEFAULT '0',
 493    `cref_module` varchar(255) NOT NULL DEFAULT '',
 494    `cref_rid` int(11) NOT NULL DEFAULT '0',
 495    `cref_int` int(11) NOT NULL DEFAULT '0',
 496    `cref_str` varchar(255) NOT NULL DEFAULT '',
 497    PRIMARY KEY (`cref_id`),
 498    KEY `cref_type` (`cref_type`,`cref_rid`,`cref_int`,`cref_str`),
 499    KEY `cref_module` (`cref_module`)
 500  ) ENGINE=MyISAM;
 501  
 502  -- --------------------------------------------------------
 503  
 504  --
 505  -- Tabellenstruktur für Tabelle `phpwcms_file`
 506  --
 507  
 508  CREATE TABLE `phpwcms_file` (
 509    `f_id` int(11) NOT NULL auto_increment,
 510    `f_pid` int(11) NOT NULL default '0',
 511    `f_uid` int(11) NOT NULL default '0',
 512    `f_kid` int(2) NOT NULL default '0',
 513    `f_order` int(11) NOT NULL default '0',
 514    `f_trash` int(1) NOT NULL default '0',
 515    `f_aktiv` int(1) NOT NULL default '0',
 516    `f_public` int(1) NOT NULL default '0',
 517    `f_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 518    `f_name` varchar(255) NOT NULL default '',
 519    `f_cat` varchar(255) NOT NULL,
 520    `f_created` int(11) NOT NULL default '0',
 521    `f_changed` int(11) NOT NULL default '0',
 522    `f_size` int(15) unsigned NOT NULL,
 523    `f_type` varchar(200) NOT NULL default '',
 524    `f_ext` varchar(50) NOT NULL default '',
 525    `f_shortinfo` varchar(255) NOT NULL default '',
 526    `f_longinfo` text NOT NULL,
 527    `f_thumb_list` varchar(255) NOT NULL default '',
 528    `f_thumb_preview` varchar(255) NOT NULL default '',
 529    `f_keywords` varchar(255) NOT NULL default '',
 530    `f_hash` varchar(50) NOT NULL default '',
 531    `f_dlstart` int(11) NOT NULL default '0',
 532    `f_dlfinal` int(11) NOT NULL default '0',
 533    `f_refid` int(11) NOT NULL default '0',
 534    `f_copyright` varchar(255) NOT NULL,
 535    `f_tags` varchar(255) NOT NULL,
 536    `f_granted` int(11) NOT NULL default '0',
 537    `f_gallerystatus` int(1) NOT NULL default '0',
 538    `f_vars` blob NOT NULL,
 539    `f_sort` int(11) NOT NULL default '0',
 540    PRIMARY KEY  (`f_id`),
 541    KEY `f_granted` (`f_granted`),
 542    KEY `f_sort` (`f_sort`),
 543    FULLTEXT KEY `f_name` (`f_name`),
 544    FULLTEXT KEY `f_shortinfo` (`f_shortinfo`)
 545  ) ENGINE=MyISAM;
 546  
 547  -- --------------------------------------------------------
 548  
 549  --
 550  -- Tabellenstruktur für Tabelle `phpwcms_filecat`
 551  --
 552  
 553  CREATE TABLE `phpwcms_filecat` (
 554    `fcat_id` int(11) NOT NULL auto_increment,
 555    `fcat_name` varchar(255) NOT NULL default '',
 556    `fcat_aktiv` int(1) NOT NULL default '0',
 557    `fcat_deleted` int(1) NOT NULL default '0',
 558    `fcat_needed` int(1) NOT NULL default '0',
 559    `fcat_sort` int(11) NOT NULL default '0',
 560    PRIMARY KEY  (`fcat_id`)
 561  ) ENGINE=MyISAM;
 562  
 563  -- --------------------------------------------------------
 564  
 565  --
 566  -- Tabellenstruktur für Tabelle `phpwcms_filekey`
 567  --
 568  
 569  CREATE TABLE `phpwcms_filekey` (
 570    `fkey_id` int(11) NOT NULL auto_increment,
 571    `fkey_cid` int(11) NOT NULL default '0',
 572    `fkey_name` varchar(255) NOT NULL default '',
 573    `fkey_aktiv` int(1) NOT NULL default '0',
 574    `fkey_deleted` int(1) NOT NULL default '0',
 575    `fkey_sort` int(11) NOT NULL default '0',
 576    PRIMARY KEY  (`fkey_id`)
 577  ) ENGINE=MyISAM;
 578  
 579  -- --------------------------------------------------------
 580  
 581  --
 582  -- Tabellenstruktur für Tabelle `phpwcms_fonts`
 583  --
 584  
 585  CREATE TABLE `phpwcms_fonts` (
 586    `font_id` int(11) NOT NULL auto_increment,
 587    `font_name` text NOT NULL,
 588    `font_shortname` text NOT NULL,
 589    `font_filename` text NOT NULL,
 590    PRIMARY KEY  (`font_id`)
 591  ) ENGINE=MyISAM   PACK_KEYS=0;
 592  
 593  -- --------------------------------------------------------
 594  
 595  --
 596  -- Tabellenstruktur für Tabelle `phpwcms_fonts_colors`
 597  --
 598  
 599  CREATE TABLE `phpwcms_fonts_colors` (
 600    `color_id` int(11) NOT NULL auto_increment,
 601    `color_name` text NOT NULL,
 602    `color_value` varchar(255) NOT NULL default '',
 603    PRIMARY KEY  (`color_id`)
 604  ) ENGINE=MyISAM;
 605  
 606  -- --------------------------------------------------------
 607  
 608  --
 609  -- Tabellenstruktur für Tabelle `phpwcms_fonts_styles`
 610  --
 611  
 612  CREATE TABLE `phpwcms_fonts_styles` (
 613    `style_id` int(11) NOT NULL auto_increment,
 614    `style_name` text NOT NULL,
 615    `style_info` text NOT NULL,
 616    PRIMARY KEY  (`style_id`)
 617  ) ENGINE=MyISAM;
 618  
 619  -- --------------------------------------------------------
 620  
 621  --
 622  -- Tabellenstruktur für Tabelle `phpwcms_formresult`
 623  --
 624  
 625  CREATE TABLE `phpwcms_formresult` (
 626    `formresult_id` int(11) NOT NULL auto_increment,
 627    `formresult_pid` int(11) NOT NULL default '0',
 628    `formresult_createdate` timestamp NULL default CURRENT_TIMESTAMP,
 629    `formresult_ip` varchar(50) NOT NULL default '',
 630    `formresult_content` mediumblob NOT NULL,
 631    PRIMARY KEY  (`formresult_id`),
 632    KEY `formresult_pid` (`formresult_pid`)
 633  ) ENGINE=MyISAM;
 634  
 635  -- --------------------------------------------------------
 636  
 637  --
 638  -- Tabellenstruktur für Tabelle `phpwcms_formtracking`
 639  --
 640  
 641  CREATE TABLE `phpwcms_formtracking` (
 642    `formtracking_id` int(11) NOT NULL auto_increment,
 643    `formtracking_hash` varchar(50) NOT NULL default '',
 644    `formtracking_ip` varchar(20) NOT NULL default '',
 645    `formtracking_created` timestamp NOT NULL default CURRENT_TIMESTAMP,
 646    `formtracking_sentdate` varchar(20) NOT NULL default '',
 647    `formtracking_sent` int(1) NOT NULL default '0',
 648    PRIMARY KEY  (`formtracking_id`)
 649  ) ENGINE=MyISAM;
 650  
 651  -- --------------------------------------------------------
 652  
 653  --
 654  -- Tabellenstruktur für Tabelle `phpwcms_glossary`
 655  --
 656  
 657  CREATE TABLE `phpwcms_glossary` (
 658    `glossary_id` int(11) NOT NULL auto_increment,
 659    `glossary_created` datetime NOT NULL default '0000-00-00 00:00:00',
 660    `glossary_changed` datetime NOT NULL default '0000-00-00 00:00:00',
 661    `glossary_title` text NOT NULL,
 662    `glossary_tag` varchar(255) NOT NULL default '',
 663    `glossary_keyword` varchar(255) NOT NULL default '',
 664    `glossary_text` mediumtext NOT NULL,
 665    `glossary_highlight` int(1) NOT NULL default '0',
 666    `glossary_object` mediumtext NOT NULL,
 667    `glossary_status` int(1) NOT NULL default '0',
 668    PRIMARY KEY  (`glossary_id`),
 669    KEY `glossary_status` (`glossary_status`),
 670    KEY `glossary_tag` (`glossary_tag`),
 671    KEY `glossary_keyword` (`glossary_keyword`),
 672    KEY `glossary_highlight` (`glossary_highlight`)
 673  ) ENGINE=MyISAM;
 674  
 675  -- --------------------------------------------------------
 676  
 677  --
 678  -- Tabellenstruktur für Tabelle `phpwcms_guestbook`
 679  --
 680  
 681  CREATE TABLE `phpwcms_guestbook` (
 682    `guestbook_id` int(11) NOT NULL auto_increment,
 683    `guestbook_cid` int(11) NOT NULL default '0',
 684    `guestbook_msg` text NOT NULL,
 685    `guestbook_name` text NOT NULL,
 686    `guestbook_email` text NOT NULL,
 687    `guestbook_created` int(11) NOT NULL default '0',
 688    `guestbook_trashed` int(1) NOT NULL default '0',
 689    `guestbook_url` text NOT NULL,
 690    `guestbook_show` int(1) NOT NULL default '0',
 691    `guestbook_ip` varchar(20) NOT NULL default '',
 692    `guestbook_useragent` varchar(255) NOT NULL default '',
 693    `guestbook_image` varchar(255) NOT NULL default '',
 694    `guestbook_imagename` varchar(255) NOT NULL default '',
 695    PRIMARY KEY  (`guestbook_id`)
 696  ) ENGINE=MyISAM;
 697  
 698  -- --------------------------------------------------------
 699  
 700  --
 701  -- Tabellenstruktur für Tabelle `phpwcms_imgcache`
 702  --
 703  
 704  CREATE TABLE `phpwcms_imgcache` (
 705    `imgcache_id` int(11) NOT NULL auto_increment,
 706    `imgcache_hash` varchar(50) NOT NULL default '',
 707    `imgcache_imgname` varchar(255) NOT NULL default '',
 708    `imgcache_width` int(11) NOT NULL default '0',
 709    `imgcache_height` int(11) NOT NULL default '0',
 710    `imgcache_wh` varchar(255) NOT NULL default '',
 711    `imgcache_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 712    `imgcache_trash` int(1) NOT NULL default '0',
 713    PRIMARY KEY  (`imgcache_id`),
 714    KEY `imgcache_hash` (`imgcache_hash`)
 715  ) ENGINE=MyISAM;
 716  
 717  -- --------------------------------------------------------
 718  
 719  --
 720  -- Tabellenstruktur für Tabelle `phpwcms_keyword`
 721  --
 722  
 723  CREATE TABLE `phpwcms_keyword` (
 724    `keyword_id` int(11) NOT NULL auto_increment,
 725    `keyword_name` varchar(255) NOT NULL default '',
 726    `keyword_created` varchar(14) NOT NULL default '',
 727    `keyword_trash` int(1) NOT NULL default '0',
 728    `keyword_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 729    `keyword_description` text NOT NULL,
 730    `keyword_link` varchar(255) NOT NULL default '',
 731    `keyword_sort` int(11) NOT NULL default '0',
 732    `keyword_important` int(1) NOT NULL default '0',
 733    `keyword_abbr` varchar(10) NOT NULL default '',
 734    PRIMARY KEY  (`keyword_id`),
 735    KEY `keyword_abbr` (`keyword_abbr`)
 736  ) ENGINE=MyISAM;
 737  
 738  -- --------------------------------------------------------
 739  
 740  --
 741  -- Tabellenstruktur für Tabelle `phpwcms_language`
 742  --
 743  
 744  CREATE TABLE `phpwcms_language` (
 745    `lang_id` varchar(255) NOT NULL default '',
 746    `lang_html` int(1) NOT NULL default '1',
 747    `lang_type` int(1) NOT NULL default '0',
 748    `EN` text NOT NULL,
 749    `DE` text NOT NULL,
 750    `BG` text NOT NULL,
 751    `CA` text NOT NULL,
 752    `CZ` text NOT NULL,
 753    `DA` text NOT NULL,
 754    `EE` text NOT NULL,
 755    `ES` text NOT NULL,
 756    `FI` text NOT NULL,
 757    `FR` text NOT NULL,
 758    `GR` text NOT NULL,
 759    `HU` text NOT NULL,
 760    `IT` text NOT NULL,
 761    `LT` text NOT NULL,
 762    `NL` text NOT NULL,
 763    `NO` text NOT NULL,
 764    `PL` text NOT NULL,
 765    `PT` text NOT NULL,
 766    `RO` text NOT NULL,
 767    `SE` text NOT NULL,
 768    `SK` text NOT NULL,
 769    `VN` text NOT NULL,
 770    PRIMARY KEY  (`lang_id`)
 771  ) ENGINE=MyISAM ;
 772  
 773  -- --------------------------------------------------------
 774  
 775  --
 776  -- Tabellenstruktur für Tabelle `phpwcms_map`
 777  --
 778  
 779  CREATE TABLE `phpwcms_map` (
 780    `map_id` int(11) NOT NULL auto_increment,
 781    `map_cid` int(11) NOT NULL default '0',
 782    `map_x` int(5) NOT NULL default '0',
 783    `map_y` int(5) NOT NULL default '0',
 784    `map_title` text NOT NULL,
 785    `map_zip` varchar(255) NOT NULL default '',
 786    `map_city` text NOT NULL,
 787    `map_deleted` int(1) NOT NULL default '0',
 788    `map_entry` text NOT NULL,
 789    `map_vars` text NOT NULL,
 790    PRIMARY KEY  (`map_id`)
 791  ) ENGINE=MyISAM;
 792  
 793  -- --------------------------------------------------------
 794  
 795  --
 796  -- Tabellenstruktur für Tabelle `phpwcms_message`
 797  --
 798  
 799  CREATE TABLE `phpwcms_message` (
 800    `msg_id` int(11) NOT NULL auto_increment,
 801    `msg_pid` int(11) NOT NULL default '0',
 802    `msg_uid` int(11) NOT NULL default '0',
 803    `msg_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 804    `msg_subject` varchar(150) NOT NULL default '',
 805    `msg_text` blob NOT NULL,
 806    `msg_deleted` tinyint(1) NOT NULL default '0',
 807    `msg_read` tinyint(1) NOT NULL default '0',
 808    `msg_to` blob NOT NULL,
 809    `msg_from` int(11) NOT NULL default '0',
 810    `msg_from_del` int(1) NOT NULL default '0',
 811    PRIMARY KEY  (`msg_id`)
 812  ) ENGINE=MyISAM;
 813  
 814  -- --------------------------------------------------------
 815  
 816  --
 817  -- Tabellenstruktur für Tabelle `phpwcms_newsletter`
 818  --
 819  
 820  CREATE TABLE `phpwcms_newsletter` (
 821    `newsletter_id` int(11) NOT NULL auto_increment,
 822    `newsletter_created` timestamp NOT NULL default '0000-00-00 00:00:00',
 823    `newsletter_lastsending` timestamp NOT NULL default '0000-00-00 00:00:00',
 824    `newsletter_subject` text NOT NULL,
 825    `newsletter_changed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 826    `newsletter_vars` mediumblob NOT NULL,
 827    `newsletter_trashed` int(1) NOT NULL default '0',
 828    `newsletter_active` int(1) NOT NULL default '0',
 829    PRIMARY KEY  (`newsletter_id`)
 830  ) ENGINE=MyISAM;
 831  
 832  -- --------------------------------------------------------
 833  
 834  --
 835  -- Tabellenstruktur für Tabelle `phpwcms_newsletterqueue`
 836  --
 837  
 838  CREATE TABLE `phpwcms_newsletterqueue` (
 839    `queue_id` int(11) NOT NULL auto_increment,
 840    `queue_created` timestamp NOT NULL default '0000-00-00 00:00:00',
 841    `queue_changed` timestamp NOT NULL default '0000-00-00 00:00:00',
 842    `queue_status` int(11) NOT NULL default '0',
 843    `queue_pid` int(11) NOT NULL default '0',
 844    `queue_rid` int(11) NOT NULL default '0',
 845    `queue_errormsg` varchar(255) NOT NULL default '',
 846    PRIMARY KEY  (`queue_id`),
 847    KEY `nlqueue` (`queue_pid`,`queue_status`)
 848  ) ENGINE=MyISAM;
 849  
 850  -- --------------------------------------------------------
 851  
 852  --
 853  -- Tabellenstruktur für Tabelle `phpwcms_pagelayout`
 854  --
 855  
 856  CREATE TABLE `phpwcms_pagelayout` (
 857    `pagelayout_id` int(11) NOT NULL auto_increment,
 858    `pagelayout_name` varchar(255) NOT NULL default '',
 859    `pagelayout_default` int(1) NOT NULL default '0',
 860    `pagelayout_var` mediumblob NOT NULL,
 861    `pagelayout_trash` int(1) NOT NULL default '0',
 862    PRIMARY KEY  (`pagelayout_id`)
 863  ) ENGINE=MyISAM;
 864  
 865  -- --------------------------------------------------------
 866  
 867  --
 868  -- Tabellenstruktur für Tabelle `phpwcms_profession`
 869  --
 870  
 871  CREATE TABLE `phpwcms_profession` (
 872    `prof_id` int(4) NOT NULL auto_increment,
 873    `prof_name` varchar(100) NOT NULL default '',
 874    PRIMARY KEY  (`prof_id`)
 875  ) ENGINE=MyISAM;
 876  
 877  -- --------------------------------------------------------
 878  
 879  --
 880  -- Tabellenstruktur für Tabelle `phpwcms_shop_orders`
 881  --
 882  
 883  CREATE TABLE `phpwcms_shop_orders` (
 884    `order_id` int(10) unsigned NOT NULL auto_increment,
 885    `order_number` varchar(20) NOT NULL default '',
 886    `order_date` datetime NOT NULL default '0000-00-00 00:00:00',
 887    `order_name` varchar(255) NOT NULL default '',
 888    `order_firstname` varchar(255) NOT NULL default '',
 889    `order_email` varchar(255) NOT NULL default '',
 890    `order_net` float NOT NULL default '0',
 891    `order_gross` float NOT NULL default '0',
 892    `order_payment` varchar(255) NOT NULL default '',
 893    `order_data` mediumtext NOT NULL,
 894    `order_status` varchar(100) NOT NULL default '',
 895    PRIMARY KEY  (`order_id`),
 896    KEY `order_number` (`order_number`,`order_status`)
 897  ) ENGINE=MyISAM;
 898  
 899  -- --------------------------------------------------------
 900  
 901  --
 902  -- Tabellenstruktur für Tabelle `phpwcms_shop_products`
 903  --
 904  
 905  CREATE TABLE `phpwcms_shop_products` (
 906    `shopprod_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 907    `shopprod_createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 908    `shopprod_changedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 909    `shopprod_status` int(1) unsigned NOT NULL DEFAULT '0',
 910    `shopprod_uid` int(10) unsigned NOT NULL DEFAULT '0',
 911    `shopprod_ordernumber` varchar(255) NOT NULL DEFAULT '',
 912    `shopprod_model` varchar(255) NOT NULL DEFAULT '',
 913    `shopprod_name1` varchar(255) NOT NULL DEFAULT '',
 914    `shopprod_name2` varchar(255) NOT NULL DEFAULT '',
 915    `shopprod_tag` varchar(255) NOT NULL DEFAULT '',
 916    `shopprod_vat` float unsigned NOT NULL DEFAULT '0',
 917    `shopprod_netgross` int(1) unsigned NOT NULL DEFAULT '0',
 918    `shopprod_price` float NOT NULL DEFAULT '0',
 919    `shopprod_maxrebate` float NOT NULL DEFAULT '0',
 920    `shopprod_description0` text NOT NULL,
 921    `shopprod_description1` text NOT NULL,
 922    `shopprod_description2` text NOT NULL,
 923    `shopprod_description3` text NOT NULL,
 924    `shopprod_var` mediumtext NOT NULL,
 925    `shopprod_category` varchar(255) NOT NULL DEFAULT '',
 926    `shopprod_weight` float NOT NULL DEFAULT '0',
 927    `shopprod_color` varchar(255) NOT NULL DEFAULT '',
 928    `shopprod_size` varchar(255) NOT NULL DEFAULT '',
 929    `shopprod_listall` int(1) unsigned DEFAULT '0',
 930    `shopprod_special_price` text NOT NULL,
 931    `shopprod_track_view` int(11) NOT NULL DEFAULT '0',
 932    PRIMARY KEY (`shopprod_id`),
 933    KEY `shopprod_status` (`shopprod_status`),
 934    KEY `category` (`shopprod_category`),
 935    KEY `tag` (`shopprod_tag`),
 936    KEY `all` (`shopprod_listall`),
 937    KEY `shopprod_track_view` (`shopprod_track_view`)
 938  ) ENGINE=MyISAM;
 939  
 940  -- --------------------------------------------------------
 941  
 942  --
 943  -- Tabellenstruktur für Tabelle `phpwcms_subscription`
 944  --
 945  
 946  CREATE TABLE `phpwcms_subscription` (
 947    `subscription_id` int(11) NOT NULL auto_increment,
 948    `subscription_name` text NOT NULL,
 949    `subscription_info` blob NOT NULL,
 950    `subscription_active` int(1) NOT NULL default '0',
 951    `subscription_lang` varchar(100) NOT NULL default '',
 952    `subscription_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
 953    PRIMARY KEY  (`subscription_id`)
 954  ) ENGINE=MyISAM;
 955  
 956  -- --------------------------------------------------------
 957  
 958  --
 959  -- Tabellenstruktur für Tabelle `phpwcms_sysvalue`
 960  --
 961  
 962  CREATE TABLE `phpwcms_sysvalue` (
 963    `sysvalue_key` varchar(255) NOT NULL default '',
 964    `sysvalue_group` varchar(255) NOT NULL default '',
 965    `sysvalue_lastchange` int(11) NOT NULL default '0',
 966    `sysvalue_status` int(1) NOT NULL default '0',
 967    `sysvalue_vartype` varchar(100) NOT NULL default '',
 968    `sysvalue_value` text NOT NULL,
 969    PRIMARY KEY  (`sysvalue_key`),
 970    KEY `sysvalue_group` (`sysvalue_group`),
 971    KEY `sysvalue_status` (`sysvalue_status`)
 972  ) ENGINE=MyISAM ;
 973  
 974  -- --------------------------------------------------------
 975  
 976  --
 977  -- Tabellenstruktur für Tabelle `phpwcms_template`
 978  --
 979  
 980  CREATE TABLE `phpwcms_template` (
 981    `template_id` int(11) NOT NULL auto_increment,
 982    `template_type` int(11) NOT NULL default '1',
 983    `template_name` varchar(255) NOT NULL default '',
 984    `template_default` int(1) NOT NULL default '0',
 985    `template_var` mediumblob NOT NULL,
 986    `template_trash` int(1) NOT NULL default '0',
 987    PRIMARY KEY  (`template_id`)
 988  ) ENGINE=MyISAM;
 989  
 990  -- --------------------------------------------------------
 991  
 992  --
 993  -- Tabellenstruktur für Tabelle `phpwcms_user`
 994  --
 995  
 996  CREATE TABLE `phpwcms_user` (
 997    `usr_id` int(11) NOT NULL auto_increment,
 998    `usr_login` varchar(30) NOT NULL default '',
 999    `usr_pass` varchar(255) NOT NULL default '',
1000    `usr_email` varchar(150) NOT NULL default '',
1001    `usr_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1002    `usr_rechte` tinyint(4) NOT NULL default '0',
1003    `usr_admin` tinyint(1) NOT NULL default '0',
1004    `usr_avatar` varchar(50) NOT NULL default '',
1005    `usr_aktiv` int(1) NOT NULL default '0',
1006    `usr_name` varchar(100) NOT NULL default '',
1007    `usr_var_structure` blob NOT NULL,
1008    `usr_var_publicfile` blob NOT NULL,
1009    `usr_var_privatefile` blob NOT NULL,
1010    `usr_lang` varchar(50) NOT NULL default '',
1011    `usr_wysiwyg` int(2) NOT NULL default '0',
1012    `usr_fe` int(1) NOT NULL default '0',
1013    `usr_vars` mediumtext NOT NULL,
1014    PRIMARY KEY  (`usr_id`)
1015  ) ENGINE=MyISAM;
1016  
1017  -- --------------------------------------------------------
1018  
1019  --
1020  -- Tabellenstruktur für Tabelle `phpwcms_userdetail`
1021  --
1022  
1023  CREATE TABLE `phpwcms_userdetail` (
1024    `detail_id` int(11) NOT NULL auto_increment,
1025    `detail_regkey` varchar(255) NOT NULL default '',
1026    `detail_pid` int(11) NOT NULL default '0',
1027    `detail_formid` int(11) NOT NULL default '0',
1028    `detail_tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1029    `detail_title` varchar(255) NOT NULL default '',
1030    `detail_salutation` varchar(255) NOT NULL default '',
1031    `detail_firstname` varchar(255) NOT NULL default '',
1032    `detail_lastname` varchar(255) NOT NULL default '',
1033    `detail_company` varchar(255) NOT NULL default '',
1034    `detail_street` varchar(255) NOT NULL default '',
1035    `detail_add` varchar(255) NOT NULL default '',
1036    `detail_city` varchar(255) NOT NULL default '',
1037    `detail_zip` varchar(255) NOT NULL default '',
1038    `detail_region` varchar(255) NOT NULL default '',
1039    `detail_country` varchar(255) NOT NULL default '',
1040    `detail_fon` varchar(255) NOT NULL default '',
1041    `detail_fax` varchar(255) NOT NULL default '',
1042    `detail_mobile` varchar(255) NOT NULL default '',
1043    `detail_signature` varchar(255) NOT NULL default '',
1044    `detail_prof` varchar(255) NOT NULL default '',
1045    `detail_notes` blob NOT NULL,
1046    `detail_public` int(1) NOT NULL default '1',
1047    `detail_aktiv` int(1) NOT NULL default '1',
1048    `detail_newsletter` int(11) NOT NULL default '0',
1049    `detail_website` varchar(255) NOT NULL default '',
1050    `detail_userimage` varchar(255) NOT NULL default '',
1051    `detail_gender` varchar(255) NOT NULL default '',
1052    `detail_birthday` date NOT NULL default '0000-00-00',
1053    `detail_varchar1` varchar(255) NOT NULL default '',
1054    `detail_varchar2` varchar(255) NOT NULL default '',
1055    `detail_varchar3` varchar(255) NOT NULL default '',
1056    `detail_varchar4` varchar(255) NOT NULL default '',
1057    `detail_varchar5` varchar(255) NOT NULL default '',
1058    `detail_text1` text NOT NULL,
1059    `detail_text2` text NOT NULL,
1060    `detail_text3` text NOT NULL,
1061    `detail_text4` text NOT NULL,
1062    `detail_text5` text NOT NULL,
1063    `detail_email` varchar(255) NOT NULL default '',
1064    `detail_login` varchar(255) NOT NULL default '',
1065    `detail_password` varchar(255) NOT NULL default '',
1066    `userdetail_lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
1067    `detail_int1` bigint(20) NOT NULL default '0',
1068    `detail_int2` bigint(20) NOT NULL default '0',
1069    `detail_int3` bigint(20) NOT NULL default '0',
1070    `detail_int4` bigint(20) NOT NULL default '0',
1071    `detail_int5` bigint(20) NOT NULL default '0',
1072    `detail_float1` double NOT NULL default '0',
1073    `detail_float2` double NOT NULL default '0',
1074    `detail_float3` double NOT NULL default '0',
1075    `detail_float4` double NOT NULL default '0',
1076    `detail_float5` double NOT NULL default '0',
1077    PRIMARY KEY  (`detail_id`),
1078    KEY `detail_pid` (`detail_pid`),
1079    KEY `detail_formid` (`detail_formid`),
1080    KEY `detail_password` (`detail_password`),
1081    KEY `detail_aktiv` (`detail_aktiv`),
1082    KEY `detail_regkey` (`detail_regkey`)
1083  ) ENGINE=MyISAM;
1084  
1085  -- --------------------------------------------------------
1086  
1087  --
1088  -- Tabellenstruktur für Tabelle `phpwcms_usergroup`
1089  --
1090  
1091  CREATE TABLE `phpwcms_usergroup` (
1092    `group_id` int(11) NOT NULL auto_increment,
1093    `group_name` varchar(200) NOT NULL default '',
1094    `group_member` mediumtext NOT NULL,
1095    `group_value` longblob NOT NULL,
1096    `group_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1097    `group_trash` int(1) NOT NULL default '0',
1098    `group_active` int(1) NOT NULL default '0',
1099    PRIMARY KEY  (`group_id`),
1100    KEY `group_member` (`group_member`(255))
1101  ) ENGINE=MyISAM;
1102  
1103  -- --------------------------------------------------------
1104  
1105  --
1106  -- Tabellenstruktur für Tabelle `phpwcms_userlog`
1107  --
1108  
1109  CREATE TABLE `phpwcms_userlog` (
1110    `userlog_id` int(11) NOT NULL auto_increment,
1111    `logged_user` varchar(30) NOT NULL default '',
1112    `logged_username` varchar(100) NOT NULL default '',
1113    `logged_start` int(11) unsigned NOT NULL default '0',
1114    `logged_change` int(11) unsigned NOT NULL default '0',
1115    `logged_in` int(1) NOT NULL default '0',
1116    `logged_ip` varchar(24) NOT NULL default '',
1117    `logged_section` int(1) NOT NULL default '0',
1118    PRIMARY KEY  (`userlog_id`)
1119  ) ENGINE=MyISAM;
1120  
1121  CREATE TABLE `phpwcms_log_seo` (
1122    `id` int(11) NOT NULL auto_increment,
1123    `create_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
1124    `domain` varchar(255) NOT NULL,
1125    `query` varchar(255) NOT NULL,
1126    `pos` int(11) NOT NULL,
1127    `referrer` text NOT NULL,
1128    PRIMARY KEY  (`id`)
1129  ) ENGINE=MyISAM;
1130  
1131  CREATE TABLE IF NOT EXISTS `phpwcms_log` (
1132    `log_id` int(11) NOT NULL AUTO_INCREMENT,
1133    `log_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1134    `log_type` varchar(50) NOT NULL DEFAULT '',
1135    `log_ip` varchar(30) NOT NULL DEFAULT '',
1136    `log_user_agent` varchar(255) NOT NULL,
1137    `log_user_id` int(11) NOT NULL DEFAULT '0',
1138    `log_user_name` varchar(255) NOT NULL,
1139    `log_referrer_id` int(11) NOT NULL DEFAULT '0',
1140    `log_referrer_url` text NOT NULL,
1141    `log_data1` varchar(255) NOT NULL DEFAULT '',
1142    `log_data2` varchar(255) NOT NULL DEFAULT '',
1143    `log_data3` varchar(255) NOT NULL DEFAULT '',
1144    `log_msg` text NOT NULL,
1145    PRIMARY KEY (`log_id`),
1146    KEY `log_referrer_id` (`log_referrer_id`),
1147    KEY `log_type` (`log_type`)
1148  ) ENGINE=MyISAM;