diff options
Diffstat (limited to 'app/Schema/Sql')
| -rw-r--r-- | app/Schema/Sql/mysql.sql | 21 | ||||
| -rw-r--r-- | app/Schema/Sql/postgres.sql | 61 |
2 files changed, 80 insertions, 2 deletions
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'); |