Add PRIMARY KEY support

[Bardin08]

Description

Implement PRIMARY KEY support at the parser's side and the schema builder.

PRIMARY KEY can be found in a couple of positions.

-- Valid PRIMARY KEY Definitions

-- 1: Definition as a column constraint
CREATE TABLE users
(
    id         INT AUTO_INCREMENT PRIMARY KEY,
    name       VARCHAR(122) NOT NULL UNIQUE,
    profile_id INT
);

-- 2: Definition as a PRIMARY KEY attribute
CREATE TABLE users
(
    id         INT AUTO_INCREMENT,
    name       VARCHAR(122) NOT NULL UNIQUE,
    profile_id INT,
    PRIMARY KEY (id)
);

-- 3: Definition as a CONSTRAINT attribute
CREATE TABLE users
(
    id         INT AUTO_INCREMENT,
    name       VARCHAR(122) NOT NULL UNIQUE,
    profile_id INT,
    CONSTRAINT PR_User PRIMARY KEY (id)
);

ACC:

• Simple PRIMARY KEY definitions
  • 1: Definition as a column constraint
  • 2: Definition as a PRIMARY KEY attribute
  • 3: Definition as a CONSTRAINT attribute