SkaDate / Oxwall : granting one location to all users via database

Table: ow_googlelocation_data

INSERT IGNORE INTO `ow_googlelocation_data` (`entityId`, `entityType`, `countryCode`, `address`, `lat`, `lng`, `northEastLat`, `northEastLng`, `southWestLat`, `southWestLng`, `json`)

Those are names of columns to be inserted. They duplicate strucutre of ow_googlelocation_data table.

SELECT id ….FROM ow_base_user

Here we are telling to fill in `entityId` with userIDs from ow_base_user table.

SkaDate / Oxwall : granting one role to all users at once via database

Usually you will need to grant one role to all users at once in following 2 cases in SkaDate / Oxwall software:

– You did a profile import.
– Something simply went wrong and you lost user role related data from your database.

To grant one user role to ALL your user at once via datbase you need to: