[Summary view] [Print] [Text view]

   1  -- phpMyAdmin SQL Dump
   2  -- version 2.8.2.4
   3  -- http://www.phpmyadmin.net
   4  -- 
   5  -- Host: localhost:3306
   6  -- Erstellungszeit: 03. August 2007 um 07:57
   7  -- Server Version: 4.1.13
   8  -- PHP-Version: 5.0.5
   9  -- 
  10  -- Datenbank: `usr_web2_1`
  11  -- 
  12  
  13  -- --------------------------------------------------------
  14  
  15  -- 
  16  -- Tabellenstruktur für Tabelle `phpwcms_categories`
  17  -- 
  18  
  19  CREATE TABLE IF NOT EXISTS `phpwcms_categories` (
  20    `cat_id` int(10) unsigned NOT NULL auto_increment,
  21    `cat_type` varchar(255) NOT NULL default '',
  22    `cat_pid` int(11) NOT NULL default '0',
  23    `cat_status` int(1) NOT NULL default '0',
  24    `cat_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  25    `cat_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
  26    `cat_name` varchar(255) NOT NULL default '',
  27    `cat_info` text NOT NULL,
  28    PRIMARY KEY  (`cat_id`),
  29    KEY `cat_type` (`cat_type`,`cat_status`),
  30    KEY `cat_pid` (`cat_pid`)
  31  ) TYPE=MyISAM ;
  32  
  33  -- --------------------------------------------------------
  34  
  35  -- 
  36  -- Tabellenstruktur für Tabelle `phpwcms_shop_orders`
  37  -- 
  38  
  39  CREATE TABLE IF NOT EXISTS `phpwcms_shop_orders` (
  40    `order_id` int(10) unsigned NOT NULL auto_increment,
  41    `order_number` varchar(20) NOT NULL default '',
  42    `order_date` datetime NOT NULL default '0000-00-00 00:00:00',
  43    `order_name` varchar(255) NOT NULL default '',
  44    `order_firstname` varchar(255) NOT NULL default '',
  45    `order_email` varchar(255) NOT NULL default '',
  46    `order_net` float NOT NULL default '0',
  47    `order_gross` float NOT NULL default '0',
  48    `order_payment` varchar(255) NOT NULL default '',
  49    `order_data` mediumtext NOT NULL,
  50    `order_status` varchar(100) NOT NULL default '',
  51    PRIMARY KEY  (`order_id`),
  52    KEY `order_number` (`order_number`,`order_status`)
  53  ) TYPE=MyISAM ;
  54  
  55  -- --------------------------------------------------------
  56  
  57  -- 
  58  -- Tabellenstruktur für Tabelle `phpwcms_shop_products`
  59  -- 
  60  
  61  CREATE TABLE IF NOT EXISTS `phpwcms_shop_products` (
  62    `shopprod_id` int(10) unsigned NOT NULL auto_increment,
  63    `shopprod_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  64    `shopprod_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
  65    `shopprod_status` int(1) unsigned NOT NULL default '0',
  66    `shopprod_uid` int(10) unsigned NOT NULL default '0',
  67    `shopprod_ordernumber` varchar(255) NOT NULL default '',
  68    `shopprod_model` varchar(255) NOT NULL default '',
  69    `shopprod_name1` varchar(255) NOT NULL default '',
  70    `shopprod_name2` varchar(255) NOT NULL default '',
  71    `shopprod_tag` varchar(255) NOT NULL default '',
  72    `shopprod_vat` float unsigned NOT NULL default '0',
  73    `shopprod_netgross` int(1) unsigned NOT NULL default '0',
  74    `shopprod_price` float NOT NULL default '0',
  75    `shopprod_maxrebate` float NOT NULL default '0',
  76    `shopprod_description0` text NOT NULL,
  77    `shopprod_description1` text NOT NULL,
  78    `shopprod_description2` text NOT NULL,
  79    `shopprod_description3` text NOT NULL,
  80    `shopprod_var` mediumtext NOT NULL,
  81    `shopprod_category` varchar(255) NOT NULL default '',
  82    `shopprod_weight` float NOT NULL default '0',
  83    `shopprod_color` varchar(255) NOT NULL default '',
  84    `shopprod_size` varchar(255) NOT NULL default '',
  85    `shopprod_listall` int(1) unsigned default '0',
  86    PRIMARY KEY  (`shopprod_id`),
  87    KEY `shopprod_status` (`shopprod_status`),
  88    KEY `category` (`shopprod_category`),
  89    KEY `tag` (`shopprod_tag`),
  90    KEY `all` (`shopprod_listall`)
  91  ) TYPE=MyISAM ;
  92  
  93  -- --------------------------------------------------------
  94  
  95  -- 
  96  -- Tabellenstruktur für Tabelle `phpwcms_sysvalue`
  97  -- 
  98  
  99  CREATE TABLE IF NOT EXISTS `phpwcms_sysvalue` (
 100    `sysvalue_key` varchar(255) NOT NULL default '',
 101    `sysvalue_group` varchar(255) NOT NULL default '',
 102    `sysvalue_lastchange` int(11) NOT NULL default '0',
 103    `sysvalue_status` int(1) NOT NULL default '0',
 104    `sysvalue_vartype` varchar(100) NOT NULL default '',
 105    `sysvalue_value` text NOT NULL,
 106    PRIMARY KEY  (`sysvalue_key`),
 107    KEY `sysvalue_group` (`sysvalue_group`),
 108    KEY `sysvalue_status` (`sysvalue_status`)
 109  ) TYPE=MyISAM;