差别

这里会显示出您选择的修订版和当前版本之间的差别。

--- en:razor:upgrade-instruction-v0-4-to-v0-5 [2015/03/18 11:17]
cobub [Step two: modify the script files of database and data warehouse]
+++ en:razor:upgrade-instruction-v0-4-to-v0-5 [2017/07/14 11:18] (当前版本)
@@ 行 1: / 行 1: @@
+~~Title:Cobub Razor Upgrade Instruction (v0.4 to v0.5) - 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.4 to version 0.5, following steps is required:.}}
+{{keywords>Cobub Razor,open source mobile analytics,mobile analytics,mobile app analytics, upgrade}}
 ====== Upgrade Instruction (v0.4 to v0.5) ======
 When you are ready to upgrade Cobub Razor from version 0.4 to version 0.5, following steps is required:
 ===== Step  one:  download the code of  V0.5 =====
   - 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.
-  - 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   .
+  - 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://yoururl/razor_v5 ‘  in config.php which is under the application folder   .
   - 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.
 ===== Step two: modify the script files of database and data warehouse =====
@@ 行 20: / 行 24: @@
 |product_id	|int(11) NOT NULL	| |
 sql:
-<code>
+<code 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);</code>
@@ 行 60: / 行 64: @@
 |streetno	|varchar(50)	|NOT NULL-> DEFAULT NULL|
 |postcode	|varchar(50)	|NOT NULL-> DEFAULT NULL|
+add:
+property name: useridentifier,
+property value:varchar(256) DEFAULT NULL。
+sql ：
+Modify the property of `serviceversion`(other columns are similar):
+<code>ALTER TABLE `razor.umsinstall_clientdata` CHANGE `serviceversion` `serviceversion` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;</code>
+== 2)users ==
+add:
+property name: sessionkey ,
+property value: varchar(50) DEFAULT NULL。
+sql ：
+ALTER TABLE `razor.umsinstall_users` ADD COLUMN `sessionkey ` varchar(50) DEFAULT NULL;
+== 3)Change the data of user_permissions ==
+step one：clear the data of table user_permissions in database
+sql ：
+<code>TRUNCATE TABLE 'razor.umsinstall_user_permissions';</code>
+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.
+==== 2、Modify data warehose ====
+=== 2.1 Modify tables ===
+== 1) fact_clientdata ==
+add:
+property name: useridentifier,
+property value: varchar(256) DEFAULT NULL
+sql ：
+<code>ALTER TABLE `razordw.umsinstall_fact_clientdata` ADD COLUMN `useridentifier` varchar(256) DEFAULT NULL;</code>
+=== 2.2 Modify the stored procedures ===
+Stored procedures: **rundim**  and **runfact**.
+Steps：
+)Copy the related sqls of **rundim** and **runfact** stored procedures in **datawarestore.sql** under the directory of **assets\sql** of v0.5, respectively.  Store them and rename **rumdim.sql** and **runfact.sql**.
+)Modify the table prefix  (Cobub Razor ‘s default table prefix is umsinstall_)
+Modify the **umsinstall_**  in **rundim.sql** and **runfact.sql** 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 the stored procedures (rundim and runfact) 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.4),store it in a suitable place and named web-backup0.4, then delete **web**.
+Change”**razor_v5**”  to “**web**”(the name of V0.4),and set $config['base_url']= ‘http://yoururl/web’ in **config.php**.
+Annex 1: user_permissionsv0.5

Cobub文档中心

用户工具

站点工具

差别

页面工具