196 lines
13 KiB
SQL
196 lines
13 KiB
SQL
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_name', 'COMPANY', '', 'Firmenname');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_legal_form', 'COMPANY', '', 'Rechtsform');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_ustid', 'COMPANY', '', 'USt-IdNr.');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_jurisdiction', 'COMPANY', '', 'Gerichtsstand');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_management', 'COMPANY', '', ' Geschäftführung');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_director', 'COMPANY', '', 'Vorstand');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_directorat', 'COMPANY', '', 'Aufsichtsratsvorsitz');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_register_court', 'COMPANY', '', 'Sitz, Registergericht, Registernummer');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_data_protection_officer', 'COMPANY', '', ' Datenschutzbeauftragte');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_youth_protection_officer', 'COMPANY', '', 'Jugendschutzbeauftragte');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_country', 'COMPANY', '', 'Land');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_street', 'COMPANY', '', 'Straße');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_zip_code', 'COMPANY', '', 'PLZ');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_city', 'COMPANY', '', 'Ort');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_email', 'COMPANY', '', 'E-Mail');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_phone', 'COMPANY', '', 'Telefon');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_fax', 'COMPANY', '', 'Fax');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_website', 'COMPANY', '', 'Webseite');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_bank', 'COMPANY', '', 'Bank');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_bank_number', 'COMPANY', '', 'BLZ');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_account_number', 'COMPANY', '', 'Kto-Nr.');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_iban', 'COMPANY', '', 'IBAN');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('company_swift_bic', 'COMPANY', '', 'SWIFT / BIC');
|
|
|
|
DROP TABLE `words`;
|
|
CREATE TABLE IF NOT EXISTS `text_translation` (
|
|
`var_id` varchar(255) NOT NULL,
|
|
`modul` varchar(255) NOT NULL,
|
|
`text` varchar(255) NOT NULL,
|
|
`text_en` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`var_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `currency` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`iso` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `domains` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`google_site_verification` varchar(255) NOT NULL,
|
|
`google_analytics_code` varchar(255) NOT NULL,
|
|
`standard_theme_id` int(11) NOT NULL,
|
|
`standard_language_id` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_image_size_zoom', 'ITEM', '800', 'Artikel Bildgröße bei Zoom');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_image_size_overview', 'ITEM', '150', 'Artikel Bildgröße bei der Artikelliste');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_image_size_thumb', 'ITEM', '90', 'Artikel Bildgröße für Thumbnails');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_image_size_details', 'ITEM', '330', 'Artikel Bildgröße in der Detailansicht');
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_image_size_detaildefault', 'ITEM', '245', 'Artikel Bildgröße in der standard Detailansicht');
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('show_child_items', 'ITEM', '0', 'Zeige Kinderartikel in der Artikelverwaltung.');
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_customer_opinion', 'ITEM', '0', 'Zeige Artikelbewertung in der Artikeldetailansicht.');
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('default_system_language', 'SYSTEM', 'de', 'Standardsprache des Systems in ISO631-1 (deutsch = de).');
|
|
|
|
CREATE TABLE IF NOT EXISTS `order_dhl` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`order_number` varchar(255) NOT NULL,
|
|
`verfahren` int(11) NOT NULL,
|
|
`produkt` int(11) NOT NULL,
|
|
`services` int(11) NOT NULL,
|
|
`gewicht` varchar(255) NOT NULL,
|
|
`teilnahme` varchar(255) NOT NULL,
|
|
`zollinhaltserklaerung` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('show_item_item_assign2', 'ITEM', '1', 'Zeige Ersatzteile bei Artikel an.');
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('item_list_filter_max_inventory', 'ITEM', '0', 'Spezieller Artikelfilter mit maximaler Lagerbestandszahl.');
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('main_menu_item_clickable', 'SITE_WIDGETS', '1', 'Hauptmenüpunkte sind klickbar');
|
|
|
|
CREATE TABLE IF NOT EXISTS `bills` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`number` varchar(255) NOT NULL,
|
|
`bill_date` date,
|
|
`state_id` tinyint(4) NOT NULL,
|
|
`payment_date` date,
|
|
`payment_state` tinyint(4) NOT NULL,
|
|
`customer` varchar(255) NOT NULL,
|
|
`amount_brutto` DECIMAL( 9, 4 ) NOT NULL,
|
|
`open_amount` DECIMAL( 9, 4 ) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `return_goods` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`return_date` date,
|
|
`state_id` tinyint(4) NOT NULL,
|
|
`customer` varchar(255) NOT NULL,
|
|
`amount_brutto` DECIMAL( 9, 4 ) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('show_shoppingcart_different_items_sum', 'shoppingcart', '0', 'Zeige die Anzahl der unterschiedlichen Artikel an und nicht die Gesamtsumme der Artikel.');
|
|
|
|
ALTER TABLE `site_content` ADD `style` VARCHAR( 255 ) NOT NULL AFTER `activ`;
|
|
UPDATE site_content SET style='h1';
|
|
|
|
ALTER TABLE `structure` ADD `sitemap_activ` tinyint(4) NOT NULL;
|
|
|
|
ALTER TABLE `customer_addresses` ADD `freetextfield1` varchar(255) DEFAULT NULL;
|
|
ALTER TABLE `customer_addresses` ADD `freetextfield2` varchar(255) DEFAULT NULL;
|
|
ALTER TABLE `customer_addresses` ADD `freetextfield3` varchar(255) DEFAULT NULL;
|
|
ALTER TABLE `customer_addresses` ADD `freetextfield4` varchar(255) DEFAULT NULL;
|
|
|
|
ALTER TABLE `customer_groups` ADD COLUMN `customer_number_edit` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0' AFTER `verification_type`;
|
|
|
|
ALTER TABLE `customers` ADD COLUMN `skonto` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
|
|
|
|
ALTER TABLE `countries` ADD COLUMN `customer_ust_id_required` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
|
|
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('guest_order_customer_id', 'text', 'SHOP_SETTINGS', '0', 0, 'Kunden-ID für die Gastbestellung.');
|
|
|
|
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('cashdesk_giftcertificate', 'text', 'CASHDESK', '0', 0, 'Gutscheincode beim Kassengang (1 = an, 0 = aus).');
|
|
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('item_search_not_found_text', 'formated', 'SHOP_TEXT', 'Für den Suchbegriff "[#search_word]" wurden keine Treffer in unserer Datenbank gefunden.', 1, 'Text für die Artikelsuche wenn keine gefunden wurden.');
|
|
|
|
ALTER TABLE `structure` ADD `item_type` int(11) NOT NULL DEFAULT '0';
|
|
|
|
ALTER TABLE `structure` ADD `customer_group` int(11) NOT NULL DEFAULT '0';
|
|
|
|
INSERT INTO `payment_methods` (
|
|
`id` ,
|
|
`name` ,
|
|
`module` ,
|
|
`active` ,
|
|
`rang` ,
|
|
`invoice_text` ,
|
|
`order_text` ,
|
|
`helperjoinkey`
|
|
)
|
|
VALUES (
|
|
NULL , 'Kundenspezifisch', 'customized', '1', '8', 'Kundenspezifisch', '', 'customized'
|
|
);
|
|
|
|
ALTER TABLE `shipping_area` ADD `active_customized` TINYINT( 2 ) NOT NULL AFTER `active_bar`;
|
|
ALTER TABLE `shipping_area` ADD `add_customized` DECIMAL( 9, 2 ) NOT NULL AFTER `add_bar`;
|
|
ALTER TABLE `shipping_area` ADD `account_type_customized` TINYINT( 4 ) NOT NULL AFTER `account_type_bar`;
|
|
|
|
ALTER TABLE `items` ADD `bargain_price_type` TINYINT( 2 ) NOT NULL DEFAULT '0';
|
|
|
|
ALTER TABLE `item_type_definitions` ADD `item_type_definition_type` TINYINT( 2 ) NOT NULL DEFAULT '0';
|
|
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('cash_desk_order_completed', 'formated', 'SHOP_TEXT', 'Ihre Bestellung mit der Bestellnummer <strong>[#order_number]</strong> wurde erfolgreich an uns übermittelt.', 1, 'Text für die Bestellbestätigungsseite.');
|
|
|
|
ALTER TABLE `item_types` ADD `item_type_available_from` DATETIME NULL;
|
|
ALTER TABLE `item_types` ADD `item_type_available_until` DATETIME NULL;
|
|
|
|
INSERT INTO `configuration` (`name`, `group_id`, `setting`, `description`) VALUES ('save_customer_shoppingcart', 'shoppingcart', '0', 'Warenkorb für eingeloggte Kunden speichern.');
|
|
|
|
ALTER TABLE `shopping_cart_items` ADD `customer_id` int(11) NOT NULL DEFAULT '0';
|
|
|
|
ALTER TABLE `shipping_area` ADD `free_payment_nn` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_pp` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_vk` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_be` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_r` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_bar` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_computop_creditcard` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_billpay_invoice` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_paymorrow_rechnung` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_paymorrow_raten` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_klarna_rechnung` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_klarna_raten` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `shipping_area` ADD `free_payment_customized` DECIMAL(6,2) NOT NULL DEFAULT '0.0';
|
|
|
|
ALTER TABLE `items` ADD `last_change_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
|
|
ALTER TABLE `items` ADD `last_change_user_id` int(11) NOT NULL DEFAULT '0';
|
|
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield1_name', 'text', 'CUSTOMER', 'Freitextfeld 1', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.');
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield2_name', 'text', 'CUSTOMER', 'Freitextfeld 2', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.');
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield3_name', 'text', 'CUSTOMER', 'Freitextfeld 3', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.');
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield4_name', 'text', 'CUSTOMER', 'Freitextfeld 4', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.');
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield5_name', 'text', 'CUSTOMER', 'Freitextfeld 5', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.');
|
|
INSERT INTO `configuration` (`name`, `text`, `group_id`, `setting`, `type`, `description`) VALUES
|
|
('customer_freetextfield6_name', 'text', 'CUSTOMER', 'Freitextfeld 6', 1, 'Bezeichnung für das Freitextfeld 1 der Kundendaten.'); |