-- MariaDB dump 10.19-11.4.0-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: extcalendar_mamcal -- ------------------------------------------------------ -- Server version 11.4.0-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `mamcal_categories` -- DROP TABLE IF EXISTS `mamcal_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_categories` ( `cat_id` int(11) NOT NULL AUTO_INCREMENT, `cat_parent` int(11) NOT NULL DEFAULT 0, `cat_name` varchar(150) NOT NULL DEFAULT '', `description` text NOT NULL, `color` varchar(10) DEFAULT '#000000', `bgcolor` varchar(10) DEFAULT '#EEF0F0', `options` tinyint(4) DEFAULT 0, `enabled` tinyint(4) DEFAULT 0, PRIMARY KEY (`cat_id`), UNIQUE KEY `cat_id` (`cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table for event categories'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_categories` -- LOCK TABLES `mamcal_categories` WRITE; /*!40000 ALTER TABLE `mamcal_categories` DISABLE KEYS */; INSERT INTO `mamcal_categories` VALUES (1,0,'General','This is the default category','#000000','#EEF0F0',0,1); /*!40000 ALTER TABLE `mamcal_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_config` -- DROP TABLE IF EXISTS `mamcal_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_config` ( `name` varchar(40) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table for configurable parameters'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_config` -- LOCK TABLES `mamcal_config` WRITE; /*!40000 ALTER TABLE `mamcal_config` DISABLE KEYS */; INSERT INTO `mamcal_config` VALUES ('allowed_file_extensions','GIF/PNG/JPG/JPEG'), ('max_upl_size','20000'), ('cookie_name','ext20'), ('cookie_path','/'), ('debug_mode','0'), ('events_per_page','10'), ('calendar_name','mamCAL'), ('calendar_admin_email','mam@heimam.at'), ('calendar_description','mam\'s online calendar'), ('lang','english'), ('charset','language-file'), ('main_table_width','650'), ('max_tabs','12'), ('theme','default'), ('time_format_24hours','1'), ('auto_daylight_saving','1'), ('default_view','2'), ('popup_event_mode','0'), ('popup_event_width','550'), ('popup_event_height','300'), ('add_event_view','1'), ('cats_view','1'), ('daily_view','1'), ('weekly_view','1'), ('monthly_view','1'), ('flyer_view','1'), ('search_view','1'), ('day_start','1'), ('archive','1'), ('flyer_show_picture','1'), ('addevent_allow_html','0'), ('addevent_allow_contact','1'), ('addevent_allow_email','1'), ('addevent_allow_url','1'), ('addevent_allow_picture','1'), ('new_post_notification','1'), ('cal_view_max_chars','100'), ('flyer_view_max_chars','100'), ('weekly_view_max_chars','100'), ('daily_view_max_chars','100'), ('cats_view_max_chars','100'), ('mini_cal_def_picture','def_pic.gif'), ('mini_cal_diplay_options','default'), ('release_name','2.0 Beta 2'), ('release_version','200.26'), ('release_type','beta'), ('sort_order','ta'), ('picture_chmod','0644'), ('max_upl_dim','450'), ('allow_user_registration','1'), ('reg_email_verify','1'), ('reg_duplicate_emails','0'), ('calendar_status','1'), ('show_recurrent_events','1'), ('multi_day_events','all'), ('cal_view_show_week','1'), ('mail_method','mail'), ('mail_smtp_host','mgate.telekabel.at'), ('mail_smtp_auth','0'), ('mail_smtp_username',''), ('mail_smtp_password',''), ('legend_cat_columns','4'), ('timezone','1'); /*!40000 ALTER TABLE `mamcal_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_events` -- DROP TABLE IF EXISTS `mamcal_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '', `description` text NOT NULL, `contact` text NOT NULL, `url` varchar(100) NOT NULL DEFAULT '', `email` varchar(120) NOT NULL DEFAULT '', `picture` varchar(100) NOT NULL DEFAULT '', `cat` tinyint(2) NOT NULL DEFAULT 0, `day` tinyint(2) NOT NULL DEFAULT 0, `month` smallint(2) NOT NULL DEFAULT 0, `year` smallint(4) NOT NULL DEFAULT 0, `approved` tinyint(1) NOT NULL DEFAULT 0, `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_date` datetime DEFAULT '0000-00-00 00:00:00', `recur_type` varchar(16) DEFAULT NULL, `recur_val` tinyint(4) DEFAULT 0, `recur_end_type` tinyint(1) unsigned NOT NULL DEFAULT 0, `recur_count` tinyint(3) unsigned NOT NULL DEFAULT 0, `recur_until` date DEFAULT '0000-00-00', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `start_date` (`start_date`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table holding events and their attributes'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_events` -- LOCK TABLES `mamcal_events` WRITE; /*!40000 ALTER TABLE `mamcal_events` DISABLE KEYS */; INSERT INTO `mamcal_events` VALUES (1,'ExtCalendar Installed','Congratulations! ExtCalendar is installed and ready to kick !','','','','',1,5,6,2006,1,'2006-06-05 18:13:13','2006-06-05 18:13:13',NULL,0,0,0,'0000-00-00'); /*!40000 ALTER TABLE `mamcal_events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_groups` -- DROP TABLE IF EXISTS `mamcal_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_groups` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `has_admin_access` tinyint(1) NOT NULL DEFAULT 0, `can_manage_accounts` tinyint(1) NOT NULL DEFAULT 0, `can_change_settings` tinyint(1) NOT NULL DEFAULT 0, `can_manage_cats` tinyint(1) NOT NULL DEFAULT 0, `upl_need_approval` tinyint(1) NOT NULL DEFAULT 1, `locked` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table holding user groups'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_groups` -- LOCK TABLES `mamcal_groups` WRITE; /*!40000 ALTER TABLE `mamcal_groups` DISABLE KEYS */; INSERT INTO `mamcal_groups` VALUES (1,'Administrators','Members of this group have the absolute power.',1,1,1,1,0,1), (2,'Moderators','Moderators can manage content of the calendar',1,0,0,1,0,0), (3,'Anonymous','Group of anonymous users',0,0,0,0,1,1), (4,'Banned','The damned group.',0,0,0,0,1,1); /*!40000 ALTER TABLE `mamcal_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_plugins` -- DROP TABLE IF EXISTS `mamcal_plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_plugins` ( `plugin_id` int(11) NOT NULL AUTO_INCREMENT, `plugin_name` varchar(64) NOT NULL DEFAULT '', `plugin_priority` tinyint(2) unsigned NOT NULL DEFAULT 50, `plugin_path` varchar(255) DEFAULT NULL, PRIMARY KEY (`plugin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table holding installed plugins'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_plugins` -- LOCK TABLES `mamcal_plugins` WRITE; /*!40000 ALTER TABLE `mamcal_plugins` DISABLE KEYS */; /*!40000 ALTER TABLE `mamcal_plugins` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_templates` -- DROP TABLE IF EXISTS `mamcal_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_templates` ( `template_id` int(11) NOT NULL AUTO_INCREMENT, `template_type` varchar(16) NOT NULL DEFAULT '', `template_description` varchar(255) DEFAULT NULL, `template_status` tinyint(1) NOT NULL DEFAULT 0, `template_value` text DEFAULT NULL, `last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`template_id`), UNIQUE KEY `template_type` (`template_type`), KEY `template_status` (`template_status`), FULLTEXT KEY `template_value` (`template_value`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table for custom interface template'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_templates` -- LOCK TABLES `mamcal_templates` WRITE; /*!40000 ALTER TABLE `mamcal_templates` DISABLE KEYS */; INSERT INTO `mamcal_templates` VALUES (1,'header','Custom header structure to display on top',0,'\r\n
\r\n
{CAL_NAME}
\r\n
{CAL_DESCRIPTION}
\r\n
\r\n {ADMIN_MENU}\r\n
\r\n {MAIN_MENU} \r\n
\r\n
\r\r\n\r\n\n','2006-06-05 20:13:13'), (2,'footer','Custom footer structure to display at the bottom',0,'
\r\n
\r\n','2006-06-05 20:13:13'), (3,'meta','Space to hold meta tags and other browser related information',1,'','2006-06-05 20:13:13'); /*!40000 ALTER TABLE `mamcal_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamcal_users` -- DROP TABLE IF EXISTS `mamcal_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamcal_users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(30) NOT NULL DEFAULT '', `password` varchar(64) NOT NULL DEFAULT '', `firstname` varchar(64) DEFAULT '', `lastname` varchar(64) DEFAULT '', `group_id` int(11) NOT NULL DEFAULT 2, `lastvisit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `email` varchar(255) NOT NULL DEFAULT '', `user_regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user_lang` varchar(255) NOT NULL DEFAULT '', `user_website` varchar(255) NOT NULL DEFAULT '', `user_location` varchar(255) NOT NULL DEFAULT '', `user_occupation` varchar(255) NOT NULL DEFAULT '', `reg_key` varchar(64) DEFAULT NULL, `user_status` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Table for calendar users'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamcal_users` -- LOCK TABLES `mamcal_users` WRITE; /*!40000 ALTER TABLE `mamcal_users` DISABLE KEYS */; INSERT INTO `mamcal_users` VALUES (1,'admin','5a9361b28ee51795f1e82d9054919034','Mr.','Administrator',1,'2006-10-26 23:47:48','mam@heimam.at','2006-06-05 20:13:13','','','','',NULL,1); /*!40000 ALTER TABLE `mamcal_users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-02-04 18:40:47