CREATE TABLE `cms_menu` (
  `id` int(2) NOT NULL,
  `menuID` int(3) NOT NULL,
  `title` varchar(100) NOT NULL,
  `href` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`,`menuID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cms_menu_names` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
CREATE TABLE `cms_meta_global` (
  `name` varchar(100) NOT NULL,
  `content` varchar(100) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cms_meta_local` (
  `name` varchar(100) NOT NULL,
  `page` int(11) NOT NULL,
  `content` varchar(100) NOT NULL,
  PRIMARY KEY  (`name`,`page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cms_pages` (
  `id` int(8) NOT NULL auto_increment,
  `alias` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `owner` int(11) NOT NULL default '-1',
  `menu` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
CREATE TABLE `cms_settings` (
  `property` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `activated` int(1) NOT NULL default '1',
  `description` varchar(75) NOT NULL,
  PRIMARY KEY  (`property`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `cms_skins` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE TABLE `cms_user` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


INSERT INTO `cms_menu` VALUES (1, 1, 'Testseite 1', 'testseite.html');
INSERT INTO `cms_menu` VALUES (2, 1, 'Testseite 2', 'testseite2.html');
INSERT INTO `cms_menu` VALUES (3, 1, 'CMS-Aktion', 'http://blog.stevieswebsite.de/eigenes-cms-erstellen/');
INSERT INTO `cms_menu_names` VALUES (1, 'Testmen');
INSERT INTO `cms_meta_global` VALUES ('author', 'Stefan Wienstrer');
INSERT INTO `cms_meta_global` VALUES ('robots', 'all');
INSERT INTO `cms_meta_local` VALUES ('description', 1, 'Die ist eine Testseite');
INSERT INTO `cms_meta_local` VALUES ('keywords', 1, 'Test');
INSERT INTO `cms_pages` VALUES (1, 'testseite', 'Testseite', -1, 1);
INSERT INTO `cms_pages` VALUES (2, 'testseite2', 'Testseite 2', 1, 1);
INSERT INTO `cms_pages` VALUES (3, 'testseite3', 'Testseite 3', 2, 0);
INSERT INTO `cms_settings` VALUES ('title', 'Test CMS', 1, 'Titel des CMS');
INSERT INTO `cms_settings` VALUES ('selectedskin', '1', 1, 'Aktueller Skin');
INSERT INTO `cms_settings` VALUES ('globalmenuid', '1', 1, 'Globales Men');
INSERT INTO `cms_settings` VALUES ('skinbgcolor', 'adadad', 1, 'Hintergrundfarbe');
INSERT INTO `cms_settings` VALUES ('skinforecolor', '525252', 1, 'Schriftfarbe');
INSERT INTO `cms_settings` VALUES ('skinhighlight1', '7cad00', 1, 'Highlight Farbe 1');
INSERT INTO `cms_settings` VALUES ('skinhighlight2', 'b3fa00', 1, 'Highlight Farbe 2');
INSERT INTO `cms_settings` VALUES ('host', 'http://cms.stevieswebsite.de', 1, 'URL der Startseite');
INSERT INTO `cms_skins` VALUES (1, 'default');