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;

-- 
-- Daten fr Tabelle `cms_menu`
-- 

INSERT INTO `cms_menu` (`id`, `menuID`, `title`, `href`) VALUES (1, 1, 'Testseite 1', 'testseite.htm');
INSERT INTO `cms_menu` (`id`, `menuID`, `title`, `href`) VALUES (2, 1, 'Testseite 2', 'testseite2.htm');
INSERT INTO `cms_menu` (`id`, `menuID`, `title`, `href`) VALUES (3, 1, 'Testseite 3', 'testseite3.htm');


CREATE TABLE `cms_menu_names` (
  `id` int(4) NOT NULL,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Daten fr Tabelle `cms_menu_names`
-- 

INSERT INTO `cms_menu_names` VALUES (1, 'Testmen');
INSERT INTO `cms_menu_names` VALUES (2, 'Zweites Testmen');


CREATE TABLE `cms_meta_global` (
  `name` varchar(100) NOT NULL,
  `content` varchar(100) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Daten fr Tabelle `cms_meta_global`
-- 

INSERT INTO `cms_meta_global` VALUES ('author', 'Stefan Wienstrer');
INSERT INTO `cms_meta_global` VALUES ('robots', 'all');


CREATE TABLE `cms_meta_local` (
  `name` varchar(100) NOT NULL,
  `page` int(11) NOT NULL,
  `content` varchar(100) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Daten fr Tabelle `cms_meta_local`
-- 

INSERT INTO `cms_meta_local` VALUES ('description', 1, 'Die ist eine Testseite');
INSERT INTO `cms_meta_local` VALUES ('keywords', 1, 'Test');


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=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Daten fr Tabelle `cms_pages`
-- 

INSERT INTO `cms_pages` VALUES (1, 'testseite', 'Testseite', -1, 1);
INSERT INTO `cms_pages` VALUES (2, 'testseite2', 'Testseite 2', 1, 0);
INSERT INTO `cms_pages` VALUES (3, 'testseite3', 'Testseite 3', 2, 0);


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;

-- 
-- Daten fr Tabelle `cms_settings`
-- 

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');


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 ;

-- 
-- Daten fr Tabelle `cms_skins`
-- 

INSERT INTO `cms_skins` VALUES (1, 'default');


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 ;

-- 
-- Daten fr Tabelle `cms_user`
-- 

INSERT INTO `cms_user` VALUES (1, 'admin', 'bitteaendern');
