~~Title:Cobub Razor Upgrade Instruction (v0.7 to v0.7.1) - Mobile Apps Marketing Platform of Open Source - Mobile Analytics & Mobile Push Notification Solutions - Cobub Mobile Developer Center~~
{{description>Cobub Razor is an Open Source Mobile Analytics. When you are ready to upgrade Cobub Razor from version 0.7 to version 0.7.1, following steps is required:.}}
{{keywords>Cobub Razor,open source mobile analytics,mobile analytics,mobile app analytics, upgrade}}

====== Upgrade Instruction (v0.7 to v0.7.1) ======
When you are ready to upgrade Cobub Razor from version 0.7 to version 0.7.1, following steps is required:
===== Step one: download the code of  V0.7.1 =====
1、Download the code of version 0.7.1   from https://github.com/cobub/razor , and you can get the razor-master.zip, unzip it to get razor-master 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 or V0.7 ).  To facilitate debugging, you can rename ”web”  to   “razor_v6“, and  set the $ config ['base_url']  value  to the ‘http://yoururl/razor_v6 ‘  in **config.php** which is under the **application** folder.

3、Copy the **autoload.php** and **database.php**   of V0.7 under the directory of **application\config\** to the diretory of **application\config\** of V0.7.1, override these two files of  V0.7.1, and replace $route['default_controller'] = “install/installation” to $route['default_controller'] = “report/home” of V0.7.1 in **routes.php**.
===== Step two: modify script files of database and data warehouse =====
Here, assume that your database is razor and data warehouse is razordw, and umsinstall_  is the table prefix of them.



==== 1、Modify the stored procedures ====


Stored procedures: **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** and **runweekly** 。

Steps:

1)you will get  six sql script files under the directory of **assets\sql** of V0.7.1 :  **sp_rundaily.sql** 、 **sp_rundim.sql** 、 **sp_runfact.sql** 、 **sp_runmonthly.sql** 、 **sp_runsum.sql**
and **sp_runweekly.sql**.

2) modify table prefix

Modify the **umsinstall_** in all sql scirpt files above to your own data warehouse’s table prefix, for example,your data warehouse table prefix “razordw_”;

Replace the “databaseprefix.umsdatainstall_” to “database.database’s table prefix”, for example, your database is cobubrazor,and database’s table prefix is razor_,the ”databaseprefix.umsdatainstall_” should be “cobubrazor.razor_“.
===== Step three: stop inserting data to database and pause the stored procedures. =====
 


Note: you need to have prepared all the relevant SQL scripts(i.e.  all sql scripts  in Step two).


===== Step four: delete all stored procedures in data warehouse. =====



===== Step five: execute the SQL scripts generated in Step two. =====


Note:  Please backup the data of your database and data warehouse before you execute the sql scripts.


===== Step six:restart the database and data warehouse. =====


Before this step, you need to do the last thing :

Backup the directory of the previous web site(e.g **web**,which is the root directory of version 0.7),store it in a suitable place and named web-backup0.7, then delete **web**.

Change”razor_v7”  to “web”(the name of V0.7),and set $config['base_url']= ‘http://yoururl/web’ in **config.php**.