--
-- Tabellenstruktur für Tabelle `as_article`
--
CREATE TABLE `as_article` (
`id` int(8) unsigned zerofill NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Daten für Tabelle `as_article`
--
INSERT INTO `as_article` VALUES (00000001, 'Artikel 1');
INSERT INTO `as_article` VALUES (00000002, 'Artikel 2');
INSERT INTO `as_article` VALUES (00000003, 'Artikel 3');
INSERT INTO `as_article` VALUES (00000004, 'Artikel 4');
INSERT INTO `as_article` VALUES (00000005, 'Artikel 5');
INSERT INTO `as_article` VALUES (00000006, 'Artikel 6');
INSERT INTO `as_article` VALUES (00000007, 'Artikel 7');
INSERT INTO `as_article` VALUES (00000008, 'Artikel 8');
INSERT INTO `as_article` VALUES (00000009, 'Artikel 9');
INSERT INTO `as_article` VALUES (00000010, 'Artikel 10');
INSERT INTO `as_article` VALUES (00000011, 'Artikel 11');
INSERT INTO `as_article` VALUES (00000012, 'Artikel 12');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `as_category`
--
CREATE TABLE `as_category` (
`id` int(8) unsigned zerofill NOT NULL auto_increment,
`id_root` int(8) unsigned zerofill NOT NULL default '00000000',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id_root` (`id_root`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Daten für Tabelle `as_category`
--
INSERT INTO `as_category` VALUES (00000001, 00000000, 'Hauptkategorie 1');
INSERT INTO `as_category` VALUES (00000002, 00000001, 'Unterkategorie 1');
INSERT INTO `as_category` VALUES (00000003, 00000001, 'Unterkategorie 2');
INSERT INTO `as_category` VALUES (00000004, 00000001, 'Unterkategorie 3');
INSERT INTO `as_category` VALUES (00000005, 00000000, 'Hauptkategorie 2');
INSERT INTO `as_category` VALUES (00000006, 00000005, 'Unterkategorie 4');
INSERT INTO `as_category` VALUES (00000007, 00000005, 'Unterkategorie 5');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `xtbl_article_category`
--
CREATE TABLE `xtbl_article_category` (
`id_article` int(8) unsigned zerofill NOT NULL default '00000000',
`id_category` int(8) unsigned zerofill NOT NULL default '00000000',
PRIMARY KEY (`id_article`,`id_category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `xtbl_article_category`
--
INSERT INTO `xtbl_article_category` VALUES (00000001, 00000002);
INSERT INTO `xtbl_article_category` VALUES (00000002, 00000002);
INSERT INTO `xtbl_article_category` VALUES (00000003, 00000002);
INSERT INTO `xtbl_article_category` VALUES (00000004, 00000002);
INSERT INTO `xtbl_article_category` VALUES (00000005, 00000003);
INSERT INTO `xtbl_article_category` VALUES (00000006, 00000004);
INSERT INTO `xtbl_article_category` VALUES (00000007, 00000004);
INSERT INTO `xtbl_article_category` VALUES (00000008, 00000006);
INSERT INTO `xtbl_article_category` VALUES (00000009, 00000007);
INSERT INTO `xtbl_article_category` VALUES (00000010, 00000006);
INSERT INTO `xtbl_article_category` VALUES (00000011, 00000007);
INSERT INTO `xtbl_article_category` VALUES (00000012, 00000007);