Add sql dump of settings table

3 files changed, 83 insertions, 2 deletions

diff --git a/Makefile b/Makefile
index 7a656ea9..e56458e9 100644
--- a/Makefile
+++ b/Makefile
@@ -90,7 +90,10 @@ unittest: test-sqlite test-mysql test-postgres
 
 sql:
 	@ pg_dump --schema-only --no-owner --file app/Schema/Sql/postgres.sql kanboard
+	@ pg_dump -d kanboard --column-inserts --data-only --table settings >> app/Schema/Sql/postgres.sql
+
 	@ mysqldump -uroot --quote-names --no-create-db --skip-comments --no-data --single-transaction kanboard | sed 's/ AUTO_INCREMENT=[0-9]*//g' > app/Schema/Sql/mysql.sql
+	@ mysqldump -uroot --quote-names --no-create-info --skip-comments --no-set-names kanboard settings >> app/Schema/Sql/mysql.sql
 
 	@ php -r "echo 'INSERT INTO users (username, password, is_admin) VALUES (\'admin\', \''.password_hash('admin', PASSWORD_DEFAULT).'\', \'1\');';" | \
 	tee -a app/Schema/Sql/postgres.sql app/Schema/Sql/mysql.sql >/dev/null
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index a4e0a7ff..c335a16f 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -521,4 +521,23 @@ CREATE TABLE `users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
-INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$BBxt.HuQCFur7qhICY22i.A6OKyce0KGqmMEWq3JdGT4WcEKCBWP.', '1');INSERT INTO schema_version VALUES ('90');
+/*!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 */;
+
+LOCK TABLES `settings` WRITE;
+/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
+INSERT INTO `settings` VALUES ('api_token','37d92e3bc7e2ede57948401870a1ab70d59265930853fd65954ca22a09ed'),('application_currency','USD'),('application_date_format','m/d/Y'),('application_language','en_US'),('application_stylesheet',''),('application_timezone','UTC'),('application_url',''),('board_columns',''),('board_highlight_period','172800'),('board_private_refresh_interval','10'),('board_public_refresh_interval','60'),('calendar_project_tasks','date_started'),('calendar_user_subtasks_time_tracking','0'),('calendar_user_tasks','date_started'),('cfd_include_closed_tasks','1'),('default_color','yellow'),('integration_gravatar','0'),('integration_hipchat','0'),('integration_hipchat_api_url','https://api.hipchat.com'),('integration_hipchat_room_id',''),('integration_hipchat_room_token',''),('integration_jabber','0'),('integration_jabber_domain',''),('integration_jabber_nickname','kanboard'),('integration_jabber_password',''),('integration_jabber_room',''),('integration_jabber_server',''),('integration_jabber_username',''),('integration_slack_webhook','0'),('integration_slack_webhook_channel',''),('integration_slack_webhook_url',''),('project_categories',''),('subtask_restriction','0'),('subtask_time_tracking','1'),('webhook_token','4f0986fa4a12fab97e0f54615c40a87e74a1e0ac65a8486b0710b5ff6a8d'),('webhook_url','');
+/*!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 */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$ORQCf1YIxrkMyA9V1cphcOVZKckWumuZXig9hsk5I6EH1p1Z1pHsO', '1');INSERT INTO schema_version VALUES ('90');
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index e686e8d2..42fbe484 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -1840,4 +1840,63 @@ GRANT ALL ON SCHEMA public TO PUBLIC;
 -- PostgreSQL database dump complete
 --
 
-INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$BBxt.HuQCFur7qhICY22i.A6OKyce0KGqmMEWq3JdGT4WcEKCBWP.', '1');INSERT INTO schema_version VALUES ('70');
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+INSERT INTO settings (option, value) VALUES ('board_highlight_period', '172800');
+INSERT INTO settings (option, value) VALUES ('board_public_refresh_interval', '60');
+INSERT INTO settings (option, value) VALUES ('board_private_refresh_interval', '10');
+INSERT INTO settings (option, value) VALUES ('board_columns', '');
+INSERT INTO settings (option, value) VALUES ('webhook_token', '94aa75d5d88c8e7084721c3a1c97c06630f494a31741f8cf3b6d9eadf6a1');
+INSERT INTO settings (option, value) VALUES ('api_token', '3f0a1683800e9104b6e8ec15cb254738eebf24028f2169546e17fa2a3801');
+INSERT INTO settings (option, value) VALUES ('application_language', 'en_US');
+INSERT INTO settings (option, value) VALUES ('application_timezone', 'UTC');
+INSERT INTO settings (option, value) VALUES ('application_url', '');
+INSERT INTO settings (option, value) VALUES ('application_date_format', 'm/d/Y');
+INSERT INTO settings (option, value) VALUES ('project_categories', '');
+INSERT INTO settings (option, value) VALUES ('subtask_restriction', '0');
+INSERT INTO settings (option, value) VALUES ('application_stylesheet', '');
+INSERT INTO settings (option, value) VALUES ('application_currency', 'USD');
+INSERT INTO settings (option, value) VALUES ('integration_slack_webhook', '0');
+INSERT INTO settings (option, value) VALUES ('integration_slack_webhook_url', '');
+INSERT INTO settings (option, value) VALUES ('integration_hipchat', '0');
+INSERT INTO settings (option, value) VALUES ('integration_hipchat_api_url', 'https://api.hipchat.com');
+INSERT INTO settings (option, value) VALUES ('integration_hipchat_room_id', '');
+INSERT INTO settings (option, value) VALUES ('integration_hipchat_room_token', '');
+INSERT INTO settings (option, value) VALUES ('integration_gravatar', '0');
+INSERT INTO settings (option, value) VALUES ('integration_jabber', '0');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_server', '');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_domain', '');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_username', '');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_password', '');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_nickname', 'kanboard');
+INSERT INTO settings (option, value) VALUES ('integration_jabber_room', '');
+INSERT INTO settings (option, value) VALUES ('calendar_user_subtasks_time_tracking', '0');
+INSERT INTO settings (option, value) VALUES ('calendar_user_tasks', 'date_started');
+INSERT INTO settings (option, value) VALUES ('calendar_project_tasks', 'date_started');
+INSERT INTO settings (option, value) VALUES ('webhook_url', '');
+INSERT INTO settings (option, value) VALUES ('integration_slack_webhook_channel', '');
+INSERT INTO settings (option, value) VALUES ('default_color', 'yellow');
+INSERT INTO settings (option, value) VALUES ('subtask_time_tracking', '1');
+INSERT INTO settings (option, value) VALUES ('cfd_include_closed_tasks', '1');
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$ORQCf1YIxrkMyA9V1cphcOVZKckWumuZXig9hsk5I6EH1p1Z1pHsO', '1');INSERT INTO schema_version VALUES ('70');