# Table structure for table `afterbuy`
#

DROP TABLE IF EXISTS `afterbuy`;
CREATE TABLE `afterbuy` (
  `id` varchar(10) NOT NULL default '1',
  `mailversand` varchar(200) NOT NULL default '1',
  `betreff` varchar(200) default NULL,
  `mailabsender` varchar(200) default NULL,
  `replymail` varchar(200) default NULL,
  `mailinhalt` blob,
  `UserID` varchar(200) default NULL,
  `AfterbuyPass` varchar(200) default NULL,
  `PartnerPass` varchar(200) default NULL,
  `PartnerID` varchar(200) default NULL,
  `Shop_URL` varchar(200) default NULL,
  `_url` varchar(200) default NULL,
  `_url_2` varchar(200) default NULL,
  `curl_url` varchar(200) default NULL,
  `c_url_vorhanden` varchar(10) NOT NULL default '2',
  `statusid` varchar(20) NOT NULL default '4',
  `link_preissuchmaschine` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_preisroboter` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_geizhals` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_kelkoo` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_preisauskunft` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `aktiv_preissuchmaschine` varchar(200) default 'checked',
  `aktiv_preisroboter` varchar(200) default 'checked',
  `preisroboter_status` varchar(200) NOT NULL default 'true',
  `preisroboter_lieferzeit_nicht_da` varchar(200) NOT NULL default '10',
  `preisroboter_normale_lieferzeit` varchar(200) NOT NULL default '4',
  `preisroboter_status_lieferzeit` varchar(200) NOT NULL default '4',
  `preisroboter_versandkostenfrei` varchar(200) NOT NULL default '999999999',
  `aktiv_geizhals` varchar(200) default 'checked',
  `aktiv_kelkoo` varchar(200) default 'checked',
  `aktiv_preisauskunft` varchar(200) default 'checked',
  `inhalt_htaccess_generieren` varchar(10) NOT NULL default 'ja',
  `normal_mail_aus` varchar(200) NOT NULL default 'nein'
);

#
# Datas for the table `afterbuy`
#

INSERT INTO `afterbuy` VALUES('1', '0', 'Vielen Dank f&uuml;r Ihre Bestellung', 'info@absender.de', 'info@reply.de', 0x477574656e20546167203c2d566f726e616d652d3e203c2d4e6163686e616d652d3e2c0d0a0d0a7669656c656e2044616e6b2066fc7220496872652042657374656c6c756e6720626569200d0a0d0a3c2d4649524d454e414e534348524946542d3e0d0a0d0a5769722077657264656e20496872652042657374656c6c756e67207363686e656c6c73746df6676c69636873742061757366fc6872656e2e0d0a0d0a3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d0d0a4e616368666f6c67656e642066696e64656e2053696520496872652042657374656c6c64657461696c733a0d0a3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d0d0a0d0a42657374656c6c6e756d6d65723a203c2d6f7264657269642d3e0d0a0d0a48696572206e6f63682065696e6d616c206469652062657374656c6c74656e20417274696b656c3a0d0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0d0a3c2d417274696b656c4c697374652d3e0d0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0d0a0d0a0d0a46fc722065696e652044657461696c69657274652042657374656c6cfc62657273696368743a200d0a68747470733a2f2f7777772e61667465726275792e64652f66622e6173703f616e3d3c2d6f7264657269642d3e312675693d3c2d5549442d3e0d0a0d0a466f6c67656e205369652062697474652064696573656d204c696e6b20756e64206b6f6e74726f6c6c696572656e20536965206e6f63682065696e6d616c204968726520446174656e210d0a0d0a486162656e2053696520646173204c6173747363687269667476657266616872656e20676577e4686c742069737420756e736572652042616e6b76657262696e64756e6720696e2064696573657220454d61696c2066fc72205369652073656c6273747665727374e46e646c69636820476567656e7374616e64736c6f732e0d0a476577e4686c7465205a61686c6172743a203c2d5a61686c6172742d3e0d0a0d0a46616c6c73206f62656e20616e6765676562656e6572204c696e6b206e696368742066756e6b74696f6e696572656e20736f6c6c7465206869657220756e736572652042616e6b76657262696e64756e67203a0d0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0d0a5a61686c62617220616e3a0d0a0d0a42616e6b3a203c2d42414e4b4e414d452d3e0d0a496e68616265723a203c2d4b4f4e544f494e48414245522d3e0d0a4b544f3a203c2d4b4f4e544f4e554d4d45522d3e0d0a424c5a3a20203c2d424c5a2d3e0d0a56657277656e64756e67737a7765636b3a203c2d4b756e64656e6e756d6d65722d3e0d0a0d0a4e757220dc62657277656973756e67656e206175732064656d204175736c616e643a0d0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0d0a4249432f53574946543a203c2d53574946542d3e0d0a4942414e3a3c2d4942414e2d3e0d0a0d0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0d0a0d0a496872652042657374656c6c756e672077697264206e616368205a61686c756e677365696e67616e6720756d676568656e642076657273656e6465742e0d0a0d0a0d0a0d0a4d697420667265756e646c696368656e204772fcdf656e0d0a0d0a0d0a3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d0d0a3c2d4649524d454e414e534348524946542d3e200d0a77fc6e73636874207669656c20537061df206d69742064656e206572776f7262656e656e2050726f64756b74656e210d0a3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d3d0d0a0d0a0d0a0d0a3c2d46494e414e5a414d542d3e0d0a3c2d5354455545524e554d4d45522d3e0d0a3c2d55535449442d3e, '', '', '', '', '', '', '', 'https://www.afterbuy.de/afterbuy/ShopInterface.asp', '1', '4', 'http://www.hecotech.de/portalpreise.php?action=preisroboter', 'http://www.hecotech.de/portalpreise.php?action=preissuchmaschine', 'http://www.hecotech.de/portalpreise.php?action=geizhals', 'http://www.hecotech.de/portalpreise.php?action=kelkoo', '', 'checked', 'checked', 'true', '10', '4', '4', '999999999', 'checked', 'checked', '', 'ja', 'nein');

# --------------------------------------------------------

#
# Table structure for table `attendees`
#

DROP TABLE IF EXISTS `attendees`;
CREATE TABLE `attendees` (
  `attendees_id` int(11) NOT NULL auto_increment,
  `attendees_gender` char(1) NOT NULL default '',
  `attendees_firstname` varchar(32) NOT NULL default '',
  `attendees_lastname` varchar(32) NOT NULL default '',
  `attendees_dob` datetime NOT NULL default '0000-00-00 00:00:00',
  `attendees_email_address` varchar(96) NOT NULL default '',
  `attendees_default_address_id` int(11) NOT NULL default '0',
  `attendees_telephone` varchar(32) NOT NULL default '',
  `attendees_fax` varchar(32) default NULL,
  `attendees_password` varchar(40) NOT NULL default '',
  `attendees_password_uncript` varchar(40) NOT NULL default '',
  `attendees_newsletter` char(1) default NULL,
  `attendees_invoice` tinyint(4) NOT NULL default '0',
  `guest_flag` char(1) default '0',
  `attendees_group_id` int(11) NOT NULL default '0',
  `member_level` int(5) NOT NULL default '0',
  PRIMARY KEY  (`attendees_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `attendees`
#

INSERT INTO `attendees` VALUES(1, '', 'Testvorname', 'Testnachname', '1990-01-01 00:00:00', 'mustermann@meinedomain.de', 23, '', '', '59f91202de2791765157485d32b69745:ee', 'musterwort', '', 0, '0', 0, 0);

# --------------------------------------------------------

#
# Table structure for table `attendees_basket`
#

DROP TABLE IF EXISTS `attendees_basket`;
CREATE TABLE `attendees_basket` (
  `attendees_basket_id` int(11) NOT NULL auto_increment,
  `attendees_id` int(11) NOT NULL default '0',
  `items_id` tinytext NOT NULL,
  `attendees_basket_quantity` int(2) NOT NULL default '0',
  `attendees_basket_laenge` int(11) NOT NULL default '1000',
  `attendees_basket_breite` int(11) NOT NULL default '1000',
  `attendees_basket_price_option` mediumint(10) NOT NULL default '0',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `items_basis_price` decimal(15,4) NOT NULL default '0.0000',
  `attendees_basket_date_added` varchar(8) default NULL,
  `price_option_comment` varchar(255) NOT NULL default '0',
  `add_cart_variable_serialize` text NOT NULL,
  PRIMARY KEY  (`attendees_basket_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `attendees_basket`
#

# --------------------------------------------------------

#
# Table structure for table `attendees_basket_characteristics`
#

DROP TABLE IF EXISTS `attendees_basket_characteristics`;
CREATE TABLE `attendees_basket_characteristics` (
  `attendees_basket_characteristics_id` int(11) NOT NULL auto_increment,
  `attendees_id` int(11) NOT NULL default '0',
  `items_id` tinytext NOT NULL,
  `items_options_id` int(11) NOT NULL default '0',
  `items_options_value_id` int(11) NOT NULL default '0',
  `items_characteristics_id` int(11) NOT NULL default '0',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  `items_options_name` varchar(32) NOT NULL default '',
  `items_options_values_name` varchar(64) NOT NULL default '',
  `qty` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`attendees_basket_characteristics_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `attendees_basket_characteristics`
#


# --------------------------------------------------------

#
# Table structure for table `attendees_basket_characteristics_conf`
#

DROP TABLE IF EXISTS `attendees_basket_characteristics_conf`;
CREATE TABLE `attendees_basket_characteristics_conf` (
  `attendees_basket_characteristics_conf_id` int(11) NOT NULL auto_increment,
  `attendees_id` int(11) NOT NULL default '0',
  `items_id` tinytext NOT NULL,
  `items_options_conf_id` int(11) NOT NULL default '0',
  `items_options_conf_value_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`attendees_basket_characteristics_conf_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `attendees_basket_characteristics_conf`
#


# --------------------------------------------------------

#
# Table structure for table `attendees_groups`
#

DROP TABLE IF EXISTS `attendees_groups`;
CREATE TABLE `attendees_groups` (
  `attendees_group_id` int(11) NOT NULL auto_increment,
  `attendees_group_name` varchar(32) NOT NULL default '',
  `attendees_group_discount` decimal(11,2) NOT NULL default '0.00',
  `color_bar` varchar(8) NOT NULL default '#FFFFFF',
  `group_payment_unallowed` varchar(255) NOT NULL default 'cc',
  `group_tax` varchar(5) NOT NULL default 'false',
  PRIMARY KEY  (`attendees_group_id`)
) AUTO_INCREMENT=3 ;

#
# Datas for the table `attendees_groups`
#

INSERT INTO `attendees_groups` VALUES(1, 'Gro&szlig;handel', 10.00, '#FFFFFF', 'cc', '0');
INSERT INTO `attendees_groups` VALUES(2, 'Stammkunden', 15.00, '#FFFFFF', '', 'true');

# --------------------------------------------------------

#
# Table structure for table `attendees_info`
#

DROP TABLE IF EXISTS `attendees_info`;
CREATE TABLE `attendees_info` (
  `attendees_info_id` int(11) NOT NULL default '0',
  `attendees_info_date_of_last_logon` datetime default NULL,
  `attendees_info_number_of_logons` int(5) default NULL,
  `attendees_info_date_member_created` datetime default NULL,
  `attendees_info_date_member_last_modified` datetime default NULL,
  `attendees_info_source_id` int(11) NOT NULL default '0',
  `global_item_informs` int(1) default '0',
  PRIMARY KEY  (`attendees_info_id`)
) ;

#
# Datas for the table `attendees_info`
#

INSERT INTO `attendees_info` VALUES(1, '2010-08-28 18:39:29', 1, '2010-08-28 14:18:18', NULL, 0, 0);

# --------------------------------------------------------

#
# Table structure for table `banktransfer`
#

DROP TABLE IF EXISTS `banktransfer`;
CREATE TABLE `banktransfer` (
  `orders_id` int(11) NOT NULL default '0',
  `banktransfer_owner` varchar(64) default NULL,
  `banktransfer_number` varchar(24) default NULL,
  `banktransfer_bankname` varchar(64) default NULL,
  `banktransfer_blz` varchar(8) default NULL,
  `banktransfer_status` int(11) default NULL,
  `banktransfer_prz` char(2) default NULL,
  `banktransfer_fax` char(2) default NULL,
  KEY `orders_id` (`orders_id`)
) ;

#
# Datas for the table `banktransfer`
#


# --------------------------------------------------------

#
# Table structure for table `banktransfer_blz`
#

DROP TABLE IF EXISTS `banktransfer_blz`;
CREATE TABLE `banktransfer_blz` (
  `blz` int(10) NOT NULL default '0',
  `bankname` varchar(255) NOT NULL default '',
  `prz` char(2) NOT NULL default '',
  PRIMARY KEY  (`blz`)
) ;

#
# Datas for the table `banktransfer_blz`
#

#
# Table structure for table `banktransfer`
#

DROP TABLE IF EXISTS `banktransfer_sepa`;
CREATE TABLE `banktransfer_sepa` (
  `orders_id` int(11) NOT NULL default '0',
  `banktransfer_sepa_owner` varchar(64) default NULL,
  `banktransfer_sepa_bankname` varchar(64) default NULL,
  `banktransfer_sepa_iban` varchar(34) default NULL,
  `banktransfer_sepa_bic` varchar(11) default NULL,
  `banktransfer_sepa_status` int(11) default NULL,
  `banktransfer_sepa_fax` char(2) default NULL,
  KEY `orders_id` (`orders_id`)
) ;

#
# Datas for the table `banktransfer_sepa`
#


# --------------------------------------------------------

#
# Table structure for table `cache`
#

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `cache_id` varchar(32) NOT NULL default '',
  `cache_language_id` tinyint(1) NOT NULL default '0',
  `cache_name` varchar(255) NOT NULL default '',
  `cache_data` mediumtext NOT NULL,
  `cache_global` tinyint(1) NOT NULL default '1',
  `cache_gzip` tinyint(1) NOT NULL default '1',
  `cache_method` varchar(20) NOT NULL default 'RETURN',
  `cache_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `cache_expires` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`cache_id`,`cache_language_id`),
  KEY `cache_id` (`cache_id`),
  KEY `cache_language_id` (`cache_language_id`),
  KEY `cache_global` (`cache_global`)
) ;

#
# Datas for the table `cache`
#


# --------------------------------------------------------

#
# Table structure for table `captcha_settings`
#

DROP TABLE IF EXISTS `captcha_settings`;
CREATE TABLE IF NOT EXISTS `captcha_settings` (
  `id` int(2) NOT NULL auto_increment,
  `captcha_enable_8` varchar(20) NOT NULL,
  `captcha_enable_10` varchar(20) NOT NULL,
  `captcha_enable_11` varchar(20) NOT NULL,
  `captcha_enable_37` varchar(20) NOT NULL,
  `captcha_enable_49` varchar(20) NOT NULL,
  `captcha_enable_53` varchar(20) NOT NULL,
  `captcha_key` varchar(20) NOT NULL,
  `possible` varchar(100) NOT NULL,
  `cap_width` varchar(20) NOT NULL,
  `cap_height` varchar(20) NOT NULL,
  `characters` varchar(100) NOT NULL,
  `background_color` varchar(20) NOT NULL,
  `text_color` varchar(20) NOT NULL,
  `noise_color` varchar(20) NOT NULL,
  `captcha_font` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `captcha_settings`
#

INSERT INTO `captcha_settings` (`id`, `captcha_enable_8`, `captcha_enable_10`, `captcha_enable_11`, `captcha_enable_37`, `captcha_enable_49`, `captcha_enable_53`, `captcha_key`, `possible`, `cap_width`, `cap_height`, `characters`, `background_color`, `text_color`, `noise_color`, `captcha_font`) VALUES
(1, 'ja', 'ja', 'ja', 'ja', 'ja', 'ja', 'individueller Text', '23456789abcdefghjkmnpqrstuwxyzABCDEFGHJKLMNPQRSTUWXYZ', '145', '50', '5', '#FFCC66', '#FFFFCC', '#339999', 'FreeSerifItalic.ttf');

# --------------------------------------------------------

#
# Table structure for table `categories`
#

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_picture` varchar(255) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `delivery_time_id` INT(6) NULL,
  `distri_katname` varchar(50) default NULL,
  `distri_aufschlag` varchar(10) default NULL,
  `distri_firstkat` varchar(10) default NULL,
  `syn` varchar(50) default NULL,
  `categories_status` tinyint(1) unsigned NOT NULL default '1',
  `spezial` varchar(200) NOT NULL default '',
  `folge` int(11) NOT NULL default '0',
  `default_gewicht` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) AUTO_INCREMENT=22 ;

#
# Datas for the table `categories`
#

INSERT INTO `categories` VALUES(20, '', 0, 0, '2006-08-27 20:23:05', '2009-03-02 00:54:18',NULL, NULL, NULL, NULL, NULL, 1, '', 0, '');
INSERT INTO `categories` VALUES(21, '', 0, 0, '2006-09-20 22:58:20', '2009-03-02 00:55:03',NULL, NULL, NULL, NULL, NULL, 1, '', 0, '');

# --------------------------------------------------------

#
# Table structure for table `categories_description`
#

DROP TABLE IF EXISTS `categories_description`;
CREATE TABLE `categories_description` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(255) NOT NULL default '',
  `categories_desc` text NOT NULL,
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
) ;

#
# Datas for the table `categories_description`
#

INSERT INTO `categories_description` VALUES(20, 3, '', '<br>');
INSERT INTO `categories_description` VALUES(20, 5, 'TestKategorie', '<br>');
INSERT INTO `categories_description` VALUES(21, 5, 'TestKategorie2', '<br>');
INSERT INTO `categories_description` VALUES(21, 3, '', '<br>');

# --------------------------------------------------------

#
# Table structure for table `change_invoice`
#

DROP TABLE IF EXISTS `change_invoice`;
CREATE TABLE `change_invoice` (
  `change_invoice_id` tinyint(3) unsigned NOT NULL default '0',
  `language_id` tinyint(3) unsigned NOT NULL default '1',
  `change_invoice_text` text,
  PRIMARY KEY  (`change_invoice_id`,`language_id`),
  KEY `status_id` (`change_invoice_id`)
) ;

#
# Datas for the table `change_invoice`
#

INSERT INTO `change_invoice` VALUES(1, 1, 'Hallo <--VORNAME_NACHNAME-->,<br>');
INSERT INTO `change_invoice` VALUES(2, 1, 'Mit frdl. Gr&uuml;&szlig;en<br><br>\r\nIhr Shopteam');

# --------------------------------------------------------

#
# Table structure for table `counter`
#

DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
  `startdate` char(8) default NULL,
  `counter` int(12) default NULL
) ;

#
# Datas for the table `counter`
#

INSERT INTO `counter` VALUES('20130212', 1);

# --------------------------------------------------------

#
# Table structure for table `counter_history`
#

DROP TABLE IF EXISTS `counter_history`;
CREATE TABLE `counter_history` (
  `month` char(8) default NULL,
  `counter` int(12) default NULL
) ;

#
# Datas for the table `counter_history`
#


# --------------------------------------------------------

#
# Table structure for table `coupons`
#

DROP TABLE IF EXISTS `coupons`;
CREATE TABLE `coupons` (
  `coupon_id` int(11) NOT NULL auto_increment,
  `coupon_type` char(1) NOT NULL default 'F',
  `coupon_code` varchar(32) NOT NULL default '',
  `coupon_amount` decimal(8,4) NOT NULL default '0.0000',
  `coupon_minimum_order` decimal(8,4) NOT NULL default '0.0000',
  `coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `uses_per_coupon` int(5) NOT NULL default '1',
  `uses_per_user` int(5) NOT NULL default '0',
  `restrict_to_items` varchar(255) default NULL,
  `restrict_to_categories` varchar(255) default NULL,
  `restrict_to_attendees` text,
  `coupon_active` char(1) NOT NULL default 'Y',
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`coupon_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `coupons`
#


# --------------------------------------------------------

#
# Table structure for table `coupons_description`
#

DROP TABLE IF EXISTS `coupons_description`;
CREATE TABLE `coupons_description` (
  `coupon_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `coupon_name` varchar(32) NOT NULL default '',
  `coupon_description` text,
  KEY `coupon_id` (`coupon_id`)
) ;

#
# Datas for the table `coupons_description`
#


# --------------------------------------------------------

#
# Table structure for table `coupon_email_track`
#

DROP TABLE IF EXISTS `coupon_email_track`;
CREATE TABLE `coupon_email_track` (
  `unique_id` int(11) NOT NULL auto_increment,
  `coupon_id` int(11) NOT NULL default '0',
  `attendee_id_sent` int(11) NOT NULL default '0',
  `sent_firstname` varchar(32) default NULL,
  `sent_lastname` varchar(32) default NULL,
  `emailed_to` varchar(32) default NULL,
  `date_sent` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`unique_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `coupon_email_track`
#

# --------------------------------------------------------

#
# Table structure for table `coupon_gv_attendee`
#

DROP TABLE IF EXISTS `coupon_gv_attendee`;
CREATE TABLE `coupon_gv_attendee` (
  `attendee_id` int(5) NOT NULL default '0',
  `amount` decimal(8,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`attendee_id`),
  KEY `attendee_id` (`attendee_id`)
) ;

#
# Datas for the table `coupon_gv_attendee`
#


# --------------------------------------------------------

#
# Table structure for table `coupon_gv_queue`
#

DROP TABLE IF EXISTS `coupon_gv_queue`;
CREATE TABLE `coupon_gv_queue` (
  `unique_id` int(5) NOT NULL auto_increment,
  `attendee_id` int(5) NOT NULL default '0',
  `order_id` int(5) NOT NULL default '0',
  `amount` decimal(8,4) NOT NULL default '0.0000',
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `ipaddr` varchar(32) NOT NULL default '',
  `release_flag` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`unique_id`),
  KEY `uid` (`unique_id`,`attendee_id`,`order_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `coupon_gv_queue`
#


# --------------------------------------------------------

#
# Table structure for table `coupon_redeem_track`
#

DROP TABLE IF EXISTS `coupon_redeem_track`;
CREATE TABLE `coupon_redeem_track` (
  `unique_id` int(11) NOT NULL auto_increment,
  `coupon_id` int(11) NOT NULL default '0',
  `attendee_id` int(11) NOT NULL default '0',
  `redeem_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `redeem_ip` varchar(32) NOT NULL default '',
  `order_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`unique_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `coupon_redeem_track`
#


# --------------------------------------------------------

#
# Table structure for table `currencies`
#

DROP TABLE IF EXISTS `currencies`;
CREATE TABLE `currencies` (
  `currencies_id` int(11) NOT NULL auto_increment,
  `title` varchar(32) NOT NULL default '',
  `code` char(3) NOT NULL default '',
  `symbol_left` varchar(12) default NULL,
  `symbol_right` varchar(12) default NULL,
  `decimal_point` char(1) default NULL,
  `thousands_point` char(1) default NULL,
  `decimal_places` char(1) default NULL,
  `roundings` VARCHAR( 120 ) NOT NULL DEFAULT  'std',
  `value` float(13,8) default NULL,
  `last_updated` datetime default NULL,
  PRIMARY KEY  (`currencies_id`)
) AUTO_INCREMENT=4 ;

#
# Datas for the table `currencies`
#

INSERT INTO `currencies` VALUES(3, 'US Dollar', 'USD', '$', '', '.', ',', '2', 'std', 1.21360004, NULL);
INSERT INTO `currencies` VALUES(2, 'Euro', 'EUR', '', 'EUR', ',', '.', '2', 'std', 1.00000000, '2004-07-10 03:26:53');

# --------------------------------------------------------

#
# Table structure for table `directory_to_address`
#

DROP TABLE IF EXISTS `directory_to_address`;
CREATE TABLE `directory_to_address` (
  `directory_to_address_id` int(11) NOT NULL auto_increment,
  `attendees_id` int(11) NOT NULL default '0',
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(32) default NULL,
  `entry_cf` varchar(16) NOT NULL default '',
  `entry_piva` varchar(11) NOT NULL default '',
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_street_address2` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_land_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`directory_to_address_id`),
  KEY `idx_directory_to_address_attendees_id` (`attendees_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `directory_to_address`
#

INSERT INTO `directory_to_address` VALUES(1, 1, '', NULL, '', '', 'Testvorname', 'Testnachname', 'Musterweg 1', '', NULL, '12345', 'Musterstadt', '', 81, 0);

# --------------------------------------------------------

#
# Table structure for table `discount`
#

DROP TABLE IF EXISTS `discount`;
CREATE TABLE `discount` (
  `discount_id` int(11) NOT NULL auto_increment,
  `limit` int(4) NOT NULL default '0',
  `discount_procent` decimal(4,2) NOT NULL default '0.00',
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`discount_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `discount`
#


# --------------------------------------------------------

#
# Table structure for table `email_template_text`
#

DROP TABLE IF EXISTS `email_template_text`;
CREATE TABLE `email_template_text` (
  `email_text_id` tinyint(3) unsigned NOT NULL default '0',
  `language_id` tinyint(3) unsigned NOT NULL default '1',
  `email_text_one` text,
  `site_name` varchar(200) NOT NULL default 'confirmation_request',
  `txt_html` int(2) NOT NULL default '2',
  PRIMARY KEY  (`email_text_id`,`language_id`),
  KEY `status_id` (`email_text_id`)
) ;

#
# Datas for the table `email_template_text`
#

INSERT INTO `email_template_text` VALUES(1, 3, '<-SHOP_NAME->\r\n\r\nVielen Dank f&uuml;r Ihre Bestellung! \r\n--------------------------------------------------------------------------------\r\n\r\nIhre Bestellnummer: <-insert_id->\r\n(Bitte bei Zahlungen und Anfragen stets angeben)\r\n\r\nIhre Detailierte Bestell&uuml;bersicht: \r\n<-INVOICE_URL->\r\n\r\nIhr Bestelldatum: <-DATE_ORDERED->\r\n\r\n\r\nIhre bestellten Artikel:\r\n\r\n<-Item_List-> \r\n<-List_Total-> \r\n\r\n\r\n \r\nIhre Rechnungsanschrift:\r\n\r\n\r\n<-BILL_Adress-> Ihre Lieferanschrift:\r\n\r\n\r\n<-DELIVERY_Adress-> \r\nZahlungsweise:\r\n\r\n\r\n<-Payment_Modul_Text-> \r\n<-Payment_Modul_Text_Footer->\r\n \r\n', 'confirmation_request', 1);
INSERT INTO `email_template_text` VALUES(2, 3, '<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial><STRONG><-SHOP_NAME-><BR><BR><FONT size=2>Vielen Dank f&uuml;r Ihre Bestellung!</FONT></STRONG></FONT>  <HR style="WIDTH: 281px; HEIGHT: 1px" align=left color=#000000>  <P><FONT face=Arial><FONT size=2>Ihre Bestellnummer:</FONT> <STRONG><FONT size=2><-insert_id-></FONT><BR></STRONG><EM><FONT size=1>(Bitte bei Zahlungen und Anfragen stets angeben)</FONT></EM></FONT></P> <P><FONT face=Arial><FONT size=2>Ihre Detailierte Bestell&uuml;bersicht: </FONT><BR><STRONG><FONT size=1><-INVOICE_URL-></FONT></STRONG></FONT></P> <P><FONT face=Arial size=2>Ihr Bestelldatum: <STRONG><-DATE_ORDERED-></STRONG></FONT></P> <P><STRONG><FONT face=Arial color=#ff0000><BR><FONT size=2>Ihre bestellten Artikel:</FONT></FONT></STRONG></P> <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM: 1px solid; BORDER-RIGHT-WIDTH: 1px" width="100%"><FONT face=Arial><-Item_List-></FONT></TD></TR> <TR> <TD width="100%"><B><FONT face=Arial><-List_Total-></FONT></B></TD></TR></TBODY></TABLE> <P>&nbsp;</P></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 border=0> <TBODY> <TR> <TD vAlign=top width="50%"><FONT face=Arial size=2><B><FONT color=#ff0000>Ihre Rechnungsanschrift:<BR></FONT></B></FONT><FONT face=Arial size=2><B><FONT color=#ff0000><BR><BR></FONT></B><-BILL_Adress-></FONT></TD> <TD vAlign=top width="50%"><FONT face=Arial color=#ff0000><B><FONT size=2>Ihre Lieferanschrift:<BR></FONT></B></FONT><FONT face=Arial color=#ff0000><B><FONT size=2><BR><BR></FONT></B></FONT><FONT face=Arial size=2><-DELIVERY_Adress-></FONT></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial size=2><B><FONT color=#ff0000>Zahlungsweise:<BR><BR></FONT></B><BR><-Payment_Modul_Text-></FONT>  <P><FONT face=Arial size=2><-Payment_Modul_Text_Footer-></FONT></P></TD></TR></TBODY></TABLE>', 'confirmation_request', 2);
INSERT INTO `email_template_text` VALUES(1, 5, '<-SHOP_NAME->\r\n\r\nVielen Dank f&uuml;r Ihre Bestellung! \r\n--------------------------------------------------------------------------------\r\n\r\nIhre Bestellnummer: <-insert_id->\r\n(Bitte bei Zahlungen und Anfragen stets angeben)\r\n\r\nIhre Detailierte Bestell&uuml;bersicht: \r\n<-INVOICE_URL->\r\n\r\nIhr Bestelldatum: <-DATE_ORDERED->\r\n\r\n\r\nIhre bestellten Artikel:\r\n\r\n<-Item_List-> \r\n<-List_Total-> \r\n\r\n\r\n \r\nIhre Rechnungsanschrift:\r\n\r\n\r\n<-BILL_Adress-> Ihre Lieferanschrift:\r\n\r\n\r\n<-DELIVERY_Adress-> \r\nZahlungsweise:\r\n\r\n\r\n<-Payment_Modul_Text-> \r\n<-Payment_Modul_Text_Footer->\r\n \r\n', 'confirmation_request', 1);
INSERT INTO `email_template_text` VALUES(2, 5, '<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial><STRONG><-SHOP_NAME-><BR><BR><FONT size=2>Vielen Dank f&uuml;r Ihre Bestellung!</FONT></STRONG></FONT>  <HR style="WIDTH: 281px; HEIGHT: 1px" align=left color=#000000>  <P><FONT face=Arial><FONT size=2>Ihre Bestellnummer:</FONT> <STRONG><FONT size=2><-insert_id-></FONT><BR></STRONG><EM><FONT size=1>(Bitte bei Zahlungen und Anfragen stets angeben)</FONT></EM></FONT></P> <P><FONT face=Arial><FONT size=2>Ihre Detailierte Bestell&uuml;bersicht: </FONT><BR><STRONG><FONT size=1><-INVOICE_URL-></FONT></STRONG></FONT></P> <P><FONT face=Arial size=2>Ihr Bestelldatum: <STRONG><-DATE_ORDERED-></STRONG></FONT></P> <P><STRONG><FONT face=Arial color=#ff0000><BR><FONT size=2>Ihre bestellten Artikel:</FONT></FONT></STRONG></P> <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM: 1px solid; BORDER-RIGHT-WIDTH: 1px" width="100%"><FONT face=Arial><-Item_List-></FONT></TD></TR> <TR> <TD width="100%"><B><FONT face=Arial><-List_Total-></FONT></B></TD></TR></TBODY></TABLE> <P>&nbsp;</P></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 border=0> <TBODY> <TR> <TD vAlign=top width="50%"><FONT face=Arial size=2><B><FONT color=#ff0000>Ihre Rechnungsanschrift:<BR></FONT></B></FONT><FONT face=Arial size=2><B><FONT color=#ff0000><BR><BR></FONT></B><-BILL_Adress-></FONT></TD> <TD vAlign=top width="50%"><FONT face=Arial color=#ff0000><B><FONT size=2>Ihre Lieferanschrift:<BR></FONT></B></FONT><FONT face=Arial color=#ff0000><B><FONT size=2><BR><BR></FONT></B></FONT><FONT face=Arial size=2><-DELIVERY_Adress-></FONT></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial size=2><B><FONT color=#ff0000>Zahlungsweise:<BR><BR></FONT></B><BR><-Payment_Modul_Text-></FONT>  <P><FONT face=Arial size=2><-Payment_Modul_Text_Footer-></FONT></P></TD></TR></TBODY></TABLE>', 'confirmation_request', 2);
INSERT INTO `email_template_text` VALUES(3, 3, '~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n<-SHOP_NAME->\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n\r\nHallo <-FIRST_NAME_CUSTOMER-> <-LAST_NAME_CUSTOMER->,\r\nSie haben ein neues Kundenaccount er&ouml;ffnet.\r\n__________________________________\r\n\r\n\r\nIhre Anmeldung war erfolgreich:\r\n\r\nSie k&ouml;nnen jetzt unser Shopsystem nutzen. Wir bietet Ihnen unter anderem:\r\n\r\nKundenwarenkorb\r\n----------------------\r\nJeder Artikel bleibt registriert bis Sie zur Kasse gehen, oder die Produkte aus dem Warenkorb entfernen.\r\n\r\nAdressbuch\r\n---------------\r\nWir k&ouml;nnen jetzt die Produkte zu der von Ihnen ausgesuchten Adresse senden. Der perfekte Weg um z.B. ein Geburtstagsgeschenk zu versenden.\r\n\r\nBestehende Bestellungen\r\n-------------------------------\r\nSie k&ouml;nnen jederzeit Ihre vorherigen Bestellungen &uuml;berpr&uuml;fen.\r\n\r\nBestellstatus einsehen\r\n----------------------------\r\nSie k&ouml;nnen in Ihrem Mitgliedsbereich den Status Ihrer Bestellung einsehen\r\n\r\nMeinungen &uuml;ber Produkte\r\n-------------------------------\r\nTeilen Sie Ihre Meinung zu unseren Produkten mit anderen Kunden.\r\n\r\n<-IF_START COUPON->\r\n\r\nCoupon:\r\n------------\r\nF&uuml;r Ihren ersten Einkauf verf&uuml;gen Sie &uuml;ber einen kleinen Einkaufsgutschein. Alle notwendigen Informationen diesbez&uuml;glich finden Sie hier:\r\n<-COUPON_INFO->\r\nGeben Sie einfach Ihren pers&ouml;nlichen Code <-COUPON_CODE-> w&auml;hrend des Bezahlvorganges ein\r\n\r\n<-IF_END COUPON->\r\n\r\n<-IF_START VOUCHER->\r\n\r\nGutschein:\r\n---------------\r\nAls kleines Willkommensgeschenk senden wir Ihnen einen Gutschein &uuml;ber <-VOUCHER_COUNT-> .\r\nIhr pers&ouml;nlicher Gutscheincode lautet <-VOUCHER_CODE->. Sie k&ouml;nnen diese Gutschrift entweder w&auml;hrend des Bestellvorgangs verbuchen oder direkt &uuml;ber diesen Link:\r\n<-VOUCHER_INFO_SITE->\r\n\r\n<-IF_END VOUCHER->\r\n\r\nBeachten Sie:\r\n------------------\r\nDiese eMail-Adresse wurde uns von einem Kunden bekannt gegeben.', 'new_user', 1);
INSERT INTO `email_template_text` VALUES(4, 3, '<table id="AutoNumber3" style="border-collapse: collapse;" width="100%" border="0" cellpadding="10" cellspacing="0"> <tbody> <tr> <td width="100%"><font face="Arial"><strong><-MY_LOGO-><br><br></strong></font><font face="Arial"><strong>Willkommen bei <-SHOP_NAME-></strong></font><br><br><font face="Arial"><strong><font size="2">Hallo </font></strong></font><font style="font-size: 12px; font-weight: bold;" face="Arial"><-FIRST_NAME_CUSTOMER-></font><font style="font-weight: bold;" face="Arial"><strong><font size="2"> </font></strong></font><font style="font-size: 12px; font-weight: bold;" face="Arial"><-LAST_NAME_CUSTOMER-></font><font face="Arial"><strong><font size="2">, <br><span style="font-weight: normal;">Sie haben einen neuen Kundenaccount&nbsp;</span></font></strong></font><font face="Arial"><strong> </strong></font><font face="Arial"><strong><font size="2"><span style="font-weight: normal;">er&ouml;ffnet.</span></font></strong></font>  <hr style="width: 281px; height: 1px;" align="left" color="#000000"><font face="Arial" size="2"><b><font color="#ff0000"><br>Ihre Anmeldung war erfolgreich:</font></b></font><br><br>Sie k&ouml;nnen jetzt unser <span style="font-weight: bold;">Shopsystem</span> nutzen. Wir bieten Ihnen unter anderem: <span style="font-weight: bold;"><br></span><ul><li><span style="font-weight: bold;">Kundenwarenkorb</span> - Jeder Artikel bleibt registriert bis Sie zur Kasse gehen oder die Produkte aus dem Warenkorb entfernen.</li><li><span style="font-weight: bold;">Adressbuch </span>- Wir k&ouml;nnen jetzt die Produkte zu der von Ihnen ausgesuchten Adresse senden. Der perfekte Weg um z.B. ein Geburtstagsgeschenk zu versenden.</li><li><span style="font-weight: bold;">Bestehende Bestellungen </span>- Sie k&ouml;nnen jederzeit Ihre vorherigen Bestellungen &uuml;berpr&uuml;fen.</li><li><span style="font-weight: bold;">Bestellstatus einsehen</span>: Sie k&ouml;nnen in Ihrem Mitgliedsbereich den Status Ihrer Bestellung einsehen</li><li><span style="font-weight: bold;">Meinungen &uuml;ber Produkte</span> - Teilen Sie Ihre Meinung zu unseren Produkten mit anderen Kunden.</li></ul><-IF_START COUPON-><br><br><span style="color: rgb(255, 0, 0); font-weight: bold;">Coupon:</span><br><br>F&uuml;r Ihren ersten Einkauf verf&uuml;gen Sie &uuml;ber einen kleinen Einkaufsgutschein. Alle notwendigen Informationen diesbez&uuml;glich finden Sie hier:<br><title>HTML clipboard</title><font style="font-size: 12px;" face="Arial"><-COUPON_INFO-></font><br>Geben Sie einfach Ihren pers&ouml;nlichen Code <-COUPON_CODE-> w&auml;hrend des Bezahlvorganges ein<br><br><-IF_END COUPON-><br><-IF_START VOUCHER-><br><br><span style="color: rgb(255, 0, 0); font-weight: bold;">Gutschein:</span><br><br>Als kleines Willkommensgeschenk senden wir Ihnen einen Gutschein &uuml;ber <-VOUCHER_COUNT-> .<br>Ihr pers&ouml;nlicher Gutscheincode lautet <-VOUCHER_CODE->. Sie k&ouml;nnen diese Gutschrift entweder w&auml;hrend des Bestellvorgangs verbuchen oder direkt &uuml;ber diesen Link:<br><-VOUCHER_INFO_SITE-><br><br><-IF_END VOUCHER-></td></tr></tbody></table><table id="AutoNumber4" style="border-collapse: collapse;" width="100%" border="0" cellpadding="10" cellspacing="0"><tbody><tr><td width="100%"><font face="Arial" size="2"><b><font color="#ff0000">Beachten Sie:</font></b><font style="color: rgb(0, 0, 0);" color="#ff0000"><br>Diese E-Mail-Adresse wurde uns von einem Kunden bekannt gegeben. <br><br><-WIDERUFSBELEHRUNG-><br></font></font><font style="font-size: 12px;" face="Arial"><-AGB-></font><br></td></tr></tbody></table>', 'new_user', 2);
INSERT INTO `email_template_text` VALUES(3, 5, '~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n<-SHOP_NAME->\r\n~~~~~~~~~~~~~~~~~~~~~~~~~~~\r\n\r\nHallo <-FIRST_NAME_CUSTOMER-> <-LAST_NAME_CUSTOMER->,\r\nSie haben einen neuen Kundenaccount er&ouml;ffnet.\r\n__________________________________\r\n\r\n\r\nIhre Anmeldung war erfolgreich:\r\n\r\nSie k&ouml;nnen jetzt unser Shopsystem nutzen. Wir bietet Ihnen unter anderem:\r\n\r\nKundenwarenkorb\r\n----------------------\r\nJeder Artikel bleibt registriert bis Sie zur Kasse gehen oder die Produkte aus dem Warenkorb entfernen.\r\n\r\nAdressbuch\r\n---------------\r\nWir k&ouml;nnen jetzt die Produkte zu der von Ihnen ausgesuchten Adresse senden. Der perfekte Weg um z.B. ein Geburtstagsgeschenk zu versenden.\r\n\r\nBestehende Bestellungen\r\n-------------------------------\r\nSie k&ouml;nnen jederzeit Ihre vorherigen Bestellungen &uuml;berpr&uuml;fen.\r\n\r\nBestellstatus einsehen\r\n----------------------------\r\nSie k&ouml;nnen in Ihrem Mitgliedsbereich den Status Ihrer Bestellung einsehen\r\n\r\nMeinungen &uuml;ber Produkte\r\n-------------------------------\r\nTeilen Sie Ihre Meinung zu unseren Produkten mit anderen Kunden.\r\n\r\n<-IF_START COUPON->\r\n\r\nCoupon:\r\n------------\r\nF&uuml;r Ihren ersten Einkauf verf&uuml;gen Sie &uuml;ber einen kleinen Einkaufsgutschein. Alle notwendigen Informationen diesbez&uuml;glich finden Sie hier:\r\n<-COUPON_INFO->\r\nGeben Sie einfach Ihren pers&ouml;nlichen Code <-COUPON_CODE-> w&auml;hrend des Bezahlvorganges ein\r\n\r\n<-IF_END COUPON->\r\n\r\n<-IF_START VOUCHER->\r\n\r\nGutschein:\r\n---------------\r\nAls kleines Willkommensgeschenk senden wir Ihnen einen Gutschein &uuml;ber <-VOUCHER_COUNT-> .\r\nIhr pers&ouml;nlicher Gutscheincode lautet <-VOUCHER_CODE->. Sie k&ouml;nnen diese Gutschrift entweder w&auml;hrend des Bestellvorgangs verbuchen oder direkt &uuml;ber diesen Link:\r\n<-VOUCHER_INFO_SITE->\r\n\r\n<-IF_END VOUCHER->\r\n\r\nBeachten Sie:\r\n------------------\r\nDiese eMail-Adresse wurde uns von einem Kunden bekannt gegeben.', 'new_user', 1);
INSERT INTO `email_template_text` VALUES(4, 5, '<table id="AutoNumber3" style="border-collapse: collapse;" width="100%" border="0" cellpadding="10" cellspacing="0"> <tbody> <tr> <td width="100%"><font face="Arial"><strong><-MY_LOGO-><br><br></strong></font><font face="Arial"><strong>Willkommen bei <-SHOP_NAME-></strong></font><br><br><font face="Arial"><strong><font size="2">Hallo </font></strong></font><font style="font-size: 12px; font-weight: bold;" face="Arial"><-FIRST_NAME_CUSTOMER-></font><font style="font-weight: bold;" face="Arial"><strong><font size="2"> </font></strong></font><font style="font-size: 12px; font-weight: bold;" face="Arial"><-LAST_NAME_CUSTOMER-></font><font face="Arial"><strong><font size="2">, <br><span style="font-weight: normal;">Sie haben einen neuen Kundenaccount&nbsp;</span></font></strong></font><font face="Arial"><strong> </strong></font><font face="Arial"><strong><font size="2"><span style="font-weight: normal;">er&ouml;ffnet.</span></font></strong></font>  <hr style="width: 281px; height: 1px;" align="left" color="#000000"><font face="Arial" size="2"><b><font color="#ff0000"><br>Ihre Anmeldung war erfolgreich:</font></b></font><br><br>Sie k&ouml;nnen jetzt unser <span style="font-weight: bold;">Shopsystem</span> nutzen. Wir bietet Ihnen unter anderem: <span style="font-weight: bold;"><br></span><ul><li><span style="font-weight: bold;">Kundenwarenkorb</span> - Jeder Artikel bleibt registriert bis Sie zur Kasse gehen, oder die Produkte aus dem Warenkorb entfernen.</li><li><span style="font-weight: bold;">Adressbuch </span>- Wir k&ouml;nnen jetzt die Produkte zu der von Ihnen ausgesuchten Adresse senden. Der perfekte Weg um z.B. ein Geburtstagsgeschenk zu versenden.</li><li><span style="font-weight: bold;">Bestehende Bestellungen </span>- Sie k&ouml;nnen jederzeit Ihre vorherigen Bestellungen &uuml;berpr&uuml;fen.</li><li><span style="font-weight: bold;">Bestellstatus einsehen</span>: Sie k&ouml;nnen in Ihrem Mitgliedsbereich den Status Ihrer Bestellung einsehen</li><li><span style="font-weight: bold;">Meinungen &uuml;ber Produkte</span> - Teilen Sie Ihre Meinung zu unseren Produkten mit anderen Kunden.</li></ul><-IF_START COUPON-><br><br><span style="color: rgb(255, 0, 0); font-weight: bold;">Coupon:</span><br><br>F&uuml;r Ihren ersten Einkauf verf&uuml;gen Sie &uuml;ber einen kleinen Einkaufsgutschein. Alle notwendigen Informationen diesbez&uuml;glich finden Sie hier:<br><title>HTML clipboard</title><font style="font-size: 12px;" face="Arial"><-COUPON_INFO-></font><br>Geben Sie einfach Ihren pers&ouml;nlichen Code <-COUPON_CODE-> w&auml;hrend des Bezahlvorganges ein<br><br><-IF_END COUPON-><br><-IF_START VOUCHER-><br><br><span style="color: rgb(255, 0, 0); font-weight: bold;">Gutschein:</span><br><br>Als kleines Willkommensgeschenk senden wir Ihnen einen Gutschein &uuml;ber <-VOUCHER_COUNT-> .<br>Ihr pers&ouml;nlicher Gutscheincode lautet <-VOUCHER_CODE->. Sie k&ouml;nnen diese Gutschrift entweder w&auml;hrend des Bestellvorgangs verbuchen oder direkt &uuml;ber diesen Link:<br><-VOUCHER_INFO_SITE-><br><br><-IF_END VOUCHER-></td></tr></tbody></table><table id="AutoNumber4" style="border-collapse: collapse;" width="100%" border="0" cellpadding="10" cellspacing="0"><tbody><tr><td width="100%"><font face="Arial" size="2"><b><font color="#ff0000">Beachten Sie:</font></b><font style="color: rgb(0, 0, 0);" color="#ff0000"><br>Diese E-Mail-Adresse wurde uns von einem Kunden bekannt gegeben. <br><br><-WIDERUFSBELEHRUNG-><br></font></font><font style="font-size: 12px;" face="Arial"><-AGB-></font><br></td></tr></tbody></table>', 'new_user', 2);

# --------------------------------------------------------

#
# Table structure for table `erw_einstellungen`
#

DROP TABLE IF EXISTS `erw_einstellungen`;
CREATE TABLE `erw_einstellungen` (
  `id` int(11) NOT NULL auto_increment,
  `default_land` varchar(11) NOT NULL default '',
  `default_newsletter` varchar(11) NOT NULL default '',
  `zusatzfeld_anmelde_name` varchar(100) NOT NULL default '',
  `keywords` longtext NOT NULL,
  `default_start` int(5) NOT NULL default '2',
  `linie` varchar(50) NOT NULL default 'dotted',
  `allg_metas` longtext NOT NULL,
  `logo_pfad` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=3 ;

#
# Datas for the table `erw_einstellungen`
#

INSERT INTO `erw_einstellungen` VALUES(1, '81', 'nein', 'Stadtteil', '', 3, 'groove', '', '');
INSERT INTO `erw_einstellungen` VALUES(2, '', '', '', '', 0, '', '', '/templates/template_01/logo/logo.png');

# --------------------------------------------------------

#
# Table structure for table `featured`
#

DROP TABLE IF EXISTS `featured`;
CREATE TABLE `featured` (
  `featured_id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `featured_date_added` datetime default NULL,
  `featured_last_modified` datetime default NULL,
  `expires_date` datetime default NULL,
  `date_status_change` datetime default NULL,
  `status` int(1) default '1',
  PRIMARY KEY  (`featured_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `featured`
#

INSERT INTO `featured` VALUES(1, 66, '2008-03-08 08:45:29', NULL, '0000-00-00 00:00:00', NULL, 1);

# --------------------------------------------------------

#
# Table structure for table `former`
#

DROP TABLE IF EXISTS `former`;
CREATE TABLE `former` (
  `former_id` int(11) NOT NULL auto_increment,
  `former_groups_id` int(11) default NULL,
  `former_firstname` varchar(32) NOT NULL default '',
  `former_lastname` varchar(32) default NULL,
  `former_email_address` varchar(96) NOT NULL default '',
  `former_password` varchar(40) NOT NULL default '',
  `former_created` datetime default NULL,
  `former_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `former_logdate` datetime default NULL,
  `former_lognum` int(11) NOT NULL default '0',
  PRIMARY KEY  (`former_id`),
  UNIQUE KEY `former_email_address` (`former_email_address`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `former`
#

INSERT INTO `former` VALUES(1, 1, 'AdminFirstname', 'AdminLastname', 'admin@localhost', '4e1fb3d588195c42c5169991e82a10b1:2a', '2004-09-08 01:42:16', '2005-01-08 04:57:17', '2010-09-06 08:37:21', 960);

# --------------------------------------------------------

#
# Table structure for table `former_access_files`
#

DROP TABLE IF EXISTS `former_access_files`;
CREATE TABLE `former_access_files` (
  `file_access_id` int(4) NOT NULL auto_increment,
  `former_files_id` int(11) NOT NULL default '0',
  `former_id` int(11) NOT NULL default '1',
  `former_access_values` int(11) NOT NULL default '1',
  PRIMARY KEY  (`file_access_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `former_access_files`
#


# --------------------------------------------------------

#
# Table structure for table `former_files`
#

DROP TABLE IF EXISTS `former_files`;
CREATE TABLE `former_files` (
  `former_files_id` int(11) NOT NULL auto_increment,
  `former_files_name` varchar(64) NOT NULL default '',
  `former_files_is_frames` tinyint(5) NOT NULL default '0',
  `former_files_to_frames` int(11) NOT NULL default '0',
  `former_groups_id` set('1','2') NOT NULL default '1',
  `former_id` set('1','2','3','4') NOT NULL default '1',
  PRIMARY KEY  (`former_files_id`)
) AUTO_INCREMENT=64 ;

#
# Datas for the table `former_files`
#

INSERT INTO `former_files` VALUES(1, 'formerman.php', 1, 0, '1', '1,3');
INSERT INTO `former_files` VALUES(62, 'cat.php', 0, 60, '1', '1');
INSERT INTO `former_files` VALUES(4, 'modules.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(5, 'main_bigware_2.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(6, 'taxes.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(7, 'localization.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(8, 'reports.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(9, 'tools.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(10, 'former_members.php', 0, 1, '1', '1,3');
INSERT INTO `former_files` VALUES(11, 'former_files.php', 0, 1, '1', '1,3');
INSERT INTO `former_files` VALUES(61, 'set_it_up.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(63, 'mods_bigware_14.php', 0, 60, '1', '1');
INSERT INTO `former_files` VALUES(60, 'catalog.php', 1, 0, '1', '1,3');
INSERT INTO `former_files` VALUES(19, 'modules.php', 0, 4, '1', '1');
INSERT INTO `former_files` VALUES(20, 'main_bigware_2.php', 0, 5, '1', '1');
INSERT INTO `former_files` VALUES(21, 'orders.php', 0, 5, '1', '1');
INSERT INTO `former_files` VALUES(22, 'lands.php', 0, 6, '1', '1');
INSERT INTO `former_files` VALUES(23, 'zones.php', 0, 6, '1', '1');
INSERT INTO `former_files` VALUES(24, 'geo_zones.php', 0, 6, '1', '1');
INSERT INTO `former_files` VALUES(25, 'tax_classes.php', 0, 6, '1', '1');
INSERT INTO `former_files` VALUES(26, 'tax_rates.php', 0, 6, '1', '1');
INSERT INTO `former_files` VALUES(27, 'currencies.php', 0, 7, '1', '1');
INSERT INTO `former_files` VALUES(28, 'languages.php', 0, 7, '1', '1');
INSERT INTO `former_files` VALUES(29, 'orders_status.php', 0, 7, '1', '1');
INSERT INTO `former_files` VALUES(30, 'stats_items_viewed.php', 0, 8, '1', '1');
INSERT INTO `former_files` VALUES(31, 'stats_items_purchased.php', 0, 8, '1', '1');
INSERT INTO `former_files` VALUES(32, 'main_bigware_108.php', 0, 8, '1', '1');
INSERT INTO `former_files` VALUES(33, 'main_bigware_4.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(34, 'main_bigware_5.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(35, 'cache.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(36, 'define_language.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(37, 'file_manager.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(38, 'mail.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(39, 'newsletters.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(40, 'server_info.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(41, 'whos_online.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(42, 'main_bigware_6.php', 0, 9, '1', '1');
INSERT INTO `former_files` VALUES(43, 'former_members_change.php', 0, 1, '1', '1,3');
INSERT INTO `former_files` VALUES(59, 'afterbuy.php', 1, 0, '1', '1,3');
INSERT INTO `former_files` VALUES(45, 'main_bigware_7.php', 1, 0, '1', '1,3');
INSERT INTO `former_files` VALUES(46, 'catalog_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(47, 'set_it_up_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(48, 'attendees_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(49, 'designwahl.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(50, 'einlesen.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(51, 'infotexte.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(52, 'localization_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(53, 'manual_order.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(54, 'modules_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(55, 'preisportale.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(56, 'reports_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(57, 'taxes_dhtml.php', 1, 0, '1', '1');
INSERT INTO `former_files` VALUES(58, 'tools_dhtml.php', 1, 0, '1', '1');

# --------------------------------------------------------

#
# Table structure for table `former_groups`
#

DROP TABLE IF EXISTS `former_groups`;
CREATE TABLE `former_groups` (
  `former_groups_id` int(11) NOT NULL auto_increment,
  `former_groups_name` varchar(64) default NULL,
  PRIMARY KEY  (`former_groups_id`),
  UNIQUE KEY `former_groups_name` (`former_groups_name`)
) AUTO_INCREMENT=5 ;

#
# Datas for the table `former_groups`
#

INSERT INTO `former_groups` VALUES(1, 'Top Administrator');
INSERT INTO `former_groups` VALUES(2, 'Marketing');
INSERT INTO `former_groups` VALUES(3, 'Guest');
INSERT INTO `former_groups` VALUES(4, 'VIP');

# --------------------------------------------------------

#
# Table structure for table `form_of_address`
#

DROP TABLE IF EXISTS `form_of_address`;
CREATE TABLE `form_of_address` (
  `form_of_address_id` int(11) NOT NULL auto_increment,
  `form_of_address` varchar(128) NOT NULL default '',
  `address_summary` varchar(48) NOT NULL default '',
  PRIMARY KEY  (`form_of_address_id`)
) AUTO_INCREMENT=6 ;

#
# Datas for the table `form_of_address`
#

INSERT INTO `form_of_address` VALUES(1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$land', '$city / $land');
INSERT INTO `form_of_address` VALUES(2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$land', '$city, $state / $land');
INSERT INTO `form_of_address` VALUES(3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$land', '$state / $land');
INSERT INTO `form_of_address` VALUES(4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$land', '$postcode / $land');
INSERT INTO `form_of_address` VALUES(5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$land$cr$cr$email', '$city / $land');

# --------------------------------------------------------

#
# Table structure for table `frame_config`
#

DROP TABLE IF EXISTS `frame_config`;
CREATE TABLE `frame_config` (
  `set_it_up_id` int(5) NOT NULL auto_increment,
  `belong_id` INT(5) NOT NULL,
  `set_it_up_show_value` varchar(255) NOT NULL default '',
  `set_it_up_name_titel` varchar(64) NOT NULL default '',
  `set_it_up_name_inhalt` text NOT NULL,
  `set_it_up_name_value` varchar(255) NOT NULL default '',
  `set_it_up_sort_value` int(10) NOT NULL default '0',
  `set_it_up_seite_value` varchar(255) NOT NULL default '',
  `php_code` text NOT NULL,
  `language` CHAR(4) NOT NULL DEFAULT '',
  PRIMARY KEY  (`set_it_up_id`)
) AUTO_INCREMENT=28 ;

#
# Datas for the table `frame_config`
#

INSERT INTO `frame_config` VALUES(1, 0, '1', 'FRAME_ABOVE_CATEGORIES', '', 'categories', 1, 'l', 'cat', '');
INSERT INTO `frame_config` VALUES(3, 0, '1', 'FRAME_ABOVE_PRODUCERS', '', 'producers', 3, 'l', 'producers', '');
INSERT INTO `frame_config` VALUES(4, 0, '1', 'FRAME_ABOVE_PAGES', '', 'info_pages', 4, 'l', 'info_pages', '');
INSERT INTO `frame_config` VALUES(5, 0, '1', 'FRAME_ABOVE_WHATS_NEW', '', 'whats_new', 5, 'l', 'whats_new', '');
INSERT INTO `frame_config` VALUES(6, 0, '1', 'FRAME_ABOVE_SEARCH', '', 'search', 3, 'r', 'search', '');
INSERT INTO `frame_config` VALUES(7, 0, '1', 'FRAME_ABOVE_INFORMATION', '', 'information', 7, 'l', 'information', '');
INSERT INTO `frame_config` VALUES(8, 0, '1', 'FRAME_ABOVE_LOGIN', '', 'login', 1, 'r', 'login', '');
INSERT INTO `frame_config` VALUES(10, 0, '1', 'FRAME_ABOVE_PRODUCER_INFO', '', 'producer_info', 3, 'r', 'producer_info', '');
INSERT INTO `frame_config` VALUES(11, 0, '1', 'FRAME_ABOVE_ATTENDEE_ORDERS', '', 'order_history', 4, 'r', 'order_history', '');
INSERT INTO `frame_config` VALUES(12, 0, '1', 'FRAME_ABOVE_BESTSELLERS', '', 'best_sellers', 5, 'r', 'best_sellers', '');
INSERT INTO `frame_config` VALUES(13, 0, '0', 'FRAME_ABOVE_INFORMS', '', 'item_informs', 6, 'r', 'item_informs', '');
INSERT INTO `frame_config` VALUES(14, 0, '0', 'FRAME_ABOVE_TELL_A_FRIEND', '', 'tell_a_friend', 7, 'r', 'tell_a_friend', '');
INSERT INTO `frame_config` VALUES(15, 0, '1', 'FRAME_ABOVE_SPECIALS', '', 'specials', 8, 'r', 'specials', '');
INSERT INTO `frame_config` VALUES(16, 0, '0', 'FRAME_ABOVE_REVIEWS', '', 'reviews', 9, 'r', 'reviews', '');
INSERT INTO `frame_config` VALUES(17, 0, '0', 'FRAME_ABOVE_LANGUAGES', '', 'languages', 10, 'r', 'languages', '');
INSERT INTO `frame_config` VALUES(18, 0, '1', 'FRAME_ABOVE_CURRENCIES', '', 'currencies', 11, 'r', 'currencies', '');
INSERT INTO `frame_config` VALUES(19, 0, '1', 'FRAME_ABOVE_WHOS_ONLINE', '', 'whos_online', 12, 'r', 'whos_online', '');
INSERT INTO `frame_config` VALUES(20, 0, '1', '_POLLS', '', 'polls', 13, 'r', 'polls', '');
INSERT INTO `frame_config` VALUES(22, 0, '0', 'FRAME_ABOVE_GALERIE', '', 'galerie', 1, 'l', 'galerie', '');
INSERT INTO `frame_config` VALUES(23, 0, '1', 'FRAME_ABOVE_DOWNLOADS', '', 'downloads', 1, 'l', 'downloads', '');
INSERT INTO `frame_config` VALUES(25, 0, '0', 'FRAME_ABOVE_SEARCHSELECT', '', 'searchselect', 4, 'r', 'searchselect', '');
INSERT INTO `frame_config` VALUES(26, 0, '0', 'FRAME_ABOVE_QUICK_SEARCH_MORE', '', 'searchproductcode', 7, 'l', 'searchproductcode', '');
INSERT INTO `frame_config` VALUES(27, 0, '0', 'FRAME_ABOVE_SHOP_BASKET', '', 'shop_basket', 7, 'r', 'shop_basket', '');

# --------------------------------------------------------

#
# Table structure for table `galerie`
#

DROP TABLE IF EXISTS `galerie`;
CREATE TABLE `galerie` (
  `galeries_id` int(24) NOT NULL auto_increment,
  `galeries_quantity` int(4) NOT NULL default '0',
  `Featured_galerie` int(4) NOT NULL default '0',
  `galeries_model` varchar(24) default NULL,
  `galeries_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `galeries_last_modified` datetime default NULL,
  `galeries_date_available` datetime default NULL,
  `galeries_weight` decimal(5,2) NOT NULL default '0.00',
  `galeries_status` tinyint(1) NOT NULL default '0',
  `galeries_tax_class_id` int(11) NOT NULL default '0',
  `producers_id` int(11) default NULL,
  `galeries_ordered` int(11) NOT NULL default '0',
  `galeries_percentage` tinyint(1) NOT NULL default '1',
  `syn` varchar(200) default NULL,
  `neu` int(11) NOT NULL default '2',
  `herstellernummer` varchar(100) NOT NULL default '',
  `galeries_sort` int(11) NOT NULL default '2147483647',
  PRIMARY KEY  (`galeries_id`),
  KEY `idx_items_date_added` (`galeries_date_added`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `galerie`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_cat`
#

DROP TABLE IF EXISTS `galerie_cat`;
CREATE TABLE `galerie_cat` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_picture` varchar(255) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `categories_status` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `galerie_cat`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_cat_desc`
#

DROP TABLE IF EXISTS `galerie_cat_desc`;
CREATE TABLE `galerie_cat_desc` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(255) NOT NULL default '',
  `categories_desc` text NOT NULL,
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
) ;

#
# Datas for the table `galerie_cat_desc`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_conf`
#

DROP TABLE IF EXISTS `galerie_conf`;
CREATE TABLE `galerie_conf` (
  `galerie_conf_id` int(11) NOT NULL auto_increment,
  `rahmenbreite` varchar(255) NOT NULL default '',
  `rahmenbreite1` varchar(255) NOT NULL default '',
  `rahmenfarbe` varchar(255) NOT NULL default '',
  `rahmenfarbe1` varchar(255) NOT NULL default '0',
  `bildbreite` varchar(255) NOT NULL default '0',
  `bildbreite1` varchar(255) NOT NULL default '0',
  `bildhoehe` varchar(255) NOT NULL default '',
  `bildhoehe1` varchar(255) NOT NULL default '',
  `pic_zeilen` varchar(255) NOT NULL default '',
  `pic_zeilen1` varchar(255) NOT NULL default '',
  `pic_auf_seite` varchar(255) NOT NULL default '',
  `pic_auf_seite1` varchar(255) NOT NULL default '',
  `cellspacing` varchar(255) NOT NULL default '0',
  `cellspacing1` varchar(255) NOT NULL default '0',
  `im_popup` int(10) NOT NULL default '0',
  `rahmenbreite2` varchar(255) NOT NULL default '',
  `rahmenfarbe2` varchar(255) NOT NULL default '',
  `bildbreitevorschau` varchar(255) NOT NULL default '',
  `bildhoehevorschau` varchar(255) NOT NULL default '',
  `cellspacing2` varchar(255) NOT NULL default '',
  `name_bild` varchar(255) NOT NULL default 'Bildvorschau',
  `name_name` varchar(255) NOT NULL default 'Galeriename',
  `name_anzahl` varchar(255) NOT NULL default 'Bilder',
  `bilderanzahl_anzeigen` int(1) NOT NULL default '1',
  `ausrichtung_bild` varchar(12) NOT NULL default 'left',
  `ausrichtung_name` varchar(12) NOT NULL default 'center',
  `ausrichtung_anzahl` varchar(12) NOT NULL default 'right',
  `ueberschriftfarbe` varchar(255) NOT NULL default '',
  `ueberschriftfont` varchar(255) NOT NULL default '',
  `ueberschriftgroesse` varchar(255) NOT NULL default '',
  `tbrahmenfarbe` varchar(255) NOT NULL default '',
  `tbhintergrundfarbe` varchar(255) NOT NULL default '',
  `bildbreite_cat_pic` varchar(4) NOT NULL default '30',
  `bildhoehe_cat_pic` varchar(4) NOT NULL default '',
  `wieviele_subcats_zeile` int(3) NOT NULL default '3',
  `farbe_linie_galerieliste` varchar(255) NOT NULL default '#000000',
  `abstand_zelle_untercat` int(5) NOT NULL default '5',
  `name_untercat_ausrichtung` int(2) NOT NULL default '2',
  `name_untercat_ausrichtung_in_zelle` varchar(7) NOT NULL default 'right',
  PRIMARY KEY  (`galerie_conf_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `galerie_conf`
#

INSERT INTO `galerie_conf` VALUES(1, '1', '1', '#00AFFF', '#00AFFF', '', '', '', '', '1', '2', '25', '6', '5', '5', 1, '1', '#00AFFF', '', '', '5', 'Bildvorschau', 'Galeriename', 'Bilder', 1, 'left', 'center', 'right', '#FFFFFF', 'Arial', '12', '#808080', '#ffffff', '30', '', 3, '#000000', 5, 2, 'right');

# --------------------------------------------------------

#
# Table structure for table `galerie_description`
#

DROP TABLE IF EXISTS `galerie_description`;
CREATE TABLE `galerie_description` (
  `galeries_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `galeries_name` varchar(255) NOT NULL default '',
  `galeries_name2` varchar(255) NOT NULL default '',
  `galeries_info1` varchar(255) NOT NULL default '',
  `galeries_info2` varchar(255) NOT NULL default '',
  `galeries_info3` varchar(255) NOT NULL default '',
  `galeries_info4` varchar(255) NOT NULL default '',
  `galeries_description` text,
  `galeries_viewed` int(5) default '0',
  PRIMARY KEY  (`galeries_id`,`language_id`),
  KEY `items_name` (`galeries_name`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `galerie_description`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_template`
#

DROP TABLE IF EXISTS `galerie_template`;
CREATE TABLE `galerie_template` (
  `template_id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `template_inhalt` blob,
  PRIMARY KEY  (`template_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `galerie_template`
#

INSERT INTO `galerie_template` VALUES(1, 'Standart',  );

# --------------------------------------------------------

#
# Table structure for table `galerie_to_categories`
#

DROP TABLE IF EXISTS `galerie_to_categories`;
CREATE TABLE `galerie_to_categories` (
  `galeries_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`galeries_id`,`categories_id`)
) ;

#
# Datas for the table `galerie_to_categories`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_to_picture`
#

DROP TABLE IF EXISTS `galerie_to_picture`;
CREATE TABLE `galerie_to_picture` (
  `galerie_to_picture_id` int(11) NOT NULL auto_increment,
  `galeries_id` int(11) NOT NULL default '0',
  `pictures` varchar(64) NOT NULL default '0',
  `sort_order` int(11) NOT NULL default '0',
  `vorschau` int(2) NOT NULL default '0',
  PRIMARY KEY  (`galerie_to_picture_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `galerie_to_picture`
#


# --------------------------------------------------------

#
# Table structure for table `galerie_to_template`
#

DROP TABLE IF EXISTS `galerie_to_template`;
CREATE TABLE `galerie_to_template` (
  `galeries_id` int(11) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`galeries_id`,`template_id`)
) ;

#
# Datas for the table `galerie_to_template`
#


# --------------------------------------------------------

#
# Table structure for table `geo_zones`
#

DROP TABLE IF EXISTS `geo_zones`;
CREATE TABLE `geo_zones` (
  `geo_zone_id` int(11) NOT NULL auto_increment,
  `geo_zone_name` varchar(32) NOT NULL default '',
  `geo_zone_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`geo_zone_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `geo_zones`
#

INSERT INTO `geo_zones` VALUES(1, 'Deutschland', 'Deutschland', '2004-08-01 15:57:04', '2004-07-10 03:28:26');

# --------------------------------------------------------

#
# Table structure for table `groups_to_categories`
#

DROP TABLE IF EXISTS `groups_to_categories`;
CREATE TABLE `groups_to_categories` (
  `attendees_group_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  `discount` decimal(11,2) NOT NULL default '0.00',
  PRIMARY KEY  (`attendees_group_id`,`categories_id`)
) ;

#
# Datas for the table `groups_to_categories`
#


# --------------------------------------------------------

#
# Table structure for table `import_comsa`
#

DROP TABLE IF EXISTS `import_comsa`;
CREATE TABLE `import_comsa` (
  `import_id` int(11) NOT NULL auto_increment,
  `update_items_price` varchar(200) NOT NULL default '1',
  `update_item_titel` varchar(200) NOT NULL default '0',
  `update_item_beschreibung` varchar(200) NOT NULL default '0',
  `bilder_verzeichnis_voll` varchar(200) default NULL,
  `bilder_verzeichnis_ab_picturesordner` varchar(200) NOT NULL default 'alle',
  `benutzer_api` varchar(200) default NULL,
  `passwort_api` varchar(200) NOT NULL default '/',
  `wenn_hersteller_leer` varchar(200) default NULL,
  `synonym_for_model` varchar(200) NOT NULL default 'api',
  `namekat` varchar(200) default NULL,
  `name_comsa_file` varchar(200) default NULL,
  `ampel` varchar(200) NOT NULL default 'nein',
  `endkunden` varchar(200) NOT NULL default 'ja',
  `last_update` int(10) NOT NULL default '0',
  `herstellervergleich` int(11) NOT NULL default '2',
  PRIMARY KEY  (`import_id`)
) AUTO_INCREMENT=2 ;

#
# Datas for the table `import_comsa`
#

INSERT INTO `import_comsa` VALUES (1, '1', '1', '', '/IHR_GANZER_SERVERPFAD_ZUM_SHOP/picture/alle', 'alle', '', '', 'www.YourDomain.de/hersteller.html', 'syno_2', 'Komsa', '', 'ja', 'ja', 1114005370, 2);

# --------------------------------------------------------

#
# Table structure for table `info_conditions`
#

DROP TABLE IF EXISTS `info_conditions`;
CREATE TABLE `info_conditions` (
  `Id` int(1) unsigned NOT NULL default '0',
  `Text` blob NOT NULL,
  `language_id` int(11) NOT NULL default '2',
  PRIMARY KEY  (`Id`,`language_id`)
) ;

#
# Datas for the table `info_conditions`
#

INSERT INTO `info_conditions` VALUES(1, 0x3c5350414e207374796c653d22464f4e542d5745494748543a20626f6c64223e3c2f5350414e3e3c42523e, 3);
INSERT INTO `info_conditions` VALUES(1,  , 5);

# --------------------------------------------------------

#
# Table structure for table `info_delivery_time`
#

DROP TABLE IF EXISTS `info_delivery_time`;
CREATE TABLE `info_delivery_time` (
  `Id` int(1) unsigned NOT NULL default '0',
  `Text` blob NOT NULL,
  `language_id` int(11) NOT NULL default '2',
  PRIMARY KEY  (`Id`,`language_id`)
) ;

#
# Datas for the table `info_delivery_time`
#

# --------------------------------------------------------

#
# Table structure for table `info_give_back`
#

DROP TABLE IF EXISTS `info_give_back`;
CREATE TABLE `info_give_back` (
  `Id` int(1) unsigned NOT NULL default '0',
  `Text` blob NOT NULL,
  `language_id` int(11) NOT NULL default '2',
  `name` VARCHAR(30) NULL ,
  `size` VARCHAR(12) NULL ,
  `type` VARCHAR(120) NULL ,
  `content` MEDIUMBLOB NULL ,
  PRIMARY KEY  (`Id`,`language_id`)
) ;

#
# Datas for the table `info_give_back`
#

# --------------------------------------------------------

#
# Table structure for table `info_privacy`
#

DROP TABLE IF EXISTS `info_privacy`;
CREATE TABLE `info_privacy` (
  `Id` int(1) unsigned NOT NULL default '0',
  `Text` blob NOT NULL,
  `language_id` int(11) NOT NULL default '2',
  PRIMARY KEY  (`Id`,`language_id`)
) ;

#
# Datas for the table `info_privacy`
#

INSERT INTO `info_privacy` VALUES(1, 0x4968726520446174656e2077657264656e2062656920756e7320696d2053696e6e652064657320446174656e73636875747a6573206e75722066fc7220696e6e6572626574726965626c69636865205a7765636b652066fc72206469652041627769636b6c756e672049687265732045696e6b617566657320756e64207a75204e616368776569737a7765636b656e2067657370656963686572742e20536f6c6c74656e20536965206e696368742077fc6e736368656e2c2064617373204968726520446174656e20656c656b74726f6e697363682067657370656963686572742077657264656e2c20736f207465696c656e2053696520756e7320646173206269747465206d69742e204e6174fc726c6963682065727465696c656e207769722049686e656e206a656465727a656974204175736b756e6674207a752064656e207a7520496872657220506572736f6e206765737065696368657274656e20446174656e2e204968726520446174656e2077657264656e206e696368742066fc7220776569746572652057657262656d61df6e616d656e2076657277656e64657420736f6665726e206e69636874206175736472fc636b6c69636820657277fc6e7363687421, 5);

# --------------------------------------------------------

#
# Table structure for table `info_shipping`
#

DROP TABLE IF EXISTS `info_shipping`;
CREATE TABLE `info_shipping` (
  `Id` int(1) unsigned NOT NULL default '0',
  `Text` blob NOT NULL,
  `language_id` int(11) NOT NULL default '2',
  PRIMARY KEY  (`Id`,`language_id`)
) ;

#
# Datas for the table `info_shipping`
#

INSERT INTO `info_shipping` VALUES(1, 0x48696572206469652056657273616e64626564696e67756e67656e2068696e65696e2121, 5);

# --------------------------------------------------------

#
# Table structure for table `items`
#

DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `items_id` int(24) NOT NULL auto_increment,
  `items_quantity` int(4) NOT NULL default '0',
  `Featured_item` int(4) NOT NULL default '0',
  `items_model` varchar(24) default NULL,
  `items_picture` varchar(255) default NULL,
  `items_bpicture` varchar(255) default NULL,
  `items_3picture` varchar(255) default NULL,
  `items_4picture` varchar(255) default NULL,
  `items_5picture` varchar(255) default NULL,
  `items_price` decimal(15,4) NOT NULL default '0.0000',
  `items_basis_price` decimal(15,4) NOT NULL default '0.0000',
  `items_price_option` varchar(10) NOT NULL default '0',
  `items_price_uvp` decimal(15,4) NOT NULL default '0.0000',
  `unit_price_option` VARCHAR( 12 ) NOT NULL DEFAULT  'none',
  `unit_price_factor` DECIMAL( 10, 6 ) NOT NULL DEFAULT  '1',
  `delivery_time_id` INT(6) NULL,
  `shipping_zone_1` decimal(15,4) NOT NULL default '0.0000',
  `shipping_zone_2` decimal(15,4) NOT NULL default '0.0000',
  `items_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `items_last_modified` datetime default NULL,
  `items_date_available` datetime default NULL,
  `items_date_available_end` datetime default NULL,
  `items_weight` decimal(5,2) NOT NULL default '0.00',
  `items_status` tinyint(1) NOT NULL default '0',
  `domainservice_status` tinyint(1) NOT NULL default '0',
  `domainservice_zahlungsintervall` tinyint(1) NOT NULL default '0',
  `items_tax_class_id` int(11) NOT NULL default '0',
  `producers_id` int(11) default NULL,
  `items_ordered` int(11) NOT NULL default '0',
  `items_percentage` tinyint(1) NOT NULL default '1',
  `syn` varchar(200) default NULL,
  `neu` int(11) NOT NULL default '2',
  `herstellernummer` varchar(100) NOT NULL default '',
  `items_ship_price` decimal(15,4) NOT NULL default '0.0000',
  `items_ship_price_two` decimal(15,4) NOT NULL default '0.0000',
  `items_sort` int(11) NOT NULL default '2147483647',
  `items_bundle` tinytext NOT NULL,
  `shipping_greatship` decimal(15,4) NOT NULL default '0.0000',
  `extra_item_costumer_input` int(2) NOT NULL default '0',
  `item_costumer_input_width` varchar(65) NOT NULL default '',
  `item_costumer_input_height` varchar(65) NOT NULL default '',
  `iss_masseinheit` int(2) NOT NULL default '0',
  `iss_download` int(2) NOT NULL default '0',
  `upc_ean_isbn` varchar(250) NOT NULL default '1',
  `shipping_range_group_id` INT UNSIGNED DEFAULT '0',
  PRIMARY KEY  (`items_id`),
  KEY `idx_items_date_added` (`items_date_added`)
) AUTO_INCREMENT=67 ;

#
# Datas for the table `items`
#

INSERT INTO `items` VALUES(58, 99, 0, '98570965', '19336.jpg', '', '', '', '', 89.0000, 0.0000, '', 0.0000, '', '',NULL, 0.0000, 0.0000, '2006-09-20 22:54:54', '2008-03-12 11:27:51', NULL, NULL, 0.00, 1, 0, 0, 1, 0, 1, 1, NULL, 2, '', 0.0000, 0.0000, 2147483647, 'no', 0.0000, 0, '', '', 0, 0, '', '');
INSERT INTO `items` VALUES(59, 100, 0, '928365052', 'Magnolia-Poster1.jpg', '', '', '', '', 56.0000, 0.0000, '', 0.0000, '', '',NULL, 0.0000, 0.0000, '2006-09-20 23:00:17', '2008-03-12 18:17:05', NULL, NULL, 0.00, 1, 0, 0, 1, 0, 0, 1, NULL, 2, '', 0.0000, 0.0000, 2147483647, 'no', 0.0000, 0, '', '', 0, 0, '', '');
INSERT INTO `items` VALUES(60, 99, 0, '451345145', 'AbDurchDieHecke-PosterGer2.jpg', '', '', '', '', 44.0000, 0.0000, '', 0.0000, '', '',NULL, 0.0000, 0.0000, '2006-09-20 23:06:57', NULL, NULL, NULL, 0.00, 1, 0, 0, 1, 0, 1, 1, NULL, 2, '', 0.0000, 0.0000, 2147483647, '', 0.0000, 0, '', '', 0, 0, '', '');
INSERT INTO `items` VALUES(66, 100, 0, '613656', 'G767580.jpg', '', '', '', '', 10.0000, 0.0000, '', 0.0000, '', '',NULL, 0.0000, 0.0000, '2008-03-01 22:37:26', '2008-03-12 18:15:33', NULL, NULL, 0.00, 1, 0, 0, 1, 0, 0, 1, NULL, 2, '', 0.0000, 0.0000, 2147483647, 'no', 0.0000, 0, '', '', 0, 0, '', '');

# --------------------------------------------------------

#
# Table structure for table `items_characteristics`
#

DROP TABLE IF EXISTS `items_characteristics`;
CREATE TABLE `items_characteristics` (
  `items_characteristics_id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `options_id` int(11) NOT NULL default '0',
  `options_values_id` int(11) NOT NULL default '0',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  `attributs_sort_order` tinyint(4) NOT NULL default '0',
  `qty` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`items_characteristics_id`)
) AUTO_INCREMENT=40 ;

#
# Datas for the table `items_characteristics`
#

INSERT INTO `items_characteristics` VALUES(39, 58, 1, 5, 0.0000, '+', 0, '');
INSERT INTO `items_characteristics` VALUES(38, 58, 1, 4, 0.0000, '+', 0, '');
INSERT INTO `items_characteristics` VALUES(37, 58, 1, 3, 0.0000, '+', 0, '');
INSERT INTO `items_characteristics` VALUES(36, 58, 1, 2, 0.0000, '+', 0, '');
INSERT INTO `items_characteristics` VALUES(35, 58, 1, 1, 0.0000, '+', 0, '');

# --------------------------------------------------------

#
# Table structure for table `items_characteristics_conf`
#

DROP TABLE IF EXISTS `items_characteristics_conf`;
CREATE TABLE `items_characteristics_conf` (
  `items_characteristics_conf_id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `options_conf_id` int(11) NOT NULL default '0',
  `options_conf_parent_id` int(11) NOT NULL default '0',
  `options_conf_values_id` int(11) NOT NULL default '0',
  `options_conf_values_parent_id` int(11) NOT NULL default '0',
  `options_conf_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  `attributs_conf_sort_order` tinyint(4) NOT NULL default '0',
  `qty` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`items_characteristics_conf_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `items_characteristics_conf`
#


# --------------------------------------------------------

#
# Table structure for table `items_characteristics_download`
#

DROP TABLE IF EXISTS `items_characteristics_download`;
CREATE TABLE `items_characteristics_download` (
  `items_characteristics_id` int(11) NOT NULL default '0',
  `items_characteristics_filename` varchar(255) NOT NULL default '',
  `items_characteristics_maxdays` int(2) default '0',
  `items_characteristics_maxcount` int(2) default '0',
  PRIMARY KEY  (`items_characteristics_id`)
) ;

#
# Datas for the table `items_characteristics_download`
#


# --------------------------------------------------------

#
# Table structure for table `items_default_option_conf`
#

DROP TABLE IF EXISTS `items_default_option_conf`;
CREATE TABLE `items_default_option_conf` (
  `id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `items_options_conf_id` int(11) NOT NULL default '0',
  `items_options_conf_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `items_default_option_conf`
#


# --------------------------------------------------------

#
# Table structure for table `items_description`
#

DROP TABLE IF EXISTS `items_description`;
CREATE TABLE `items_description` (
  `items_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `items_name` varchar(128) NOT NULL default '',
  `items_name2` varchar(128) NOT NULL default '',
  `items_description` text,
  `items_url` varchar(255) default NULL,
  `items_viewed` int(5) default '0',
  `bezeichnung1` varchar(200) NOT NULL default '',
  `inhalt1` varchar(200) NOT NULL default '',
  `bezeichnung2` varchar(200) NOT NULL default '',
  `inhalt2` varchar(200) NOT NULL default '',
  `bezeichnung3` varchar(200) NOT NULL default '',
  `inhalt3` varchar(200) NOT NULL default '',
  `bezeichnung4` varchar(200) NOT NULL default '',
  `inhalt4` varchar(200) NOT NULL default '',
  `bezeichnung5` varchar(200) NOT NULL default '',
  `inhalt5` varchar(200) NOT NULL default '',
  `bezeichnung6` varchar(200) NOT NULL default '',
  `inhalt6` varchar(200) NOT NULL default '',
  `extra_item_costumer_input_text_preceded` varchar(65) NOT NULL default '',
  `items_description_in_cat_list` text,
  PRIMARY KEY  (`items_id`,`language_id`),
  KEY `items_name` (`items_name`)
) AUTO_INCREMENT=67 ;

#
# Datas for the table `items_description`
#

INSERT INTO `items_description` VALUES(58, 5, 'Testartikel2', 'Artikelname2', '', '', 63, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(58, 3, 'Testartikel2', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 't', NULL);
INSERT INTO `items_description` VALUES(59, 5, 'TestArtikel3', '', '<br>', '', 23, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(59, 3, 'TestArtikel3', '', '<br>', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(60, 5, 'TestArtikel4', '', '', '', 13, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(60, 3, 'TestArtikel4', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(66, 3, 'Testartikel1', '', '<br>', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);
INSERT INTO `items_description` VALUES(66, 5, 'Testartikel1', '', 'Dies ist der Testartikel1', '', 34, '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);

# --------------------------------------------------------

#
# Table structure for table `items_groups`
#

DROP TABLE IF EXISTS `items_groups`;
CREATE TABLE `items_groups` (
  `attendees_group_id` int(11) NOT NULL default '0',
  `attendees_group_price` decimal(15,2) NOT NULL default '0.00',
  `items_id` int(11) NOT NULL default '0',
  `items_price` decimal(15,2) NOT NULL default '0.00'
) ;

#
# Datas for the table `items_groups`
#

INSERT INTO `items_groups` VALUES(1, 0.00, 56, 0.00);
INSERT INTO `items_groups` VALUES(2, 0.00, 56, 0.00);
INSERT INTO `items_groups` VALUES(1, 80.10, 58, 89.00);
INSERT INTO `items_groups` VALUES(2, 75.65, 58, 89.00);
INSERT INTO `items_groups` VALUES(1, 50.40, 59, 56.00);
INSERT INTO `items_groups` VALUES(2, 47.60, 59, 56.00);
INSERT INTO `items_groups` VALUES(1, 39.60, 60, 44.00);
INSERT INTO `items_groups` VALUES(2, 37.40, 60, 44.00);
INSERT INTO `items_groups` VALUES(1, 9.00, 66, 10.00);
INSERT INTO `items_groups` VALUES(2, 8.50, 66, 10.00);

# --------------------------------------------------------

#
# Table structure for table `items_informs`
#

DROP TABLE IF EXISTS `items_informs`;
CREATE TABLE `items_informs` (
  `items_id` int(11) NOT NULL default '0',
  `attendees_id` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`items_id`,`attendees_id`)
) ;

#
# Datas for the table `items_informs`
#


# --------------------------------------------------------

#
# Table structure for table `items_options`
#

DROP TABLE IF EXISTS `items_options`;
CREATE TABLE `items_options` (
  `items_options_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `items_options_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`items_options_id`,`language_id`)
) ;

#
# Datas for the table `items_options`
#

INSERT INTO `items_options` VALUES(1, 3, 'Gr&ouml;&szlig;e');
INSERT INTO `items_options` VALUES(1, 5, 'Gr&ouml;&szlig;e');

# --------------------------------------------------------

#
# Table structure for table `items_options_conf`
#

DROP TABLE IF EXISTS `items_options_conf`;
CREATE TABLE `items_options_conf` (
  `items_options_conf_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `items_options_conf_name` varchar(32) NOT NULL default '',
  `items_type` enum('selectframe','radioframe','checkbox') NOT NULL default 'selectframe',
  PRIMARY KEY  (`items_options_conf_id`,`language_id`)
) ;

#
# Datas for the table `items_options_conf`
#


# --------------------------------------------------------

#
# Table structure for table `items_options_conf_values`
#

DROP TABLE IF EXISTS `items_options_conf_values`;
CREATE TABLE `items_options_conf_values` (
  `items_options_conf_values_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `items_options_conf_values_name` varchar(64) NOT NULL default '',
  `items_options_conf_values_desc` text NOT NULL,
  `in_items_neu` int(2) NOT NULL default '0',
  PRIMARY KEY  (`items_options_conf_values_id`,`language_id`)
) ;

#
# Datas for the table `items_options_conf_values`
#


# --------------------------------------------------------

#
# Table structure for table `items_options_conf_values_to_items_options_conf`
#

DROP TABLE IF EXISTS `items_options_conf_values_to_items_options_conf`;
CREATE TABLE `items_options_conf_values_to_items_options_conf` (
  `items_options_conf_values_to_items_options_conf_id` int(11) NOT NULL auto_increment,
  `items_options_conf_id` int(11) NOT NULL default '0',
  `items_options_conf_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`items_options_conf_values_to_items_options_conf_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `items_options_conf_values_to_items_options_conf`
#


# --------------------------------------------------------

#
# Table structure for table `items_options_values`
#

DROP TABLE IF EXISTS `items_options_values`;
CREATE TABLE `items_options_values` (
  `items_options_values_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `items_options_values_name` varchar(64) NOT NULL default '',
  `in_items_neu` int(2) NOT NULL default '0',
  PRIMARY KEY  (`items_options_values_id`,`language_id`)
) ;

#
# Datas for the table `items_options_values`
#

INSERT INTO `items_options_values` VALUES(5, 3, 'XXXl', 0);
INSERT INTO `items_options_values` VALUES(1, 3, 'XL', 0);
INSERT INTO `items_options_values` VALUES(2, 5, 'X', 0);
INSERT INTO `items_options_values` VALUES(2, 3, 'X', 0);
INSERT INTO `items_options_values` VALUES(3, 5, 'L', 0);
INSERT INTO `items_options_values` VALUES(3, 3, 'L', 0);
INSERT INTO `items_options_values` VALUES(4, 5, 'XXL', 0);
INSERT INTO `items_options_values` VALUES(4, 3, 'XXL', 0);
INSERT INTO `items_options_values` VALUES(5, 5, 'XXXl', 0);
INSERT INTO `items_options_values` VALUES(1, 5, 'XL', 0);

# --------------------------------------------------------

#
# Table structure for table `items_options_values_to_items_options`
#

DROP TABLE IF EXISTS `items_options_values_to_items_options`;
CREATE TABLE `items_options_values_to_items_options` (
  `items_options_values_to_items_options_id` int(11) NOT NULL auto_increment,
  `items_options_id` int(11) NOT NULL default '0',
  `items_options_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`items_options_values_to_items_options_id`)
) AUTO_INCREMENT=66 ;

#
# Datas for the table `items_options_values_to_items_options`
#

INSERT INTO `items_options_values_to_items_options` VALUES(62, 1, 2);
INSERT INTO `items_options_values_to_items_options` VALUES(63, 1, 3);
INSERT INTO `items_options_values_to_items_options` VALUES(61, 1, 1);
INSERT INTO `items_options_values_to_items_options` VALUES(65, 1, 5);
INSERT INTO `items_options_values_to_items_options` VALUES(64, 1, 4);

# --------------------------------------------------------

#
# Table structure for table `items_to_categories`
#

DROP TABLE IF EXISTS `items_to_categories`;
CREATE TABLE `items_to_categories` (
  `items_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`items_id`,`categories_id`)
) ;

#
# Datas for the table `items_to_categories`
#

INSERT INTO `items_to_categories` VALUES(58, 20);
INSERT INTO `items_to_categories` VALUES(59, 21);
INSERT INTO `items_to_categories` VALUES(60, 21);
INSERT INTO `items_to_categories` VALUES(66, 20);

# --------------------------------------------------------

#
# Table structure for table `items_xsell`
#

DROP TABLE IF EXISTS `items_xsell`;
CREATE TABLE `items_xsell` (
  `ID` int(10) NOT NULL auto_increment,
  `items_id` int(10) unsigned NOT NULL default '1',
  `xsell_id` int(10) unsigned NOT NULL default '1',
  `sort_order` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `items_xsell`
#


# --------------------------------------------------------

#
# Table structure for table `item_template`
#

DROP TABLE IF EXISTS `item_template`;
CREATE TABLE `item_template` (
  `template_id` tinyint(3) NOT NULL default '0',
  `aktiviert` tinyint(3) NOT NULL default '0',
  `template_inhalt` blob,
  `uvp_anzeigen` varchar(11) NOT NULL default '0',
  `items_name2_anzeigen` varchar(11) NOT NULL default '0',
  `text_uvp` varchar(50) NOT NULL default '',
  `text_price` varchar(50) NOT NULL default '',
  `anzahl_select` int(24) NOT NULL default '500'
) ;

#
# Datas for the table `item_template`
#

INSERT INTO `item_template` VALUES(1, 1,  , '0', '0', '', '', 500);
INSERT INTO `item_template` VALUES(2, 1,  , '0', '0', '', '', 500);
# --------------------------------------------------------

#
# Table structure for table `lands`
#

DROP TABLE IF EXISTS `lands`;
CREATE TABLE `lands` (
  `lands_id` int(11) NOT NULL auto_increment,
  `lands_name` varchar(64) NOT NULL default '',
  `lands_iso_code_2` char(2) NOT NULL default '',
  `lands_iso_code_3` char(3) NOT NULL default '',
  `form_of_address_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`lands_id`),
  KEY `IDX_LANDS_NAME` (`lands_name`)
) AUTO_INCREMENT=240 ;

#
# Datas for the table `lands`
#

INSERT INTO `lands` VALUES(1, 'Afghanistan', 'AF', 'AFG', 1);
INSERT INTO `lands` VALUES(2, 'Albania', 'AL', 'ALB', 1);
INSERT INTO `lands` VALUES(3, 'Algeria', 'DZ', 'DZA', 1);
INSERT INTO `lands` VALUES(4, 'American Samoa', 'AS', 'ASM', 1);
INSERT INTO `lands` VALUES(5, 'Andorra', 'AD', 'AND', 1);
INSERT INTO `lands` VALUES(6, 'Angola', 'AO', 'AGO', 1);
INSERT INTO `lands` VALUES(7, 'Anguilla', 'AI', 'AIA', 1);
INSERT INTO `lands` VALUES(8, 'Antarctica', 'AQ', 'ATA', 1);
INSERT INTO `lands` VALUES(9, 'Antigua and Barbuda', 'AG', 'ATG', 1);
INSERT INTO `lands` VALUES(10, 'Argentina', 'AR', 'ARG', 1);
INSERT INTO `lands` VALUES(11, 'Armenia', 'AM', 'ARM', 1);
INSERT INTO `lands` VALUES(12, 'Aruba', 'AW', 'ABW', 1);
INSERT INTO `lands` VALUES(13, 'Australia', 'AU', 'AUS', 1);
INSERT INTO `lands` VALUES(14, 'Austria', 'AT', 'AUT', 5);
INSERT INTO `lands` VALUES(15, 'Azerbaijan', 'AZ', 'AZE', 1);
INSERT INTO `lands` VALUES(16, 'Bahamas', 'BS', 'BHS', 1);
INSERT INTO `lands` VALUES(17, 'Bahrain', 'BH', 'BHR', 1);
INSERT INTO `lands` VALUES(18, 'Bangladesh', 'BD', 'BGD', 1);
INSERT INTO `lands` VALUES(19, 'Barbados', 'BB', 'BRB', 1);
INSERT INTO `lands` VALUES(20, 'Belarus', 'BY', 'BLR', 1);
INSERT INTO `lands` VALUES(21, 'Belgium', 'BE', 'BEL', 1);
INSERT INTO `lands` VALUES(22, 'Belize', 'BZ', 'BLZ', 1);
INSERT INTO `lands` VALUES(23, 'Benin', 'BJ', 'BEN', 1);
INSERT INTO `lands` VALUES(24, 'Bermuda', 'BM', 'BMU', 1);
INSERT INTO `lands` VALUES(25, 'Bhutan', 'BT', 'BTN', 1);
INSERT INTO `lands` VALUES(26, 'Bolivia', 'BO', 'BOL', 1);
INSERT INTO `lands` VALUES(27, 'Bosnia and Herzegowina', 'BA', 'BIH', 1);
INSERT INTO `lands` VALUES(28, 'Botswana', 'BW', 'BWA', 1);
INSERT INTO `lands` VALUES(29, 'Bouvet Island', 'BV', 'BVT', 1);
INSERT INTO `lands` VALUES(30, 'Brazil', 'BR', 'BRA', 1);
INSERT INTO `lands` VALUES(31, 'British Indian Ocean Territory', 'IO', 'IOT', 1);
INSERT INTO `lands` VALUES(32, 'Brunei Darussalam', 'BN', 'BRN', 1);
INSERT INTO `lands` VALUES(33, 'Bulgaria', 'BG', 'BGR', 1);
INSERT INTO `lands` VALUES(34, 'Burkina Faso', 'BF', 'BFA', 1);
INSERT INTO `lands` VALUES(35, 'Burundi', 'BI', 'BDI', 1);
INSERT INTO `lands` VALUES(36, 'Cambodia', 'KH', 'KHM', 1);
INSERT INTO `lands` VALUES(37, 'Cameroon', 'CM', 'CMR', 1);
INSERT INTO `lands` VALUES(38, 'Canada', 'CA', 'CAN', 1);
INSERT INTO `lands` VALUES(39, 'Cape Verde', 'CV', 'CPV', 1);
INSERT INTO `lands` VALUES(40, 'Cayman Islands', 'KY', 'CYM', 1);
INSERT INTO `lands` VALUES(41, 'Central African Republic', 'CF', 'CAF', 1);
INSERT INTO `lands` VALUES(42, 'Chad', 'TD', 'TCD', 1);
INSERT INTO `lands` VALUES(43, 'Chile', 'CL', 'CHL', 1);
INSERT INTO `lands` VALUES(44, 'China', 'CN', 'CHN', 1);
INSERT INTO `lands` VALUES(45, 'Christmas Island', 'CX', 'CXR', 1);
INSERT INTO `lands` VALUES(46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 1);
INSERT INTO `lands` VALUES(47, 'Colombia', 'CO', 'COL', 1);
INSERT INTO `lands` VALUES(48, 'Comoros', 'KM', 'COM', 1);
INSERT INTO `lands` VALUES(49, 'Congo', 'CG', 'COG', 1);
INSERT INTO `lands` VALUES(50, 'Cook Islands', 'CK', 'COK', 1);
INSERT INTO `lands` VALUES(51, 'Costa Rica', 'CR', 'CRI', 1);
INSERT INTO `lands` VALUES(52, 'Cote D\'Ivoire', 'CI', 'CIV', 1);
INSERT INTO `lands` VALUES(53, 'Croatia', 'HR', 'HRV', 1);
INSERT INTO `lands` VALUES(54, 'Cuba', 'CU', 'CUB', 1);
INSERT INTO `lands` VALUES(55, 'Cyprus', 'CY', 'CYP', 1);
INSERT INTO `lands` VALUES(56, 'Czech Republic', 'CZ', 'CZE', 1);
INSERT INTO `lands` VALUES(57, 'Denmark', 'DK', 'DNK', 1);
INSERT INTO `lands` VALUES(58, 'Djibouti', 'DJ', 'DJI', 1);
INSERT INTO `lands` VALUES(59, 'Dominica', 'DM', 'DMA', 1);
INSERT INTO `lands` VALUES(60, 'Dominican Republic', 'DO', 'DOM', 1);
INSERT INTO `lands` VALUES(61, 'East Timor', 'TP', 'TMP', 1);
INSERT INTO `lands` VALUES(62, 'Ecuador', 'EC', 'ECU', 1);
INSERT INTO `lands` VALUES(63, 'Egypt', 'EG', 'EGY', 1);
INSERT INTO `lands` VALUES(64, 'El Salvador', 'SV', 'SLV', 1);
INSERT INTO `lands` VALUES(65, 'Equatorial Guinea', 'GQ', 'GNQ', 1);
INSERT INTO `lands` VALUES(66, 'Eritrea', 'ER', 'ERI', 1);
INSERT INTO `lands` VALUES(67, 'Estonia', 'EE', 'EST', 1);
INSERT INTO `lands` VALUES(68, 'Ethiopia', 'ET', 'ETH', 1);
INSERT INTO `lands` VALUES(69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1);
INSERT INTO `lands` VALUES(70, 'Faroe Islands', 'FO', 'FRO', 1);
INSERT INTO `lands` VALUES(71, 'Fiji', 'FJ', 'FJI', 1);
INSERT INTO `lands` VALUES(72, 'Finland', 'FI', 'FIN', 1);
INSERT INTO `lands` VALUES(73, 'France', 'FR', 'FRA', 1);
INSERT INTO `lands` VALUES(74, 'France, Metropolitan', 'FX', 'FXX', 1);
INSERT INTO `lands` VALUES(75, 'French Guiana', 'GF', 'GUF', 1);
INSERT INTO `lands` VALUES(76, 'French Polynesia', 'PF', 'PYF', 1);
INSERT INTO `lands` VALUES(77, 'French Southern Territories', 'TF', 'ATF', 1);
INSERT INTO `lands` VALUES(78, 'Gabon', 'GA', 'GAB', 1);
INSERT INTO `lands` VALUES(79, 'Gambia', 'GM', 'GMB', 1);
INSERT INTO `lands` VALUES(80, 'Georgia', 'GE', 'GEO', 1);
INSERT INTO `lands` VALUES(81, 'Germany', 'DE', 'DEU', 5);
INSERT INTO `lands` VALUES(82, 'Ghana', 'GH', 'GHA', 1);
INSERT INTO `lands` VALUES(83, 'Gibraltar', 'GI', 'GIB', 1);
INSERT INTO `lands` VALUES(84, 'Greece', 'GR', 'GRC', 1);
INSERT INTO `lands` VALUES(85, 'Greenland', 'GL', 'GRL', 1);
INSERT INTO `lands` VALUES(86, 'Grenada', 'GD', 'GRD', 1);
INSERT INTO `lands` VALUES(87, 'Guadeloupe', 'GP', 'GLP', 1);
INSERT INTO `lands` VALUES(88, 'Guam', 'GU', 'GUM', 1);
INSERT INTO `lands` VALUES(89, 'Guatemala', 'GT', 'GTM', 1);
INSERT INTO `lands` VALUES(90, 'Guinea', 'GN', 'GIN', 1);
INSERT INTO `lands` VALUES(91, 'Guinea-bissau', 'GW', 'GNB', 1);
INSERT INTO `lands` VALUES(92, 'Guyana', 'GY', 'GUY', 1);
INSERT INTO `lands` VALUES(93, 'Haiti', 'HT', 'HTI', 1);
INSERT INTO `lands` VALUES(94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 1);
INSERT INTO `lands` VALUES(95, 'Honduras', 'HN', 'HND', 1);
INSERT INTO `lands` VALUES(96, 'Hong Kong', 'HK', 'HKG', 1);
INSERT INTO `lands` VALUES(97, 'Hungary', 'HU', 'HUN', 1);
INSERT INTO `lands` VALUES(98, 'Iceland', 'IS', 'ISL', 1);
INSERT INTO `lands` VALUES(99, 'India', 'IN', 'IND', 1);
INSERT INTO `lands` VALUES(100, 'Indonesia', 'ID', 'IDN', 1);
INSERT INTO `lands` VALUES(101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1);
INSERT INTO `lands` VALUES(102, 'Iraq', 'IQ', 'IRQ', 1);
INSERT INTO `lands` VALUES(103, 'Ireland', 'IE', 'IRL', 1);
INSERT INTO `lands` VALUES(104, 'Israel', 'IL', 'ISR', 1);
INSERT INTO `lands` VALUES(105, 'Italy', 'IT', 'ITA', 1);
INSERT INTO `lands` VALUES(106, 'Jamaica', 'JM', 'JAM', 1);
INSERT INTO `lands` VALUES(107, 'Japan', 'JP', 'JPN', 1);
INSERT INTO `lands` VALUES(108, 'Jordan', 'JO', 'JOR', 1);
INSERT INTO `lands` VALUES(109, 'Kazakhstan', 'KZ', 'KAZ', 1);
INSERT INTO `lands` VALUES(110, 'Kenya', 'KE', 'KEN', 1);
INSERT INTO `lands` VALUES(111, 'Kiribati', 'KI', 'KIR', 1);
INSERT INTO `lands` VALUES(112, 'Korea, Democratic People\'s Republic of', 'KP', 'PRK', 1);
INSERT INTO `lands` VALUES(113, 'Korea, Republic of', 'KR', 'KOR', 1);
INSERT INTO `lands` VALUES(114, 'Kuwait', 'KW', 'KWT', 1);
INSERT INTO `lands` VALUES(115, 'Kyrgyzstan', 'KG', 'KGZ', 1);
INSERT INTO `lands` VALUES(116, 'Lao People\'s Democratic Republic', 'LA', 'LAO', 1);
INSERT INTO `lands` VALUES(117, 'Latvia', 'LV', 'LVA', 1);
INSERT INTO `lands` VALUES(118, 'Lebanon', 'LB', 'LBN', 1);
INSERT INTO `lands` VALUES(119, 'Lesotho', 'LS', 'LSO', 1);
INSERT INTO `lands` VALUES(120, 'Liberia', 'LR', 'LBR', 1);
INSERT INTO `lands` VALUES(121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 1);
INSERT INTO `lands` VALUES(122, 'Liechtenstein', 'LI', 'LIE', 1);
INSERT INTO `lands` VALUES(123, 'Lithuania', 'LT', 'LTU', 1);
INSERT INTO `lands` VALUES(124, 'Luxembourg', 'LU', 'LUX', 1);
INSERT INTO `lands` VALUES(125, 'Macau', 'MO', 'MAC', 1);
INSERT INTO `lands` VALUES(126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 1);
INSERT INTO `lands` VALUES(127, 'Madagascar', 'MG', 'MDG', 1);
INSERT INTO `lands` VALUES(128, 'Malawi', 'MW', 'MWI', 1);
INSERT INTO `lands` VALUES(129, 'Malaysia', 'MY', 'MYS', 1);
INSERT INTO `lands` VALUES(130, 'Maldives', 'MV', 'MDV', 1);
INSERT INTO `lands` VALUES(131, 'Mali', 'ML', 'MLI', 1);
INSERT INTO `lands` VALUES(132, 'Malta', 'MT', 'MLT', 1);
INSERT INTO `lands` VALUES(133, 'Marshall Islands', 'MH', 'MHL', 1);
INSERT INTO `lands` VALUES(134, 'Martinique', 'MQ', 'MTQ', 1);
INSERT INTO `lands` VALUES(135, 'Mauritania', 'MR', 'MRT', 1);
INSERT INTO `lands` VALUES(136, 'Mauritius', 'MU', 'MUS', 1);
INSERT INTO `lands` VALUES(137, 'Mayotte', 'YT', 'MYT', 1);
INSERT INTO `lands` VALUES(138, 'Mexico', 'MX', 'MEX', 1);
INSERT INTO `lands` VALUES(139, 'Micronesia, Federated States of', 'FM', 'FSM', 1);
INSERT INTO `lands` VALUES(140, 'Moldova, Republic of', 'MD', 'MDA', 1);
INSERT INTO `lands` VALUES(141, 'Monaco', 'MC', 'MCO', 1);
INSERT INTO `lands` VALUES(142, 'Mongolia', 'MN', 'MNG', 1);
INSERT INTO `lands` VALUES(143, 'Montserrat', 'MS', 'MSR', 1);
INSERT INTO `lands` VALUES(144, 'Morocco', 'MA', 'MAR', 1);
INSERT INTO `lands` VALUES(145, 'Mozambique', 'MZ', 'MOZ', 1);
INSERT INTO `lands` VALUES(146, 'Myanmar', 'MM', 'MMR', 1);
INSERT INTO `lands` VALUES(147, 'Namibia', 'NA', 'NAM', 1);
INSERT INTO `lands` VALUES(148, 'Nauru', 'NR', 'NRU', 1);
INSERT INTO `lands` VALUES(149, 'Nepal', 'NP', 'NPL', 1);
INSERT INTO `lands` VALUES(150, 'Netherlands', 'NL', 'NLD', 1);
INSERT INTO `lands` VALUES(151, 'Netherlands Antilles', 'AN', 'ANT', 1);
INSERT INTO `lands` VALUES(152, 'New Caledonia', 'NC', 'NCL', 1);
INSERT INTO `lands` VALUES(153, 'New Zealand', 'NZ', 'NZL', 1);
INSERT INTO `lands` VALUES(154, 'Nicaragua', 'NI', 'NIC', 1);
INSERT INTO `lands` VALUES(155, 'Niger', 'NE', 'NER', 1);
INSERT INTO `lands` VALUES(156, 'Nigeria', 'NG', 'NGA', 1);
INSERT INTO `lands` VALUES(157, 'Niue', 'NU', 'NIU', 1);
INSERT INTO `lands` VALUES(158, 'Norfolk Island', 'NF', 'NFK', 1);
INSERT INTO `lands` VALUES(159, 'Northern Mariana Islands', 'MP', 'MNP', 1);
INSERT INTO `lands` VALUES(160, 'Norway', 'NO', 'NOR', 1);
INSERT INTO `lands` VALUES(161, 'Oman', 'OM', 'OMN', 1);
INSERT INTO `lands` VALUES(162, 'Pakistan', 'PK', 'PAK', 1);
INSERT INTO `lands` VALUES(163, 'Palau', 'PW', 'PLW', 1);
INSERT INTO `lands` VALUES(164, 'Panama', 'PA', 'PAN', 1);
INSERT INTO `lands` VALUES(165, 'Papua New Guinea', 'PG', 'PNG', 1);
INSERT INTO `lands` VALUES(166, 'Paraguay', 'PY', 'PRY', 1);
INSERT INTO `lands` VALUES(167, 'Peru', 'PE', 'PER', 1);
INSERT INTO `lands` VALUES(168, 'Philippines', 'PH', 'PHL', 1);
INSERT INTO `lands` VALUES(169, 'Pitcairn', 'PN', 'PCN', 1);
INSERT INTO `lands` VALUES(170, 'Poland', 'PL', 'POL', 1);
INSERT INTO `lands` VALUES(171, 'Portugal', 'PT', 'PRT', 1);
INSERT INTO `lands` VALUES(172, 'Puerto Rico', 'PR', 'PRI', 1);
INSERT INTO `lands` VALUES(173, 'Qatar', 'QA', 'QAT', 1);
INSERT INTO `lands` VALUES(174, 'Reunion', 'RE', 'REU', 1);
INSERT INTO `lands` VALUES(175, 'Romania', 'RO', 'ROM', 1);
INSERT INTO `lands` VALUES(176, 'Russian Federation', 'RU', 'RUS', 1);
INSERT INTO `lands` VALUES(177, 'Rwanda', 'RW', 'RWA', 1);
INSERT INTO `lands` VALUES(178, 'Saint Kitts and Nevis', 'KN', 'KNA', 1);
INSERT INTO `lands` VALUES(179, 'Saint Lucia', 'LC', 'LCA', 1);
INSERT INTO `lands` VALUES(180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1);
INSERT INTO `lands` VALUES(181, 'Samoa', 'WS', 'WSM', 1);
INSERT INTO `lands` VALUES(182, 'San Marino', 'SM', 'SMR', 1);
INSERT INTO `lands` VALUES(183, 'Sao Tome and Principe', 'ST', 'STP', 1);
INSERT INTO `lands` VALUES(184, 'Saudi Arabia', 'SA', 'SAU', 1);
INSERT INTO `lands` VALUES(185, 'Senegal', 'SN', 'SEN', 1);
INSERT INTO `lands` VALUES(186, 'Seychelles', 'SC', 'SYC', 1);
INSERT INTO `lands` VALUES(187, 'Sierra Leone', 'SL', 'SLE', 1);
INSERT INTO `lands` VALUES(188, 'Singapore', 'SG', 'SGP', 4);
INSERT INTO `lands` VALUES(189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 1);
INSERT INTO `lands` VALUES(190, 'Slovenia', 'SI', 'SVN', 1);
INSERT INTO `lands` VALUES(191, 'Solomon Islands', 'SB', 'SLB', 1);
INSERT INTO `lands` VALUES(192, 'Somalia', 'SO', 'SOM', 1);
INSERT INTO `lands` VALUES(193, 'South Africa', 'ZA', 'ZAF', 1);
INSERT INTO `lands` VALUES(194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 1);
INSERT INTO `lands` VALUES(195, 'Spain', 'ES', 'ESP', 3);
INSERT INTO `lands` VALUES(196, 'Sri Lanka', 'LK', 'LKA', 1);
INSERT INTO `lands` VALUES(197, 'St. Helena', 'SH', 'SHN', 1);
INSERT INTO `lands` VALUES(198, 'St. Pierre and Miquelon', 'PM', 'SPM', 1);
INSERT INTO `lands` VALUES(199, 'Sudan', 'SD', 'SDN', 1);
INSERT INTO `lands` VALUES(200, 'Suriname', 'SR', 'SUR', 1);
INSERT INTO `lands` VALUES(201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1);
INSERT INTO `lands` VALUES(202, 'Swaziland', 'SZ', 'SWZ', 1);
INSERT INTO `lands` VALUES(203, 'Sweden', 'SE', 'SWE', 1);
INSERT INTO `lands` VALUES(204, 'Switzerland', 'CH', 'CHE', 1);
INSERT INTO `lands` VALUES(205, 'Syrian Arab Republic', 'SY', 'SYR', 1);
INSERT INTO `lands` VALUES(206, 'Taiwan', 'TW', 'TWN', 1);
INSERT INTO `lands` VALUES(207, 'Tajikistan', 'TJ', 'TJK', 1);
INSERT INTO `lands` VALUES(208, 'Tanzania, United Republic of', 'TZ', 'TZA', 1);
INSERT INTO `lands` VALUES(209, 'Thailand', 'TH', 'THA', 1);
INSERT INTO `lands` VALUES(210, 'Togo', 'TG', 'TGO', 1);
INSERT INTO `lands` VALUES(211, 'Tokelau', 'TK', 'TKL', 1);
INSERT INTO `lands` VALUES(212, 'Tonga', 'TO', 'TON', 1);
INSERT INTO `lands` VALUES(213, 'Trinidad and Tobago', 'TT', 'TTO', 1);
INSERT INTO `lands` VALUES(214, 'Tunisia', 'TN', 'TUN', 1);
INSERT INTO `lands` VALUES(215, 'Turkey', 'TR', 'TUR', 1);
INSERT INTO `lands` VALUES(216, 'Turkmenistan', 'TM', 'TKM', 1);
INSERT INTO `lands` VALUES(217, 'Turks and Caicos Islands', 'TC', 'TCA', 1);
INSERT INTO `lands` VALUES(218, 'Tuvalu', 'TV', 'TUV', 1);
INSERT INTO `lands` VALUES(219, 'Uganda', 'UG', 'UGA', 1);
INSERT INTO `lands` VALUES(220, 'Ukraine', 'UA', 'UKR', 1);
INSERT INTO `lands` VALUES(221, 'United Arab Emirates', 'AE', 'ARE', 1);
INSERT INTO `lands` VALUES(222, 'United Kingdom', 'GB', 'GBR', 1);
INSERT INTO `lands` VALUES(223, 'United States', 'US', 'USA', 2);
INSERT INTO `lands` VALUES(224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1);
INSERT INTO `lands` VALUES(225, 'Uruguay', 'UY', 'URY', 1);
INSERT INTO `lands` VALUES(226, 'Uzbekistan', 'UZ', 'UZB', 1);
INSERT INTO `lands` VALUES(227, 'Vanuatu', 'VU', 'VUT', 1);
INSERT INTO `lands` VALUES(228, 'Vatican City State (Holy See)', 'VA', 'VAT', 1);
INSERT INTO `lands` VALUES(229, 'Venezuela', 'VE', 'VEN', 1);
INSERT INTO `lands` VALUES(230, 'Viet Nam', 'VN', 'VNM', 1);
INSERT INTO `lands` VALUES(231, 'Virgin Islands (British)', 'VG', 'VGB', 1);
INSERT INTO `lands` VALUES(232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 1);
INSERT INTO `lands` VALUES(233, 'Wallis and Futuna Islands', 'WF', 'WLF', 1);
INSERT INTO `lands` VALUES(234, 'Western Sahara', 'EH', 'ESH', 1);
INSERT INTO `lands` VALUES(235, 'Yemen', 'YE', 'YEM', 1);
INSERT INTO `lands` VALUES(236, 'Yugoslavia', 'YU', 'YUG', 1);
INSERT INTO `lands` VALUES(237, 'Zaire', 'ZR', 'ZAR', 1);
INSERT INTO `lands` VALUES(238, 'Zambia', 'ZM', 'ZMB', 1);
INSERT INTO `lands` VALUES(239, 'Zimbabwe', 'ZW', 'ZWE', 1);

# --------------------------------------------------------

#
# Table structure for table `languages`
#

DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `languages_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `code` char(2) NOT NULL default '',
  `picture` varchar(64) default NULL,
  `directory` varchar(32) default NULL,
  `sort_order` int(3) default NULL,
  PRIMARY KEY  (`languages_id`),
  KEY `IDX_LANGUAGES_NAME` (`name`)
) AUTO_INCREMENT=6 ;

#
# Datas for the table `languages`
#

INSERT INTO `languages` VALUES(3, 'englisch', 'en', 'icon.gif', 'en', 2);
INSERT INTO `languages` VALUES(5, 'deutsch', 'de', 'icon.gif', 'de', 1);

# --------------------------------------------------------

#
# Table structure for table `languagesinhalt`
#

DROP TABLE IF EXISTS `languagesinhalt`;
CREATE TABLE `languagesinhalt` (
  `name` varchar(255) NOT NULL default '',
  `inhalt` text NOT NULL,
  `laenge` varchar(255) NOT NULL default ''
) ;

#
# Datas for the table `languagesinhalt`
#

INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('', '', '0');
INSERT INTO `languagesinhalt` VALUES('DATE_FORMAT_SHORT', '%d.%m.%Y', '17');
INSERT INTO `languagesinhalt` VALUES('DATE_FORMAT_LONG', '%A, %d. %B %Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_FORMAT', 'd.m.Y', '11');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('DATE_TIME_FORMAT', 'd.m.Y', '16');
INSERT INTO `languagesinhalt` VALUES('CATEGORY_PIVA', 'inkl. UST', '13');
INSERT INTO `languagesinhalt` VALUES('TAX_INCLUDED', 'inkl. UST', '12');
INSERT INTO `languagesinhalt` VALUES('TAX_EXCLUDED', 'exkl. UST', '12');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_PIVA', 'Umsatzsteueridentifikationsnummer:', '12');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_PIVA_ERROR', 'Falsche Umsatzsteueridentifikationsnummer .', '18');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_PIVA_TEXT', '*', '17');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_CF', 'Steuernummer:', '10');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_CF_TEXT', '*', '15');
INSERT INTO `languagesinhalt` VALUES('TYPE_IN_CF_ERROR', 'Falsche Steuernummer.', '16');
INSERT INTO `languagesinhalt` VALUES('PRICES_LOGGED_IN_TEXT', 'Preise nur, wenn eingeloggt', '21');
INSERT INTO `languagesinhalt` VALUES('PRICES_LOGGED_IN_SUBMIT', 'Preise nur, wenn eingelogt', '23');
INSERT INTO `languagesinhalt` VALUES('PRICES_LOGGED_IN_BUY_TEXT', 'Um jetzt zu kaufen loggen Sie sich bitte ein"', '25');
INSERT INTO `languagesinhalt` VALUES('LANGUAGE_CURRENCY', 'EUR', '17');
INSERT INTO `languagesinhalt` VALUES('HTML_PARAMS', 'dir="LTR" lang="de"', '11');
INSERT INTO `languagesinhalt` VALUES('CHARSET', 'iso-8859-1', '7');
INSERT INTO `languagesinhalt` VALUES('TITLE', '''. SHOP_NAME .''', '5');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_CREATE_MEMBER', 'Neues Konto', '26');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_MY_MEMBER', 'Ihr Konto', '22');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_CART_CONTENTS', 'Warenkorb', '26');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_CHECKOUT', 'Kasse', '21');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_TOP', 'Startseite', '16');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_CATALOG', 'Startseite ', '20');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_LOGOFF', 'Abmelden', '19');
INSERT INTO `languagesinhalt` VALUES('HEADER_TITLE_LOGIN', 'Anmelden', '18');
INSERT INTO `languagesinhalt` VALUES('FOOTER_TEXT_REQUESTS_SINCE', 'Zugriffe seit', '26');
INSERT INTO `languagesinhalt` VALUES('MALE', 'Herr', '4');
INSERT INTO `languagesinhalt` VALUES('FEMALE', 'Frau', '6');
INSERT INTO `languagesinhalt` VALUES('MALE_ADDRESS', 'Herr', '12');
INSERT INTO `languagesinhalt` VALUES('FEMALE_ADDRESS', 'Frau', '14');
INSERT INTO `languagesinhalt` VALUES('DOB_FORMAT_STRING', 'tt.mm.jjjj', '17');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_CATEGORIES', 'Kategorien', '22');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_PRODUCERS', 'Hersteller', '21');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_WHATS_NEW', 'Neue Produkte', '21');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_SEARCH', 'Schnellsuche', '18');
INSERT INTO `languagesinhalt` VALUES('FRAME_SEARCH_TEXT', 'Verwenden Sie Stichworte, um ein Produkt zu finden.', '17');
INSERT INTO `languagesinhalt` VALUES('FRAME_SEARCH_ADVANCED_SEARCH', 'erweiterte Suche', '28');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_SPECIALS', 'Angebote', '20');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_REVIEWS', 'Bewertungen', '19');
INSERT INTO `languagesinhalt` VALUES('FRAME_REVIERELATIV_WRITE_REVIEW', 'Bewerten Sie dieses Produkt!', '31');
INSERT INTO `languagesinhalt` VALUES('FRAME_REVIERELATIV_NO_REVIEWS', 'Es liegen noch keine Bewertungen vor', '29');
INSERT INTO `languagesinhalt` VALUES('FRAME_REVIERELATIV_TEXT_OF_5_STARS', '%s von 5 Sternen!', '34');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_SHOP_BASKET', 'Warenkorb', '23');
INSERT INTO `languagesinhalt` VALUES('FRAME_SHOP_BASKET_EMPTY', '0 Produkte', '23');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_ATTENDEE_ORDERS', 'Bestell&uuml;bersicht', '27');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_BESTSELLERS', 'Bestseller', '23');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_BESTSELLERS_IN', 'Bestseller<br>  ', '26');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_INFORMS', 'Benachrichtigungen', '19');
INSERT INTO `languagesinhalt` VALUES('FRAME_INFORMS_NOTIFY', 'Benachrichtigen Sie mich &uuml;ber Aktuelles zu diesem Artikel <b>%s</b>', '20');
INSERT INTO `languagesinhalt` VALUES('FRAME_INFORMS_NOTIFY_REMOVE', 'Benachrichtigen Sie mich nicht mehr zu diesem Artikel <b>%s</b>', '27');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_PRODUCER_INFO', 'Hersteller Info', '25');
INSERT INTO `languagesinhalt` VALUES('FRAME_PRODUCER_INFO_HOMEPAGE', '%s Homepage', '28');
INSERT INTO `languagesinhalt` VALUES('FRAME_PRODUCER_INFO_OTHER_ITEMS', 'Mehr Produkte', '31');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_LANGUAGES', 'Sprachen', '21');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_CURRENCIES', 'W&auml;hrungen', '22');
INSERT INTO `languagesinhalt` VALUES('FRAME_ABOVE_INFORMATION', 'Informationen', '23');
INSERT INTO `languagesinhalt` VALUES('FRAME_INFORMATION_PRIVACY', 'Privatsph&auml;re<br> und Datenschutz', '25');

# --------------------------------------------------------

#
# Table structure for table `limit_level_config`
#
DROP TABLE IF EXISTS `limit_level_config`;
CREATE TABLE  `limit_level_config` ( 
  `set_it_up_id` INT( 5 ) NOT NULL AUTO_INCREMENT KEY, 
  `set_it_up_title` VARCHAR( 64 ) NOT NULL , 
  `set_it_up_key` VARCHAR( 64 ) NOT NULL , 
  `set_it_up_value` VARCHAR( 255 ) NOT NULL , 
  `set_it_up_description` VARCHAR( 255 ) NOT NULL, 
  `last_modified` DATETIME , 
  `date_added` DATETIME );

#
# Datas for the table `limit_level_config`
#
 
INSERT INTO `limit_level_config` (`set_it_up_id`, `set_it_up_title`, `set_it_up_key`, `set_it_up_value`, `set_it_up_description`, `last_modified`, `date_added`) VALUES
  (null, 'gelbe Ampel anzeigen', 'SHOW_YELLOW_TRAFFIC_LIGHT', '10', '<br>Bitte geben Sie die Anzahl der Artikel ein, ab der die Ampel auf GELB schalten soll.<br><br>Wenn die vorhandene Artikelanzahl gr&ouml;&szlig;er als der hier vorgegebene Wert ist, schaltet die Ampel automatisch auf GR&Uuml;N.', now(), now()), 
  (null, 'orange Ampel anzeigen', 'SHOW_ORANGE_TRAFFIC_LIGHT', '5', '<br>Bitte geben Sie die Anzahl der Artikel ein, ab der die Ampel auf ORANGE schalten soll.', now(), now());

#
# Table structure for table `newsletters`
#

DROP TABLE IF EXISTS `newsletters`;
CREATE TABLE `newsletters` (
  `newsletters_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `module` varchar(255) NOT NULL default '',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_sent` datetime default NULL,
  `status` int(1) default NULL,
  `locked` int(1) default '0',
  PRIMARY KEY  (`newsletters_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `newsletters`
#


# --------------------------------------------------------

#
# Table structure for table `orders`
#

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `orders_id` int(11) NOT NULL auto_increment,
  `attendees_id` int(11) NOT NULL default '0',
  `attendees_name` varchar(64) NOT NULL default '',
  `attendees_company` varchar(32) default NULL,
  `attendees_street_address` varchar(64) NOT NULL default '',
  `attendees_street_address2` varchar(64) NOT NULL default '',
  `attendees_suburb` varchar(32) default NULL,
  `attendees_city` varchar(32) NOT NULL default '',
  `attendees_postcode` varchar(10) NOT NULL default '',
  `attendees_state` varchar(32) default NULL,
  `attendees_land` varchar(32) NOT NULL default '',
  `attendees_telephone` varchar(32) NOT NULL default '',
  `attendees_email_address` varchar(96) NOT NULL default '',
  `attendees_form_of_address_id` int(5) NOT NULL default '0',
  `delivery_name` varchar(64) NOT NULL default '',
  `delivery_company` varchar(32) default NULL,
  `delivery_street_address` varchar(64) NOT NULL default '',
  `delivery_street_address2` varchar(64) NOT NULL default '',
  `delivery_suburb` varchar(32) default NULL,
  `delivery_city` varchar(32) NOT NULL default '',
  `delivery_postcode` varchar(10) NOT NULL default '',
  `delivery_state` varchar(32) default NULL,
  `delivery_land` varchar(32) NOT NULL default '',
  `delivery_form_of_address_id` int(5) NOT NULL default '0',
  `billing_name` varchar(64) NOT NULL default '',
  `billing_company` varchar(32) default NULL,
  `billing_cf` varchar(16) default NULL,
  `billing_piva` varchar(11) default NULL,
  `billing_street_address` varchar(64) NOT NULL default '',
  `billing_street_address2` varchar(64) NOT NULL default '',
  `billing_suburb` varchar(32) default NULL,
  `billing_city` varchar(32) NOT NULL default '',
  `billing_postcode` varchar(10) NOT NULL default '',
  `billing_state` varchar(32) default NULL,
  `billing_land` varchar(32) NOT NULL default '',
  `billing_form_of_address_id` int(5) NOT NULL default '0',
  `payment_method` varchar(32) NOT NULL default '',
  `cc_type` varchar(20) default NULL,
  `cc_owner` varchar(64) default NULL,
  `cc_number` varchar(32) default NULL,
  `cc_code` varchar(4) default NULL,
  `cc_expires` varchar(4) default NULL,
  `last_modified` datetime default NULL,
  `date_purchased` datetime default NULL,
  `orders_status` int(5) NOT NULL default '0',
  `orders_date_finished` datetime default NULL,
  `currency` char(3) default NULL,
  `currency_value` decimal(14,6) default NULL,
  `payment_class` varchar(32) NOT NULL default '',
  `shipping_method` varchar(128) NOT NULL default '',
  `shipping_class` varchar(32) NOT NULL default '',
  `attendees_group_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`orders_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders`
#


# --------------------------------------------------------

#
# Table structure for table `orders_items`
#

DROP TABLE IF EXISTS `orders_items`;
CREATE TABLE `orders_items` (
  `orders_items_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `items_id` int(11) NOT NULL default '0',
  `items_model` varchar(24) default NULL,
  `items_name` varchar(64) NOT NULL default '',
  `items_price` decimal(15,4) NOT NULL default '0.0000',
  `items_basis_price` decimal(15,4) NOT NULL default '0.0000',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `items_tax` decimal(7,4) NOT NULL default '0.0000',
  `items_quantity` int(2) NOT NULL default '0',
  `items_laenge` int(10) NOT NULL default '0',
  `items_breite` int(10) NOT NULL default '0',
  `items_price_option` int(10) NOT NULL default '0',
  `items_price_option_comment` varchar(255) NOT NULL default '0',
  `items_display_opt_price` text NOT NULL,
  PRIMARY KEY  (`orders_items_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_items`
#


# --------------------------------------------------------

#
# Table structure for table `orders_items_characteristics`
#

DROP TABLE IF EXISTS `orders_items_characteristics`;
CREATE TABLE `orders_items_characteristics` (
  `orders_items_characteristics_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_items_id` int(11) NOT NULL default '0',
  `items_options` varchar(32) NOT NULL default '',
  `items_options_values` varchar(32) NOT NULL default '',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`orders_items_characteristics_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_items_characteristics`
#


# --------------------------------------------------------

#
# Table structure for table `orders_items_characteristics_conf`
#

DROP TABLE IF EXISTS `orders_items_characteristics_conf`;
CREATE TABLE `orders_items_characteristics_conf` (
  `orders_items_characteristics_conf_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_items_id` int(11) NOT NULL default '0',
  `items_options_conf` varchar(32) NOT NULL default '',
  `items_options_conf_values` varchar(32) NOT NULL default '',
  `options_conf_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`orders_items_characteristics_conf_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_items_characteristics_conf`
#


# --------------------------------------------------------

#
# Table structure for table `orders_items_download`
#

DROP TABLE IF EXISTS `orders_items_download`;
CREATE TABLE `orders_items_download` (
  `orders_items_download_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_items_id` int(11) NOT NULL default '0',
  `orders_items_filename` varchar(255) NOT NULL default '',
  `download_maxdays` int(2) NOT NULL default '0',
  `download_maxcount` int(4) NOT NULL default '0',
  PRIMARY KEY  (`orders_items_download_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_items_download`
#


# --------------------------------------------------------

#
# Table structure for table `orders_status`
#

DROP TABLE IF EXISTS `orders_status`;
CREATE TABLE `orders_status` (
  `orders_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `orders_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`orders_status_id`,`language_id`),
  KEY `idx_orders_status_name` (`orders_status_name`)
) ;

#
# Datas for the table `orders_status`
#

INSERT INTO `orders_status` VALUES(1, 3, 'Offen');
INSERT INTO `orders_status` VALUES(2, 3, 'In Bearbeitung');
INSERT INTO `orders_status` VALUES(3, 3, 'Versendet');
INSERT INTO `orders_status` VALUES(4, 3, 'Afterbuy Import');
INSERT INTO `orders_status` VALUES(5, 3, 'Bezahlt - download freigeben');
INSERT INTO `orders_status` VALUES(1, 5, 'Offen');
INSERT INTO `orders_status` VALUES(2, 5, 'In Bearbeitung');
INSERT INTO `orders_status` VALUES(3, 5, 'Versendet');
INSERT INTO `orders_status` VALUES(4, 5, 'Afterbuy Import');
INSERT INTO `orders_status` VALUES(5, 5, 'Bezahlt - download freigeben');

# --------------------------------------------------------

#
# Table structure for table `orders_status_history`
#

DROP TABLE IF EXISTS `orders_status_history`;
CREATE TABLE `orders_status_history` (
  `orders_status_history_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_status_id` int(5) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `attendee_notified` int(1) default '0',
  `comments` text,
  `new_value` varchar(200) default NULL,
  `old_value` varchar(200) default NULL,
  PRIMARY KEY  (`orders_status_history_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_status_history`
#


# --------------------------------------------------------

#
# Table structure for table `orders_total`
#

DROP TABLE IF EXISTS `orders_total`;
CREATE TABLE `orders_total` (
  `orders_total_id` int(10) unsigned NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `value` decimal(15,4) NOT NULL default '0.0000',
  `class` varchar(32) NOT NULL default '',
  `sort_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`orders_total_id`),
  KEY `idx_orders_total_orders_id` (`orders_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `orders_total`
#


# --------------------------------------------------------

#
# Table structure for table `pages`
#

DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `pages_id` int(11) NOT NULL auto_increment,
  `pages_title` varchar(64) NOT NULL default '',
  `pages_html_text` text,
  `language_id` int(11) NOT NULL default '2',
  `sort_order` int(3) default NULL,
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`pages_id`,`language_id`)
)  AUTO_INCREMENT=11 ;

#
# Datas for the table `pages`
#

INSERT INTO `pages` VALUES(1, 'INFO', '<FONT face=Arial>\r\n<P><STRONG>Herzlich Willkommen beim </STRONG><A href="/"><STRONG>Bigware</STRONG></A><STRONG>&nbsp;Shop System </STRONG></P>\r\n<P><FONT face="Arial, Helvetica, sans-serif"><FONT face=Verdana>Bei unserem Shopsystem <FONT color=#6e6e6e><EM><STRONG>Bigware-Shop</STRONG></EM> </FONT>handelt es sich um eine ausgereifte Entwicklung von Bigware und zugleich um eine sehr m&auml;chtige e-commerce Software. Kein Shopsystem von der Stange! Mit zahlreichen Entwicklungen hat <EM>Bigware</EM>&nbsp; ein Shopsystem geschaffen, das Vergleiche zu Shopsystemen, die um ein vielfaches teurer sind, nicht scheuen braucht.&nbsp;Zus&auml;tzlich kommt in dieser Version des Shopsystems hinzu, dass es vollst&auml;ndig&nbsp;von&nbsp;seiner Softwareschmiede produziert wurde. </FONT></FONT></P>\r\n<P>Sie k&ouml;nnen diesen Text in der Administration bequem &auml;ndern!</FONT></P>', 5, 1, 1);
INSERT INTO `pages` VALUES(2, '&Uuml;BER UNS', '<P><FONT face="Arial, Helvetica, sans-serif">Die Bigware LTD&nbsp;hat sich zum Ziel gesetzt, Top&nbsp;Software zu g&uuml;nstigen Preisen anzubieten. Hohe Qualit&auml;t der Produkte versteht sich von selbst, so wie die einfache Abwicklung des Einkaufens auf unserer Startseite&nbsp;<A title=bigware.de href="/">bigware.de</A> . </FONT></P>\r\n<P></P>', 5, 1, 1);
INSERT INTO `pages` VALUES(5, 'IHRE VORTEILE', '<P><FONT style="FONT-SIZE: 8pt" face=Verdana><SPAN class=normal><B>Sie sparen Geld</B>. <BR>Unsere angebotenen&nbsp;Software&nbsp;ist im Durchschnitt billiger als bei anderen Firmen. Vergleichen Sie bitte!<BR><BR><B>Sie sparen Zeit</B>. <BR>Sie k&ouml;nnen 24h am Tag in Ruhe und bequem unsere Software ordern und sich entspannt zur&uuml;cklehnen. <BR><B><BR>Sie haben eine riesige Auswahl</B>.<BR>Nach und nach werden Sie bei Bigware.de immer mehr Software finden, die Ihnen qualitativ hochwertige E-Commerce erm&ouml;glicht um sich richtig pr&auml;sentieren zu k&ouml;nnen. <BR><BR><B>Sie k&ouml;nnen sich auf unseren Service verlassen.</B> <BR>Wir werden alles unternehmen, damit Sie Ihre Software innerhalb k&uuml;rzester Zeit erhalten und mit unserem Angebot zufrieden sind. <BR><BR><B>Sie werden informiert.</B> <BR>Wenn Sie sich f&uuml;r unseren Newsletter eintragen, halten wir Sie immer auf dem Laufenden &uuml;ber die neuesten Trends und aktuellen Angebote.</SPAN></FONT></P>\r\n<P></P>', 5, 1, 1);
INSERT INTO `pages` VALUES(6, 'IMPRESSUM', '<P></P>\r\n<P>Company</P>\r\n<P>Vorname Nachname</P>\r\n<P>Stra&szlig;e 100</P>\r\n<P>12345 Stadt</P>', 5, 1, 1);
INSERT INTO `pages` VALUES(9, 'ZUM ERSTEN MAL HIER?', '<P><SPAN class=normal><FONT face="Arial, Helvetica, sans-serif"><FONT size=2><B>Zum ersten Mal bei Bigware? - So geht es</B> <BR>Dringend ben&ouml;tigte Software&nbsp;einzukaufen ist jetzt ganz einfach.&nbsp;Auf unseren&nbsp;Seiten&nbsp;<A title=bigware.de href="/" target=_blank>bigware.de</A> gelangen Sie &uuml;ber verschiedene Wege zu einem Produkt. M&ouml;chten Sie einen Artikel kaufen, bestellen Sie diesen einfach &uuml;ber unsere Bestellseiten, und Sie erhalten unverz&uuml;glich Ihre&nbsp;Software per E-Mail zugesandt. </FONT></FONT></SPAN></P>\r\n<P><SPAN class=normal><FONT face="Arial, Helvetica, sans-serif"><FONT size=2>Vielen Dank f&uuml;r Ihr Interesse</FONT></FONT></SPAN></P>\r\n<P><SPAN class=normal><FONT face="Arial, Helvetica, sans-serif"><FONT size=2>Ihr Bigware Team</FONT></P></FONT></SPAN>', 5, 1, 1);
INSERT INTO `pages` VALUES(10, 'FAQ', '<P><FONT style="FONT-SIZE: 8pt; TEXT-DECORATION: underline" face="Arial, Helvetica, sans-serif"><SPAN class=normal><B>H&auml;ufig gestellte Fragen (FAQ)</B></SPAN></FONT></P>\r\n<P><FONT style="FONT-SIZE: 8pt" face=Verdana><FONT face="Arial, Helvetica, sans-serif"></FONT></P></FONT>', 5, 1, 1);

# --------------------------------------------------------

#
# Table structure for table `payment_words`
#

DROP TABLE IF EXISTS `payment_words`;
CREATE TABLE `payment_words` (
  `id` int(3) NOT NULL auto_increment,
  `words` varchar(32) NOT NULL default '',
  `standart` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `payment_words`
#


# --------------------------------------------------------

#
# Table structure for table `phesis_comments`
#

DROP TABLE IF EXISTS `phesis_comments`;
CREATE TABLE `phesis_comments` (
  `commentid` int(11) NOT NULL auto_increment,
  `pollid` int(11) default '0',
  `attendee_id` int(11) NOT NULL default '0',
  `date` datetime default NULL,
  `name` varchar(60) NOT NULL default '',
  `host_name` varchar(60) default NULL,
  `comment` text NOT NULL,
  `language_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`commentid`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `phesis_comments`
#


# --------------------------------------------------------

#
# Table structure for table `phesis_poll_check`
#

DROP TABLE IF EXISTS `phesis_poll_check`;
CREATE TABLE `phesis_poll_check` (
  `ip` varchar(20) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  `pollID` int(10) NOT NULL default '0'
) ;

#
# Datas for the table `phesis_poll_check`
#


# --------------------------------------------------------

#
# Table structure for table `phesis_poll_config`
#

DROP TABLE IF EXISTS `phesis_poll_config`;
CREATE TABLE `phesis_poll_config` (
  `set_it_up_id` int(5) NOT NULL auto_increment,
  `set_it_up_title` varchar(64) NOT NULL default '',
  `set_it_up_key` varchar(64) NOT NULL default '',
  `set_it_up_value` varchar(255) NOT NULL default '',
  `set_it_up_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`set_it_up_id`)
) AUTO_INCREMENT=7 ;

#
# Datas for the table `phesis_poll_config`
#

INSERT INTO `phesis_poll_config` VALUES(1, 'Umfrage anzeigen', 'SHOW_POLL_HOW', '2', 'Entscheiden Sie wie die Umfragen in der Box gezeigt werden<br>0 = Zufall<br>1 = Letzte<br>2 = Popul&auml;rste<br>3 = bestimmte Umfrage ID', '2001-12-08 18:22:30', '2001-12-07 16:56:23');
INSERT INTO `phesis_poll_config` VALUES(2, 'Umfrage Id', 'SHOW_POLL_ID', '', 'Falls Sie in der Box eine bestimmte Umfrage ID anzeigen m&ouml;chten (siehe Punkt 1), w&auml;hlen Sie diese hier aus', '2005-05-17 16:27:24', '2001-12-07 16:56:23');
INSERT INTO `phesis_poll_config` VALUES(3, 'Kommentare erlauben', 'SHOW_POLL_COMMENTS', '1', 'Kommentare anzeigen oder nicht.<br>0 = Nicht anzeigen<br>1 = anzeigen', '2003-04-06 16:19:43', '2001-12-07 16:58:09');
INSERT INTO `phesis_poll_config` VALUES(4, 'Box anzeigen', 'SHOW_NOPOLL', '1', '<br>0 = zeige die Seitenframe nicht<br>1 = Zeige die Box', '2005-06-01 06:44:37', '2001-12-07 19:36:33');
INSERT INTO `phesis_poll_config` VALUES(5, 'Erlaube mehrfach Abstimmungen', 'POLL_SPAM', '0', 'Benutzer erlauben mehrere Abstimmungen zu t&auml;tigen.<br>0 = Nein (empfohlen)<br>1 = Ja (gut f&uuml;r Test)', '2001-12-07 20:20:26', '2001-12-07 20:20:26');
INSERT INTO `phesis_poll_config` VALUES(6, 'Anzahl Kommentare', 'MAX_SHOW_NEW_COMMENTS', '10', 'Maximale Anzeige der Komentare', '2001-12-07 20:20:26', '2001-12-07 20:20:26');

# --------------------------------------------------------

#
# Table structure for table `phesis_poll_data`
#

DROP TABLE IF EXISTS `phesis_poll_data`;
CREATE TABLE `phesis_poll_data` (
  `pollID` int(11) NOT NULL default '0',
  `optionText` varchar(255) NOT NULL default '',
  `optionCount` int(11) NOT NULL default '0',
  `voteID` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1'
) ;

#
# Datas for the table `phesis_poll_data`
#

INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 8, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 7, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 6, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 5, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 4, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 3, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 2, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 1, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 0, 3);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 8, 5);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 7, 5);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 6, 5);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 5, 5);
INSERT INTO `phesis_poll_data` VALUES(2, '', 0, 4, 5);
INSERT INTO `phesis_poll_data` VALUES(2, 'Geht so!', 0, 3, 5);
INSERT INTO `phesis_poll_data` VALUES(2, 'Ja, gut!', 0, 2, 5);
INSERT INTO `phesis_poll_data` VALUES(2, 'Ja, sehr gut!', 1, 1, 5);
INSERT INTO `phesis_poll_data` VALUES(2, 'Gef&auml;llt Ihnen unser Shop', 0, 0, 5);

# --------------------------------------------------------

#
# Table structure for table `phesis_poll_desc`
#

DROP TABLE IF EXISTS `phesis_poll_desc`;
CREATE TABLE `phesis_poll_desc` (
  `pollID` int(11) NOT NULL auto_increment,
  `timeStamp` datetime default NULL,
  `voters` mediumint(9) NOT NULL default '0',
  `poll_type` char(1) NOT NULL default '0',
  `poll_open` char(1) NOT NULL default '0',
  `catID` int(11) NOT NULL default '0',
  `prodID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pollID`)
) AUTO_INCREMENT=3 ;

#
# Datas for the table `phesis_poll_desc`
#

INSERT INTO `phesis_poll_desc` VALUES(2, '2006-10-10 17:13:50', 1, '0', '0', 0, 0);

# --------------------------------------------------------

#
# Table structure for table `preisportale`
#

DROP TABLE IF EXISTS `preisportale`;
CREATE TABLE `preisportale` (
  `id` varchar(10) NOT NULL default '1',
  `link_preissuchmaschine` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_preisroboter` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_geizhals` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_kelkoo` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `link_preisauskunft` varchar(200) default 'http://www.meinshop.de/catalog/preisportale/',
  `aktiv_preissuchmaschine` varchar(200) default 'checked',
  `aktiv_preisroboter` varchar(200) default 'checked',
  `preisroboter_status` varchar(200) NOT NULL default 'true',
  `preisroboter_lieferzeit_nicht_da` varchar(200) NOT NULL default '10',
  `preisroboter_normale_lieferzeit` varchar(200) NOT NULL default '4',
  `preisroboter_status_lieferzeit` varchar(200) NOT NULL default '4',
  `preisroboter_versandkostenfrei` varchar(200) NOT NULL default '999999999',
  `aktiv_geizhals` varchar(200) default 'checked',
  `aktiv_kelkoo` varchar(200) default 'checked',
  `aktiv_preisauskunft` varchar(200) default 'checked',
  `inhalt_htaccess_generieren` varchar(10) NOT NULL default 'ja',
  `google_feedname` varchar(128) default NULL,
  `google_ftp_enable` int(2) default NULL,
  `google_ftp_host` varchar(128) default NULL,
  `google_ft_username` varchar(128) default NULL,
  `google_ftp_password` varchar(128) default NULL,
  `google_currency_type` varchar(128) default NULL,
  `google_default_language` varchar(128) default NULL,
  `google_destination_file` varchar(256) default NULL
) ;

#
# Datas for the table `preisportale`
#

INSERT INTO `preisportale` (`id`, `link_preissuchmaschine`, `link_preisroboter`, `link_geizhals`, `link_kelkoo`, `link_preisauskunft`, `aktiv_preissuchmaschine`, `aktiv_preisroboter`, `preisroboter_status`, `preisroboter_lieferzeit_nicht_da`, `preisroboter_normale_lieferzeit`, `preisroboter_status_lieferzeit`, `preisroboter_versandkostenfrei`, `aktiv_geizhals`, `aktiv_kelkoo`, `aktiv_preisauskunft`, `inhalt_htaccess_generieren`, `google_feedname`, `google_ftp_enable`, `google_ftp_host`, `google_ft_username`, `google_ftp_password`, `google_currency_type`, `google_default_language`, `google_destination_file`) VALUES
('1', 'http://www.IhreDomainZumShop.de/portalpreise.php?action=preisroboter', 'http://www.IhreDomainZumShop.de/portalpreise.php?action=preissuchmaschine', 'http://www.IhreDomainZumShop.de/portalpreise.php?action=geizhals', 'http://www.IhreDomainZumShop.de/portalpreise.php?action=kelkoo', '', 'checked', 'checked', 'true', '10', '4', '4', '999999999', 'checked', 'checked', '', 'ja', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

# --------------------------------------------------------

#
# Table structure for table `price_option`
#

DROP TABLE IF EXISTS `price_option`;
CREATE TABLE `price_option` (
  `id` int(11) NOT NULL auto_increment,
  `text` varchar(10) NOT NULL default '',
  `immeter` int(10) NOT NULL default '0',
  `inmeter_breite` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `text` (`text`)
) AUTO_INCREMENT=5 ;

#
# Datas for the table `price_option`
#

INSERT INTO `price_option` VALUES(1, 'qm', 1000, 1000);
INSERT INTO `price_option` VALUES(2, 'qmm', 1, 1);
INSERT INTO `price_option` VALUES(3, 'lfdm', 1000, 1000);
INSERT INTO `price_option` VALUES(4, 'U lfdm', 1000, 1000);

# --------------------------------------------------------

#
# Table structure for table `producers`
#

DROP TABLE IF EXISTS `producers`;
CREATE TABLE `producers` (
  `producers_id` int(11) NOT NULL auto_increment,
  `producers_name` varchar(32) NOT NULL default '',
  `producers_picture` varchar(64) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`producers_id`),
  KEY `IDX_PRODUCERS_NAME` (`producers_name`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `producers`
#


# --------------------------------------------------------

#
# Table structure for table `producers_info`
#

DROP TABLE IF EXISTS `producers_info`;
CREATE TABLE `producers_info` (
  `producers_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `producers_url` varchar(255) NOT NULL default '',
  `url_clicked` int(5) NOT NULL default '0',
  `date_last_click` datetime default NULL,
  PRIMARY KEY  (`producers_id`,`languages_id`)
) ;

#
# Datas for the table `producers_info`
#


# --------------------------------------------------------

#
# Table structure for table `rahmen`
#

DROP TABLE IF EXISTS `rahmen`;
CREATE TABLE `rahmen` (
  `id` varchar(10) NOT NULL default '1',
  `rahmennummer` varchar(10) NOT NULL default '2',
  `descr` varchar(200) default NULL
) ;

#
# Datas for the table `rahmen`
#

INSERT INTO `rahmen` VALUES('1', '1', 'Runder Rahmen');

# --------------------------------------------------------

#
# Table structure for table `reviews`
#

DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
  `reviews_id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `attendees_id` int(11) default NULL,
  `attendees_name` varchar(64) NOT NULL default '',
  `reviews_rating` int(1) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `reviews_read` int(5) NOT NULL default '0',
  PRIMARY KEY  (`reviews_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `reviews`
#


# --------------------------------------------------------

#
# Table structure for table `reviews_description`
#

DROP TABLE IF EXISTS `reviews_description`;
CREATE TABLE `reviews_description` (
  `reviews_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `reviews_text` text NOT NULL,
  PRIMARY KEY  (`reviews_id`,`languages_id`)
) ;

#
# Datas for the table `reviews_description`
#


# --------------------------------------------------------

#
# Table structure for table `searchselect`
#

DROP TABLE IF EXISTS `searchselect`;
CREATE TABLE `searchselect` (
  `searchselect_id` int(11) NOT NULL auto_increment,
  `searchtext` varchar(100) NOT NULL default '0',
  `selectbox` int(4) NOT NULL default '0',
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`searchselect_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `searchselect`
#


# --------------------------------------------------------

#
# Table structure for table `searchselectbox`
#

DROP TABLE IF EXISTS `searchselectbox`;
CREATE TABLE `searchselectbox` (
  `searchselectbox_id` int(11) NOT NULL auto_increment,
  `selectboxtext` varchar(100) NOT NULL default '0',
  `language_id` INT(2) NOT NULL DEFAULT '0' , 
  `position_id` INT(2) NOT NULL DEFAULT '0' , 
  `optionText` TEXT NOT NULL ,
  PRIMARY KEY  (`searchselectbox_id`)
) AUTO_INCREMENT=1 ;

#
# Datas for the table `searchselectbox`
#


# --------------------------------------------------------

# 
# Table structure for table `sessions`
# 

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `sesskey` varchar(64) NOT NULL default '',
  `expiry` int(11) unsigned NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (`sesskey`)
) ;

# 
#  Datas for the table `sessions`
# 


# --------------------------------------------------------

# 
#  Table structure for table `set_it_up`
# 

DROP TABLE IF EXISTS `set_it_up`;
CREATE TABLE `set_it_up` (
  `set_it_up_id` int(11) NOT NULL auto_increment,
  `set_it_up_title` varchar(64) NOT NULL default '',
  `set_it_up_key` varchar(64) NOT NULL default '',
  `set_it_up_value` varchar(255) NOT NULL default '',
  `set_it_up_description` text NOT NULL,
  `set_it_up_group_id` int(11) NOT NULL default '0',
  `sort_order` int(5) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `use_function` varchar(255) default NULL,
  `set_function` varchar(255) default NULL,
  PRIMARY KEY  (`set_it_up_id`)
) AUTO_INCREMENT=1230;

# 
#  Datas for the table `set_it_up`
#

INSERT INTO `set_it_up` (`set_it_up_id`, `set_it_up_title`, `set_it_up_key`, `set_it_up_value`, `set_it_up_description`, `set_it_up_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
(1, 'SHOP_NAME_TITEL', 'SHOP_NAME', 'Ihr ShopName', 'SHOP_NAME_DESCRIPTION', 1, 1, '2006-04-10 06:10:05', '2004-03-17 00:34:34', NULL, NULL),
(2, 'SHOP_OWNER_TITEL', 'SHOP_OWNER', 'Ihr Namen', 'SHOP_OWNER_DESCRIPTION', 1, 2, '2006-04-10 06:18:38', '2004-03-17 00:34:34', NULL, NULL),
(3, 'SHOP_OWNER_EMAIL_ADDRESS_TITEL', 'SHOP_OWNER_EMAIL_ADDRESS', 'Ihre@email.de', 'SHOP_OWNER_EMAIL_ADDRESS_DESCRIPTION', 1, 4, '2010-08-28 14:16:47', '2004-03-17 00:34:34', NULL, NULL),
(4, 'EMAIL_FROM_TITEL', 'EMAIL_FROM', 'Firmennamen <Ihre@email.de>', 'EMAIL_FROM_DESCRIPTION', 1, 5, '2006-04-10 06:18:05', '2004-03-17 00:34:34', NULL, NULL),
(5, 'SHOP_LAND_TITEL', 'SHOP_LAND', '81', 'SHOP_LAND_DESCRIPTION', 1, 6, '2004-03-17 14:26:26', '2004-03-17 00:34:34', 'go_get_land_name', 'go_cfg_pull_down_land_list('),
(6, 'SHOP_ZONE_TITEL', 'SHOP_ZONE', '85', 'SHOP_ZONE_DESCRIPTION', 1, 7, '2011-08-21 20:33:21', '2004-03-17 00:34:34', 'go_cfg_get_zone_name', 'go_cfg_pull_down_zone_list('),
(7, 'EXPECTED_ITEMS_SORT_TITEL', 'EXPECTED_ITEMS_SORT', 'desc', 'EXPECTED_ITEMS_SORT_DESCRIPTION', 1, 15, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''asc'', ''desc''),'),
(8, 'EXPECTED_ITEMS_FIELD_TITEL', 'EXPECTED_ITEMS_FIELD', 'date_expected', 'EXPECTED_ITEMS_FIELD_DESCRIPTION', 1, 16, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''items_name'', ''date_expected''),'),
(9, 'USE_DEFAULT_LANGUAGE_CURRENCY_TITEL', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'USE_DEFAULT_LANGUAGE_CURRENCY_DESCRIPTION', 1, 9, '2006-01-31 13:15:46', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(10, 'SEND_EXTRA_ORDER_EMAILS_TO_TITEL', 'SEND_EXTRA_ORDER_EMAILS_TO', 'Ihre@email.de', 'SEND_EXTRA_ORDER_EMAILS_TO_DESCRIPTION', 1, 27, '2006-01-04 19:59:20', '2004-03-17 00:34:34', NULL, NULL),
(12, 'SHOW_CART_TITEL', 'SHOW_CART', 'true', 'SHOW_CART_DESCRIPTION', 1, 23, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(13, 'ALLOW_GUEST_TO_TELL_A_FRIEND_TITEL', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'true', 'ALLOW_GUEST_TO_TELL_A_FRIEND_DESCRIPTION', 1, 30, '2004-04-10 19:21:06', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(14, 'ADVANCED_SEARCH_DEFAULT_OPERATOR_TITEL', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'ADVANCED_SEARCH_DEFAULT_OPERATOR_DESCRIPTION', 1, 32, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''and'', ''or''),'),
(15, 'SHOP_NAME_ADDRESS_TITEL', 'SHOP_NAME_ADDRESS', 'Company\r\nStrasse 100\r\n12345 Stadt\r\n040 1234567', 'SHOP_NAME_ADDRESS_DESCRIPTION', 1, 3, '2004-08-12 09:08:52', '2004-03-17 00:34:34', NULL, 'go_cfg_textarea('),
(16, 'SHOW_COUNTS_TITEL', 'SHOW_COUNTS', 'false', 'SHOW_COUNTS_DESCRIPTION', 1, 17, '2005-01-29 18:46:46', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(17, 'TAX_DECIMAL_PLACES_TITEL', 'TAX_DECIMAL_PLACES', '2', 'TAX_DECIMAL_PLACES_DESCRIPTION', 1, 11, '2004-04-10 19:25:31', '2004-03-17 00:34:34', NULL, NULL),
(18, 'SHOW_PRICE_WITH_TAX_TITEL', 'SHOW_PRICE_WITH_TAX', 'true', 'SHOW_PRICE_WITH_TAX_DESCRIPTION', 1, 12, '2006-02-06 19:32:36', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(19, 'TYPE_IN_FIRST_NAME_MIN_LENGTH_TITEL', 'TYPE_IN_FIRST_NAME_MIN_LENGTH', '2', 'TYPE_IN_FIRST_NAME_MIN_LENGTH_DESCRIPTION', 2, 1, NULL, '2004-03-17 00:34:34', NULL, NULL),
(20, 'TYPE_IN_LAST_NAME_MIN_LENGTH_TITEL', 'TYPE_IN_LAST_NAME_MIN_LENGTH', '2', 'TYPE_IN_LAST_NAME_MIN_LENGTH_DESCRIPTION', 2, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(21, 'TYPE_IN_DOB_MIN_LENGTH_TITEL', 'TYPE_IN_DOB_MIN_LENGTH', '10', 'TYPE_IN_DOB_MIN_LENGTH_DESCRIPTION', 2, 3, NULL, '2004-03-17 00:34:34', NULL, NULL),
(22, 'TYPE_IN_EMAIL_ADDRESS_MIN_LENGTH_TITEL', 'TYPE_IN_EMAIL_ADDRESS_MIN_LENGTH', '6', 'TYPE_IN_EMAIL_ADDRESS_MIN_LENGTH_DESCRIPTION', 2, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(23, 'TYPE_IN_STREET_ADDRESS_MIN_LENGTH_TITEL', 'TYPE_IN_STREET_ADDRESS_MIN_LENGTH', '5', 'TYPE_IN_STREET_ADDRESS_MIN_LENGTH_DESCRIPTION', 2, 5, NULL, '2004-03-17 00:34:34', NULL, NULL),
(24, 'TYPE_IN_COMPANY_MIN_LENGTH_TITEL', 'TYPE_IN_COMPANY_MIN_LENGTH', '2', 'TYPE_IN_COMPANY_MIN_LENGTH_DESCRIPTION', 2, 6, NULL, '2004-03-17 00:34:34', NULL, NULL),
(25, 'TYPE_IN_POSTCODE_MIN_LENGTH_TITEL', 'TYPE_IN_POSTCODE_MIN_LENGTH', '4', 'TYPE_IN_POSTCODE_MIN_LENGTH_DESCRIPTION', 2, 7, NULL, '2004-03-17 00:34:34', NULL, NULL),
(26, 'TYPE_IN_CITY_MIN_LENGTH_TITEL', 'TYPE_IN_CITY_MIN_LENGTH', '3', 'TYPE_IN_CITY_MIN_LENGTH_DESCRIPTION', 2, 8, NULL, '2004-03-17 00:34:34', NULL, NULL),
(27, 'TYPE_IN_STATE_MIN_LENGTH_TITEL', 'TYPE_IN_STATE_MIN_LENGTH', '2', 'TYPE_IN_STATE_MIN_LENGTH_DESCRIPTION', 2, 9, NULL, '2004-03-17 00:34:34', NULL, NULL),
(28, 'TYPE_IN_TELEPHONE_MIN_LENGTH_TITEL', 'TYPE_IN_TELEPHONE_MIN_LENGTH', '3', 'TYPE_IN_TELEPHONE_MIN_LENGTH_DESCRIPTION', 2, 10, NULL, '2004-03-17 00:34:34', NULL, NULL),
(29, 'TYPE_IN_PASSWORD_MIN_LENGTH_TITEL', 'TYPE_IN_PASSWORD_MIN_LENGTH', '5', 'TYPE_IN_PASSWORD_MIN_LENGTH_DESCRIPTION', 2, 11, NULL, '2004-03-17 00:34:34', NULL, NULL),
(30, 'CC_OWNER_MIN_LENGTH_TITEL', 'CC_OWNER_MIN_LENGTH', '3', 'CC_OWNER_MIN_LENGTH_DESCRIPTION', 2, 12, NULL, '2004-03-17 00:34:34', NULL, NULL),
(31, 'CC_NUMBER_MIN_LENGTH_TITEL', 'CC_NUMBER_MIN_LENGTH', '10', 'CC_NUMBER_MIN_LENGTH_DESCRIPTION', 2, 13, NULL, '2004-03-17 00:34:34', NULL, NULL),
(32, 'REVIEW_TEXT_MIN_LENGTH_TITEL', 'REVIEW_TEXT_MIN_LENGTH', '50', 'REVIEW_TEXT_MIN_LENGTH_DESCRIPTION', 2, 14, NULL, '2004-03-17 00:34:34', NULL, NULL),
(33, 'MIN_SHOW_BESTSELLERS_TITEL', 'MIN_SHOW_BESTSELLERS', '1', 'MIN_SHOW_BESTSELLERS_DESCRIPTION', 2, 15, NULL, '2004-03-17 00:34:34', NULL, NULL),
(34, 'MIN_SHOW_ALSO_PURCHASED_TITEL', 'MIN_SHOW_ALSO_PURCHASED', '1', 'MIN_SHOW_ALSO_PURCHASED_DESCRIPTION', 2, 16, NULL, '2004-03-17 00:34:34', NULL, NULL),
(35, 'MAX_DIRECTORY_TO_ADDRESS_ENTRIES_TITEL', 'MAX_DIRECTORY_TO_ADDRESS_ENTRIES', '5', 'MAX_DIRECTORY_TO_ADDRESS_ENTRIES_DESCRIPTION', 3, 1, NULL, '2004-03-17 00:34:34', NULL, NULL),
(36, 'MAX_SHOW_SEARCH_RESULTS_TITEL', 'MAX_SHOW_SEARCH_RESULTS', '20', 'MAX_SHOW_SEARCH_RESULTS_DESCRIPTION', 3, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(37, 'MAX_SHOW_PAGE_LINKS_TITEL', 'MAX_SHOW_PAGE_LINKS', '5', 'MAX_SHOW_PAGE_LINKS_DESCRIPTION', 3, 3, NULL, '2004-03-17 00:34:34', NULL, NULL),
(38, 'MAX_SHOW_SPECIAL_ITEMS_TITEL', 'MAX_SHOW_SPECIAL_ITEMS', '9', 'MAX_SHOW_SPECIAL_ITEMS_DESCRIPTION', 3, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(39, 'MAX_SHOW_NEW_ITEMS_TITEL', 'MAX_SHOW_NEW_ITEMS', '9', 'MAX_SHOW_NEW_ITEMS_DESCRIPTION', 3, 5, NULL, '2004-03-17 00:34:34', NULL, NULL),
(40, 'MAX_SHOW_UPCOMING_ITEMS_TITEL', 'MAX_SHOW_UPCOMING_ITEMS', '10', 'MAX_SHOW_UPCOMING_ITEMS_DESCRIPTION', 3, 6, NULL, '2004-03-17 00:34:34', NULL, NULL),
(41, 'MAX_SHOW_PRODUCERS_IN_A_LIST_TITEL', 'MAX_SHOW_PRODUCERS_IN_A_LIST', '0', 'MAX_SHOW_PRODUCERS_IN_A_LIST_DESCRIPTION', 3, 7, NULL, '2004-03-17 00:34:34', NULL, NULL),
(42, 'MAX_PRODUCERS_LIST_TITEL', 'MAX_PRODUCERS_LIST', '1', 'MAX_PRODUCERS_LIST_DESCRIPTION', 3, 7, NULL, '2004-03-17 00:34:34', NULL, NULL),
(43, 'MAX_SHOW_PRODUCER_NAME_LEN_TITEL', 'MAX_SHOW_PRODUCER_NAME_LEN', '15', 'MAX_SHOW_PRODUCER_NAME_LEN_DESCRIPTION', 3, 8, NULL, '2004-03-17 00:34:34', NULL, NULL),
(44, 'MAX_SHOW_NEW_REVIEWS_TITEL', 'MAX_SHOW_NEW_REVIEWS', '6', 'MAX_SHOW_NEW_REVIEWS_DESCRIPTION', 3, 9, NULL, '2004-03-17 00:34:34', NULL, NULL),
(45, 'MAX_RANDOM_SELECT_REVIEWS_TITEL', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'MAX_RANDOM_SELECT_REVIEWS_DESCRIPTION', 3, 10, NULL, '2004-03-17 00:34:34', NULL, NULL),
(46, 'MAX_RANDOM_SELECT_NEW_TITEL', 'MAX_RANDOM_SELECT_NEW', '10', 'MAX_RANDOM_SELECT_NEW_DESCRIPTION', 3, 11, NULL, '2004-03-17 00:34:34', NULL, NULL),
(47, 'MAX_RANDOM_SELECT_SPECIALS_TITEL', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'MAX_RANDOM_SELECT_SPECIALS_DESCRIPTION', 3, 12, NULL, '2004-03-17 00:34:34', NULL, NULL),
(48, 'MAX_SHOW_CATEGORIES_PER_ROW_TITEL', 'MAX_SHOW_CATEGORIES_PER_ROW', '3', 'MAX_SHOW_CATEGORIES_PER_ROW_DESCRIPTION', 3, 13, NULL, '2004-03-17 00:34:34', NULL, NULL),
(49, 'MAX_SHOW_ITEMS_NEW_TITEL', 'MAX_SHOW_ITEMS_NEW', '10', 'MAX_SHOW_ITEMS_NEW_DESCRIPTION', 3, 14, NULL, '2004-03-17 00:34:34', NULL, NULL),
(50, 'MAX_SHOW_BESTSELLERS_TITEL', 'MAX_SHOW_BESTSELLERS', '10', 'MAX_SHOW_BESTSELLERS_DESCRIPTION', 3, 15, NULL, '2004-03-17 00:34:34', NULL, NULL),
(51, 'MAX_SHOW_ALSO_PURCHASED_TITEL', 'MAX_SHOW_ALSO_PURCHASED', '6', 'MAX_SHOW_ALSO_PURCHASED_DESCRIPTION', 3, 16, NULL, '2004-03-17 00:34:34', NULL, NULL),
(52, 'MAX_SHOW_ITEMS_IN_ORDER_HISTORY_FRAME_TITEL', 'MAX_SHOW_ITEMS_IN_ORDER_HISTORY_FRAME', '6', 'MAX_SHOW_ITEMS_IN_ORDER_HISTORY_FRAME_DESCRIPTION', 3, 17, NULL, '2004-03-17 00:34:34', NULL, NULL),
(53, 'MAX_SHOW_ORDER_HISTORY_TITEL', 'MAX_SHOW_ORDER_HISTORY', '10', 'MAX_SHOW_ORDER_HISTORY_DESCRIPTION', 3, 18, NULL, '2004-03-17 00:34:34', NULL, NULL),
(54, 'SMALL_PICTURE_WIDTH_TITEL', 'SMALL_PICTURE_WIDTH', '100', 'SMALL_PICTURE_WIDTH_DESCRIPTION', 4, 1, '2009-06-01 06:32:37', '2004-03-17 00:34:34', NULL, NULL),
(55, 'SMALL_PICTURE_HEIGHT_TITEL', 'SMALL_PICTURE_HEIGHT', '', 'SMALL_PICTURE_HEIGHT_DESCRIPTION', 4, 2, '2004-07-10 17:16:01', '2004-03-17 00:34:34', NULL, NULL),
(56, 'ABOVE_PICTURE_WIDTH_TITEL', 'ABOVE_PICTURE_WIDTH', '60', 'ABOVE_PICTURE_WIDTH_DESCRIPTION', 4, 3, '2004-04-10 19:27:48', '2004-03-17 00:34:34', NULL, NULL),
(57, 'ABOVE_PICTURE_HEIGHT_TITEL', 'ABOVE_PICTURE_HEIGHT', '', 'ABOVE_PICTURE_HEIGHT_DESCRIPTION', 4, 4, '2004-04-10 19:27:59', '2004-03-17 00:34:34', NULL, NULL),
(58, 'SUBCATEGORY_PICTURE_WIDTH_TITEL', 'SUBCATEGORY_PICTURE_WIDTH', '100', 'SUBCATEGORY_PICTURE_WIDTH_DESCRIPTION', 4, 5, NULL, '2004-03-17 00:34:34', NULL, NULL),
(59, 'SUBCATEGORY_PICTURE_HEIGHT_TITEL', 'SUBCATEGORY_PICTURE_HEIGHT', '', 'SUBCATEGORY_PICTURE_HEIGHT_DESCRIPTION', 4, 6, '2004-04-10 19:28:23', '2004-03-17 00:34:34', NULL, NULL),
(60, 'CONFIG_CALCULATE_PICTURE_SIZE_TITEL', 'CONFIG_CALCULATE_PICTURE_SIZE', 'true', 'CONFIG_CALCULATE_PICTURE_SIZE_DESCRIPTION', 4, 7, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(61, 'PICTURE_REQUIRED_TITEL', 'PICTURE_REQUIRED', 'false', 'PICTURE_REQUIRED_DESCRIPTION', 4, 8, '2004-04-10 19:28:47', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(62, 'MEMBER_GENDER_TITEL', 'MEMBER_GENDER', 'false', 'MEMBER_GENDER_DESCRIPTION', 5, 1, '2006-01-30 07:50:30', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(63, 'MEMBER_DOB_TITEL', 'MEMBER_DOB', 'true', 'MEMBER_DOB_DESCRIPTION', 5, 3, '2005-01-11 11:42:59', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(64, 'MEMBER_COMPANY_TITEL', 'MEMBER_COMPANY', 'false', 'MEMBER_COMPANY_DESCRIPTION', 5, 6, '2006-01-30 07:50:43', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(65, 'MEMBER_SUBURB_TITEL', 'MEMBER_SUBURB', 'false', 'MEMBER_SUBURB_DESCRIPTION', 5, 14, '2006-01-30 07:50:51', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(66, 'MEMBER_STATE_TITEL', 'MEMBER_STATE', 'true', 'MEMBER_STATE_DESCRIPTION', 5, 16, '2005-01-11 11:51:40', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(67, 'CONSTITUENT_PAYMENT_INSTALLED_TITEL', 'CONSTITUENT_PAYMENT_INSTALLED', 'moneyorder.php;invoice.php', 'CONSTITUENT_PAYMENT_INSTALLED_DESCRIPTION', 6, 0, '2011-08-21 20:29:58', '2004-03-17 00:34:34', NULL, NULL),
(68, 'CONSTITUENT_ORDER_TOTAL_INSTALLED_TITEL', 'CONSTITUENT_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php', 'CONSTITUENT_ORDER_TOTAL_INSTALLED_DESCRIPTION', 6, 0, '2011-08-21 20:32:16', '2004-03-17 00:34:34', NULL, NULL),
(69, 'CONSTITUENT_SHIPPING_INSTALLED_TITEL', 'CONSTITUENT_SHIPPING_INSTALLED', 'dp.php', 'CONSTITUENT_SHIPPING_INSTALLED_DESCRIPTION', 6, 0, '2006-11-14 10:41:02', '2004-03-17 00:34:34', NULL, NULL),
(84, 'DEFAULT_CURRENCY_TITEL', 'DEFAULT_CURRENCY', 'EUR', 'DEFAULT_CURRENCY_DESCRIPTION', 6, 0, NULL, '2004-03-17 00:34:34', NULL, NULL),
(85, 'DEFAULT_LANGUAGE_TITEL', 'DEFAULT_LANGUAGE', 'de', 'DEFAULT_LANGUAGE_DESCRIPTION', 6, 0, NULL, '2004-03-17 00:34:34', NULL, NULL),
(86, 'DEFAULT_ORDERS_STATUS_ID_TITEL', 'DEFAULT_ORDERS_STATUS_ID', '1', 'DEFAULT_ORDERS_STATUS_ID_DESCRIPTION', 6, 0, NULL, '2004-03-17 00:34:34', NULL, NULL),
(87, 'CONSTITUENT_ORDER_TOTAL_SHIPPING_STATUS_TITEL', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_STATUS_DESCRIPTION', 6, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(88, 'CONSTITUENT_ORDER_TOTAL_SHIPPING_SORT_ORDER_TITEL', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_SORT_ORDER', '4', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_SORT_ORDER_DESCRIPTION', 6, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(89, 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_TITEL', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'true', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_DESCRIPTION', 6, 3, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(90, 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER_TITEL', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '100', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER_DESCRIPTION', 6, 4, NULL, '2004-03-17 00:34:34', 'currencies->format', NULL),
(91, 'CONSTITUENT_ORDER_TOTAL_SHIPPING_DESTINATION_TITEL', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'CONSTITUENT_ORDER_TOTAL_SHIPPING_DESTINATION_DESCRIPTION', 6, 5, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''national'', ''international'', ''both''),'),
(92, 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_STATUS_TITEL', 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_STATUS_DESCRIPTION', 6, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(93, 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_SORT_ORDER_TITEL', 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'CONSTITUENT_ORDER_TOTAL_SUBTOTAL_SORT_ORDER_DESCRIPTION', 6, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(94, 'CONSTITUENT_ORDER_TOTAL_TAX_STATUS_TITEL', 'CONSTITUENT_ORDER_TOTAL_TAX_STATUS', 'true', 'CONSTITUENT_ORDER_TOTAL_TAX_STATUS_DESCRIPTION', 6, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(95, 'CONSTITUENT_ORDER_TOTAL_TAX_SORT_ORDER_TITEL', 'CONSTITUENT_ORDER_TOTAL_TAX_SORT_ORDER', '7', 'CONSTITUENT_ORDER_TOTAL_TAX_SORT_ORDER_DESCRIPTION', 6, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(96, 'CONSTITUENT_ORDER_TOTAL_TOTAL_STATUS_TITEL', 'CONSTITUENT_ORDER_TOTAL_TOTAL_STATUS', 'true', 'CONSTITUENT_ORDER_TOTAL_TOTAL_STATUS_DESCRIPTION', 6, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(97, 'CONSTITUENT_ORDER_TOTAL_TOTAL_SORT_ORDER_TITEL', 'CONSTITUENT_ORDER_TOTAL_TOTAL_SORT_ORDER', '8', 'CONSTITUENT_ORDER_TOTAL_TOTAL_SORT_ORDER_DESCRIPTION', 6, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(98, 'SHIPPING_ORIGIN_LAND_TITEL', 'SHIPPING_ORIGIN_LAND', '81', 'SHIPPING_ORIGIN_LAND_DESCRIPTION', 7, 1, '2004-04-10 19:30:55', '2004-03-17 00:34:34', 'go_get_land_name', 'go_cfg_pull_down_land_list('),
(99, 'SHIPPING_ORIGIN_ZIP_TITEL', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'SHIPPING_ORIGIN_ZIP_DESCRIPTION', 7, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(100, 'SHIPPING_MAX_WEIGHT_TITEL', 'SHIPPING_MAX_WEIGHT', '50', 'SHIPPING_MAX_WEIGHT_DESCRIPTION', 7, 3, '2004-05-07 11:46:48', '2004-03-17 00:34:34', NULL, NULL),
(101, 'SHIPPING_FRAME_WEIGHT_TITEL', 'SHIPPING_FRAME_WEIGHT', '3', 'SHIPPING_FRAME_WEIGHT_DESCRIPTION', 7, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(102, 'SHIPPING_FRAME_PADDING_TITEL', 'SHIPPING_FRAME_PADDING', '10', 'SHIPPING_FRAME_PADDING_DESCRIPTION', 7, 5, NULL, '2004-03-17 00:34:34', NULL, NULL),
(103, 'ITEM_LIST_PICTURE_TITEL', 'ITEM_LIST_PICTURE', '1', 'ITEM_LIST_PICTURE_DESCRIPTION', 8, 1, '2004-09-15 22:34:21', '2004-03-17 00:34:34', NULL, NULL),
(104, 'ITEM_LIST_PRODUCER_TITEL', 'ITEM_LIST_PRODUCER', '0', 'ITEM_LIST_PRODUCER_DESCRIPTION', 8, 2, NULL, '2004-03-17 00:34:34', NULL, NULL),
(105, 'ITEM_LIST_MODEL_TITEL', 'ITEM_LIST_MODEL', '0', 'ITEM_LIST_MODEL_DESCRIPTION', 8, 3, NULL, '2004-03-17 00:34:34', NULL, NULL),
(106, 'ITEM_LIST_NAME_TITEL', 'ITEM_LIST_NAME', '2', 'ITEM_LIST_NAME_DESCRIPTION', 8, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(107, 'ITEM_LIST_PRICE_TITEL', 'ITEM_LIST_PRICE', '4', 'ITEM_LIST_PRICE_DESCRIPTION', 8, 5, '2004-11-07 23:11:25', '2004-03-17 00:34:34', NULL, NULL),
(108, 'ITEM_LIST_QUANTITY_TITEL', 'ITEM_LIST_QUANTITY', '2', 'ITEM_LIST_QUANTITY_DESCRIPTION', 8, 6, '2004-11-07 23:11:08', '2004-03-17 00:34:34', NULL, NULL),
(109, 'ITEM_LIST_WEIGHT_TITEL', 'ITEM_LIST_WEIGHT', '0', 'ITEM_LIST_WEIGHT_DESCRIPTION', 8, 7, NULL, '2004-03-17 00:34:34', NULL, NULL),
(110, 'ITEM_LIST_BUY_NOW_TITEL', 'ITEM_LIST_BUY_NOW', '5', 'ITEM_LIST_BUY_NOW_DESCRIPTION', 8, 8, '2004-11-07 23:11:38', '2004-03-17 00:34:34', NULL, NULL),
(111, 'ITEM_LIST_FILTER_TITEL', 'ITEM_LIST_FILTER', '1', 'ITEM_LIST_FILTER_DESCRIPTION', 8, 9, NULL, '2004-03-17 00:34:34', NULL, NULL),
(112, 'PREV_NEXT_BAR_LOCATION_TITEL', 'PREV_NEXT_BAR_LOCATION', '2', 'PREV_NEXT_BAR_LOCATION_DESCRIPTION', 8, 10, NULL, '2004-03-17 00:34:34', NULL, NULL),
(113, 'STOCK_CHECK_TITEL', 'STOCK_CHECK', 'true', 'STOCK_CHECK_DESCRIPTION', 9, 1, '2004-11-07 03:00:16', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(114, 'STOCK_LIMITED_TITEL', 'STOCK_LIMITED', 'true', 'STOCK_LIMITED_DESCRIPTION', 9, 2, '2006-01-30 07:49:16', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(115, 'STOCK_ALLOW_CHECKOUT_TITEL', 'STOCK_ALLOW_CHECKOUT', 'false', 'STOCK_ALLOW_CHECKOUT_DESCRIPTION', 9, 3, '2006-02-16 22:12:05', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(116, 'STOCK_MARK_ITEM_OUT_OF_STOCK_TITEL', 'STOCK_MARK_ITEM_OUT_OF_STOCK', '***', 'STOCK_MARK_ITEM_OUT_OF_STOCK_DESCRIPTION', 9, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(117, 'STOCK_REORDER_LEVEL_TITEL', 'STOCK_REORDER_LEVEL', '1', 'STOCK_REORDER_LEVEL_DESCRIPTION', 9, 5, '2004-11-07 02:35:10', '2004-03-17 00:34:34', NULL, NULL),
(118, 'SHOP_PAGE_PARSE_TIME_TITEL', 'SHOP_PAGE_PARSE_TIME', 'false', 'SHOP_PAGE_PARSE_TIME_DESCRIPTION', 10, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1203, 'PRICE_PICTURE_TITEL', 'PRICE_PICTURE', 'True', 'PRICE_PICTURE_DESCRIPTION', 1, 14, '2006-04-10 06:10:05', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(120, 'SHOP_PARSE_DATE_TIME_FORMAT_TITEL', 'SHOP_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'SHOP_PARSE_DATE_TIME_FORMAT_DESCRIPTION', 10, 3, NULL, '2004-03-17 00:34:34', NULL, NULL),
(121, 'SHOW_PAGE_PARSE_TIME_TITEL', 'SHOW_PAGE_PARSE_TIME', 'true', 'SHOW_PAGE_PARSE_TIME_DESCRIPTION', 10, 4, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(122, 'SHOP_DB_TRANSACTIONS_TITEL', 'SHOP_DB_TRANSACTIONS', 'false', 'SHOP_DB_TRANSACTIONS_DESCRIPTION', 10, 5, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(125, 'EMAIL_TRANSPORT_TITEL', 'EMAIL_TRANSPORT', 'sendmail', 'EMAIL_TRANSPORT_DESCRIPTION', 12, 1, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''sendmail'', ''smtp''),'),
(126, 'EMAIL_LINEFEED_TITEL', 'EMAIL_LINEFEED', 'LF', 'EMAIL_LINEFEED_DESCRIPTION', 12, 2, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''LF'', ''CRLF''),'),
(127, 'EMAIL_USE_HTML_TITEL', 'EMAIL_USE_HTML', 'true', 'EMAIL_USE_HTML_DESCRIPTION', 12, 3, '2006-09-26 00:48:37', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(128, 'TYPE_IN_EMAIL_ADDRESS_CHECK_TITEL', 'TYPE_IN_EMAIL_ADDRESS_CHECK', 'false', 'TYPE_IN_EMAIL_ADDRESS_CHECK_DESCRIPTION', 12, 4, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(129, 'SEND_EMAILS_TITEL', 'SEND_EMAILS', 'true', 'SEND_EMAILS_DESCRIPTION', 12, 5, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(130, 'DOWNLOAD_ENABLED_TITEL', 'DOWNLOAD_ENABLED', 'false', 'DOWNLOAD_ENABLED_DESCRIPTION', 13, 1, '2004-08-08 16:32:48', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(131, 'DOWNLOAD_BY_REDIRECT_TITEL', 'DOWNLOAD_BY_REDIRECT', 'true', 'DOWNLOAD_BY_REDIRECT_DESCRIPTION', 13, 2, '2004-08-08 16:33:57', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(132, 'DOWNLOAD_MAX_DAYS_TITEL', 'DOWNLOAD_MAX_DAYS', '7', 'DOWNLOAD_MAX_DAYS_DESCRIPTION', 13, 3, NULL, '2004-03-17 00:34:34', NULL, ''),
(133, 'DOWNLOAD_MAX_COUNT_TITEL', 'DOWNLOAD_MAX_COUNT', '5', 'DOWNLOAD_MAX_COUNT_DESCRIPTION', 13, 4, NULL, '2004-03-17 00:34:34', NULL, ''),
(136, 'SESSION_WRITE_DIRECTORY_TITEL', 'SESSION_WRITE_DIRECTORY', 'session', 'SESSION_WRITE_DIRECTORY_DESCRIPTION', 15, 1, '2004-08-12 01:19:34', '2004-03-17 00:34:34', NULL, NULL),
(137, 'SESSION_FORCE_COOKIE_USE_TITEL', 'SESSION_FORCE_COOKIE_USE', 'False', 'SESSION_FORCE_COOKIE_USE_DESCRIPTION', 15, 2, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(138, 'SESSION_CHECK_SSL_SESSION_ID_TITEL', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'SESSION_CHECK_SSL_SESSION_ID_DESCRIPTION', 15, 3, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(139, 'SESSION_CHECK_USER_AGENT_TITEL', 'SESSION_CHECK_USER_AGENT', 'False', 'SESSION_CHECK_USER_AGENT_DESCRIPTION', 15, 4, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(140, 'SESSION_CHECK_IP_ADDRESS_TITEL', 'SESSION_CHECK_IP_ADDRESS', 'False', 'SESSION_CHECK_IP_ADDRESS_DESCRIPTION', 15, 5, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(141, 'SESSION_BLOCK_SPIDERS_TITEL', 'SESSION_BLOCK_SPIDERS', 'False', 'SESSION_BLOCK_SPIDERS_DESCRIPTION', 15, 6, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(142, 'SESSION_RECREATE_TITEL', 'SESSION_RECREATE', 'False', 'SESSION_RECREATE_DESCRIPTION', 15, 7, NULL, '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(151, 'CONSTITUENT_PAYMENT_MONEYORDER_STATUS_TITEL', 'CONSTITUENT_PAYMENT_MONEYORDER_STATUS', 'True', 'CONSTITUENT_PAYMENT_MONEYORDER_STATUS_DESCRIPTION', 6, 1, NULL, '2004-03-17 14:22:03', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(152, 'CONSTITUENT_PAYMENT_MONEYORDER_PAYTO_TITEL', 'CONSTITUENT_PAYMENT_MONEYORDER_PAYTO', '', 'CONSTITUENT_PAYMENT_MONEYORDER_PAYTO_DESCRIPTION', 6, 1, NULL, '2004-03-17 14:22:03', NULL, NULL),
(153, 'CONSTITUENT_PAYMENT_MONEYORDER_SORT_ORDER_TITEL', 'CONSTITUENT_PAYMENT_MONEYORDER_SORT_ORDER', '1', 'CONSTITUENT_PAYMENT_MONEYORDER_SORT_ORDER_DESCRIPTION', 6, 0, NULL, '2004-03-17 14:22:03', NULL, NULL),
(154, 'CONSTITUENT_PAYMENT_MONEYORDER_ZONE_TITEL', 'CONSTITUENT_PAYMENT_MONEYORDER_ZONE', '0', 'CONSTITUENT_PAYMENT_MONEYORDER_ZONE_DESCRIPTION', 6, 2, NULL, '2004-03-17 14:22:03', 'go_get_zone_class_title', 'go_cfg_pull_down_zone_classes('),
(155, 'CONSTITUENT_PAYMENT_MONEYORDER_ORDER_STATUS_ID_TITEL', 'CONSTITUENT_PAYMENT_MONEYORDER_ORDER_STATUS_ID', '0', 'CONSTITUENT_PAYMENT_MONEYORDER_ORDER_STATUS_ID_DESCRIPTION', 6, 0, NULL, '2004-03-17 14:22:03', 'go_get_order_status_name', 'go_cfg_pull_down_order_statuses('),
(170, 'CONSTITUENT_SHIPPING_WEIGHT_MODE_TITEL', 'CONSTITUENT_SHIPPING_WEIGHT_MODE', 'weight', 'CONSTITUENT_SHIPPING_WEIGHT_MODE_DESCRIPTION', 6, 0, NULL, '2004-04-11 22:15:04', NULL, 'go_cfg_select_option(array(''weight'', ''price''),'),
(760, 'REFERRAL_REQUIRED_TITEL', 'REFERRAL_REQUIRED', 'false', 'REFERRAL_REQUIRED_DESCRIPTION', 5, 23, NULL, '2005-05-14 00:24:23', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(648, 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT_TITEL', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT_DESCRIPTION', 1, 35, NULL, '2003-12-05 05:01:41', NULL, NULL),
(646, 'FEATURED_ITEMS_DISPLAY_TITEL', 'FEATURED_ITEMS_DISPLAY', 'true', 'FEATURED_ITEMS_DISPLAY_DESCRIPTION', 33, 1, '2005-02-23 16:38:42', '2005-02-23 16:38:42', NULL, NULL),
(647, 'MAX_SHOW_FEATURED_ITEMS_TITEL', 'MAX_SHOW_FEATURED_ITEMS', '6', 'MAX_SHOW_FEATURED_ITEMS_DESCRIPTION', 33, 2, '2005-02-23 16:38:42', '2005-02-23 16:38:42', NULL, NULL),
(1227, 'MODULE_PAYMENT_INVOICE_ORDER_STATUS_ID_TITEL', 'MODULE_PAYMENT_INVOICE_ORDER_STATUS_ID', '0', 'MODULE_PAYMENT_INVOICE_ORDER_STATUS_ID_DESCRIPTION', 6, 0, NULL, '2011-08-21 20:29:46', 'go_get_order_status_name', 'go_cfg_pull_down_order_statuses('),
(1226, 'MODULE_PAYMENT_INVOICE_SORT_ORDER_TITEL', 'MODULE_PAYMENT_INVOICE_SORT_ORDER', '2', 'MODULE_PAYMENT_INVOICE_SORT_ORDER_DESCRIPTION', 6, 0, NULL, '2011-08-21 20:29:46', '', ''),
(1225, 'MODULE_PAYMENT_INVOICE_ZONE_TITEL', 'MODULE_PAYMENT_INVOICE_ZONE', '0', 'MODULE_PAYMENT_INVOICE_ZONE_DESCRIPTION', 6, 2, NULL, '2011-08-21 20:29:46', 'go_get_zone_class_title', 'go_cfg_pull_down_zone_classes('),
(1224, 'MODULE_PAYMENT_INVOICE_STATUS_TITEL', 'MODULE_PAYMENT_INVOICE_STATUS', 'True', 'MODULE_PAYMENT_INVOICE_STATUS_DESCRIPTION', 6, 0, NULL, '2011-08-21 20:29:46', '', 'go_cfg_select_option(array(''True'', ''False''),'),
(303, 'FOLDER_RELATIV_TEMPLATES_DEFAULT_TITEL', 'FOLDER_RELATIV_TEMPLATES_DEFAULT', 'template_01', 'FOLDER_RELATIV_TEMPLATES_DEFAULT_DESCRIPTION', 1, 33, '2004-07-28 20:23:49', '2004-07-28 16:47:44', NULL, NULL),
(304, 'TEMPLATE_SWITCHING_ALLOWED_TITEL', 'TEMPLATE_SWITCHING_ALLOWED', 'true', 'TEMPLATE_SWITCHING_ALLOWED_DESCRIPTION', 1, 34, NULL, '2004-07-28 16:47:44', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(305, 'DOWNLOAD_AVAILABLE_DATE_TITEL', 'DOWNLOAD_AVAILABLE_DATE', '2', 'DOWNLOAD_AVAILABLE_DATE_DESCRIPTION', 13, 5, NULL, '2003-07-31 04:04:04', NULL, 'go_cfg_select_option(array(''1'', ''2''),'),
(306, 'DOWNLOAD_MIN_STATUS_TITEL', 'DOWNLOAD_MIN_STATUS', '5', 'DOWNLOAD_MIN_STATUS_DESCRIPTION', 13, 6, '2004-08-10 02:48:31', '2003-07-31 04:04:04', NULL, NULL),
(353, 'CHANGE_INVOICE_LOGO_TITEL', 'CHANGE_INVOICE_LOGO', 'shopformer.jpg', 'CHANGE_INVOICE_LOGO_DESCRIPTION', 787, 1, '2006-02-19 18:34:24', '2003-05-18 21:00:00', '', ''),
(354, 'CHANGE_INVOICE_LOGO_ALIGN_TITEL', 'CHANGE_INVOICE_LOGO_ALIGN', 'links', 'CHANGE_INVOICE_LOGO_ALIGN_DESCRIPTION', 787, 2, '2004-08-12 09:17:03', '2003-05-18 21:00:00', '', 'go_cfg_select_option(array(''links'', ''rechts'', ''mitte''),'),
(355, 'CHANGE_INVOICE_SHOW_DATE_TITEL', 'CHANGE_INVOICE_SHOW_DATE', 'nur Datum', 'CHANGE_INVOICE_SHOW_DATE_DESCRIPTION', 787, 20, '2003-06-15 04:49:34', '2003-05-18 21:00:00', '', 'go_cfg_select_option(array(''nur Datum'', ''Datum und Uhrzeit''),'),
(356, 'CHANGE_INFOICE_SHOW_CNR_TITEL', 'CHANGE_INFOICE_SHOW_CNR', 'ja', 'CHANGE_INFOICE_SHOW_CNR_DESCRIPTION', 787, 30, '2003-06-15 04:49:34', '2003-05-18 21:00:00', '', 'go_cfg_select_option(array(''ja'', ''nein''),'),
(357, 'CHANGE_INFOICE_SHOW_ONR_TITEL', 'CHANGE_INFOICE_SHOW_ONR', 'ja', 'CHANGE_INFOICE_SHOW_ONR_DESCRIPTION', 787, 35, '2003-06-15 04:49:34', '2003-05-18 21:00:00', '', 'go_cfg_select_option(array(''ja'', ''nein''),'),
(358, 'CHANGE_INFOICE_SHOW_PAYMENT_TITEL', 'CHANGE_INFOICE_SHOW_PAYMENT', 'ja', 'CHANGE_INFOICE_SHOW_PAYMENT_DESCRIPTION', 787, 40, '2003-06-15 04:49:34', '2003-05-18 21:00:00', '', 'go_cfg_select_option(array(''ja'', ''nein''),'),
(359, 'OWNER_BANK_NAME_TITEL', 'OWNER_BANK_NAME', 'BankName', 'OWNER_BANK_NAME_DESCRIPTION', 911, 1, '2004-10-07 02:52:40', '2004-08-11 16:03:33', NULL, NULL),
(360, 'OWNER_BANK_MEMBER_TITEL', 'OWNER_BANK_MEMBER', 'Vor u. Zuname', 'OWNER_BANK_MEMBER_DESCRIPTION', 911, 2, '2004-08-11 16:03:33', '2004-08-11 16:03:33', NULL, NULL),
(361, 'SHOP_OWNER_BLZ_TITEL', 'SHOP_OWNER_BLZ', '60060060', 'SHOP_OWNER_BLZ_DESCRIPTION', 911, 3, '2004-10-07 02:52:55', '2004-08-11 16:03:33', NULL, NULL),
(362, 'OWNER_BANK_TITEL', 'OWNER_BANK', '123456789', 'OWNER_BANK_DESCRIPTION', 911, 4, '2004-10-07 02:53:15', '2004-08-11 16:03:33', NULL, NULL),
(363, 'OWNER_BANK_IBAN_TITEL', 'OWNER_BANK_IBAN', 'IBAN', 'OWNER_BANK_IBAN_DESCRIPTION', 911, 5, '2004-08-11 16:03:33', '2004-08-11 16:03:33', NULL, NULL),
(364, 'OWNER_BANK_SWIFT_TITEL', 'OWNER_BANK_SWIFT', 'BIC/SWIFT', 'OWNER_BANK_SWIFT_DESCRIPTION', 911, 6, '2004-08-11 16:03:33', '2004-08-11 16:03:33', NULL, NULL),
(365, 'OWNER_BANK_FA_TITEL', 'OWNER_BANK_FA', 'Finanzamt Stadt II', 'OWNER_BANK_FA_DESCRIPTION', 911, 7, '2004-10-07 02:53:35', '2004-08-11 16:03:33', NULL, NULL),
(366, 'OWNER_BANK_TAX_NUMBER_TITEL', 'OWNER_BANK_TAX_NUMBER', 'Steuer_Nr.:111/111/1111', 'OWNER_BANK_TAX_NUMBER_DESCRIPTION', 911, 8, '2004-10-07 02:54:00', '2004-08-11 16:03:33', NULL, NULL),
(367, 'OWNER_BANK_UST_NUMBER_TITEL', 'OWNER_BANK_UST_NUMBER', 'UST-ID-Nr.:DE1111111111', 'OWNER_BANK_UST_NUMBER_DESCRIPTION', 911, 9, '2004-10-07 02:54:25', '2004-08-11 16:03:33', NULL, NULL),
(368, 'SHOW_BANK_DATA_TITEL', 'SHOW_BANK_DATA', 'ja', 'SHOW_BANK_DATA_DESCRIPTION', 911, 10, '2004-08-11 16:03:33', '2004-08-11 16:03:33', NULL, 'go_cfg_select_option(array(''ja'',''nein''),'),
(407, 'CONSTITUENT_SHIPPING_WEIGHT_MODE_TITEL', 'CONSTITUENT_SHIPPING_WEIGHT_MODE', 'weight', 'CONSTITUENT_SHIPPING_WEIGHT_MODE_DESCRIPTION', 6, 0, NULL, '2004-09-24 19:45:52', NULL, 'go_cfg_select_option(array(''weight'', ''price''),'),
(399, 'GUEST_ON_TITEL', 'GUEST_ON', 'true', 'GUEST_ON_DESCRIPTION', 40, 1, '2003-09-09 13:07:44', '2003-09-09 12:10:51', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(436, 'WHOS_ONLINE_LIST_TITEL', 'WHOS_ONLINE_LIST', 'ja', 'WHOS_ONLINE_LIST_DESCRIPTION', 5, 26, '2004-03-17 04:04:04', '2004-03-17 04:04:04', NULL, 'go_cfg_select_option(array(''ja'', ''nein''),'),
(437, 'WHOS_ONLINE_AGO_TITEL', 'WHOS_ONLINE_AGO', '900', 'WHOS_ONLINE_AGO_DESCRIPTION', 5, 27, '2004-03-17 04:04:04', '2004-03-17 04:04:04', NULL, NULL),
(1007, 'URL_Kurzwortfilter_TITEL', 'URL Kurzwortfilter', '3', 'URL_Kurzwortfilter_DESCRIPTION', 1000, 2, '2005-05-27 09:27:21', '2005-05-27 09:27:21', NULL, NULL),
(1008, 'SEO_URLS_CACHE_RESET_TITEL', 'SEO_URLS_CACHE_RESET', 'false', 'SEO_URLS_CACHE_RESET_DESCRIPTION', 1000, 3, '2005-05-27 09:27:21', '2005-05-27 09:27:21', 'go_reset_cache_data_seo_urls', 'go_cfg_select_option(array(''reset'', ''false''),'),
(1005, 'SEO_URLS_TITEL', 'SEO_URLS', 'false', 'SEO_URLS_DESCRIPTION', 1000, 0, '2006-11-14 10:32:13', '2005-05-27 09:27:21', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1006, 'SEO_URLS_TYPE_TITEL', 'SEO_URLS_TYPE', 'cName', 'SEO_URLS_TYPE_DESCRIPTION', 1000, 1, '2006-11-14 10:32:03', '2005-05-27 09:27:21', NULL, 'go_cfg_select_option(array(''cName'', ''Rewrite''),'),
(670, 'NEW_SIGNUP_DISCOUNT_COUPON_TITEL', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'NEW_SIGNUP_DISCOUNT_COUPON_DESCRIPTION', 1, 36, '2005-06-01 05:51:14', '2003-12-05 05:01:41', NULL, NULL),
(714, 'SHOW_REFERRAL_SOURCE_TITEL', 'SHOW_REFERRAL_SOURCE', 'false', 'SHOW_REFERRAL_SOURCE_DESCRIPTION', 1, 31, '2005-06-01 06:06:30', '2005-05-13 11:47:13', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(713, 'SHOW_REFERRAL_OTHER_TITEL', 'SHOW_REFERRAL_OTHER', 'true', 'SHOW_REFERRAL_OTHER_DESCRIPTION', 1, 29, NULL, '2005-05-13 11:47:13', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1009, 'HAENDLER_ERLAUBEN_TITEL', 'HAENDLER_ERLAUBEN', 'false', 'HAENDLER_ERLAUBEN_DESCRIPTION', 72, 5, '2001-11-28 14:25:10', '2001-11-17 11:22:55', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1010, 'KUNDEN_ERLAUBEN_TITEL', 'KUNDEN_ERLAUBEN', 'true', 'KUNDEN_ERLAUBEN_DESCRIPTION', 72, 5, '2001-11-28 14:25:10', '2001-11-17 11:22:55', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1011, 'PRICES_LOGGED_IN_TITEL', 'PRICES_LOGGED_IN', 'false', 'PRICES_LOGGED_IN_DESCRIPTION', 72, 5, '2001-11-28 14:25:10', '2001-11-17 11:22:55', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1012, 'B2B_TITEL', 'B2B', 'false', 'B2B_DESCRIPTION', 72, 1, '2006-01-29 20:17:16', '2003-10-06 17:24:00', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1013, 'MEMBER_TITEL', 'MEMBER', 'false', 'MEMBER_DESCRIPTION', 72, 6, '2006-10-03 07:07:54', '2004-02-26 19:30:00', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1014, 'MEMBER_PIVA_TITEL', 'MEMBER_PIVA', 'false', 'MEMBER_PIVA_DESCRIPTION', 5, 8, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1015, 'MEMBER_PIVA_REQ_TITEL', 'MEMBER_PIVA_REQ', 'false', 'MEMBER_PIVA_REQ_DESCRIPTION', 5, 9, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1016, 'MEMBER_CF_TITEL', 'MEMBER_CF', 'false', 'MEMBER_CF_DESCRIPTION', 5, 11, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1017, 'MEMBER_CF_REQ_TITEL', 'MEMBER_CF_REQ', 'false', 'MEMBER_CF_REQ_DESCRIPTION', 5, 12, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1018, 'TYPE_IN_VAT_CHECK_TITEL', 'TYPE_IN_VAT_CHECK', 'false', 'TYPE_IN_VAT_CHECK_DESCRIPTION', 5, 10, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1034, 'MEMBER_GENDER_REQ_TITEL', 'MEMBER_GENDER_REQ', 'false', 'MEMBER_GENDER_REQ_DESCRIPTION', 5, 2, '2006-01-30 07:49:32', '2005-11-28 00:00:00', NULL, 'go_cfg_select_option(array(\\''true\\'', \\''false\\''),'),
(1035, 'MEMBER_DOB_REQ_TITEL', 'MEMBER_DOB_REQ', 'true', 'MEMBER_DOB_REQ_DESCRIPTION', 5, 4, NULL, '2005-11-28 00:00:00', NULL, 'go_cfg_select_option(array(\\''true\\'', \\''false\\''),'),
(1036, 'MEMBER_COMPANY_REQ_TITEL', 'MEMBER_COMPANY_REQ', 'false', 'MEMBER_COMPANY_REQ_DESCRIPTION', 5, 7, '2006-01-24 07:42:03', '2005-11-28 00:00:00', NULL, 'go_cfg_select_option(array(\\''true\\'', \\''false\\''),'),
(1037, 'MEMBER_SUBURB_REQ_TITEL', 'MEMBER_SUBURB_REQ', 'false', 'MEMBER_SUBURB_REQ_DESCRIPTION', 5, 15, '2006-01-24 07:42:11', '2005-11-28 00:00:00', NULL, 'go_cfg_select_option(array(\\''true\\'', \\''false\\''),'),
(1038, 'MEMBER_STATE_REQ_TITEL', 'MEMBER_STATE_REQ', 'false', 'MEMBER_STATE_REQ_DESCRIPTION', 5, 17, '2006-01-24 07:42:20', '2005-11-28 00:00:00', NULL, 'go_cfg_select_option(array(\\''true\\'', \\''false\\''),'),
(1223, 'CONTACT_LINK_AVAILABLE_TITEL', 'CONTACT_LINK_AVAILABLE', 'True', 'CONTACT_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2010-08-28 20:13:19', '2010-01-27 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1110, 'VERSANMODUL_EINSTELLUNG_TITEL', 'VERSANMODUL_EINSTELLUNG', '3', 'VERSANMODUL_EINSTELLUNG_DESCRIPTION', 6, NULL, NULL, '0000-00-00 00:00:00', NULL, NULL),
(1054, 'CONSTITUENT_SHIPPING_DP_STATUS_TITEL', 'CONSTITUENT_SHIPPING_DP_STATUS', 'True', 'CONSTITUENT_SHIPPING_DP_STATUS_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1055, 'CONSTITUENT_SHIPPING_DP_HANDLING_TITEL', 'CONSTITUENT_SHIPPING_DP_HANDLING', '0', 'CONSTITUENT_SHIPPING_DP_HANDLING_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1056, 'CONSTITUENT_SHIPPING_DP_TAX_CLASS_TITEL', 'CONSTITUENT_SHIPPING_DP_TAX_CLASS', '0', 'CONSTITUENT_SHIPPING_DP_TAX_CLASS_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', 'go_get_tax_class_title', 'go_cfg_pull_down_tax_classes('),
(1057, 'CONSTITUENT_SHIPPING_DP_ZONE_TITEL', 'CONSTITUENT_SHIPPING_DP_ZONE', '0', 'CONSTITUENT_SHIPPING_DP_ZONE_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', 'go_get_zone_class_title', 'go_cfg_pull_down_zone_classes('),
(1058, 'CONSTITUENT_SHIPPING_DP_SORT_ORDER_TITEL', 'CONSTITUENT_SHIPPING_DP_SORT_ORDER', '1', 'CONSTITUENT_SHIPPING_DP_SORT_ORDER_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1059, 'CONSTITUENT_SHIPPING_DP_LANDS_1_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_1', 'AD,AT,BE,CZ,DK,FO,FI,FR,GR,GL,IE,IT,LI,LU,MC,NL,PL,PT,SM,SK,SE,CH,VA,GB,SP', 'CONSTITUENT_SHIPPING_DP_LANDS_1_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1060, 'CONSTITUENT_SHIPPING_DP_COST_1_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_1', '5:16.50,10:20.50,20:28.50', 'CONSTITUENT_SHIPPING_DP_COST_1_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1061, 'CONSTITUENT_SHIPPING_DP_LANDS_2_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_2', 'AL,AM,AZ,BY,BA,BG,HR,CY,GE,GI,HU,IS,KZ,LT,MK,MT,MD,NO,SI,UA,TR,YU,RU,RO,LV,EE', 'CONSTITUENT_SHIPPING_DP_LANDS_2_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1062, 'CONSTITUENT_SHIPPING_DP_COST_2_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_2', '5:25.00,10:35.00,20:45.00', 'CONSTITUENT_SHIPPING_DP_COST_2_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1063, 'CONSTITUENT_SHIPPING_DP_LANDS_3_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_3', 'DZ,BH,CA,EG,IR,IQ,IL,JO,KW,LB,LY,OM,SA,SY,US,AE,YE,MA,QA,TN,PM', 'CONSTITUENT_SHIPPING_DP_LANDS_3_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1064, 'CONSTITUENT_SHIPPING_DP_COST_3_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_3', '5:29.00,10:39.00,20:59.00', 'CONSTITUENT_SHIPPING_DP_COST_3_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1065, 'CONSTITUENT_SHIPPING_DP_LANDS_4_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_4', 'AF,AS,AO,AI,AG,AR,AW,AU,BS,BD,BB,BZ,BJ,BM,BT,BO,BW,BR,IO,BN,BF,BI,KH,CM,CV,KY,CF,TD,CL,CN,CC,CO,KM,CG,CR,CI,CU,DM,DO,EC,SV,ER,ET,FK,FJ,GF,PF,GA,GM,GH,GD,GP,GT,GN,GW,GY,HT,HN,HK,IN,ID,JM,JP,KE,KI,KG,KP,KR,LA,LS', 'CONSTITUENT_SHIPPING_DP_LANDS_4_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1066, 'CONSTITUENT_SHIPPING_DP_COST_4_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_4', '5:35.00,10:50.00,20:80.00', 'CONSTITUENT_SHIPPING_DP_COST_4_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1067, 'CONSTITUENT_SHIPPING_DP_LANDS_5_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_5', 'MO,MG,MW,MY,MV,ML,MQ,MR,MU,MX,MN,MS,MZ,MM,NA,NR,NP,AN,NC,NZ,NI,NE,NG,PK,PA,PG,PY,PE,PH,PN,RE,KN,LC,VC,SN,SC,SL,SO,LK,SR,SZ,ZA,SG,TG,TH,TZ,TT,TO,TM,TV,VN,WF,VE,UG,UZ,UY,ST,SH,SD,TW,GQ,LR,DJ,CG,RW,ZM,ZW', 'CONSTITUENT_SHIPPING_DP_LANDS_5_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1068, 'CONSTITUENT_SHIPPING_DP_COST_5_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_5', '5:35.00,10:50.00,20:80.00', 'CONSTITUENT_SHIPPING_DP_COST_5_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1069, 'CONSTITUENT_SHIPPING_DP_LANDS_6_TITEL', 'CONSTITUENT_SHIPPING_DP_LANDS_6', 'DE', 'CONSTITUENT_SHIPPING_DP_LANDS_6_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1070, 'CONSTITUENT_SHIPPING_DP_COST_6_TITEL', 'CONSTITUENT_SHIPPING_DP_COST_6', '5:6.70,10:9.70,20:13.00', 'CONSTITUENT_SHIPPING_DP_COST_6_DESCRIPTION', 6, 0, NULL, '2006-01-22 23:02:19', NULL, NULL),
(1111, '_TITEL', '', '', '_DESCRIPTION', 6, 0, NULL, '2006-01-23 08:44:40', NULL, NULL),
(1129, 'VERSANMODUL_EINSTELLUNG_TITEL', 'VERSANMODUL_EINSTELLUNG', '5', 'VERSANMODUL_EINSTELLUNG_DESCRIPTION', 6, NULL, NULL, '0000-00-00 00:00:00', NULL, NULL),
(1130, 'KONFIGURATOR_TITEL', 'KONFIGURATOR', 'false', 'KONFIGURATOR_DESCRIPTION', 1, 10, '2006-04-09 17:30:44', '2006-02-27 10:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1131, 'ITEM_LIST_INFO_TITEL', 'ITEM_LIST_INFO', '0', 'ITEM_LIST_INFO_DESCRIPTION', 8, 4, NULL, '2004-03-17 00:34:34', NULL, NULL),
(1132, 'MEMBER_EMAIL_VALIDATION_TITEL', 'MEMBER_EMAIL_VALIDATION', 'false', 'MEMBER_EMAIL_VALIDATION_DESCRIPTION', 5, 5, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1133, 'MEMBER_ADRESS2_TITEL', 'MEMBER_ADRESS2', 'false', 'MEMBER_ADRESS2_DESCRIPTION', 5, 13, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1134, 'MEMBER_TELE_FAX_TITEL', 'MEMBER_TELE_FAX', 'false', 'MEMBER_TELE_FAX_DESCRIPTION', 5, 18, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1135, 'STANDARDSPRACHE_TITEL', 'STANDARDSPRACHE', 'browser', 'STANDARDSPRACHE_DESCRIPTION', 1, 8, '2006-04-09 17:30:44', '2006-02-27 10:34:34', NULL, 'go_cfg_select_option(array(''english'', ''german'', ''browser''),'),
(1136, 'OPTIMIZE_ORDER_TITEL', 'OPTIMIZE_ORDER', 'false', 'OPTIMIZE_ORDER_DESCRIPTION', 1, 25, '2004-04-10 19:21:06', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1194, 'BASKET_DEL_IF_NEW_LOGIN_TITLE', 'BASKET_DEL_IF_NEW_LOGIN', 'false', 'BASKET_DEL_IF_NEW_LOGIN_DESC', 1, 24, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1188, 'OVERCAT_PICTURE_TITEL', 'OVERCAT_PICTURE', 'false', 'OVERCAT_PICTURE_DESCRIPTION', 1, 21, '2004-04-10 19:21:06', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1189, 'SHOW_ITEMCODE_TITEL', 'SHOW_ITEMCODE', 'true', 'SHOW_ITEMCODE_DESCRIPTION', 1, 22, '2004-04-10 19:21:06', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1193, 'SHOW_ITEMS_NEWS_OF_LAST_SITE_TITLE', 'SHOW_ITEMS_NEWS_OF_LAST_SITE', 'true', 'SHOW_ITEMS_NEWS_OF_LAST_SITE_DESC', 1, 28, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1190, 'SHOW_AGB_TITEL', 'SHOW_AGB', 'true', 'SHOW_AGB_DESCRIPTION', 5, 25, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1191, 'WEIGHT_COUNT_TITEL', 'WEIGHT_COUNT', 'false', 'WEIGHT_COUNT_DESCRIPTION', 1, 26, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1192, 'SHOW_SUBCAT_IF_ITEMS_THERE_TITLE', 'SHOW_SUBCAT_IF_ITEMS_THERE', 'false', 'SHOW_SUBCAT_IF_ITEMS_THERE_DESC', 1, 18, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1195, 'UST_WORD_TITLE', 'UST_WORD', 'true', 'UST_WORD_DESC', 1, 13, NULL, '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1202, 'SHOW_ONLY_ITEMS_WITH_PICTURE_ON_START_TITLE', 'SHOW_ONLY_ITEMS_WITH_PICTURE', 'false', 'SHOW_ONLY_ITEMS_WITH_PICTURE_ON_START_DESC', 1, 19, '2008-06-12 08:36:09', '2003-06-01 17:41:12', NULL, 'go_cfg_select_option(array(''true'', ''false''),'),
(1204, 'POPBOX_TITEL', 'POPBOX', 'True', 'POPBOX_DESCRIPTION', 1, 20, '2009-06-24 01:28:30', '2004-03-17 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1221, 'CONDITION_LINK_AVAILABLE_TITEL', 'CONDITION_LINK_AVAILABLE', 'True', 'CONDITION_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2010-01-27 01:28:30', '2010-01-27 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1222, 'VOUCHER_INFO_LINK_AVAILABLE_TITEL', 'VOUCHER_INFO_LINK_AVAILABLE', 'True', 'VOUCHER_INFO_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2010-01-27 01:28:30', '2010-01-27 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1220, 'PRIVACY_LINK_AVAILABLE_TITEL', 'PRIVACY_LINK_AVAILABLE', 'True', 'PRIVACY_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2010-01-27 01:28:30', '2010-01-27 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1219, 'SHIP_INFO_LINK_AVAILABLE_TITEL', 'SHIP_INFO_LINK_AVAILABLE', 'True', 'SHIP_INFO_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2010-01-27 01:28:30', '2010-01-27 00:34:34', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1228, 'MODULE_PAYMENT_INVOICE_FROM_ORDER_TITEL', 'MODULE_PAYMENT_INVOICE_FROM_ORDER', '3', 'MODULE_PAYMENT_INVOICE_FROM_ORDER_DESCRIPTION', 6, 0, NULL, '2011-08-21 20:29:46', '', ''),
(1229,'MAX_ITEMS_PER_ORDER_TITEL','MAX_ITEMS_PER_ORDER','0','MAX_ITEMS_PER_ORDER_DESCRIPTION',3,20, NULL,'2011-08-28 20:29:46', '', ''),
(1230,'MEMBER_TEL_TITLE', 'MEMBER_TEL', 'true', 'MEMBER_TEL_DESCRIPTION', 5, 19, NULL, now(), NULL, 'go_cfg_select_option(array(\'true\', \'false\'),'),
(1231,'MEMBER_TEL_REQ_TITLE', 'MEMBER_TEL_REQ', 'false', 'MEMBER_TEL_REQ_DESCRIPTION', 5, 20, NULL, now(), NULL,'go_cfg_select_option(array(\'true\', \'false\'),'),
(1232,'MEMBER_FAX_TITLE', 'MEMBER_FAX', 'true', 'MEMBER_FAX_DESCRIPTION', 5, 21, NULL, now(), NULL,'go_cfg_select_option(array(\'true\', \'false\'),'),
(1233,'MEMBER_FAX_REQ_TITLE', 'MEMBER_FAX_REQ', 'false', 'MEMBER_FAX_REQ_DESCRIPTION', 5, 22, NULL, now(), NULL,'go_cfg_select_option(array(\'true\', \'false\'),'),
(1234,'REFERRAL_REQUIRED_REQ_TITLE', 'REFERRAL_REQUIRED_REQ', 'false', 'REFERRAL_REQUIRED_REQ_DESCRIPTION', 5, 24, NULL, now(), NULL,'go_cfg_select_option(array(\'true\', \'false\'),'),
(1235,'IMPRESSUM_LINK_AVAILABLE_TITEL', 'IMPRESSUM_LINK_AVAILABLE', 'True', 'IMPRESSUM_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2014-01-12 01:00:00', '2014-01-12 01:00:00', NULL, 'go_cfg_select_option(array(''True'', ''False''),'),
(1236, 'ROR_LINK_AVAILABLE_TITEL', 'ROR_LINK_AVAILABLE', 'True', 'ROR_LINK_AVAILABLE_DESCRIPTION', 777, 1, '2014-06-29 01:00:00', '2014-06-29 01:00:00', NULL,  'go_cfg_select_option(array(''True'', ''False''),'),
(1238, 'STOCK_LIMIT_LEVEL_TITEL', 'STOCK_LIMIT_LEVEL', 'false', 'STOCK_LIMIT_LEVEL_DESCRIPTION', 9, 6, now(), now(), NULL, 'go_cfg_select_option(array(''true'', ''false''),');

# --------------------------------------------------------

# 
#  Table structure for table `set_it_up_group`
# 

DROP TABLE IF EXISTS `set_it_up_group`;
CREATE TABLE `set_it_up_group` (
  `set_it_up_group_id` int(11) NOT NULL auto_increment,
  `set_it_up_group_title` varchar(64) NOT NULL default '',
  `set_it_up_group_description` varchar(255) NOT NULL default '',
  `sort_order` int(5) default NULL,
  `visible` int(1) default '1',
  PRIMARY KEY  (`set_it_up_group_id`)
) AUTO_INCREMENT=1001 ;

# 
#  Datas for the table `set_it_up_group`
# 

INSERT INTO `set_it_up_group` VALUES(1, 'SETGROUP_TITEL_MY_STORE', 'SETGROUP_DESC_MY_STORE', 1, 1);
INSERT INTO `set_it_up_group` VALUES(2, 'SETGROUP_TITEL_MIN_VALUES', 'SETGROUP_DESC_MIN_VALUES', 2, 1);
INSERT INTO `set_it_up_group` VALUES(3, 'SETGROUP_TITEL_MAX_VALUES', 'SETGROUP_DESC_MAX_VALUES', 3, 1);
INSERT INTO `set_it_up_group` VALUES(4, 'SETGROUP_TITEL_IMAGES', 'SETGROUP_DESC_IMAGES', 4, 1);
INSERT INTO `set_it_up_group` VALUES(5, 'SETGROUP_TITEL_CUST_DETAILS', 'SETGROUP_DESC_CUST_DETAILS', 5, 1);
INSERT INTO `set_it_up_group` VALUES(6, 'SETGROUP_TITEL_MODUL_OPTIONS', 'SETGROUP_DESC_MODUL_OPTIONS', 6, 0);
INSERT INTO `set_it_up_group` VALUES(7, 'SETGROUP_TITEL_SHIPPING', 'SETGROUP_DESC_SHIPPING', 7, 1);
INSERT INTO `set_it_up_group` VALUES(8, 'SETGROUP_TITEL_ITEM_LISTING', 'SETGROUP_DESC_ITEM_LISTING', 8, 1);
INSERT INTO `set_it_up_group` VALUES(9, 'SETGROUP_TITEL_STOCK', 'SETGROUP_DESC_STOCK', 9, 1);
INSERT INTO `set_it_up_group` VALUES(10, 'SETGROUP_TITEL_LOGGING', 'SETGROUP_DESC_LOGGING', 10, 1);
INSERT INTO `set_it_up_group` VALUES(12, 'SETGROUP_TITEL_MAIL_OPTIONS', 'SETGROUP_DESC_MAIL_OPTIONS', 12, 1);
INSERT INTO `set_it_up_group` VALUES(13, 'SETGROUP_TITEL_DOWNLOADS', 'SETGROUP_DESC_DOWNLOADS', 13, 0);
INSERT INTO `set_it_up_group` VALUES(15, 'SETGROUP_TITEL_SESSIONS', 'SETGROUP_DESC_SESSIONS', 15, 1);
INSERT INTO `set_it_up_group` VALUES(911, 'SETGROUP_TITEL_BANK', 'SETGROUP_DESC_BANK', 911, 1);
INSERT INTO `set_it_up_group` VALUES(40, 'SETGROUP_TITEL_GUESTS', 'SETGROUP_DESC_GUESTS', 40, 1);
INSERT INTO `set_it_up_group` VALUES(33, 'SETGROUP_TITEL_TOP_ITEMS', 'SETGROUP_DESC_TOP_ITEMS', 33, 1);
INSERT INTO `set_it_up_group` VALUES(1000, 'SETGROUP_TITEL_OPTI_URLS', 'SETGROUP_DESC_OPTI_URLS', 1000, 0);
INSERT INTO `set_it_up_group` VALUES(72, 'SETGROUP_TITEL_BTOB', 'SETGROUP_DESC_BTOB', 72, 1);
INSERT INTO `set_it_up_group` VALUES(787, 'SETGROUP_TITEL_INVOICE_LAYOUT', 'SETGROUP_DESC_INVOICE_LAYOUT', 0, 0);
INSERT INTO `set_it_up_group` VALUES(777, 'SETGROUP_TITEL_INFO_BOX_LINK_AVAILABLE', 'SETGROUP_DESC_INFO_BOX_LINK_AVAILABLE', 77, 1);

# --------------------------------------------------------
# 
#  Table structure for table `shipping_range_groups`
#
DROP TABLE IF EXISTS shipping_range_groups;
CREATE TABLE shipping_range_groups (
  id             INT UNSIGNED NOT NULL AUTO_INCREMENT,
  description    VARCHAR(60)  NOT NULL DEFAULT '',
  date_added     DATETIME     NOT NULL DEFAULT '0000-00-00 00:00:00',
  last_modified  DATETIME     DEFAULT NULL,
  PRIMARY KEY (id)
);
# 
#  Table structure for table `shipping_range`
#
DROP TABLE IF EXISTS shipping_range;
CREATE TABLE shipping_range (
  id             INT UNSIGNED  NOT NULL AUTO_INCREMENT,
  group_id       INT UNSIGNED  NOT NULL,
  quantity       INT UNSIGNED  NOT NULL,
  delivery_price DECIMAL(15,4) NOT NULL,
  PRIMARY KEY (id)
);

# 
#  Table structure for table `shipping_words`
# 

DROP TABLE IF EXISTS `shipping_words`;
CREATE TABLE `shipping_words` (
  `id` int(3) NOT NULL auto_increment,
  `words` varchar(32) NOT NULL default '',
  `standart` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) AUTO_INCREMENT=1 ;

# 
#  Datas for the table `shipping_words`
# 


# --------------------------------------------------------

# 
#  Table structure for table `sources`
# 

DROP TABLE IF EXISTS `sources`;
CREATE TABLE `sources` (
  `sources_id` int(11) NOT NULL auto_increment,
  `sources_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`sources_id`),
  KEY `IDX_SOURCES_NAME` (`sources_name`)
) AUTO_INCREMENT=6 ;

# 
#  Datas for the table `sources`
# 

INSERT INTO `sources` VALUES(1, 'Google');
INSERT INTO `sources` VALUES(2, 'Yahoo!');
INSERT INTO `sources` VALUES(3, 'AOL');
INSERT INTO `sources` VALUES(4, 'MSN');
INSERT INTO `sources` VALUES(5, 'BigWare');

# --------------------------------------------------------

# 
#  Table structure for table `sources_other`
# 

DROP TABLE IF EXISTS `sources_other`;
CREATE TABLE `sources_other` (
  `attendees_id` int(11) NOT NULL default '0',
  `sources_other_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`attendees_id`)
) ;

# 
#  Datas for the table `sources_other`
# 


# --------------------------------------------------------

# 
#  Table structure for table `specials`
# 

DROP TABLE IF EXISTS `specials`;
CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL auto_increment,
  `items_id` int(11) NOT NULL default '0',
  `specials_new_items_price` decimal(15,4) NOT NULL default '0.0000',
  `specials_date_added` datetime default NULL,
  `specials_last_modified` datetime default NULL,
  `expires_date` datetime default NULL,
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  `attendees_group_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`specials_id`)
) AUTO_INCREMENT=4 ;

# 
#  Datas for the table `specials`
# 

INSERT INTO `specials` VALUES(3, 6546835, 10.0000, '2004-11-22 15:13:10', NULL, '0000-00-00 00:00:00', NULL, 1, 0);

# --------------------------------------------------------

# 
#  Table structure for table `tax_class`
# 

DROP TABLE IF EXISTS `tax_class`;
CREATE TABLE `tax_class` (
  `tax_class_id` int(11) NOT NULL auto_increment,
  `tax_class_title` varchar(32) NOT NULL default '',
  `tax_class_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_class_id`)
) AUTO_INCREMENT=3 ;

# 
#  Datas for the table `tax_class`
# 

INSERT INTO `tax_class` VALUES(1, 'Deutschland normal', 'incl. 19% UST.', '2006-01-30 09:50:20', '2004-07-10 03:28:26');
INSERT INTO `tax_class` VALUES(2, 'Erm&auml;&szlig;igter Steuersatz', 'incl. 7% UST.', '2006-01-30 09:50:38', '2005-04-01 13:55:32');

# --------------------------------------------------------

# 
#  Table structure for table `tax_rates`
# 

DROP TABLE IF EXISTS `tax_rates`;
CREATE TABLE `tax_rates` (
  `tax_rates_id` int(11) NOT NULL auto_increment,
  `tax_zone_id` int(11) NOT NULL default '0',
  `tax_class_id` int(11) NOT NULL default '0',
  `tax_priority` int(5) default '1',
  `tax_rate` decimal(7,4) NOT NULL default '0.0000',
  `tax_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_rates_id`)
) AUTO_INCREMENT=3 ;

# 
#  Datas for the table `tax_rates`
# 

INSERT INTO `tax_rates` VALUES(1, 1, 1, 1, 19.0000, 'inkl. 19 % UST', '2006-02-07 18:57:35', '2004-07-10 03:28:26');
INSERT INTO `tax_rates` VALUES(2, 1, 2, 0, 7.0000, 'inkl. 7 % UST', '2006-02-07 18:57:58', '2005-04-01 13:56:36');

# --------------------------------------------------------

# 
#  Table structure for table `temp_categories`
# 

DROP TABLE IF EXISTS `temp_categories`;
CREATE TABLE `temp_categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_picture` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) AUTO_INCREMENT=1 ;

# 
#  Datas for the table `temp_categories`
# 


# --------------------------------------------------------

# 
#  Table structure for table `temp_items`
# 

DROP TABLE IF EXISTS `temp_items`;
CREATE TABLE `temp_items` (
  `items_id` int(11) NOT NULL auto_increment,
  `items_quantity` int(4) NOT NULL default '0',
  `items_model` varchar(12) default NULL,
  `items_picture` varchar(64) default NULL,
  `items_price` decimal(8,2) NOT NULL default '0.00',
  `items_date_added` datetime default NULL,
  `items_last_modified` datetime default NULL,
  `items_date_available` datetime default NULL,
  `items_weight` decimal(5,2) NOT NULL default '0.00',
  `items_status` tinyint(1) NOT NULL default '0',
  `items_tax_class_id` int(11) NOT NULL default '0',
  `producers_id` int(11) default NULL,
  `items_ordered` int(11) NOT NULL default '0',
  PRIMARY KEY  (`items_id`)
) AUTO_INCREMENT=1 ;

# 
#  Datas for the table `temp_items`
# 


# --------------------------------------------------------

# 
#  Table structure for table `temp_serialize`
# 

DROP TABLE IF EXISTS `temp_serialize`;
CREATE TABLE `temp_serialize` (
  `user` varchar(255) NOT NULL default '',
  `serialize_code` text NOT NULL,
  `was` varchar(255) NOT NULL default ''
) ;

# 
#  Datas for the table `temp_serialize`
# 


# --------------------------------------------------------

# 
#  Table structure for table `uni_import_vorlagen`
# 

DROP TABLE IF EXISTS `uni_import_vorlagen`;
CREATE TABLE `uni_import_vorlagen` (
  `vorlagen_id` int(11) NOT NULL auto_increment,
  `ampel` varchar(200) NOT NULL default '',
  `aufschlag` varchar(200) NOT NULL default '',
  `seperierung` varchar(200) NOT NULL default '',
  `bezeichnung` varchar(200) NOT NULL default '',
  `anzahl` varchar(200) NOT NULL default '',
  `anzahl_default` varchar(200) NOT NULL default '',
  `items_model` varchar(200) NOT NULL default '',
  `items_model_zufall` varchar(200) NOT NULL default '',
  `buld_url` varchar(200) NOT NULL default '',
  `buld_url_default` varchar(200) NOT NULL default '',
  `preis` varchar(200) NOT NULL default '',
  `uvp` varchar(200) NOT NULL default '',
  `gewicht` varchar(200) NOT NULL default '',
  `gewicht_default` varchar(200) NOT NULL default '',
  `unit_price_option` VARCHAR( 20 ) NOT NULL DEFAULT  'keine',
  `unit_price_value` VARCHAR( 20 ) NOT NULL DEFAULT  'keine',
  `unterkat` varchar(200) NOT NULL default '',
  `unterkat_default` varchar(200) NOT NULL default '',
  `beschreibung` varchar(200) NOT NULL default '',
  `beschreibung_incat` VARCHAR( 200 ) NOT NULL default '',
  `filter1` varchar(200) NOT NULL default '',
  `filter2` varchar(200) NOT NULL default '',
  `lieferbarkeit` varchar(200) NOT NULL default '',
  `lieferbarkeit_default` varchar(200) NOT NULL default '',
  `verfuegbar_wert` varchar(200) NOT NULL default '',
  `oberkat` varchar(200) NOT NULL default '',
  `csv_datei` varchar(200) NOT NULL default '',
  `vorlagenname` varchar(200) NOT NULL default '',
  `pfad_zum_bild` varchar(200) default NULL,
  `copybild` enum('no','yes') NOT NULL default 'no',
  `copybild2` enum('no','yes') NOT NULL default 'no',
  `copybild3` enum('no','yes') NOT NULL default 'no',
  `copybild4` enum('no','yes') NOT NULL default 'no',
  `copybild5` enum('no','yes') NOT NULL default 'no',
  `hochkomma` char(3) default NULL,
  `brutto` char(3) default NULL,
  `uni_id` tinyint(24) NOT NULL default '0',
  `unterkat_zweiten` varchar(200) NOT NULL default '',
  `unterkat_dritten` varchar(200) NOT NULL default '',
  `unterkat_vierten` varchar(200) NOT NULL default '',
  `unterkat_fuenften` varchar(200) NOT NULL default '',
  `unterkat_default_zweiten` varchar(200) NOT NULL default '',
  `unterkat_default_dritten` varchar(200) NOT NULL default '',
  `unterkat_default_vierten` varchar(200) NOT NULL default '',
  `unterkat_default_fuenften` varchar(200) NOT NULL default '',
  `buld_url_zweites` varchar(200) NOT NULL default '',
  `buld_url_default_zweites` varchar(200) NOT NULL default '',
  `pfad_zum_bild_zweites` varchar(200) NOT NULL default '',
  `buld_url_drittes` varchar(200) NOT NULL default '',
  `buld_url_default_drittes` varchar(200) NOT NULL default '',
  `pfad_zum_bild_drittes` varchar(200) NOT NULL default '',
  `buld_url_viertes` varchar(200) NOT NULL default '',
  `buld_url_default_viertes` varchar(200) NOT NULL default '',
  `pfad_zum_bild_viertes` varchar(200) NOT NULL default '',
  `buld_url_fuenftes` varchar(200) NOT NULL default '',
  `buld_url_default_fuenftes` varchar(200) NOT NULL default '',
  `pfad_zum_bild_fuenftes` varchar(200) NOT NULL default '',
  `bezeichnung1` varchar(200) NOT NULL default '',
  `inhalt1` varchar(200) NOT NULL default '',
  `bezeichnung_zwei` varchar(200) NOT NULL default '',
  `hersteller` varchar(200) NOT NULL default '',
  `bezeichnung2` varchar(200) NOT NULL default '',
  `inhalt2` varchar(200) NOT NULL default '',
  `bezeichnung3` varchar(200) NOT NULL default '',
  `inhalt3` varchar(200) NOT NULL default '',
  `bezeichnung4` varchar(200) NOT NULL default '',
  `inhalt4` varchar(200) NOT NULL default '',
  `bezeichnung5` varchar(200) NOT NULL default '',
  `inhalt5` varchar(200) NOT NULL default '',
  `bezeichnung6` varchar(200) NOT NULL default '',
  `inhalt6` varchar(200) NOT NULL default '',
  `ean` varchar(255) default NULL,
  `mpn` varchar(255) default NULL,
  PRIMARY KEY  (`vorlagen_id`)
) AUTO_INCREMENT=1 ;

# 
#  Datas for the table `uni_import_vorlagen`
# 


# --------------------------------------------------------

# 
#  Table structure for table `update_ftp_zugang`
# 

DROP TABLE IF EXISTS `update_ftp_zugang`;
CREATE TABLE `update_ftp_zugang` (
  `update_id` tinyint(20) NOT NULL default '1',
  `ftp_server` varchar(200) NOT NULL default '',
  `ftp_user_name` varchar(200) NOT NULL default '',
  `ftp_user_pass` varchar(200) NOT NULL default '',
  `source_file` varchar(200) NOT NULL default '/',
  `ftp_server2` varchar(200) default NULL,
  `ftp_user_name2` varchar(200) default NULL,
  `ftp_user_pass2` varchar(200) default NULL,
  `source_file2` varchar(200) NOT NULL default '/',
  `config` char(2) NOT NULL default '0',
  PRIMARY KEY  (`update_id`)
) ;

# 
#  Datas for the table `update_ftp_zugang`
# 

INSERT INTO `update_ftp_zugang` VALUES(1, '', '', '', '/', '', '', '', '', '1');

# --------------------------------------------------------

# 
#  Table structure for table `update_shop`
# 

DROP TABLE IF EXISTS `update_shop`;
CREATE TABLE `update_shop` (
  `verzeichnissname` varchar(200) NOT NULL default '',
  `update_type` varchar(64) NOT NULL default ''
) ;

# 
#  Datas for the table `update_shop`
# 


# --------------------------------------------------------

# 
#  Table structure for table `whos_online`
# 

DROP TABLE IF EXISTS `whos_online`;
CREATE TABLE `whos_online` (
  `attendee_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(128) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(64) NOT NULL default ''
) ;

# 
#  Datas for the table `whos_online`
# 


# --------------------------------------------------------

# 
#  Table structure for table `zones`
# 

DROP TABLE IF EXISTS `zones`;
CREATE TABLE `zones` (
  `zone_id` int(11) NOT NULL auto_increment,
  `zone_land_id` int(11) NOT NULL default '0',
  `zone_code` varchar(32) NOT NULL default '',
  `zone_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`zone_id`)
) AUTO_INCREMENT=182 ;

# 
#  Datas for the table `zones`
# 

INSERT INTO `zones` VALUES(1, 223, 'AL', 'Alabama');
INSERT INTO `zones` VALUES(2, 223, 'AK', 'Alaska');
INSERT INTO `zones` VALUES(3, 223, 'AS', 'American Samoa');
INSERT INTO `zones` VALUES(4, 223, 'AZ', 'Arizona');
INSERT INTO `zones` VALUES(5, 223, 'AR', 'Arkansas');
INSERT INTO `zones` VALUES(6, 223, 'AF', 'Armed Forces Africa');
INSERT INTO `zones` VALUES(7, 223, 'AA', 'Armed Forces Americas');
INSERT INTO `zones` VALUES(8, 223, 'AC', 'Armed Forces Canada');
INSERT INTO `zones` VALUES(9, 223, 'AE', 'Armed Forces Europe');
INSERT INTO `zones` VALUES(10, 223, 'AM', 'Armed Forces Middle East');
INSERT INTO `zones` VALUES(11, 223, 'AP', 'Armed Forces Pacific');
INSERT INTO `zones` VALUES(12, 223, 'CA', 'California');
INSERT INTO `zones` VALUES(13, 223, 'CO', 'Colorado');
INSERT INTO `zones` VALUES(14, 223, 'CT', 'Connecticut');
INSERT INTO `zones` VALUES(15, 223, 'DE', 'Delaware');
INSERT INTO `zones` VALUES(16, 223, 'DC', 'District of Columbia');
INSERT INTO `zones` VALUES(17, 223, 'FM', 'Federated States Of Micronesia');
INSERT INTO `zones` VALUES(18, 223, 'FL', 'Florida');
INSERT INTO `zones` VALUES(19, 223, 'GA', 'Georgia');
INSERT INTO `zones` VALUES(20, 223, 'GU', 'Guam');
INSERT INTO `zones` VALUES(21, 223, 'HI', 'Hawaii');
INSERT INTO `zones` VALUES(22, 223, 'ID', 'Idaho');
INSERT INTO `zones` VALUES(23, 223, 'IL', 'Illinois');
INSERT INTO `zones` VALUES(24, 223, 'IN', 'Indiana');
INSERT INTO `zones` VALUES(25, 223, 'IA', 'Iowa');
INSERT INTO `zones` VALUES(26, 223, 'KS', 'Kansas');
INSERT INTO `zones` VALUES(27, 223, 'KY', 'Kentucky');
INSERT INTO `zones` VALUES(28, 223, 'LA', 'Louisiana');
INSERT INTO `zones` VALUES(29, 223, 'ME', 'Maine');
INSERT INTO `zones` VALUES(30, 223, 'MH', 'Marshall Islands');
INSERT INTO `zones` VALUES(31, 223, 'MD', 'Maryland');
INSERT INTO `zones` VALUES(32, 223, 'MA', 'Massachusetts');
INSERT INTO `zones` VALUES(33, 223, 'MI', 'Michigan');
INSERT INTO `zones` VALUES(34, 223, 'MN', 'Minnesota');
INSERT INTO `zones` VALUES(35, 223, 'MS', 'Mississippi');
INSERT INTO `zones` VALUES(36, 223, 'MO', 'Missouri');
INSERT INTO `zones` VALUES(37, 223, 'MT', 'Montana');
INSERT INTO `zones` VALUES(38, 223, 'NE', 'Nebraska');
INSERT INTO `zones` VALUES(39, 223, 'NV', 'Nevada');
INSERT INTO `zones` VALUES(40, 223, 'NH', 'New Hampshire');
INSERT INTO `zones` VALUES(41, 223, 'NJ', 'New Jersey');
INSERT INTO `zones` VALUES(42, 223, 'NM', 'New Mexico');
INSERT INTO `zones` VALUES(43, 223, 'NY', 'New York');
INSERT INTO `zones` VALUES(44, 223, 'NC', 'North Carolina');
INSERT INTO `zones` VALUES(45, 223, 'ND', 'North Dakota');
INSERT INTO `zones` VALUES(46, 223, 'MP', 'Northern Mariana Islands');
INSERT INTO `zones` VALUES(47, 223, 'OH', 'Ohio');
INSERT INTO `zones` VALUES(48, 223, 'OK', 'Oklahoma');
INSERT INTO `zones` VALUES(49, 223, 'OR', 'Oregon');
INSERT INTO `zones` VALUES(50, 223, 'PW', 'Palau');
INSERT INTO `zones` VALUES(51, 223, 'PA', 'Pennsylvania');
INSERT INTO `zones` VALUES(52, 223, 'PR', 'Puerto Rico');
INSERT INTO `zones` VALUES(53, 223, 'RI', 'Rhode Island');
INSERT INTO `zones` VALUES(54, 223, 'SC', 'South Carolina');
INSERT INTO `zones` VALUES(55, 223, 'SD', 'South Dakota');
INSERT INTO `zones` VALUES(56, 223, 'TN', 'Tennessee');
INSERT INTO `zones` VALUES(57, 223, 'TX', 'Texas');
INSERT INTO `zones` VALUES(58, 223, 'UT', 'Utah');
INSERT INTO `zones` VALUES(59, 223, 'VT', 'Vermont');
INSERT INTO `zones` VALUES(60, 223, 'VI', 'Virgin Islands');
INSERT INTO `zones` VALUES(61, 223, 'VA', 'Virginia');
INSERT INTO `zones` VALUES(62, 223, 'WA', 'Washington');
INSERT INTO `zones` VALUES(63, 223, 'WV', 'West Virginia');
INSERT INTO `zones` VALUES(64, 223, 'WI', 'Wisconsin');
INSERT INTO `zones` VALUES(65, 223, 'WY', 'Wyoming');
INSERT INTO `zones` VALUES(66, 38, 'AB', 'Alberta');
INSERT INTO `zones` VALUES(67, 38, 'BC', 'British Columbia');
INSERT INTO `zones` VALUES(68, 38, 'MB', 'Manitoba');
INSERT INTO `zones` VALUES(69, 38, 'NF', 'Newfoundland');
INSERT INTO `zones` VALUES(70, 38, 'NB', 'New Brunswick');
INSERT INTO `zones` VALUES(71, 38, 'NS', 'Nova Scotia');
INSERT INTO `zones` VALUES(72, 38, 'NT', 'Northwest Territories');
INSERT INTO `zones` VALUES(73, 38, 'NU', 'Nunavut');
INSERT INTO `zones` VALUES(74, 38, 'ON', 'Ontario');
INSERT INTO `zones` VALUES(75, 38, 'PE', 'Prince Edward Island');
INSERT INTO `zones` VALUES(76, 38, 'QC', 'Quebec');
INSERT INTO `zones` VALUES(77, 38, 'SK', 'Saskatchewan');
INSERT INTO `zones` VALUES(78, 38, 'YT', 'Yukon Territory');
INSERT INTO `zones` VALUES(79, 81, 'NDS', 'Niedersachsen');
INSERT INTO `zones` VALUES(80, 81, 'BAW', 'Baden-W&uuml;rttemberg');
INSERT INTO `zones` VALUES(81, 81, 'BAY', 'Bayern');
INSERT INTO `zones` VALUES(82, 81, 'BER', 'Berlin');
INSERT INTO `zones` VALUES(83, 81, 'BRG', 'Brandenburg');
INSERT INTO `zones` VALUES(84, 81, 'BRE', 'Bremen');
INSERT INTO `zones` VALUES(85, 81, 'HAM', 'Hamburg');
INSERT INTO `zones` VALUES(86, 81, 'HES', 'Hessen');
INSERT INTO `zones` VALUES(87, 81, 'MEC', 'Mecklenburg-Vorpommern');
INSERT INTO `zones` VALUES(88, 81, 'NRW', 'Nordrhein-Westfalen');
INSERT INTO `zones` VALUES(89, 81, 'RHE', 'Rheinland-Pfalz');
INSERT INTO `zones` VALUES(90, 81, 'SAR', 'Saarland');
INSERT INTO `zones` VALUES(91, 81, 'SAS', 'Sachsen');
INSERT INTO `zones` VALUES(92, 81, 'SAC', 'Sachsen-Anhalt');
INSERT INTO `zones` VALUES(93, 81, 'SCN', 'Schleswig-Holstein');
INSERT INTO `zones` VALUES(94, 81, 'THE', 'Th&uuml;ringen');
INSERT INTO `zones` VALUES(95, 14, 'WI', 'Wien');
INSERT INTO `zones` VALUES(96, 14, 'NO', 'Nieder&ouml;sterreich');
INSERT INTO `zones` VALUES(97, 14, 'OO', 'Ober&ouml;sterreich');
INSERT INTO `zones` VALUES(98, 14, 'SB', 'Salzburg');
INSERT INTO `zones` VALUES(99, 14, 'KN', 'K&auml;rnten');
INSERT INTO `zones` VALUES(100, 14, 'ST', 'Steiermark');
INSERT INTO `zones` VALUES(101, 14, 'TI', 'Tirol');
INSERT INTO `zones` VALUES(102, 14, 'BL', 'Burgenland');
INSERT INTO `zones` VALUES(103, 14, 'VB', 'Voralberg');
INSERT INTO `zones` VALUES(104, 204, 'AG', 'Aargau');
INSERT INTO `zones` VALUES(105, 204, 'AI', 'Appenzell Innerrhoden');
INSERT INTO `zones` VALUES(106, 204, 'AR', 'Appenzell Ausserrhoden');
INSERT INTO `zones` VALUES(107, 204, 'BE', 'Bern');
INSERT INTO `zones` VALUES(108, 204, 'BL', 'Basel-Landschaft');
INSERT INTO `zones` VALUES(109, 204, 'BS', 'Basel-Stadt');
INSERT INTO `zones` VALUES(110, 204, 'FR', 'Freiburg');
INSERT INTO `zones` VALUES(111, 204, 'GE', 'Genf');
INSERT INTO `zones` VALUES(112, 204, 'GL', 'Glarus');
INSERT INTO `zones` VALUES(113, 204, 'JU', 'Graub&uuml;nden');
INSERT INTO `zones` VALUES(114, 204, 'JU', 'Jura');
INSERT INTO `zones` VALUES(115, 204, 'LU', 'Luzern');
INSERT INTO `zones` VALUES(116, 204, 'NE', 'Neuenburg');
INSERT INTO `zones` VALUES(117, 204, 'NW', 'Nidwalden');
INSERT INTO `zones` VALUES(118, 204, 'OW', 'Obwalden');
INSERT INTO `zones` VALUES(119, 204, 'SG', 'St. Gallen');
INSERT INTO `zones` VALUES(120, 204, 'SH', 'Schaffhausen');
INSERT INTO `zones` VALUES(121, 204, 'SO', 'Solothurn');
INSERT INTO `zones` VALUES(122, 204, 'SZ', 'Schwyz');
INSERT INTO `zones` VALUES(123, 204, 'TG', 'Thurgau');
INSERT INTO `zones` VALUES(124, 204, 'TI', 'Tessin');
INSERT INTO `zones` VALUES(125, 204, 'UR', 'Uri');
INSERT INTO `zones` VALUES(126, 204, 'VD', 'Waadt');
INSERT INTO `zones` VALUES(127, 204, 'VS', 'Wallis');
INSERT INTO `zones` VALUES(128, 204, 'ZG', 'Zug');
INSERT INTO `zones` VALUES(129, 204, 'ZH', 'Z&uuml;rich');
INSERT INTO `zones` VALUES(130, 195, 'A CoruÃ±a', 'A CoruÃ±a');
INSERT INTO `zones` VALUES(131, 195, 'Alava', 'Alava');
INSERT INTO `zones` VALUES(132, 195, 'Albacete', 'Albacete');
INSERT INTO `zones` VALUES(133, 195, 'Alicante', 'Alicante');
INSERT INTO `zones` VALUES(134, 195, 'Almeria', 'Almeria');
INSERT INTO `zones` VALUES(135, 195, 'Asturias', 'Asturias');
INSERT INTO `zones` VALUES(136, 195, 'Avila', 'Avila');
INSERT INTO `zones` VALUES(137, 195, 'Badajoz', 'Badajoz');
INSERT INTO `zones` VALUES(138, 195, 'Baleares', 'Baleares');
INSERT INTO `zones` VALUES(139, 195, 'Barcelona', 'Barcelona');
INSERT INTO `zones` VALUES(140, 195, 'Burgos', 'Burgos');
INSERT INTO `zones` VALUES(141, 195, 'Caceres', 'Caceres');
INSERT INTO `zones` VALUES(142, 195, 'Cadiz', 'Cadiz');
INSERT INTO `zones` VALUES(143, 195, 'Cantabria', 'Cantabria');
INSERT INTO `zones` VALUES(144, 195, 'Castellon', 'Castellon');
INSERT INTO `zones` VALUES(145, 195, 'Ceuta', 'Ceuta');
INSERT INTO `zones` VALUES(146, 195, 'Ciudad Real', 'Ciudad Real');
INSERT INTO `zones` VALUES(147, 195, 'Cordoba', 'Cordoba');
INSERT INTO `zones` VALUES(148, 195, 'Cuenca', 'Cuenca');
INSERT INTO `zones` VALUES(149, 195, 'Girona', 'Girona');
INSERT INTO `zones` VALUES(150, 195, 'Granada', 'Granada');
INSERT INTO `zones` VALUES(151, 195, 'Guadalajara', 'Guadalajara');
INSERT INTO `zones` VALUES(152, 195, 'Guipuzcoa', 'Guipuzcoa');
INSERT INTO `zones` VALUES(153, 195, 'Huelva', 'Huelva');
INSERT INTO `zones` VALUES(154, 195, 'Huesca', 'Huesca');
INSERT INTO `zones` VALUES(155, 195, 'Jaen', 'Jaen');
INSERT INTO `zones` VALUES(156, 195, 'La Rioja', 'La Rioja');
INSERT INTO `zones` VALUES(157, 195, 'Las Palmas', 'Las Palmas');
INSERT INTO `zones` VALUES(158, 195, 'Leon', 'Leon');
INSERT INTO `zones` VALUES(159, 195, 'Lleida', 'Lleida');
INSERT INTO `zones` VALUES(160, 195, 'Lugo', 'Lugo');
INSERT INTO `zones` VALUES(161, 195, 'Madrid', 'Madrid');
INSERT INTO `zones` VALUES(162, 195, 'Malaga', 'Malaga');
INSERT INTO `zones` VALUES(163, 195, 'Melilla', 'Melilla');
INSERT INTO `zones` VALUES(164, 195, 'Murcia', 'Murcia');
INSERT INTO `zones` VALUES(165, 195, 'Navarra', 'Navarra');
INSERT INTO `zones` VALUES(166, 195, 'Ourense', 'Ourense');
INSERT INTO `zones` VALUES(167, 195, 'Palencia', 'Palencia');
INSERT INTO `zones` VALUES(168, 195, 'Pontevedra', 'Pontevedra');
INSERT INTO `zones` VALUES(169, 195, 'Salamanca', 'Salamanca');
INSERT INTO `zones` VALUES(170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife');
INSERT INTO `zones` VALUES(171, 195, 'Segovia', 'Segovia');
INSERT INTO `zones` VALUES(172, 195, 'Sevilla', 'Sevilla');
INSERT INTO `zones` VALUES(173, 195, 'Soria', 'Soria');
INSERT INTO `zones` VALUES(174, 195, 'Tarragona', 'Tarragona');
INSERT INTO `zones` VALUES(175, 195, 'Teruel', 'Teruel');
INSERT INTO `zones` VALUES(176, 195, 'Toledo', 'Toledo');
INSERT INTO `zones` VALUES(177, 195, 'Valencia', 'Valencia');
INSERT INTO `zones` VALUES(178, 195, 'Valladolid', 'Valladolid');
INSERT INTO `zones` VALUES(179, 195, 'Vizcaya', 'Vizcaya');
INSERT INTO `zones` VALUES(180, 195, 'Zamora', 'Zamora');
INSERT INTO `zones` VALUES(181, 195, 'Zaragoza', 'Zaragoza');

# --------------------------------------------------------

# 
#  Table structure for table `zones_to_geo_zones`
# 

DROP TABLE IF EXISTS `zones_to_geo_zones`;
CREATE TABLE `zones_to_geo_zones` (
  `association_id` int(11) NOT NULL auto_increment,
  `zone_land_id` int(11) NOT NULL default '0',
  `zone_id` int(11) default NULL,
  `geo_zone_id` int(11) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`association_id`)
) AUTO_INCREMENT=2 ;

# 
#  Datas for the table `zones_to_geo_zones`
# 

INSERT INTO `zones_to_geo_zones` VALUES(1, 0, NULL, 1, '2006-01-30 09:48:59', '2004-07-10 03:28:26');
