From d9570411134273d690e783748dd572696fc14c6f Mon Sep 17 00:00:00 2001 From: Brian Picciano Date: Wed, 12 Oct 2022 23:43:31 +0200 Subject: Make description an optional field --- src/post/sql.go | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'src/post/sql.go') diff --git a/src/post/sql.go b/src/post/sql.go index c768c9a..786ea63 100644 --- a/src/post/sql.go +++ b/src/post/sql.go @@ -52,6 +52,20 @@ var migrations = &migrate.MemoryMigrationSource{Migrations: []*migrate.Migration )`, }, }, + { + Id: "3", + Up: []string{ + `ALTER TABLE post_drafts RENAME description TO description_old`, + `ALTER TABLE post_drafts ADD COLUMN description TEXT`, + `UPDATE post_drafts AS pd SET description=pd.description_old`, + `ALTER TABLE post_drafts DROP COLUMN description_old`, + + `ALTER TABLE posts RENAME description TO description_old`, + `ALTER TABLE posts ADD COLUMN description TEXT`, + `UPDATE posts AS p SET description=p.description_old`, + `ALTER TABLE posts DROP COLUMN description_old`, + }, + }, }} // SQLDB is a sqlite3 database which can be used by storage interfaces within -- cgit v1.2.3