-- phpMyAdmin SQL Dump -- version 2.11.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 09. September 2010 um 21:26 -- Server Version: 5.0.51 -- PHP-Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Datenbank: `heimatmuseum` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_affiliate` -- CREATE TABLE IF NOT EXISTS `cm_affiliate` ( `id` int(10) NOT NULL default '0', `user_id` int(10) NOT NULL default '0', `ccm_template` varchar(20) NOT NULL default '', `bg_color` varchar(20) NOT NULL default '0', `fg_color` varchar(20) NOT NULL default '0', `block_bg_color` varchar(20) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_affiliate` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_article_types` -- CREATE TABLE IF NOT EXISTS `cm_article_types` ( `id` int(10) NOT NULL default '0', `title` varchar(200) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Artikelarten die verkauft werden k?nnen'; -- -- Daten f?r Tabelle `cm_article_types` -- INSERT INTO `cm_article_types` (`id`, `title`) VALUES (0, 'normaler Artikel'), (1, 'Gutschein'), (3, 'Download-Artikel'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_bar` -- CREATE TABLE IF NOT EXISTS `cm_bar` ( `id` int(10) NOT NULL auto_increment, `page_id` int(10) NOT NULL default '0', `position` enum('top','bottom') NOT NULL default 'top', `weight` int(10) NOT NULL default '0', `shop_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='obere und untere Leiste' AUTO_INCREMENT=24 ; -- -- Daten f?r Tabelle `cm_bar` -- INSERT INTO `cm_bar` (`id`, `page_id`, `position`, `weight`, `shop_id`) VALUES (1, 456, 'top', 1, 0), (2, 446, 'top', 2, 0), (3, 450, 'top', 3, 0), (8, 1, 'top', 8, 1), (9, 497, 'top', 9, 1), (6, 447, 'top', 6, 0), (7, 463, 'top', 7, 0), (10, 496, 'top', 10, 1), (11, 498, 'top', 11, 1), (16, 474, 'top', 12, 1), (13, 498, 'bottom', 2, 1), (18, 475, 'top', 13, 1), (19, 476, 'top', 14, 1), (20, 477, 'top', 15, 1), (21, 478, 'top', 16, 1), (22, 479, 'top', 17, 1), (23, 480, 'top', 18, 1); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_blocked_ips` -- CREATE TABLE IF NOT EXISTS `cm_blocked_ips` ( `ip` varchar(100) NOT NULL default '', `time` int(10) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_blocked_ips` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_blocks` -- CREATE TABLE IF NOT EXISTS `cm_blocks` ( `id` int(10) NOT NULL auto_increment, `page_id` int(10) NOT NULL default '0', `position` enum('left','right') NOT NULL default 'left', `title_disable` enum('0','1') default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ; -- -- Daten f?r Tabelle `cm_blocks` -- INSERT INTO `cm_blocks` (`id`, `page_id`, `position`, `title_disable`) VALUES (19, 223, 'right', ''), (2, 197, 'left', '1'), (3, 198, 'right', ''), (4, 199, 'right', '1'), (5, 200, 'left', ''), (6, 201, 'left', ''), (7, 202, 'right', ''), (8, 203, 'left', ''), (9, 3, 'left', '0'), (18, 12, 'left', '0'), (12, 2, 'left', '0'), (17, 215, 'left', '0'), (14, 207, 'left', ''), (15, 208, 'right', ''), (16, 209, 'left', ''), (20, 224, 'left', '0'), (21, 225, 'left', '0'), (22, 226, 'left', '0'), (27, 234, 'left', '1'), (87, 521, 'left', '0'), (39, 465, 'left', '0'), (40, 468, 'left', ''), (41, 469, 'left', ''), (71, 503, 'left', '0'), (90, 512, 'left', ''); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_counter` -- CREATE TABLE IF NOT EXISTS `cm_counter` ( `ip` varchar(16) NOT NULL default '', `time` varchar(10) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_counter` -- INSERT INTO `cm_counter` (`ip`, `time`) VALUES ('127.0.0.1', '1274819170'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_counter_now` -- CREATE TABLE IF NOT EXISTS `cm_counter_now` ( `ip` varchar(16) NOT NULL default '', `time` varchar(10) NOT NULL default '', UNIQUE KEY `ip_2` (`ip`), UNIQUE KEY `ip_3` (`ip`), KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_counter_now` -- INSERT INTO `cm_counter_now` (`ip`, `time`) VALUES ('127.0.0.1', '1274819170'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_countries` -- CREATE TABLE IF NOT EXISTS `cm_countries` ( `id` int(10) NOT NULL auto_increment, `country` varchar(50) NOT NULL default '', `zone` varchar(50) NOT NULL default '', `default` int(1) NOT NULL default '0', `status` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=323 ; -- -- Daten f?r Tabelle `cm_countries` -- INSERT INTO `cm_countries` (`id`, `country`, `zone`, `default`, `status`) VALUES (1, 'ARGENTINIA', '1', 0, 0), (2, 'AUSTRALIA', '3', 0, 1), (3, 'BELGIQUE', '2', 0, 1), (4, 'CANADA', '3', 0, 1), (5, 'CYPRUS', '2', 0, 1), (6, 'DANMARK', '2', 0, 1), (7, 'DEUTSCHLAND', '1', 1, 1), (8, 'SPAIN', '2', 0, 1), (9, 'FRANCE', '2', 0, 1), (10, 'HONG KONG', '3', 0, 1), (11, 'ISLAND', '3', 0, 1), (12, 'IRELAND', '2', 0, 1), (13, 'ITALIA', '2', 0, 1), (14, 'KOREA, REPUBLIC OF', '3', 0, 1), (15, 'KUWAIT', '3', 0, 1), (16, 'LIECHTENSTEIN', '2', 0, 1), (17, 'LUXEMBOURG', '2', 0, 1), (18, 'MALTA', '2', 0, 1), (19, 'ISRAEL', '3', 0, 1), (20, 'MONACO', '2', 0, 1), (21, 'NEDERLAND', '2', 0, 1), (22, 'NEW ZEALAND', '3', 0, 1), (23, 'OESTERREICH', '2', 0, 1), (24, 'PORTUGAL', '2', 0, 1), (25, 'SCHWEIZ', '2', 0, 1), (26, 'SINGAPORE', '3', 0, 1), (27, 'UNITED KINGDOM', '2', 0, 1), (28, 'UNITED STATES', '3', 0, 1), (29, 'NORWAY', '2', 0, 1), (31, 'AFGHANISTAN', '3', 0, 1), (32, '?LAND ISLANDS', '3', 0, 1), (33, 'ALBANIA', '3', 0, 1), (34, 'ALGERIA', '3', 0, 1), (35, 'AMERICAN SAMOA', '3', 0, 1), (36, 'ANDORRA', '2', 0, 1), (37, 'ANGOLA', '3', 0, 1), (38, 'ANGUILLA', '3', 0, 1), (39, 'ANTARCTICA', '3', 0, 1), (40, 'ANTIGUA AND BARBUDA', '3', 0, 1), (41, 'ARMENIA', '3', 0, 1), (42, 'ARUBA', '3', 0, 1), (43, 'AZERBAIJAN', '3', 0, 1), (44, 'BAHAMAS', '3', 0, 1), (45, 'BAHRAIN', '3', 0, 1), (46, 'BANGLADESH', '3', 0, 1), (47, 'BARBADOS', '3', 0, 1), (48, 'BELARUS', '3', 0, 1), (49, 'BELIZE', '3', 0, 1), (50, 'BENIN', '3', 0, 1), (51, 'BERMUDA', '3', 0, 1), (52, 'BHUTAN', '3', 0, 1), (53, 'BOLIVIA', '3', 0, 1), (54, 'BOSNIA AND HERZEGOVINA', '3', 0, 1), (55, 'BOTSWANA', '3', 0, 1), (56, 'BOUVET ISLAND', '3', 0, 1), (57, 'BRAZIL', '3', 0, 1), (58, 'BRITISH INDIAN OCEAN TERRITORY', '3', 0, 1), (59, 'BRUNEI DARUSSALAM', '3', 0, 1), (60, 'BULGARIA', '3', 0, 1), (61, 'BURKINA FASO', '3', 0, 1), (62, 'BURUNDI', '3', 0, 1), (63, 'CAMBODIA', '3', 0, 1), (64, 'CAMEROON', '3', 0, 1), (65, 'CAPE VERDE', '3', 0, 1), (66, 'CAYMAN ISLANDS', '3', 0, 1), (67, 'CENTRAL AFRICAN REPUBLIC', '3', 0, 1), (68, 'CHAD', '3', 0, 1), (69, 'CHILE', '3', 0, 1), (70, 'CHINA', '3', 0, 1), (71, 'CHRISTMAS ISLAND', '3', 0, 1), (72, 'COCOS (KEELING) ISLANDS', '3', 0, 1), (73, 'COLOMBIA', '3', 0, 1), (74, 'COMOROS', '3', 0, 1), (75, 'CONGO', '3', 0, 1), (76, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', '3', 0, 1), (77, 'COOK ISLANDS', '3', 0, 1), (78, 'COSTA RICA', '3', 0, 1), (93, 'BAHRAIN', '3', 0, 1), (155, 'COTE D''IVOIRE', '3', 0, 1), (156, 'CROATIA', '3', 0, 1), (157, 'CUBA', '3', 0, 1), (158, 'CZECH REPUBLIC', '2', 0, 1), (159, 'DJIBOUTI', '3', 0, 1), (160, 'DOMINICA', '3', 0, 1), (161, 'DOMINICAN REPUBLIC', '3', 0, 1), (162, 'ECUADOR', '3', 0, 1), (163, 'EGYPT', '3', 0, 1), (164, 'EL SALVADOR', '3', 0, 1), (165, 'EQUATORIAL GUINEA', '3', 0, 1), (166, 'ERITREA', '3', 0, 1), (167, 'ESTONIA', '3', 0, 1), (168, 'ETHIOPIA', '3', 0, 1), (169, 'FALKLAND ISLANDS (MALVINAS)', '3', 0, 1), (170, 'FAROE ISLANDS', '3', 0, 1), (171, 'FIJI', '3', 0, 1), (172, 'FINLAND', '2', 0, 1), (173, 'FRENCH GUIANA', '3', 0, 1), (174, 'FRENCH POLYNESIA', '3', 0, 1), (175, 'FRENCH SOUTHERN TERRITORIES', '3', 0, 1), (176, 'GABON', '3', 0, 1), (177, 'GAMBIA', '3', 0, 1), (178, 'GEORGIA', '3', 0, 1), (179, 'GHANA', '3', 0, 1), (180, 'GIBRALTAR', '3', 0, 1), (181, 'GREECE', '2', 0, 1), (182, 'GREENLAND', '3', 0, 1), (183, 'GRENADA', '3', 0, 1), (184, 'GUADELOUPE', '3', 0, 1), (185, 'GUAM', '3', 0, 1), (186, 'GUATEMALA', '3', 0, 1), (187, 'GUERNSEY', '3', 0, 1), (188, 'GUINEA', '3', 0, 1), (189, 'GUINEA-BISSAU', '3', 0, 1), (190, 'GUYANA', '3', 0, 1), (191, 'HAITI', '3', 0, 1), (192, 'HEARD ISLAND AND MCDONALD ISLANDS', '3', 0, 1), (193, 'HOLY SEE (VATICAN CITY STATE)', '3', 0, 1), (194, 'HONDURAS', '3', 0, 1), (195, 'HUNGARY', '2', 0, 1), (196, 'INDIA', '3', 0, 1), (197, 'INDONESIA', '3', 0, 1), (198, 'IRAN, ISLAMIC REPUBLIC OF', '3', 0, 1), (199, 'IRAQ', '3', 0, 1), (200, 'ISLE OF MAN', '3', 0, 1), (201, 'JAMAICA', '3', 0, 1), (202, 'JAPAN', '3', 0, 1), (203, 'JERSEY', '3', 0, 1), (204, 'JORDAN', '3', 0, 1), (205, 'KAZAKHSTAN', '3', 0, 1), (206, 'KENYA', '3', 0, 1), (207, 'KIRIBATI', '3', 0, 1), (208, 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', '3', 0, 1), (209, 'KYRGYZSTAN', '3', 0, 1), (211, 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', '3', 0, 1), (212, 'LATVIA', '3', 0, 1), (213, 'LEBANON', '3', 0, 1), (214, 'LESOTHO', '3', 0, 1), (215, 'LIBERIA', '3', 0, 1), (216, 'LIBYAN ARAB JAMAHIRIYA', '3', 0, 1), (217, 'LITHUANIA', '3', 0, 1), (218, 'MACAO', '3', 0, 1), (219, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', '3', 0, 0), (220, 'MADAGASCAR', '3', 0, 1), (221, 'MALAWI', '3', 0, 1), (222, 'MALAYSIA', '3', 0, 1), (223, 'MALDIVES', '3', 0, 1), (224, 'MALI', '3', 0, 1), (225, 'MARSHALL ISLANDS', '3', 0, 1), (226, 'MARTINIQUE', '3', 0, 1), (227, 'MAURITANIA', '3', 0, 1), (228, 'MAURITIUS', '3', 0, 1), (229, 'MAYOTTE', '3', 0, 1), (230, 'MEXICO', '3', 0, 1), (231, 'MICRONESIA, FEDERATED STATES OF', '3', 0, 1), (232, 'MOLDOVA, REPUBLIC OF', '3', 0, 1), (233, 'MONGOLIA', '3', 0, 1), (234, 'MONTENEGRO', '3', 0, 1), (235, 'MONTSERRAT', '3', 0, 1), (236, 'MOROCCO', '3', 0, 1), (237, 'MOZAMBIQUE', '3', 0, 1), (238, 'MYANMAR', '3', 0, 1), (239, 'NAMIBIA', '3', 0, 1), (240, 'NAURU', '3', 0, 1), (241, 'NEPAL', '3', 0, 1), (242, 'NETHERLANDS ANTILLES', '3', 0, 1), (243, 'NEW CALEDONIA', '3', 0, 1), (244, 'NICARAGUA', '3', 0, 1), (245, 'NIGER', '3', 0, 1), (246, 'NIGERIA', '3', 0, 1), (247, 'NIUE', '3', 0, 1), (248, 'NORFOLK ISLAND', '3', 0, 1), (249, 'NORTHERN MARIANA ISLANDS', '3', 0, 1), (250, 'OMAN', '3', 0, 1), (251, 'PAKISTAN', '3', 0, 1), (252, 'PALAU', '3', 0, 1), (253, 'PALESTINIAN TERRITORY, OCCUPIED', '3', 0, 1), (254, 'PANAMA', '3', 0, 1), (255, 'PAPUA NEW GUINEA', '3', 0, 1), (256, 'PARAGUAY', '3', 0, 1), (257, 'PERU', '3', 0, 1), (258, 'PHILIPPINES', '3', 0, 1), (259, 'PITCAIRN', '3', 0, 1), (260, 'POLAND', '2', 0, 1), (261, 'PUERTO RICO', '3', 0, 1), (262, 'QATAR', '3', 0, 1), (263, 'REUNION', '3', 0, 1), (264, 'ROMANIA', '3', 0, 1), (265, 'RUSSIAN FEDERATION', '2', 0, 1), (266, 'RWANDA', '3', 0, 1), (267, 'SAINT HELENA', '3', 0, 1), (268, 'SAINT KITTS AND NEVIS', '3', 0, 1), (269, 'SAINT LUCIA', '3', 0, 1), (270, 'SAINT PIERRE AND MIQUELON', '3', 0, 1), (271, 'SAINT VINCENT AND THE GRENADINES', '3', 0, 1), (272, 'SAMOA', '3', 0, 1), (273, 'SAN MARINO', '3', 0, 1), (274, 'SAO TOME AND PRINCIPE', '3', 0, 1), (275, 'SAUDI ARABIA', '3', 0, 1), (276, 'SENEGAL', '3', 0, 1), (277, 'SERBIA', '3', 0, 1), (278, 'SEYCHELLES', '3', 0, 1), (279, 'SIERRA LEONE', '3', 0, 1), (280, 'SLOVAKIA', '2', 0, 1), (281, 'SLOVENIA', '2', 0, 1), (282, 'SOLOMON ISLANDS', '3', 0, 1), (283, 'SOMALIA', '3', 0, 1), (284, 'SOUTH AFRICA', '3', 0, 1), (285, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', '3', 0, 0), (286, 'SRI LANKA', '3', 0, 1), (287, 'SUDAN', '3', 0, 1), (288, 'SURINAME', '3', 0, 1), (289, 'SVALBARD AND JAN MAYEN', '3', 0, 1), (290, 'SWAZILAND', '3', 0, 1), (291, 'SWEDEN', '2', 0, 1), (292, 'SYRIAN ARAB REPUBLIC', '3', 0, 1), (293, 'TAIWAN, PROVINCE OF CHINA', '3', 0, 1), (294, 'TAJIKISTAN', '3', 0, 1), (295, 'TANZANIA, UNITED REPUBLIC OF', '3', 0, 1), (296, 'THAILAND', '3', 0, 1), (297, 'TIMOR-LESTE', '3', 0, 1), (298, 'TOGO', '3', 0, 1), (299, 'TOKELAU', '3', 0, 1), (300, 'TONGA', '3', 0, 1), (301, 'TRINIDAD AND TOBAGO', '3', 0, 1), (302, 'TUNISIA', '3', 0, 1), (303, 'TURKEY', '3', 0, 1), (304, 'TURKMENISTAN', '3', 0, 1), (305, 'TURKS AND CAICOS ISLANDS', '3', 0, 1), (306, 'TUVALU', '3', 0, 1), (307, 'UGANDA', '3', 0, 1), (308, 'UKRAINE', '3', 0, 1), (309, 'UNITED ARAB EMIRATES', '3', 0, 1), (310, 'UNITED STATES MINOR OUTLYING ISLANDS', '3', 0, 1), (311, 'URUGUAY', '3', 0, 1), (312, 'UZBEKISTAN', '3', 0, 1), (313, 'VANUATU', '3', 0, 1), (314, 'VENEZUELA', '3', 0, 1), (315, 'VIET NAM', '3', 0, 1), (316, 'VIRGIN ISLANDS, BRITISH', '3', 0, 1), (317, 'VIRGIN ISLANDS, U.S.', '3', 0, 1), (318, 'WALLIS AND FUTUNA', '3', 0, 1), (319, 'WESTERN SAHARA', '3', 0, 1), (320, 'YEMEN', '3', 0, 1), (321, 'ZAMBIA', '3', 0, 1), (322, 'ZIMBABWE', '3', 0, 1); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_errors` -- CREATE TABLE IF NOT EXISTS `cm_errors` ( `time` int(11) NOT NULL default '0', `message` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_errors` -- INSERT INTO `cm_errors` (`time`, `message`) VALUES (1280920056, 'Unknown column ''cms_template'' in ''field list'''), (1280920135, 'Unknown column ''cms_template'' in ''field list'''), (1280920238, 'Unknown column ''cms_template'' in ''field list'''), (1280920280, 'Unknown column ''cms_template'' in ''field list'''), (1280920304, 'Unknown column ''cms_template'' in ''field list'''), (1280920310, 'Unknown column ''cms_template'' in ''field list'''), (1280920407, 'Unknown column ''cms_template'' in ''field list'''), (1280920411, 'Unknown column ''cms_template'' in ''field list'''), (1280920424, 'Unknown column ''cms_template'' in ''field list'''), (1280920494, 'Unknown column ''cms_template'' in ''field list'''), (1280920527, 'Unknown column ''cms_template'' in ''field list'''), (1280920595, 'Unknown column ''cms_template'' in ''field list'''), (1280920596, 'Unknown column ''cms_template'' in ''field list'''), (1280920655, 'Unknown column ''cms_template'' in ''field list'''), (1280920667, 'Unknown column ''cms_template'' in ''field list'''), (1280920755, 'Unknown column ''cms_template'' in ''field list'''), (1280920827, 'Unknown column ''cms_template'' in ''field list'''), (1280920841, 'Unknown column ''cms_template'' in ''field list'''), (1280920854, 'Unknown column ''cms_template'' in ''field list'''), (1280920891, 'Unknown column ''cms_template'' in ''field list'''), (1280920914, 'Unknown column ''cms_template'' in ''field list'''), (1280920922, 'Unknown column ''cms_template'' in ''field list'''), (1280920928, 'Unknown column ''cms_template'' in ''field list'''), (1280920938, 'Unknown column ''cms_template'' in ''field list'''), (1280920946, 'Unknown column ''cms_template'' in ''field list'''), (1280920965, 'Unknown column ''cms_template'' in ''field list'''), (1280920972, 'Unknown column ''cms_template'' in ''field list'''), (1280920995, 'Unknown column ''cms_template'' in ''field list'''), (1280921007, 'Unknown column ''cms_template'' in ''field list'''), (1280921018, 'Unknown column ''cms_template'' in ''field list'''), (1280921031, 'Unknown column ''cms_template'' in ''field list'''), (1280921046, 'Unknown column ''cms_template'' in ''field list'''), (1280921315, 'Unknown column ''cms_template'' in ''field list'''), (1280921359, 'Unknown column ''cms_template'' in ''field list'''), (1280921370, 'Unknown column ''cms_template'' in ''field list'''), (1280921380, 'Unknown column ''cms_template'' in ''field list'''), (1280921386, 'Unknown column ''cms_template'' in ''field list'''), (1280921397, 'Unknown column ''cms_template'' in ''field list'''), (1280921408, 'Unknown column ''cms_template'' in ''field list'''), (1280921414, 'Unknown column ''cms_template'' in ''field list'''), (1280921421, 'Unknown column ''cms_template'' in ''field list'''), (1280921431, 'Unknown column ''cms_template'' in ''field list'''), (1280921481, 'Unknown column ''cms_template'' in ''field list'''), (1280921538, 'Unknown column ''cms_template'' in ''field list'''), (1280921545, 'Unknown column ''cms_template'' in ''field list'''), (1280921552, 'Unknown column ''cms_template'' in ''field list'''), (1280921553, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922193, 'Unknown column ''cms_template'' in ''field list'''), (1280922193, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922231, 'Unknown column ''cms_template'' in ''field list'''), (1280922231, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922244, 'Unknown column ''cms_template'' in ''field list'''), (1280922244, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922248, 'Unknown column ''cms_template'' in ''field list'''), (1280922248, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922248, 'Unknown column ''cms_template'' in ''field list'''), (1280922248, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922249, 'Unknown column ''cms_template'' in ''field list'''), (1280922249, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922250, 'Unknown column ''cms_template'' in ''field list'''), (1280922250, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922251, 'Unknown column ''cms_template'' in ''field list'''), (1280922251, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922251, 'Unknown column ''cms_template'' in ''field list'''), (1280922251, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922253, 'Unknown column ''cms_template'' in ''field list'''), (1280922253, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922253, 'Unknown column ''cms_template'' in ''field list'''), (1280922253, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922260, 'Unknown column ''cms_template'' in ''field list'''), (1280922260, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922264, 'Unknown column ''cms_template'' in ''field list'''), (1280922264, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922265, 'Unknown column ''cms_template'' in ''field list'''), (1280922265, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922267, 'Unknown column ''cms_template'' in ''field list'''), (1280922267, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922269, 'Unknown column ''cms_template'' in ''field list'''), (1280922269, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922269, 'Unknown column ''cms_template'' in ''field list'''), (1280922269, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922271, 'Unknown column ''cms_template'' in ''field list'''), (1280922271, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922272, 'Unknown column ''cms_template'' in ''field list'''), (1280922272, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922272, 'Unknown column ''cms_template'' in ''field list'''), (1280922272, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922274, 'Unknown column ''cms_template'' in ''field list'''), (1280922274, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922276, 'Unknown column ''cms_template'' in ''field list'''), (1280922276, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922277, 'Unknown column ''cms_template'' in ''field list'''), (1280922277, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922278, 'Unknown column ''cms_template'' in ''field list'''), (1280922278, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922280, 'Unknown column ''cms_template'' in ''field list'''), (1280922280, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922280, 'Unknown column ''cms_template'' in ''field list'''), (1280922280, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922282, 'Unknown column ''cms_template'' in ''field list'''), (1280922282, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922283, 'Unknown column ''cms_template'' in ''field list'''), (1280922283, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922283, 'Unknown column ''cms_template'' in ''field list'''), (1280922284, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922285, 'Unknown column ''cms_template'' in ''field list'''), (1280922285, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922287, 'Unknown column ''cms_template'' in ''field list'''), (1280922287, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922287, 'Unknown column ''cms_template'' in ''field list'''), (1280922287, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922289, 'Unknown column ''cms_template'' in ''field list'''), (1280922289, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922290, 'Unknown column ''cms_template'' in ''field list'''), (1280922290, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922290, 'Unknown column ''cms_template'' in ''field list'''), (1280922290, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922490, 'Unknown column ''cms_template'' in ''field list'''), (1280922490, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922506, 'Unknown column ''cms_template'' in ''field list'''), (1280922506, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922522, 'Unknown column ''cms_template'' in ''field list'''), (1280922522, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922530, 'Unknown column ''cms_template'' in ''field list'''), (1280922530, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922534, 'Unknown column ''cms_template'' in ''field list'''), (1280922534, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922534, 'Unknown column ''cms_template'' in ''field list'''), (1280922534, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922545, 'Unknown column ''cms_template'' in ''field list'''), (1280922545, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922547, 'Unknown column ''cms_template'' in ''field list'''), (1280922547, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922547, 'Unknown column ''cms_template'' in ''field list'''), (1280922547, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922561, 'Unknown column ''cms_template'' in ''field list'''), (1280922561, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922564, 'Unknown column ''cms_template'' in ''field list'''), (1280922564, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922564, 'Unknown column ''cms_template'' in ''field list'''), (1280922564, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922572, 'Unknown column ''cms_template'' in ''field list'''), (1280922572, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922580, 'Unknown column ''cms_template'' in ''field list'''), (1280922580, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922580, 'Unknown column ''cms_template'' in ''field list'''), (1280922580, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922586, 'Unknown column ''cms_template'' in ''field list'''), (1280922586, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1280922810, 'Unknown column ''cms_template'' in ''field list'''), (1280922810, 'Unknown column ''cms_template'' in ''field list'''), (1280923184, 'Unknown column ''cms_template'' in ''field list'''), (1280923197, 'Unknown column ''cms_template'' in ''field list'''), (1280923209, 'Unknown column ''cms_template'' in ''field list'''), (1280923226, 'Unknown column ''cms_template'' in ''field list'''), (1280923289, 'Unknown column ''cms_template'' in ''field list'''), (1280923296, 'Unknown column ''cms_template'' in ''field list'''), (1280923306, 'Unknown column ''cms_template'' in ''field list'''), (1280923348, 'Unknown column ''cms_template'' in ''field list'''), (1280923357, 'Unknown column ''cms_template'' in ''field list'''), (1280923365, 'Unknown column ''cms_template'' in ''field list'''), (1280923385, 'Unknown column ''cms_template'' in ''field list'''), (1280923532, 'Unknown column ''cms_template'' in ''field list'''), (1280923539, 'Unknown column ''cms_template'' in ''field list'''), (1280923578, 'Unknown column ''cms_template'' in ''field list'''), (1280924044, 'Unknown column ''cms_template'' in ''field list'''), (1280924055, 'Unknown column ''cms_template'' in ''field list'''), (1280924062, 'Unknown column ''cms_template'' in ''field list'''), (1280924092, 'Unknown column ''cms_template'' in ''field list'''), (1280924098, 'Unknown column ''cms_template'' in ''field list'''), (1280924104, 'Unknown column ''cms_template'' in ''field list'''), (1280924121, 'Unknown column ''cms_template'' in ''field list'''), (1280924163, 'Unknown column ''cms_template'' in ''field list'''), (1280924168, 'Unknown column ''cms_template'' in ''field list'''), (1280949532, 'Unknown column ''cms_template'' in ''field list'''), (1280951552, 'Unknown column ''cms_template'' in ''field list'''), (1280951927, 'Unknown column ''cms_template'' in ''field list'''), (1281032165, 'Unknown column ''cms_template'' in ''field list'''), (1281032194, 'Unknown column ''cms_template'' in ''field list'''), (1281032198, 'Unknown column ''cms_template'' in ''field list'''), (1281032200, 'Unknown column ''cms_template'' in ''field list'''), (1281032202, 'Unknown column ''cms_template'' in ''field list'''), (1281032208, 'Unknown column ''cms_template'' in ''field list'''), (1281032366, 'Unknown column ''cms_template'' in ''field list'''), (1281032370, 'Unknown column ''cms_template'' in ''field list'''), (1281032379, 'Unknown column ''cms_template'' in ''field list'''), (1281032379, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032387, 'Unknown column ''cms_template'' in ''field list'''), (1281032388, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032391, 'Unknown column ''cms_template'' in ''field list'''), (1281032391, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032400, 'Unknown column ''cms_template'' in ''field list'''), (1281032400, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032413, 'Unknown column ''cms_template'' in ''field list'''), (1281032413, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032435, 'Unknown column ''cms_template'' in ''field list'''), (1281032435, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032684, 'Unknown column ''cms_template'' in ''field list'''), (1281032684, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032688, 'Unknown column ''cms_template'' in ''field list'''), (1281032688, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032705, 'Unknown column ''cms_template'' in ''field list'''), (1281032705, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032889, 'Unknown column ''cms_template'' in ''field list'''), (1281032889, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281032947, 'Unknown column ''cms_template'' in ''field list'''), (1281032947, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041343, 'Unknown column ''cms_template'' in ''field list'''), (1281041347, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041440, 'Unknown column ''cms_template'' in ''field list'''), (1281041440, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041512, 'Unknown column ''cms_template'' in ''field list'''), (1281041512, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041535, 'Unknown column ''cms_template'' in ''field list'''), (1281041535, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041677, 'Unknown column ''cms_template'' in ''field list'''), (1281041677, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041682, 'Unknown column ''cms_template'' in ''field list'''), (1281041872, 'Unknown column ''cms_template'' in ''field list'''), (1281041873, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281041873, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041879, 'Unknown column ''cms_template'' in ''field list'''), (1281041879, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281041879, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281041879, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281041879, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281041880, 'Unknown column ''cms_template'' in ''field list'''), (1281041914, 'Unknown column ''cms_template'' in ''field list'''), (1281041914, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281041914, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042054, 'Unknown column ''cms_template'' in ''field list'''), (1281042054, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281042054, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042238, 'Unknown column ''cms_template'' in ''field list'''), (1281042238, 'Unknown column ''url_title'' in ''field list'''), (1281042238, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281042238, 'Table ''heimatmuseum.cm_news'' doesn''t exist'), (1281042238, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042246, 'Unknown column ''cms_template'' in ''field list'''), (1281042246, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042331, 'Unknown column ''cms_template'' in ''field list'''), (1281042331, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042335, 'Unknown column ''cms_template'' in ''field list'''), (1281042335, 'Unknown column ''p.url_title'' in ''field list'''), (1281042335, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042337, 'Unknown column ''cms_template'' in ''field list'''), (1281042337, 'Unknown column ''p.url_title'' in ''field list'''), (1281042337, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042337, 'Unknown column ''cms_template'' in ''field list'''), (1281042337, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042343, 'Unknown column ''cms_template'' in ''field list'''), (1281042343, 'Unknown column ''url_title'' in ''field list'''), (1281042343, 'Unknown column ''p.url_title'' in ''field list'''), (1281042343, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042353, 'Unknown column ''cms_template'' in ''field list'''), (1281042353, 'Unknown column ''p.url_title'' in ''field list'''), (1281042353, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042353, 'Unknown column ''cms_template'' in ''field list'''), (1281042353, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042422, 'Unknown column ''cms_template'' in ''field list'''), (1281042422, 'Unknown column ''url_title'' in ''field list'''), (1281042422, 'Unknown column ''p.url_title'' in ''field list'''), (1281042422, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042569, 'Unknown column ''cms_template'' in ''field list'''), (1281042569, 'Unknown column ''p.url_title'' in ''field list'''), (1281042569, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042571, 'Unknown column ''cms_template'' in ''field list'''), (1281042571, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042573, 'Unknown column ''cms_template'' in ''field list'''), (1281042573, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042575, 'Unknown column ''cms_template'' in ''field list'''), (1281042576, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042677, 'Unknown column ''cms_template'' in ''field list'''), (1281042677, 'Unknown column ''p.url_title'' in ''field list'''), (1281042677, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042679, 'Unknown column ''cms_template'' in ''field list'''), (1281042679, 'Unknown column ''p.url_title'' in ''field list'''), (1281042679, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042679, 'Unknown column ''cms_template'' in ''field list'''), (1281042679, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281042698, 'Unknown column ''cms_template'' in ''field list'''), (1281042698, 'Unknown column ''url_title'' in ''field list'''), (1281042698, 'Unknown column ''p.url_title'' in ''field list'''), (1281042698, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045649, 'Unknown column ''cms_template'' in ''field list'''), (1281045650, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045653, 'Unknown column ''cms_template'' in ''field list'''), (1281045653, 'Unknown column ''p.url_title'' in ''field list'''), (1281045653, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045741, 'Unknown column ''cms_template'' in ''field list'''), (1281045741, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045742, 'Unknown column ''cms_template'' in ''field list'''), (1281045742, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045751, 'Unknown column ''cms_template'' in ''field list'''), (1281045751, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045762, 'Unknown column ''cms_template'' in ''field list'''), (1281045762, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045799, 'Unknown column ''cms_template'' in ''field list'''), (1281045799, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045805, 'Unknown column ''cms_template'' in ''field list'''), (1281045806, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045809, 'Unknown column ''cms_template'' in ''field list'''), (1281045809, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045809, 'Unknown column ''cms_template'' in ''field list'''), (1281045809, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045811, 'Unknown column ''cms_template'' in ''field list'''), (1281045811, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045813, 'Unknown column ''cms_template'' in ''field list'''), (1281045813, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045813, 'Unknown column ''cms_template'' in ''field list'''), (1281045813, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045815, 'Unknown column ''cms_template'' in ''field list'''), (1281045815, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045817, 'Unknown column ''cms_template'' in ''field list'''), (1281045817, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045817, 'Unknown column ''cms_template'' in ''field list'''), (1281045817, 'Table ''heimatmuseum.cm_shop_orders'' doesn''t exist'), (1281045819, 'Unknown column ''cms_template'' in ''field list'''), (1281045821, 'Unknown column ''cms_template'' in ''field list'''), (1281045824, 'Unknown column ''cms_template'' in ''field list'''), (1281045832, 'Unknown column ''cms_template'' in ''field list'''), (1281045849, 'Unknown column ''cms_template'' in ''field list'''), (1281045851, 'Unknown column ''cms_template'' in ''field list'''), (1281045943, 'Unknown column ''cms_template'' in ''field list'''), (1281046024, 'Unknown column ''cms_template'' in ''field list'''), (1281046066, 'Unknown column ''cms_template'' in ''field list'''), (1281046070, 'Unknown column ''cms_template'' in ''field list'''), (1281046151, 'Unknown column ''cms_template'' in ''field list'''), (1281046162, 'Unknown column ''cms_template'' in ''field list'''), (1281046204, 'Unknown column ''cms_template'' in ''field list'''), (1281046227, 'Unknown column ''cms_template'' in ''field list'''), (1281046337, 'Unknown column ''cms_template'' in ''field list'''), (1281046370, 'Unknown column ''cms_template'' in ''field list'''), (1281046552, 'Unknown column ''cms_template'' in ''field list'''), (1281046639, 'Unknown column ''cms_template'' in ''field list'''), (1281047035, 'Unknown column ''cms_template'' in ''field list'''), (1281047081, 'Unknown column ''cms_template'' in ''field list'''), (1281047547, 'Unknown column ''cms_template'' in ''field list'''), (1281047573, 'Unknown column ''cms_template'' in ''field list'''), (1281047586, 'Unknown column ''cms_template'' in ''field list'''), (1281047621, 'Unknown column ''cms_template'' in ''field list'''), (1281047633, 'Unknown column ''cms_template'' in ''field list'''), (1281047645, 'Unknown column ''cms_template'' in ''field list'''), (1281047662, 'Unknown column ''cms_template'' in ''field list'''), (1281047672, 'Unknown column ''cms_template'' in ''field list'''), (1281047675, 'Unknown column ''cms_template'' in ''field list'''), (1281047688, 'Unknown column ''cms_template'' in ''field list'''), (1281133295, 'Unknown column ''cms_template'' in ''field list'''), (1281133300, 'Unknown column ''cms_template'' in ''field list'''), (1281134974, 'Unknown column ''cms_template'' in ''field list'''), (1281135579, 'Unknown column ''cms_template'' in ''field list'''), (1281135622, 'Unknown column ''cms_template'' in ''field list'''), (1281135645, 'Unknown column ''cms_template'' in ''field list'''), (1281135664, 'Unknown column ''cms_template'' in ''field list'''), (1281135691, 'Unknown column ''cms_template'' in ''field list'''), (1281135701, 'Unknown column ''cms_template'' in ''field list'''), (1281135709, 'Unknown column ''cms_template'' in ''field list'''), (1281379983, 'Unknown column ''cms_template'' in ''field list'''), (1281380222, 'Unknown column ''cms_template'' in ''field list'''); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_favorites` -- CREATE TABLE IF NOT EXISTS `cm_favorites` ( `id` int(10) NOT NULL auto_increment, `user_id` int(10) NOT NULL default '0', `page_id` int(10) NOT NULL default '0', `description` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten f?r Tabelle `cm_favorites` -- INSERT INTO `cm_favorites` (`id`, `user_id`, `page_id`, `description`) VALUES (1, 1, 51, 'Artikel einf?gen'), (2, 1, 25, 'neue Bestellungen'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_functions` -- CREATE TABLE IF NOT EXISTS `cm_functions` ( `id` int(10) NOT NULL auto_increment, `name` text NOT NULL, `description` text NOT NULL, `file` text NOT NULL, `block_function` tinyint(1) default '0', `groups` varchar(50) NOT NULL default 'public', `standard` enum('0','1') NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ; -- -- Daten f?r Tabelle `cm_functions` -- INSERT INTO `cm_functions` (`id`, `name`, `description`, `file`, `block_function`, `groups`, `standard`) VALUES (3, 'Inhalts- od. Artikel-Seiten', 'In diesem Block können Inhaltsseiten oder Seiten für Artikel-Listen eingefügt werden.', '/groups/public/block_pages.php', 1, 'public', '0'), (1, 'ohne Funktion - freie Bearbeitung', 'Dieser Block kann mit dem html-Editor frei gestaltet werden, z.B. um Werbung einzublenden.', '/groups/public/block_html.php', 1, 'public', '1'), (12, 'Inhalts-Seite', 'Auf dieser Seite können sie mit dem html-Editor den Inhalt frei gestalten, z.B. für Infoseiten oder Versandkosten.', '', 0, 'public', '1'), (15, 'Kontaktformular', 'Auf dieser Seite wird ein Formular f?r die Kontaktaufnahme eingeblendet. Die Nachricht wird an die Email-Adresse des Administrators gesendet.', 'public/kontaktformular.php', 0, 'public', '0'), (18, 'News', 'Blendet eine Liste von entsprechenden News-Mitteilungen ein.', 'public/news.php', 0, 'public', '0'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_groups` -- CREATE TABLE IF NOT EXISTS `cm_groups` ( `id` int(10) NOT NULL default '0', `group` varchar(50) NOT NULL default '', `active` int(1) NOT NULL default '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_groups` -- INSERT INTO `cm_groups` (`id`, `group`, `active`) VALUES (13, 'affiliate', 1), (3, 'service', 1), (4, 'newsletter', 0), (5, 'forum', 0), (6, 'advertisers', 0), (1, 'administrators', 1), (2, 'users', 0), (12, 'it_editors', 0), (15, 'reseller', 1), (11, 'fr_editors', 0), (10, 'pl_editors', 0), (7, 'de_editors', 1), (8, 'en_editors', 0), (9, 'es_editors', 0), (14, 'sv_editors', 0), (16, 'pt_editors', 0), (17, 'nl_editors', 0); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_languages` -- CREATE TABLE IF NOT EXISTS `cm_languages` ( `id` int(10) NOT NULL auto_increment, `language` varchar(100) NOT NULL default '', `short` char(2) NOT NULL default '', `charset` varchar(10) NOT NULL default '', `status` varchar(10) NOT NULL default '0', `view` enum('0','1') NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Daten f?r Tabelle `cm_languages` -- INSERT INTO `cm_languages` (`id`, `language`, `short`, `charset`, `status`, `view`) VALUES (9, 'Polski', 'pl', 'iso-8859-2', '0', '1'), (2, 'Nederlands', 'nl', 'iso-8859-1', '0', '1'), (3, 'Portugu?s', 'pt', 'iso-8859-1', '0', '1'), (4, 'Espa?ol', 'es', 'iso-8859-1', '0', '1'), (5, 'Svenska', 'sv', 'iso-8859-1', '0', '1'), (6, 'Italiano', 'it', 'iso-8859-1', '0', '1'), (7, 'English', 'en', 'iso-8859-1', '0', '1'), (8, 'Fran?ais', 'fr', 'iso-8859-1', '0', '1'), (1, 'Deutsch', 'de', 'iso-8859-1', '1', '1'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_lettering` -- CREATE TABLE IF NOT EXISTS `cm_lettering` ( `id` int(10) NOT NULL auto_increment, `name` varchar(200) NOT NULL default '', `see` varchar(100) NOT NULL default '', `value` text NOT NULL, `language` char(2) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Daten f?r Tabelle `cm_lettering` -- INSERT INTO `cm_lettering` (`id`, `name`, `see`, `value`, `language`) VALUES (1, 'email', 'Login', 'Benutzername', 'de'), (2, 'password', 'Login', 'Passwort', 'de'), (3, 'login', 'Login', 'anmelden', 'de'), (4, 'lastLogin', 'Login-Startseite', 'Letzter Login', 'de'), (5, 'welcome', 'Login-Startseite', 'Sie befinden sich in Ihrem persönlichen Loginbereich.', 'de'), (6, 'countAccessDenied', 'Login-Startseite', 'Anzahl gescheiterter Logins', 'de'), (7, 'logout', 'Login', 'ausloggen', 'de'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_logins` -- CREATE TABLE IF NOT EXISTS `cm_logins` ( `time` int(10) NOT NULL default '0', `last_active` int(10) NOT NULL default '0', `ip` varchar(50) NOT NULL default '', `user_id` int(20) NOT NULL default '0', `session_id` varchar(50) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_logins` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_news` -- CREATE TABLE IF NOT EXISTS `cm_news` ( `id` int(10) NOT NULL auto_increment, `preview_text` varchar(500) NOT NULL, `preview_image` varchar(100) NOT NULL, `page_id` int(10) NOT NULL, `content_page_id` int(10) NOT NULL, `publication_time` int(10) NOT NULL, `expires_time` int(10) NOT NULL, `sort` int(10) NOT NULL, `start_page` enum('0','1') NOT NULL default '0', `start_page_top` enum('0','1') NOT NULL default '0', `status` enum('inuse','open','closed','archive') NOT NULL default 'closed', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Daten f?r Tabelle `cm_news` -- INSERT INTO `cm_news` (`id`, `preview_text`, `preview_image`, `page_id`, `content_page_id`, `publication_time`, `expires_time`, `sort`, `start_page`, `start_page_top`, `status`) VALUES (4, 'Eine Ausstellung des F?rdervereins Heimatmuseum der Stadt \r\nRathenow e. V. aus Anlass des 80. Jahrestages der Er?ffnung \r\ndes ersten Rathenower Heimatmuseums im alten Rathaus am \r\nMarkt.\r\nGezeigt wird in wechselnden Expositionen ein ?berblick ?ber \r\ndie j?ngsten Arbeitsergebnisse des Vereins zur Heimatge-\r\nschichte.\r\n', '', 513, 521, 1281045720, 0, 0, '', '', 'open'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_newsletters` -- CREATE TABLE IF NOT EXISTS `cm_newsletters` ( `id` int(10) NOT NULL default '0', `subject` varchar(200) NOT NULL default '', `body` text NOT NULL, `time` int(10) NOT NULL default '0', `created_by` varchar(50) NOT NULL default '', `language` char(3) NOT NULL default 'de', `status` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_newsletters` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_newsletter_temp` -- CREATE TABLE IF NOT EXISTS `cm_newsletter_temp` ( `id` int(11) NOT NULL auto_increment, `email` varchar(100) NOT NULL default '', `send` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Daten f?r Tabelle `cm_newsletter_temp` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_pages` -- CREATE TABLE IF NOT EXISTS `cm_pages` ( `id` int(10) NOT NULL auto_increment, `page_id` int(10) NOT NULL default '0', `page` int(10) NOT NULL default '0', `title` varchar(50) NOT NULL default '', `short_title` varchar(200) NOT NULL default '', `content` text NOT NULL, `function_id` int(10) NOT NULL default '0', `link` varchar(255) NOT NULL default '', `link_param` varchar(100) NOT NULL default '', `meta_title` varchar(100) NOT NULL default '', `meta_description` varchar(255) NOT NULL default '', `meta_keys` varchar(255) NOT NULL default '', `parent` int(10) NOT NULL default '0', `shop_id` int(10) NOT NULL default '0', `weight` int(10) NOT NULL default '0', `target` varchar(10) NOT NULL default '_self', `popup_width` int(4) NOT NULL, `popup_height` int(4) NOT NULL, `created` int(10) NOT NULL default '0', `changed` int(10) NOT NULL default '0', `changed_by` varchar(50) NOT NULL default '', `groups` varchar(200) NOT NULL default '', `language` varchar(30) NOT NULL default 'de', `charset` varchar(50) NOT NULL default 'iso-8859-1', `status` char(2) NOT NULL default '11', `public_enable` enum('0','1') NOT NULL default '1', `change_enable` enum('0','1') NOT NULL default '1', `delete_enable` enum('0','1') NOT NULL default '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1071 ; -- -- Daten f?r Tabelle `cm_pages` -- INSERT INTO `cm_pages` (`id`, `page_id`, `page`, `title`, `short_title`, `content`, `function_id`, `link`, `link_param`, `meta_title`, `meta_description`, `meta_keys`, `parent`, `shop_id`, `weight`, `target`, `popup_width`, `popup_height`, `created`, `changed`, `changed_by`, `groups`, `language`, `charset`, `status`, `public_enable`, `change_enable`, `delete_enable`) VALUES (32, 32, 0, 'Länder', '', '', 0, 'administrator/countries.php', '', '', '', '', 27, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', 'de', 'iso-8859-1', '11', '1', '1', '1'), (34, 34, 0, 'Zonen', '', '', 0, 'administrator/zones.php', '', '', '', '', 27, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', 'de', 'iso-8859-1', '11', '1', '1', '1'), (14, 14, 0, 'Who?', '', '', 0, 'root/who.php', '', '', '', '', 2, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-1', '11', '1', '1', '1'), (124, 124, 0, 'Transportkosten', '', '', 0, 'administrator/transportcharges.php', '', '', '', '', 27, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-1', '11', '1', '1', '1'), (28, 28, 0, 'Kunden-Tools', '', 'Tools für den Kunden', 0, '', '', '', '', '', 0, 0, 4, '_self', 0, 0, 0, 1158581137, 'homuth', 'shop', '', 'iso-8859-1', '00', '1', '1', '1'), (30, 30, 0, 'Wunschliste', '', '', 0, 'shop/notepad.php', '', '', '', '', 28, 0, 0, '_self', 0, 0, 0, 0, '', 'shop', '', 'iso-', '11', '1', '1', '1'), (29, 29, 0, 'getätigte Käufe', '', '', 0, 'shop/orders.php', '', '', '', '', 28, 0, 0, '_self', 0, 0, 0, 0, '', 'shop', '', 'iso-8859-1', '11', '1', '1', '1'), (31, 31, 0, 'gesammelte Artikel', '', '', 0, 'shop/collected.php', '', '', '', '', 28, 0, 0, '_self', 0, 0, 0, 0, '', 'shop', '', 'iso-8859-1', '11', '1', '1', '1'), (4, 4, 0, 'Login', '', '', 0, 'public/login.php', '', '', '', '', 0, 0, 40, '_self', 0, 0, 1137668493, 1215082677, 'homuth', 'public', 'de', 'iso-8859-1', '10', '1', '', '1'), (6, 6, 0, 'What''s New?', '', '', 0, 'root/whatsnew.php', '', '', '', '', 12, 0, 0, '_self', 0, 0, 0, 0, '', 'root', '', 'iso-\r\n\r\n8859-1', '11', '1', '1', '1'), (7, 7, 0, 'Anmeldung', '', '', 0, 'public/anmeldung.php', '', '', '', '', 0, 0, 33, '_self', 0, 0, 0, 1215082694, 'homuth', 'public', 'de', 'iso-\r\n\r\n8859-1', '10', '1', '', '1'), (8, 8, 0, 'Best?tigung', '', '', 0, 'public/confirm.php', '', '', '', '', 0, 0, 34, '_self', 0, 0, 0, 1215082718, 'homuth', 'public', 'de', 'iso-8859-1', '10', '1', '', '1'), (10, 10, 0, 'mein Profil', '', 'Hier können Sie Ihre persönlichen Daten ändern.', 0, '', '', '', '', '', 0, 0, 4, '_self', 0, 0, 0, 1158581118, 'homuth', 'users, administrator', '', 'iso-8859-1', '00', '1', '1', '1'), (11, 11, 0, 'Daten ändern', '', '', 0, 'users/usr_change.php', '', '', '', '', 10, 0, 0, '_self', 0, 0, 0, 0, '', 'users', '', 'iso-8859-1', '11', '1', '1', '1'), (12, 12, 0, 'root-Tools', '', 'Diese Funktionen stehen nur den Benutzern mit root-Rechten zur Verfügung.', 3, '', '', '', '', '', 0, 0, 4, '_self', 0, 0, 0, 0, '', 'root', '', 'iso-8859-1', '11', '1', '1', '1'), (22, 22, 0, 'Zum Merkzettel hinzufügen', '', '', 0, 'users/shop/add_notepad.php', '', '', '', '', 0, 0, 4, '_self', 0, 0, 0, 0, '', 'users', '', 'iso-8859-1', '01', '1', '', '1'), (47, 47, 0, 'Bestätigung', '', '', 0, 'public/confirm.php', '', '', '', '', 0, 0, 27, '_self', 0, 0, 1158659895, 1158659946, 'homuth', 'public', 'de', 'iso-8859-1', '00', '1', '', '1'), (2, 2, 0, 'Admin-Tools', '', 'Benutzerverwaltung und Statistik.', 3, '', '', '', '', '', 0, 0, 4, '_self', 0, 0, 1137076119, 1137076119, 'homuth', 'administrator', '', 'iso-8859-1', '11', '1', '1', '1'), (5, 5, 0, 'Benutzer-Verwaltung', '', '', 0, 'administrator/users_manager.php', '', '', '', '', 2, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-1', '11', '1', '1', '1'), (21, 21, 0, 'Warenkorb', '', '', 0, 'public/shop/order/order.php', '', '', '', '', 0, 0, 26, '_self', 0, 0, 1158580941, 1158581031, 'homuth', 'public', 'de', 'iso-8859-1', '00', '1', '', '1'), (3, 3, 0, 'Deutsch', '', 'Bearbeiten der Seiten.', 3, '', '', '', '', '', 0, 0, 16, '_self', 0, 0, 0, 0, '', 'de_editors', '', 'iso-8859-1', '11', '1', '1', '1'), (9, 9, 0, 'Seiten bearbeiten', '', '', 0, 'editors/management.php', 'lp_language=de', '', '', '', 3, 0, 0, '_self', 0, 0, 0, 0, '', 'de_editors', '', 'iso-8859-1', '11', '1', '1', '1'), (41, 41, 0, 'Newsletter', '', '', 0, 'public/newsletter.php', '', '', '', '', 0, 0, 25, '_self', 0, 0, 1158164427, 1158164480, 'homuth', 'public', 'de', 'iso-8859-1', '00', '1', '', '1'), (42, 42, 0, 'Passwort vergessen', '', '', 0, 'public/forget.php', '', '', '', '', 0, 0, 24, '_self', 0, 0, 1158164483, 1215082705, 'homuth', 'public', 'de', 'iso-8859-1', '00', '1', '', '1'), (43, 43, 0, 'Diese Seite weiterempfehlen', '', '', 0, 'public/recommend.php', '', '', '', '', 0, 0, 1, '_self', 0, 0, 1158164538, 1158164654, 'homuth', 'users', '', 'iso-8859-1', '00', '1', '', '1'), (45, 45, 0, 'Startseite', '', '', 0, 'users/start.php', '', '', '', '', 0, 0, 16, '_self', 0, 0, 0, 1158583651, 'homuth', 'users', '', 'iso-8859-1', '01', '1', '', '1'), (53, 53, 0, 'Sperre', '', '', 0, 'root/servicing.php', '', '', '', '', 2, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-\r\n\r\n1', '11', '1', '1', '1'), (55, 55, 0, 'Suche', '', '', 0, 'public/article_search.php', '', '', '', '', 0, 0, 39, '_self', 0, 0, 0, 0, '', 'public', 'de', 'iso-8859-1', '00', '1', '', '1'), (20, 20, 0, 'Einstellungen', '', '', 0, 'administrator/settings.php', '', '', '', '', 2, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-1', '11', '1', '1', '1'), (105, 105, 0, 'Öffentliche Wunschliste', '', '', 0, 'public/public_notepad.php', '', '', '', '', 0, 0, 38, '_self', 0, 0, 0, 0, '', 'public', 'de', 'iso-8859-1', '0', '1', '', '1'), (125, 125, 0, 'Sprache hinzufügen', '', '', 0, 'administrator/newlanguage.php', '', '', '', '', 2, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', '', 'iso-8859-1', '00', '1', '1', '1'), (605, 445, 0, 'Kontakt', '', '', 0, 'public/kontaktformular.php', '', '', '', '', 444, 0, 0, '_self', 0, 0, 1216381131, 1216381179, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (624, 464, 0, 'Wiederverkäufer', '', '', 3, '', '', '', '', '', 0, 0, 15, '_self', 0, 0, 0, 0, '', 'distributors', 'de', 'iso-8859-1', '11', '1', '1', '1'), (625, 465, 0, 'Partner', '', '', 3, '', '', '', '', '', 0, 0, 16, '_self', 0, 0, 0, 0, '', 'affiliate', 'de', 'iso-8859-1', '11', '1', '1', '1'), (626, 466, 0, 'Umsätze', '', '', 0, 'affiliate/orders.php', '', '', 'Hier finden sie ihre Umsätze aus dem Partner-Programm.', '', 465, 0, 0, '_self', 0, 0, 0, 0, '', 'affiliate', 'de', 'iso-8859-1', '11', '1', '1', '1'), (627, 467, 0, 'Wiederverkäufer', '', '', 0, 'resellers/resellers.php', '', '', 'Hier finden sie ihre Umsätze aus dem Wiederverk?ufer-Programm.', '', 464, 0, 0, '_self', 0, 0, 0, 0, '', 'distributors', 'de', 'iso-8859-1', '11', '1', '1', '1'), (634, 470, 0, 'Umsätze', '', '', 0, 'resellers/turnovers.php', '', '', '', '', 464, 0, 0, '_self', 0, 0, 0, 0, '', 'distributors', 'de', 'iso-8859-1', '11', '1', '1', '1'), (17, 17, 0, 'Newsletter erstellen', '', '', 0, 'administrator/modules/newsletters/new.php', '', '', '', '', 0, 0, 0, '_self', 0, 0, 0, 0, '', 'administrator', 'de', 'iso-8859-1', '11', '0', '0', '0'), (16, 16, 0, 'PayPal', '', '', 0, 'public/shop/order/modules/paypal.php', '', '', '', '', 0, 0, 0, '_self', 0, 0, 0, 0, '', 'public', 'de', 'iso-8859-1', '11', '0', '0', '0'), (18, 18, 0, 'Rechnung', '', '', 0, 'service/modules/bill.php', '', '', '', '', 0, 0, 0, '_self', 0, 0, 0, 0, '', 'service', 'de', 'iso-8859-1', '11', '0', '0', '0'), (1055, 512, 0, 'Men?', '', '', 3, '', '', '', '', '', 0, 1, 100, '', 0, 0, 1277850423, 1280922530, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1056, 513, 0, 'Aktuelles', '', '<h2>F?rderverein Heimatmuseum der Stadt Rathenow e.V.</h2>\r\n <p>Herzlich Willkommen auf unserer Seite, auf der wir uns, unsere Ziele und das Heimatmuseum Rathenow vorstellen wollen.<br /> </p>', 18, '', '', '', '', '', 512, 1, 100, '_self', 0, 0, 1280922534, 1281032947, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1057, 514, 0, 'Wer sind wir?', '', 'Inhalt folgt', 12, '', '', '', '', '', 512, 1, 100, '_self', 0, 0, 1280922547, 1280922561, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1058, 515, 0, 'Was wollen wir?', '', 'Inhalt folgt', 12, '', '', '', '', '', 512, 1, 100, '_self', 0, 0, 1280922564, 1280922572, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1059, 516, 0, 'Impressum', '', 'Inhalt folgt', 12, '', '', '', '', '', 512, 1, 100, '_self', 0, 0, 1280922580, 1280922586, 'homuth', 'public', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1064, 13, 0, 'News', '', '', 0, 'editors/news.php', '', '', '', '', 3, 1, 0, '_self', 0, 0, 1231323413, 1231323413, 'homuth', 'de_editors', 'de', 'iso-8859-1', '11', '1', '1', '1'), (1065, 15, 0, 'News-Archiv', '', '', 0, 'editors/news_archiv.php', '', '', '', '', 3, 0, 0, '_self', 0, 0, 1233181058, 1233219193, 'homuth', 'de_editors', 'de', 'iso-8859-1', '11', '1', '0', '0'), (1066, 517, 0, 'neue News', '', 'Inhalt folgt.', 19, '', '', '', '', '', 0, 0, 0, '_self', 0, 0, 1281041879, 1281041879, '', 'public', 'de', 'iso-8859-1', '11', '0', '0', '1'), (1070, 521, 0, 'Ausstellung am 13.August 2010', '', 'Inhalt folgt.', 19, '', '', '', '', '', 513, 0, 0, '_self', 0, 0, 1281045741, 1281045799, 'homuth', 'public', 'de', 'iso-8859-1', '11', '0', '0', '1'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_privat_messages` -- CREATE TABLE IF NOT EXISTS `cm_privat_messages` ( `id` int(10) NOT NULL auto_increment, `from_user_name` varchar(100) NOT NULL default '', `from_user_id` int(10) NOT NULL default '0', `to_user_name` varchar(100) NOT NULL default '', `to_user_id` int(10) NOT NULL default '0', `subject` varchar(100) NOT NULL default '', `body` text NOT NULL, `send_time` int(10) NOT NULL default '0', `read_time` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Daten f?r Tabelle `cm_privat_messages` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_recommend` -- CREATE TABLE IF NOT EXISTS `cm_recommend` ( `id` int(10) NOT NULL auto_increment, `to_email` varchar(200) NOT NULL default '', `user_id` int(10) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `first_name` varchar(100) NOT NULL default '', `email` varchar(200) NOT NULL default '', `comment` text NOT NULL, `time` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Daten f?r Tabelle `cm_recommend` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_searchlog` -- CREATE TABLE IF NOT EXISTS `cm_searchlog` ( `id` int(10) NOT NULL auto_increment, `search_term` text NOT NULL, `user_id` int(10) NOT NULL default '0', `ip` varchar(100) NOT NULL default '', `time` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Daten f?r Tabelle `cm_searchlog` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_settings` -- CREATE TABLE IF NOT EXISTS `cm_settings` ( `id` int(10) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `cathegory` varchar(100) NOT NULL default '', `description` varchar(100) NOT NULL default '', `data` varchar(200) NOT NULL default '', `shop_id` varchar(20) NOT NULL default '0', `user_group` varchar(20) NOT NULL default '', `changeable` int(1) NOT NULL default '0', `input_type` varchar(20) NOT NULL default '', `values` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- Daten f?r Tabelle `cm_settings` -- INSERT INTO `cm_settings` (`id`, `name`, `cathegory`, `description`, `data`, `shop_id`, `user_group`, `changeable`, `input_type`, `values`) VALUES (1, 'currency', 'shop', 'Währung', 'Euro', '0', 'ev', 0, '', ''), (2, 'notify_order', 'shop', 'Benachrichtigung über neue Bestellungen an folgende Email-Adresse', '[email protected]', '0', '', 0, '', ''), (3, 'minimum', 'shop', 'Mindesbestellwert in Euro', '0,01', '0', '', 0, '', ''), (4, 'reminder1_fee', 'shop', 'Mahngebühr', '3.00', '0', '', 0, '', ''), (5, 'reminder2_fee', 'shop', 'Mahngebühr', '3.00', '0', '', 0, '', ''), (6, 'transport_limit', 'shop', 'Summe ab der die Transportkosten entfallen', '20', '0', 'ev', 0, '', ''), (7, 'transport_limit_worldwide', 'shop', 'Summe ab der die Transportkosten entfallen (weltweit)', '0', '0', 'ev', 0, '', ''), (8, 'transport_limit_europe', 'shop', 'Summe ab der die Transportkosten entfallen (Europa)', '0', '0', 'ev', 0, '', ''), (9, 'warning_stock_limit', 'shop', 'Ab welcher Anzahl soll ein Warenbestand-Defizit gemeldet werden.', '10', '0', '', 0, '', ''), (10, 'bill_spacer', 'shop', 'Freiraum über der Rechnung für das Logo', '20', '0', '', 0, '', ''), (11, 'decrement_stock', 'shop', 'Reduziere Warenbestand nach Bestellung', '0', '0', '', 0, 'select', '0=>aus, 1=>ein'), (12, 'collect_enable', 'shop', 'Sammel-Bestellung', '1', '0', '', 0, 'select', '0=>aus, 1=>ein'), (13, 'servicing', 'system', 'Seite für Wartungsarbeiten sperren!', '0', '0', '', 0, '', ''), (14, 'email', 'system', 'Email des Admin', '[email protected]', '0', '', 1, '', ''), (15, 'new_limit', 'system', 'Zeitspanne "neue im Shop" in Tage', '20', '0', '', 0, '', ''), (16, 'upload_dir', 'system', 'Verzeichnis für Artikel-Bilder', 'UserFiles/Image/articles/', '0', '', 0, '', ''), (17, 'timeout', 'system', 'Zeit nach der die Login-Session automatisch unterbrochen wird (0 ...ausgeschaltet)', '0', '0', '', 1, '', ''), (18, 'article_limit', 'layout', 'Anzahl der Artikel auf einer Seite', '10', '0', '', 0, '', ''), (19, 'last_supply_limit', 'layout', 'Zeitspanne "eingetroffene Lieferungen"', '20', '0', '', 0, '', ''), (20, 'bg_color', 'layout', 'Hintergrundfarbe', '#757575', '0', '', 1, '', ''), (21, 'fg_color', 'layout', 'Vordergrundfarbe', '#0802FB', '0', '', 0, '', ''), (22, 'block_bg_color', 'layout', 'Hintergrund der Blöcke', '#DBDBDE', '0', '', 0, '', ''), (23, 'cms_template', 'layout', 'Template für den öffentlichen Bereich', 'heimatmuseum', '0', '', 1, '', ''), (24, 'cms_login_template', 'layout', 'Template für den Login-Bereich', 'miet_admin', '0', '', 1, '', ''), (25, 'start_page_id', 'layout', 'Startseite', '514', '0', '', 1, '', ''), (26, 'footer', 'layout', 'Text unter dem Shop', 'Manfred Schröder GmbH & Co. KG - Stieffring 8 - D-13627 Berlin - Telefon +49 (0)30 344 30 93 - Telefax +49 (0)30 344 54 85', '0', '', 0, '', ''), (27, 'ip_sperre', 'counter', 'Zähler-Reload-Sperre', '3600', '0', '', 0, '', ''), (28, 'now', 'counter', '', '1000', '0', '', 0, '', ''), (29, 'start', 'counter', 'Zähler-Startwert', '0', '0', '', 0, '', ''), (30, 'allowDoppleEmailUser', 'users', 'Erlaube doppelte Email-Adressen in Benutzer-Datenbank', '0', '0', '', 0, 'select', '0=>nicht erlaubt, 1=>erlaubt'), (31, 'debug_mode', 'system', 'Fehlermeldungen werden nicht gespeichert, sondern angezeigt', '0', '0', '', 0, '', ''), (32, 'bill_length', 'shop', 'Größe der Rechnungs-Tabelle', '16', '0', '', 0, '', ''), (33, 'bill_logo', 'shop', 'Rechnung mit Logo', '1', '0', '', 0, 'select', '0=>ausblenden,1=>einblenden'), (34, 'version', 'system', 'Aktuelle Software-Version', 'campula Onlineshop - 1.1', '0', '', 0, '', ''), (35, 'type', 'system', '0 = Basic, 1 = Professional, 2 = Enterprise', '1', '0', '', 0, '', ''), (36, 'order_acceptance', 'shop', 'Automatische Bestellbest?tigung', '1', '0', '', 0, 'select', '0=>aus, 1=>ein'), (37, 'article_limit', 'system', 'Maximale Artikel-Anzahl, die vom System erlaubt ist.', '5', '0', '', 0, '', ''), (38, 'cms_admin_template', 'layout', 'Template f?r den Admin-Bereich', 'miet_admin', '0', '', 0, '', ''), (39, 'free_products_enabled', 'shop', 'Artikel können auch mit 0 Euro eingestellt werden.', '0', '0', '', 0, 'select', '0=>aus,1=>ein'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_shops` -- CREATE TABLE IF NOT EXISTS `cm_shops` ( `id` int(10) NOT NULL default '0', `ccm_template` varchar(20) NOT NULL default '', `start_page_id` int(10) NOT NULL default '0', `description` varchar(200) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_shops` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_shop_cart` -- CREATE TABLE IF NOT EXISTS `cm_shop_cart` ( `id` int(10) NOT NULL auto_increment, `article_id` int(10) NOT NULL default '0', `number` int(10) NOT NULL default '0', `unity` varchar(10) NOT NULL default '', `article_type_id` int(11) NOT NULL default '0', `option1_id` int(10) NOT NULL default '0', `option2_id` int(10) NOT NULL default '0', `option3_id` int(10) NOT NULL default '0', `session_id` varchar(200) NOT NULL default '', `time` int(10) NOT NULL default '0', `availability_bit` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Daten f?r Tabelle `cm_shop_cart` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_statistik` -- CREATE TABLE IF NOT EXISTS `cm_statistik` ( `id` int(10) NOT NULL default '0', `page_id` int(10) NOT NULL default '0', `page` int(10) NOT NULL default '0', `page_title` varchar(50) NOT NULL default '', `time` int(10) NOT NULL default '0', `ip` varchar(20) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_statistik` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_users` -- CREATE TABLE IF NOT EXISTS `cm_users` ( `id` int(10) NOT NULL auto_increment, `uname` varchar(30) NOT NULL default '', `password` varchar(200) NOT NULL default '', `company` varchar(50) NOT NULL default '', `title` varchar(10) NOT NULL default '', `name` varchar(30) NOT NULL default '', `first_name` varchar(30) NOT NULL default '', `anschrift` varchar(30) NOT NULL default '', `plz` varchar(10) NOT NULL default '', `ort` varchar(50) NOT NULL default '', `country` int(10) NOT NULL default '0', `land` int(10) NOT NULL default '0', `phone` varchar(20) NOT NULL default '', `fax` varchar(20) NOT NULL default '', `email` varchar(100) NOT NULL default '', `birthday_day` int(2) NOT NULL default '-1', `birthday_month` int(2) NOT NULL default '-1', `birthday_year` int(4) NOT NULL default '-1', `language` varchar(10) NOT NULL default 'de', `groups` varchar(255) NOT NULL default 'users', `customer_group` varchar(100) NOT NULL default '1', `newsletter` tinyint(1) NOT NULL default '0', `last_login` int(10) NOT NULL default '0', `access_denied` int(2) default '0', `notification` int(1) NOT NULL default '1', `by_ref_id` int(10) NOT NULL default '0', `signup_time` int(10) NOT NULL default '0', `signup_ip` varchar(50) NOT NULL default '', `status` varchar(10) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ; -- -- Daten f?r Tabelle `cm_users` -- INSERT INTO `cm_users` (`id`, `uname`, `password`, `company`, `title`, `name`, `first_name`, `anschrift`, `plz`, `ort`, `country`, `land`, `phone`, `fax`, `email`, `birthday_day`, `birthday_month`, `birthday_year`, `language`, `groups`, `customer_group`, `newsletter`, `last_login`, `access_denied`, `notification`, `by_ref_id`, `signup_time`, `signup_ip`, `status`) VALUES (1, 'homuth', '', '', 'Frau', 'Homuth', 'Mike', '', '', '', 31, 0, '', '\r\n', '[email protected]', 0, 0, 0, 'de', 'administrator, users, de_editors, en_editors, pl_editors, nl_editors, pt_editors, es_editors, sv_editors, it_editors, fr_editors, service, root', '1', 0, 1281032370, 0, 1, 0, 0, '', 'free'), (2, 'admin', '446a12100c856ce9', '', 'Frau', 'max', 'mustermann', 'anschrfit', '888888', 'berlin', 7, 0, '', '', '[email protected]', 0, 0, 0, 'de', 'users, service, users, administrator, users, de_editors', '1', 1, 1224428141, 16, 1, 0, 0, '', 'free'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_vorlagen` -- CREATE TABLE IF NOT EXISTS `cm_vorlagen` ( `id` int(10) NOT NULL default '0', `vorlagen_id` int(10) NOT NULL default '0', `description_short` varchar(50) NOT NULL default '', `description` text NOT NULL, `subject` varchar(200) NOT NULL default '', `body` text NOT NULL, `language` varchar(10) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_vorlagen` -- -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_whatsnew` -- CREATE TABLE IF NOT EXISTS `cm_whatsnew` ( `time` int(6) NOT NULL default '0', `text` text NOT NULL, `status` varchar(50) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_whatsnew` -- INSERT INTO `cm_whatsnew` (`time`, `text`, `status`) VALUES (1281032370, 'Login: homuth', '0'), (1281032947, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1281032947, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1281045819, 'Logout von homuth (1)', '0'), (1281045820, 'Logout', '0'), (1274819972, 'Delete Page (de)492 von homuth von homuth (1)', '0'), (1274819977, 'Delete Page (de)496 von homuth von homuth (1)', '0'), (1274819982, 'Delete Page (de)497 von homuth von homuth (1)', '0'), (1274819987, 'Delete Page (de)498 von homuth von homuth (1)', '0'), (1274819993, 'Delete Page (de)512 von homuth von homuth (1)', '0'), (1274819995, 'Delete Page (de)494 von homuth von homuth (1)', '0'), (1274819999, 'Delete Page (de)493 von homuth von homuth (1)', '0'), (1274820002, 'Delete Page (de)495 von homuth von homuth (1)', '0'), (1274820005, 'Delete Page (de)499 von homuth von homuth (1)', '0'), (1274820007, 'Delete Page (de)513 von homuth von homuth (1)', '0'), (1274820010, 'Delete Page (de)517 von homuth von homuth (1)', '0'), (1274820938, 'Logout von homuth (1)', '0'), (1274820938, 'Logout', '0'), (1274821246, 'Login: homuth', '0'), (1274821246, 'Login: homuth', '0'), (1274821307, 'Logout von homuth (1)', '0'), (1274821307, 'Logout', '0'), (1274823369, 'Login: homuth', '0'), (1274823369, 'Login: homuth', '0'), (1274823402, 'Logout von homuth (1)', '0'), (1274823402, 'Logout', '0'), (1274824346, 'Login: homuth', '0'), (1274824346, 'Login: homuth', '0'), (1274824380, 'Logout von homuth (1)', '0'), (1274824381, 'Logout', '0'), (1274826239, 'Login: homuth', '0'), (1274826240, 'Login: homuth', '0'), (1274826262, 'Logout von homuth (1)', '0'), (1274826263, 'Logout', '0'), (1274833012, 'Login: homuth', '0'), (1274833013, 'Login: homuth', '0'), (1274869214, 'Login: homuth', '0'), (1274869215, 'Login: homuth', '0'), (1274869299, 'Login: homuth', '0'), (1274869299, 'Login: homuth', '0'), (1274869586, 'Logout von homuth (1)', '0'), (1274869586, 'Logout', '0'), (1274871361, 'Login: homuth', '0'), (1274871361, 'Login: homuth', '0'), (1274875398, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875398, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875617, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875617, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875679, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875679, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875715, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875715, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875742, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274875742, 'Update de Page 23 Page: 0 von homuth von homuth (1)', '0'), (1274901738, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1274901738, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1274902084, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1274902084, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1274902343, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1274902343, 'Update de Page 25 Page: 0 von homuth von homuth (1)', '0'), (1275901514, 'Login: homuth', '0'), (1275901514, 'Login: homuth', '0'), (1275901636, 'Logout von homuth (1)', '0'), (1275901636, 'Logout', '0'), (1275902248, 'Login: homuth', '0'), (1275902248, 'Login: homuth', '0'), (1275902600, 'Login: homuth von homuth (1)', '0'), (1275902600, 'Login: homuth von homuth (1)', '0'), (1275902652, 'Update de Page 24 Page: 0 von homuth von homuth (1)', '0'), (1275902652, 'Update de Page 24 Page: 0 von homuth von homuth (1)', '0'), (1275902948, 'Logout von homuth (1)', '0'), (1275902948, 'Logout', '0'), (1277844334, 'Login: homuth', '0'), (1277844398, 'Logout von homuth (1)', '0'), (1277844398, 'Logout', '0'), (1277847502, 'Login: homuth', '0'), (1277847510, 'Insert de Block 0 von \r\n homuth von homuth (1)', '0'), (1277847720, 'Update Block 471 von homuth von homuth (1)', '0'), (1277847720, 'Update de Page 471 Page: 0 von homuth von homuth (1)', '0'), (1277847728, 'Insert de Block 0 von \r\n homuth von homuth (1)', '0'), (1277847735, 'Update Block 472 von homuth von homuth (1)', '0'), (1277847735, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277847980, 'Logout von homuth (1)', '0'), (1277847980, 'Logout', '0'), (1277847996, 'Login: homuth', '0'), (1277848007, 'Insert de Page f?r Page 0 von \r\n homuth von homuth (1)', '0'), (1277848014, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848014, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848239, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848239, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848364, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848364, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277848588, 'Delete Page (de)471 von homuth von homuth (1)', '0'), (1277848614, 'Update Block 472 von homuth von homuth (1)', '0'), (1277848614, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277848703, 'Update Block 472 von homuth von homuth (1)', '0'), (1277848703, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849074, 'Update Block 472 von homuth von homuth (1)', '0'), (1277849074, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849096, 'Update Block 472 von homuth von homuth (1)', '0'), (1277849096, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849577, 'Update Block 472 von homuth von homuth (1)', '0'), (1277849577, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849585, 'Update Block 472 von homuth von homuth (1)', '0'), (1277849585, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849594, 'Update Block 472 von homuth von homuth (1)', '0'), (1277849594, 'Update de Page 472 Page: 0 von homuth von homuth (1)', '0'), (1277849627, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849642, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1277849642, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1277849646, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849653, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1277849653, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1277849655, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849661, 'Update de Page 476 Page: 0 von homuth von homuth (1)', '0'), (1277849661, 'Update de Page 476 Page: 0 von homuth von homuth (1)', '0'), (1277849664, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849673, 'Update de Page 477 Page: 0 von homuth von homuth (1)', '0'), (1277849673, 'Update de Page 477 Page: 0 von homuth von homuth (1)', '0'), (1277849677, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849698, 'Update de Page 478 Page: 0 von homuth von homuth (1)', '0'), (1277849698, 'Update de Page 478 Page: 0 von homuth von homuth (1)', '0'), (1277849707, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849715, 'Update de Page 479 Page: 0 von homuth von homuth (1)', '0'), (1277849715, 'Update de Page 479 Page: 0 von homuth von homuth (1)', '0'), (1277849719, 'Insert de Page f?r Page 472 von \r\n homuth von homuth (1)', '0'), (1277849726, 'Update de Page 480 Page: 0 von homuth von homuth (1)', '0'), (1277849726, 'Update de Page 480 Page: 0 von homuth von homuth (1)', '0'), (1277850032, 'Logout von homuth (1)', '0'), (1277850032, 'Logout', '0'), (1277850417, 'Login: homuth', '0'), (1277850423, 'Insert de Block 0 von \r\n homuth von homuth (1)', '0'), (1277850451, 'Update Block 512 von homuth von homuth (1)', '0'), (1277850451, 'Update de Page 512 Page: 0 von homuth von homuth (1)', '0'), (1277850459, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277850468, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1277850468, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1277850471, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277850478, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277850478, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277850482, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277850495, 'Update de Page 515 Page: 0 von homuth von homuth (1)', '0'), (1277850495, 'Update de Page 515 Page: 0 von homuth von homuth (1)', '0'), (1277850583, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277850597, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1277850597, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1277850599, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277850609, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1277850609, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1277885832, 'Logout von homuth (1)', '0'), (1277885832, 'Logout', '0'), (1277891772, 'Login: homuth', '0'), (1277892349, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1277892349, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1277892353, 'Logout von homuth (1)', '0'), (1277892353, 'Logout', '0'), (1277894206, 'Login: homuth', '0'), (1277894206, 'Login: homuth', '0'), (1277894401, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277894401, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277894405, 'Logout von homuth (1)', '0'), (1277894405, 'Logout', '0'), (1277894533, 'Login: homuth', '0'), (1277894533, 'Login: homuth', '0'), (1277895860, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277895868, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277895868, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277895916, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277895916, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1277896075, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277896075, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277897179, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277897179, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277897549, 'Logout von homuth (1)', '0'), (1277897549, 'Logout', '0'), (1277897582, 'Login: homuth', '0'), (1277897582, 'Login: homuth', '0'), (1277929825, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1277929825, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1277930374, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1277930374, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1277931082, 'Update de Page 477 Page: 0 von homuth von homuth (1)', '0'), (1277931082, 'Update de Page 477 Page: 0 von homuth von homuth (1)', '0'), (1277932362, 'Update de Page 479 Page: 0 von homuth von homuth (1)', '0'), (1277932362, 'Update de Page 479 Page: 0 von homuth von homuth (1)', '0'), (1277932881, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1277932882, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1277933116, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1277933607, 'Update de Page 519 Page: 0 von homuth von homuth (1)', '0'), (1277933607, 'Update de Page 519 Page: 0 von homuth von homuth (1)', '0'), (1277974915, 'Login: homuth', '0'), (1277974915, 'Login: homuth', '0'), (1277975072, 'Insert de Page f?r Page 518 von \r\n homuth von homuth (1)', '0'), (1277975086, 'Update de Page 520 Page: 0 von homuth von homuth (1)', '0'), (1277975086, 'Update de Page 520 Page: 0 von homuth von homuth (1)', '0'), (1277975089, 'Logout von homuth (1)', '0'), (1277975089, 'Logout', '0'), (1277977786, 'Login: homuth', '0'), (1277977786, 'Login: homuth', '0'), (1277978061, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277978061, 'Update de Page 473 Page: 0 von homuth von homuth (1)', '0'), (1277978210, 'Logout von homuth (1)', '0'), (1277978210, 'Logout', '0'), (1277981370, 'Login: homuth', '0'), (1277981370, 'Login: homuth', '0'), (1277981411, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277981411, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1277981815, 'Logout von homuth (1)', '0'), (1277981815, 'Logout', '0'), (1277985730, 'Login: homuth', '0'), (1277985730, 'Login: homuth', '0'), (1278012391, 'Login: homuth', '0'), (1278012391, 'Login: homuth', '0'), (1278012536, 'Logout', '0'), (1278012536, 'Logout', '0'), (1278013561, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1278013561, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1278070467, 'Login: homuth', '0'), (1278070467, 'Login: homuth', '0'), (1278070563, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1278070563, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1278070803, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1278070803, 'Update de Page 517 Page: 0 von homuth von homuth (1)', '0'), (1278071342, 'Logout von homuth (1)', '0'), (1278071342, 'Logout', '0'), (1278577019, 'Login: homuth', '0'), (1278577019, 'Login: homuth', '0'), (1278579256, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1278579256, 'Update de Page 474 Page: 0 von homuth von homuth (1)', '0'), (1278579401, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278579401, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278579544, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278579544, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278579635, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278579635, 'Update de Page 518 Page: 0 von homuth von homuth (1)', '0'), (1278582443, 'Delete Page (de)472 von homuth von homuth (1)', '0'), (1278582650, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278582650, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278582811, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278582811, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278583777, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278583777, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278583972, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278583972, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584007, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584007, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584109, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584109, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584242, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584242, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584259, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584259, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584361, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584361, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584405, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584405, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584436, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584436, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584448, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278584448, 'Update de Page 475 Page: 0 von homuth von homuth (1)', '0'), (1278585749, 'Logout von homuth (1)', '0'), (1278585750, 'Logout', '0'), (1278585765, 'Login: homuth', '0'), (1278585765, 'Login: homuth', '0'), (1278586069, 'Login: homuth', '0'), (1278586069, 'Login: homuth', '0'), (1278586447, 'Logout von homuth (1)', '0'), (1278586447, 'Logout', '0'), (1280921545, 'Login: homuth', '0'), (1280921546, 'Login: homuth', '0'), (1280922248, 'Delete Page (de)519 von homuth von homuth (1)', '0'), (1280922249, 'Delete Page (de)473 von homuth von homuth (1)', '0'), (1280922251, 'Delete Page (de)517 von homuth von homuth (1)', '0'), (1280922253, 'Delete Page (de)516 von homuth von homuth (1)', '0'), (1280922264, 'Delete Page (de)474 von homuth von homuth (1)', '0'), (1280922269, 'Delete Page (de)475 von homuth von homuth (1)', '0'), (1280922272, 'Delete Page (de)477 von homuth von homuth (1)', '0'), (1280922276, 'Delete Page (de)479 von homuth von homuth (1)', '0'), (1280922280, 'Delete Page (de)514 von homuth von homuth (1)', '0'), (1280922283, 'Delete Page (de)518 von homuth von homuth (1)', '0'), (1280922287, 'Delete Page (de)513 von homuth von homuth (1)', '0'), (1280922290, 'Delete Page (de)515 von homuth von homuth (1)', '0'), (1280922506, 'Update Block 512 von homuth von homuth (1)', '0'), (1280922506, 'Update de Page 512 Page: 0 von homuth von homuth (1)', '0'), (1280922530, 'Update Block 512 von homuth von homuth (1)', '0'), (1280922530, 'Update de Page 512 Page: 0 von homuth von homuth (1)', '0'), (1280922534, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1280922545, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1280922545, 'Update de Page 513 Page: 0 von homuth von homuth (1)', '0'), (1280922547, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1280922561, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1280922561, 'Update de Page 514 Page: 0 von homuth von homuth (1)', '0'), (1280922564, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1280922572, 'Update de Page 515 Page: 0 von homuth von homuth (1)', '0'), (1280922572, 'Update de Page 515 Page: 0 von homuth von homuth (1)', '0'), (1280922580, 'Insert de Page f?r Page 512 von \r\n homuth von homuth (1)', '0'), (1280922586, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1280922586, 'Update de Page 516 Page: 0 von homuth von homuth (1)', '0'), (1280922810, 'Logout von homuth (1)', '0'), (1280922810, 'Logout', '0'), (1281032370, 'Login: homuth', '0'); -- -------------------------------------------------------- -- -- Tabellenstruktur f?r Tabelle `cm_zone_shipping` -- CREATE TABLE IF NOT EXISTS `cm_zone_shipping` ( `id` int(10) NOT NULL default '0', `zone` varchar(100) NOT NULL default '', `description` varchar(200) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f?r Tabelle `cm_zone_shipping` -- INSERT INTO `cm_zone_shipping` (`id`, `zone`, `description`) VALUES (1, 'zone 1', 'Deutschland'), (2, 'zone 2', 'Europa'), (3, 'zone 3', 'weltweit');
Se han encontrado las siguientes palabras clave. Comprueba si esta página está bien optimizada para cada palabra clave en concreto.
(Deseable)