aboutsummaryrefslogtreecommitdiff
path: root/sql/update/json_diff_update.sql
blob: e18b2857f1241a548124071a77872f4410f4f48b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- metadata_audit.sql ---

-- Copyright (C) 2021 Bonface Munyoki K. <me@bonfacemunyoki.com>

-- Author: Bonface Munyoki K. <me@bonfacemunyoki.com>

-- This program is free software; you can redistribute it and/or
-- modify it under the terms of the GNU General Public License
-- as published by the Free Software Foundation; either version 3
-- of the License, or (at your option) any later version.

-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.

-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see <http://www.gnu.org/licenses/>.

-- Update the json_diff_data column to TEXT
ALTER TABLE metadata_audit
MODIFY json_diff_data TEXT NOT NULL;