Skip to content
This repository has been archived by the owner on Jun 2, 2024. It is now read-only.

export/import table comment #26

Open
LeoOnTheEarth opened this issue Apr 17, 2015 · 3 comments
Open

export/import table comment #26

LeoOnTheEarth opened this issue Apr 17, 2015 · 3 comments

Comments

@LeoOnTheEarth
Copy link
Contributor

It is good to have this feature

@asika32764
Copy link
Owner

table 有 comment 喔?

那你幫我看一下現在的 yaml 格式裡面哪邊有空間可以放

@LeoOnTheEarth
Copy link
Contributor Author

table 有 comment 喔?

MySQL 有
但我不確定其他的關聯資料庫有沒有

'#__table_name':
    name: '#__table_name'
    comment: 'This is table comment'
    from:
        - '#__table_name'
    columns:
        id: { Field: id, Type: int(11), 'Null': NO, Default: null, Extra: auto_increment, Comment: The id, From: [id] }
        foo: { Field: foo, Type: varchar(64), 'Null': YES, Default: null, Extra: '', Comment: 'Foo', From: [foo] }
    index:
        - { Table: '#__table_name, Non_unique: '0', Key_name: PRIMARY, Seq_in_index: '1', Column_name: id, Sub_part: null, 'Null': '', Comment: '', Index_comment: '' }

@LeoOnTheEarth
Copy link
Contributor Author

https://github.com/asika32764/JConsole/blob/staging/src/Sqlsync/Query/MysqlQueryBuilder.php#L160

Table Comment 在這個方法可以取得,欄位名稱是 Comment

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants