Cobub Razor
Cobub Toaster
Other Links
Cobub Razor
Cobub Toaster
Other Links
这是本文档旧的修订版!
When you are ready to upgrade Cobub Razor from version 0.4 to version 0.5, following steps is required:
Here, assume that your database is razor and data warehouse is razordw, and umsinstall_ is the table prefix of them.
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:
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);
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 |