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