CREATE DATABASE  IF NOT EXISTS `bitnami_redmine` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `bitnami_redmine`;
-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: bitnami_redmine
-- ------------------------------------------------------
-- Server version	5.7.32-log

/*!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 `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` text,
  `updated_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_settings_on_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'activity_days_default','30','2011-12-19 02:30:20'),(2,'diff_max_lines_displayed','1500','2011-12-19 02:30:20'),(3,'app_title','OpenOpcUa','2011-12-19 02:30:20'),(4,'attachment_max_size','100000','2015-04-01 13:37:57'),(5,'host_name','www.openopcua.org/redmine','2020-12-21 11:28:24'),(6,'repositories_encodings','','2011-12-19 02:30:20'),(7,'wiki_compression','','2011-12-19 02:30:20'),(8,'protocol','https','2021-01-02 00:09:19'),(9,'file_max_size_displayed','512','2011-12-19 02:30:20'),(10,'text_formatting','textile','2011-12-19 02:30:20'),(11,'feeds_limit','15','2011-12-19 02:30:20'),(12,'per_page_options','25,50,100','2011-12-19 02:30:20'),(13,'cache_formatted_text','0','2011-12-19 02:30:20'),(14,'welcome_text','*Bienvenue le portail collaboratif du projet OpenOpcUa.*\r\nPour l\'accès au code source nous vous conseillons :\r\n* Sous Windows http://ankhsvn.open.collab.net/ ou  http://tortoisesvn.net/\r\n* Sous Linux http://tortoisesvn.net/\r\n\r\n*Welcome on the OpenOpcUa project forge*\r\nTo access the source we advice you \r\n* Using Windows http://ankhsvn.open.collab.net/ ou  http://tortoisesvn.net/\r\n* Using Linux http://tortoisesvn.net/','2012-01-18 18:39:17'),(15,'time_format','','2012-01-07 01:22:45'),(16,'ui_theme','classic','2020-12-20 23:53:08'),(17,'default_language','en','2012-01-11 08:48:48'),(18,'start_of_week','1','2012-01-07 01:22:45'),(19,'gravatar_default','wavatar','2012-01-07 01:22:45'),(20,'date_format','','2012-01-07 01:22:45'),(21,'user_format','firstname_lastname','2012-01-07 01:22:45'),(22,'gravatar_enabled','1','2012-01-07 01:22:45'),(23,'self_registration','1','2012-01-07 01:23:16'),(24,'openid','0','2012-01-07 01:23:16'),(25,'autologin','1','2020-12-20 02:32:26'),(26,'rest_api_enabled','0','2020-12-03 17:37:10'),(27,'password_min_length','8','2017-06-20 09:25:47'),(28,'lost_password','1','2012-01-07 01:23:16'),(29,'login_required','1','2020-12-20 03:28:33'),(30,'new_project_user_role_id','3','2012-01-07 01:23:36'),(31,'default_projects_public','0','2020-07-26 13:40:50'),(32,'sequential_project_identifiers','0','2012-01-07 01:23:36'),(33,'default_projects_modules','--- \n- issue_tracking\n- time_tracking\n- news\n- documents\n- files\n- wiki\n- repository\n- boards\n- calendar\n- gantt\n','2012-01-07 01:23:36'),(34,'issue_group_assignment','1','2012-01-07 01:24:03'),(35,'default_issue_start_date_to_creation_date','1','2012-01-07 01:24:03'),(36,'issues_export_limit','500','2012-01-07 01:24:03'),(37,'issue_list_default_columns','--- \n- tracker\n- status\n- priority\n- subject\n- assigned_to\n- updated_on\n- due_date\n- done_ratio\n','2012-01-07 01:24:03'),(38,'gantt_items_limit','500','2012-01-07 01:24:03'),(39,'issue_done_ratio','issue_field','2012-01-07 01:24:03'),(40,'display_subprojects_issues','1','2012-01-07 01:24:03'),(41,'cross_project_issue_relations','1','2012-01-07 01:24:03'),(42,'default_notification_option','all','2012-01-13 17:48:30'),(43,'mail_from','michel@openopcua.org','2020-07-25 20:49:50'),(44,'bcc_recipients','1','2012-01-07 01:26:27'),(45,'emails_header','','2012-01-07 01:26:27'),(46,'notified_events','--- \n- issue_added\n- issue_updated\n- issue_note_added\n- issue_status_updated\n- issue_priority_updated\n- news_added\n- news_comment_added\n- document_added\n- file_added\n- message_posted\n- wiki_content_added\n- wiki_content_updated\n','2012-01-07 01:26:27'),(47,'plain_text_mail','0','2012-01-07 01:26:27'),(48,'emails_footer','You have received this notification because you have either subscribed to it, or are involved in it.\r\nTo change your notification preferences, please click here: http://www.OpenOpcUa.org/redmine/my/account','2014-03-22 02:28:49'),(49,'repository_log_display_limit','100','2012-01-07 01:27:10'),(50,'commit_logtime_enabled','1','2012-01-07 01:27:10'),(52,'autofetch_changesets','1','2012-01-07 01:27:10'),(54,'enabled_scm','--- \n- Subversion\n- Filesystem\n','2020-07-26 13:34:57'),(55,'sys_api_enabled','1','2012-01-11 08:44:14'),(56,'commit_ref_keywords','refs,references,IssueID','2012-01-07 01:27:10'),(58,'commit_logtime_activity_id','0','2012-01-10 01:34:16'),(59,'sys_api_key','','2012-01-12 17:09:09'),(60,'commit_update_keywords','---\n- keywords: fixes,closes\n  status_id: \'1\'\n  done_ratio: \'100\'\n','2020-11-25 21:01:47'),(61,'jsonp_enabled','0','2020-12-03 16:10:57'),(62,'show_custom_fields_on_registration','1','2020-12-03 16:13:39'),(63,'password_required_char_classes','--- []\n','2020-12-03 16:13:39'),(64,'password_max_age','0','2020-12-03 16:13:39'),(65,'session_lifetime','480','2020-12-03 16:13:39'),(66,'session_timeout','240','2020-12-03 16:13:39'),(67,'search_results_per_page','10','2020-12-20 11:28:53'),(68,'force_default_language_for_anonymous','0','2020-12-20 19:28:57'),(69,'force_default_language_for_loggedin','0','2020-12-20 19:28:57'),(70,'timespan_format','decimal','2020-12-20 19:28:57'),(71,'thumbnails_enabled','1','2020-12-20 19:28:57'),(72,'thumbnails_size','100','2020-12-20 19:28:57'),(73,'new_item_menu_tab','2','2020-12-20 19:28:57'),(74,'max_additional_emails','5','2022-08-29 14:12:37'),(75,'unsubscribe','0','2022-08-29 14:12:37'),(76,'default_users_hide_mail','1','2022-08-29 14:12:37'),(77,'default_users_time_zone','Paris','2022-08-29 14:12:37');
/*!40000 ALTER TABLE `settings` 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 2023-02-19 17:26:29