-- MySQL dump 10.13 Distrib 5.6.25, for Win32 (x86) -- -- Host: localhost Database: extcalendar_mamcal -- ------------------------------------------------------ -- Server version 5.6.36 /*!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 utf8 */; /*!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 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 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 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 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 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, `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 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 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-01 2:00:06