差别

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

--- en:razor:upgrade-instruction-v0-5-to-v0-6 [2015/03/18 14:38]
cobub [2、Modify the data warehouse]
+++ en:razor:upgrade-instruction-v0-5-to-v0-6 [2017/07/14 11:18] (当前版本)
@@ 行 1: / 行 1: @@
+~~Title:Cobub Razor Upgrade Instruction (v0.5 to v0.6) - 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.5 to version 0.6, following steps is required:.}}
+{{keywords>Cobub Razor,open source mobile analytics,mobile analytics,mobile app analytics, upgrade}}
 ====== Upgrade Instruction (v0.5 to v0.6) ======
 When you are ready to upgrade Cobub Razor from version 0.5 to version 0.6, following steps is required:
@@ 行 4: / 行 8: @@
 、Download the code of version 0.6   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.
-、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.5 ).  To facilitate debugging, you can rename ”web”  to   “razor_v6“, and  set the $ config ['base_url']  value  to the ‘http://192.168.1.103/razor_v6 ‘  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 or V0.5 ).  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.
 、Copy the **autoload.php** and **database.php**   of V0.5 under the directory of **application\config\** to the diretory of **application\config\** of V0.6, override these two files of  V0.6, and replace $route['default_controller'] = “install/installation” to $route['default_controller'] = “report/home” of V0.6 in **routes.php**.
@@ 行 153: / 行 157: @@
 == 1) fact_event ==
+^property name	^property value	^changes^
+|deviceid	|varchar(50)	|NOT NULL -> DEFAULT NULL|
+|category	|varchar(50)	|NOT NULL -> DEFAULT NULL|
+|label	|varchar(50)	|NOT NULL -> DEFAULT NULL|
+|attachment	|varchar(50)	|NOT NULL -> DEFAULT NULL|
+sql:
+<code>
+ALTER TABLE `razordw.umsinstall_fact_event` CHANGE `deviceid` `deviceid` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;
+</code>
+Note: Other columns are similar.
 == 2)log ==
+^property name	^property value	^changes^
+|op_date	|datetime	|NOT NULL -> DEFAULT NULL|
+|affected_rows	|int(11)	|NOT NULL -> DEFAULT NULL|
+|duration	|int(11)	|NOT NULL -> DEFAULT NULL|
+sql:
+<code>
+ALTER TABLE `razordw.umsinstall_log` CHANGE `op_date` `op_date` datetime  DEFAULT NULL;
+</code>
+Note: Other columns are similar.
+add:
+property name:op_starttime
+property value:datetime DEFAULT NULL
+sql:
+<code>
+ALTER TABLE `razordw.umsinstall_log` ADD COLUMN `op_starttime` datetime DEFAULT NULL;
+</code>
 == 3)fact_reserveusers_monthly ==
+Rename ‘**fact_reserveusers_monthly**’ to ‘**sum_reserveusers_monthly**`;
+sql:
+<code>
+RENAME TABLE `razordw.umsinstall_fact_reserveusers_monthly` TO `razordw.umsinstall_sum_reserveusers_monthly`;
+</code>
+add:
+property name:channel_name
+property value:varchar(128) NOT NULL
+sql：
+<code>ALTER TABLE `razordw.umsinstall_sum_reserveusers_monthly` ADD COLUMN `channel_name` varchar(128) NOT NULL;</code>
+modify unique key:
+change  UNIQUE KEY `startdate_sk` (`startdate_sk`,`enddate_sk`,`product_id`,`version_name`)
+to UNIQUE KEY `startdate_sk` (`startdate_sk`,`enddate_sk`,`product_id`,`version_name`,`channel_name`).
+sql：
+<code>ALTER TABLE `razordw.umsinstall_sum_reserveusers_monthly` ADD UNIQUE( `startdate_sk`, `enddate_sk`, `product_id`, `version_name`, `channel_name`);</code>
 == 4)fact_reserveusers_weekly ==
+Rename ‘**fact_reserveusers_weekly**’ to ‘**sum_reserveusers_weekly**’.
+sql：
+<code>RENAME TABLE `razordw.umsinstall_fact_reserveusers_weekly` TO `razordw.umsinstall_sum_reserveusers_weekly`;</code>
+add:
+property name:channel_name
+property value:varchar(128) NOT NULL
+sql：
+<code>ALTER TABLE `razordw.umsinstall_sum_reserveusers_weekly` ADD COLUMN `channel_name` varchar(128) NOT NULL;
+</code>
+change  UNIQUE KEY `startdate_sk` (`startdate_sk`,`enddate_sk`,`product_id`,`version_name`)
+to UNIQUE KEY `startdate_sk` (`startdate_sk`,`enddate_sk`,`product_id`,`version_name`,`channel_name`).
+sql：
+<code>ALTER TABLE `razordw.umsinstall_sum_reserveusers_weekly` ADD UNIQUE( `startdate_sk`, `enddate_sk`, `product_id`, `version_name`, `channel_name`);</code>
 ==== 3、Modify the stored procedures ====
@@ 行 197: / 行 273: @@
 Backup the directory of the previous web site(e.g **web**,which is the root directory of version 0.5),store it in a suitable place and named web-backup0.5, then delete **web**.
-Change”razor_v6”  to “web”(the name of V0.5),and set $config['base_url']= ‘http://192.168.1.103/web’ in **config.php**.
+Change”razor_v6”  to “web”(the name of V0.5),and set $config['base_url']= ‘http://yoururl/web’ in **config.php**.

Cobub文档中心

用户工具

站点工具

差别

页面工具