DDL Support

[KKould]

Feature Request

Function

• [ ] CURRENT_TIMESTAMP

Create Table

• [x] PRIMARY KEY (column_1, column_2, ...)
• [x] UNIQUE (column_1, column_2, ...)
• Options
  • [x] Default e.g. CREATE TABLE CUSTOMER (C_ID INTEGER DEFAULT '0' NOT NULL)

Ref: https://github.com/KipData/KipSQL/pull/103

Create Index

• [ ] CREATE UNIQUE INDEX u_index ON table(column_1, column_2, ...);
• [ ] Perf Unique Index Choose (options)

Alert Table

• [x] ALTER TABLE table ADD column_1 INTERGER; ref: https://github.com/KipData/kipsql/pull/104
• [ ] ALTER TABLE table MODIFY column_1 INTERGER;
• [ ] ALTER TABLE table CHANGE COLUMN column_1 column_2 INTERGER;
• [x] ALTER TABLE table DROP COLUMN column_1; ref: https://github.com/KipData/kipsql/pull/109
• [ ] RENAME table TO table ;

Ref:

• https://github.com/KipData/KipSQL/issues/101

Desc

• [ ] Desc Table: https://github.com/KipData/KipSQL/issues/102