News app removal

[alfwro13]

I was wondering what is the procedure for total removal of the app (including any DB tables)
is there a script available anywhere?
Thanks

[Grotax]

Hey, there is no script for that.
The app lives in /apps/news

The main tables of news are:
(my nextcloud db prefix is oc_)

oc_news_feeds
oc_news_folders
oc_news_items

You should be able to simply drop these
DROP TABLE table_name;
Without having tested it, I would start with folders then feeds and last items.
I know we added some restrictions lately I don't know how that will behave.
But I'm sure you can figure that out.

There are also migration versions stored in the oc_migrations
DELETE FROM oc_migrations WHERE app='news'

And configuration data in oc_appconfig
DELETE FROM from oc_appconfig WHERE appid='news';

I think that should be it.
Take note that depending on how many feeds and items you have this might take some time an impact db performance for other users.