-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Server Version: 4.0.18
-- PHP-Version: 4.4.2
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `CACHEDATA`
--
CREATE TABLE IF NOT EXISTS `CACHEDATA` (
`CACHEKEY` varchar(255) NOT NULL default '',
`CACHEEXPIRATION` int(11) NOT NULL default '0',
`GZDATA` mediumblob,
`DATASIZE` int(11) default NULL,
`DATACRC` int(11) default NULL,
PRIMARY KEY (`CACHEKEY`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `DTP_nav`
--
CREATE TABLE IF NOT EXISTS `DTP_nav` (
`id` int(8) NOT NULL auto_increment,
`parent_cat` int(8) default NULL,
`pos` int(8) NOT NULL default '0',
`page_type` varchar(32) NOT NULL default '',
`templates` blob NOT NULL,
`output_type` varchar(250) NOT NULL default 'HTML,flash,PDF',
`pages` int(11) NOT NULL default '0',
`output_format_print` float NOT NULL default '0',
`output_format_screen` float NOT NULL default '0',
`output_dpi` int(11) NOT NULL default '0',
`output_format_print_media_path` varchar(250) NOT NULL default '',
`output_format_screen_media_path` varchar(250) NOT NULL default '',
`output_format_print_font_path` varchar(250) NOT NULL default '',
`output_format_screen_font_path` varchar(250) NOT NULL default '',
`left_template` varchar(250) NOT NULL default '',
`right_template` varchar(250) NOT NULL default '',
`output_format_print_height` float NOT NULL default '0',
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`output_format_html` float NOT NULL default '0',
`output_format_screen_right_template` varchar(250) NOT NULL default '',
`output_format_screen_left_template` varchar(250) NOT NULL default '',
`output_format_html_right_template` varchar(250) NOT NULL default '',
`output_format_html_left_template` varchar(250) NOT NULL default '',
`output_format_print_left_template` varchar(250) NOT NULL default '',
`output_format_print_right_template` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `DTP_pages`
--
CREATE TABLE IF NOT EXISTS `DTP_pages` (
`id` int(8) NOT NULL auto_increment,
`cat_id` int(8) NOT NULL default '0',
`pos` int(8) NOT NULL default '0',
`template` varchar(250) NOT NULL default '',
`chapter` varchar(250) NOT NULL default '',
`variables` blob NOT NULL,
`screen_template` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=469 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `anchor`
--
CREATE TABLE IF NOT EXISTS `anchor` (
`id` int(11) NOT NULL auto_increment,
`topic` varchar(100) NOT NULL default '',
`name` varchar(200) NOT NULL default '',
`lang` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `blog_keywords`
--
CREATE TABLE IF NOT EXISTS `blog_keywords` (
`id` int(10) unsigned NOT NULL auto_increment,
`keyword` varchar(255) NOT NULL default '',
`usedby` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `blog_trackbacks`
--
CREATE TABLE IF NOT EXISTS `blog_trackbacks` (
`id` int(11) NOT NULL auto_increment,
`blogentry` int(11) NOT NULL default '0',
`url` varchar(255) NOT NULL default '',
`blog_name` varchar(255) NOT NULL default '',
`excerpt` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`active` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `blogentries`
--
CREATE TABLE IF NOT EXISTS `blogentries` (
`id` int(10) unsigned NOT NULL auto_increment,
`linkname` varchar(50) NOT NULL default '',
`heading` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`author` varchar(127) NOT NULL default '',
`category` varchar(255) NOT NULL default '0',
`topics` varchar(255) NOT NULL default '',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`previewlength` int(11) unsigned NOT NULL default '9999',
`commentsallowed` tinyint(3) unsigned NOT NULL default '1',
`trackbacksallowed` tinyint(3) NOT NULL default '1',
`hidden` tinyint(3) NOT NULL default '0',
`userid` int(10) unsigned default NULL,
`previewtext` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL auto_increment,
`heading` varchar(255) NOT NULL default '',
`email` text,
`content` text NOT NULL,
`author` varchar(127) NOT NULL default '',
`url` text,
`parentid` int(10) unsigned NOT NULL default '0',
`tbl` varchar(127) NOT NULL default 'blogentries',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`ipaddress` varchar(50) default NULL,
`active` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `content`
--
CREATE TABLE IF NOT EXISTS `content` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`topic` varchar(255) NOT NULL default '',
`template_id` varchar(100) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `site` (`site`),
KEY `site_2` (`site`,`topic`,`template_id`)
) TYPE=MyISAM AUTO_INCREMENT=132 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `countries`
--
CREATE TABLE IF NOT EXISTS `countries` (
`ID` int(8) NOT NULL auto_increment,
`domain` varchar(8) default NULL,
`countries` varchar(40) default NULL,
`countries_long` varchar(80) default NULL,
`fips_code` char(2) default NULL,
`capital` varchar(80) default NULL,
`deactivated` enum('0','1') NOT NULL default '1',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `countries_state`
--
CREATE TABLE IF NOT EXISTS `countries_state` (
`ID` int(11) NOT NULL auto_increment,
`fips_code` char(2) NOT NULL default '',
`name` varchar(60) NOT NULL default '',
`short` varchar(4) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `dtp_pages_article`
--
CREATE TABLE IF NOT EXISTS `dtp_pages_article` (
`id` int(8) NOT NULL auto_increment,
`page_id` int(8) NOT NULL default '0',
`article_id` int(8) NOT NULL default '0',
`pos` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`,`article_id`)
) TYPE=MyISAM AUTO_INCREMENT=2676 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `form`
--
CREATE TABLE IF NOT EXISTS `form` (
`id` int(11) NOT NULL auto_increment,
`topic` varchar(200) NOT NULL default '',
`form` text NOT NULL,
`subject` varchar(200) NOT NULL default '',
`action` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `image`
--
CREATE TABLE IF NOT EXISTS `image` (
`id` int(11) NOT NULL auto_increment,
`topic` varchar(200) NOT NULL default '',
`template_id` varchar(200) NOT NULL default '',
`href` text NOT NULL,
`link` varchar(255) NOT NULL default '',
`popup` enum('true','false') NOT NULL default 'false',
`target` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`alt` text NOT NULL,
`language` varchar(10) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`user_id` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `topic` (`topic`,`template_id`(50))
) TYPE=MyISAM AUTO_INCREMENT=400 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `message`
--
CREATE TABLE IF NOT EXISTS `message` (
`id` int(11) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`text` longtext NOT NULL,
`datetime` timestamp(14) NOT NULL,
`start_datetime` timestamp(14) NOT NULL default '00000000000000',
`till_datetime` timestamp(14) NOT NULL default '00000000000000',
`user_id` int(11) unsigned NOT NULL default '0',
`topic` varchar(255) NOT NULL default '',
`type` set('message','task') NOT NULL default 'message',
`done` tinyint(5) unsigned NOT NULL default '0',
KEY `id` (`id`),
KEY `userID` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `message_rel`
--
CREATE TABLE IF NOT EXISTS `message_rel` (
`id` int(11) unsigned NOT NULL auto_increment,
`message_id` int(11) unsigned NOT NULL default '0',
`userto_id` int(11) unsigned NOT NULL default '0',
`status` set('new','old','deleted') NOT NULL default 'new',
KEY `id` (`id`,`message_id`,`userto_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_groups`
--
CREATE TABLE IF NOT EXISTS `newsletter_groups` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`sendername` varchar(255) NOT NULL default '',
`senderemail` varchar(200) default NULL,
`html_group_header_template` varchar(255) NOT NULL default '',
`html_topic_template` varchar(255) NOT NULL default '',
`html_group_footer_template` varchar(255) NOT NULL default '',
`ascii_group_header_template` varchar(255) NOT NULL default '',
`ascii_topic_template` varchar(255) NOT NULL default '',
`ascii_group_footer_template` varchar(255) NOT NULL default '',
`priority` tinyint(5) NOT NULL default '0',
`langs` varchar(255) NOT NULL default '',
`topics_order` varchar(50) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_groups_rel`
--
CREATE TABLE IF NOT EXISTS `newsletter_groups_rel` (
`subscriber_group_id` int(10) unsigned NOT NULL default '0',
`group_id` int(10) unsigned NOT NULL default '0',
`position` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `subscriber_groups_id` (`subscriber_group_id`,`group_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_log_types`
--
CREATE TABLE IF NOT EXISTS `newsletter_log_types` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_mail_log`
--
CREATE TABLE IF NOT EXISTS `newsletter_mail_log` (
`email` varchar(200) default '0',
`topic_title` varchar(255) default NULL,
`sentdate` timestamp(14) NOT NULL,
`error` enum('no','yes') default 'no',
`errorcode` text,
`mail_text` text NOT NULL,
KEY `email` (`email`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_schedule`
--
CREATE TABLE IF NOT EXISTS `newsletter_schedule` (
`subscriber_group_id` mediumint(10) unsigned NOT NULL default '0',
`frequency` enum('interval','daily','weekly','monthly') NOT NULL default 'interval',
`status` enum('queue','sent') NOT NULL default 'queue',
`datetime` timestamp(14) NOT NULL,
PRIMARY KEY (`subscriber_group_id`,`frequency`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_subscriber`
--
CREATE TABLE IF NOT EXISTS `newsletter_subscriber` (
`site_user_id` int(10) unsigned default NULL,
`type` enum('html','ascii') NOT NULL default 'html',
`lang` varchar(20) NOT NULL default '',
`digest` enum('false','true') NOT NULL default 'false',
`frequency` enum('interval','daily','weekly','monthly') NOT NULL default 'daily',
`subscriber_group_id` int(10) unsigned NOT NULL default '0',
`groups` varchar(255) NOT NULL default '',
`hash` varchar(255) NOT NULL default '',
`profile` text,
UNIQUE KEY `siteuserid` (`site_user_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_subscriber_groups`
--
CREATE TABLE IF NOT EXISTS `newsletter_subscriber_groups` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`sendername` varchar(255) NOT NULL default '',
`senderemail` varchar(200) default NULL,
`html_header_template` varchar(255) NOT NULL default '',
`html_group_header_template` varchar(255) NOT NULL default '',
`html_topic_template` varchar(255) NOT NULL default '',
`html_group_footer_template` varchar(255) NOT NULL default '',
`html_footer_template` varchar(255) NOT NULL default '',
`ascii_header_template` varchar(255) NOT NULL default '',
`ascii_group_header_template` varchar(255) NOT NULL default '',
`ascii_topic_template` varchar(255) NOT NULL default '',
`ascii_group_footer_template` varchar(255) NOT NULL default '',
`ascii_footer_template` varchar(255) NOT NULL default '',
`langs` varchar(255) NOT NULL default '',
`groups_order` varchar(50) NOT NULL default 'fixed',
`senddates` text NOT NULL,
`status` enum('enabled','disabled') NOT NULL default 'enabled',
PRIMARY KEY (`id`),
KEY `groups_order` (`groups_order`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_subscriber_log`
--
CREATE TABLE IF NOT EXISTS `newsletter_subscriber_log` (
`type_id` int(10) unsigned default NULL,
`type` varchar(255) NOT NULL default '',
`notification` text,
`profile` text,
`email` varchar(200) default NULL,
`ip` varchar(100) default NULL,
`date` timestamp(14) NOT NULL,
`hash` varchar(255) default NULL,
KEY `type_id` (`type_id`),
KEY `email` (`email`),
KEY `ip` (`ip`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_templates`
--
CREATE TABLE IF NOT EXISTS `newsletter_templates` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`type` enum('html','ascii') NOT NULL default 'html',
`template` longtext,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_topics`
--
CREATE TABLE IF NOT EXISTS `newsletter_topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) default NULL,
`html_text` longtext,
`ascii_text` longtext,
`ascii_edit` enum('off','on') NOT NULL default 'off',
`link` varchar(255) default NULL,
`lang` varchar(200) default NULL,
`group_id` int(10) unsigned NOT NULL default '0',
`subscriber_groups` varchar(255) NOT NULL default '0',
`priority` tinyint(5) NOT NULL default '0',
`status` enum('in process','proofreading','retour','published','refused') NOT NULL default 'in process',
`moddate` timestamp(14) NOT NULL,
`insdate` timestamp(14) NOT NULL default '00000000000000',
`senddate` timestamp(8) NOT NULL default '00000000',
`ins_user_id` int(10) unsigned default NULL,
`mod_user_id` int(10) unsigned default NULL,
`sent_interval` enum('no','yes') NOT NULL default 'no',
`sent_daily` enum('no','yes') NOT NULL default 'no',
`sent_weekly` enum('no','yes') NOT NULL default 'no',
`sent_monthly` enum('no','yes') NOT NULL default 'no',
PRIMARY KEY (`id`),
KEY `ins_user_id` (`ins_user_id`),
KEY `mod_user_id` (`mod_user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_topics_files`
--
CREATE TABLE IF NOT EXISTS `newsletter_topics_files` (
`topic_id` int(10) NOT NULL default '0',
`file` varchar(255) NOT NULL default '',
KEY `file` (`topic_id`,`file`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_topics_rel`
--
CREATE TABLE IF NOT EXISTS `newsletter_topics_rel` (
`topic_id` int(10) unsigned NOT NULL default '0',
`group_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`topic_id`,`group_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `newsletter_topics_sent`
--
CREATE TABLE IF NOT EXISTS `newsletter_topics_sent` (
`subscriber_group_id` int(10) unsigned NOT NULL default '0',
`topic_id` int(10) unsigned NOT NULL default '0',
`frequency` enum('interval','daily','weekly','monthly') NOT NULL default 'interval',
PRIMARY KEY (`subscriber_group_id`,`topic_id`,`frequency`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `producers`
--
CREATE TABLE IF NOT EXISTS `producers` (
`id` int(10) unsigned NOT NULL auto_increment,
`date` timestamp(14) NOT NULL,
`user_id` int(10) unsigned NOT NULL default '0',
`status` enum('enabled','preview','feedback','pending','disabled') NOT NULL default 'enabled',
`dbrel_id` int(11) NOT NULL default '0',
`Name` text,
`Beschreibung` text,
`Link` text,
`Linktext` text,
`Bild1` varchar(255) default NULL,
`Bildunterschrift1` text,
`Bild2` varchar(255) default NULL,
`Bildunterschrift2` text,
`Bild3` varchar(255) default NULL,
`Bildunterschrift3` text,
`language` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_artgroup`
--
CREATE TABLE IF NOT EXISTS `shop_artgroup` (
`id` int(11) NOT NULL auto_increment,
`ugroup_of_id` int(11) default NULL,
`privs` text NOT NULL,
`deactivated` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `deactivated` (`deactivated`),
KEY `ugroup_of_id` (`ugroup_of_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_article_article_cs`
--
CREATE TABLE IF NOT EXISTS `shop_article_article_cs` (
`id` int(8) NOT NULL auto_increment,
`parent_article_id` int(8) NOT NULL default '0',
`article_id` int(8) NOT NULL default '0',
`pos` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_article_keywords`
--
CREATE TABLE IF NOT EXISTS `shop_article_keywords` (
`article_id` int(8) NOT NULL default '0',
`keyword_id` int(8) NOT NULL default '0',
PRIMARY KEY (`article_id`,`keyword_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_article_lists`
--
CREATE TABLE IF NOT EXISTS `shop_article_lists` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(250) NOT NULL default '',
`article_id` int(8) NOT NULL default '0',
`pos` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_article_options`
--
CREATE TABLE IF NOT EXISTS `shop_article_options` (
`id` int(11) NOT NULL auto_increment,
`art_id` int(11) NOT NULL default '0',
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
`code` varchar(20) NOT NULL default '',
`EAN` varchar(20) NOT NULL default '',
`distributor` varchar(80) NOT NULL default '',
`distributor_code` varchar(20) NOT NULL default '',
`freeoption1` varchar(80) default NULL,
`freeoption2` varchar(80) default NULL,
`freeoption3` varchar(80) default NULL,
`weight` float NOT NULL default '0',
`volume` float NOT NULL default '0',
`width_dimension` float NOT NULL default '0',
`height_dimension` float NOT NULL default '0',
`depth_dimension` float NOT NULL default '0',
`EK` float NOT NULL default '0',
`EVP` float NOT NULL default '0',
`price` float NOT NULL default '0',
`stored_quantity` int(11) NOT NULL default '0',
`ordered_quantity` int(11) NOT NULL default '0',
`days_to_supply` int(11) NOT NULL default '0',
`image` varchar(255) default NULL,
`deactivated` enum('0','1') NOT NULL default '0',
`last_order` datetime default NULL,
`total_orders` int(11) NOT NULL default '0',
`pos` int(11) NOT NULL default '0',
`freeoption4` longtext NOT NULL,
`freeoption5` longtext NOT NULL,
`gutschein` int(8) NOT NULL default '0',
`stock_unit` varchar(128) NOT NULL default 'Stück',
`stock_min_unit` float NOT NULL default '1',
`quantity_per_unit` float NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `deactivated` (`deactivated`),
KEY `art_id` (`art_id`),
KEY `ean` (`EAN`)
) TYPE=MyISAM AUTO_INCREMENT=2595 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_article_options_template`
--
CREATE TABLE IF NOT EXISTS `shop_article_options_template` (
`id` int(11) NOT NULL auto_increment,
`art_id` int(11) NOT NULL default '0',
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
`code` varchar(20) NOT NULL default '',
`EAN` varchar(20) NOT NULL default '',
`distributor` varchar(80) NOT NULL default '',
`distributor_code` varchar(20) NOT NULL default '',
`freeoption1` longtext,
`freeoption2` longtext,
`freeoption3` longtext,
`freeoption4` longtext NOT NULL,
`freeoption5` longtext NOT NULL,
`weight` float NOT NULL default '0',
`volume` float NOT NULL default '0',
`width_dimension` float NOT NULL default '0',
`height_dimension` float NOT NULL default '0',
`depth_dimension` float NOT NULL default '0',
`EK` float NOT NULL default '0',
`EVP` float NOT NULL default '0',
`price` float NOT NULL default '0',
`stored_quantity` int(11) NOT NULL default '0',
`ordered_quantity` int(11) NOT NULL default '0',
`days_to_supply` int(11) NOT NULL default '0',
`image` varchar(80) default NULL,
`deactivated` enum('0','1') NOT NULL default '0',
`last_order` datetime default NULL,
`total_orders` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `deactivated` (`deactivated`),
KEY `art_id` (`art_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_articles`
--
CREATE TABLE IF NOT EXISTS `shop_articles` (
`id` int(11) NOT NULL auto_increment,
`detail_topic` varchar(255) NOT NULL default '',
`artgroup_id` int(11) NOT NULL default '0',
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
`included_VAT` float NOT NULL default '16',
`tax_class` varchar(255) NOT NULL default '',
`catch_line` varchar(80) default NULL,
`summary` varchar(80) default NULL,
`text` text NOT NULL,
`image1` varchar(255) default NULL,
`image2` varchar(255) default NULL,
`image3` varchar(255) default NULL,
`image4` varchar(255) default NULL,
`image5` varchar(255) default NULL,
`deactivated` enum('0','1') NOT NULL default '0',
`textFreeoption1` varchar(80) default NULL,
`textFreeoption2` varchar(80) default NULL,
`textFreeoption3` varchar(80) default NULL,
`manufacturer` varchar(80) default NULL,
`manufacturer_link` varchar(255) default NULL,
`pos` int(11) NOT NULL default '0',
`detail_template` varchar(255) NOT NULL default '',
`textFreeoption4` varchar(80) NOT NULL default '',
`textFreeoption5` varchar(80) NOT NULL default '',
`optionsorter` tinytext NOT NULL,
`optiongroup` tinytext NOT NULL,
`variables` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `deactivated` (`deactivated`),
KEY `artgroup_id` (`artgroup_id`)
) TYPE=MyISAM AUTO_INCREMENT=1564 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_basket`
--
CREATE TABLE IF NOT EXISTS `shop_basket` (
`id` int(8) NOT NULL auto_increment,
`user_id` int(8) NOT NULL default '0',
`session_id` varchar(42) NOT NULL default '0',
`data` text NOT NULL,
`status` enum('enabled','disabled') NOT NULL default 'enabled',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=173 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_bills`
--
CREATE TABLE IF NOT EXISTS `shop_bills` (
`id` int(11) NOT NULL auto_increment,
`generated` timestamp(14) NOT NULL,
`bill_date` timestamp(14) NOT NULL default '00000000000000',
`orderID` int(11) NOT NULL default '0',
`data` longtext NOT NULL,
`status` enum('empty','complete','partly') NOT NULL default 'empty',
`bill_status` enum('active','canceled','archive') NOT NULL default 'active',
`payment` enum('paid','unpaid') NOT NULL default 'unpaid',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_bills_sum`
--
CREATE TABLE IF NOT EXISTS `shop_bills_sum` (
`id` int(11) NOT NULL auto_increment,
`generated` timestamp(14) NOT NULL,
`bill_date` timestamp(14) NOT NULL default '00000000000000',
`data` text NOT NULL,
`detail_data` text NOT NULL,
`status` enum('empty','complete','partly') NOT NULL default 'empty',
`bill_status` enum('active','canceled','archive') NOT NULL default 'active',
`payment` enum('paid','unpaid') NOT NULL default 'unpaid',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_bills_sum_ref`
--
CREATE TABLE IF NOT EXISTS `shop_bills_sum_ref` (
`order_id` int(8) NOT NULL default '0',
`shop_bills_sum_id` int(8) NOT NULL default '0',
PRIMARY KEY (`order_id`,`shop_bills_sum_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_campaigns`
--
CREATE TABLE IF NOT EXISTS `shop_campaigns` (
`id` int(11) NOT NULL auto_increment,
`artoption_id` int(11) NOT NULL default '0',
`comment` text,
`campaign_price` float NOT NULL default '0',
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime default NULL,
`quantity_rest` int(11) default NULL,
`total_orders` int(11) NOT NULL default '0',
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
`deactivated` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `artoption_id` (`artoption_id`),
KEY `startdate` (`startdate`),
KEY `enddate` (`enddate`),
KEY `quantity_rest` (`quantity_rest`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_cashed`
--
CREATE TABLE IF NOT EXISTS `shop_cashed` (
`id` int(8) NOT NULL auto_increment,
`user_id` int(8) NOT NULL default '0',
`session_id` varchar(64) NOT NULL default '',
`basket_id` int(8) NOT NULL default '0',
`order_id` int(8) NOT NULL default '0',
`datum` datetime NOT NULL default '0000-00-00 00:00:00',
`type` set('coupon','gutschein') NOT NULL default '',
`discount_price` float NOT NULL default '0',
`code` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_constants`
--
CREATE TABLE IF NOT EXISTS `shop_constants` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`dynamic` enum('0','1') NOT NULL default '0',
`dependent_on` enum('price','weight','volume','dimension') NOT NULL default 'weight',
`min_price` float default NULL,
`max_price` float default NULL,
`min_weight` float default NULL,
`max_weight` float default NULL,
`min_volume` float default NULL,
`max_volume` float default NULL,
`max_width_dimension` float default NULL,
`max_height_dimension` float default NULL,
`max_depth_dimension` float default NULL,
`price` float NOT NULL default '0',
`region_1` float NOT NULL default '0',
`region_2` float NOT NULL default '0',
`region_3` float NOT NULL default '0',
`region_4` float NOT NULL default '0',
`region_5` float NOT NULL default '0',
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `min_price` (`min_price`),
KEY `max_price` (`max_price`),
KEY `min_weight` (`min_weight`),
KEY `max_weight` (`max_weight`),
KEY `min_volume` (`min_volume`),
KEY `max_volume` (`max_volume`),
KEY `max_width_dimension` (`max_width_dimension`),
KEY `max_depth_dimension` (`max_depth_dimension`),
KEY `max_depth_dimension_2` (`max_depth_dimension`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_constants_price`
--
CREATE TABLE IF NOT EXISTS `shop_constants_price` (
`id` int(11) NOT NULL auto_increment,
`constant_id` int(11) NOT NULL default '0',
`region` varchar(255) NOT NULL default '',
`price` float NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `constant_id` (`constant_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_coupon`
--
CREATE TABLE IF NOT EXISTS `shop_coupon` (
`id` int(8) NOT NULL auto_increment,
`fromDate` datetime NOT NULL default '0000-00-00 00:00:00',
`toDate` datetime NOT NULL default '0000-00-00 00:00:00',
`max_user_quantity` int(8) NOT NULL default '0',
`max_system_quantity` int(8) NOT NULL default '0',
`rule_percent` float NOT NULL default '0',
`rule_price` float NOT NULL default '0',
`status` set('enabled','disabled') NOT NULL default '',
`user_id` int(8) NOT NULL default '0',
`code` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_coupon_option`
--
CREATE TABLE IF NOT EXISTS `shop_coupon_option` (
`id` int(8) NOT NULL auto_increment,
`coupon_id` int(8) NOT NULL default '0',
`option_id` int(8) NOT NULL default '0',
`rule_percent` float NOT NULL default '0',
`rule_price` float NOT NULL default '0',
`min_quantity` int(8) NOT NULL default '0',
`max_quantity` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_coupon_role`
--
CREATE TABLE IF NOT EXISTS `shop_coupon_role` (
`coupon_id` int(8) NOT NULL default '0',
`role_id` int(8) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_discount`
--
CREATE TABLE IF NOT EXISTS `shop_discount` (
`id` int(11) NOT NULL auto_increment,
`update_date` timestamp(14) NOT NULL,
`insert_date` timestamp(14) NOT NULL default '00000000000000',
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_discount_values`
--
CREATE TABLE IF NOT EXISTS `shop_discount_values` (
`id` int(11) NOT NULL auto_increment,
`update_date` timestamp(14) NOT NULL,
`insert_date` timestamp(14) NOT NULL default '00000000000000',
`discount_from` int(11) NOT NULL default '0',
`discount_to` int(11) NOT NULL default '0',
`sign` varchar(255) NOT NULL default '',
`discount` float NOT NULL default '0',
`discount_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `discount_id` (`discount_id`,`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_gutschein`
--
CREATE TABLE IF NOT EXISTS `shop_gutschein` (
`id` int(8) NOT NULL auto_increment,
`code` varchar(32) NOT NULL default '',
`price` float NOT NULL default '0',
`toDate` timestamp(14) NOT NULL,
`order_id` int(8) NOT NULL default '0',
`status` set('enabled','disabled') NOT NULL default '',
`user_id` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_import`
--
CREATE TABLE IF NOT EXISTS `shop_import` (
`id` int(11) NOT NULL auto_increment,
`import_session` int(11) NOT NULL default '0',
`php_session` varchar(32) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`host` varchar(80) NOT NULL default '',
`time` timestamp(14) NOT NULL,
`art_id` int(11) NOT NULL default '0',
`image_novalues` int(11) NOT NULL default '0',
`image_errors` int(11) NOT NULL default '0',
`filename` varchar(80) NOT NULL default '',
`image` varchar(80) NOT NULL default '',
`line` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_merkliste`
--
CREATE TABLE IF NOT EXISTS `shop_merkliste` (
`id` int(8) NOT NULL auto_increment,
`basket_id` int(8) NOT NULL default '0',
`user_id` int(8) NOT NULL default '0',
`session_id` varchar(64) NOT NULL default '',
`name` varchar(250) NOT NULL default '',
`status` set('enabled','disabled') NOT NULL default '',
`saveable` int(8) NOT NULL default '1',
`active` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=173 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_merkliste_role`
--
CREATE TABLE IF NOT EXISTS `shop_merkliste_role` (
`merkliste_id` int(8) NOT NULL default '0',
`role_id` int(8) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_option_discount`
--
CREATE TABLE IF NOT EXISTS `shop_option_discount` (
`option_id` bigint(20) NOT NULL default '0',
`discount_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`option_id`,`discount_id`),
UNIQUE KEY `option_id` (`option_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_order_inbox`
--
CREATE TABLE IF NOT EXISTS `shop_order_inbox` (
`ordered` timestamp(14) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`data` text NOT NULL,
`payment` enum('unpaid','paid') NOT NULL default 'unpaid',
`status` enum('new','mail','mail_part','back','in process','archive','trash','pending') NOT NULL default 'new',
`comment` text NOT NULL,
`comment_intern` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_ordered_art`
--
CREATE TABLE IF NOT EXISTS `shop_ordered_art` (
`id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`artoption_id` int(11) NOT NULL default '0',
`campaign_id` int(11) default NULL,
`code` varchar(20) NOT NULL default '',
`name` varchar(80) NOT NULL default '',
`textFreeoption1` varchar(80) default NULL,
`textFreeoption2` varchar(80) default NULL,
`textFreeoption3` varchar(80) default NULL,
`freeoption1` varchar(80) default NULL,
`freeoption2` varchar(80) default NULL,
`freeoption3` varchar(80) default NULL,
`manufacturer` varchar(80) default NULL,
`quantity` int(11) NOT NULL default '0',
`EK` float NOT NULL default '0',
`price` float NOT NULL default '0',
`campaign_price` float NOT NULL default '0',
`included_VAT` float NOT NULL default '16',
`after_VAT_sum` float NOT NULL default '0',
`supplied` enum('0','1') NOT NULL default '0',
`supplied_date` datetime default NULL,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `artoption_id` (`artoption_id`),
KEY `campaign_id` (`campaign_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_orders`
--
CREATE TABLE IF NOT EXISTS `shop_orders` (
`id` int(11) NOT NULL auto_increment,
`order_code` varchar(20) NOT NULL default '',
`order_date` datetime NOT NULL default '0000-00-00 00:00:00',
`customer_id` int(11) NOT NULL default '0',
`company` varchar(255) default NULL,
`salutation` varchar(20) NOT NULL default '',
`firstname` varchar(80) NOT NULL default '',
`lastname` varchar(80) NOT NULL default '',
`adress` varchar(255) NOT NULL default '',
`postal` varchar(20) NOT NULL default '',
`city` varchar(80) NOT NULL default '',
`nation` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`payment` varchar(20) NOT NULL default '',
`BAN` varchar(20) NOT NULL default '',
`BIC` varchar(20) NOT NULL default '',
`Bank` varchar(80) NOT NULL default '',
`BAN_owner` varchar(80) NOT NULL default '',
`befor_discount_sum` float NOT NULL default '0',
`discount` float NOT NULL default '0',
`discount_sum` float NOT NULL default '0',
`after_discount_sum` float NOT NULL default '0',
`postal_charges` float NOT NULL default '0',
`package_charges` float NOT NULL default '0',
`insurance_charges` float NOT NULL default '0',
`befor_VAT_sum` float NOT NULL default '0',
`VAT1` float NOT NULL default '0',
`VAT1_sum` float NOT NULL default '0',
`VAT2` float NOT NULL default '0',
`VAT2_sum` float NOT NULL default '0',
`after_VAT_sum` float NOT NULL default '0',
`paid` enum('0','1') NOT NULL default '0',
`paid_date` datetime default NULL,
`changed` timestamp(14) NOT NULL,
`status` enum('new','processed','stopped','mail','back') NOT NULL default 'new',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `customer_id` (`customer_id`),
KEY `paid` (`paid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_payment`
--
CREATE TABLE IF NOT EXISTS `shop_payment` (
`name` varchar(100) NOT NULL default '',
`region` varchar(255) NOT NULL default '',
`price` float NOT NULL default '0',
`requestFields` text NOT NULL,
UNIQUE KEY `name` (`name`,`region`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_payment_assignment`
--
CREATE TABLE IF NOT EXISTS `shop_payment_assignment` (
`id` int(11) NOT NULL auto_increment,
`provider_id` int(11) NOT NULL default '0',
`payment_name` varchar(255) NOT NULL default '',
`settings` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_payment_provider`
--
CREATE TABLE IF NOT EXISTS `shop_payment_provider` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`settings` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_queries`
--
CREATE TABLE IF NOT EXISTS `shop_queries` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`query` text NOT NULL,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_ratings`
--
CREATE TABLE IF NOT EXISTS `shop_ratings` (
`id` int(11) NOT NULL auto_increment,
`art_id` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`firstname` varchar(80) default NULL,
`lastname` varchar(80) default NULL,
`email` varchar(80) default NULL,
`status` varchar(80) default NULL,
`short` varchar(80) NOT NULL default '',
`comment` text NOT NULL,
`rating` int(1) NOT NULL default '0',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `art_id` (`art_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_region`
--
CREATE TABLE IF NOT EXISTS `shop_region` (
`region_key` varchar(10) NOT NULL default '',
`language` varchar(10) NOT NULL default '',
`countries` text NOT NULL,
`currency_symbol` varchar(10) NOT NULL default '',
`currency_code` varchar(255) NOT NULL default '',
`exchange_ratio` float NOT NULL default '1',
`decimal_separator` varchar(5) NOT NULL default '.',
PRIMARY KEY (`region_key`,`language`),
FULLTEXT KEY `countries` (`countries`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_role_discount`
--
CREATE TABLE IF NOT EXISTS `shop_role_discount` (
`id` int(11) NOT NULL auto_increment,
`update_date` timestamp(14) NOT NULL,
`insert_date` timestamp(14) NOT NULL default '00000000000000',
`name` varchar(255) NOT NULL default '',
`desc` text NOT NULL,
`discount` float NOT NULL default '0',
`role` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_tax`
--
CREATE TABLE IF NOT EXISTS `shop_tax` (
`id` int(11) NOT NULL auto_increment,
`taxnr` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`region` varchar(255) NOT NULL default '',
`tax` float NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_texts`
--
CREATE TABLE IF NOT EXISTS `shop_texts` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(50) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`status` enum('enabled','pending','disabled') NOT NULL default 'disabled',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `site` (`site`),
KEY `lang` (`lang`,`relation`,`relation_id`),
KEY `relation` (`relation`),
KEY `relation_id` (`relation_id`),
FULLTEXT KEY `volltext` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=8676 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_topic_article`
--
CREATE TABLE IF NOT EXISTS `shop_topic_article` (
`id` int(8) NOT NULL auto_increment,
`article_id` bigint(20) NOT NULL default '0',
`topic` varchar(255) NOT NULL default '',
`pos` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `article_id_2` (`article_id`),
KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=12192 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_topic_article_cs`
--
CREATE TABLE IF NOT EXISTS `shop_topic_article_cs` (
`id` int(8) NOT NULL auto_increment,
`article_id` bigint(20) NOT NULL default '0',
`topic` varchar(255) NOT NULL default '',
`pos` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `article_id` (`article_id`),
KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `shop_user`
--
CREATE TABLE IF NOT EXISTS `shop_user` (
`email` varchar(255) NOT NULL default '',
`birthday` varchar(20) NOT NULL default '',
`additional` varchar(255) default NULL,
`address` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`phone` varchar(50) NOT NULL default '',
`fax` varchar(50) default NULL,
PRIMARY KEY (`email`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `snippets`
--
CREATE TABLE IF NOT EXISTS `snippets` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`html` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `texts`
--
CREATE TABLE IF NOT EXISTS `texts` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(255) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`in_process` varchar(10) NOT NULL default '',
`in_process_start` timestamp(14) NOT NULL default '00000000000000',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `site` (`site`),
KEY `lang` (`lang`,`relation`,`relation_id`),
KEY `relation` (`relation`),
KEY `relation_id` (`relation_id`),
FULLTEXT KEY `volltext` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `txtbackup`
--
CREATE TABLE IF NOT EXISTS `txtbackup` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(50) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`status` enum('enabled','pending','disabled') NOT NULL default 'disabled',
`user_id` int(11) default NULL,
`ean` varchar(20) NOT NULL default '',
`artname` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=73 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyArea`
--
CREATE TABLE IF NOT EXISTS `tyArea` (
`id` bigint(20) NOT NULL auto_increment,
`relation_id` int(8) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`topic` varchar(255) NOT NULL default '',
`area_id` varchar(255) NOT NULL default '',
`variables` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`snippet_id` bigint(20) NOT NULL default '0',
`language` text NOT NULL,
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`user_id` int(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `area_id` (`area_id`),
KEY `topic` (`topic`),
KEY `relation_id` (`relation_id`,`status`)
) TYPE=MyISAM AUTO_INCREMENT=8558 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyArea_snippet`
--
CREATE TABLE IF NOT EXISTS `tyArea_snippet` (
`id` bigint(20) NOT NULL auto_increment,
`relation_id` int(8) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`src` text NOT NULL,
`customized_src` text NOT NULL,
`privs_user` text NOT NULL,
`variables` text NOT NULL,
`variables_inc` text NOT NULL,
`php` enum('enabled','disabled') NOT NULL default 'disabled',
`status` enum('enabled','disabled') NOT NULL default 'disabled',
PRIMARY KEY (`id`),
KEY `relation_id` (`relation_id`,`status`)
) TYPE=MyISAM AUTO_INCREMENT=2073 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyArea_snippet_set`
--
CREATE TABLE IF NOT EXISTS `tyArea_snippet_set` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`template` varchar(255) NOT NULL default '',
`topic` varchar(255) NOT NULL default '',
`rubrik` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyBanner`
--
CREATE TABLE IF NOT EXISTS `tyBanner` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
`type` enum('image','code','flash') NOT NULL default 'image',
`link` varchar(255) NOT NULL default '',
`link_target` enum('_self','_blank') NOT NULL default '_blank',
`link_alt` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`user_id` varchar(255) NOT NULL default '',
`code` text NOT NULL,
`text` text NOT NULL,
`flash` text NOT NULL,
`width` int(8) NOT NULL default '0',
`height` int(8) NOT NULL default '0',
`clicks` int(8) NOT NULL default '0',
`views` int(8) NOT NULL default '0',
`show_percentage` float NOT NULL default '0.5',
`everywhere` int(2) NOT NULL default '1',
`status` enum('enabled','disabled') NOT NULL default 'disabled',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyBannerDuration`
--
CREATE TABLE IF NOT EXISTS `tyBannerDuration` (
`banner_id` int(8) NOT NULL default '0',
`id` int(8) NOT NULL auto_increment,
`start` datetime default NULL,
`end` datetime default '0000-00-00 00:00:00',
`clicks` int(8) NOT NULL default '0',
`views` int(8) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyBannerLog`
--
CREATE TABLE IF NOT EXISTS `tyBannerLog` (
`id` int(8) NOT NULL auto_increment,
`banner_id` int(8) NOT NULL default '0',
`ip` varchar(32) NOT NULL default '',
`log_time` timestamp(14) NOT NULL,
`typ` enum('click','view') NOT NULL default 'click',
`topic` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyBannerTopic`
--
CREATE TABLE IF NOT EXISTS `tyBannerTopic` (
`banner_id` int(8) NOT NULL default '0',
`topic` varchar(128) NOT NULL default '',
`template_id` varchar(128) NOT NULL default ''
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyClients`
--
CREATE TABLE IF NOT EXISTS `tyClients` (
`id` int(10) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`subdomain` varchar(255) NOT NULL default '',
`db_type` varchar(255) NOT NULL default '',
`db_host` varchar(255) NOT NULL default '',
`db_name` varchar(255) NOT NULL default '',
`db_user` varchar(255) NOT NULL default '',
`db_pwd` varchar(20) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`user_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyDBLangRel`
--
CREATE TABLE IF NOT EXISTS `tyDBLangRel` (
`id` int(11) NOT NULL auto_increment,
`table` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=152 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyFiles`
--
CREATE TABLE IF NOT EXISTS `tyFiles` (
`id` bigint(20) NOT NULL auto_increment,
`update_date` timestamp(14) NOT NULL,
`insert_date` timestamp(14) NOT NULL default '00000000000000',
`title` varchar(255) NOT NULL default '',
`filetype` varchar(100) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`infotext` varchar(50) NOT NULL default '',
`longinfo` varchar(255) NOT NULL default '',
`size` int(20) NOT NULL default '0',
`categories_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
PRIMARY KEY (`id`),
KEY `categories_id` (`categories_id`)
) TYPE=MyISAM AUTO_INCREMENT=233 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyFilesCategories`
--
CREATE TABLE IF NOT EXISTS `tyFilesCategories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`relation_id` int(11) default NULL,
`nix` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=27 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyFormManager`
--
CREATE TABLE IF NOT EXISTS `tyFormManager` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`category` varchar(100) NOT NULL default '',
`method` enum('get','post') NOT NULL default 'post',
`action` text,
`structure` text,
`dbTable` varchar(255) NOT NULL default '',
`mail_template` varchar(255) default NULL,
`mail_subject` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyFormManagerForms`
--
CREATE TABLE IF NOT EXISTS `tyFormManagerForms` (
`id` int(11) NOT NULL auto_increment,
`form_id` int(11) NOT NULL default '0',
`template_id` varchar(255) NOT NULL default '0',
`topic` varchar(255) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyFormManagerMail`
--
CREATE TABLE IF NOT EXISTS `tyFormManagerMail` (
`id` int(10) unsigned NOT NULL auto_increment,
`form_id` int(11) unsigned NOT NULL default '0',
`template` varchar(255) NOT NULL default '',
`subject` varchar(255) default NULL,
`sender` varchar(255) default NULL,
`recipient` varchar(255) default NULL,
`recipient_dbfield` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyGlobalTags`
--
CREATE TABLE IF NOT EXISTS `tyGlobalTags` (
`tag_id` varchar(100) NOT NULL default '',
`tag_topic` varchar(255) NOT NULL default '',
`tag_type` varchar(100) NOT NULL default '',
`tag_default` text NOT NULL,
`site_topic` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
UNIQUE KEY `tag_id` (`tag_id`,`tag_topic`,`tag_type`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyImageButton`
--
CREATE TABLE IF NOT EXISTS `tyImageButton` (
`id` int(11) NOT NULL auto_increment,
`topic` varchar(255) NOT NULL default '',
`template_id` varchar(255) NOT NULL default '',
`caption` varchar(255) NOT NULL default '',
`alt` varchar(255) NOT NULL default '',
`fontSize` char(3) NOT NULL default '',
`startX` char(3) NOT NULL default '',
`startY` char(3) NOT NULL default '',
`language` varchar(100) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
`user_id` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2540 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyKeywords`
--
CREATE TABLE IF NOT EXISTS `tyKeywords` (
`id` int(11) NOT NULL auto_increment,
`lang` varchar(10) NOT NULL default 'de',
`keyword` varchar(255) NOT NULL default '',
`keywordNormal` varchar(255) NOT NULL default '',
`modul` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `langKey` (`lang`,`keyword`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyKeywordsTopics`
--
CREATE TABLE IF NOT EXISTS `tyKeywordsTopics` (
`topic` varchar(233) NOT NULL default '0',
`keyword_id` int(11) NOT NULL default '0',
`modul` varchar(128) NOT NULL default 'navigation',
PRIMARY KEY (`topic`,`keyword_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyLog`
--
CREATE TABLE IF NOT EXISTS `tyLog` (
`id` int(11) NOT NULL auto_increment,
`date` timestamp(14) NOT NULL,
`modul` varchar(255) NOT NULL default '',
`action` varchar(255) NOT NULL default '',
`values` longtext NOT NULL,
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyMailText`
--
CREATE TABLE IF NOT EXISTS `tyMailText` (
`id` int(11) NOT NULL auto_increment,
`lang` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default 'ascii',
`name` varchar(255) NOT NULL default '',
`text` text NOT NULL,
`date` timestamp(14) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyMessages`
--
CREATE TABLE IF NOT EXISTS `tyMessages` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(50) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `site` (`site`),
KEY `lang` (`lang`,`relation`),
KEY `relation` (`relation`),
FULLTEXT KEY `volltext` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyNews`
--
CREATE TABLE IF NOT EXISTS `tyNews` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`topic` varchar(200) NOT NULL default '',
`date` timestamp(14) NOT NULL,
`title` varchar(200) NOT NULL default '',
`subject` text NOT NULL,
`text` text NOT NULL,
`language` varchar(100) NOT NULL default 'de',
`picture` varchar(200) NOT NULL default '',
`status` enum('enabled','disabled') NOT NULL default 'enabled',
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyNewsletter_history`
--
CREATE TABLE IF NOT EXISTS `tyNewsletter_history` (
`id` int(11) NOT NULL auto_increment,
`date` timestamp(14) NOT NULL,
`sentdate` timestamp(14) NOT NULL default '00000000000000',
`name` varchar(200) NOT NULL default '',
`subject` varchar(200) NOT NULL default '',
`text` text NOT NULL,
`status` varchar(255) NOT NULL default 'sent',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyNewsletter_sentto`
--
CREATE TABLE IF NOT EXISTS `tyNewsletter_sentto` (
`id` int(11) NOT NULL auto_increment,
`date` timestamp(14) NOT NULL,
`usertable` varchar(100) NOT NULL default '',
`usertable_id` int(11) NOT NULL default '0',
`history_id` int(11) NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `history_id` (`history_id`),
KEY `usertable_id` (`usertable_id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyNewsletter_statistic`
--
CREATE TABLE IF NOT EXISTS `tyNewsletter_statistic` (
`id` int(11) NOT NULL auto_increment,
`date_last_opened` timestamp(14) NOT NULL,
`date_first_opened` timestamp(14) NOT NULL default '00000000000000',
`date_send` timestamp(14) NOT NULL default '00000000000000',
`newsletter` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`count` int(11) NOT NULL default '1',
`history_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `history_id` (`history_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyPartner`
--
CREATE TABLE IF NOT EXISTS `tyPartner` (
`id` int(11) NOT NULL auto_increment,
`partner` varchar(80) NOT NULL default '',
`partner_street` varchar(80) NOT NULL default '',
`partner_plz` varchar(5) NOT NULL default '',
`partner_city` varchar(80) NOT NULL default '',
`partner_home` varchar(255) NOT NULL default '',
`partner_mail` varchar(80) NOT NULL default '',
`partner_phone` varchar(20) NOT NULL default '',
`partner_fax` varchar(20) NOT NULL default '',
`ASP1_name` varchar(80) NOT NULL default '',
`ASP1_mail` varchar(80) NOT NULL default '',
`ASP1_phone` varchar(20) NOT NULL default '',
`ASP2_name` varchar(80) NOT NULL default '',
`ASP2_mail` varchar(80) NOT NULL default '',
`ASP2_phone` varchar(20) NOT NULL default '',
`login_email` varchar(255) NOT NULL default '',
`login_passwort` varchar(255) NOT NULL default '',
`login_admin_email` varchar(255) NOT NULL default '',
`login_admin_passwort` varchar(255) NOT NULL default '',
`text` text NOT NULL,
`lang` varchar(20) NOT NULL default '',
`changed` timestamp(14) NOT NULL,
`status` enum('enabled','disabled') NOT NULL default 'enabled',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyPkey`
--
CREATE TABLE IF NOT EXISTS `tyPkey` (
`table_name` varchar(255) NOT NULL default '',
`pkey_value` int(8) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyRecentTexts`
--
CREATE TABLE IF NOT EXISTS `tyRecentTexts` (
`texts_id` int(11) default NULL
) TYPE=HEAP;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyShopCompanyData`
--
CREATE TABLE IF NOT EXISTS `tyShopCompanyData` (
`id` int(11) NOT NULL auto_increment,
`company` varchar(100) NOT NULL default '',
`adress1` varchar(100) NOT NULL default '',
`adress2` varchar(100) NOT NULL default '',
`zipcode` varchar(10) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`country` varchar(100) NOT NULL default '',
`website` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`bank` varchar(100) NOT NULL default '',
`blz` varchar(100) NOT NULL default '',
`swift_bic` varchar(100) NOT NULL default '',
`iban` varchar(100) NOT NULL default '',
`account` varchar(100) NOT NULL default '',
`bank2` varchar(100) NOT NULL default '',
`blz2` varchar(100) NOT NULL default '',
`swift_bic2` varchar(100) NOT NULL default '',
`iban2` varchar(100) NOT NULL default '',
`account2` varchar(100) NOT NULL default '',
`court_site` varchar(100) NOT NULL default '',
`court_number` varchar(100) NOT NULL default '',
`manager` varchar(100) NOT NULL default '',
`sales_tax_id` varchar(100) NOT NULL default '',
`tax_nr` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyShopTexts`
--
CREATE TABLE IF NOT EXISTS `tyShopTexts` (
`id` int(11) NOT NULL auto_increment,
`lang` varchar(255) NOT NULL default '',
`template` varchar(255) NOT NULL default '',
`text` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`date` timestamp(14) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySignSession`
--
CREATE TABLE IF NOT EXISTS `tySignSession` (
`ip` varchar(15) NOT NULL default '',
`browser` varchar(255) default NULL,
`created` timestamp(14) NOT NULL,
`signkey` varchar(20) NOT NULL default ''
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUser`
--
CREATE TABLE IF NOT EXISTS `tySiteUser` (
`tySiteUserId` int(11) NOT NULL auto_increment,
`salutation` varchar(255) NOT NULL default '',
`firstname` varchar(200) NOT NULL default '',
`lastname` varchar(200) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`email` varchar(200) NOT NULL default '',
`password` varchar(200) NOT NULL default '',
`group` varchar(255) NOT NULL default '',
`privs` text NOT NULL,
`free_definitions` text NOT NULL,
`lastchange` timestamp(14) NOT NULL,
`lastlogin` timestamp(14) NOT NULL default '00000000000000',
`signdate` timestamp(14) NOT NULL default '00000000000000',
`status` enum('online','offline','ratification') NOT NULL default 'online',
`lang` varchar(255) default 'de',
PRIMARY KEY (`tySiteUserId`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserAction`
--
CREATE TABLE IF NOT EXISTS `tySiteUserAction` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=94 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserFormError`
--
CREATE TABLE IF NOT EXISTS `tySiteUserFormError` (
`id` int(11) NOT NULL auto_increment,
`lang` varchar(10) NOT NULL default 'de',
`title` varchar(255) NOT NULL default '',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserLog`
--
CREATE TABLE IF NOT EXISTS `tySiteUserLog` (
`id` int(10) unsigned NOT NULL auto_increment,
`session_id` varchar(32) NOT NULL default '',
`subject_id` int(10) unsigned NOT NULL default '0',
`log_typ` varchar(255) NOT NULL default '',
`modul_name` varchar(255) NOT NULL default '',
`resource_name` varchar(255) NOT NULL default '',
`action_name` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`log_time` timestamp(14) NOT NULL,
PRIMARY KEY (`id`),
KEY `session_subject_index` (`session_id`,`subject_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserModule`
--
CREATE TABLE IF NOT EXISTS `tySiteUserModule` (
`id` int(11) NOT NULL auto_increment,
`version` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=180 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserPolicy`
--
CREATE TABLE IF NOT EXISTS `tySiteUserPolicy` (
`id` int(10) unsigned NOT NULL auto_increment,
`resources_ID` int(10) unsigned NOT NULL default '0',
`action_id` int(10) unsigned NOT NULL default '0',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`,`resources_ID`,`action_id`),
KEY `Policy_FKIndex1` (`resources_ID`),
KEY `Policy_FKIndex2` (`action_id`)
) TYPE=MyISAM AUTO_INCREMENT=583 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserPolicySet`
--
CREATE TABLE IF NOT EXISTS `tySiteUserPolicySet` (
`role_id` int(10) unsigned NOT NULL default '0',
`policy_id` int(10) unsigned NOT NULL default '0',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`role_id`,`policy_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserRessource`
--
CREATE TABLE IF NOT EXISTS `tySiteUserRessource` (
`id` int(10) unsigned NOT NULL auto_increment,
`modul_id` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`typ` varchar(255) NOT NULL default '',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `resources_FKIndex1` (`modul_id`)
) TYPE=MyISAM AUTO_INCREMENT=415 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserRole`
--
CREATE TABLE IF NOT EXISTS `tySiteUserRole` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`maxusers` int(11) NOT NULL default '-1',
`roletype` varchar(250) NOT NULL default '',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserRoleCache`
--
CREATE TABLE IF NOT EXISTS `tySiteUserRoleCache` (
`role_id` int(8) NOT NULL default '0',
`cache` mediumblob NOT NULL,
UNIQUE KEY `role_id` (`role_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserRoleParentChild`
--
CREATE TABLE IF NOT EXISTS `tySiteUserRoleParentChild` (
`parent_role_id` int(10) unsigned NOT NULL default '0',
`child_role_id` int(10) unsigned NOT NULL default '0',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`parent_role_id`,`child_role_id`),
KEY `rolle_has_rolle_FKIndex1` (`parent_role_id`),
KEY `rolle_has_rolle_FKIndex2` (`child_role_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserRoleRef`
--
CREATE TABLE IF NOT EXISTS `tySiteUserRoleRef` (
`role_id` int(10) unsigned NOT NULL default '0',
`subject_id` int(10) unsigned NOT NULL default '0',
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`role_id`,`subject_id`),
KEY `subject_has_rolle_FKIndex1` (`subject_id`),
KEY `subject_has_rolle_FKIndex2` (`role_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserSubject`
--
CREATE TABLE IF NOT EXISTS `tySiteUserSubject` (
`id` int(10) unsigned NOT NULL auto_increment,
`email` varchar(100) NOT NULL default '',
`passwort` varchar(100) NOT NULL default '',
`privs` text NOT NULL,
`verified` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `subject_index` (`email`,`passwort`)
) TYPE=MyISAM AUTO_INCREMENT=898 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tySiteUserSubjectAttribute`
--
CREATE TABLE IF NOT EXISTS `tySiteUserSubjectAttribute` (
`subject_id` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`verified` varchar(40) NOT NULL default '',
KEY `subject_attribute_FKIndex1` (`subject_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyStatistic`
--
CREATE TABLE IF NOT EXISTS `tyStatistic` (
`id` int(8) NOT NULL auto_increment,
`template` varchar(128) NOT NULL default '',
`topic` varchar(128) NOT NULL default '',
`get` text NOT NULL,
`referer` varchar(128) NOT NULL default '',
`session` varchar(32) NOT NULL default '',
`siteroles_id` int(8) NOT NULL default '0',
`remote_ip` varchar(16) NOT NULL default '',
`time` timestamp(14) NOT NULL,
`lang` varchar(12) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8221 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyStatisticArchiv`
--
CREATE TABLE IF NOT EXISTS `tyStatisticArchiv` (
`id` int(8) NOT NULL auto_increment,
`template` varchar(128) NOT NULL default '',
`topic` varchar(128) NOT NULL default '',
`get` text NOT NULL,
`referer` varchar(128) NOT NULL default '',
`session` varchar(32) NOT NULL default '',
`siteroles_id` int(8) NOT NULL default '0',
`remote_ip` varchar(16) NOT NULL default '',
`time` timestamp(14) NOT NULL,
`lang` varchar(12) NOT NULL default '',
`name` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyTexts`
--
CREATE TABLE IF NOT EXISTS `tyTexts` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(255) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`in_process` varchar(10) NOT NULL default '',
`in_process_start` timestamp(14) NOT NULL default '00000000000000',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `site` (`site`),
KEY `lang` (`lang`,`relation`,`relation_id`),
KEY `relation` (`relation`),
KEY `relation_id` (`relation_id`),
FULLTEXT KEY `volltext` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=13988 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyTextsArchive`
--
CREATE TABLE IF NOT EXISTS `tyTextsArchive` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`lang` varchar(10) NOT NULL default 'de',
`datum` timestamp(14) NOT NULL,
`text` text,
`relation` varchar(255) NOT NULL default '',
`relation_id` int(11) NOT NULL default '0',
`comment` text,
`status` enum('enabled','disabled') NOT NULL default 'disabled',
`in_process` varchar(10) NOT NULL default '',
`in_process_start` timestamp(14) NOT NULL default '00000000000000',
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `site` (`site`),
KEY `lang` (`lang`,`relation`,`relation_id`),
KEY `relation` (`relation`),
KEY `relation_id` (`relation_id`),
FULLTEXT KEY `volltext` (`text`)
) TYPE=MyISAM AUTO_INCREMENT=969 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tyVisitors`
--
CREATE TABLE IF NOT EXISTS `tyVisitors` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(80) NOT NULL default '',
`deactivated` enum('0','1') NOT NULL default '0',
`BIC` varchar(20) NOT NULL default '',
`Bank` varchar(80) default NULL,
`BAN` varchar(20) NOT NULL default '',
`BAN_owner` varchar(80) NOT NULL default '',
`payment` enum('bill','cod','prepay','elv') NOT NULL default 'cod',
`company` varchar(255) default NULL,
`salutation` varchar(20) NOT NULL default 'Herr',
`firstname` varchar(80) NOT NULL default '',
`lastname` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`password` varchar(80) NOT NULL default '',
`grp` enum('Interessent','User','Reseller','Partner') default NULL,
`adress` varchar(255) NOT NULL default '',
`city` varchar(80) NOT NULL default '',
`state` varchar(80) default NULL,
`postal` varchar(20) NOT NULL default '',
`country` char(2) NOT NULL default 'GM',
`telephone` varchar(20) default NULL,
`inserted` datetime NOT NULL default '0000-00-00 00:00:00',
`changed` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime default NULL,
`last_order` datetime default NULL,
`discount` float default NULL,
`accept_bill` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`),
KEY `deactivated` (`deactivated`),
KEY `password` (`password`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tymailings`
--
CREATE TABLE IF NOT EXISTS `tymailings` (
`id` int(11) NOT NULL auto_increment,
`update_date` timestamp(14) NOT NULL,
`insert_date` timestamp(14) NOT NULL default '00000000000000',
`recipient` varchar(255) NOT NULL default '',
`sender` varchar(255) NOT NULL default '',
`subject` text NOT NULL,
`template` longtext NOT NULL,
`tag` varchar(255) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=396 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tynav`
--
CREATE TABLE IF NOT EXISTS `tynav` (
`id` int(11) NOT NULL auto_increment,
`site` int(11) NOT NULL default '0',
`date` timestamp(14) NOT NULL,
`structure` longtext NOT NULL,
`status` enum('enabled','pending','disabled') NOT NULL default 'disabled',
PRIMARY KEY (`id`),
KEY `site` (`site`)
) TYPE=MyISAM AUTO_INCREMENT=398 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tysetup`
--
CREATE TABLE IF NOT EXISTS `tysetup` (
`id` int(10) unsigned NOT NULL auto_increment,
`tyvalues` longtext NOT NULL,
`insdate` timestamp(14) NOT NULL,
PRIMARY KEY (`id`),
KEY `insdate` (`insdate`)
) TYPE=MyISAM AUTO_INCREMENT=383 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `user_livestat`
--
CREATE TABLE IF NOT EXISTS `user_livestat` (
`id` int(8) NOT NULL auto_increment,
`session_id` varchar(32) NOT NULL default '',
`role_id` int(8) NOT NULL default '0',
`user_id` int(8) NOT NULL default '0',
`datum` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10025 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`status` set('public','hidden','deleted') NOT NULL default 'hidden',
`login` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`firstname` varchar(100) NOT NULL default '',
`email` varchar(150) NOT NULL default '',
`password` varchar(25) NOT NULL default '',
`newsletter` enum('ja','nein') NOT NULL default 'nein',
`position` varchar(200) NOT NULL default '',
`anrede` enum('Herr','Frau') NOT NULL default 'Frau',
`organisation` varchar(100) NOT NULL default '',
`url` varchar(250) NOT NULL default '',
`profil` text NOT NULL,
`rubrik` set('Beratung','Webdesign','Contentmanagement','Webapplikationsentwicklung') NOT NULL default '',
`aktualisierung` timestamp(14) NOT NULL,
`eintrag` timestamp(14) NOT NULL default '00000000000000',
`kontonummer` varchar(50) NOT NULL default '',
`blz` varchar(50) NOT NULL default '',
`bank` varchar(100) NOT NULL default '',
`adresse` varchar(250) NOT NULL default '',
`plz` varchar(10) NOT NULL default '',
`ort` varchar(100) NOT NULL default '',
`telefon` varchar(100) NOT NULL default '',
`strhnr` varchar(250) NOT NULL default '',
`partner` char(2) NOT NULL default '',
`privs` text,
`chief_id` int(11) default NULL,
`login_last` timestamp(14) NOT NULL default '00000000000000',
`login_count` int(11) NOT NULL default '0',
`phone` varchar(200) NOT NULL default '',
`mobile` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
