Eric Bower
·
18 Aug 22
20220811_add_data_to_post.sql
1ALTER TABLE posts ADD COLUMN shasum char(64) NOT NULL DEFAULT '';
2ALTER TABLE posts ADD COLUMN mime_type character varying(250) NOT NULL DEFAULT '';
3ALTER TABLE posts ADD COLUMN file_size int NOT NULL DEFAULT 0;
4ALTER TABLE posts ADD COLUMN data jsonb NOT NULL DEFAULT '{}'::jsonb;