差别

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

--- en:razor:upgrade-instruction-v0-5-to-v0-6 [2015/03/18 14:28]
cobub [Step two: modify script files of database and data warehouse]
+++ en:razor:upgrade-instruction-v0-5-to-v0-6 [2015/09/15 15:29]
cobub v0.7.2
@@ 行 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:
@@ 行 101: / 行 105: @@
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;</code>
+==== 2、Modify the data warehouse ====
+=== 2.1、Add tables ===
+== 1)sum_reserveusers_daily ==
+^property name	^property value	^index^
+|rid	|int(11) NOT NULL AUTO_INCREMENT	|PRIMARY KEY|
+|startdate_sk	|int(11) NOT NULL||	|
+|enddate_sk	|int(11) NOT NULL|	|
+|product_id	|int(11) NOT NULL|	|
+|version_name	|varchar(128) NOT NULL|	|
+|channel_name	|varchar(128) NOT NULL|	|
+|usercount	|int(11) NOT NULL DEFAULT 0|
+|day1	|int(11) NOT NULL DEFAULT 0|	|
+|day2	|int(11) NOT NULL DEFAULT 0|	|
+|day3	|int(11) NOT NULL DEFAULT 0|	|
+|day4	|int(11) NOT NULL DEFAULT 0|	|
+|day5	|int(11) NOT NULL DEFAULT 0|	|
+|day6	|int(11) NOT NULL DEFAULT 0|	|
+|day7	|int(11) NOT NULL DEFAULT 0|	|
+|day8	|int(11) NOT NULL DEFAULT 0|     |
+Unique key：
+UNIQUE KEY `startdate_sk` (`startdate_sk`, `enddate_sk`, `product_id`, `version_name`, `channel_name`)
+sql：
+<code>
+CREATE TABLE `razordw.umsinstall_sum_reserveusers_daily` (
+  `rid` int(11) NOT NULL AUTO_INCREMENT,
+  `startdate_sk` int(11) NOT NULL,
+  `enddate_sk` int(11) NOT NULL,
+  `product_id` int(11) NOT NULL,
+  `version_name` varchar(128) NOT NULL,
+  `channel_name` varchar(128) NOT NULL,
+  `usercount` int(11) NOT NULL DEFAULT 0,
+  `day1` int(11) NOT NULL DEFAULT 0,
+  `day2` int(11) NOT NULL DEFAULT 0,
+  `day3` int(11) NOT NULL DEFAULT 0,
+  `day4` int(11) NOT NULL DEFAULT 0,
+  `day5` int(11) NOT NULL DEFAULT 0,
+  `day6` int(11) NOT NULL DEFAULT 0,
+  `day7` int(11) NOT NULL DEFAULT 0,
+  `day8` int(11) NOT NULL DEFAULT 0,
+  PRIMARY KEY (`rid`),
+  UNIQUE KEY `startdate_sk` (`startdate_sk`,`enddate_sk`,`product_id`,`version_name`,`channel_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+</code>
+=== 2.2、Modify tables ===
+== 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 ====
+Stored procedures: **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** and **runweekly** 。
+Steps:
+)you will get  six sql script files under the directory of **assets\sql** of V0.6 :  **sp_rundaily.sql** 、 **sp_rundim.sql** 、 **sp_runfact.sql** 、 **sp_runmonthly.sql** 、 **sp_runsum.sql**
+and **sp_runweekly.sql**.
+) 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. =====

Cobub文档中心

用户工具

站点工具

差别

页面工具