这里会显示出您选择的修订版和当前版本之间的差别。
两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 后一修订版 两侧同时换到之后的修订记录 | ||
en:razor:upgrade-instruction-v0-4-to-v0-5 [2015/03/18 11:27] cobub [1、Modify database] |
en:razor:upgrade-instruction-v0-4-to-v0-5 [2015/09/15 15:29] cobub v0.7.2 |
||
---|---|---|---|
行 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) ====== | ====== 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: | When you are ready to upgrade Cobub Razor from version 0.4 to version 0.5, following steps is required: | ||
行 20: | 行 24: | ||
|product_id |int(11) NOT NULL | | | |product_id |int(11) NOT NULL | | | ||
sql: | 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> | 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> | ||
行 97: | 行 101: | ||
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. | 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: | ||
+ | |||
+ | 1)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**. | ||
+ | |||
+ | 2)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. ===== | ===== Step three: stop inserting data to database and pause the stored procedures. ===== | ||