UPGRADE.txt in node privacy byrole 5

- WARNING -
-----------

THESE INSTRUCTIONS HAVE NOT BEEN FULLY TESTED SO PLEASE ONLY
DO ON A TEST ENVIRONMENT OR WITH BACKUPS PLEASE REPORT BACK
AT THE PROJECT WITH YOUR RESULTS!

In order to upgrade this from the 4.7 version, you need to
perform the following BEFORE installation.

The reason for this is because the data we need is in the
node_access table, however when this module is enabled it
will rebuild all permissions and wipe that data.

What we need to do first is copy all the relevant lines to a
new table, which is used in this version of the module as the
master copy of the permissions from which node access is build.

To do this, execute the two following MySQL queries:

CREATE TABLE node_privacy_byrole (
nid int(10) unsigned NOT NULL default '0',
gid int(10) unsigned NOT NULL default '0',
realm varchar(255) NOT NULL default '',
grant_view tinyint(3) unsigned NOT NULL default '0',
grant_update tinyint(3) unsigned NOT NULL default '0',
grant_delete tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY  (nid,gid,realm));

INSERT INTO node_privacy_byrole
SELECT * FROM node_access WHERE realm LIKE "node_privacy_byrole_%";

The first one creates the new table, the second one copies
the relevant rows from node_access.

You should now be able to enable the module and use it as normal.