Guard "public" in the database (using trigger)

[WcaleNieWolny]

Currently we use a very bizzare way to ensure that there is only 1 channel that is public. Instead I propose to create a proper trigger that would ensure all of the "public" channel rules

[riderx]

Let's move this setting to the app level, not channel