[jira] [Updated] (AMBARI-15915) SQL constraints: Inline constraints and name them in CREATE table

["Balázs Bence Sári (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-15915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Balázs Bence Sári updated AMBARI-15915:
---------------------------------------
    Status: Patch Available  (was: In Progress)

- named all PK's (except quartz tables)
- inlined all constraints (except quartz tables, and one exception of circular FK dependency)
- fixed mismatching column names, missing columns and constraints (taking Postgres DDL as master)
- added unit tests to check the consistency of DDL's

> SQL constraints: Inline constraints and name them in CREATE table
> -----------------------------------------------------------------
>
>                 Key: AMBARI-15915
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15915
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.4.0
>            Reporter: Sebastian Toader
>            Assignee: Balázs Bence Sári
>             Fix For: 2.4.0
>
>
> Move ALTER TABLE statements for unique and foreign key constraints into the CREATE table statement.
> Also provide primary key constraint names where primary keys are specified.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)