search

drawdb-io / drawdb

Free, simple, and intuitive online database design tool and SQL generator.
https://drawdb.vercel.app
MIT License
12.09k stars 855 forks source link

[suggestion]Comment in export sql #78

Open changeAtLater opened 2 months ago

changeAtLater commented 2 months ago

now:

/* user table */
CREATE TABLE `table_user` (
    `user_id` BIGINT NOT NULL AUTO_INCREMENT UNIQUE,
    -- userName
    `user_name` VARCHAR(255),
    `dept_id` BIGINT,
    PRIMARY KEY(`user_id`)
);

expect:

CREATE TABLE `table_user` (
    `user_id` BIGINT NOT NULL AUTO_INCREMENT UNIQUE,
    `user_name` VARCHAR(255) comment 'userName',
    `dept_id` BIGINT,
    PRIMARY KEY(`user_id`)
) comment 'user table';
1ilit commented 1 month ago

There's a PR for this that I'll merge some time this week

jackman0925 commented 2 weeks ago

it's works of mysql, but not pgsql, thanks.