[Summary view] [Print] [Text view]

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