000000013.go 380 B

1234567891011121314151617
  1. package migrate
  2. import (
  3. "golang-fave/engine/sqlw"
  4. )
  5. func Migrate_000000013(db *sqlw.DB, host string) error {
  6. if _, err := db.Exec(`ALTER TABLE shop_products ADD COLUMN gname VARCHAR(255) NOT NULL DEFAULT '' AFTER price;`); err != nil {
  7. return err
  8. }
  9. if _, err := db.Exec(`ALTER TABLE shop_products ALTER gname DROP DEFAULT;`); err != nil {
  10. return err
  11. }
  12. return nil
  13. }