core-schema-mysql v1.0.0

MySQL Schema Tools

Once defined table in core-schema format

You can use this tools to create mysql schema

Reference table difinition test/tables/*.table.json

Create Table and Indexes

core-schema-mysql create 

Preview SQL

core-schema-mysql --sql create 

create table `ITEM` (NodeId varchar(40), ItemCode nvarchar(48), ItemName nvarchar(48), Active nvarchar(1))
create table `CARD` (NodeId varchar(40), CardCode nvarchar(48), CardName nvarchar(48), Balance decimal(19,6), Active nvarchar(1), Active1 nvarchar(1))
alter table CARD add primary key(NodeId)
create unique index IDX_CARD_CODE on CARD (CardCode)
create index IDX_CARD_NAME on CARD (CardCode, CardName)