这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 后一修订版 两侧同时换到之后的修订记录 | ||
en:razor:upgrade-instruction-v0-5-to-v0-6 [2015/03/18 14:33] cobub [2、Modify the 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) ====== | ====== 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: | When you are ready to upgrade Cobub Razor from version 0.5 to version 0.6, following steps is required: | ||
行 107: | 行 111: | ||
== 1)sum_reserveusers_daily == | == 1)sum_reserveusers_daily == | ||
- | === 2.2、Modify tables === | + | ^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 == | == 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 == | == 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 == | == 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 == | == 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 ==== | ==== 3、Modify the stored procedures ==== | ||
- | Stored procedures: rundaily 、 rundim 、 runfact 、 runmonthly 、 runsum and runweekly 。 | + | Stored procedures: **rundaily** 、 **rundim** 、 **runfact** 、 **runmonthly** 、 **runsum** and **runweekly** 。 |
Steps: | Steps: |