这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 后一修订版 两侧同时换到之后的修订记录 | ||
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 [2015/09/11 14:52] cobub v0.7.1 |
||
---|---|---|---|
行 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}} | ||
+ | v0.7.1 | ||
====== 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: | ||
行 153: | 行 157: | ||
== 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 ==== | ||