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