core-schema-mysql
v1.0.0
Published
Once defined table in core-schema format
Downloads
4
Readme
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)