# /* -------------------------------------------------------------------  */
# /* PhPepperShop v.2.5 MySQL Collation / Charset Anpassungen             */
# /* -------------------------------------------------------------------  */
# /* (C)2001-2007 Jose Fontanil, Reto Glanzmann, Glarotech GmbH           */
# /* -------------------------------------------------------------------  */

# /* -------------------------------------------------------------------  */
# /* Die folgenden SQL-Befehle passen eine neu installierte PhPepperShop  */
# /* Version 2.5 an die Collation latin1_german2_ci an. Der Zeichensatz   */
# /* wird auf latin1 gesetzt.                                             */
# /* -------------------------------------------------------------------  */

# /* -------------------------------------------------------------------  */
# /* Dieses Script kann ab MySQL Version 4.1.0 angewendet werden          */
# /* -------------------------------------------------------------------  */

# /* -------------------------------------------------------------------  */
# /* Bevor man das Script laufen laesst muss im alter database SQL-Befehl */
# /* zuerst noch {shop_db} durch den Namen der Datenbank ersetzt werden   */
# /* -------------------------------------------------------------------  */


# /* DEFAULT CHARACTER SET UND DEFAULT COLLATION DER DATENBANK SETZEN */

ALTER DATABASE `{shop_db}` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci

# /* DEFAULT CHARACTER SET UND DEFAULT COLLATION ALLER TABELLEN SETZEN */

ALTER TABLE `affiliate_calls`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `affiliates`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_bestellung`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_kategorie`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_optionen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_variationen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_variationsgruppen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `attribut`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `backup`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bestellung`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bestellung_kunde`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bewertungen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bonitaet`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `box_content`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `css_file`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `e_content`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `hilfe`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kategorie_locale`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kategorien`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kreditkarte`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde_adressen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde_artikel`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `locale`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `locks`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `mehrwertsteuer`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_interfaces`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_interfaces_module`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_locale`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_mainmodule`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_requiredmodule`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_submodule`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_empfaenger`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_empfaenger_kategorien`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_kategorien`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `notify_events`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `notify_liste`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `session`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `shop_settings`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `shop_settings_new`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `statistik`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `suchresultate`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `sync_ts`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `tracking`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_intervalle`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_laender`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_laendergruppen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_versandarten`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_zahlungsarten`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `waehrungen`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `zahlung_weitere`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;

# /* ALLE TABELLEN MIT IHREN SPALTEN KONVERTIEREN */

ALTER TABLE `affiliate_calls` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `affiliates` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_bestellung` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_kategorie` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_optionen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_variationen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `artikel_variationsgruppen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `attribut` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `backup` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bestellung` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bestellung_kunde` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bewertungen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `bonitaet` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `box_content` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `css_file` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `e_content` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `hilfe` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kategorie_locale` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kategorien` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kreditkarte` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde_adressen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `kunde_artikel` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `locale` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `locks` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `mehrwertsteuer` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_interfaces` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_interfaces_module` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_locale` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_mainmodule` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_requiredmodule` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `module_submodule` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_empfaenger` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_empfaenger_kategorien` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `newsl_kategorien` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `notify_events` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `notify_liste` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `session` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `shop_settings` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `shop_settings_new` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `statistik` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `suchresultate` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `sync_ts` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `tracking` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_intervalle` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_laender` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_laendergruppen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_versandarten` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `versand_zahlungsarten` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `waehrungen` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `zahlung_weitere` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;

# /* Falls die Tabelle Gutscheine in Gebrauch ist... */

ALTER TABLE `gutscheine`  DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci;
ALTER TABLE `gutscheine` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german2_ci;


# /* End of file ----------------------------------  */