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