Add Support for CHECK Constraints, Lakshay Arora | GSoC 2018 with phpmyadmin

Add Support for CHECK Constraints

Post 1

This feature request is divided in three parts -

  1. Implement an interface for interacting with these constraints
  2. Update parser to understand this syntax
  3. Update the export interface to allow including these in an export

Mysql does not provide any way to alter the definition of a constraint. The main idea is to add support for a constraint and additionally build a feature seperate from mysql to alter a constraint.

Iā€™m currenlty working on the interface to build, edit and drop check constraints.(The first part) Work done -

  1. Implemented UI to add a check constraint during table creation. UI to add CHECK

  2. Implemented UI to show defined constraints on a table in table structure.

Plans for this week-

  1. Finish the functionality to add/drop/alter constraints(first part).
  2. Update parser to understand syntax(second part).
Written on July 9, 2018