差别
这里会显示出您选择的修订版和当前版本之间的差别。
|
en:razor:upgrade-instruction-v0-4-to-v0-5 [2015/03/18 11:17] cobub [Step two: modify the script files of database and data warehouse] |
en:razor:upgrade-instruction-v0-4-to-v0-5 [2017/07/14 11:18] |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| - | ====== 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: | ||
| - | ===== Step one: download the code of V0.5 ===== | ||
| - | - Download the code of version 0.5 from https://github.com/cobub/razor/releases , and you can get the razor-0.5.zip, unzip it to get razor-0.5 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 ). To facilitate debugging, you can rename “web” to “razor_v5“, and set the $ config ['base_url'] value to the ‘http://192.168.1.103/razor_v5 ‘ in config.php which is under the application folder . | ||
| - | - Copy the autoload.php、database.php and routes.php of V0.4 under the directory of application\config\ to the diretory of application\config\ of V0.5, override these three files of V0.5. | ||
| - | ===== Step two: modify the script files of database and data warehouse ===== | ||
| - | Here, assume that your database is razor and data warehouse is razordw, and umsinstall_ is the table prefix of them. | ||
| - | ==== 1、Modify database ==== | ||
| - | |||
| - | |||
| - | === 1.1 Add tables === | ||
| - | |||
| - | |||
| - | == 1)user2product == | ||
| - | ^property name ^property value ^index ^ | ||
| - | |id |int(11) NOT NULL AUTO_INCREMENT|primary key| | ||
| - | |user_id |int(11) NOT NULL | | | ||
| - | |product_id |int(11) NOT NULL | | | ||
| - | sql: | ||
| - | <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> | ||
| - | |||
| - | === 1.2 Modify tables === | ||
| - | |||
| - | |||
| - | == 1) clientdata == | ||
| - | |||
| - | ^property name ^property value ^changes ^ | ||
| - | |serviceversion |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |name |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |version |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |platform |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |osversion |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |osaddtional |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |language |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |resolution |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |ismobiledevice |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |devicename |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |deviceid |varchar(200) |NOT NULL-> DEFAULT NULL| | ||
| - | |defaultbrowser |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |javasupport |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |flashversion |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |modulename |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |imei |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |imsi |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |havegps |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |havebt |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |havewifi |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |havegravity |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |wifimac |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |latitude |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |longtitude |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |service_supplier |varchar(64) |NOT NULL-> DEFAULT NULL| | ||
| - | |country |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |region |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |city |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |street |varchar(500) |NOT NULL-> DEFAULT NULL| | ||
| - | |streetno |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
| - | |postcode |varchar(50) |NOT NULL-> DEFAULT NULL| | ||
en/razor/upgrade-instruction-v0-4-to-v0-5.txt · 最后更改: 2017/07/14 11:18 (外部编辑)