e7fcf07c92
Fix SQL Server migration
2023-05-18 20:51:51 -07:00
aade89c9ba
Add Themes: Dark, light and automatic mode
2023-05-14 21:14:35 -07:00
33852e9ea0
feature: add Microsoft SQL Server database support
...
can be used via the pdo_dblib or pdo_odbc extensions.
requires Microsoft SQL Server 2016 or later.
* add schema/migrations
* add database provider
* add setup check for pdo module needed by selected driver (dblib/odbc)
* add default config doc
2022-10-29 21:11:15 -07:00
178e2eaf63
Fix `General error: 1 no such table: main.task_has_subtasks`
...
See: https://kanboard.discourse.group/t/error-no-such-table-main-task-has-subtasks/1664/15
> The `subtask_time_tracking table` has a wrong foreign key constraint. The constraints references the no-longer-existing table `task_has_subtasks`.
2022-03-17 18:10:52 -07:00
ae072d5fcf
Fix tasks.swimlane_id foreign key for sqlite
2020-10-25 17:40:39 -07:00
67a5dd6a89
Add option to enable or disable global tags per projects
2020-04-04 11:39:17 -07:00
c8a617cfcb
Add per-project and per-swimlane task limits
...
This change allows projects and swimlanes to be configured with task limits that apply to their whole scope (i.e. all active tasks in a project or swimlane, respectively), as opposed to the usual per-column task limits.
2020-02-25 20:26:31 -08:00
e59ab08af3
Allow task limits to be applied per-swimlane
2020-02-04 20:16:35 -08:00
35602c0880
Change string indexing from {0} to [0] (deprecated in PHP 7.4)
2019-11-09 11:46:53 -08:00
42694ac2af
Fix postgres schema usage
2019-02-28 18:23:35 -08:00
46e3dd66c6
Fix MySQL migration when using increment values different from 1
...
Fixes #4137
2019-02-15 17:39:03 -08:00
f070ad87d6
Update SQL dumps
2018-12-19 16:01:50 -08:00
7c2e0f7780
Fix postgres schema version + move to separate lines
2018-10-31 18:29:21 -07:00
00228ac12f
Update ChangeLog and MySQL dump
2018-10-10 20:17:19 -07:00
e650ed5814
Escape table name 'groups' because groups is a reserved word as of MySql 8.0.2
2018-10-06 13:06:13 -07:00
9d4cd31e1a
Allow to associate tags to colors
...
The color is then used as background in the board, list and task details
views
2018-08-11 10:15:13 +02:00
ae3ade0908
Allow to associate project categories to colors
...
The color is then used as background in the board and list views
2018-08-09 19:45:51 +02:00
ba0455d8e4
Increase size of the "users.language" column
...
The current schema definition for the language column in the users table
is limited to 5 characters, while the longest currently available
language code in Kanboard is 10 characters long - sr_Latn_RS. This
limitation prevents switching to Serbian as the application interface
language.
As per the currently available ISO 639 language codes this column should
be at least 11 characters in size. Examples of language codes of 11
characters in size are en-US-POSIX and shi_Latn_MA.
References:
- http://www.localeplanet.com/icu/iso639.html
2018-05-25 01:07:35 -07:00
0e8a94ac42
Adjust field size to keep compatibility with MySQL 5.6
2018-04-12 15:39:55 -07:00
d8c625c856
Use utf8mb4 encoding for MySQL instead of utf8
2018-04-12 13:41:32 -07:00
dd92564d22
Increase text fields length in several tables
2018-04-11 13:48:13 -07:00
5f7a3442d6
Add default filter per user
2018-04-02 14:07:04 -07:00
9cec52f76b
Update ChangeLog
2017-12-26 18:00:19 -08:00
ccd177ada6
Store PHP sessions in the database
2017-12-12 15:04:28 -08:00
e2eec8b7e7
Update SQL dumps
2017-11-20 11:22:54 -08:00
648dc6bcfb
Add predefined templates for task descriptions
2017-11-02 15:41:58 -07:00
cc6618901b
Remove feature "Allow everybody to access to this project"
2017-10-27 16:16:11 -07:00
418f5522a2
Improve SQL migrations when old default swimlanes have the same name as a normal swimlanes
2017-06-19 21:54:12 -04:00
dd8d7ef49d
Add configurable list of predefined subjects when sending a task by email
2017-06-03 17:31:32 -04:00
22cfbd9e56
Update SQL dumps
2017-04-08 17:52:41 -04:00
0f4b5d9562
Add missing migrations for Mysql and Postgres
2017-04-08 15:54:26 -04:00
fe9f3ba707
Add assignee restriction for custom project roles (dnd)
2017-04-08 11:18:58 -04:00
99015d08fa
Merge pull request #3164
...
update to sqlite schema - fixing existing table
2017-03-29 22:44:11 -04:00
b4c6b2ff99
update to sqlite schema - fixing existing table
...
table project_activities contains a typo in schema, this corrects the typo on existing installations
2017-03-29 08:53:23 +02:00
4618594f73
fix typo in project_activities migration
2017-03-29 08:29:32 +02:00
73b2f51fe5
Make sure the default swimlane name is not empty before to run migration
2017-02-23 18:18:00 -05:00
3d7a682ec7
Fix compatibility issue with Mysql migration
2017-02-20 22:30:01 -05:00
63a460724d
Update SQL dumps
2017-02-20 22:11:15 -05:00
de128dbad8
Remove default swimlane
2017-02-18 09:42:01 -05:00
d58b35fe86
Update SQL dumps
2017-02-12 13:42:34 -05:00
d5c4c18ea0
Add email address field for projects
2017-02-04 16:03:29 -05:00
c185d24156
Update SQL exports
2017-01-28 11:37:43 -05:00
10d96bfd66
Add user invitations
2017-01-22 22:38:00 -05:00
b906b91733
Fix typos in PR #2950
2017-01-22 12:40:53 -05:00
8e18c39db9
Add date_modification to comments (PR #2950 )
2017-01-22 12:39:30 -05:00
0ad1779435
Fix Kanboard installation errors on MySQL 8.0.0
...
This is a quick and dirty fix for "Internal Error: Unable to run SQL migrations: Running migration \Schema\version_113, SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'role VARCHAR(255) NOT NULL,".
As per https://dev.mysql.com/doc/refman/8.0/en/keywords.html **role** is a reserved keyword in MySQL 8.0.0.
2017-01-15 17:54:53 +02:00
7719703dce
Remove incompatible option in SQL dump for Postgrs 9.5
2016-12-04 13:08:29 -05:00
b8f7532e5c
Add personal API access token
2016-12-03 15:43:36 -05:00
c1f05371bc
Update SQL dumps
2016-12-02 20:55:20 -05:00
faef2e85d1
Fix field too small for application settings
2016-12-02 20:49:30 -05:00
Frédéric Guillot
Joe Nahmias
emojized
Igor
Timo
Andre Nathan
Lőrinczy, Zsigmond
trendspotter
Psy-Q
Thomas
Julian Maurice
Miodrag Tokić
Aurélien
palica
Lev Lazinskiy
Volodymyr Kushnir