mysql> select XWD_ID, XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_WEB, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR from xwikidoc where XWD_ID=1868545427; +------------+--------------------------------------------------------------------+---------------------------------------------------------------+---------------------------------------------------------------+---------+---------------------+-------------------------+---------------------+------------------+--------------------+------------------+ | XWD_ID | XWD_FULLNAME | XWD_NAME | XWD_TITLE | XWD_WEB | XWD_DATE | XWD_CONTENT_UPDATE_DATE | XWD_CREATION_DATE | XWD_AUTHOR | XWD_CONTENT_AUTHOR | XWD_CREATOR | +------------+--------------------------------------------------------------------+---------------------------------------------------------------+---------------------------------------------------------------+---------+---------------------+-------------------------+---------------------+------------------+--------------------+------------------+ | 1868545427 | Blog./site+under+construction%2C+but+please+register+your+accounts | /site+under+construction%2C+but+please+register+your+accounts | site under construction, but please register your accounts... | Blog | 2009-02-07 06:20:33 | 2009-02-07 06:20:33 | 2009-01-15 17:57:30 | XWiki.NielsMayer | XWiki.NielsMayer | XWiki.NielsMayer | +------------+--------------------------------------------------------------------+---------------------------------------------------------------+---------------------------------------------------------------+---------+---------------------+-------------------------+---------------------+------------------+--------------------+------------------+ 1 row in set (0.00 sec) mysql> select XWR_DOCID,XWR_DATE,XWR_AUTHOR,XWR_VERSION1,XWR_VERSION2 from xwikircs where XWR_DOCID='1868545427'; +------------+---------------------+------------------+--------------+--------------+ | XWR_DOCID | XWR_DATE | XWR_AUTHOR | XWR_VERSION1 | XWR_VERSION2 | +------------+---------------------+------------------+--------------+--------------+ | 1868545427 | 2009-01-15 17:57:53 | XWiki.NielsMayer | 1 | 1 | | 1868545427 | 2009-02-07 06:20:33 | XWiki.NielsMayer | 2 | 1 | +------------+---------------------+------------------+--------------+--------------+ 2 rows in set (0.00 sec) mysql> delete from xwikircs where XWR_DOCID='1868545427'; Query OK, 2 rows affected (0.00 sec) mysql> delete from xwikidoc where XWD_ID=1868545427; Query OK, 1 row affected (0.00 sec) ============================================================================== mysql> update xwikidoc set XWD_FULLNAME='Blog.Finally got OfficeImporter Working' where XWD_ID=630207584; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update xwikidoc set XWD_NAME='Finally got OfficeImporter Working' where XWD_ID=630207584; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select XWR_DOCID,XWR_DATE,XWR_AUTHOR,XWR_VERSION1,XWR_VERSION2 from xwikircs where XWR_DOCID='630207584'; +-----------+---------------------+------------------+--------------+--------------+ | XWR_DOCID | XWR_DATE | XWR_AUTHOR | XWR_VERSION1 | XWR_VERSION2 | +-----------+---------------------+------------------+--------------+--------------+ | 630207584 | 2009-01-21 12:44:22 | XWiki.NielsMayer | 1 | 1 | | 630207584 | 2009-01-21 12:44:42 | XWiki.NielsMayer | 2 | 1 | | 630207584 | 2009-01-21 12:46:02 | XWiki.NielsMayer | 3 | 1 | | 630207584 | 2009-02-07 06:20:03 | XWiki.NielsMayer | 4 | 1 | +-----------+---------------------+------------------+--------------+--------------+ 4 rows in set (0.00 sec) ============================================================================== mysql> select XDD_ID,XDD_FULLNAME,XDD_FULLNAME,XDD_DELETER from xwikirecyclebin; +--------+-----------------------------------------------------------------+-----------------------------------------------------------------+-------------+ | XDD_ID | XDD_FULLNAME | XDD_FULLNAME | XDD_DELETER | +--------+-----------------------------------------------------------------+-----------------------------------------------------------------+-------------+ | 1 | XWiki.BazfropMcRotfl | XWiki.BazfropMcRotfl | XWiki.Admin | | 2 | XWiki.foobar | XWiki.foobar | XWiki.Admin | | 3 | XWiki.NewUser | XWiki.NewUser | XWiki.Admin | | 15 | Main.site under construction, but please register your accounts | Main.site under construction, but please register your accounts | XWiki.Admin | +--------+-----------------------------------------------------------------+-----------------------------------------------------------------+-------------+ 4 rows in set (0.00 sec) mysql> delete from xwikirecyclebin where XDD_ID=15; Query OK, 1 row affected (0.00 sec)