--
-- Host: localhost    Database: finger
-- ------------------------------------------------------


--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int NOT NULL AUTO_INCREMENT,
  `template_id` int NOT NULL,
  `template_field_id` int NOT NULL,
  `item_id` int NOT NULL,
  `url` varchar(246) NOT NULL,
  `label` varchar(256) NOT NULL,
  `watermarked` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `lookup_tid_tfid_iid_url` (`template_id`,`template_field_id`,`item_id`,`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `images`
--


--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `code` char(2) NOT NULL DEFAULT '',
  `site_id` int NOT NULL DEFAULT '0',
  `title` varchar(20) NOT NULL DEFAULT '',
  `main` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`code`,`site_id`),
  KEY `site_id_main` (`site_id`,`main`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES ('el',1,'Ελληνικά',1),('en',1,'English',0);

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `type` varchar(128) NOT NULL,
  `title_el` varchar(1024) NOT NULL,
  `title_en` varchar(1024) NOT NULL,
  `target` tinyint NOT NULL,
  `url_el` varchar(1024) NOT NULL,
  `url_en` varchar(1024) NOT NULL,
  `mid` int NOT NULL,
  `table_name` varchar(65) NOT NULL DEFAULT '',
  `table_record_id` int DEFAULT NULL,
  `order_id` int NOT NULL,
  `site_id` int NOT NULL,
  `active` tinyint NOT NULL DEFAULT '1',
  `deleted` tinyint NOT NULL DEFAULT '0',
  `menu_id` int NOT NULL DEFAULT '1' COMMENT 'FK to submenu.id',
  `modal` varchar(45) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` VALUES (1,0,'custom','Home','',0,'/','',0,'',NULL,1,1,1,1,1,''),(2,0,'custom','Home','Home',0,'/','/en',0,'',NULL,1,1,1,1,1,''),(3,0,'custom','About Us','About Us',0,'','/en/aboutus',0,'',NULL,1,1,1,0,1,''),(4,0,'custom','Tours','Tours',0,'/packages','/en/packages',0,'',NULL,4,1,1,1,1,''),(5,0,'custom','Experiences','Experiences',0,'/experiences','/en/experiences',0,'',NULL,5,1,1,1,1,''),(6,0,'custom','Team Buildings & Events','Team Buildings & Events',0,'/teamsandevents','/en/teamsandevents',0,'',NULL,6,1,1,1,1,''),(7,0,'custom','Collaborators','Collaborators',0,'','/en/collabs',0,'',NULL,2,1,0,0,1,''),(8,0,'custom','Contacts','Contacts',0,'/contact','/en/contact',0,'',NULL,3,1,1,0,1,''),(9,0,'template','Όροι χρήσης ','Terms Of Use',0,'','',23,'t_content',1,1,1,1,0,2,''),(10,0,'template','Πολιτική επιστροφών / ακυρώσεων','Order Cancellation',0,'','',23,'t_content',2,2,1,1,0,2,''),(11,0,'template','Πολιτική Απορρήτου','Confidentiality',0,'','',23,'t_content',3,3,1,1,0,2,''),(12,0,'template','Τρόποι Πληρωμής ','Payment Methods',0,'','',23,'t_content',4,12,1,1,1,2,''),(13,0,'template','Ασφάλεια Συναλλαγών','Security',0,'','',23,'t_content',5,13,1,1,1,2,''),(14,0,'template','Στοιχεία της Επιχείρησης','Company ',0,'','',23,'t_content',6,14,1,1,1,2,''),(15,0,'template','','',0,'','',0,'',0,15,1,1,1,1,''),(16,0,'template','','',1,'','',0,'',0,4,1,1,0,1,'');

--
-- Table structure for table `menu_admin`
--

CREATE TABLE `menu_admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT '0',
  `type` varchar(128) DEFAULT '',
  `title` varchar(1024) DEFAULT '',
  `target` tinyint DEFAULT '0',
  `url` varchar(1024) DEFAULT '',
  `mid` int DEFAULT '0',
  `order_id` int DEFAULT '0',
  `site_id` int DEFAULT '0',
  `deleted` tinyint DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `menu_admin`
--

INSERT INTO `menu_admin` VALUES (1,0,'custom','Super Admin',0,'www.musiccoderadio.com',0,1,0,0),(2,1,'custom','Minisites',0,'/admin/minisites.php?site_id=0&action=',0,1,0,0),(3,1,'custom','Templates',0,'/admin/template.php?site_id=0&action=',0,2,0,0),(4,1,'custom','Πίνακες Περιεχομένων',0,'/admin/template_content.php?site_id=0&action=',0,3,0,0),(5,1,'custom','Modules',0,'/admin/modules.php?site_id=0&action=',0,4,0,0),(6,1,'custom','Γλώσσες',0,'/admin/language.php?site_id=0&action=',0,5,0,0),(7,1,'custom','Μενού Διαχειριστικού',0,'/admin/menu_admin.php?site_id=0&action=',0,6,0,0),(8,0,'custom','Αρχική',0,'',0,1,1,1),(9,0,'custom','Περιεχόμενο',0,'',0,5,1,0),(10,0,'custom','Γενικές Ρυθμίσεις',0,'',0,6,1,0),(12,10,'custom','Μενού',0,'/admin/menu.php?site_id=1&action=',0,3,1,0),(13,10,'custom','Χρήστες',0,'/admin/user.php?site_id=1&action=',0,1,1,0),(14,10,'custom','Νέος Χρήστης',0,'/admin/user.php?site_id=1&action=new',0,2,1,0),(15,1,'custom','Χρήστες (RBAC)',0,'/admin/user.php?site_id=0&action=',0,7,0,0),(16,1,'custom','Ρόλοι (RBAC)',0,'/admin/user_role.php?site_id=0&action=',0,8,0,0),(17,9,'template','Experiences',1,'/admin/template_content.php?site_id=1&template_id=9&action=view_table',9,1,1,1),(18,9,'template','Experiences',1,'/admin/template_content.php?site_id=1&template_id=11&action=view_table',11,1,1,0),(19,21,'template','Packages',1,'/admin/template_content.php?site_id=1&template_id=12&action=view_table',12,1,1,1),(20,0,'custom','My Packages',1,'',0,5,0,1),(21,0,'custom','My Packages',1,'',0,2,1,0),(22,21,'template','Packages Categories',1,'/admin/template_content.php?site_id=1&template_id=13&action=view_table',13,1,1,0),(23,0,'custom','Orders',1,'',0,7,1,0),(24,23,'template','Orders',1,'/admin/template_content.php?site_id=1&template_id=14&action=view_table',14,1,1,0),(25,26,'template','Teams & Events',1,'/admin/template_content.php?site_id=1&template_id=16&action=view_table',16,1,1,0),(26,0,'custom','Teams & Events',1,'',0,3,1,0),(27,26,'template','Teams & Events Page',1,'/admin/template_content.php?site_id=1&template_id=17&action=view_table',17,2,1,1),(28,9,'template','About Us',1,'/admin/template_content.php?site_id=1&template_id=18&action=view_table',18,2,1,0),(29,0,'custom','Collaborations ',1,'',0,4,1,0),(30,29,'template','Collaborations Categories',1,'/admin/template_content.php?site_id=1&template_id=19&action=view_table',19,1,1,1),(31,29,'template','Collab Categories',1,'/admin/template_content.php?site_id=1&template_id=19&action=view_table',19,1,1,0),(32,29,'template','Collab Customers',1,'/admin/template_content.php?site_id=1&template_id=20&action=view_table',20,2,1,0),(33,10,'template','Settings',1,'/admin/template_content.php?site_id=1&template_id=1&action=view_table',1,4,1,0),(34,9,'template','FAQ',1,'/admin/template_content.php?site_id=1&template_id=22&action=view_table',22,3,1,0),(35,0,'custom','Home',1,'',0,1,1,0),(36,35,'template','Home',1,'/admin/template_content.php?site_id=1&template_id=21&action=view_table',21,1,1,1),(37,9,'template','Other Pages',1,'/admin/template_content.php?site_id=1&template_id=23&action=view_table',23,4,1,0);

--
-- Table structure for table `minisites`
--

CREATE TABLE `minisites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(1024) NOT NULL,
  `domain` varchar(1024) NOT NULL,
  `template` varchar(1024) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `order_id` int NOT NULL,
  `deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `minisites`
--

INSERT INTO `minisites` VALUES (0,'Admin','IbHellas','ibhellas',0,100,0),(1,'Website Name','betostokos,fingertrip.com.gr,betostokos.com','demo',0,1,0);

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(512) NOT NULL,
  `file` varchar(512) NOT NULL,
  `menu_id` int NOT NULL DEFAULT '1',
  `order_id` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` VALUES (1,'','',1,1);

--
-- Table structure for table `phprbac_permissions`
--

CREATE TABLE `phprbac_permissions` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `Lft` int NOT NULL,
  `Rght` int NOT NULL,
  `Title` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Title` (`Title`),
  KEY `Lft` (`Lft`),
  KEY `Rght` (`Rght`)
) ENGINE=InnoDB AUTO_INCREMENT=461 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `phprbac_permissions`
--

INSERT INTO `phprbac_permissions` VALUES (1,0,609,'root','root'),(2,1,608,'module','User can call any action in any module'),(3,2,11,'board','User can call any action in module: \'board\''),(4,3,4,'index','User can call action: \'index\' in module: \'board\''),(5,5,6,'add','User can call action: \'add\' in module: \'board\''),(6,7,8,'edit','User can call action: \'edit\' in module: \'board\''),(7,9,10,'delete','User can call action: \'delete\' in module: \'board\''),(8,12,17,'board_content','User can call any action in module: \'board_content\''),(9,13,14,'index','User can call action: \'index\' in module: \'board_content\''),(10,15,16,'edit','User can call action: \'edit\' in module: \'board_content\''),(11,18,27,'language','User can call any action in module: \'language\''),(12,19,20,'index','User can call action: \'index\' in module: \'language\''),(13,21,22,'add','User can call action: \'add\' in module: \'language\''),(14,23,24,'edit','User can call action: \'edit\' in module: \'language\''),(15,25,26,'delete','User can call action: \'delete\' in module: \'language\''),(16,28,45,'menu','User can call any action in module: \'menu\''),(17,29,30,'index','User can call action: \'index\' in module: \'menu\''),(18,31,32,'new','User can call action: \'new\' in module: \'menu\''),(19,33,34,'edit','User can call action: \'edit\' in module: \'menu\''),(20,35,36,'delete','User can call action: \'delete\' in module: \'menu\''),(21,37,38,'add_submenu','User can call action: \'add_submenu\' in module: \'menu\''),(22,39,40,'edit_submenu','User can call action: \'edit_submenu\' in module: \'menu\''),(23,41,42,'delete_submenu','User can call action: \'delete_submenu\' in module: \'menu\''),(24,43,44,'reorder','User can call action: \'reorder\' in module: \'menu\''),(25,46,57,'menu_admin','User can call any action in module: \'menu_admin\''),(26,47,48,'index','User can call action: \'index\' in module: \'menu_admin\''),(27,49,50,'new','User can call action: \'new\' in module: \'menu_admin\''),(28,51,52,'edit','User can call action: \'edit\' in module: \'menu_admin\''),(29,53,54,'delete','User can call action: \'delete\' in module: \'menu_admin\''),(30,55,56,'reorder','User can call action: \'reorder\' in module: \'menu_admin\''),(31,58,69,'minisites','User can call any action in module: \'minisites\''),(32,59,60,'index','User can call action: \'index\' in module: \'minisites\''),(33,61,62,'new','User can call action: \'new\' in module: \'minisites\''),(34,63,64,'edit','User can call action: \'edit\' in module: \'minisites\''),(35,65,66,'delete','User can call action: \'delete\' in module: \'minisites\''),(36,67,68,'set_active','User can call action: \'set_active\' in module: \'minisites\''),(37,70,71,'modules','User can call any action in module: \'modules\''),(38,72,83,'template','User can call any action in module: \'template\''),(39,73,74,'index','User can call action: \'index\' in module: \'template\''),(40,75,76,'add','User can call action: \'add\' in module: \'template\''),(41,77,78,'edit','User can call action: \'edit\' in module: \'template\''),(42,79,80,'delete','User can call action: \'delete\' in module: \'template\''),(43,81,82,'searchTemplates','User can call action: \'searchTemplates\' in module: \'template\''),(44,84,571,'template_content','User can call any action in module: \'template_content\' regarding any template.'),(45,85,132,'1','User can call all actions in module: \'template_content\' regarding template: \'Settings\'.'),(46,86,87,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Settings\'.'),(47,88,89,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Settings\'.'),(48,90,113,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Settings\'.  All template fields are editable.'),(49,91,92,'1','User can edit field: \'Γενικός Τίτλος\'\'.'),(50,93,94,'2','User can edit field: \'Λογότυπο\'\'.'),(51,95,96,'7','User can edit field: \'Facebook\'\'.'),(52,97,98,'8','User can edit field: \'Instagram\'\'.'),(53,99,100,'10','User can edit field: \'TikTok\'\'.'),(56,101,102,'3','User can edit field: \'E-mail\'\'.'),(58,103,104,'5','User can edit field: \'Κινητό\'\'.'),(59,105,106,'6','User can edit field: \'Διεύθυνση\'\'.'),(60,114,115,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Settings\'.'),(61,116,117,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Settings\'.'),(62,118,119,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Settings\'.'),(63,120,121,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Settings\'.'),(64,122,123,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Settings\'.'),(65,124,125,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Settings\'.'),(66,126,127,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Settings\'.'),(67,128,129,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Settings\'.'),(68,130,131,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Settings\'.'),(69,572,583,'user','User can call any action in module: \'user\''),(70,573,574,'index','User can call action: \'index\' in module: \'user\''),(71,575,576,'add','User can call action: \'add\' in module: \'user\''),(72,577,578,'view','User can call action: \'view\' in module: \'user\''),(73,579,580,'edit','User can call action: \'edit\' in module: \'user\''),(74,581,582,'delete','User can call action: \'delete\' in module: \'user\''),(75,584,603,'user_role','User can call any action in module: \'user_role\''),(76,585,586,'index','User can call action: \'index\' in module: \'user_role\''),(77,587,588,'add','User can call action: \'add\' in module: \'user_role\''),(78,589,590,'view','User can call action: \'view\' in module: \'user_role\''),(79,591,592,'edit','User can call action: \'edit\' in module: \'user_role\''),(80,593,594,'delete','User can call action: \'delete\' in module: \'user_role\''),(81,595,596,'view_permission','User can call action: \'view_permission\' in module: \'user_role\''),(82,597,598,'set_permission_to_role','User can call action: \'set_permission_to_role\' in module: \'user_role\''),(83,599,600,'edit_permission','User can call action: \'edit_permission\' in module: \'user_role\''),(84,601,602,'add_permission','User can call action: \'add_permission\' in module: \'user_role\''),(85,604,607,'upload','User can call any action in module: \'upload\''),(86,605,606,'upload_image','User can call action: \'upload_image\' in module: \'upload\''),(87,133,168,'2','User can call all actions in module: \'template_content\' regarding template: \'Experiences\'.'),(88,134,135,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Experiences\'.'),(89,136,137,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Experiences\'.'),(90,138,149,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Experiences\'.  All template fields are editable.'),(91,139,140,'12','User can edit field: \'Title\'\'.'),(92,150,151,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Experiences\'.'),(93,152,153,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Experiences\'.'),(94,154,155,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Experiences\'.'),(95,156,157,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Experiences\'.'),(96,158,159,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Experiences\'.'),(97,160,161,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(98,162,163,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(99,164,165,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Experiences\'.'),(100,166,167,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Experiences\'.'),(101,141,142,'13','User can edit field: \'Description\'\'.'),(102,143,144,'14','User can edit field: \'Gallery\'\'.'),(103,145,146,'15','User can edit field: \'Persons\'\'.'),(104,147,148,'17','User can edit field: \'Price\'\'.'),(105,169,196,'3','User can call all actions in module: \'template_content\' regarding template: \'test\'.'),(106,170,171,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'test\'.'),(107,172,173,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'test\'.'),(108,174,177,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'test\'.  All template fields are editable.'),(109,175,176,'18','User can edit field: \'tttt\'\'.'),(110,178,179,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'test\'.'),(111,180,181,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'test\'.'),(112,182,183,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'test\'.'),(113,184,185,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'test\'.'),(114,186,187,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'test\'.'),(115,188,189,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'test\'.'),(116,190,191,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'test\'.'),(117,192,193,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'test\'.'),(118,194,195,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'test\'.'),(119,197,224,'4','User can call all actions in module: \'template_content\' regarding template: \'Experiences\'.'),(120,198,199,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Experiences\'.'),(121,200,201,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Experiences\'.'),(122,202,205,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Experiences\'.  All template fields are editable.'),(123,203,204,'19','User can edit field: \'Title\'\'.'),(124,206,207,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Experiences\'.'),(125,208,209,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Experiences\'.'),(126,210,211,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Experiences\'.'),(127,212,213,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Experiences\'.'),(128,214,215,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Experiences\'.'),(129,216,217,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(130,218,219,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(131,220,221,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Experiences\'.'),(132,222,223,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Experiences\'.'),(133,225,260,'9','User can call all actions in module: \'template_content\' regarding template: \'Experiences\'.'),(134,226,227,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Experiences\'.'),(135,228,229,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Experiences\'.'),(136,230,241,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Experiences\'.  All template fields are editable.'),(137,231,232,'22','User can edit field: \'Title\'\'.'),(138,242,243,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Experiences\'.'),(139,244,245,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Experiences\'.'),(140,246,247,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Experiences\'.'),(141,248,249,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Experiences\'.'),(142,250,251,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Experiences\'.'),(143,252,253,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(144,254,255,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Experiences\'.'),(145,256,257,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Experiences\'.'),(146,258,259,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Experiences\'.'),(147,233,234,'23','User can edit field: \'Description\'\'.'),(148,235,236,'24','User can edit field: \'Gallery\'\'.'),(149,237,238,'25','User can edit field: \'Price\'\'.'),(150,239,240,'26','User can edit field: \'Persons\'\'.'),(151,261,296,'10','User can call all actions in module: \'template_content\' regarding template: \'test2\'.'),(152,262,263,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'test2\'.'),(153,264,265,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'test2\'.'),(154,266,277,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'test2\'.  All template fields are editable.'),(155,267,268,'27','User can edit field: \'test2\'\'.'),(156,278,279,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'test2\'.'),(157,280,281,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'test2\'.'),(158,282,283,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'test2\'.'),(159,284,285,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'test2\'.'),(160,286,287,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'test2\'.'),(161,288,289,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'test2\'.'),(162,290,291,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'test2\'.'),(163,292,293,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'test2\'.'),(164,294,295,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'test2\'.'),(165,269,270,'28','User can edit field: \'test22\'\'.'),(166,271,272,'29','User can edit field: \'gg\'\'.'),(167,273,274,'31','User can edit field: \'ff\'\'.'),(168,275,276,'32','User can edit field: \'tgtg\'\'.'),(224,297,340,'14','User can call all actions in module: \'template_content\' regarding template: \'Orders\'.'),(225,298,299,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Orders\'.'),(226,300,301,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Orders\'.'),(227,302,321,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Orders\'.  All template fields are editable.'),(228,303,304,'56','User can edit field: \'Code\'\'.'),(229,305,306,'57','User can edit field: \'First Name\'\'.'),(230,307,308,'58','User can edit field: \'Last Name\'\'.'),(231,309,310,'59','User can edit field: \'Email\'\'.'),(232,311,312,'60','User can edit field: \'Phone\'\'.'),(233,313,314,'61','User can edit field: \'Payment Type\'\'.'),(234,315,316,'62','User can edit field: \'Price\'\'.'),(235,322,323,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Orders\'.'),(236,324,325,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Orders\'.'),(237,326,327,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Orders\'.'),(238,328,329,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Orders\'.'),(239,330,331,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Orders\'.'),(240,332,333,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Orders\'.'),(241,334,335,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Orders\'.'),(242,336,337,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Orders\'.'),(243,338,339,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Orders\'.'),(244,317,318,'63','User can edit field: \'Status\'\'.'),(245,341,378,'15','User can call all actions in module: \'template_content\' regarding template: \'Order Products\'.'),(246,342,343,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Order Products\'.'),(247,344,345,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Order Products\'.'),(248,346,359,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Order Products\'.  All template fields are editable.'),(249,347,348,'64','User can edit field: \'Title\'\'.'),(250,349,350,'65','User can edit field: \'Type\'\'.'),(251,351,352,'66','User can edit field: \'Persons\'\'.'),(253,353,354,'68','User can edit field: \'Unit Price\'\'.'),(254,355,356,'69','User can edit field: \'Total Price\'\'.'),(255,360,361,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Order Products\'.'),(256,362,363,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Order Products\'.'),(257,364,365,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Order Products\'.'),(258,366,367,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Order Products\'.'),(259,368,369,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Order Products\'.'),(260,370,371,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Order Products\'.'),(261,372,373,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Order Products\'.'),(262,374,375,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Order Products\'.'),(263,376,377,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Order Products\'.'),(264,319,320,'70','User can edit field: \'Products\'\'.'),(265,357,358,'72','User can edit field: \'Date\'\'.'),(266,379,414,'16','User can call all actions in module: \'template_content\' regarding template: \'Teams & Events\'.'),(267,380,381,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(268,382,383,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(269,384,395,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Teams & Events\'.  All template fields are editable.'),(270,385,386,'73','User can edit field: \'Title\'\'.'),(271,387,388,'74','User can edit field: \'Description\'\'.'),(272,389,390,'75','User can edit field: \'Image1\'\'.'),(273,391,392,'76','User can edit field: \'Image2\'\'.'),(274,396,397,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(275,398,399,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(276,400,401,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(277,402,403,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(278,404,405,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(279,406,407,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(280,408,409,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(281,410,411,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(282,412,413,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Teams & Events\'.'),(283,393,394,'77','User can edit field: \'Category\'\'.'),(284,415,448,'17','User can call all actions in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(285,416,417,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(286,418,419,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(287,420,429,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.  All template fields are editable.'),(288,421,422,'78','User can edit field: \'Title\'\'.'),(289,423,424,'79','User can edit field: \'Description\'\'.'),(290,425,426,'80','User can edit field: \'Header Image\'\'.'),(291,430,431,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(292,432,433,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(293,434,435,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(294,436,437,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(295,438,439,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(296,440,441,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(297,442,443,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(298,444,445,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(299,446,447,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Teams & Events Page\'.'),(300,427,428,'81','User can edit field: \'Description2\'\'.'),(301,449,506,'18','User can call all actions in module: \'template_content\' regarding template: \'About Us\'.'),(302,450,451,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'About Us\'.'),(303,452,453,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'About Us\'.'),(304,454,487,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'About Us\'.  All template fields are editable.'),(305,455,456,'82','User can edit field: \'Title\'\'.'),(306,457,458,'83','User can edit field: \'Header Image\'\'.'),(307,459,460,'84','User can edit field: \'Title1\'\'.'),(308,461,462,'85','User can edit field: \'Description1\'\'.'),(309,463,464,'86','User can edit field: \'Image1\'\'.'),(310,465,466,'87','User can edit field: \'Image2\'\'.'),(311,467,468,'88','User can edit field: \'Title2\'\'.'),(312,469,470,'89','User can edit field: \'Description2\'\'.'),(313,471,472,'90','User can edit field: \'Title3\'\'.'),(314,473,474,'91','User can edit field: \'Description1\'\'.'),(315,475,476,'92','User can edit field: \'Image3\'\'.'),(316,488,489,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'About Us\'.'),(317,490,491,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'About Us\'.'),(318,492,493,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'About Us\'.'),(319,494,495,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'About Us\'.'),(320,496,497,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'About Us\'.'),(321,498,499,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'About Us\'.'),(322,500,501,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'About Us\'.'),(323,502,503,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'About Us\'.'),(324,504,505,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'About Us\'.'),(325,477,478,'94','User can edit field: \'Title1\'\'.'),(326,479,480,'95','User can edit field: \'Title2\'\'.'),(327,481,482,'96','User can edit field: \'Title3\'\'.'),(328,483,484,'97','User can edit field: \'Description2\'\'.'),(329,485,486,'98','User can edit field: \'Description3\'\'.'),(344,507,540,'20','User can call all actions in module: \'template_content\' regarding template: \'Collab Customers\'.'),(345,508,509,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(346,510,511,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(347,512,521,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Collab Customers\'.  All template fields are editable.'),(348,513,514,'101','User can edit field: \'Title\'\'.'),(349,515,516,'102','User can edit field: \'Image\'\'.'),(350,517,518,'103','User can edit field: \'Url\'\'.'),(351,522,523,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(352,524,525,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(353,526,527,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(354,528,529,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(355,530,531,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(356,532,533,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(357,534,535,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(358,536,537,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(359,538,539,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Collab Customers\'.'),(360,519,520,'104','User can edit field: \'Category\'\'.'),(361,107,108,'106','User can edit field: \'Description\'\'.'),(362,109,110,'107','User can edit field: \'Copyright\'\'.'),(364,111,112,'111','User can edit field: \'Map\'\'.'),(426,541,570,'23','User can call all actions in module: \'template_content\' regarding template: \'Contents\'.'),(427,542,543,'index','User can call action: \'index\' in module: \'template_content\' regarding template: \'Contents\'.'),(428,544,545,'add_row','User can call action: \'add_row\' in module: \'template_content\' regarding template: \'Contents\'.'),(429,546,551,'edit_row','User can call action: \'edit_row\' in module: \'template_content\' regarding template: \'Contents\'.  All template fields are editable.'),(430,547,548,'148','User can edit field: \'Title\'\'.'),(431,549,550,'149','User can edit field: \'Text\'\'.'),(432,552,553,'view_table','User can call action: \'view_table\' in module: \'template_content\' regarding template: \'Contents\'.'),(433,554,555,'delete','User can call action: \'delete\' in module: \'template_content\' regarding template: \'Contents\'.'),(434,556,557,'delete_multiple','User can call action: \'delete_multiple\' in module: \'template_content\' regarding template: \'Contents\'.'),(435,558,559,'getDataTableRecords','User can call action: \'getDataTableRecords\' in module: \'template_content\' regarding template: \'Contents\'.'),(436,560,561,'toggle_active','User can call action: \'toggle_active\' in module: \'template_content\' regarding template: \'Contents\'.'),(437,562,563,'make_caption','User can call action: \'make_caption\' in module: \'template_content\' regarding template: \'Contents\'.'),(438,564,565,'check_caption','User can call action: \'check_caption\' in module: \'template_content\' regarding template: \'Contents\'.'),(439,566,567,'searchForeignTable','User can call action: \'searchForeignTable\' in module: \'template_content\' regarding template: \'Contents\'.'),(440,568,569,'share','User can call action: \'share\' in module: \'template_content\' regarding template: \'Contents\'.');

--
-- Table structure for table `phprbac_rolepermissions`
--

CREATE TABLE `phprbac_rolepermissions` (
  `RoleID` int NOT NULL,
  `PermissionID` int NOT NULL,
  `AssignmentDate` int NOT NULL,
  PRIMARY KEY (`RoleID`,`PermissionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `phprbac_rolepermissions`
--

INSERT INTO `phprbac_rolepermissions` VALUES (1,1,1676038242),(2,2,1676038243),(3,8,1676038243),(3,16,1676038243),(3,44,1676038243),(3,69,1676038243),(3,75,1676038243),(3,85,1676038243),(4,69,1676038243),(4,75,1676038243),(5,44,1676038243),(6,45,1676038243),(7,46,1676038243),(7,60,1676038243),(7,63,1676038243),(8,16,1676038243),(9,8,1676038243),(13,105,1678746660),(14,110,1678746660),(14,113,1678746660),(19,151,1678754039),(20,156,1678754039),(20,159,1678754039),(27,224,1682469697),(28,235,1682469697),(28,238,1682469697),(29,245,1682470048),(30,255,1682470048),(30,258,1682470048),(31,266,1682621588),(32,274,1682621588),(32,277,1682621588),(33,284,1682623561),(34,291,1682623561),(34,294,1682623561),(35,301,1682665802),(36,316,1682665802),(36,319,1682665802),(38,335,1683270424),(38,338,1683270424),(39,344,1683271132),(40,351,1683271132),(40,354,1683271132),(45,426,1686744580),(46,432,1686744580),(46,435,1686744580);

--
-- Table structure for table `phprbac_roles`
--

CREATE TABLE `phprbac_roles` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `Lft` int NOT NULL,
  `Rght` int NOT NULL,
  `Title` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Title` (`Title`),
  KEY `Lft` (`Lft`),
  KEY `Rght` (`Rght`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `phprbac_roles`
--

INSERT INTO `phprbac_roles` VALUES (1,0,59,'root','root'),(2,1,58,'Super Administrator','Super Administrator has complete access to CMS.'),(3,2,57,'Administrator','Administrator role for clients.'),(4,3,4,'User Manager','User Manager has complete access to user-related CMS functionality.'),(5,5,50,'Template Content Manager','Template Content Manager has complete access to template content pages.'),(6,6,9,'Settings Manager','Manages \'Settings\' template content'),(7,7,8,'Settings Viewer','Views \'Settings\' template content'),(8,51,52,'Menu Manager','Manages everything regarding front-end Menus.'),(9,53,56,'Board Content Manager','Manages Board Contents'),(10,54,55,'Board Content Viewer','Views Board Contents'),(13,10,13,'test Manager','Manages \'test\' template content'),(14,11,12,'test Viewer','Views \'test\' template content'),(19,14,17,'test2 Manager','Manages \'test2\' template content'),(20,15,16,'test2 Viewer','Views \'test2\' template content'),(27,18,21,'Orders Manager','Manages \'Orders\' template content'),(28,19,20,'Orders Viewer','Views \'Orders\' template content'),(29,22,25,'Order Products Manager','Manages \'Order Products\' template content'),(30,23,24,'Order Products Viewer','Views \'Order Products\' template content'),(31,26,29,'Teams & Events Manager','Manages \'Teams & Events\' template content'),(32,27,28,'Teams & Events Viewer','Views \'Teams & Events\' template content'),(33,30,33,'Teams & Events Page Manager','Manages \'Teams & Events Page\' template content'),(34,31,32,'Teams & Events Page Viewer','Views \'Teams & Events Page\' template content'),(35,34,37,'About Us Manager','Manages \'About Us\' template content'),(36,35,36,'About Us Viewer','Views \'About Us\' template content'),(37,38,41,'Collaborations Categories Manager','Manages \'Collaborations Categories\' template content'),(38,39,40,'Collaborations Categories Viewer','Views \'Collaborations Categories\' template content'),(39,42,45,'Collab Customers Manager','Manages \'Collab Customers\' template content'),(40,43,44,'Collab Customers Viewer','Views \'Collab Customers\' template content'),(45,46,49,'Contents Manager','Manages \'Contents\' template content'),(46,47,48,'Contents Viewer','Views \'Contents\' template content');

--
-- Table structure for table `phprbac_userroles`
--

CREATE TABLE `phprbac_userroles` (
  `UserID` int NOT NULL,
  `RoleID` int NOT NULL,
  `AssignmentDate` int NOT NULL,
  PRIMARY KEY (`UserID`,`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Dumping data for table `phprbac_userroles`
--

INSERT INTO `phprbac_userroles` VALUES (1,1,1676038243);

--
-- Table structure for table `submenus`
--

CREATE TABLE `submenus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(45) DEFAULT NULL,
  `site_id` int DEFAULT NULL,
  `options` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `submenus`
--

INSERT INTO `submenus` VALUES (1,'Main menu',1,NULL),(2,'footer',1,'{\"templates\":[\"23\"]}');

--
-- Table structure for table `t_aboutus`
--

CREATE TABLE `t_aboutus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `meta_title_el` varchar(255) NOT NULL DEFAULT '',
  `meta_description_el` text NOT NULL,
  `meta_keywords_el` varchar(255) NOT NULL DEFAULT '',
  `meta_title_en` varchar(255) NOT NULL DEFAULT '',
  `meta_description_en` text NOT NULL,
  `meta_keywords_en` varchar(255) NOT NULL DEFAULT '',
  `title_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `himage` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title1_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title1_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description1_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description1_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `image1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `image2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title2_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title2_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description2_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description2_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `title3_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title3_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description31_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description31_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `image3` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title31_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title31_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title32_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title32_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title33_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title33_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description32_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description32_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description33_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description33_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_aboutus`
--

INSERT INTO `t_aboutus` VALUES (1,'about-us',1,'2023-04-28 07:17:43','2024-08-23 10:37:18','About Us','','','About Us','','','About Us','About Us','digital_photo.png','About Us','About Us','','My name is Konstantina Koutsikou. I live in Athens since 2010.\r\n<br/> I was born in Thessaloniki, but  I always loved Athens so I moved here and I started my life from zero.<br/>\r\nMy vision for someone who is coming for the first time in Athens is to see  the lifestyle here, to smell, to taste ,to feel, to dance ,to drink as a real Greek.<br/>\r\nTo feel the  energy that only this town can give you.<br/>\r\nWellcome you on board!','digital_photo.png','','','What we provide',' Πατάς εδω : 		https://i.streams.ovh:2199/start/musiccoderadio/','Fingertrip is an innovative company with great experience  in organising events, teambuilding and entertainment events and tourist fun packages. Our executive team is always at your disposal, for your event, public relationships ,fun and conferences the way you dreamed about it .Always  with a great smile ,positive energy and  innovative ideas we create cooperations which are human based.\r\nAlways working with deadline and a plan, we make your idea real,with the best results!\r\nWe are here for you ! ','Our Services','Our Services','','Our daily packages offer to you the ability to have exclusive services and solutions considering your age ,your taste and your demands!\r\nYour visit in Athens will be one of the memorable and Unforgettable experiences you\'ve ever lived till now!','digital_photo.png',' Tour Packages',' Tour Packages','Experiences','Experiences','Events','Events','','Except our daily choices you have the unique opportunity to choose something specific to do with us while you\'re staying up in Athens!\r\nWe are here for you !','','Share with us what  you are  thinking!!\r\nOur  executive team will make a specific and organized plan about how your dreams and plans will become true, either it considers a corporate environment or a party,an anniversary, a surprise,a  birthday party or even your wedding dreaming day!!!!\r\nWe make it happen!!!');

--
-- Table structure for table `t_colabs`
--

CREATE TABLE `t_colabs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `title_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `image` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `category` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_colabs`
--

INSERT INTO `t_colabs` VALUES (1,'loco-sabor',1,'2023-05-05 07:29:54','2023-05-05 12:13:38','Loco Sabor ','Loco Sabor ','collabs/food/6.jpg','',2),(2,'anefani',1,'2023-05-05 07:30:30','2023-05-05 07:30:31','Aνεφανη','Anefani','collabs/food/2.jpg','',2),(3,'plant-based-food',1,'2023-05-05 07:30:52','2023-05-05 07:30:52','Plant Based Food','Plant Based Food','collabs/food/8.jpg','',2),(4,'hyper-astrobar',1,'2023-05-05 07:31:12','2023-05-05 07:31:12','Hyper Astrobar','Hyper Astrobar','collabs/food/1.jpg','',2),(5,'tsi-tsi',1,'2023-05-05 07:31:35','2023-05-05 07:31:35','Τσι Τσι','Tsi Tsi ','collabs/food/3.jpg','',2),(6,'ciel',1,'2023-05-05 07:31:52','2023-05-05 07:31:52','Ciel','Ciel','collabs/food/4.jpg','',2),(7,'agioneri',1,'2023-05-05 07:32:12','2023-05-05 07:32:12','Αγιονέρι','Agioneri','collabs/food/5.jpg','',2),(8,'momo-asian-bar',1,'2023-05-05 07:32:35','2023-05-05 07:32:35','Momo Asian Bar','Momo Asian Bar','collabs/food/7.jpg','',2),(9,'coiffure-experience',1,'2023-05-05 07:33:05','2023-05-05 07:33:05','Coiffure Experience','Coiffure Experience','collabs/nails/1.png','',3),(10,'kl-hair-style',1,'2023-05-05 07:33:31','2023-05-05 12:17:51','KL Hair Style','KL Hair Style','collabs/nails/2.jpg','',3),(11,'antonis-tsamakis-coiffure',1,'2023-05-05 07:33:59','2023-05-05 12:25:45','Antonis Tsamakis Coiffure','Antonis Tsamakis Coiffure','collabs/nails/3.jpg','',3),(12,'vera-hairstyle',1,'2023-05-05 07:34:27','2023-05-05 22:32:21','Vera Hairstyle','Vera Hairstyle','collabs/nails/5.jpg','',3),(13,'doxopoulos-beauty-salons',1,'2023-05-05 07:34:58','2023-05-05 22:35:38','Doxopoulos Beauty Salons','Doxopoulos Beauty Salons','collabs/nails/6.jpg','',3),(14,'mts-by-mimi',1,'2023-05-05 07:35:24','2023-05-05 22:37:46','MTS by Mimi','MTS by Mimi','collabs/nails/7.jpg','',3),(15,'jackie-hair-nail-salon',1,'2023-05-05 07:35:54','2023-05-05 22:39:42','Jackie Hair & Nail Salon','Jackie Hair & Nail Salon','collabs/nails/4.jpg','',3),(16,'pole-dancefloor',1,'2023-05-05 07:36:22','2023-05-05 22:42:50','Pole Dancefloor','Pole Dancefloor','collabs/activities/9.jpg','',1),(17,'sherlocked-homes-escape-rooms',1,'2023-05-05 07:36:59','2023-05-05 22:41:11','Sherlocked Homes Escape Rooms','Sherlocked Homes Escape Rooms','collabs/activities/1.png','',1),(18,'viva-lets-fly',1,'2023-05-05 07:37:21','2023-05-05 07:37:21','Viva Lets fly','Viva Lets fly','collabs/activities/10.png','',1),(19,'sailways-yacht-charter',1,'2023-05-05 07:37:47','2023-05-05 22:44:33','Sailways Yacht Charter','Sailways Yacht Charter','collabs/activities/11.png','',1),(20,'improvibe',1,'2023-05-05 07:38:05','2023-05-05 22:45:54','Improvibe','Improvibe','collabs/activities/12.jpg','',1),(21,'topos-allou-theater',1,'2023-05-05 07:38:39','2023-05-05 22:47:33','Topos Allou Theater','Topos Allou Theater','collabs/activities/13.png','',1),(22,'kentro-technis',1,'2023-05-05 07:41:45','2023-05-05 07:41:45','Κέντρο Τέχνης','Kentro Texnis','collabs/activities/2.jpg','',1),(23,'mathimata-mageirikis',1,'2023-05-05 07:42:30','2023-05-05 22:50:05','Μαθήματα Μαγειρικης','Cooking lessons','collabs/activities/3.jpg','',1),(24,'nhphides-spa',1,'2023-05-05 07:43:01','2023-05-05 07:43:01','Nhphides Spa','Nhphides Spa','collabs/activities/4.png','',1),(25,'the-greek-kitchen',1,'2023-05-05 07:43:24','2023-05-05 07:43:24','The Greek Kitchen','The Greek Kitchen','collabs/activities/5.png','',1),(26,'athens-paintball-village',1,'2023-05-05 07:43:49','2023-05-05 22:51:28','Athens Paintball Village','Athens Paintball Village','collabs/activities/6.jpg','',1),(27,'cabane',1,'2023-05-05 07:44:04','2023-05-05 07:44:04','CABANE','CABANE','collabs/activities/7.jpg','',1),(28,'wine-point-bar',1,'2023-05-05 07:44:26','2023-05-05 07:44:26','Wine Point Bar','Wine Point Bar','collabs/activities/8.jpg','',1),(29,'kalimeres-bistro',1,'2023-06-14 18:44:45','2023-06-14 18:44:45','Kalimeres Bistro','Kalimeres Bistro','collabs/kalimeres.jpg','',2),(30,'salt-cave',1,'2023-06-14 18:46:55','2023-08-02 07:16:08','Salt Cave','Salt Cave','collabs/logo_salt_cave2.jpg','',3),(31,'tre',1,'2023-08-02 07:13:34','2023-08-02 07:13:34','Tre','TRe','collabs/tre.jpg','',2),(32,'medi-foot',1,'2023-08-02 07:19:49','2023-08-02 07:19:49','MEDI FOOT','MEDI FOOT','collabs/medi.png','',3),(33,'eeate',1,'2023-08-02 07:24:29','2023-08-02 07:24:29','Eeate','Eeate','collabs/eaete.png','',0),(34,'',1,'2024-08-25 23:47:51','2024-08-25 23:47:55','','','digital_photo.png','',0);

--
-- Table structure for table `t_content`
--

CREATE TABLE `t_content` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `title_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `text_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `text_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_content`
--

INSERT INTO `t_content` VALUES (1,'oroi-chrisis',1,'2023-06-14 12:57:43','2023-06-14 19:04:10','Όροι χρήσης ','Terms Of Use','<p><strong>Όροι Χρήσης <a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong></p>\r\n<p> <br />Το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a> είναι επίσημη ιστοσελίδα ελληνικής Ατομικής επιχείρησης που εδρεύει στην Ελλάδα, στην πόλη των Αθηνών (ΑΦΜ: 079464873).</p>\r\n<p>Ο Συνδρομητής/Χρήστης/Επισκέπτης οφείλει να διαβάσει προσεκτικά τους όρους της Σύμβασης Χρήσης που ακολουθεί, πριν από την είσοδο-επίσκεψή του στο δικτυακό τόπο του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a> και την όποια χρήση του περιεχομένου του και των παρεχόμενων υπηρεσιών. </p>\r\n<p>Η είσοδος του Συνδρομητή/Χρήστη/Επισκέπτη στον δικτυακό τόπο του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a> συνεπάγεται την ανεπιφύλακτη αποδοχή του και τη δέσμευσή του, έναντι του κάτωθι φορέα του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>, με τους όρους της Σύμβασης χρήσης που ακολουθεί.</p>\r\n<p> <br />Εάν ο συνδρομητής/χρήστης/επισκέπτης δεν συμφωνεί με τους όρους της Σύμβασης χρήσης που ακολουθεί, τότε οφείλει να μην κάνει χρήση των υπηρεσιών και του περιεχομένου του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a></p>\r\n<p><strong> Όροι</strong></p>\r\n<p>Τα FingerTrip διατηρούν το δικαίωμα να τροποποιούν μονομερώς ή να ανανεώνει τους παρόντες όρους και τις προϋποθέσεις των συναλλαγών, που γίνονται μέσω του ηλεκτρονικού της καταστήματος, σύμφωνα με τις ανάγκες της και τα συναλλακτικά ήθη. Τo FingerTrip αναλαμβάνουν την υποχρέωση να ενημερώνει τους χρήστες για τυχόν τροποποιήσεις καθώς και για οποιαδήποτε αλλαγή, μέσω από την ιστοσελίδα του παρόντος ηλεκτρονικού καταστήματος. Διευκρινίζεται ότι η αλλαγή όρων δεν καταλαμβάνει παραγγελίες τις οποίες έχετε ήδη κάνει.</p>\r\n<p><strong>Παρεχόμενες πληροφορίες &amp; Προϊόντα</strong></p>\r\n<p>Ο συνδρομητής-χρήστης των ιστοσελίδων και των υπηρεσιών του δικτυακού τόπου <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  δίνει τη συγκατάθεσή του και αποδέχεται τους κατωτέρω όρους χρήσης, που θεωρούνται όλοι ως ουσιώδεις και ισχύουν για το σύνολο των ιστοσελίδων αυτού, ήτοι ενδεικτικά αλλά όχι περιοριστικά για το εκάστοτε περιεχόμενό τους, συμπεριλαμβανομένων των γραφικών, των εικόνων, των φωτογραφιών και των αρχείων που περιλαμβάνονται σε αυτές.</p>\r\n<p> </p>\r\n<p><strong>Περιορισμός ευθύνης</strong></p>\r\n<p>Υπό οποιεσδήποτε συνθήκες, συμπεριλαμβανομένης και της περίπτωσης αμέλειας, το Δίκτυο δεν ευθύνεται για οποιασδήποτε μορφής ζημία υποστεί ο Συνδρομητής/ Χρήστης/Επισκέπτης των σελίδων, υπηρεσιών, επιλογών και περιεχομένων του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  στις οποίες προβαίνει με δική του πρωτοβουλία και με τη γνώση των όρων του παρόντος. Τα περιεχόμενα του <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  παρέχονται \"όπως ακριβώς είναι\" χωρίς καμία εγγύηση εκπεφρασμένη ή και συναγόμενη με οποιοδήποτε τρόπο. Το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  αρνείται όλες τις εγγυήσεις εκπεφρασμένες ή και συναγόμενες, συμπεριλαμβανομένων, όχι όμως περιοριζόμενων σε αυτό, αυτών, οι οποίες συνεπάγονται την εμπορευσιμότητα και την καταλληλότητα για ένα συγκεκριμένο σκοπό. Το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  δηλώνει ότι θα καταβάλλει κάθε δυνατή προσπάθεια, ωστόσο δεν εγγυάται ότι οι σελίδες, οι υπηρεσίες, οι επιλογές και τα περιεχόμενα θα παρέχονται χωρίς διακοπή, χωρίς σφάλματα και ότι τα λάθη θα διορθώνονται. Επίσης το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  δεν εγγυάται ότι το ίδιο ή οποιοδήποτε άλλο συγγενικό site ή οι εξυπηρετητές \"servers\" μέσω των οποίων αυτά τίθενται στη διάθεσή σας, σας παρέχονται χωρίς \"ιούς\" ή άλλα επιζήμια συστατικά. Το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a>  δεν εγγυάται σε καμία περίπτωση την ορθότητα, την πληρότητα ή και διαθεσιμότητα των περιεχομένων, σελίδων, υπηρεσιών, επιλογών ή τα αποτελέσματά τους. Το κόστος των ενδεχόμενων διορθώσεων ή εξυπηρετήσεων, το αναλαμβάνει ο Συνδρομητής /Χρήστης/Επισκέπτης και σε καμία περίπτωση το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a> .  </p>\r\n<p> </p>\r\n<p><strong>Ηλεκτρονικό Κατάστημα (e-shop)</strong></p>\r\n<p> <br />Το <a href=\"https://www.elta.gr/\"><strong>fingertrip.com.gr</strong></a> . παρέχει στους συνδρομητές/επισκέπτες / χρήστες του υπηρεσίες ηλεκτρονικού εμπορίου σύμφωνα με τους ειδικότερους όρους που αυτό τάσσει και μεριμνώντας για την προστασία των προσωπικών στοιχείων που υποβάλλουν για τη χρήση των υπηρεσιών αυτών. </p>\r\n<p>Τα FingerTrip ουδεμία εγγύηση μπορούν να παράσχουν για τη διαθεσιμότητα των προϊόντων, αλλά εγγυούνται την έγκαιρη ενημέρωση των τελικών καταναλωτών περί της μη διαθεσιμότητάς τους.</p>\r\n<p>Τα FingerTrip  ευθύνονται μόνο για δόλο και βαριά αμέλεια, σε περίπτωση καθυστέρησης στην παράδοση παραγγελθέντων προϊόντων και για πληροφορίες που τα ίδια δίνουν ή υπηρεσίες που παρέχουν μέσω του δικτυακού τόπου τους.</p>\r\n<p>Το ηλεκτρονικό κατάστημα FingerTrip δεν φέρει ευθύνη για τυχόν τεχνικά προβλήματα που τυχόν παρουσιασθούν στους χρήστες όταν επιχειρούν την πρόσβαση στον δικτυακό τόπο και κατά την διάρκεια αυτής και έχουν σχέση με τη λειτουργία ή συμβατότητα της δικής τους υποδομής με τη χρήση του δικτυακού τόπου. Επίσης τα FingerTrip ουδεμία ευθύνη έχουν για πράξεις ή παραλείψεις τρίτων και ιδιαίτερα μη επιτρεπόμενες παρεμβάσεις τρίτων σε προϊόντα ή/και υπηρεσίες ή/και πληροφορίες που διατίθενται μέσω αυτών.</p>\r\n<p> </p>\r\n<p> </p>\r\n<p> </p>','<p><strong>Terms Of Use</strong></p>\r\n<p><strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> is the e-shop for the online display and distribution over the Internet of the products of a Greek company, having its headquarters in Greece, in the city of Athens (TIN:079464873).</p>\r\n<p>The Subscriber/User/Visitor is responsible to carefully read the Terms of Use below, prior to his/her accessing-visiting <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> site and before any use of the content and services provided therein.<br /><br />Subscriber\'s/User\'s/Visitor\'s access to <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> site implies unreserved acceptance and commitment against the following operator of <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> , as per the Terms of Use cited below.<br /><br />In case the subscriber/user/visitor does not agree to the terms of use described below, then he/she must not proceed to the usage of the services and contents of <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> .<br /><br />Terms<br /><br />FingerTrip reserves the right to unilaterally amend or renew the present terms and conditions of the transactions performed through its e-shop, in accordance with its needs and transactional ethics. FingerTrip undertakes the obligation to notify users on any amendments as well as any change, via this e-shop webpage. It is clarified that any change to the terms shall not affect orders that have already been placed.<br /><br />Information &amp; Products provided<br /><br />The subscriber-user of the web pages and services of <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> website agrees to and accepts the following terms of use, which are considered as material and which apply to its web pages, i.e. without limitation to their Content at times, including graphics, images, pictures and files contained in such web pages:<br /><br /><br />Disclaimer of Liability<br /><br />Under no circumstances, including the case of negligence, shall the Network be liable for any damage of any form whatsoever incurred by the Subscriber/User/Visitor to the pages, services, options and content of <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> , which he/she uses at his/her own initiative, being aware of the terms hereunder. The content of <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> is provided \"exactly as is\" without any warranty of any kind, either expressed or implied in any way whatsoever. <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> disclaims all warranties, expressed or implied, including, but not limited to, the implied warranties of merchantability and condition for specific use. <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong>  declares that it will make all efforts necessary, however it can not warantee that the pages, services, options and content shall be provided without interruptions and errors and that errors will be corrected. Furthermore, <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> cannot warrantee that the same or any other affiliated site or servers through which these are availed, are free of \"viruses\" or other damaging components. <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> does not provide any warranty regarding the accuracy, completeness or availability of the content, pages, services, options or their results. for any corrections or assistance shall be borne in all cases by the Subscriber/User/Visitor and not by <strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> <br /><br /><br /><br />e-Shop<br /><strong><a href=\"https://www.elta.gr/\">fingertrip.com.gr</a></strong> . provides to its subscribers/users/visitors e-commerce services, in accordance with the specific terms applicable and attending the protection of personal data submitted in order to use such services.<br /><br />FingerTrip is not able to provide any warranty regarding the availability of products, but it warrants that the end users shall be promptly informed of their non-availability.<br /><br />FingerTrip shall only be liable for intent and gross negligence in case of a delay in the delivery of products ordered and for information or services provided through its website.<br /><br />FingerTrip  e-Shop shall not be responsible for any technical problems that may occur when users attempt to access the website and during such use, and are related to the operation or compatibility of their infrastructure with the use of website. Moreover, FingerTrip  shall not be liable for acts or omissions of third parties, particularly unauthorized third party interventions to products and/or services and/or information provided by it.</p>'),(2,'politiki-epistrofon-akuroseon',0,'2023-06-14 13:04:06','2023-06-14 15:12:47','Πολιτική  επιστροφών / ακυρώσεων','Order Cancellation','<p>Ακύρωση της παραγγελίας δύναται να γίνει στις κάτωθι περιπτώσεις: Πριν ολοκληρωθεί η παραγγελία, κατά τη διάρκεια της ηλεκτρονικής διαδικασίας της παραγγελίας μπορείτε να κάνετε πίσω \"back\" και να αφαιρέσετε τις ποσότητες των προϊόντων από το καλάθι σας πατώντας στο κουμπί \"διαγραφή\". Εάν έχει ολοκληρωθεί η ηλεκτρονική παραγγελία αλλά δεν έχει αποσταλεί ακόμα το προϊόν, μπορείτε να επικοινωνήσετε στο email <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> και ένας συνεργάτης μας θα αναλάβει την ακύρωση της παραγγελίας σας. Μετά την παραλαβή του προϊόντος,  επικοινωνήστε μέσω της φόρμας ηλεκτρονικού ταχυδρομείου του δικτυακού τόπου ή στο email <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a>, εξηγώντας το λόγο που επιθυμείτε την ακύρωση της παραγγελίας. Ένας συνεργάτης μας θα σας εξυπηρετήσει άμεσα και θα σας ενημερώσει για όλες τις επιλογές σας. Σε περίπτωση που παραγγελία σας έχει ήδη τιμολογηθεί και επιθυμείτε την ακύρωση της, τότε επικοινωνήστε στο email <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> και δώστε τα στοιχεία της παραγγελίας σας. Ωστόσο, η κατάσταση (status) της παραγγελίας δεν θα αλλάξει στη σελίδα του λογαριασμού σας.</p>','<p>Cancellation of orders may be made in the following cases: Before completion of your order, during electronic processing of your order you can click \"back\" and remove the quantities of products from your basket by clicking \"delete\". If online order is completed but the product has not been dispatched yet, you can contact <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> and one of our partners will undertake the cancellation of your order. After reception of the product, contact <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> or via the e-mail form on the website, explaining why you wish to cancel the order. One of our partners will assist you immediately and will advise you on all your options. If your order has been invoiced and wish to cancel it, then contact our Customer Service Department at <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> and provide the details of your order. However, the status of your order will not be updated on your account page</p>'),(3,'politiki-aporritou',1,'2023-06-14 13:07:19','2023-06-14 15:12:06','Πολιτική Απορρήτου','Confidentiality','<p>Η τήρηση του απορρήτου θεωρείται αυτονόητη.</p>\r\n<p>Οι ίδιες βασικές αρχές που διέπουν τις κλασσικές συναλλαγές ισχύουν και στην περίπτωση του e-commerce <br />(ηλεκτρονικού εμπορίου). Όλες οι πληροφορίες που διαβιβάζονται από τον χρήστη /μέλος στα FingerTrip είναι εμπιστευτικές και τo FingerTrip  έχουν λάβει όλα τα απαραίτητα μέτρα ώστε να γίνεται χρήση τους μόνο στο μέτρο που αυτό κρίνεται αναγκαίο στο πλαίσιο των παρεχομένων υπηρεσιών. Μερικά από τα μέτρα που έχουν ληφθεί είναι τα ακόλουθα:<br />Μόνο εξουσιοδοτημένοι υπάλληλοι έχουν πρόσβαση στις πληροφορίες των συναλλαγών σας και μόνο όποτε αυτό είναι αναγκαίο, π.χ. για τη διεκπεραίωση των αιτήσεών σας.<br />Τα FingerTrip δεν αποκαλύπτουν τα στοιχεία των πελατών και των συναλλαγών τους, εκτός αν έχουν έγγραφη εξουσιοδότηση από εσάς ή αυτό επιβάλλεται από δικαστική απόφαση ή απόφαση άλλης δημόσιας αρχής. Στην περίπτωση που τα FingerTrip  χρησιμοποιούν τρίτους για την υποστήριξη των συστημάτων τους, φροντίζουν για την εξασφάλιση του απορρήτου.<br />Μπορείτε να ζητήσετε οποιαδήποτε στοιχεία τηρούνται για εσάς καθώς και την διόρθωσή τους σε περίπτωση που μπορείτε να τεκμηριώσετε την ύπαρξη λάθους.<br />Για τη δική σας ασφάλεια, θα πρέπει και εσείς να χειρίζεστε όλες τις πληροφορίες που παρέχονται μέσω της υπηρεσίας ως εμπιστευτικές και απόρρητες <br />και να μην προβαίνετε σε οποιαδήποτε αποκάλυψή τους σε τρίτα πρόσωπα.</p>','<p>Confidentiality is considered self-evident. The same basic principles applicable to conventional transactions, also apply in the case of e-commerce (electronic commerce). All information transmitted from the user / member to FingerTrip  is confidential and FingerTrip  has taken all necessary steps to use them only to the extent necessary and in the context of the services provided. Some of the measures taken are the following:<br /><br />Only authorized employees have access to information of your transaction and only when necessary, eg for processing your requests.<br /><br />FingerTrip  does not disclose customer information and transactions, unless with written authorization on your part, or when required by a court decision or a decision of any other public authority.<br /><br />In case FingerTrip  employs third parties in order to support its systems, it shall ensure confidentiality.<br /><br />You may request any information held about you and request their amendment, as long as you can document the existence of an error.<br /><br />For your own safety, you should treat all information provided through the service as private and confidential and not to make any disclosures to third parties.</p>'),(4,'tropoi-pliromis',0,'2023-06-14 13:08:07','2023-06-14 18:58:29','Τρόποι Πληρωμής ','Payment Methods','<p><strong>Πληρωμή μέσω Πιστωτικής Κάρτας</strong>:</p>\r\n<p>Το ηλεκτρονικό κατάστημα του FingerPrint δέχεται όλες τις πιστωτικές κάρτες, Visa, Mastercard . Οι συναλλαγές σας με πιστωτική κάρτα θα γίνονται πάνω στο e-POS της τράπεζας (redirection) και έχουν το επίπεδο ασφάλειας της υπηρεσίας της τράπεζας. Επιπλέον, κανένα στοιχείο της πιστωτικής σας κάρτας δεν αποθηκεύεται στους servers των FingerTrip .</p>\r\n<p><strong>Πληρωμή με τραπεζική κατάθεση</strong>:</p>\r\n<p>ΙΒΑΝ GR7401101840000018400419738 ΕΘΝΙΚΗ ΤΡΑΠΕΖΑ</p>\r\n<p><strong>Πληρωμή μέσω Paypal (προϋποθέτει την ύπαρξη λογαριασμού Paypal)</strong>:</p>\r\n<p>Εφόσον επιλέξετε ως μέθοδο πληρωμής την καταβολή του αντίτιμου της παραγγελίας μέσω Paypal θα μεταφερθείτε στη σελίδα της PayPal (<a href=\"http://www.paypal.com/\"><strong>www.paypal.com</strong></a>) όπου και θα πρέπει να καταχωρήσετε τα στοιχεία του PayPal λογαριασμού σας και στη συνέχεια θα ολοκληρώσετε την παραγγελία σας.</p>','<p><strong>Credit Card payment:</strong><br /><br />FingerPrint\'s  online store accepts all major credit cards, Visa, Mastercard. Your credit card transactions shall be performed on National Bank  e-POS (redirection) and shall be subject to the bank\'s service security level. Furthermore, no details of your credit card are stored on FingerPrint servers.<br /><br /><strong>Payment via Bank Transaction</strong></p>\r\n<p>ΙΒΑΝ GR7401101840000018400419738 <br /><br /><strong>Difference between shop value and online store value</strong><br /><br />The pricing policy for FingerPrint products is the same in all our distribution channels: stores, catalogs, e-shop. However, in our online store, and for selected products we created \"offers\", where the value at the online store differs from the one at the other channels and is only valid for purchases through this online store and dispatch to your premises. In any case, although we make every effort to accurately register the data and prices posted on our online shop, it is not possible to exclude the possibility of occurrence of typographical or technical errors in prices and product features. For this reason we recommend that also in cases of \"offers\" before each payment and checkout of your order, to contact with the Customer Service Department at <a class=\"footer-link\" href=\"mailto:softlab@mail.com\">fingertriptravel@gmail.com</a> or via the e-mail form on the website in order to confirm the price recorded.</p>'),(5,'asfaleia-sunallagon',1,'2023-06-14 13:09:18','2024-08-23 10:39:06','Ασφάλεια Συναλλαγών','Security','<p>Το FingerTrip αναγνωρίζουν τη σημασία του θέματος της ασφαλείας των προσωπικών σας δεδομένων καθώς και των ηλεκτρονικών σας συναλλαγών και λαμβάνει όλα τα απαραίτητα μέτρα, με τις πιο σύγχρονες και προηγμένες μεθόδους, ώστε να εξασφαλίζεται η μέγιστη δυνατή ασφάλεια σας. Όλες οι πληροφορίες, οι οποίες σχετίζονται με τα προσωπικά σας στοιχεία και τις συναλλαγές σας, είναι ασφαλείς και απόρρητες. Η ασφάλεια του Ηλεκτρονικού καταστήματος των FingerTrip επιτυγχάνεται με τις ακόλουθες μεθόδους:</p>\r\n<p><strong>Ελεγχόμενη Πρόσβαση (firewall)</strong></p>\r\n<p>Η πρόσβαση στα συστήματα των FingerTrip (servers) ελέγχεται από firewall, το οποίο επιτρέπει τη χρήση συγκεκριμένων υπηρεσιών από τους πελάτες/ χρήστες απαγορεύοντας, παράλληλα, την πρόσβαση σε συστήματα και βάσεις δεδομένων με απόρρητα στοιχεία και πληροφορίες της εταιρείας.</p>','<p>FingerTrip  acknowledges the importance of the protection your personal data and your online transactions and employs all necessary measures using the most modern and state of the art methods in order to ensure maximum security. All information related to your personal information and your transactions are secure and confidential. The security of FingerTrip \'s online shop is achieved through the following methods:<br /><br />Controlled Access (firewall)<br /><br />Access to FingerTrip systems (servers) is controlled by a firewall, which allows the use of specific services by the customers / users, prohibiting at the same time, access to systems and databases containing sensitive company data and information.</p>'),(6,'stoicheia-tis-epicheirisis',0,'2023-06-14 13:10:37','2023-06-14 18:56:52','Στοιχεία της Επιχείρησης','Company ','<p>Ατομική επιχείρηση</p>\r\n<div dir=\"auto\">Αφμ 079464873</div>\r\n<div dir=\"auto\">Αγοναριδου 5 νέος Κόσμος τκ 11744</div>\r\n<div dir=\"auto\">Αθήνα </div>\r\n<div dir=\"auto\">Mail <a href=\"mailto:fingertriptravel@gmail.com\" target=\"_blank\" rel=\"noopener\">fingertriptravel@gmail.com</a></div>\r\n<div dir=\"auto\">Tηλ 6945562327</div>','<p>Ατομική επιχείρηση</p>\r\n<div dir=\"auto\">VAT Number 079464873</div>\r\n<div dir=\"auto\">Athens ,Agonaridou 5, 11744,Greece</div>\r\n<div dir=\"auto\">Mail <a href=\"mailto:fingertriptravel@gmail.com\" target=\"_blank\" rel=\"noopener\">fingertriptravel@gmail.com</a></div>\r\n<div dir=\"auto\">Phone +36945562327</div>');

--
-- Table structure for table `t_orders`
--

CREATE TABLE `t_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `code` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `fname` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `lname` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ptype` int NOT NULL DEFAULT '0',
  `price` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `products` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_orders`
--

INSERT INTO `t_orders` VALUES (1,'',0,'2023-04-26 01:02:22','2023-04-26 01:02:22','3kiLgJBTO2','alekos','varnezis','ddd@gmail.com','+306939322114',0,0,0,''),(2,'k5xLGeEdm',0,'2023-04-26 01:05:33','2023-04-26 01:05:33','k5xLGeEdm','alekos','varnezis','ddd@gmail.com','+306939322114',0,0,0,''),(3,'i4MY2xI8ZJ',0,'2023-04-26 01:06:14','2023-04-26 01:06:14','i4MY2xI8ZJ','alekos','varnezis','ddd@gmail.com','+306939322114',0,0,0,''),(4,'0rJz7HQ9bo',0,'2023-04-26 01:08:24','2023-04-26 01:08:24','0rJz7HQ9bo','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,''),(5,'igBtHURUAj',0,'2023-04-26 01:08:51','2023-04-26 01:08:51','igBtHURUAj','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,''),(6,'KGMfcLPsMo',0,'2023-04-26 01:12:16','2023-04-26 01:12:16','KGMfcLPsMo','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,''),(7,'Y9y6C93Gel',0,'2023-04-26 01:12:25','2023-04-26 01:20:28','Y9y6C93Gel','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,'[\"8\",\"7\"]'),(8,'SEkAClRlH',0,'2023-04-26 01:24:46','2024-08-23 10:40:40','SEkAClRlH','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,'[\"9\",\"10\",\"11\"]'),(9,'vKKxpM6jBB',0,'2023-04-26 01:24:49','2024-08-23 10:40:41','vKKxpM6jBB','alekos','varnezis','ddd@gmail.com','+306939322114',0,250,0,'[\"12\",\"13\",\"14\"]'),(10,'c5H4rDnBup',0,'2023-04-26 01:28:29','2024-08-23 10:40:42','c5H4rDnBup','1','1','1','1',0,250,0,'[\"15\",\"16\",\"17\"]'),(11,'ZyO4NDKJ7W',0,'2023-04-26 01:32:38','2024-08-23 10:40:44','ZyO4NDKJ7W','1','1','1','1',0,250,0,'[\"18\",\"19\",\"20\"]'),(12,'8PmA1B8Ro6',0,'2023-04-26 01:33:45','2024-08-23 10:40:45','8PmA1B8Ro6','1','1','1','1',0,225,0,'[\"21\",\"22\",\"23\"]'),(13,'rTyfXlhLdH',0,'2023-04-26 01:42:49','2024-08-23 10:40:45','rTyfXlhLdH','1','1','1','1',0,225,0,'[\"24\",\"25\",\"26\"]'),(14,'DeF5u0Lrmx',0,'2023-05-06 15:49:05','2024-08-23 10:40:46','DeF5u0Lrmx','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,148,0,'[\"27\"]'),(15,'WgKbiJRwnO',0,'2023-05-06 15:50:58','2024-08-23 10:40:47','WgKbiJRwnO','IONNNIS','CHARCHAROS','jcharcharos34@gmail.com','+306939322114',0,148,0,'[\"28\"]'),(16,'Rez0wMg4NO',0,'2023-05-07 11:12:16','2024-08-23 10:40:48','Rez0wMg4NO','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,148,0,'[\"46\"]'),(17,'8hMU7EXgbR',0,'2023-05-07 11:13:35','2024-08-23 10:40:28','8hMU7EXgbR','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,148,0,'[\"47\"]'),(18,'nmkQRbXuv4',0,'2023-05-07 12:07:48','2024-08-23 10:40:29','nmkQRbXuv4','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,148,0,'[\"48\"]'),(19,'0mGMvEvJ0M',2,'2023-06-27 21:00:39','2024-08-25 23:23:32','','','','','',2,0,2,'[\"49\",\"50\",\"51\",\"52\",\"53\"]'),(20,'IFlDcqOdJ0',0,'2023-06-27 21:04:09','2024-08-23 10:40:31','IFlDcqOdJ0','alekos','alekos','alekos@kkk.pol','6949554445',0,125,0,'[\"54\",\"55\",\"56\",\"57\",\"58\"]'),(21,'mQAAADY2L3',0,'2023-06-27 21:05:04','2024-08-23 10:40:32','mQAAADY2L3','alekos','alekos','alekos@kkk.pol','6949554445',0,125,0,'[\"59\",\"60\",\"61\",\"62\",\"63\"]'),(22,'11ojgoodVa',0,'2023-06-27 21:06:40','2024-08-23 10:40:33','11ojgoodVa','alekos','alekos','alekos@kkk.pol','6949554445',0,125,0,'[\"64\",\"65\",\"66\",\"67\",\"68\"]'),(23,'rzzWNqbYN',0,'2023-06-27 21:07:04','2024-08-23 10:40:34','rzzWNqbYN','alekos','alekos','alekos@pp.vpo','6949554445',0,125,0,'[\"69\",\"70\",\"71\",\"72\",\"73\"]'),(24,'Q3IF7VQY7F',0,'2023-06-27 21:07:19','2024-08-23 10:40:36','Q3IF7VQY7F','alekos','alekos','alekos@pp.vpo','6949554445',0,125,0,'[\"74\",\"75\",\"76\",\"77\",\"78\"]'),(25,'7jSLNTjaEv',0,'2023-06-27 21:08:01','2024-08-23 10:40:36','7jSLNTjaEv','alekos','alekos','alekos','alekos',0,125,0,'[\"79\",\"80\",\"81\",\"82\",\"83\"]'),(26,'Dz4Jwzrns8',0,'2023-06-27 21:10:30','2024-08-23 10:40:37','Dz4Jwzrns8','alekos','alekos','alekos','alekos',0,125,0,'[\"84\",\"85\",\"86\",\"87\",\"88\"]'),(27,'9JgCf2l2MX',0,'2023-06-27 21:10:38','2024-08-23 10:40:16','9JgCf2l2MX','alekos','alekos','alekos','alekos',1,125,0,'[\"89\",\"90\",\"91\",\"92\",\"93\"]'),(28,'1YAXzQilTy',0,'2023-06-27 21:10:45','2024-08-23 10:40:16','1YAXzQilTy','alekos','alekos','alekos','alekos',2,125,0,'[\"94\",\"95\",\"96\",\"97\",\"98\"]'),(29,'oZ2SidBS23',0,'2023-06-27 21:12:18','2024-08-23 10:40:17','oZ2SidBS23','alekos','alekos','alekos','alekos',2,125,0,'[\"99\",\"100\",\"101\",\"102\",\"103\"]'),(30,'t1wUxFiJf',0,'2023-06-27 21:17:50','2024-08-23 10:40:18','t1wUxFiJf','alekos','alekos','alekos','alekos',2,125,0,'[\"104\",\"105\",\"106\",\"107\",\"108\"]'),(31,'Ks0gr8fGfv',0,'2023-06-27 21:18:01','2024-08-23 10:40:19','Ks0gr8fGfv','alekos','alekos','alekos@pp.pol','alekos',2,0,0,'[\"\"]'),(32,'bDSaHbgmTV',0,'2023-06-27 21:22:30','2024-08-23 10:40:20','bDSaHbgmTV','alekos','alekos','alekos@pp.pol','alekos',0,18,0,'[\"109\"]'),(33,'SasTAZgtD',0,'2023-06-27 21:23:42','2024-08-23 10:40:20','SasTAZgtD','alekos','alekos','alekos@pp.pol','alekos',0,18,0,'[\"110\"]'),(34,'otA9eIGM1C',0,'2023-06-27 21:24:16','2024-08-23 10:40:22','otA9eIGM1C','alekos','alekos','alekos@pp.pol','alekos',0,0,0,'[\"\"]'),(35,'k1P4kKtkwV',0,'2023-06-27 21:25:05','2024-08-23 10:40:22','k1P4kKtkwV','alekos','alekos','alekos@pp.pol','alekos',0,18,0,'[\"111\"]'),(36,'E4GiO4WsYk',0,'2023-06-27 21:25:34','2024-08-23 10:40:23','E4GiO4WsYk','alekos','alekos','alekos@kk.pol','694955884',2,63,0,'[\"112\"]'),(37,'xxy7YMD8iF',0,'2023-06-27 21:27:51','2024-08-23 10:40:01','xxy7YMD8iF','alekos','alekos','alekos','6949554445',2,63,0,'[\"113\"]'),(38,'YkmRu9r27C',0,'2023-06-27 21:28:02','2024-08-23 10:40:02','YkmRu9r27C','alekos','alekos','alekos@hhh.pol','6949554445',2,0,0,'[\"\"]'),(39,'gHqwNt86FQ',0,'2023-06-27 21:29:01','2024-08-23 10:40:03','gHqwNt86FQ','alekos','alekos','alekos@pp.pol','6949554445',2,18,0,'[\"114\"]'),(40,'AEJT3uVEdr',0,'2023-06-27 21:30:19','2024-08-23 10:40:03','AEJT3uVEdr','alekos','alekos','alekos@pp.pol','6949554445',2,18,0,'[\"115\"]'),(41,'tflXsWrVJP',0,'2023-06-28 14:07:12','2024-08-23 10:40:05','tflXsWrVJP','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,18,0,'[\"116\"]'),(42,'OywtCAtwY',0,'2023-06-28 22:05:35','2024-08-23 10:40:06','OywtCAtwY','','','','',0,72,0,'[\"117\"]'),(43,'7sUxccKbef',0,'2023-06-29 07:19:03','2024-08-23 10:40:08','7sUxccKbef','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,290,1,'[\"118\"]'),(44,'QAuvMFHIyL',0,'2023-06-29 19:02:05','2024-08-23 10:40:09','QAuvMFHIyL','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,18,2,'[\"119\"]'),(45,'dkiZKKW0c9',0,'2023-06-29 20:11:39','2024-08-23 10:40:09','dkiZKKW0c9','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,642,0,'[\"120\",\"121\"]'),(46,'U2o0fa6rIX',0,'2023-06-29 20:12:23','2024-08-23 10:40:10','U2o0fa6rIX','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,624,0,'[\"122\"]'),(47,'7S48n2h1te',0,'2023-06-29 20:14:26','2024-08-23 10:39:40','7S48n2h1te','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,624,0,'[\"123\"]'),(48,'wzbFOhX5hG',0,'2023-06-29 20:15:00','2024-08-23 10:39:40','wzbFOhX5hG','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,624,0,'[\"124\"]'),(49,'nLqBEir0MF',0,'2023-06-29 20:16:08','2024-08-23 10:39:41','nLqBEir0MF','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,624,0,'[\"125\"]'),(50,'z3x9Ufp9Xv',0,'2023-06-29 20:20:03','2024-08-23 10:39:43','z3x9Ufp9Xv','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,624,0,'[\"126\"]'),(51,'PkffxeIN6X',0,'2023-06-29 20:23:06','2024-08-23 10:39:45','PkffxeIN6X','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,624,0,'[\"127\"]'),(52,'ur8StY2a2',0,'2023-06-29 20:23:38','2024-08-23 10:39:46','ur8StY2a2','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,780,0,'[\"128\"]'),(53,'b28PB1EsdB',0,'2023-06-29 20:23:42','2024-08-23 10:39:47','b28PB1EsdB','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,0,0,'[\"\"]'),(54,'1JHmFqdXVz',0,'2023-06-29 20:24:41','2024-08-23 10:39:49','1JHmFqdXVz','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,780,0,'[\"129\"]'),(55,'O6XLcDH3FFanZt1H',0,'2023-06-29 21:33:08','2024-08-23 10:39:49','O6XLcDH3FFanZt1H','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,1410,0,'[\"130\"]'),(56,'kwqcM767etZXJoQ2',0,'2023-06-29 22:04:20','2024-08-23 10:39:50','kwqcM767etZXJoQ2','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,44,0,'[\"131\"]'),(57,'L3qQ9bpQ6bfMIwDO',0,'2023-06-29 22:58:44','2024-08-23 10:39:28','L3qQ9bpQ6bfMIwDO','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,81,2,'[\"132\"]'),(58,'RwAtSQzM31F1XPrf',0,'2023-06-29 23:01:18','2024-08-23 10:39:28','RwAtSQzM31F1XPrf','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,72,1,'[\"133\"]'),(59,'dgrizrEhsbvv2i65',0,'2023-06-29 23:03:50','2024-08-23 10:39:29','dgrizrEhsbvv2i65','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,1410,1,'[\"134\"]'),(60,'6jQRuU1549w0tT8y',0,'2023-06-29 23:06:15','2024-08-23 10:39:30','6jQRuU1549w0tT8y','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,44,0,'[\"135\"]'),(61,'zzUOeqtqOok04Zli',0,'2023-06-29 23:07:45','2024-08-23 10:39:31','zzUOeqtqOok04Zli','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,38,0,'[\"136\"]'),(62,'gtQAxf8SYcnZ8X6K',0,'2023-06-30 13:52:11','2024-08-23 10:39:32','gtQAxf8SYcnZ8X6K','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,63,0,'[\"137\"]'),(63,'ihRl31LRwb5z0Iv',0,'2023-06-30 13:53:10','2024-08-23 10:39:32','ihRl31LRwb5z0Iv','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,72,0,'[\"138\"]'),(64,'4d8GBOsLhDDgDoM',0,'2023-06-30 13:53:18','2024-08-23 10:39:35','4d8GBOsLhDDgDoM','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,0,0,'[\"\"]'),(65,'8sS82mKs9JNb0all',0,'2023-06-30 13:53:31','2024-08-23 10:39:34','8sS82mKs9JNb0all','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',2,0,0,'[\"\"]'),(66,'QJsp1AidpbbKKDxS',0,'2023-06-30 13:53:56','2024-08-25 13:03:45','QJsp1AidpbbKKDxS','IONNNIS','CHARCHAROS','jcharcharos@gmail.com','+306939322114',0,72,0,'[\"139\"]');

--
-- Table structure for table `t_porders`
--

CREATE TABLE `t_porders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `title` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `persons` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `uprice` int NOT NULL DEFAULT '0',
  `fprice` int NOT NULL DEFAULT '0',
  `pdate` date NOT NULL DEFAULT '0000-00-00',
  `itemid` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_porders`
--

INSERT INTO `t_porders` VALUES (1,'',0,'2023-04-26 01:12:25','2023-04-26 01:12:25','Escape Room','Experience','1',25,25,'0000-00-00',0),(2,'',0,'2023-04-26 01:12:25','2023-04-26 01:12:25','Escape Room','Experience','3',25,75,'0000-00-00',0),(3,'',0,'2023-04-26 01:12:25','2023-04-26 01:12:25','Explorer Art','Tour','1',125,125,'0000-00-00',0),(4,'ewfewf',0,'2023-04-26 01:14:52','2024-08-25 23:26:43','Music Code Radio','','',0,0,'0000-00-00',0),(5,'32333',0,'2023-04-26 01:15:07','2024-08-25 23:26:18','32333','333','2',2,2,'0000-00-00',0),(6,'43t234t3t',0,'2023-04-26 01:18:49','2024-08-25 23:26:17','43t234t3t','43t34','4',4,4,'0000-00-00',0),(7,'44',0,'2023-04-26 01:19:08','2024-08-25 23:26:16','44','4r4r43','43r43',43341,3434,'0000-00-00',0),(8,'444',0,'2023-04-26 01:19:43','2024-08-25 23:26:16','444','444','44',44,44,'0000-00-00',0),(9,'',0,'2023-04-26 01:24:46','2023-04-26 01:24:46','Escape Room','Experience','1',25,25,'2023-04-26',0),(10,'',0,'2023-04-26 01:24:46','2023-04-26 01:24:46','Escape Room','Experience','3',25,75,'2023-04-26',0),(11,'',0,'2023-04-26 01:24:46','2023-04-26 01:24:46','Explorer Art','Tour','1',125,125,'2023-04-26',0),(12,'',0,'2023-04-26 01:24:49','2023-04-26 01:24:49','Escape Room','Experience','1',25,25,'2023-04-26',0),(13,'',0,'2023-04-26 01:24:49','2023-04-26 01:24:49','Escape Room','Experience','3',25,75,'2023-04-26',0),(14,'',0,'2023-04-26 01:24:49','2023-04-26 01:24:49','Explorer Art','Tour','1',125,125,'2023-04-26',0),(15,'',0,'2023-04-26 01:28:29','2023-04-26 01:28:29','Escape Room','Experience','1',25,25,'2023-04-26',0),(16,'',0,'2023-04-26 01:28:29','2023-04-26 01:28:29','Escape Room','Experience','3',25,75,'2023-04-26',0),(17,'',0,'2023-04-26 01:28:29','2023-04-26 01:28:29','Explorer Art','Tour','1',125,125,'2023-04-26',0),(18,'',0,'2023-04-26 01:32:38','2023-04-26 01:32:38','Escape Room','Experience','1',25,25,'2023-04-26',0),(19,'',0,'2023-04-26 01:32:38','2023-04-26 01:32:38','Escape Room','Experience','3',25,75,'2023-04-26',0),(20,'',0,'2023-04-26 01:32:38','2023-04-26 01:32:38','Explorer Art','Tour','1',125,125,'2023-04-26',0),(21,'',0,'2023-04-26 01:33:45','2023-04-26 01:33:45','Escape Room','Experience','1',25,25,'2023-04-26',0),(22,'',0,'2023-04-26 01:33:45','2023-04-26 01:33:45','Escape Room','Experience','3',25,75,'2023-04-26',0),(23,'',0,'2023-04-26 01:33:45','2023-04-26 01:33:45','Explorer Art','Tour','1',125,125,'2023-04-26',0),(24,'',0,'2023-04-26 01:42:49','2023-04-26 01:42:49','Escape Room','Experience','1',25,25,'2023-04-26',0),(25,'',0,'2023-04-26 01:42:49','2023-04-26 01:42:49','Escape Room','Experience','3',25,75,'2023-04-26',0),(26,'',0,'2023-04-26 01:42:49','2023-04-26 01:42:49','Explorer Art','Tour','1',125,125,'2023-04-26',0),(27,'',0,'2023-05-06 15:49:05','2023-05-06 15:49:05','Young street','Tour','1',148,148,'2023-05-10',0),(28,'',0,'2023-05-06 15:50:58','2023-05-06 15:50:58','Young street','Tour','1',148,148,'2023-05-10',0),(29,'',0,'2023-05-06 22:25:19','2023-05-06 22:25:19','Young street','Tour','1',148,148,'2023-05-12',0),(30,'',0,'2023-05-06 22:26:09','2023-05-06 22:26:09','Young street','Tour','1',148,148,'2023-05-12',0),(31,'',0,'2023-05-06 22:30:13','2023-05-06 22:30:13','Young street','Tour','1',148,148,'2023-05-12',0),(32,'',0,'2023-05-06 22:31:09','2023-05-06 22:31:09','Young street','Tour','1',148,148,'2023-05-12',0),(33,'',0,'2023-05-06 22:32:04','2023-05-06 22:32:04','Young street','Tour','1',148,148,'2023-05-12',0),(34,'',0,'2023-05-06 22:34:59','2023-05-06 22:34:59','Young street','Tour','1',148,148,'2023-05-12',0),(35,'',0,'2023-05-06 22:38:15','2023-05-06 22:38:15','Young street','Tour','1',148,148,'2023-05-12',0),(36,'',0,'2023-05-06 22:39:13','2023-05-06 22:39:13','Young street','Tour','1',148,148,'2023-05-12',0),(37,'',0,'2023-05-06 22:39:38','2023-05-06 22:39:38','Young street','Tour','1',148,148,'2023-05-12',0),(38,'',0,'2023-05-06 22:40:08','2023-05-06 22:40:08','Young street','Tour','1',148,148,'2023-05-12',0),(39,'',0,'2023-05-06 22:40:26','2023-05-06 22:40:26','Young street','Tour','1',148,148,'2023-05-12',0),(40,'',0,'2023-05-06 22:40:55','2023-05-06 22:40:55','Young street','Tour','1',148,148,'2023-05-12',0),(41,'',0,'2023-05-06 22:41:40','2023-05-06 22:41:40','Young street','Tour','1',148,148,'2023-05-12',0),(42,'',0,'2023-05-06 22:42:09','2023-05-06 22:42:09','Young street','Tour','1',148,148,'2023-05-12',0),(43,'',0,'2023-05-06 22:42:09','2023-05-06 22:42:09','Escape Room','Experience','1',25,25,'2023-05-06',0),(44,'',0,'2023-05-06 22:46:13','2023-05-06 22:46:13','Young street','Tour','1',148,148,'2023-05-12',0),(45,'',0,'2023-05-06 22:46:13','2023-05-06 22:46:13','Escape Room','Experience','1',25,25,'2023-05-06',0),(46,'',0,'2023-05-07 11:12:16','2023-05-07 11:12:16','Young street','Tour','1',148,148,'2023-05-07',0),(47,'',0,'2023-05-07 11:13:35','2023-05-07 11:13:35','Young street','Tour','1',148,148,'2023-05-07',0),(48,'',0,'2023-05-07 12:07:48','2023-05-07 12:07:48','Young street','Tour','1',148,148,'2023-05-07',0),(49,'',0,'2023-06-27 21:00:39','2023-06-27 21:00:39',' Grooming/ Limb care','Experience','1',21,21,'2023-06-27',0),(50,'',0,'2023-06-27 21:00:39','2023-06-27 21:00:39','Grooming/ Hair Care','Experience','1',18,18,'2023-06-27',0),(51,'',0,'2023-06-27 21:00:39','2023-06-27 21:00:39','Escape Room','Experience','1',18,18,'2023-06-27',0),(52,'',0,'2023-06-27 21:00:39','2024-08-25 23:23:54','Music Code Radio','','',0,0,'2023-06-27',0),(53,'',0,'2023-06-27 21:00:39','2023-06-27 21:00:39','Grooming/ Hair Care','Experience','1',50,50,'2023-06-27',0),(54,'',0,'2023-06-27 21:04:09','2023-06-27 21:04:09',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(55,'',0,'2023-06-27 21:04:09','2023-06-27 21:04:09','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(56,'',0,'2023-06-27 21:04:09','2023-06-27 21:04:09','Escape Room','Experience','1',18,18,'2023-06-27',0),(57,'',0,'2023-06-27 21:04:09','2023-06-27 21:04:09','Escape Room','Experience','1',18,18,'2023-06-27',0),(58,'',0,'2023-06-27 21:04:09','2023-06-27 21:04:09','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(59,'',0,'2023-06-27 21:05:04','2023-06-27 21:05:04',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(60,'',0,'2023-06-27 21:05:04','2023-06-27 21:05:04','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(61,'',0,'2023-06-27 21:05:04','2023-06-27 21:05:04','Escape Room','Experience','1',18,18,'2023-06-27',0),(62,'',0,'2023-06-27 21:05:04','2023-06-27 21:05:04','Escape Room','Experience','1',18,18,'2023-06-27',0),(63,'',0,'2023-06-27 21:05:04','2023-06-27 21:05:04','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(64,'',0,'2023-06-27 21:06:40','2023-06-27 21:06:40',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(65,'',0,'2023-06-27 21:06:40','2023-06-27 21:06:40','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(66,'',0,'2023-06-27 21:06:40','2023-06-27 21:06:40','Escape Room','Experience','1',18,18,'2023-06-27',0),(67,'',0,'2023-06-27 21:06:40','2023-06-27 21:06:40','Escape Room','Experience','1',18,18,'2023-06-27',0),(68,'',0,'2023-06-27 21:06:40','2023-06-27 21:06:40','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(69,'',0,'2023-06-27 21:07:04','2023-06-27 21:07:04',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(70,'',0,'2023-06-27 21:07:04','2023-06-27 21:07:04','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(71,'',0,'2023-06-27 21:07:04','2023-06-27 21:07:04','Escape Room','Experience','1',18,18,'2023-06-27',0),(72,'',0,'2023-06-27 21:07:04','2023-06-27 21:07:04','Escape Room','Experience','1',18,18,'2023-06-27',0),(73,'',0,'2023-06-27 21:07:04','2023-06-27 21:07:04','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(74,'',0,'2023-06-27 21:07:19','2023-06-27 21:07:19',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(75,'',0,'2023-06-27 21:07:19','2023-06-27 21:07:19','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(76,'',0,'2023-06-27 21:07:19','2023-06-27 21:07:19','Escape Room','Experience','1',18,18,'2023-06-27',0),(77,'',0,'2023-06-27 21:07:19','2023-06-27 21:07:19','Escape Room','Experience','1',18,18,'2023-06-27',0),(78,'',0,'2023-06-27 21:07:19','2023-06-27 21:07:19','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(79,'',0,'2023-06-27 21:08:01','2023-06-27 21:08:01',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(80,'',0,'2023-06-27 21:08:01','2023-06-27 21:08:01','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(81,'',0,'2023-06-27 21:08:01','2023-06-27 21:08:01','Escape Room','Experience','1',18,18,'2023-06-27',0),(82,'',0,'2023-06-27 21:08:01','2023-06-27 21:08:01','Escape Room','Experience','1',18,18,'2023-06-27',0),(83,'',0,'2023-06-27 21:08:01','2023-06-27 21:08:01','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(84,'',0,'2023-06-27 21:10:30','2023-06-27 21:10:30',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(85,'',0,'2023-06-27 21:10:30','2023-06-27 21:10:30','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(86,'',0,'2023-06-27 21:10:30','2023-06-27 21:10:30','Escape Room','Experience','1',18,18,'2023-06-27',0),(87,'',0,'2023-06-27 21:10:30','2023-06-27 21:10:30','Escape Room','Experience','1',18,18,'2023-06-27',0),(88,'',0,'2023-06-27 21:10:30','2023-06-27 21:10:30','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(89,'',0,'2023-06-27 21:10:38','2023-06-27 21:10:38',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(90,'',0,'2023-06-27 21:10:38','2023-06-27 21:10:38','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(91,'',0,'2023-06-27 21:10:38','2023-06-27 21:10:38','Escape Room','Experience','1',18,18,'2023-06-27',0),(92,'',0,'2023-06-27 21:10:38','2023-06-27 21:10:38','Escape Room','Experience','1',18,18,'2023-06-27',0),(93,'',0,'2023-06-27 21:10:38','2023-06-27 21:10:38','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(94,'',0,'2023-06-27 21:10:45','2023-06-27 21:10:45',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(95,'',0,'2023-06-27 21:10:45','2023-06-27 21:10:45','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(96,'',0,'2023-06-27 21:10:45','2023-06-27 21:10:45','Escape Room','Experience','1',18,18,'2023-06-27',0),(97,'',0,'2023-06-27 21:10:45','2023-06-27 21:10:45','Escape Room','Experience','1',18,18,'2023-06-27',0),(98,'',0,'2023-06-27 21:10:45','2023-06-27 21:10:45','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(99,'',0,'2023-06-27 21:12:18','2023-06-27 21:12:18',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(100,'',0,'2023-06-27 21:12:18','2023-06-27 21:12:18','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(101,'',0,'2023-06-27 21:12:18','2023-06-27 21:12:18','Escape Room','Experience','1',18,18,'2023-06-27',0),(102,'',0,'2023-06-27 21:12:18','2023-06-27 21:12:18','Escape Room','Experience','1',18,18,'2023-06-27',0),(103,'',0,'2023-06-27 21:12:18','2023-06-27 21:12:18','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(104,'',0,'2023-06-27 21:17:50','2023-06-27 21:17:50',' Grooming/ Limb care<br/>DOXOPOULOS  Gel Polish Manicure','Experience','1',21,21,'2023-06-27',0),(105,'',0,'2023-06-27 21:17:50','2023-06-27 21:17:50','Grooming/ Hair Care<br/>Mynever  Cuthair Man ','Experience','1',18,18,'2023-06-27',0),(106,'',0,'2023-06-27 21:17:50','2023-06-27 21:17:50','Escape Room','Experience','1',18,18,'2023-06-27',0),(107,'',0,'2023-06-27 21:17:50','2023-06-27 21:17:50','Escape Room','Experience','1',18,18,'2023-06-27',0),(108,'',0,'2023-06-27 21:17:50','2023-06-27 21:17:50','Grooming/ Hair Care<br/>Mynever Hair Treatment and Haistyle','Experience','1',50,50,'2023-06-27',0),(109,'',0,'2023-06-27 21:22:30','2023-06-27 21:22:30','Escape Room','Experience','1',18,18,'2023-06-27',0),(110,'',0,'2023-06-27 21:23:42','2023-06-27 21:23:42','Escape Room','Experience','1',18,18,'2023-06-27',0),(111,'',0,'2023-06-27 21:25:05','2023-06-27 21:25:05','Escape Room','Experience','1',18,18,'2023-06-27',0),(112,'',0,'2023-06-27 21:25:34','2023-06-27 21:25:34','Μαθήματα Κεραμεικης','Experience','1',63,63,'2023-06-27',0),(113,'',0,'2023-06-27 21:27:51','2023-06-27 21:27:51','Ceramic lessons','Experience','1',63,63,'2023-06-27',0),(114,'',0,'2023-06-27 21:29:01','2023-06-27 21:29:01','Escape Room','Experience','1',18,18,'2023-06-27',0),(115,'',0,'2023-06-27 21:30:19','2023-06-27 21:30:19','Escape Room','Experience','1',18,18,'2023-06-27',0),(116,'',0,'2023-06-28 14:07:12','2023-06-28 14:07:12','Escape Room','Experience','1',18,18,'2023-06-28',0),(117,'',0,'2023-06-28 22:05:35','2023-06-28 22:05:35','Ημερήσιες Αποδράσεις με Yaght<br/>Half-day trip - monohull ','Experience','1',72,72,'2023-06-28',0),(118,'',0,'2023-06-29 07:19:03','2023-06-29 07:19:03','Ημερήσιες Αποδράσεις με Yaght<br/>Full day - catamaran','Experience','2',145,290,'2023-06-19',0),(119,'',0,'2023-06-29 19:02:05','2023-06-29 19:02:05','Escape Room','Experience','1',18,18,'2023-06-29',0),(120,'',0,'2023-06-29 20:11:39','2023-06-29 20:11:39','Escape Room','Experience','1',18,18,'2023-06-29',0),(121,'',0,'2023-06-29 20:11:39','2023-06-29 20:11:39','Young street','Tour','4',156,624,'2023-06-29',0),(122,'',0,'2023-06-29 20:12:23','2023-06-29 20:12:23','Young street','Tour','4',156,624,'2023-06-29',0),(123,'',0,'2023-06-29 20:14:26','2023-06-29 20:14:26','Young street','Tour','4',156,624,'2023-06-29',0),(124,'',0,'2023-06-29 20:15:00','2023-06-29 20:15:00','Young street','Tour','4',156,624,'2023-06-29',0),(125,'',0,'2023-06-29 20:16:08','2023-06-29 20:16:08','Young street','Tour','4',156,624,'2023-06-29',0),(126,'',0,'2023-06-29 20:20:03','2023-06-29 20:20:03','Young street','Tour','4',156,624,'2023-06-29',0),(127,'',0,'2023-06-29 20:23:06','2023-06-29 20:23:06','Young street','Tour','4',156,624,'2023-06-29',1),(128,'',0,'2023-06-29 20:23:38','2023-06-29 20:23:38','Family ancient','Tour','4',195,780,'2023-06-29',5),(129,'',0,'2023-06-29 20:24:41','2023-06-29 20:24:41','Family ancient','Tour','4',195,780,'2023-06-29',5),(130,'',0,'2023-06-29 21:33:08','2023-06-29 21:33:08','Grand Art','Tour','10',141,1410,'2023-06-29',12),(131,'',0,'2023-06-29 22:04:20','2023-06-29 22:04:20','Γνωριμία με ελληνικά κρασιά','Experience','1',44,44,'2023-06-29',0),(132,'',0,'2023-06-29 22:58:44','2023-06-29 22:58:44','Μαθήματα Μαγειρικής','Experience','1',81,81,'2023-06-29',0),(133,'',0,'2023-06-29 23:01:18','2023-06-29 23:01:18','Βολτα στον Εθνικό κήπο με πικνικ','Experience','1',72,72,'2023-06-29',0),(134,'',0,'2023-06-29 23:03:50','2023-06-29 23:03:50','Grand Art','Tour','10',141,1410,'2023-06-29',12),(135,'',0,'2023-06-29 23:06:15','2023-06-29 23:06:15','vegan','Experience','1',44,44,'2023-06-29',0),(136,'',0,'2023-06-29 23:07:45','2023-06-29 23:07:45','Improvibe workshop','Experience','1',38,38,'2023-06-29',0),(137,'',0,'2023-06-30 13:52:10','2023-06-30 13:52:10','Μαθήματα Κεραμεικης','Experience','1',63,63,'2023-06-30',0),(138,'',0,'2023-06-30 13:53:09','2023-06-30 13:53:09','Ημερήσιες Αποδράσεις με Yaght<br/>Half-day trip - monohull ','Experience','1',72,72,'2023-06-30',0),(139,'',0,'2023-06-30 13:53:56','2023-06-30 13:53:56','Ημερήσιες Αποδράσεις με Yaght<br/>Half-day trip - monohull ','Experience','1',72,72,'2023-06-30',0),(140,'-2',0,'2024-08-25 23:34:44','2024-08-25 23:34:44','','','',0,0,'0000-00-00',0),(141,'-3',0,'2024-08-25 23:35:36','2024-08-25 23:35:46','','','',0,0,'0000-00-00',0),(142,'-4',2,'2024-08-25 23:45:47','2024-08-25 23:45:47','','','',0,0,'0000-00-00',0),(143,'-5',2,'2024-08-25 23:48:06','2024-08-25 23:48:18','','','',0,0,'0001-11-30',0);

--
-- Table structure for table `t_settings`
--

CREATE TABLE `t_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `meta_title_el` varchar(255) NOT NULL DEFAULT '',
  `meta_description_el` text NOT NULL,
  `meta_keywords_el` varchar(255) NOT NULL DEFAULT '',
  `meta_title_en` varchar(255) NOT NULL DEFAULT '',
  `meta_description_en` text NOT NULL,
  `meta_keywords_en` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `logo` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `mobile` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `address_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `address_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `facebook` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `instagram` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `linkedin` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `copyright_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `copyright_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `map` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_settings`
--

INSERT INTO `t_settings` VALUES (1,'',1,'2023-03-20 21:49:56','2024-08-26 16:09:15','Music Code Radio','www.musiccoderadio.com','','Finger Print','','','Music Code Radio','digital_photo.png','radiocodemusic@gmail.com','+30','.','','https://www.facebook.com/profile.php?id=100091982916895','','','www.musiccoderadio.com','','Copyright 2023 Music Code Radio. All Rights Reserved.','','{\"address\":\"5 Αγοναρίδου Αθήνα\",\"center\":{\"lat\":37.9572676,\"lng\":23.7294323},\"zoom\":17,\"place\":{\"address_components\":[{\"long_name\":\"5\",\"short_name\":\"5\",\"types\":[\"street_number\"]},{\"long_name\":\"Αγοναρίδου\",\"short_name\":\"Αγοναρίδου\",\"types\":[\"route\"]},{\"long_name\":\"Αθήνα\",\"short_name\":\"Αθήνα\",\"types\":[\"locality\",\"political\"]},{\"long_name\":\"Κεντρικός Τομέας Αθηνών\",\"short_name\":\"Κεντρικός Τομέας Αθηνών\",\"types\":[\"administrative_area_level_3\",\"political\"]},{\"long_name\":\"Ελλάδα\",\"short_name\":\"GR\",\"types\":[\"country\",\"political\"]},{\"long_name\":\"117 44\",\"short_name\":\"117 44\",\"types\":[\"postal_code\"]}],\"geometry\":{\"location\":{\"lat\":37.9572676,\"lng\":23.7294323},\"viewport\":{\"south\":37.9559181197085,\"west\":23.7281139697085,\"north\":37.9586160802915,\"east\":23.7308119302915}},\"icon\":\"https://maps.gstatic.com/mapfiles/place_api/icons/v1/png_71/geocode-71.png\",\"name\":\"Αγοναρίδου 5\",\"html_attributions\":[]}}');

--
-- Table structure for table `t_tourevents`
--

CREATE TABLE `t_tourevents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `title_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `image1` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `image2` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `category` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_tourevents`
--

INSERT INTO `t_tourevents` VALUES (1,'incentives',0,'2023-04-27 19:03:23','2024-08-23 10:42:46','Ενδοεταιρικα events','Incentives Events','<p>Τα ενδοεταιρικά events επιβραβεύουν και κινητοποιούν και επιβραβεύουν τους υπαλλήλους μιας εταιρείας και παραμένουν με κίνητρα στην δουλειά τους και στην καθημερινότητά τους. Η εμπειρία μας έχει δείξει ότι ένα τέτοιο event όχι μόνο ενδυναμώνει τις σχέσεις το υπαλλήλων αλλά αποφέρει το μέγιστο δυναμικό τους για την επίτευξη των μέγιστων δυνατών  αποτελεσμάτων!</p>\r\n<p>Η πολύ έμπειρη ομάδα μας σου εγγυάται Πώς με ένα τέτοιο πρόγραμμα το οποίο θα είναι συνυφασμένο με τις ανάγκες και τους στόχους της εταιρείας θα βοηθήσει να απογειωθούν οι στόχοι της χρονιάς!</p>','<p>Incentive events allow your company to reward and motivate top-performing employees for their hard work, so that everyone feels valued and stay motivated. As we’ve been planning such events occasions for decades, we guarantee to organize one-of-a-kind events that will fuel your employees’ drive to aim higher. Our highly experienced team can create a bespoke program according to your needs that will be in alignment with your company’s goals and vision.</p>','team2/4.jpg','team2/1.jpg',1),(2,'corporate-events',0,'2023-04-27 19:05:28','2024-08-23 10:42:44','Εταιρικά events','Corporate Events','<p>Η εξειδικευμένη ομάδα μας αναλύει προσεκτικά όλες τις απαιτήσεις σας και μαζί αναπτύσσουμε και διαμορφώνουμε ένα πρόγραμμα από event το οποίο  απευθύνεται στους υπαλλήλους σας αλλά και  στους πελάτες σας !</p>\r\n<p>Μαζί αναλύουμε την εταιρεία από κάθε οπτική και εγγυόμαστε μία πετυχημένη συνεργασία όλων των συμμετεχόντων !</p>','<p>Our specialized team carefully analyses your requirements. Together, we develop and shape the program of your event, whether it is addressed to the staff of your company or to your customers. We undertake the organization of every aspect of the event and successfully complete it, ensuring a unique &amp; exciting experience for the participants.</p>','team2/5.jpg','',1),(3,'team-building',0,'2023-04-27 19:07:10','2024-08-23 10:42:44','Team Building','Team Building','<p>Μία εταιρεία είναι τόσο δυνατή όσο δυνατή είναι η ομάδα πίσω από αυτήν και κυρίως όταν αυτή απαρτίζεται από μία χαρούμενη ομάδα, τότε σίγουρα αυτός είναι ένας τρόπος για να μεγαλώσει αποτελεσματικά η εταιρεία και οι στόχοι της !!!</p>\r\n<p>Σας προκαλούμε ,λοιπόν να οργανώσουμε μαζί ένα team building bonding program το οποίο  θα ενδυναμώσει στο μέγιστο τις δυνατότητες της ομάδας σας και των ικανοτήτων των στελεχών σας!</p>\r\n<p>Και όλα αυτά μέσα από το να περάσουνε πραγματικά ευχάριστα αλλά πάνω από όλα με βάση το πλάνο που θα αρμόζει απόλυτα στις ανάγκες της εταιρείας ! Έτσι δίνουμε την ευκαιρία εντός ή εκτός εταιρείας να βρουν οι υπάλληλοι σας τα κίνητρα τους και μία μεγαλύτερη αίσθηση αυτό εκπλήρωσης!!! Ένα Teambuilding event μπορεί να αυξήσει θετικά και με κερδοφορία την αλληλεπίδραση της παραγωγικότητας στην εταιρείας σας .</p>','<p>A business is only as strong as the team behind it, which is why building a cohesive, happy team is a sure-fire way to help your business grow and thrive. As the premier team building organizers in Greece, we can provide team building and corporate bonding services that will bring your people together and boost your employees’ team and management skills. Our team building activities are designed to be fun can be tailored to suit the needs of your company. By giving your staff a chance to get out of the office and engage in some fun activities, you will find there is renewed motivation and a greater sense of camaraderie.</p>\r\n<p>Team building events can have an incredibly positive and beneficial impact on the productivity of your business.</p>','team2/9.jpg','team2/7.jpg',0),(4,'conference-and-meetings',2,'2023-04-27 19:09:03','2024-08-25 23:47:09','','','<p><img src=\"https://mediafingertrip.betostokos.com/images/0/0/346613121_986131219248360_7009191647894248952_n.jpg\" alt=\"\" width=\"405\" height=\"514\" /></p>','<p>To deliver an integrated project such as conference requires a long-term process. With a team of specialists with extensive experience in creating, designing, and implementing creative projects and in cooperation with qualified partners we will deliver to you a full package of qualitative, creative and perfectly combined services for your meetings.</p>\r\n<p>Regardless of if you addressed to us for a meeting of few attendees or for a conference of thousands of attendees, our dedicated team would handle with professionalism your project from the stage of creation till its implementation, designing with you step by step a project that will meet all your expectations.</p>','digital_photo.png','',0),(5,'weddings',0,'2023-04-27 19:12:26','2024-08-23 10:42:42','Γάμοι','Weddings','<p>Από τη Σαντορίνη και τη Μύκονο μέχρι τη Θεσσαλονίκη και την Αθήνα ...<br />Ο γάμος σου είναι η πιο αξέχαστη μέρα της ζωής σου και την θέλεις να είναι τέλεια!!!! Η ομάδα μας αποτελείται από υψηλά στελέχη, έμπειρα για να οργανώσουν ακριβώς ότι έχεις και ότι ονειρεύεσαι για εκείνη την μοναδική σου Ημέρα !!!</p>\r\n<p>Είμαστε περήφανοι για την ποιότητα των υπηρεσιών μας και για τη λεπτομέρεια με την οποία εργαζόμαστε πάνω σε αυτό που εσύ επιθυμείς. Πάντα ακούμε τις προτάσεις σου και τις ιδιαίτερες απαιτήσεις σου και μπορούμε να οργανώσουμε κάθε λεπτομέρεια της ημέρας εκείνης από το να κλείσουμε το χώρο, το catering, την μεταφορά σου, τα λουλούδια, την διακόσμηση, την μουσική αλλά ακόμα και την πιο παραμικρή λεπτομέρεια όπως ακριβώς την έχεις ονειρευτεί...</p>\r\n<p>Εσύ απλά θα απολαύσεις μαζί μας τη διαδικασία και αυτή την τόσο ιδιαίτερη ημέρα που σου ανήκει...Μαζί μας είσαι ήσυχος ότι ο γάμος σου θα είναι ακριβώς αυτό που έχεις ονειρευτεί!!!!!</p>','<p>From Santorini to Mykonos and Thessaloniki to Athens your wedding is the most special, memorable day of your life, and you want it to be perfect. We have a highly experienced team of wedding planners, who are perfectly placed to take the burden of all that planning away, leaving you free to simply enjoy the experience. We pride ourselves on the quality of our services and our attention to detail.</p>\r\n<p>Whether you have a theme in mind or are open to suggestions, our highly professional planners will go above and beyond to accommodate your special requests. We can take care of every element of your wedding, from finding and booking a venue, catering, and transport to even the finest details of your table décor and flower arrangements.</p>\r\n<p>By delegating the planning to us, you’re able to simply relax and enjoy that special day, safe in the knowledge that your wedding will be perfect!</p>','team2/3.jpg','team2/6.jpg',1),(6,'event-marketing-future-of-communication',0,'2023-04-27 19:13:45','2024-08-23 10:42:42','Event marketing PR και επικοινωνία','Event marketing – future of communication','<p>Ειλικρινά πιστεύουμε πως ένα event είναι ο τρόπος που θα επικοινωνούμε στο μέλλον, γιατί οι συμμετέχοντες είναι  παρών \"στο τώρα\" με όλες τις αισθήσεις τους.<br />Η παρουσία είναι ο μόνος αποτελεσματικός τρόπος για να δημιουργήσεις όμορφα συναισθήματα και πραγματική  σύνδεση για την εταιρεία σου, το branding σου και τα προϊόντα σου μέσα από τον οραματισμό, μέσα από την ακοή, την αφή, την μυρωδιά την γεύση και την διαίσθηση.</p>\r\n<p>Έχουμε την ικανότητα να σε βοηθήσουμε να υλοποιήσεις τους στόχους για τους οποίους δημιουργήθηκε αυτό το event!!! Άλλωστε με τον καταιγισμό της πληροφορίας που έχει ο κάθε καταναλωτής στην καθημερινότητά του είναι πάρα πολύ δύσκολο να τραβήξεις την προσοχή του κοινού και να διατηρήσεις το ενδιαφέρον του αμείωτο!</p>\r\n<p>Επομένως ένα event marketing είναι ένας από τους καλύτερους τρόπους έτσι ώστε ευχάριστα να δημιουργήσεις, έκπληξη στο κοινό σου, δίνοντας μία επιπρόσθετη αξία στο υποσυνείδητο και στην κατοχύρωση της εταιρείας σου!!!! Αυτό που μπορούμε να σας εγγυηθούμε είναι ότι τα event μας είναι επιτυχημένα και υπηρετούν εξαιρετικά εργαλεία επικοινωνίας. </p>','<p>We truly believe that events are communication of future! Why? Because only in the event person is present – “here and now”, we can approach the person through all their senses. And presence is the most effective way of creating good emotions and connection with your company, brand or product through vision, hearing, touch, smell, taste, and intuition.</p>\r\n<p>We will help you to implement vision of the event and reach the set goals. With further development of the advertising sector, it becomes increasingly difficult for every company to attract the attention of public, media, and potential customers.</p>\r\n<p>Event marketing is one of the best ways how to pleasantly surprise the audience – with real events, emotions and added value to the world.</p>\r\n<p>We will make sure your events are successful and serve as excellent tools of communication.</p>','team2/8.jpg','',1),(7,'',0,'2024-08-25 13:17:24','2024-08-25 23:27:36','','','','','346613121_986131219248360_7009191647894248952_n.jpg','',0),(8,'-2',0,'2024-08-25 23:45:03','2024-08-25 23:45:03','','','','','','',0),(9,'-3',0,'2024-08-25 23:46:50','2024-08-25 23:46:50','','','','','','',0),(10,'-4',2,'2024-08-25 23:49:13','2024-08-25 23:49:13','','','','','','',0),(11,'-5',2,'2024-08-25 23:49:21','2024-08-25 23:49:21','','','','','','',0);

--
-- Table structure for table `t_troureventpage`
--

CREATE TABLE `t_troureventpage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `caption` varchar(256) NOT NULL DEFAULT '',
  `active` tinyint NOT NULL DEFAULT '2' COMMENT 'Κατάσταση εγγραφής. 0: διεγραμμένη, 1: Ενεργή, 2: Ανενεργή',
  `cdatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα δημιουργίας εγγραφής.',
  `udatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Ημερομηνία/ώρα ενημέρωσης εγγραφής.',
  `meta_title_el` varchar(255) NOT NULL DEFAULT '',
  `meta_description_el` text NOT NULL,
  `meta_keywords_el` varchar(255) NOT NULL DEFAULT '',
  `meta_title_en` varchar(255) NOT NULL DEFAULT '',
  `meta_description_en` text NOT NULL,
  `meta_keywords_en` varchar(255) NOT NULL DEFAULT '',
  `title_el` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title_en` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `himage` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description2_el` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description2_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `active` (`active`),
  KEY `cdatetime` (`cdatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_troureventpage`
--

INSERT INTO `t_troureventpage` VALUES (1,'team-buildings-events',1,'2023-04-27 19:29:20','2024-08-25 23:46:38','','','','Team Buildings & Events','We are FINGERTRIP team, a multi award-winning event company, recognised as one of the best providers for your needs. With a team of professional experienced, creative, dynamic & dedicated professionals, we have pushed all areas of event management to new heights.','','Team ','Team ','','','digital_photo.png','','');

--
-- Table structure for table `template`
--

CREATE TABLE `template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `site_id` int NOT NULL DEFAULT '0',
  `name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '' COMMENT 'table name',
  `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'Το πλήρες όνομα του πίνακα (με ''t_'' prefix).',
  `list` tinyint NOT NULL DEFAULT '0' COMMENT 'Καθορίζει αν ο πίνακας περιέχει πολλαπλές εγγραφές, ή μόνο μία.',
  `route_prefix` varchar(127) DEFAULT '',
  `share_prefix` varchar(127) DEFAULT '',
  `has_meta` tinyint DEFAULT '0' COMMENT 'Αν θα χρησιμοποιούνται τα meta πεδΙα (meta_title, description, keywords) στον αντίστοιχο πίνακα.',
  `orderable` tinyint DEFAULT '0',
  `shareable` tinyint DEFAULT '0',
  `publishable` tinyint DEFAULT '0',
  `cacheable` tinyint DEFAULT '0',
  `supports_hiding_fields` tinyint DEFAULT '0',
  `order_column` varchar(64) DEFAULT 'id',
  `order_type` tinyint DEFAULT '0' COMMENT '0=DESC, 1=ASC',
  `columns` varchar(30) DEFAULT '12' COMMENT 'CSV column widths, eg: 8,2,2 means 3 cols where the first one has a width of the 8/12 of the total available width.',
  `options` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `site_id_name` (`site_id`,`name`),
  UNIQUE KEY `table_name_UNIQUE` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `template`
--

INSERT INTO `template` VALUES (1,1,'Settings','settings',0,'','',1,0,0,0,0,0,'id',0,'6,6',''),(14,1,'Orders','orders',1,'','',0,0,0,0,0,0,'id',0,'4,8',NULL),(15,1,'Order Products','porders',1,'','',0,0,0,0,0,0,'id',0,'12',NULL),(16,1,'Teams & Events','tourevents',1,'','',0,0,0,0,0,0,'id',0,'8,4',NULL),(17,1,'Teams & Events Page','troureventpage',0,'','',1,0,0,0,0,0,'id',0,'8,4',NULL),(18,1,'About Us','aboutus',0,'','',1,0,0,0,0,0,'id',0,'6,6',NULL),(20,1,'Collab Customers','colabs',1,'','',0,0,0,0,0,0,'id',0,'12',NULL),(23,1,'Contents','content',1,'','',0,0,0,0,0,0,'id',0,'12',NULL);

--
-- Table structure for table `template_field`
--

CREATE TABLE `template_field` (
  `id` int NOT NULL AUTO_INCREMENT,
  `template_id` int NOT NULL,
  `type` smallint NOT NULL DEFAULT '0' COMMENT 'Ο τύπος του πεδίου (πχ 1 = Text Input, 2 = Checkbox). \nΟι τύποι <100 είναι απλά πεδία για τα οποία δεν αποθηκεύουμε κάποιο default value.\nΟι τύποι >100 είναι πεδία που περιλαμβάνουν πιθανώς πολλαπλά values και μπορεί να έχουν και ένα default value (πχ 101  =  Select Group, 102 = Radio Group).\n\n(βλ class ModelTemplate για τα διαθέσιμα field_types)',
  `label` varchar(64) NOT NULL DEFAULT '',
  `column_name` varchar(64) NOT NULL DEFAULT '',
  `values` longtext COMMENT 'Λίστα JSON από επιτρεπόμενες τιμές του πεδίου.',
  `default` int DEFAULT NULL COMMENT 'Δείχνει ποιό από τα values είναι το προεπιλεγμένο. NULL σημαίνει κανένα.',
  `used_in_caption` tinyint NOT NULL DEFAULT '0' COMMENT 'Αν το συγκεκριμένο πεδίο θα δίνει την τιμή του στο caption της αντίστοιχης σελίδας.',
  `sort_order` smallint NOT NULL DEFAULT '0' COMMENT 'Η σειρά κατάταξης του πεδίου σε ένα template.',
  `show_in_table` tinyint NOT NULL DEFAULT '0' COMMENT 'Αν θα φαίνεται το πεδίο στo datatable του view_table.',
  `foreign_table` varchar(65) DEFAULT NULL,
  `foreign_template_id` int DEFAULT NULL,
  `multilingual` tinyint NOT NULL DEFAULT '0',
  `parent_field_id` int DEFAULT NULL,
  `order_type` tinyint NOT NULL DEFAULT '0' COMMENT '0 : Not an order_by column, 1: Order by this column DESC, 2: Order by this column ASC',
  `panel_id` int NOT NULL DEFAULT '0' COMMENT 'Foreign key to template_panel table.',
  `options` longtext,
  PRIMARY KEY (`id`),
  KEY `fk_template_field_1_idx` (`template_id`),
  CONSTRAINT `fk_template_field_1` FOREIGN KEY (`template_id`) REFERENCES `template` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `template_field`
--

INSERT INTO `template_field` VALUES (1,1,1,'Γενικός Τίτλος','title',NULL,NULL,1,0,0,NULL,NULL,0,NULL,0,43,NULL),(2,1,6,'Λογότυπο','logo',NULL,NULL,0,1,0,NULL,NULL,0,NULL,0,43,NULL),(3,1,1,'E-mail','email',NULL,NULL,0,5,0,NULL,NULL,0,NULL,0,45,NULL),(5,1,1,'Κινητό','mobile',NULL,NULL,0,6,0,NULL,NULL,0,NULL,0,45,NULL),(6,1,1,'Διεύθυνση','address',NULL,NULL,0,7,0,NULL,NULL,1,NULL,0,45,NULL),(7,1,1,'Facebook','facebook',NULL,NULL,0,2,0,NULL,NULL,0,NULL,0,44,NULL),(8,1,1,'Instagram','instagram',NULL,NULL,0,3,0,NULL,NULL,0,NULL,0,44,NULL),(10,1,1,'TikTok','linkedin',NULL,NULL,0,4,0,NULL,NULL,0,NULL,0,44,NULL),(56,14,1,'Code','code',NULL,NULL,1,0,1,NULL,NULL,0,NULL,0,22,NULL),(57,14,1,'First Name','fname',NULL,NULL,0,4,1,NULL,NULL,0,NULL,0,23,NULL),(58,14,1,'Last Name','lname',NULL,NULL,0,5,1,NULL,NULL,0,NULL,0,23,NULL),(59,14,1,'Email','email',NULL,NULL,0,6,1,NULL,NULL,0,NULL,0,23,NULL),(60,14,1,'Phone','phone',NULL,NULL,0,7,0,NULL,NULL,0,NULL,0,23,NULL),(61,14,101,'Payment Type','ptype','[\"Paypal\",\"Credit Card\",\" Bank Deposit\"]',NULL,0,3,1,NULL,NULL,0,NULL,0,22,NULL),(62,14,9,'Price','price',NULL,NULL,0,1,1,NULL,NULL,0,NULL,0,22,NULL),(63,14,101,'Status','status','[\"In Progress\",\"Success\",\"Cancel\"]',NULL,0,2,1,NULL,NULL,0,NULL,0,22,NULL),(64,15,1,'Title','title',NULL,NULL,1,0,1,NULL,NULL,0,NULL,0,0,NULL),(65,15,1,'Type','type',NULL,NULL,0,1,0,NULL,NULL,0,NULL,0,0,NULL),(66,15,1,'Persons','persons',NULL,NULL,0,2,0,NULL,NULL,0,NULL,0,0,NULL),(68,15,9,'Unit Price','uprice',NULL,NULL,0,4,0,NULL,NULL,0,NULL,0,0,NULL),(69,15,9,'Total Price','fprice',NULL,NULL,0,5,0,NULL,NULL,0,NULL,0,0,NULL),(70,14,1203,'Products','products',NULL,NULL,0,8,0,'t_porders',15,0,NULL,0,24,'{\"shown_foreign_fields\": [\"caption_label\",\"65\",\"66\",\"72\",\"68\",\"69\"] }'),(72,15,12,'Date','pdate',NULL,NULL,0,5,0,NULL,NULL,0,NULL,0,0,NULL),(73,16,1,'Title','title',NULL,NULL,1,0,1,NULL,NULL,1,NULL,0,25,NULL),(74,16,5,'Description','description',NULL,NULL,0,1,0,NULL,NULL,1,NULL,0,25,NULL),(75,16,6,'Image1','image1',NULL,NULL,0,2,1,NULL,NULL,0,NULL,0,26,NULL),(76,16,6,'Image2','image2',NULL,NULL,0,3,0,NULL,NULL,0,NULL,0,26,NULL),(77,16,101,'Category','category','[\"Team Building\",\"Event\"]',NULL,0,4,1,NULL,NULL,0,NULL,0,26,NULL),(78,17,1,'Title','title',NULL,NULL,1,0,1,NULL,NULL,1,NULL,0,29,NULL),(79,17,4,'Description','description',NULL,NULL,0,1,0,NULL,NULL,1,NULL,0,29,NULL),(80,17,6,'Header Image','himage',NULL,NULL,0,3,1,NULL,NULL,0,NULL,0,30,NULL),(81,17,5,'Description2','description2',NULL,NULL,0,2,0,NULL,NULL,1,NULL,0,29,NULL),(82,18,1,'Title','title',NULL,NULL,1,0,0,NULL,NULL,1,NULL,0,35,NULL),(83,18,6,'Header Image','himage',NULL,NULL,0,1,0,NULL,NULL,0,NULL,0,35,NULL),(84,18,1,'Title1','title1',NULL,NULL,0,2,0,NULL,NULL,1,NULL,0,36,NULL),(85,18,4,'Description1','description1',NULL,NULL,0,3,0,NULL,NULL,1,NULL,0,36,NULL),(86,18,6,'Image1','image1',NULL,NULL,0,4,0,NULL,NULL,0,NULL,0,36,NULL),(87,18,6,'Image2','image2',NULL,NULL,0,5,0,NULL,NULL,0,NULL,0,36,NULL),(88,18,1,'Title2','title2',NULL,NULL,0,6,0,NULL,NULL,1,NULL,0,37,NULL),(89,18,4,'Description2','description2',NULL,NULL,0,7,0,NULL,NULL,1,NULL,0,37,NULL),(90,18,1,'Title3','title3',NULL,NULL,0,8,0,NULL,NULL,1,NULL,0,38,NULL),(91,18,4,'Description1','description31',NULL,NULL,0,11,0,NULL,NULL,1,NULL,0,38,NULL),(92,18,6,'Image3','image3',NULL,NULL,0,9,0,NULL,NULL,0,NULL,0,38,NULL),(94,18,1,'Title1','title31',NULL,NULL,0,10,0,NULL,NULL,1,NULL,0,38,NULL),(95,18,1,'Title2','title32',NULL,NULL,0,12,0,NULL,NULL,1,NULL,0,38,NULL),(96,18,1,'Title3','title33',NULL,NULL,0,14,0,NULL,NULL,1,NULL,0,38,NULL),(97,18,4,'Description2','description32',NULL,NULL,0,13,0,NULL,NULL,1,NULL,0,38,NULL),(98,18,4,'Description3','description33',NULL,NULL,0,15,0,NULL,NULL,1,NULL,0,38,NULL),(101,20,1,'Title','title',NULL,NULL,1,0,1,NULL,NULL,1,NULL,0,0,NULL),(102,20,6,'Image','image',NULL,NULL,0,1,1,NULL,NULL,0,NULL,0,0,NULL),(103,20,1,'Url','url',NULL,NULL,0,2,0,NULL,NULL,0,NULL,0,0,NULL),(104,20,1101,'Category','category',NULL,NULL,0,3,1,'t_colabcats',19,0,NULL,0,0,NULL),(106,1,4,'Description','description',NULL,NULL,0,9,0,NULL,NULL,1,NULL,0,46,NULL),(107,1,1,'Copyright','copyright',NULL,NULL,0,8,0,NULL,NULL,1,NULL,0,46,NULL),(111,1,8,'Map','map',NULL,NULL,0,10,0,NULL,NULL,0,NULL,0,46,NULL),(148,23,1,'Title','title',NULL,NULL,1,0,1,NULL,NULL,1,NULL,0,0,NULL),(149,23,5,'Text','text',NULL,NULL,0,1,0,NULL,NULL,1,NULL,0,0,NULL);

--
-- Table structure for table `template_panel`
--

CREATE TABLE `template_panel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `template_id` int NOT NULL,
  `title` varchar(64) NOT NULL DEFAULT '',
  `x` tinyint NOT NULL DEFAULT '0',
  `y` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_template_panel_1_idx` (`template_id`),
  CONSTRAINT `fk_template_panel_1` FOREIGN KEY (`template_id`) REFERENCES `template` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `template_panel`
--

INSERT INTO `template_panel` VALUES (22,14,'Order',0,0),(23,14,'Customer',1,0),(24,14,'Products',1,1),(25,16,'Data',0,0),(26,16,'Media',1,0),(29,17,'Νέο Panel',0,0),(30,17,'Νέο Panel',1,0),(35,18,'Main Data',0,0),(36,18,'Section1',0,1),(37,18,'Section2',1,0),(38,18,'Section3',1,1),(43,1,'Στοιχεία ιστότοπου',0,0),(44,1,'Social',0,1),(45,1,'Στοιχεία Επικοινωνίας',1,0),(46,1,'Descr',1,1);

--
-- Table structure for table `template_relation`
--

CREATE TABLE `template_relation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `table_s` varchar(65) NOT NULL COMMENT 'Source table.',
  `table_t` varchar(65) NOT NULL COMMENT 'Target table.',
  `id_s` int NOT NULL COMMENT 'id in source table.',
  `id_t` int NOT NULL COMMENT 'id in target table.',
  `field` varchar(65) NOT NULL COMMENT 'Field name (a.k.a. column name) in Source table.',
  PRIMARY KEY (`id`),
  KEY `all` (`table_s`,`table_t`,`id_s`,`id_t`,`field`)
) ENGINE=InnoDB AUTO_INCREMENT=2105 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `template_relation`
--

INSERT INTO `template_relation` VALUES (2104,'t_colabs','t_colabcats',34,0,'category'),(2099,'t_orders','t_porders',19,49,'products'),(2100,'t_orders','t_porders',19,50,'products'),(2101,'t_orders','t_porders',19,51,'products'),(2102,'t_orders','t_porders',19,52,'products'),(2103,'t_orders','t_porders',19,53,'products');

--
-- Table structure for table `testpaypal`
--

CREATE TABLE `testpaypal` (
  `id` int NOT NULL,
  `mytext` longtext,
  `mytext2` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `testpaypal`
--

INSERT INTO `testpaypal` VALUES (0,'7sUxccKbef','discount=0.00&insurance_amount=0.00&payer_id=9MR7HV8XTR5LS&address_country_code=GR&ipn_track_id=f809532b277d3&address_zip=115+24&charset=windows-1253&payment_gross=&address_status=confirmed&shipping_discount=0.00&address_street=%C5%F5%F3%F4%E1%E8%DF%EF%F5+30&verify_sign=ASOA0bZOl5StZH6-qcrRLDnprpCjA0XWX6zSMCKffx-wlZOyL2aMCEm6&item_name=7sUxccKbef&txn_type=web_accept&receiver_id=H8NJXWQY9EWYN&payment_fee=&mc_currency=EUR&transaction_subject=&shipping_method=Default&custom=&protection_eligibility=Eligible&address_country=Greece&payer_status=verified&first_name=IOANNIS&address_name=IOANNIS+CHARCHAROS&mc_gross=1.00&payment_date=00%3A19%3A34+Jun+29%2C+2023+PDT&payment_status=Completed&quantity=1&business=fingertriptravel%40gmail.com&item_number=&last_name=CHARCHAROS&address_state=&txn_id=8J707016SV497232U&mc_fee=0.38&resend=true&payment_type=instant&notify_version=3.9&payer_email=jcharcharos%40gmail.com&receiver_email=fingertriptravel%40gmail.com&address_city=%C1%E8%DE%ED%E1&residence_country=GR'),(1,'7sUxccKbef','discount=0.00&insurance_amount=0.00&payer_id=9MR7HV8XTR5LS&address_country_code=GR&ipn_track_id=f809532b277d3&address_zip=115+24&charset=windows-1253&payment_gross=&address_status=confirmed&shipping_discount=0.00&address_street=%C5%F5%F3%F4%E1%E8%DF%EF%F5+30&verify_sign=AvH6o3ObGlY5.uMIYdC-cptHWrKUAOGdeVIpZgRq05sOkdVaPPOHFNn0&item_name=7sUxccKbef&txn_type=web_accept&receiver_id=H8NJXWQY9EWYN&payment_fee=&mc_currency=EUR&transaction_subject=&shipping_method=Default&custom=&protection_eligibility=Eligible&address_country=Greece&payer_status=verified&first_name=IOANNIS&address_name=IOANNIS+CHARCHAROS&mc_gross=1.00&payment_date=00%3A19%3A34+Jun+29%2C+2023+PDT&payment_status=Completed&quantity=1&business=fingertriptravel%40gmail.com&item_number=&last_name=CHARCHAROS&address_state=&txn_id=8J707016SV497232U&mc_fee=0.38&resend=true&payment_type=instant&notify_version=3.9&payer_email=jcharcharos%40gmail.com&receiver_email=fingertriptravel%40gmail.com&address_city=%C1%E8%DE%ED%E1&residence_country=GR');

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(512) NOT NULL,
  `access_sites` varchar(512) NOT NULL,
  `menu` varchar(512) NOT NULL,
  `menu_items` varchar(512) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (1,'SuperAdmin','1,0','',''),(2,'Admin','1','','');


