7
Copyright | C2EU Software Service Manual, Version 1.0.0
"expiryDate" and "parenIdTag" can be empty.
6) Execute update Table name set field name=new value where field name=old value; ##data
update
for example:update tb_auth_info set status='Invalid' where _id=1;
If you want to update more values for a single time (note: please use comma to separate
different values):
for example:update tb_auth_info set parenIdTag='123',status='Invalid' where _id=1;
7) Execute delete from table name where field name=value; ##delete the data
for example:delete from tb_auth_info where _id=1;
other operations:
to show the field name: .header on
Note:
At the end of each command, add a semicolon (command separator).
6.2 Add the card to local whitelist
1) Connect C2EU through Micro USB with laptop. Open ADB tool and execute adb remount
2) Execute adb shell sqlite3 /data/data/com.xcharge.charger/databases/content.db;
3) Execute select count(*) from tb_auth_info; ##get the number of all data in table N
4) Execute insert into tb_auth_info(_id,idTag,status) values(N+1,'card ID','Accepted'); ##insert
the card ID into N+1 line
6.3 Add the card to blacklist
1) Connect C2EU through Micro USB with laptop. Open ADB tool and execute adb remount
2) Execute adb shell sqlite3 /data/data/com.xcharge.charger/databases/content.db;
3) Execute select count(*) from tb_auth_info; ##get the number of all data in table N
4) Execute insert into tb_auth_info(_id,idTag,status) values(N+1,'card ID','Invalid'); ##insert
the card ID into N+1 line
5) Execute update tb_auth_info set status='Invalid' where _id=N+1; ##When die ID exists in
datebank, just use the data update command to set it invalid