Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

撰寫升級程式，擴充ext欄位長度 #38

Open
scribetw opened this issue Mar 2, 2015 · 1 comment
Open

撰寫升級程式，擴充ext欄位長度 #38

scribetw opened this issue Mar 2, 2015 · 1 comment
Labels
enhancement
Milestone
9th.Release

Comments

@scribetw
Copy link
Member

scribetw commented Mar 2, 2015

因 #36
SQL的ext欄位長度要改成5

ALTER TABLE imglog MODIFY ext varchar(5);

因目前資料庫有PostgreSQL, SQLite, MySQL，上述語法不見得通用。
@scribetw scribetw added this to the 9th.Release milestone Mar 2, 2015
@Kennyl
Copy link
Contributor

Kennyl commented Mar 3, 2015

簡單一些，開一個imglog2 的table 再select insert吧。
或者寫三種alter ，不通用的其餘兩條照運行，也不會對DB有影響。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
9th.Release
Development

No branches or pull requests
2 participants
@Kennyl @scribetw