Specifically, rollback restores rows which have been modified since time to their condition prior to time (? column = `c'); deletes rows that added since time (? column = `a'); and puts back rows which existed prior to and deleted since time. The audit table is also ``rolled back''.

Prior to modifying table and table-a, rollback makes backup copies named table.bak and table-a.bak.

-fc

use c as the column separation character, instead of the default TAB.

time

specify the restoration point of table in YYMMDDhhmmss format (ie., 940915163455 is September 15, 1994 4:35.55 PM). time is compared with the timestamp column in each row of table-a, to determine whether the row should be restored, deleted or added to the resulting table. Although the timestamp column measures transactions down to the second, it is not necessary to specify the time argument to this degree of precision.

\s-2$ cat inventory
Item    Amount  Value   Description
----    ------  -----   -----------
1       4       1500    rubber duckies
3       5       400     clamps
4       23      437     plates
5       99      2376    cleaning cloth
6       89      13083   bunsen burners
7       5       875     scales
$ cat inventory-a
YYMMDDhhmmss  user  ?  Item  Amount  Value   Description
------------  ----  -  ----  ------  -----   -----------
940914160355  barb  c  1     4       150     rubber gloves
940915113340  barb  a
940915113400  barb  d  2     100     500     test tubes

$ rollback inventory 940915
$ cat inventory
Item    Amount  Value   Description
----    ------  -----   -----------
1       4       1500    rubber duckies
2       100     500     test tubes
3       5       400     clamps
4       23      437     plates
5       99      2376    cleaning cloth
6       89      13083   bunsen burners
$ cat inventory-a
YYMMDDhhmmss  user  ?  Item  Amount  Value   Description
------------  ----  -  ----  ------  -----   -----------
940914160355  barb  c  1     4       150     rubber gloves

$ rollback inventory
$ cat inventory
Item    Amount  Value   Description
----    ------  -----   -----------
1       4       150     rubber gloves
2       100     500     test tubes
3       5       400     clamps
4       23      437     plates
5       99      2376    cleaning cloth
6       89      13083   bunsen burners
$ cat inventory-a
YYMMDDhhmmss  user  ?  Item  Amount  Value   Description
------------  ----  -  ----  ------  -----   -----------\s0