0uirZnfx

1/*
2SQLyog Community Edition- MySQL GUI v8.14 
3MySQL - 5.1.37 : Database - jellybean
4*********************************************************************
5*/
6
7/*!40101 SET NAMES utf8 */;
8
9/*!40101 SET SQL_MODE=''*/;
10
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15/*Table structure for table `navigation_contents` */
16
17DROP TABLE IF EXISTS `navigation_contents`;
18
19CREATE TABLE `navigation_contents` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(255) NOT NULL DEFAULT '',
22  `slug` varchar(255) DEFAULT '',
23  `navigation_id` int(11) NOT NULL DEFAULT '0',
24  `lang` varchar(2) NOT NULL DEFAULT '',
25  PRIMARY KEY (`id`),
26  KEY `navigation_id` (`navigation_id`),
27  CONSTRAINT `navigation_contents_ibfk_1` FOREIGN KEY (`navigation_id`) REFERENCES `navigations` (`id`) ON DELETE CASCADE
28) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
29
30/*Data for the table `navigation_contents` */
31
32insert  into `navigation_contents`(`id`,`name`,`slug`,`navigation_id`,`lang`) values (1,'Αρχική σελίδα','αρχική-σελίδα',2,'el'),(2,'Home page','home-page',2,'en'),(3,'Επικοινωνία','επικοινωνία-3',3,'el'),(4,'Contact','contact-3',3,'en'),(5,'Η εταιρία μας','η-εταιρία-μας',4,'el'),(6,'Our company','our-company',4,'en'),(21,'abc','abc',13,'el'),(22,'123','123',13,'en'),(25,'zxc','zxc-15',15,'el'),(26,'zxc','zxc-15',15,'en'),(29,'asd','asd',17,'el'),(30,'zxc','zxc-17',17,'en'),(31,'Επικοινωνία','επικοινωνία',18,'el'),(32,'Contact','contact',18,'en');
33
34/*Table structure for table `navigation_groups` */
35
36DROP TABLE IF EXISTS `navigation_groups`;
37
38CREATE TABLE `navigation_groups` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `name` varchar(255) NOT NULL DEFAULT '',
41  `description` text NOT NULL,
42  PRIMARY KEY (`id`)
43) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
44
45/*Data for the table `navigation_groups` */
46
47insert  into `navigation_groups`(`id`,`name`,`description`) values (11,'header',''),(12,'sidebar','Μενού πλαινής στήλης.');
48
49/*Table structure for table `navigations` */
50
51DROP TABLE IF EXISTS `navigations`;
52
53CREATE TABLE `navigations` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `name` varchar(255) NOT NULL DEFAULT '',
56  `page` int(11) NOT NULL DEFAULT '0',
57  `module` int(11) NOT NULL DEFAULT '0',
58  `link` varchar(255) NOT NULL DEFAULT '',
59  `target` varchar(10) NOT NULL,
60  `navigation_group_id` int(11) NOT NULL DEFAULT '0',
61  `lft` int(11) NOT NULL,
62  `rgt` int(11) NOT NULL,
63  `lvl` int(11) NOT NULL,
64  `scope` int(11) NOT NULL,
65  `is_default` tinyint(1) NOT NULL DEFAULT '0',
66  `is_active` tinyint(1) NOT NULL DEFAULT '1',
67  PRIMARY KEY (`id`)
68) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
69
70/*Data for the table `navigations` */
71
72insert  into `navigations`(`id`,`name`,`page`,`module`,`link`,`target`,`navigation_group_id`,`lft`,`rgt`,`lvl`,`scope`,`is_default`,`is_active`) values (1,'root',0,0,'','0',11,1,16,0,0,0,1),(2,'Αρχική σελίδα / Home page',29,0,'','_self',11,2,3,1,0,0,1),(3,'Επικοινωνία / Contact',0,3,'','_self',11,4,5,1,0,0,1),(4,'Η εταιρία μας / Our company',32,0,'','_self',11,6,11,1,0,0,1),(13,'abc / 123',29,0,'','_blank',11,8,9,3,0,0,1),(15,'zxc / zxc',29,0,'','_self',11,7,10,2,0,0,1),(17,'asd / zxc',32,0,'','_self',11,12,13,1,0,0,1),(18,'Επικοινωνία / Contact',0,3,'','_self',11,14,15,1,0,0,1);
73
74/*Table structure for table `page_contents` */
75
76DROP TABLE IF EXISTS `page_contents`;
77
78CREATE TABLE `page_contents` (
79  `id` int(11) NOT NULL AUTO_INCREMENT,
80  `name` varchar(255) NOT NULL DEFAULT '',
81  `title` varchar(255) NOT NULL DEFAULT '',
82  `slug` varchar(255) NOT NULL DEFAULT '',
83  `body` text NOT NULL,
84  `meta_keywords` varchar(255) NOT NULL DEFAULT '',
85  `meta_description` text NOT NULL,
86  `lang` varchar(5) NOT NULL DEFAULT '',
87  `page_id` int(11) NOT NULL DEFAULT '0',
88  PRIMARY KEY (`id`)
89) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
90
91/*Data for the table `page_contents` */
92
93insert  into `page_contents`(`id`,`name`,`title`,`slug`,`body`,`meta_keywords`,`meta_description`,`lang`,`page_id`) values (52,'Αρχική Σελίδα','Καλώς ήρθατε στην ιστοσελίδα μας','αρχική-σελίδα','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec ultricies lacus nec nisi aliquet porta. Donec dapibus adipiscing est, quis condimentum purus vehicula sit amet. Nunc commodo, mi eget ultrices lobortis, ante tellus posuere nisl, quis luctus diam magna elementum ante. Curabitur dapibus est quis augue pretium et euismod mi blandit. Mauris ultrices consequat augue, id mollis quam tempor sit amet. Aenean suscipit commodo nibh, mattis varius tellus facilisis at. Aliquam vel arcu sit amet justo ultricies bibendum a varius sem. Phasellus porta, magna ac tempor ultrices, lorem magna tristique nibh, volutpat lacinia leo lorem non diam. Nam mattis facilisis lorem, ac ullamcorper erat dictum a. Phasellus ut libero tortor, in pulvinar urna. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus malesuada ultrices diam, at fringilla mi consectetur posuere. Sed vitae quam at lectus interdum commodo. Aenean tempus neque vitae lectus tincidunt fermentum iaculis est pulvinar. Integer aliquet consequat blandit. Sed vitae faucibus velit. Nam ut nibh at dolor fermentum consectetur vitae vel odio. Vestibulum vel dignissim nunc. Aenean consequat erat at erat vulputate tristique. <br></p>\n<p>Quisque molestie turpis eu mi posuere lacinia. Sed in turpis vitae nisi tristique auctor ac at lorem. Phasellus fermentum eleifend metus, in lacinia ipsum imperdiet rutrum. Duis commodo est ligula. Aliquam ut est ut turpis dictum vulputate et ut justo. Nullam ligula mauris, pulvinar vel porttitor vel, convallis sed enim. Phasellus porta turpis dui. Proin tempor, elit vel dapibus lacinia, nulla orci pellentesque justo, quis ullamcorper nibh nisl vel lectus. Maecenas lacinia placerat vulputate. Suspendisse tempus nisi in tellus pharetra sit amet egestas odio auctor. Nam nulla lacus, gravida sodales tempus at, commodo vitae nulla. In fringilla purus vel nisl porttitor eget vulputate felis euismod. Praesent vitae vestibulum neque. Quisque vitae eros vitae risus consectetur iaculis ut sed leo. Nullam mattis nibh ut mi suscipit accumsan. Phasellus commodo mauris eu lectus fermentum iaculis. Suspendisse nisi tellus, imperdiet id lacinia eget, vestibulum hendrerit nunc. Donec et metus massa, eleifend adipiscing lacus. Integer commodo lectus enim.</p>','','','el',29),(55,'Home Page','Home Page','home-page','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec ultricies lacus nec nisi aliquet porta. Donec dapibus adipiscing est, quis condimentum purus vehicula sit amet. Nunc commodo, mi eget ultrices lobortis, ante tellus posuere nisl, quis luctus diam magna elementum ante. Curabitur dapibus est quis augue pretium et euismod mi blandit. Mauris ultrices consequat augue, id mollis quam tempor sit amet. Aenean suscipit commodo nibh, mattis varius tellus facilisis at. Aliquam vel arcu sit amet justo ultricies bibendum a varius sem. Phasellus porta, magna ac tempor ultrices, lorem magna tristique nibh, volutpat lacinia leo lorem non diam. Nam mattis facilisis lorem, ac ullamcorper erat dictum a. Phasellus ut libero tortor, in pulvinar urna. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus malesuada ultrices diam, at fringilla mi consectetur posuere. Sed vitae quam at lectus interdum commodo. Aenean tempus neque vitae lectus tincidunt fermentum iaculis est pulvinar. Integer aliquet consequat blandit. Sed vitae faucibus velit. Nam ut nibh at dolor fermentum consectetur vitae vel odio. Vestibulum vel dignissim nunc. Aenean consequat erat at erat vulputate tristique.\n\nQuisque molestie turpis eu mi posuere lacinia. Sed in turpis vitae nisi tristique auctor ac at lorem. Phasellus fermentum eleifend metus, in lacinia ipsum imperdiet rutrum. Duis commodo est ligula. Aliquam ut est ut turpis dictum vulputate et ut justo. Nullam ligula mauris, pulvinar vel porttitor vel, convallis sed enim. Phasellus porta turpis dui. Proin tempor, elit vel dapibus lacinia, nulla orci pellentesque justo, quis ullamcorper nibh nisl vel lectus. Maecenas lacinia placerat vulputate. Suspendisse tempus nisi in tellus pharetra sit amet egestas odio auctor. Nam nulla lacus, gravida sodales tempus at, commodo vitae nulla. In fringilla purus vel nisl porttitor eget vulputate felis euismod. Praesent vitae vestibulum neque. Quisque vitae eros vitae risus consectetur iaculis ut sed leo. Nullam mattis nibh ut mi suscipit accumsan. Phasellus commodo mauris eu lectus fermentum iaculis. Suspendisse nisi tellus, imperdiet id lacinia eget, vestibulum hendrerit nunc. Donec et metus massa, eleifend adipiscing lacus. Integer commodo lectus enim.','','','en',29),(56,'Η εταιρία μας','Η εταιρία μας','η-εταιρία-μας','There are many variations of passages of Lorem Ipsum available, but the\nmajority have suffered alteration in some form, by injected humour, or\nrandomised words which don\'t look even slightly believable. If you are\ngoing to use a passage of Lorem Ipsum, you need to be sure there isn\'t\nanything embarrassing hidden in the middle of text. All the Lorem Ipsum\ngenerators on the Internet tend to repeat predefined chunks as\nnecessary, making this the first true generator on the Internet. It\nuses a dictionary of over 200 Latin words, combined with a handful of\nmodel sentence structures, to generate Lorem Ipsum which looks\nreasonable. The generated Lorem Ipsum is therefore always free from\nrepetition, injected humour, or non-characteristic words etc.','','','el',32),(57,'Our company','Our company','our-company','There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.','','','en',32),(58,'Συχνές ερωτήσεις','Συχνές ερωτήσεις','συχνές-ερωτήσεις','Αυτή είναι η σελίδα για τις συχνές ερωτήσεις.','','','el',33),(59,'FAQ','FAQ','faq','This is the FAQ Page.','','','en',33);
94
95/*Table structure for table `pages` */
96
97DROP TABLE IF EXISTS `pages`;
98
99CREATE TABLE `pages` (
100  `id` int(11) NOT NULL AUTO_INCREMENT,
101  `name` varchar(255) NOT NULL DEFAULT '',
102  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
103  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
104  PRIMARY KEY (`id`)
105) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
106
107/*Data for the table `pages` */
108
109insert  into `pages`(`id`,`name`,`created_on`,`updated_on`) values (29,'Αρχική Σελίδα / Home Page','2009-08-06 12:13:53','2009-08-19 17:10:24'),(32,'Η εταιρία μας / Our company','2009-08-12 02:53:54','2009-08-18 18:23:40'),(33,'Συχνές ερωτήσεις / FAQ','2009-08-27 02:25:58','2009-08-27 02:25:58');
110
111/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
112/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
113/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
114/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;