The content of this page has been automatically translated by AI. If you encounter any problems while reading, you can view the corresponding content in Chinese.

Rolling back Table

Last updated: 2024-10-15 17:31:26

Overview

This document describes how to roll back specified records in the TcaplusDB Console.

Prerequisites

A table has been created, please see Create Table.

Directions

1. Enter the Table List page, select the required table, and in the Actions column select More > Rollback.
2. In the pop-up dialog box, upload a .txt file containing the field values of the target record. The file format is as follows: For instance, if the user's table definition is as follows, the primary keys are openid, tconndid, timekey.
syntax = "proto2";
package myTcaplusTable;
import "tcaplusservice.optionv1.proto";
message tb_online {
option(tcaplusservice.tcaplus_primary_key) = "openid,tconndid,timekey";
required int32 openid = 1; //QQ Uin
required int32 tconndid = 2;
required string timekey = 3;
required string gamesvrid = 4;
optional int32 logintime = 5 [default = 1];
repeated int64 lockid = 6 [packed = true];
optional pay_info pay = 7;
message pay_info {
optional uint64 total_money = 1;
optional uint64 pay_times = 2;
}
}
If you need to roll back the record with key openid=100, tconndid=1, timekey='123456', you need to prepare a file containing the keys as follows, with the first line being the primary key field names separated by spaces, and from the second line onwards, the primary key values to be rolled back:
openid tconndid timekey
100 1 123456
3. After key.txt has been uploaded, select the rollback time and click [Submit] to proceed.