Project

General

Profile

« Previous | Next » 

Revision 3123

Added by Jing Tao almost 18 years ago

Add a script to delete documents manually.

View differences:

src/delete-xml-documents.sql
1
DELETE FROM xml_index WHERE docid ='tao.12043';
2
DELETE FROM xml_access WHERE accessfileid ='tao.12043';
3
DELETE FROM xml_access WHERE docid ='tao.12043';
4
DELETE FROM xml_queryresult WHERE docid ='tao.12043';
5
DELETE FROM xml_relation WHERE docid ='tao.12043';
6
DELETE FROM xml_path_index WHERE docid ='tao.12043';
7
DELETE FROM xml_accesssubtree WHERE docid = 'tao.12043';
8
DELETE FROM xml_documents WHERE docid ='tao.12043';
9
DELETE FROM xml_nodes where docid ='tao.12043';
10

  
11
DELETE FROM xml_index WHERE docid ='tao.12045';
12
DELETE FROM xml_access WHERE accessfileid ='tao.12045';
13
DELETE FROM xml_access WHERE docid ='tao.12045';
14
DELETE FROM xml_queryresult WHERE docid ='tao.12045';
15
DELETE FROM xml_relation WHERE docid ='tao.12045';
16
DELETE FROM xml_path_index WHERE docid ='tao.12045';
17
DELETE FROM xml_accesssubtree WHERE docid = 'tao.12045';
18
DELETE FROM xml_documents WHERE docid ='tao.12045';
19
DELETE FROM xml_nodes where docid ='tao.12045';
0 20

  

Also available in: Unified diff