42 lines
1.1 KiB
SQL
42 lines
1.1 KiB
SQL
|
|
/*!40101 SET NAMES utf8 */;
|
|
|
|
--
|
|
-- Table structure for table `navigation`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `navigation`;
|
|
CREATE TABLE `navigation` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`controller` varchar(64) DEFAULT NULL,
|
|
`action` varchar(64) DEFAULT NULL,
|
|
`link` varchar(255) DEFAULT NULL,
|
|
`parent_id` int(11) DEFAULT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`sorting` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Table structure for table `page`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `page`;
|
|
CREATE TABLE `page` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(256) NOT NULL,
|
|
`subtitle` varchar(256) DEFAULT NULL,
|
|
`url` varchar(256) NOT NULL,
|
|
`content` text DEFAULT NULL,
|
|
`active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`header_image` varchar(256) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Data
|
|
--
|
|
|
|
INSERT INTO `page` (`title`, `url`, `content`) VALUES ("Home", "home", "Wilkommen bei Katharsis");
|
|
INSERT INTO `navigation` (`name`, `link`) VALUES ("Home", "/");
|