summaryrefslogtreecommitdiff
path: root/app/Schema
AgeCommit message (Collapse)Author
2018-10-31Fix postgres schema version + move to separate linestrendspotter
2018-10-10Update ChangeLog and MySQL dumpFrédéric Guillot
2018-10-06Escape table name 'groups' because groups is a reserved word as of MySql 8.0.2Thomas
2018-08-11Allow to associate tags to colorsJulian Maurice
The color is then used as background in the board, list and task details views
2018-08-09Allow to associate project categories to colorsJulian Maurice
The color is then used as background in the board and list views
2018-05-25Increase size of the "users.language" columnMiodrag Tokić
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-04-12Adjust field size to keep compatibility with MySQL 5.6Frédéric Guillot
2018-04-12Use utf8mb4 encoding for MySQL instead of utf8Frédéric Guillot
2018-04-11Increase text fields length in several tablesFrédéric Guillot
2018-04-02Add default filter per userAurélien
2017-12-26Update ChangeLogFrédéric Guillot
2017-12-12Store PHP sessions in the databaseFrédéric Guillot
2017-11-20Update SQL dumpsFrédéric Guillot
2017-11-02Add predefined templates for task descriptionsFrederic Guillot
2017-10-27Remove feature "Allow everybody to access to this project"Frederic Guillot
2017-06-19Improve SQL migrations when old default swimlanes have the same name as a ↵Frederic Guillot
normal swimlanes
2017-06-03Add configurable list of predefined subjects when sending a task by emailFrederic Guillot
2017-04-08Update SQL dumpsFrederic Guillot
2017-04-08Add missing migrations for Mysql and PostgresFrederic Guillot
2017-04-08Add assignee restriction for custom project roles (dnd)Frederic Guillot
2017-03-29Merge pull request #3164Frédéric Guillot
update to sqlite schema - fixing existing table
2017-03-29update to sqlite schema - fixing existing tablepalica
table project_activities contains a typo in schema, this corrects the typo on existing installations
2017-03-29fix typo in project_activities migrationpalica
2017-02-23Make sure the default swimlane name is not empty before to run migrationFrederic Guillot
2017-02-20Fix compatibility issue with Mysql migrationFrederic Guillot
2017-02-20Update SQL dumpsFrederic Guillot
2017-02-18Remove default swimlaneFrederic Guillot
2017-02-12Update SQL dumpsFrederic Guillot
2017-02-04Add email address field for projectsFrederic Guillot
2017-01-28Update SQL exportsFrederic Guillot
2017-01-22Add user invitationsFrederic Guillot
2017-01-22Fix typos in PR #2950Frederic Guillot
2017-01-22Add date_modification to comments (PR #2950)Lev Lazinskiy
2017-01-15Fix Kanboard installation errors on MySQL 8.0.0Volodymyr Kushnir
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.
2016-12-04Remove incompatible option in SQL dump for Postgrs 9.5Frederic Guillot
2016-12-03Add personal API access tokenFrederic Guillot
2016-12-02Update SQL dumpsFrederic Guillot
2016-12-02Fix field too small for application settingsFrederic Guillot
2016-11-05Add the possibility to create external tasksFrederic Guillot
2016-09-18Add column restrictions to custom project rolesFrederic Guillot
2016-09-11Add missing primary key in Mysql schemaFrederic Guillot
2016-09-11Add project restrictions for custom rolesFrederic Guillot
2016-09-07Add new models ColumnMoveRestrictionModel and ProjectRoleModelFrederic Guillot
2016-07-12Make sure that the table schema_version use InnoDB for MysqlFrederic Guillot
2016-07-09Fix a couple of bugs in PR #2424Frederic Guillot
2016-07-05Hide tasks within specific columns in dashboard (#2424)Busfreak
2016-06-28Update SQL schema dumpsFrederic Guillot
2016-06-23Added models for tagsFrederic Guillot
2016-05-22Improve Postgres SQL dumpFrederic Guillot
2016-03-27Update SQL dumps and improve schema migration processFrederic Guillot