Das ist der SQL Export, alles mit UTF-8
Code:
#================================================================================
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
#---------------------------------------------------------
# Table structure for table 'tl_article'
#---------------------------------------------------------
CREATE TABLE `tl_article` (
`id` int(10) unsigned NOT NULL auto_increment,
`pid` int(10) unsigned NOT NULL default '0',
`sorting` int(10) unsigned NOT NULL default '0',
`tstamp` int(10) unsigned NOT NULL default '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
`alias` varchar(255) COLLATE utf8_bin NOT NULL default '',
`author` int(10) unsigned NOT NULL default '0',
`inColumn` varchar(32) COLLATE utf8_unicode_ci NOT NULL default 'main',
`keywords` text COLLATE utf8_unicode_ci NULL,
`showTeaser` char(1) COLLATE utf8_unicode_ci NOT NULL default '',
`teaserCssID` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
`teaser` text COLLATE utf8_unicode_ci NULL,
`printable` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
`customTpl` varchar(64) COLLATE utf8_unicode_ci NOT NULL default '',
`protected` char(1) COLLATE utf8_unicode_ci NOT NULL default '',
`groups` blob NULL,
`guests` char(1) COLLATE utf8_unicode_ci NOT NULL default '',
`cssID` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
`published` char(1) COLLATE utf8_unicode_ci NOT NULL default '',
`start` varchar(10) COLLATE utf8_unicode_ci NOT NULL default '',
`stop` varchar(10) COLLATE utf8_unicode_ci NOT NULL default '',
`cssClasses` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
PRIMARY KEY (`id`),
KEY `alias` (`alias`),
KEY `pid_published_incolumn_start_stop` (`pid`, `published`, `inColumn`, `start`, `stop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=446;
Das sind Zeilen aus dem Export:
Code:
'a:2:{i:0;s:0:"";i:1;s:0:"";}', '1', '', '', '' );
INSERT INTO `tl_article` VALUES ( 368, 291, 128, 1543439600, 'Arbeitsregion Rhön-Grabfeld', '', 1, 'main', NULL, '', '', NULL, '', '', '', NULL, '', '', '', '', '', '' );
INSERT INTO `tl_article` VALUES ( 369, 292, 128, 1543439600, 'Arbeitsregion Stuttgart', '', 1, 'main', NULL, '', '', NULL, '', '', '', NULL, '', '', '', '', '', '' );
INSERT INTO `tl_article` VALUES ( 370, 293, 128, 1548793090, 'Kurse', '', 1, 'main', NULL, '1', 'a:2:{i:0;s:0:"";i:1;s:0:"";}', '<p>Zu diesen Themen finden regelmäßig Kurse in Würzburg statt:</p>\n<ul>\n<li>Grundgehorsam I/ erwachsene Hunde</li>\n<li>Grundgehorsam II/ erwachsene Hunde</li>\n<li>Junghundeerziehung</li>\n<li>Welpenerziehung</li>\n<li>Anti-Fresstraining (Anti-Gift-Kurs)</li>\n</ul>', '', '', '', NULL, '', 'a:2:{i:0;s:0:"";i:1;s:0:"";}', '1', '', '', '' );
Das ist die Website:
screenshot_53.png
Lesezeichen