1package migration 2 3import ( 4 "database/sql" 5 6 "github.com/pressly/goose" 7) 8 9func init() { 10 goose.AddMigration(Up20200411164603, Down20200411164603) 11} 12 13func Up20200411164603(tx *sql.Tx) error { 14 _, err := tx.Exec(` 15alter table playlist 16 add created_at datetime; 17alter table playlist 18 add updated_at datetime; 19update playlist 20 set created_at = datetime('now'), updated_at = datetime('now'); 21`) 22 return err 23} 24 25func Down20200411164603(tx *sql.Tx) error { 26 return nil 27} 28