When you are ready to upgrade Cobub Razor from version 0.4 to version 0.5, following steps is required:

1. Download the code of version 0.5 from https://github.com/cobub/razor/releases , and you can get the razor-0.5.zip, unzip it to get razor-0.5 folder, which contains the sdk and web folders.
2. Copy the web folder to the directory of your web site where you are ready to upgrade Cobub Razor (Note: web can not be the same name with Cobub Razor’s name of V0.4 ). To facilitate debugging, you can rename “web” to “razor_v5“, and set the $ config ['base_url'] value to the ‘http://192.168.1.103/razor_v5 ‘ in config.php which is under the application folder .
3. Copy the autoload.php、database.php and routes.php of V0.4 under the directory of application\config\ to the diretory of application\config\ of V0.5, override these three files of V0.5.

Here, assume that your database is razor and data warehouse is razordw, and umsinstall_ is the table prefix of them.

sql:

create table razor.umsinstall_user2product(id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,user_id int(11) NOT NULL,product_id int(11) NOT NULL);

add: property name: useridentifier,
property value:varchar(256) DEFAULT NULL。

sql ：

Modify the property of `serviceversion`(other columns are similar):

ALTER TABLE `razor.umsinstall_clientdata` CHANGE `serviceversion` `serviceversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;

add:

property name: sessionkey ,

property value: varchar(50) DEFAULT NULL。

sql ：

ALTER TABLE `razor.umsinstall_users` ADD COLUMN `sessionkey ` varchar(50) DEFAULT NULL;

step one：clear the data of table user_permissions in database

sql ：

TRUNCATE TABLE 'razor.umsinstall_user_permissions'; step two: import data of v0.5

Here we provide a SQL script, which is the pre-insert data of user_permissions of V0.5 , click on the user_permissionsv0.5 file behind Step six (Annex 1) ,download it to the local.

Unzip it and change the name of database(razor) to your own database name(v0.4), and the table prefix(umsinstall_ ) to your own database table prefix(v0.4) in SQL script.