Tabellenstruktur für Tabelle `boxes`
--
CREATE TABLE `boxes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`box_name` varchar(32) NOT NULL,
`position` varchar(16) NOT NULL,
`sort_id` int(4) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`box_type` varchar(16) NOT NULL,
`file_flag` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;
--
-- Daten für Tabelle `boxes`
--
INSERT INTO `boxes` VALUES (1, 'admin', 'admin', 1, 1, 'file', 0);
INSERT INTO `boxes` VALUES (2, 'loginbox', 'login', 1, 1, 'file', 0);
INSERT INTO `boxes` VALUES (3, 'shopping_cart', 'nav', 1, 1, 'file', 0);
INSERT INTO `boxes` VALUES (4, 'categories_0', 'nav', 2, 1, 'file', 0);
INSERT INTO `boxes` VALUES (5, 'categories_1', 'nav', 3, 0, 'file', 0);
INSERT INTO `boxes` VALUES (6, 'categories_2', 'nav', 4, 0, 'file', 0);
INSERT INTO `boxes` VALUES (7, 'categories_3', 'nav', 5, 0, 'file', 0);
INSERT INTO `boxes` VALUES (8, 'categories_4', 'nav', 6, 0, 'file', 0);
INSERT INTO `boxes` VALUES (9, 'categories_5', 'nav', 7, 0, 'file', 0);
INSERT INTO `boxes` VALUES (10, 'categories_6', 'nav', 8, 0, 'file', 0);
INSERT INTO `boxes` VALUES (11, 'categories_7', 'nav', 9, 0, 'file', 0);
INSERT INTO `boxes` VALUES (12, 'categories_8', 'nav', 10, 0, 'file', 0);
INSERT INTO `boxes` VALUES (13, 'categories_9', 'nav', 11, 0, 'file', 0);
INSERT INTO `boxes` VALUES (14, 'categories_10', 'nav', 12, 0, 'file', 0);
INSERT INTO `boxes` VALUES (15, 'categories_11', 'nav', 13, 0, 'file', 0);
INSERT INTO `boxes` VALUES (16, 'whats_new', 'nav', 2, 14, 'file', 0);
INSERT INTO `boxes` VALUES (17, 'add_a_quickie', 'boxen', 1, 0, 'file', 0);
INSERT INTO `boxes` VALUES (18, 'last_viewed', 'boxen', 2, 0, 'file', 0);
INSERT INTO `boxes` VALUES (19, 'blog', 'boxen', 3, 0, 'file', 0);
INSERT INTO `boxes` VALUES (20, 'product_filter', 'boxen', 4, 1, 'file', 0);
INSERT INTO `boxes` VALUES (21, 'filter', 'boxen', 5, 0, 'file', 0);
INSERT INTO `boxes` VALUES (22, 'manufacturers', 'boxen', 6, 1, 'file', 0);
INSERT INTO `boxes` VALUES (23, 'manufacturers_info', 'boxen', 7, 0, 'file', 0);
INSERT INTO `boxes` VALUES (24, 'best_sellers', 'boxen', 8, 0, 'file', 0);
INSERT INTO `boxes` VALUES (25, 'infobox', 'boxen', 9, 0, 'file', 0);
INSERT INTO `boxes` VALUES (26, 'newsletter', 'boxen', 10, 1, 'file', 0);
INSERT INTO `boxes` VALUES (27, 'specials', 'boxen', 11, 1, 'file', 0);
INSERT INTO `boxes` VALUES (28, 'order_history', 'boxen', 12, 0, 'file', 0);
INSERT INTO `boxes` VALUES (29, 'currencies', 'boxen', 13, 0, 'file', 0);
INSERT INTO `boxes` VALUES (30, 'languages', 'boxen', 14, 0, 'file', 0);
INSERT INTO `boxes` VALUES (31, 'news_ticker', 'boxen', 15, 0, 'file', 0);
INSERT INTO `boxes` VALUES (32, 'information', 'boxen', 16, 1, 'file', 0);
INSERT INTO `boxes` VALUES (33, 'cross_selling', 'boxen', 17, 1, 'file', 0);
INSERT INTO `boxes` VALUES (34, 'trusted_shop', 'boxen', 18, 0, 'file', 0);
INSERT INTO `boxes` VALUES (35, 'tagcloud', 'boxen', 19, 1, 'file', 0);
INSERT INTO `boxes` VALUES (36, 'social_bookmarks', 'boxen', 20, 0, 'file', 0);
INSERT INTO `boxes` VALUES (37, 'reviews', 'boxen', 21, 1, 'file', 0);
INSERT INTO `boxes` VALUES (38, 'twitterbox', 'boxen', 22, 0, 'file', 0);
INSERT INTO `boxes` VALUES (39, 'content', 'footer', 1, 1, 'file', 0);
INSERT INTO `boxes` VALUES (40, 'searchhead', 'nav_search', 1, 1, 'file', 0);
INSERT INTO `boxes` VALUES (41, 'votingbox', 'boxen', 2, 0, 'file', 0);
INSERT INTO `boxes` VALUES (45, 'mls_code', 'boxen', 19, 0, 'database', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `boxes_names`
--
CREATE TABLE `boxes_names` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`box_name` varchar(32) NOT NULL,
`box_title` varchar(32) NOT NULL,
`box_desc` text NOT NULL,
`language_id` int(2) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;
--
-- Daten für Tabelle `boxes_names`
--
INSERT INTO `boxes_names` VALUES (1, 'categories_0', 'Categories', '', 1, 1);
INSERT INTO `boxes_names` VALUES (2, 'categories_1', 'Categories1', '', 1, 0);
INSERT INTO `boxes_names` VALUES (3, 'categories_2', 'Categories2', '', 1, 0);
INSERT INTO `boxes_names` VALUES (4, 'categories_3', 'Categories3', '', 1, 0);
INSERT INTO `boxes_names` VALUES (5, 'categories_4', 'Categories4', '', 1, 0);
INSERT INTO `boxes_names` VALUES (6, 'categories_5', 'Categories5', '', 1, 0);
INSERT INTO `boxes_names` VALUES (7, 'categories_6', 'Categories6', '', 1, 0);
INSERT INTO `boxes_names` VALUES (8, 'categories_7', 'Categories7', '', 1, 0);
INSERT INTO `boxes_names` VALUES (9, 'categories_8', 'Categories8', '', 1, 0);
INSERT INTO `boxes_names` VALUES (10, 'categories_9', 'Categories9', '', 1, 0);
INSERT INTO `boxes_names` VALUES (11, 'categories_10', 'Categories10', '', 1, 0);
INSERT INTO `boxes_names` VALUES (12, 'categories_11', 'Categories11', '', 1, 0);
INSERT INTO `boxes_names` VALUES (13, 'add_a_quickie', 'Add a Quickie', '', 1, 0);
INSERT INTO `boxes_names` VALUES (14, 'admin', 'Admin', '', 1, 1);
INSERT INTO `boxes_names` VALUES (15, 'best_sellers', 'Bestseller', '', 1, 1);
INSERT INTO `boxes_names` VALUES (16, 'shopping_cart', 'Cart', '', 1, 1);
INSERT INTO `boxes_names` VALUES (17, 'content', 'more about...', '', 1, 1);
INSERT INTO `boxes_names` VALUES (18, 'currencies', 'currencies', '', 1, 1);
INSERT INTO `boxes_names` VALUES (19, 'newsletter', 'newsletter', '', 1, 1);
INSERT INTO `boxes_names` VALUES (20, 'information', 'information', '', 1, 1);
INSERT INTO `boxes_names` VALUES (21, 'last_viewed', 'last viewed', '', 1, 1);
INSERT INTO `boxes_names` VALUES (22, 'languages', 'languages', '', 1, 0);
INSERT INTO `boxes_names` VALUES (23, 'loginbox', 'login', '', 1, 1);
INSERT INTO `boxes_names` VALUES (24, 'manufacturers', 'manufacturers', '', 1, 1);
INSERT INTO `boxes_names` VALUES (25, 'manufacturers_info', 'manufacturers info', '', 1, 1);
INSERT INTO `boxes_names` VALUES (26, 'order_history', 'order history', '', 1, 1);
INSERT INTO `boxes_names` VALUES (27, 'reviews', 'reviews', '', 1, 1);
INSERT INTO `boxes_names` VALUES (28, 'specials', 'specials', '', 1, 1);
INSERT INTO `boxes_names` VALUES (29, 'twitterbox', 'twitterbox', '', 1, 1);
INSERT INTO `boxes_names` VALUES (30, 'whats_new', 'whats new', '', 1, 1);
INSERT INTO `boxes_names` VALUES (31, 'tagcloud', 'tagcloud', '', 1, 1);
INSERT INTO `boxes_names` VALUES (32, 'news_ticker', 'news ticker', '', 1, 0);
INSERT INTO `boxes_names` VALUES (33, 'infobox', 'infobox', '', 1, 1);
INSERT INTO `boxes_names` VALUES (34, 'social_bookmarks', 'social bookmarks', '', 1, 0);
INSERT INTO `boxes_names` VALUES (35, 'trusted_shop', 'Trusted Shops', '', 1, 1);
INSERT INTO `boxes_names` VALUES (36, 'blog', 'Blog', '', 1, 1);
INSERT INTO `boxes_names` VALUES (37, 'searchhead', 'searchhead', '', 1, 0);
INSERT INTO `boxes_names` VALUES (38, 'product_filter', 'Product Filter', '', 1, 1);
INSERT INTO `boxes_names` VALUES (39, 'cross_selling', 'cross selling', '', 1, 1);
INSERT INTO `boxes_names` VALUES (40, 'filter', 'Filter', '', 1, 0);
INSERT INTO `boxes_names` VALUES (41, 'categories_0', 'Kategorien', '', 2, 1);
INSERT INTO `boxes_names` VALUES (42, 'categories_1', 'Kategorie1', '', 2, 0);
INSERT INTO `boxes_names` VALUES (43, 'categories_2', 'Kategorie2', '', 2, 0);
INSERT INTO `boxes_names` VALUES (44, 'categories_3', 'Kategorie3', '', 2, 0);
INSERT INTO `boxes_names` VALUES (45, 'categories_4', 'Kategorie4', '', 2, 0);
INSERT INTO `boxes_names` VALUES (46, 'categories_5', 'Kategorie5', '', 2, 0);
INSERT INTO `boxes_names` VALUES (47, 'categories_6', 'Kategorie6', '', 2, 0);
INSERT INTO `boxes_names` VALUES (48, 'categories_7', 'Kategorie7', '', 2, 0);
INSERT INTO `boxes_names` VALUES (49, 'categories_8', 'Kategorie8', '', 2, 0);
INSERT INTO `boxes_names` VALUES (50, 'categories_9', 'Kategorie9', '', 2, 0);
INSERT INTO `boxes_names` VALUES (51, 'categories_10', 'Kategorie10', '', 2, 0);
INSERT INTO `boxes_names` VALUES (52, 'categories_11', 'Kategorie11', '', 2, 0);
INSERT INTO `boxes_names` VALUES (53, 'add_a_quickie', 'Schnellkauf', '', 2, 0);
INSERT INTO `boxes_names` VALUES (54, 'admin', 'Adminbox', '', 2, 1);
INSERT INTO `boxes_names` VALUES (55, 'best_sellers', 'Bestseller', '', 2, 1);
INSERT INTO `boxes_names` VALUES (56, 'shopping_cart', 'Warenkorb', '', 2, 1);
INSERT INTO `boxes_names` VALUES (57, 'content', 'Mehr über...', '', 2, 1);
INSERT INTO `boxes_names` VALUES (58, 'currencies', 'Währungen', '', 2, 1);
INSERT INTO `boxes_names` VALUES (59, 'newsletter', 'Newsletter', '', 2, 1);
INSERT INTO `boxes_names` VALUES (60, 'information', 'Informationen', '', 2, 1);
INSERT INTO `boxes_names` VALUES (61, 'last_viewed', 'Zuletzt angesehen', '', 2, 1);
INSERT INTO `boxes_names` VALUES (62, 'languages', 'andere Sprachen', '', 2, 0);
INSERT INTO `boxes_names` VALUES (63, 'loginbox', 'Login', '', 2, 1);
INSERT INTO `boxes_names` VALUES (64, 'manufacturers', 'Hersteller', '', 2, 1);
INSERT INTO `boxes_names` VALUES (65, 'manufacturers_info', 'Infos zum Hersteller', '', 2, 1);
INSERT INTO `boxes_names` VALUES (66, 'order_history', 'Bestellübersicht', '', 2, 1);
INSERT INTO `boxes_names` VALUES (67, 'reviews', 'Bewertungen', '', 2, 1);
INSERT INTO `boxes_names` VALUES (68, 'specials', 'Angebote', '', 2, 1);
INSERT INTO `boxes_names` VALUES (69, 'twitterbox', 'Wir bei Twitter', '', 2, 1);
INSERT INTO `boxes_names` VALUES (70, 'whats_new', 'Neue Artikel', '', 2, 1);
INSERT INTO `boxes_names` VALUES (71, 'tagcloud', 'Tagcloud', '', 2, 1);
INSERT INTO `boxes_names` VALUES (72, 'news_ticker', 'News Ticker', '', 2, 0);
INSERT INTO `boxes_names` VALUES (73, 'infobox', 'Kundengruppe', '', 2, 1);
INSERT INTO `boxes_names` VALUES (74, 'social_bookmarks', 'Social Bookmarks', '', 2, 0);
INSERT INTO `boxes_names` VALUES (75, 'trusted_shop', 'Trusted Shops', '', 2, 1);
INSERT INTO `boxes_names` VALUES (76, 'blog', 'Shop-Blog', '', 2, 1);
INSERT INTO `boxes_names` VALUES (77, 'searchhead', 'Header Suche', '', 2, 0);
INSERT INTO `boxes_names` VALUES (78, 'product_filter', 'Produkt Filter', '', 2, 1);
INSERT INTO `boxes_names` VALUES (79, 'cross_selling', 'Passende Produkte', '', 2, 1);
INSERT INTO `boxes_names` VALUES (80, 'filter', 'Multi Filter', '', 2, 0);
INSERT INTO `boxes_names` VALUES (81, 'votingbox', 'Shop Voting', '', 1, 0);
INSERT INTO `boxes_names` VALUES (82, 'votingbox', 'Shop Bewertungen', '', 2, 0);
Alles anzeigen