erd-editor
erd-editor copied to clipboard
add: UNSIGNED numeric data types for MySQL
Hi. I found that type suggestion does not provide any unsigned
types, which gave me a little inconvenience.
I found the list of types that support unsigned
option at https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html.
Hi. I found that type suggestion does not provide any
unsigned
types, which gave me a little inconvenience.I found the list of types that support
unsigned
option at https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html.
To add a type to autocomplete, a list is added from the following file.
- https://github.com/vuerd/vuerd/blob/master/packages/vuerd/src/core/sql/dataType/MySQL.ts
Sorry, it seems that unsigned
keyword is an attribute, not a type.
Would it be okay to add it to PrimitiveType
like..
export type PrimitiveType =
| 'int'
| 'int unsigned'
...
or add another field to DataTypeHint
like below?
export interface DataTypeHint {
name: string;
primitiveType: PrimitiveType;
unsigned: boolean;
}
Since this type is for cordegenerate mapping purposes, there is no need to divide it in detail.
I don't need it right now, so I think I can use the int